Changes

Jump to navigation Jump to search

MySQL (edit)

Revision as of 13:00, 25 August 2015

53 bytes added ,  13:00, 25 August 2015
no edit summary
Line 1: Line 1:  
== SQL ==
 
== SQL ==
 
=== List databases ===
 
=== List databases ===
−
  show databases;
+
  SHOW databases;
    
=== Open db ===
 
=== Open db ===
−
  use dbname;
+
  USE dbname;
 
or
 
or
−
  connect dbname;
+
  CONNECT dbname;
    
=== List tables ===
 
=== List tables ===
−
  show tables;
+
  SHOW TABLES;
 +
 
 +
=== Show table fields ===
 +
SHOW COLUMNS FROM City;
 +
 
 
=== add .sql to MySQL database ===
 
=== add .sql to MySQL database ===
 
TODO: REVISAR
 
TODO: REVISAR
Retrieved from "https://wiki.herrerosolis.com/index.php/Special:MobileDiff/591"

Navigation menu