schema and Catalog under MySQL 3.23.55

[Morten Gulbrandsen]

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>my sql -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