Hi,
I'm trying to design a relational database where two tables link to each
other through unique id sa below
Table 1
table1_id INT UNSIGNED NOT NULL AUTO INCREMENT,
entrydate TIMESTAMP
Table2
table2_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
table1_id INT UNSIGNED NOT NULL,
entrydate
Dear MySQL users,
MySQL Community Server 5.1.33, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.33 is
recommended for use on production systems.
Users running AIX 5.2 should be aware that this platform will be EOL'd
from 30th April 2009,
This is a question that I run into frequently; I might even have posted it
before.
If I have three tables:
A: pub_product_id
B: product_id, publisher_id, pub_product_id
C: publisher_id, publisher_code
D: product_id, product_price
and I want to find those `pub_products` that are in A, but might
Abdul,
Is this what you mean?
CREATE TABLE Table1 (
table1_id INT UNSIGNED PRIMARY KEY AUTO INCREMENT,
entrydate TIMESTAMP
)ENGINE=INNODB;
CREATE TABLE table2 (
table2_id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
table1_id INT UNSIGNED NOT NULL,
entrydate TIMESTAMP,
FOREIGN KEY(table1_id)
Hi,
I need to rename a database having InnoDB tables.
MySQL version is: 5.0.24-standard - so I cannot use the 'mysqladmin
rename' option.
What would be the best approach for doing this?
Thanks,
Shuly.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To