By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

schema and Catalog under MySQL 3.23.55

P: n/a
Hi programmers,

I try to investigate some of the basics behind schemas and cataloges,
Which is part of SQL2 Language

this is the error message I get:


C:\mysql\bin>mysql -u administrator -h localhost -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 246 to server version: 3.23.55-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create schema company_00 authorization administrator;
ERROR 1064: You have an error in your SQL syntax near 'schema company_00
author
ization administrator' at line 1
mysql> use company;
Database changed
mysql> create schema company_00 authorization administrator;
ERROR 1064: You have an error in your SQL syntax near 'schema company_00
author
ization administrator' at line 1
mysql> create schema company_00 authorization administrator;
===

it seems to me that the sql statements schema and catalog is not working
in my version of mysql.
What can be done in order to remedy this ?

Yours Sincerely

Morten Gulbrandsen


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.