Hello Steve,
> Ok, I'm a little new a this, so be gentle!! :)
>
> I was looking into the InnoDB engine for some tables I have, and would
like
> to use the PK/FK on some of the data.
>
> It appears that the PK/FK is mainly used for updating/deleting data,
> correct? I can't use it to retreive data
Ok, I'm a little new a this, so be gentle!! :)
I was looking into the InnoDB engine for some tables I have, and would like
to use the PK/FK on some of the data.
It appears that the PK/FK is mainly used for updating/deleting data,
correct? I can't use it to retreive data from multiple tables
Hello,
A bit embarrassed, I have been away from the databasing side of system
development for quite a while so am a little rusty. This seems like a simple
issue.
I have a USER table:
userID
fName
lName
address
address2
city
province
country
referrerID
userID is the unique pr
Howdy all,
Quick question about foreign keys. If I have a
database with foreign keys setup, then drop one of the
tables (which is referenced by many of the others) and
re-add the table, will the existing FKs work?
I'm seeing errors in SHOW INNODB STATUS under the
LATEST FOREIGN KEY ERRORS section
--- Randy Clamons <[EMAIL PROTECTED]> wrote:
"Primary key names start with pk_, unique indexes
start with uk_, other indexes start wiht ix_."
That's a good tip. What if just named the primary key
pk and the foreign key fk. Would you run into trouble
if you're working with two or three tables, and
I am using MySql-3.23.51. Even though this version
doesn't support foreign keys, the foreign key
declarations can be entered without getting an error
message. I would like to write CREATE TABLE
statements that include foreign key declarations that
would be compatible with future releases that wi
