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

a problem, you have to do more!!. Ahmad Khashan Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam

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 &g

Re: Create Table Syntax

ECTED]> wrote: 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.

Re: Create Table Syntax

d then again specify '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 sy

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]

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] [select_st