Re: Create Table Syntax

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 meant

How do I determine the row number or key when table has no key

!!. Ahmad Khashan Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam

Re: Create Table Syntax

: 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

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 [(create_definition,...)] [table_options] [select_statement] and: create_definition: part-1 (- inserted by me for reference) col_name type [NOT NULL | NULL]

Re: Create Table Syntax

'Primary Key' as part of the table modifiers? Ahmad Khashan Rhino [EMAIL PROTECTED] wrote: - Original Message - From: Khashan To: 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 table 'LIKE' ....Error 1064

Hello All, I have MySQL 4.0.16 on Windows 2000 pro. I am trying to create a table in an existing database. according to the manual, I can use one of these statements: 6.5.3 CREATE TABLE Syntax CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options]