Re: Adding Columns to table

2002-03-21 Thread alan4100
mysql I tried to d/l winmysql from this website: http://www.winmysql.com/page4.html as freeware, but it did not respond. Guess it is busy. Will try again, later. But would you or others suggest me to put it in a separate folder from MySQL folder after the d/l?

Re: Adding Columns to table

2002-03-21 Thread alan4100
mysql Thanks, Colin for the reference to winmysql..etc. By the way, do you also get this email at your personal email address besides mailing list? It looks like you have to check at this mailing list site, because almost all personal emails have been bounced back. I only reply notes to [EM

Re: Adding Columns to table

2002-03-21 Thread alan4100
mysql Allon, Thanks for the clear and simple example regarding keys. You may notice mysql at the top left corner because without it your letter will bonce back like others (users). eek!

Re: Adding Columns to table

2002-03-20 Thread alan4100
t; To: "alan4100" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 5:41 PM Subject: Re: Adding Columns to table > At 15:30 -0500 3/20/02, alan4100 wrote: > >I am creating a database called Meet_a_Geek at MS DOS prompt. The > >customer table

Re: Adding Columns to table

2002-03-20 Thread alan4100
ista (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 &

Re: Adding Columns to table

2002-03-20 Thread alan4100
keeping sending one to you and cc to mailing list separately. - Original Message - From: "Tony" <[EMAIL PROTECTED]> To: "'Paul DuBois'" <[EMAIL PROTECTED]>; "alan4100" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, M

Re: Adding Columns to table

2002-03-20 Thread alan4100
mysql - Original Message - From: "Tony" <[EMAIL PROTECTED]> To: "'alan4100'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, March 20, 2002 2:11 PM Subject: RE: Adding Columns to table Just put a carriage return (e.g. the enter

Re: Adding Columns to table

2002-03-20 Thread Allon Bendavid
The problem is you are not entering any returns. You can do this: mysql> create table customers -->(Customer_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, -->First_Name VARCHAR(20) NOT NULL, -->LAst_Name VARCHAR(30) NOT NULL, Etc, until you get to the last: -->; That's it. On 3/20/02 2:40

RE: Adding Columns to table

2002-03-20 Thread Tony
columnA tinyint auto_increment, ... -Original Message- From: Paul DuBois [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 20, 2002 5:42 PM To: alan4100; [EMAIL PROTECTED] Subject: Re: Adding Columns to table At 15:30 -0500 3/20/02, alan4100 wrote: >I am creating a da

RE: Adding Columns to table

2002-03-20 Thread Tony
Just put a carriage return (e.g. the enter key) in your command every, say 72 characters or wherever the next logical word occurs. MySQL really only cares about ending all the entry with a semi-colon (or some maximum line length which I think you've run up against). In short, hitting the en

Re: Adding Columns to table

2002-03-20 Thread Paul DuBois
At 15:30 -0500 3/20/02, alan4100 wrote: >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. The mysql program does not require that you enter an

Re: Adding Columns to table

2002-03-20 Thread Colin Faber
I suggest using one of the windows GUI clients to modify tables, rather than a command prompt (i.e. winmysql etc). alan4100 wrote: > > 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