Re: Error Creating a Table
Posted by:
kbshook
Date: July 22, 2005 08:05PM
Andrew I want to "Thank You" for all of your assistance in this problem. You were a tremendous help to me. If anyone else is having this problem, here is the solution. I know it was probably a simple solution to many SQL users, but if you have not used SQL for several years like me, it was not so simple.
Thanks Again Andrew, if I can assist you with anything let me know.
Sincerely, kbshook
Andrew Gilfrin wrote:
> The first thing you need to do in MySQL is create
> a database to store your tables. Once the data
> base has been created you then need to use the
> "use" command to attach to that database.
>
> So to create the database use the following code.
>
>
> mysql> create database newdb;
> Query OK, 1 row affected (0.17 sec)
>
> Change newdb to the name you want your database to
> have. Then attach to that database as follows.
>
> mysql> use newdb;
> Database changed
>
> You can now use the create table syntax. If you
> exit the mysql client the next time you use it you
> will need to issue the "use" command again.
>
Subject
Written By
Posted
Re: Error Creating a Table
July 22, 2005 08:05PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.