MySQL - Engines (innoDB) what are these? - dBforums

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

> MySQL - Engines (innoDB) what are these?

Reply

Search this Thread

#1 (permalink)

Old

08-01-06, 03:47

hYph3n

hYph3n is offline

Registered User

Join Date: Jul 2006

Posts: 26

MySQL - Engines (innoDB) what are these?

i want to know what are these engines in MySQL. I have never seen any such thing in MS-SQL or Oracle.

Moreover, Whenever i tried to make a relationship between 2 tables it gives me error that InnoDB handles is missing, i created the DB on InnDB engine and even then i am having the same error. How can i make relationships between 2 tables?

Reply With Quote

#2 (permalink)

Old

08-01-06, 06:06

r937

r937 is offline

SQL Consultant

Join Date: Apr 2002

Location: Toronto, Canada

Posts: 19,534

http://dev.mysql.com/doc/refman/5.0/...e-engines.html

when declaring a relationship, make sure the foreign key has an index

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book

Reply With Quote

#3 (permalink)

Old

08-02-06, 06:16

hYph3n

hYph3n is offline

Registered User

Join Date: Jul 2006

Posts: 26

Thanks for the help. I'll go through the document.

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules