commandPrompt> USE DataBaseName;
Thanks Emery ----- Original Message ----- From: "Wang Feng" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 10:55 Subject: newbie Q: create a table in a database > Hi, folks. > > I use Windows XP Pro, MySQL v.1.4 > > The following is how I access to MySQL and create a database and a table in > that database: > > >c:\mysql\bin\mysql --------line 1 > mysql>create database DB1 --------line 2 > mysql>quit --------line 3 > >c:\mysql\bin\mysql DB1 --------line 4 > mysql>create table TB1(id char(3)); -------line 5 > > It works fine. But I'm not happy with that since everytime I have to quit > the MySQL after creating a database (e.g. line 3) and then login again using > the command 'mysql database_name' to access that database (e.g. line 4) and > then create the tables in the database, Otherwise, I'll get the message: "No > Database Selected". So, I'm wondering what commands I should use to create > the tables in a database without having to exit just like what I did above? > > Thanks for your time. > > > > cheers, > > feng > > > > -- > 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]