hello
i creates two table t1 and t2;
CREATE TABLE t1 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE t2 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
t1id INT UNSIGNED NOT NULL,
PRIMARY KEY (id),
KEY (t1id),
FOREIGN KEY (
I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want
to use foreign key constraints .
what configurations i have to made. please give step by step procedure
so that i am able to install in my machine and able to work.
waiting for your reply.
Regards
--
I have installed mysql -3.23.39-pc-linux-gnu-i686 on linux , and i want
to use foreign key constraints .
what configurations i have to made. please give step by step procedure
so that i am able to install in my machine and able to work.
waiting for your reply.
Regards
Mysql pick up the database list from its default datadir C:/mysql/data
as it is mentioned in
my.ini file in window.
but i want to use my own directory which contains some database , if i
am setting the datadir into my
directory i am able to use my own directory to which i have to copy the
default
I need to create a database in MySQL that I need to bundle with my
program
for distribution. The user will have its own copy of MySQL running. User
using my program will not bother about database issues and the bundled
database will provide him, through my application program GUI, to
enter/retr
