Difference between revisions of "MySQL"

From DUNE
Jump to navigation Jump to search
(Created page with "=Install= <pre> sudo apt-get update sudo apt-get install mysql-server </pre> =The Service= <pre> systemctl status mysql.service mysqladmin -p -u root version mysql -u root -p...")
 
Line 10: Line 10:
 
mysqladmin -p -u root version
 
mysqladmin -p -u root version
 
mysql -u root -p
 
mysql -u root -p
 +
</pre>
 +
 +
=CLI Client Commands=
 +
==Misc==
 +
<pre>
 +
quit
 +
\q
 +
SELECT VERSION();
 +
select (4+11);
 +
</pre>
 +
 +
==Admin==
 +
<pre>
 +
SHOW DATABASES;
 +
use FOO;
 +
create table t1 (name varchar(20), ts DATE);
 +
describe t1;
 
</pre>
 
</pre>

Revision as of 18:36, 26 November 2018

Install

sudo apt-get update
sudo apt-get install mysql-server

The Service

systemctl status mysql.service
mysqladmin -p -u root version
mysql -u root -p

CLI Client Commands

Misc

quit
\q
SELECT VERSION();
select (4+11);

Admin

SHOW DATABASES;
use FOO;
create table t1 (name varchar(20), ts DATE);
describe t1;