Project Notes

Project:
Author:
Company:
Description:

Things to do...
MySQL - pozaduje stredniky mSQL - \g tid = table id cid = column id iid = index id

CREATE

CREATE DATABASE dbname ...MySQL
CREATE [TEMPORARY] TABLE tid ( , , , )
CREATE [TEMPORARY] TABLE tid1 SELECT * FROM tid2
CREATE [UNIQUE] INDEX cid ON tid (cid, , )
CREATE PRIMARY KEY ON tid (cid, , )
CREATE [AGGREGATE] FUNCTION fid, RETURNS {STRING|REAL|INTEGER} SONAME lib

DESCRIBE

DESCRIBE tid [cid] ...MySQL == SHOW

DROP

DROP DATABASE [IF EXISTS] dbname ...MySQL
DROP TABLE [IF EXISTS] tid,,, ...MySQL
DROP INDEX iid ON tid ...MySQL
DROP FUNCTION fid ...MySQL

INSERT

INSERT INTO tid (colid, , ,) VALUES (1,NULL,'aaa',"AAAAA")
INSERT INTO tid (colid, , ,) VALUES (1,NULL,'aaa',"AAAAA") AS ,,, FROM tid WHERE krit

SELECT

SELECT * FROM tid [WHERE ...] [GROUP BY ] [ORDER BY ]...MySQL
SELECT tid.cid, , , FROM tid, , , [WHERE ...] ...MySQL
SELECT 1+1
SELECT concat(nm1, " ", nm2) AS cid, , , FROM tid
SELECT MAX(?id?? ) AS ??? FROM tid

UPDATE

UPDATE tid SET cid=newval [WHERE krit] ...MySQL
UPDATE COLUMNS FROM tid ...MySQL

SHOW

SHOW TABLES FROM dbname ...MySQL
SHOW COLUMNS FROM tid ...MySQL

USE

USE dbname ...MySQL

ALTER

ALTER TABLE tid ...MySQL
ALTER TABLE oldtid RENAME newtid ..MySQL
ALTER TABLE tid DROP cid ..MySQL
ALTER TABLE tid ADD cid typ ...MySQL
ALTER TABLE tid ADD {KEY|INDEX} iid (cid,,,) ...MySQL
ALTER TABLE tid ADD UNIQUE iid (cid,,,) ...MySQL
ALTER TABLE tid ADD PRIMARY KEY iid (cid,,,) ...MySQL
ALTER TABLE tid DROP cid ...MySQL

CHANGE

CHANGE oldcid newcid typ ...MySQL

LOAD

LOAD ...MySQL

LOCK

LOCK ...MySQL

UNLOCK

UNLOACK ...MySQL