Hi I am a new user of Mysql and have received an error. I enter my C drive using the MS-DOS prompt. I then access the mysql\bin directory. I then type "mysql". which welcomes me to Mysql Monitor. I then try to create a database called "database01" by typing "mysqladmin create database01\g" but i get the following error:- Error 1064:You have an error in your SQL syntax near 'mysqladmin create database01' at line 1.
I would be very grateful if you could get back to me about this as i am using it for a college project.
mysqladmin is not a command that you enter at the mysql> prompt from within the mysql program. It's a separate program that you invoke from the DOS prompt.
You can either create the database from within mysql like this:
mysql> CREATE DATABASE database01;
or from the command line using mysqladmin like this:
C:\> mysqladmin create database01
Thanks Patrick Geary
-- Paul DuBois http://www.kitebird.com/ sql, 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
