MySQL Function name Note

$conn = mysql_connect ();

Process language;
No-process language;
/*

Sql
DDL define
DML mainpulate
DCL Control
Interacitve SQL
embeded SQL

SELECT User_name,age
From Tbl_user
WHERE age>18
Key words:
CREATE TABLE
DROP TABLE
ALTER TABLE
CREATE INDEX
DROP INDEX
CREATE PROCEDURE
DROP PROCEDURE

SELECT
INSERT
UPDATE
DELETE

GRANT
REVOKE

COMMIT
ROLLBACK
-----
2. Data Type:
INT Type:
TINYINT 1byte
Samillint 2 bytes
Mediumint 3 bytes
INT 4 bytes
BIGINT 8bytes

Real Number Type:
FLOAT 4 bytes
DOUBLE 8 bytes
DECIMAL (20,2)

String Type: >80%
VARCHAR can change
CHAR length-unchanged
Text >> tinytext text Mediumtext longtext//charset
Blob >> Tinyblob blob mediumblob Longblob//binary
DATETIME 8 bytes
TIMESTAMP 1970-1-1 gerorg time-2938

Select Data Type Standard:
1. Minimize
2. Simple
3. Index not NULL
--------

3. Common operation
Add Delete Edit Search

Apt-get:advancded-package-tools
Update
Install
Remove
Autoremove
Purge
Upgrade
Source
Check

MySQL Function name Note