Hi Joao, I will check on it...thanks
I know if I send it directly to you; it will be returned to me while the cc: goes to the [EMAIL PROTECTED] successfully. >From now on I will just email it to [EMAIL PROTECTED] I wonder if [EMAIL PROTECTED] has made arrangements to send a personal copy to you and one to the mailing list. I am asking this question because I keep getting replies from different users with empty cc: to the mailing list. How can it be done? Or how do they do it? Hope you or others will able to explain this to me. ----- Original Message ----- From: "Joao Batista (JB-Informática, Lda)" <[EMAIL PROTECTED]> To: "'alan4100'" <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 5:41 PM Subject: RE: Adding Columns to table > Hi, > > For a WIndows you can take a look at http://mysqlfront.de it's sample and > easy. > > HTH > > João Batista > > > -----Original Message----- > From: alan4100 [mailto:[EMAIL PROTECTED]] > Sent: quarta-feira, 20 de Março de 2002 20:31 > To: [EMAIL PROTECTED] > Subject: Adding Columns to table > > > I am creating a database called Meet_a_Geek at MS DOS prompt. The customer > table has about 30 fields..no time counting..but I noticed that I cannot go > beyond 9 fields without ending with a semicolon. Also another problem crops > up when I tried to recreate the customer table with the remaining fields yet > to be created. The error message says "Customer Table existed". > > Is there a windows program that I can input all at once with ease? I know > more questions are keeping coming in...Please just refer me to good tutorial > sites so I can continue and finish this assignment. > > You may take a glance at my assignment below from cut and paste with dos > editor. > ========================================== > ========================================== > > mysql> use Meet_a_Geek; > Database changed > mysql> create table customers (Customer_ID INT NOT NULL PRIMARY KEY > AUTO_INCREME > NT, First_Name VARCHAR(20) NOT NULL, LAst_Name VARCHAR(30) NOT NULL); > Query OK, 0 rows affected (0.00 sec) > > mysql> show tables from Meet_a_Geek; > +-----------------------+ > | Tables_in_Meet_a_Geek | > +-----------------------+ > | customers | > +-----------------------+ > 1 row in set (0.01 sec) > > mysql> create table customers (Customer_ID INT NOT NULL PRIMARY KEY > AUTO_INCREME > NT, First_Name VARCHAR(20) NOT NULL, LAst_Name VARCHAR(30) NOT NULL, address > VAR > CHAR(50), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(20), E_Mail > VARCHAR(20 > ), Age INT); > ERROR 1050: Table 'customers' already exists > mysql> create table customers (Customer_ID INT NOT NULL PRIMARY KEY > AUTO_INCREME > NT, First_Name VARCHAR(20) NOT NULL, LAst_Name VARCHAR(30) NOT NULL, address > VAR > CHAR(50), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(20), E_Mail > VARCHAR(20 > ), Age INT); > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
