Differences

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

--- keller_and_evans_lab:my_sql [2015/12/04 12:54]
scott /* MySQL */
+++ keller_and_evans_lab:my_sql [2019/10/31 10:50] (current)
lessem ↷ Page moved from my_sql to keller_and_evans_lab:my_sql
@@ Line 9: / Line 9: @@
 MySQL commands
-   show databases;      # show the databases
+ show databases;      # show the databases
-   use userdata_schema; # connect to a particular database
+ use userdata_schema; # connect to a particular database
-   show tables;         # list the tables within the 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 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;
-Python script to extract entries from a table and write to tab-delimited file
-  <syntaxhighlight lang="python">
-  TBD
- </sintaxhighlight>

IBG Wiki