Wednesday, October 1, 2008

SQL

1. To use a database
use

2. To show all tables in the database
show tables from

3. Describe a table
describe

4. print some rows
select * from limit
-
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Continuously monitor GPU usage

 For nvidia GPUs do the follwing: nvidia-smi -l 1

  • Invalid annotation object error in PDFs
    If you used Adobe acrobat to annotate a PDF file and you had Acrobat crashed or had to restart the computer abruptly during the annotation p...
  • TexShop MacTex US letter PDFs
    By default when you install MacTex and use TexShop for writing and compiling latex you will get PDFs with page size A4. This is all fine for...
  • numpy dot vs inner
    dot and inner returns the same result for 1D arrays. However, for 2D arrays (matrices), dot gives the matrix product, whereas inner gives ...