RE: Can field names be longer than ONE word?

2001-10-30 Thread Carsten H. Pedersen
> As subject what do I do if I want a field called (for example) > Competition ID? > > I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no > avail. Section 6.1.2 is probably closer to what you need. > I have tried enclosing it in "quotes" and 'single quotes' but neither > w

Re: Can field names be longer than ONE word?

2001-10-30 Thread Shankar Unni
David Ayliffe wrote: > As subject what do I do if I want a field called (for example) > Competition ID? > I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no > avail. > I have tried enclosing it in "quotes" and 'single quotes' but neither > work. Can this be done? I beli

Re: Can field names be longer than ONE word?

2001-10-30 Thread jim barchuk
Hello David! > As subject what do I do if I want a field called (for example) > Competition ID? > > I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no > avail. > I have tried enclosing it in "quotes" and 'single quotes' but neither > work. Can this be done? Wrong doc. :) T

Re: Can field names be longer than ONE word?

2001-10-30 Thread Paul DuBois
At 5:16 PM + 10/30/01, David Ayliffe wrote: >As subject what do I do if I want a field called (for example) >Competition ID? > >I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no >avail. >I have tried enclosing it in "quotes" and 'single quotes' but neither >work. Can th