Difference between revisions of "MySQL"
Jump to navigation
Jump to search
Rafahsolis (talk | contribs) |
Rafahsolis (talk | contribs) |
||
| Line 1: | Line 1: | ||
== SQL == | == SQL == | ||
=== List databases === | === List databases === | ||
| − | + | SHOW databases; | |
=== Open db === | === Open db === | ||
| − | + | USE dbname; | |
or | or | ||
| − | + | CONNECT dbname; | |
=== List tables === | === List tables === | ||
| − | + | SHOW TABLES; | |
| + | |||
| + | === Show table fields === | ||
| + | SHOW COLUMNS FROM City; | ||
| + | |||
=== add .sql to MySQL database === | === add .sql to MySQL database === | ||
TODO: REVISAR | TODO: REVISAR | ||
Revision as of 13:00, 25 August 2015
SQL
List databases
SHOW databases;
Open db
USE dbname;
or
CONNECT dbname;
List tables
SHOW TABLES;
Show table fields
SHOW COLUMNS FROM City;
add .sql to MySQL database
TODO: REVISAR backup:
mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql
backup .sql.gz
mysql -uroot -ppassword mydb > myfile.sql.gz
restore:
mysql -u root -p[root_password] [database_name] < dumpfilename.sql
restore .sql.gz
zcat /path/to/file.sql.gz | mysql -u 'root' -p 'password' your_database