Neculai, thanks. That answers my question.
cheers, feng ----- Original Message ----- From: "Neculai Macarie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 8:01 PM Subject: Re: newbie Q: create a table in a database > > >c:\mysql\bin\mysql --------line 1 > > mysql>create database DB1 --------line 2 > mysql>use DB1; > > mysql>create table TB1(id char(3)); -------line 5 > > <mack /> > > > ----- 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
