User Tools

Site Tools



Connecting to MySQL server in bash

 # Connect to mysql server
 mysql --host=<ip.address> --user=<username> --password=<password>

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;

keller_and_evans_lab/my_sql.txt · Last modified: 2019/10/31 10:50 by lessem