Last active
January 28, 2021 20:05
-
-
Save ambercouch/1de96e3cf7895e2ff7565f6e60a87590 to your computer and use it in GitHub Desktop.
MySQL commands
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
SELECT * FROM orders_admin group by order_session having count(*) >= 2 |
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
mysql -u username -p database_name < file.sql |
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
unzip -p dbdump.sql.zip | mysql -u root -p yourdbname |
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
zcat file.sql.gz | mysql -u 'root' -p your_database |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment