Differences

This shows you the differences between two versions of the page.

--- my_sql [2015/11/30 00:23] – Created page with " <syntaxhighlight lang="bash"> # Connect to mysql server mysql --host=<ip.address> --user=<username> --password=<password> </syntaxhighlight>" scott
+++ keller_and_evans_lab:my_sql [2019/10/31 16:50] (current) – ↷ Page moved from my_sql to keller_and_evans_lab:my_sql lessem
@@ Line 1: / Line 1: @@
+====== MySQL ======
+Connecting to MySQL server in bash
+   # Connect to mysql server
+   mysql --host=<ip.address> --user=<username> --password=<password>
+MySQL commands
- # Connect to mysql server
+ show databases;      # show the databases
- mysql --host=<ip.address> --user=<username> --password=<password>
+ 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;