is text and number so you I can't autoincrement a
username like abc003434 ...
- Original Message -
From: Mohammad Shoja [EMAIL PROTECTED]
To: anna soobrattee [EMAIL PROTECTED]
Sent: Wednesday, June 13, 2001 11:57 AM
Subject: Re: table locking and priorities
Hi Anna,
Why you
Thank you all for your suggestions,
I'm using tcsh so I resolve this problem like this:
mysql -u root dbname test.sql ! log
and its working on command line but the problem is, it doesnt work when I
put mentioned statement into a bach file.
for example I create a file (createtables) and its
Thank you for all your suggestions,
I got it.
the problem was in our web server because of security $ENV{HOME} doesnt
point to my home directory so my .my.cnf file was unreachable.
That's it.
may be It can be helpful for other people as well.
my %attr = (
PrintError =0,
Hello everybody.
would you please tell me how can I log execution of a DDL?
I have a test.sql which is a DDL file, I wanna log its output but when I
try the following it create log file but its empty.
mysql -u root databasename test.sql log
it Just send errors and logs to STDERR.
Thanks you for
I am stuck on a select query and was wondering if someone could help. I
have I've written a database app. that helps me run my business
(trucking). I need however to write a query that shows me all of the
loads that are delivered but not billed (invoiced). Which means that I
have to
Mybe this is not a mysql question but a unix command line question:
would you please tell me how can I log execution of a DDL?
I have a test.sql which is a DDL file, I wanna log its output but when I
try the following it create log file but its empty.
mysql -u root databasename test.sql log
it
Thanks for your reply
The question is why in command line there is no problem?
It is looking for /tmp/mysql.sock and the one that exists is
/tmp/mysql.sock.shoja
Two different files.. It can't find what it is looking for. Try:
safe_mysqld --socket=/tmp/mysql.sock
and it should work