Mysql: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== Syntax == === Data Manipulation === ==== Basic ==== * Select <syntaxhighlight lang="mysql"> SELECT columna, columnb FROM mytable; SELECT columna as alias1, columnb as alias...") |
No edit summary |
||
| Line 36: | Line 36: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
==== Alter Table ==== | ===== Alter Table ===== | ||
<syntaxhighlight lang="mysql"> | <syntaxhighlight lang="mysql"> | ||
</syntaxhighlight> | </syntaxhighlight> | ||
=== | ==== Special Case ==== | ||
===== TimeStampe ===== | |||
<syntaxhighlight lang="mysql"> | |||
CREATE TABLE test_table( | |||
Id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, | |||
CreatedTime TIMESTAMP DEFAULT '0000-00-00 00:00:00', | |||
UpdatedTime TIMESTAMP DEFAUT NOW() ON UPDATE NOW() | |||
); | |||
</syntaxhighlight> | |||
Revision as of 16:37, 20 November 2014
Syntax
Data Manipulation
Basic
- Select
SELECT columna, columnb FROM mytable;
SELECT columna as alias1, columnb as alias2 FROM mytable;
Special
- Dummy Table
SELECT 1+1;
SELECT 1+1 FROM DUAL;
- Concatenate
SELECT CONCAT(last_name,', ',first_name) AS full_name FROM mytable;
Data Definition
Basic
Create Database
CREATE DATABASE mydatabase;
CREATE DATABASE mydatabase CHARACTER SET utf8 COLLATE utf8_general_ci;
Create User
GRANT ALL PRIVILEGES ON mydatabase.* TO myuser@localhost IDENTIFIED BY 'myuser_password';
Create Table
Alter Table
Special Case
TimeStampe
CREATE TABLE test_table(
Id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
CreatedTime TIMESTAMP DEFAULT '0000-00-00 00:00:00',
UpdatedTime TIMESTAMP DEFAUT NOW() ON UPDATE NOW()
);