INSERT INTO table_name (column1, ...) VALUES (value1, ...
);
INSERT INTO table_name (column1, ...) SELECT copyc1, copyc2 from table_name;
ALTER TABLE nume_tabela ADD/DROP/MODIFY nume_coloana tip_data;
ALTER TABLE nume_t CHANGE COLUMN num_vechi_c num_nou_c TIP DATA
DEFAULT valoare NOT NULL;
ALTER TABLE tab ALTER COLUMN coloana SET DEFAULT valoare ;
ALTER TABLE T1 ADD COLUMN DATA_MODIFICARII2 timestamp default
current_timestamp on update current_timestamp;
CREATE TABLE IF NOT EXISTS num_tab SELECT num_col_de_copiat FROM
tab_de_copiat;
UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;
DELETE FROM table_name num_coloana WHERE condition;
CREATE TABLE IF NOT EXISTS t2(c1 VARCHAR(10) CHARACTER SET UTF8
COLLATE UTF8_romanian_ci);
ALTER TABLE chimicale RENAME chemicals;
SELECT (coloana1, …) FROM tabela WHERE conditie ORDER BY coloana ASC/DESC
LIMIT numar;
SELECT coloana, valoare IN (coloana) FROM table;
SELECT coloana, valoare INTO variabila FROM table WHERE conditie;
UPDATE tabela SET coloana= coloana- INTERVAL 10 DAY WHERE conditie;
CREATE TABLE IF NOT EXISTS nume_tabel (
nume_coloane
FOREIGN KEY(coloanal_aici) REFERENCES tab_parinte(coloana_parinte) ON UPDATE
CASCADE (sau set_null) ON DELETE CASCADE);
ALTER table T4 add primary key(ID_CLIENT);
SELECT
nume coloane pe care vrem sa le afisam
FROM table1
INNER/LEFT/RIGHT JOIN table 2
ON table1.column_name=table2_column_name;
SET GLOBAL log_bin_trust_function_creators=1;
DELIMITER #
CREATE FUNCTION nume(param1 tip_data, …)
RETURNS TIP_DATA
BEGIN
DECLARE variabile;
SET @variab:=valoare;
instructiuni
RETURN variabila
END#
DELIMITER;
SELECT nume_func(parametru);
CREATE PROCEDURE nume(IN param INT, …) BEGIN ………….. END#
CALL procedura(parametru);
CREATE TRIGGER nume BEFORE/AFTER INSERT/UPDATE/DELETE ON tabela FOR
EACH ROW
BEGIN …instructiuni… END#
DROP TRIGGER nume_trigger;
SELECT CASE(WEEKDAY(data_imprumut)) WHEN '0' THEN 'Luni' WHEN '1' THEN
'Marti' …WHEN '6' THEN 'Duminica' END AS zi_saptamana FROM zile;
IF(condition, value_if_true, value_if_false) // IF conditie THEN rezultat ELSE rezultat2
ENDIF;
CURDATE() AS data_curenta;
CHAR_LENGTH(string);
CONCAT_WS(separator, expression1, expression2, expression3,...);
TRUNCATE(number, decimals);
TIMESTAMPDIFF(DAY, timestamp1 ,timestamp2 );
TRUNCATE(number, decimals);
CONV(c1, b_init, b_finala);
DATE_ADD(data,INTERVAL 10 DAY);
INTERVAL(c1,c2,c3,c4,c5) FROM t3;
SELECT RAND();
LPAD(string, length, lpad_string)
STR_TO_DATE(string, format)
SUBSTR(string FROM start FOR length)
