Revision: 15482
Updated Code
at July 7, 2009 11:04 by iloveitaly
Updated Code
SHOW CREATE TABLE `tablename` DESCRIBE `table` EXPLAIN SELECT ... ALTER TABLE playlist_events ADD FOREIGN KEY (playlist_id) REFERENCES playlists (id) ALTER TABLE playlists CONVERT TO CHARACTER SET utf8 ALTER TABLE tbl_name DROP FOREIGN KEY fk_symbol -- Insert data from other table INSERT INTO TestTable (FirstName, LastName) SELECT FirstName, LastName FROM Contact WHERE EmailPromotion = 2
Revision: 15481
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at July 7, 2009 10:56 by iloveitaly
Initial Code
SHOW CREATE TABLE `tablename` DESCRIBE `table` EXPLAIN SELECT ... ALTER TABLE playlist_events ADD FOREIGN KEY (playlist_id) REFERENCES playlists (id) ALTER TABLE playlists CONVERT TO CHARACTER SET utf8 ALTER TABLE tbl_name DROP FOREIGN KEY fk_symbol
Initial URL
Initial Description
More for me than anything else
Initial Title
Foreign Keys & DB Design
Initial Tags
sql
Initial Language
SQL