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

Crontab command

 crontab -l  to see all listed crontab tasks. crontab -e to add/edit crontab tasks. Inside the crontab editor, the command would be composed of  <scheduler> <run command> <the output> * * * * * /home/ae/code.sh >> output.txt 2>&1  Which.. the 1st star = minutes to start running the 2nd star = hours to start running the 3rd star = day of the month to start running the 4th star = month to start running the 5th star = day of the week to start running More info: https://www.geeksforgeeks.org/crontab-in-linux-with-examples/  
Read more

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

Guideline: How to write the thesis report

The following tips came from my personal experience during writing my master thesis report. I hope this could help friends to start your research/thesis on the right track and reduce your time to manage it. Any suggestions are welcome as well. Where should I start? Select your interesting area, it's highly recommended to focus on your future career life.  Think about the situation and problems existing in that area, this will lead to your research/thesis topics. Go to more information on google/youtube/teds any platform that could give you the reality of the current situation of that topic area (spend your time serving for 2-3 days if possible, so you will see a clearer picture of what you're interested in). Focus on only one important problem as your topic, which you will give your contribution to solving. Before start writing? Think about the topics related to your thesis background, problem statements, and potential solutions. List those topics in the hierarchy...
Read more