Advanced Search

Return to Snippet

Revision: 15482
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
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