Re: Create table syntax question

2004-06-16 Thread Michael Stassen
PROTECTED] Subject: Re: Create table syntax question eifion herbert (IAH-C) wrote: Hi, Probably a very basic question. I'm trying to a create a table in mySQL 4.0.15 thus: create table VACANCIES( VACREF char(6) NOT NULL PRIMARY KEY, TITLE varchar(60), LOC varchar(9), DESC text, STARTD

RE: Create table syntax question

2004-06-16 Thread eifion herbert (IAH-C)
enforce RI. > -Original Message- > From: Michael Stassen [mailto:[EMAIL PROTECTED] > Sent: 16 June 2004 16:43 > To: eifion herbert (IAH-C) > Cc: [EMAIL PROTECTED] > Subject: Re: Create table syntax question > > > > eifion herbert (IAH-C) wrote: > >

Re: Create table syntax question

2004-06-16 Thread Michael Stassen
eifion herbert (IAH-C) wrote: Hi, Probably a very basic question. I'm trying to a create a table in mySQL 4.0.15 thus: create table VACANCIES( VACREF char(6) NOT NULL PRIMARY KEY, TITLE varchar(60), LOC varchar(9), DESC text, STARTDATE date, GROUP varchar(25), CONSTRAINT fk_grp FOREIGN KEY (GROUP)

RE: Create table syntax question

2004-06-16 Thread Mike Johnson
From: eifion herbert (IAH-C) [mailto:[EMAIL PROTECTED] > Hi, > > Probably a very basic question. > > I'm trying to a create a table in mySQL 4.0.15 thus: > > create table VACANCIES( > VACREF char(6) NOT NULL PRIMARY KEY, > TITLE varchar(60), > LOC varchar(9), > DESC text, > STARTDATE date, > GR

Re: Create Table Syntax

2004-04-03 Thread Khashan
Thanks a lot, I think I have enough to validate the syntax (sort of). Ahmad Khashan Michael Stassen <[EMAIL PROTECTED]> wrote: Khashan wrote: > **None of these are "table level" modifiers** > > Sorry, I guess I used the wrong terminology. I am aware of the table > options available. What I me

Re: Create Table Syntax

2004-04-02 Thread Michael Stassen
Khashan wrote: **None of these are "table level" modifiers** Sorry, I guess I used the wrong terminology. I am aware of the table options available. What I meant is “additional definitions” after the columns have been defined. Sorry I misunderstood you. Now, do I understand that you are saying

Re: Create Table Syntax

2004-04-02 Thread Khashan
**None of these are "table level" modifiers** Sorry, I guess I used the wrong terminology. I am aware of the table options available. What I meant is “additional definitions” after the columns have been defined. Now, do I understand that you are saying that a user can specify any of :

Re: Create Table Syntax

2004-04-02 Thread Michael Stassen
Khashan wrote: Thanks for the reply. It seems like the syntax for create_table/create_definition should have 2 part-2 modifiers I think you are misreading the syntax. That is, I think you are confusing the index-related create_definitions with the table_options. 1- one part-2 'column' modifi

Re: Create Table Syntax

2004-04-01 Thread Khashan
Thanks for the reply. It seems like the syntax for create_table/create_definition should have 2 part-2 modifiers 1- one part-2 'column' modifiers for the each column. and 2- another part-2 table modifiers for the table as a whole ? ( at the end of column definitions). two questions: -- Are a

Re: Create Table Syntax

2004-04-01 Thread Rhino
- Original Message - From: "Khashan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 01, 2004 1:04 PM Subject: Create Table Syntax > > I am looking at the syntax for creating table( section 6.5.3 of the manual): > > CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(c

Re: Create Table Syntax for DEFAULT

2001-08-23 Thread Paul DuBois
At 5:18 PM -0700 8/23/01, Igbar Foosenhopper wrote: >Is it possible to use current_date (mysql function) to generate a >default for a column? No. Defaults must be constants. http://www.mysql.com/doc/C/R/CREATE_TABLE.html > >If so .. what would the syntax look like. I have tried several thing