MySQL Database Forum

I'm not finding what the maximum number of characters that a statement can be. Anyone know where I can find that spec?

Hello I have a problem with mysql. Using the tables of type INNODB, mysql it has created the archives (ibdata1) whose dimensions exceed the 3G. I have cancelled all the database but the occupied space is remained the same one. How I can make in order to compattare this space? Thanks

Hi, I haven’t select data from any table in mysql database. While I selected the data I got ERROR 1033 (HY000): Incorrect information in file error. I have not changed any configuration in mysql database. How can I resolve it? Thanks, Michael

I'm currently working on a component tracking file and we are using an hour meter query to always have up to date information. My problem is that I need the hour meter query to display the reading of the most recent date for each equipment number. My columns are: EQUIP_NO DATE_READING CONDITION LIFE_TO_DATE I want a single SQL query...

------=_NextPart_000_003E_01C34934.FBC032B0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Hello, I'm looking for a solution to write a sql query that inserts a set of = data if the data id is not present and otherwise update the set.

Query a list of CITY names from STATION with even ID numbers only. You may print the results in any order, but must exclude duplicates from your answer. This Was My Solutino.... SELECT CITY FROM STATION WHERE MOD(ID,2) = 0; BUT ITS NOT WORKING

Helo, I have problem in finding right tutorial how to create multi key in DB. I have 4 tables. in each I have TIME datatime Nr int I want them as a MUL key, could You help me in creating the right code to create such a tables.The code has a bug in sql syntax, can You see CREATE TABLE table1 ( value int(11) NOT NULL default '0',

Hey all I have a column of user membership ids that is 8 characters long. These ids are based on the users surname with number added on the end to uniquely identify each user. My problem is that if the users surname is short, there are spaces between the end of the surname and the numbers. There are 18000 or so members in the database...

The following code works fine select concat( case t1.testColumn when 'value1' then t1.column1 when 'value2' then t1.column2 when 'value3' then t1.column3 else t1.column4 end

Hi, I want to start the mysql services by manually in the dos on windows...... Starting an Mysql Service : shell>net start mysql The service name is invalid.

Hello Everyone, I have been searching around for an answer to this question with no luck. I hope that some of you may have a couple of good ideas I could try. I am running MySQL 4.1.20. In one of my databases, I have two tables: patients, visits.

I'm been looking for a way around this. There doesn't seem to be, but I'm hoping someone here knows. It seems to have to add a user to the mysql.users table for each HOST they want to connect from. Well, we have a few users (admins) who access the company DB from home and they have dynamic IP addresses (dialup or DSL.) Is there any way to...

I have discovered a new thing as a solution for MySql error 10061 (error 2003) where if port 3306 is busy then service cannot run message comes The solution I found is go to mysql/bin type mysqld port 3305(or any port which is vacant) and then mysql runs I need any expert to verify it and authenticate it

Hi All, I've been racking my brain trying to figure out some sort of Sub-Select mySQL statement that will create a result with multiple rows of averaged values over a years time. What I have is weather data. There is a new record every 5 minutes, every day. So. What I want to do with one SQL statement is figure out the Average of...

in oracle so how can i do this in mysql?

Hi guys, i would like to make create temporary table pagamentos SELECT d.name, SUM(advanced) AS total_advance, f.salario FROM data d JOIN empregados f ON f.name = d.name where MONTH(d.date) = 04 group by name; and after select all select * from pagamentos; in a php script... could someone help me???

I picked up the following code to take a mysql table to an excel file. What do I need to do to it to make the first excel row be the column names, rather than the first record? $query = "SELECT * FROM mytable"; $result = mysql_query($query) or die('Error, query failed'); $tsv = array(); while($row = mysql_fetch_array($result,...

Hi, Suppose I have a table "product" with fields id,name,price. I want to get a resultset of previous and current and next record when the resultset is sorted by id and id=10. The table data is shown in the following: id Name Price 1 : : 5 : :<--------------previous record

Please help. I have a website running on a linux/apache/mysql/php server. I receive about 8,000-10,000 visitors a day with about 200,000 to 300,000 page views. The server is a RedHat Linux server running PHP 5.x, MySQL 5.x, Apache 2.x We have been suffering from a number of performance issues. Our hosting company has set our max...

Damn it this "illegal mix of collashit" messages are driving me nuts!! What's wrong with the following statement? SELECT userid, CONCAT(username,' / ',firstname,' ',lastname,' / ', email, IF(activated=1,'',' (NOT YET ACTIVATED)')) AS uname FROM tbuser I get: MySQL Error Occured

Hi, Can anyone confirm whether it is possible to: a) use subqueries in mySQL b) use DISTINCT TOP in mySQL? I am trying to find a way to return the top 5 results in my table. For simplicity sake: user I hits I date

Hi guys, I have a databae in MYSQL, ver 5.1, I am supposed to fire a trigger when a row in table reaches certain value. The trigger is supposed to send an email to all the users in database. can u guys help me out in this issue.

Hi, I have an application as follows: MySQL database Back-Eend linked to MS Access Front-End and ASP Web Application. I require users to enter Serial Numbers such as: 0105123567 (10 digits), the first 4 being the month and year (mmyy)

Could someone help me find the cnf file so i can turn on the bin log? I can't locate a my.cnf anywhere, but i can find /usr/share/mysql/my-huge.cnf /usr/share/mysql/my-large.cnf /usr/share/mysql/my-medium.cnf /usr/share/mysql/my-small.cnf ,and I don't know which of those is being read on startup. I tried looking at the...

how to select first row from database of mysql