[snip]
If I do something like:
select * from foo where bar=123;;
I get the result of the select followed by:
ERROR:
No query specified
This is because I have ';;' at the end of the line and it is complaining
about the empty command.
OK, I should not have typed it, but I do not think that it should be an
error.
[/snip]
The reason it is not an error is that you can do multiple queries from the
command line in MySQL. This allows you to do some fairly complex things --
DROP TABLE IF EXISTS tblCDRList;
CREATE TABLE tblCDRList (
id int(11) NOT NULL auto_increment,
cdrFileName varchar(64) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
INSERT INTO tblCDRList VALUES (1, 'network_intell_01_2002060704');
INSERT INTO tblCDRList VALUES (2, 'network_intell_01_2002062504');
INSERT INTO tblCDRList VALUES (3, 'network_intell_01_2002062604');
INSERT INTO tblCDRList VALUES (4, 'network_intell_01_2002062704');
INSERT INTO tblCDRList VALUES (5, 'network_intell_01_2002062804');
INSERT INTO tblCDRList VALUES (6, 'network_intell_01_2002062904');
INSERT INTO tblCDRList VALUES (7, 'network_intell_01_2002063004');
INSERT INTO tblCDRList VALUES (8, 'network_intell_01_2002070104');
HTH!
Jay
sql, mysql, query
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
