Types of SQL Command



DDL = Data Definition Language - specify table definitions
DML = Data Manipulation Language - works with data
DCL = Data Control Language - who has access rights
TCL = Transaction Control Language - how the transaction will be

Reference: https://www.w3schools.in/mysql/ddl-dml-dcl/

Comments

Post a Comment

Popular posts from this blog

MySQL Function: Thai months to String

 /*--------- Function: get_month ---------*/ DROP FUNCTION IF EXISTS get_month; DELIMITER $$ CREATE FUNCTION get_month(   m VARCHAR(100) ) RETURNS int(2)     DETERMINISTIC BEGIN  DECLARE me int(2) default 0;      IF m= 'ม.ค.' THEN set me= 1;     ELSEIF m= 'ก.พ.' THEN set me= 2;     ELSEIF m= 'มี.ค.' THEN set me= 3;     ELSEIF m= 'เม.ย.' THEN set me= 4;     ELSEIF m= 'พ.ค.' THEN set me= 5;     ELSEIF m= 'มิ.ย.' THEN set me= 6;     ELSEIF m= 'ก.ค.' THEN set me= 7;     ELSEIF m= 'ส.ค.' THEN set me= 8;     ELSEIF m= 'ก.ย.' THEN set me= 9;     ELSEIF m= 'ต.ค.' THEN set me= 10; ELSEIF m= 'พ.ย.' THEN set me= 11;     ELSEIF m= 'ธ.ค.' THEN set me= 12;     END IF;         RETURN me; END $$ DELIMITER ;
Read more

2>&1 in command means??

References.. 0 =  standard input  ( stdin ) 1 =  standard output  ( stdout )  2 =  standard error  ( stderr ) Hence, we can use command > output.log to print the std output stream, which is an implicit meaning of command 1>output.log Thus, the annex 2>&1 means print the std error to the same place as the std output.  Moreover, the we can hide the std output from printing out by using 2>/dev/null. Thanks to: https://linuxize.com/post/bash-redirect-stderr-stdout/ Learning bash: https://iridakos.com/programming/2018/03/01/bash-programmable-completion-tutorial
Read more

Recommended video screen recorder (on Window, Linux, Andriod)

On window use the program Free Cam On Linux use the program Peek sudo add-apt-repository ppa:peek-developers/stable sudo apt update sudo apt install peek or use the program VokoScreenNG sudo add-apt-repository ppa:ubuntuhandbook1/apps sudo apt update sudo apt install vokoscreen-ng On Andriod use the app XRecorder More detail for Linux: https://itsfoss.com/take-screenshot-linux/  
Read more