(t1id) REFERENCES t1(id)
) TYPE=InnoDB;
it supports the foreign key fine. if i will alter the table t2 and add
one
more column to it , then foreign key is not working .
if anybody knows about this or it is a bug of MySQL ?
Regards
Asit
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
=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-max-nt.exe
user=asit
password=asit
QueryInterval=10
Regards
Asit
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
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
=Test
dcncentral.Open str1- Giving Catastrophic Error
End Sub
This function is not opening the database and giving "Catastrophic Error".
What should be the connection string for database ?
Please help. Kindly note that I want to connect to MYSQL database without a DSN
Thanks i