File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes My SQl prob Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "My SQl prob" Watch "My SQl prob" New topic

My SQl prob

sachin pachpute
Ranch Hand

Joined: Nov 04, 2004
Posts: 38
When i try to create a new database in mysql using the mysqladmin and encounter the following error
the command typed by me is
mysql>mysqladmin create petstore;

ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysqladmin create petstore' at line 1or
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

You sure it shouldn't be:


(BTW: this is a mysql question - not an advanced Java question.)

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Ilja Preuss

Joined: Jul 11, 2001
Posts: 14112
SQL questions are probably best answered in the JDBC forum. Moving...

The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
I agree. Here's the link:
subject: My SQl prob
jQuery in Action, 3rd edition