Difference between revisions of "SQL"

From Void-Byte
Jump to navigation Jump to search
(Created page with "Useful commands: show databases; use <database>; show tables; select <columnA>, <columnB> from <nowiki><table> where <columnB> like <pattern>;</nowiki> select last_name,...")
 
(No difference)

Latest revision as of 21:21, 28 December 2020

Useful commands:

show databases;

use <database>;

show tables;

select <columnA>, <columnB> from <table> where <columnB> like <pattern>;

select last_name, first_name from users union select 1,2;