and string functions.
-Original Message-
From: Peter Lauri [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 21, 2006 4:43 PM
To: [EMAIL PROTECTED]; Song Ken Vern-E11804
Cc: mysql@lists.mysql.com
Subject: RE: if else statement
SELECT IF(col1=3, (Select col2 from table2 where table2.id = 1
Hi,
I'm trying to build a query in using SQL instead of doing it in Perl.
I am trying to do something like this :
If ((select col1 from table1 where id = 1) == 3)
Then
Select col2 from table2 where table2.id = 1;
Else
Select col2 from table3 where table3.id = 1;
In Perl I would probably do
Hi,
I am using mysqlcc 0.9.4-beta to browse my DB.
Server side am using 5.0.18-nt.
However, when I try to double click on a table to see the data, it will
always
return the error.
[localhost] ERROR 1146: Table 'test.1' doesn't exist
The SQL query for this is
SELECT * FROM `test`
The query is
Hi,
I have one table which grows at a much faster rate than the rest.
It has 80 times more entries than the second largest table, which has
10k rows.
What are the steps I can take to slow down the growth?
Can I partition the table?
Will the size of the table affect the perfomance of queries?
I
Hi,
I am using the cygwin version of the mysql client.
When trying to read back my dump file into the database, I get this error
[EMAIL PROTECTED]:/cygdrive/c/Program Files/mysql/data
23:15$ ../bin/mysql.exe -h 10.224.3.3 -u root -p testdb -e ./zztest.sql
Enter password:
ERROR