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

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

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

Ruby on Rails with PosgreSQL : Basic tutorial

Installation Steps - Install Ubuntu and upgrade - Install Apache2 - Install Rails - Install Ruby - Install Passenger More Info:  https://nathanhoad.net/how-to-ruby-on-rails-ubuntu-apache-with-passenger Command Guides * To install Apache 2 development headers: sudo apt-get install apache2-dev * To install Ruby development headers: sudo apt-get install ruby-dev * To in stall Passenger gem install passenger passenger-install-apache2-module * To install Apache Portable Runtime (APR) development headers: sudo apt-get install libapr1-dev * To install Apache Portable Runtime Utility (APU) development headers: sudo apt-get install libaprutil1-dev * To install Curl development headers with SSL support: sudo apt-get install libcurl4-openssl-dev (or libcurl4-gnutls-dev) ------------ Set c onfig passenger ----------- LoadModule passenger_module /home/web05/.rbenv/versions/2.5.1/lib/ruby/gems/2.5.0/gems/passenger-5.3.4/buildout/apache2/mod_passenger.so
Read more