* FROM inventory WHERE 1=0;";
$create_tmp = mysql_query($sql) or $err=("temp table not created");
Any ideas why this might be happening?
Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY 11225
(718)623-7265
[EMAIL PROT
Thanks, Fred.
It works perfectly.
At 01:00 PM 2/11/2003 +0100, Fred van Engen wrote:
>Hello Anya,
>
>On Tue, Feb 11, 2003 at 07:51:00PM +0800, Anya wrote:
>>
>>
>> Dear all,
>> I have a table Kids which has the following fields:
>>
>> kid c
x27;, 'pear', 'orange'
Or I have to do one by one such as:
select count(*) from Kids where favourite_fruits like '%apple%'
and loop against the items in the set?
Any help will be appreciated!
Thanks!
Anya
http:www.acmescripts.com
--
the error message "Access denied for user 'root@localhost' (using
password =YES)"
I have tried to restart mysql with the --skip-grant-tables option but I
still can't get in as root?
How do I fix this? Can anyone help?
Anya Miretsky
Computer Technology Dept.
Brooklyn Botani
the error message "Access denied for user 'root@localhost' (using
password =YES)"
I have tried to restart mysql with the --skip-grant-tables option but I
still can't get in as root?
How do I fix this? Can anyone help?
Anya Miretsky
Computer Technology Dept.
Brooklyn Botani
How do I restore a Mysqldump of a database? I've found documentation on how
to backup a db and have done but I can't figure out how to create a new db
from my dump file? Please help.
thanks
Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Br
what I am doing wrong? This is my first time using Mysql,
so if this isn't the right list to post on, please tell me where I can post
beginner mysql questions.
Thanks for your help in advance.
Anya Miretsky
Computer Technology Dept.
Brooklyn Botanic Garden
1000 Washington Avenue
Brooklyn, NY
