User Tools

Site Tools


keller_and_evans_lab:my_sql

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
keller_and_evans_lab:my_sql [2015/11/29 17:26]
scott
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 14: Line 14:
  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;
    
  
keller_and_evans_lab/my_sql.1448843206.txt.gz · Last modified: 2015/11/29 17:26 by scott