MySQL Forums
Forum List  »  Newbie

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.
>

Options: ReplyQuote


Subject
Written By
Posted
July 20, 2005 06:32PM
July 21, 2005 06:29PM
July 21, 2005 06:36PM
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.