Difference between revisions of "MySQL"
Jump to navigation
Jump to search
| Line 13: | Line 13: | ||
select * from table_name limit 10; # to see what's in a table (first ten entries) | select * from table_name limit 10; # to see what's in a table (first ten entries) | ||
select * from user_location where user_id='6346669087044735461' order by sample_time desc limit 10; | select * from user_location where user_id='6346669087044735461' order by sample_time desc limit 10; | ||
| + | </syntaxhighlight> | ||
| + | |||
| + | Copy remote table to local file | ||
| + | <syntaxhighlight lang="mysql"> | ||
| + | mysql -u<username> -p -h <ip> --ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem \ | ||
| + | userdata_schema -e "select * from user_location" > <export-file>.csv | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 12:41, 17 April 2020
MySQL
Connecting to MySQL server in bash
# Connect to mysql server
mysql -u<username> -p -h <ip> --ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem
MySQL commands
show databases; # show the databases
use userdata_schema; # connect to a particular database
show tables; # list the tables within the database
select * from table_name limit 10; # to see what's in a table (first ten entries)
select * from user_location where user_id='6346669087044735461' order by sample_time desc limit 10;
Copy remote table to local file
mysql -u<username> -p -h <ip> --ssl-ca=server-ca.pem --ssl-cert=client-cert.pem --ssl-key=client-key.pem \
userdata_schema -e "select * from user_location" > <export-file>.csv