.
And if it is true that InnoDB tables can contain
only 1000 or fewer rows, what's the use. I could do that with a text file.
Jim Bailey
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/su
gn Key Field(s)
AGAIN?
true or false
Question V.
I suppose I should include the Constraint syntax in the SQL that creates the
Native Table and not in the SQL that creats the Foreign Table?
True or false?
Thanks for your help
Jim Bailey
_
sql,query
Following are two CREATE TABLE statements. The second one fails because of
an error in the last line.
Does anyone know why?
Jim Bailey
STATEMENT #1
CREATE TABLE IIM_InventoryItemMaster(
IIM_InventoryItemMaster_ID MEDIUMINT(8) NOT NULL,
IIM_ItemNm VARCHAR(64),
IIM_ItemDescCD VARCHAR
At the prompt mysql> I type a command : SOURCE SCRIPTS\MT_INV_TBL.TXT.
The command returns the following error message:
Failed to open file [FileName] Error 2.
So what is this error 2. What does it mean?
Your help will be appreciated.
