mhpreiman
1/24/2017 - 10:31 PM

MySQL commands

mysql commands.md
content_copyfile_download
  • Rendered
  • Source

.
  `COUNT(*)`     returns the number of records in a table   `SELECT COUNT(*) FROM film`  


Various queries

Copy data from one table to another

SELECT *
INTO newtable [IN externaldb]
FROM table1;