 | | | Problem : Mysql | Problem : Mysql 2006-09-13 - By vipin.chandna@(protected)
Back
1. Foreign Key concept is not working on MySQL version
4.1.15-max .
Actually I made two tables and I was able to "delete &
update" from primary key value even if those values are
present as a foreign key in another table.
2. Another problem is with _rowid. It only works when we
create Integer Primary key other wise it doesn't work.
How can we differentiate two rows when no primary key is
defined and both the rows contains same data. I can do in
Oracle with rowid.
how can we delete all those duplicate records in a table
which doesn't contain primary key or doesn't contain
numbered primary key. this can be done in oracle by rowid
but this can't be done in mysql. Plz give me solution at
earlist.
Regards,
Vipin Chandna
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
|