Schemas and user defined partitions are not utilized in MySQL as they are in
Oracle. If you are attempting to design your architecture according to
schemas you could visualize each database as an user defined schema.
CREATE DATABASE company_00;
-Original Message-
From: Morten Gulbrandsen [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 8:38 AM
To: [EMAIL PROTECTED]
Subject: schema and Catalog under MySQL 3.23.55
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\binmysql -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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
