Created
June 2, 2014 16:30
-
-
Save saibotsivad/88cfbb844bb4492ed0bd to your computer and use it in GitHub Desktop.
Commonly used MySQL commands that I keep forgetting for some reason.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# insert from a select query | |
INSERT INTO table (column1,column2) | |
SELECT column1,column2 | |
FROM ... | |
# dropping tables | |
DROP TABLE IF EXISTS tablename; | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment