Sql order of operations

sql order of operations SELECT DISTINCT column, AGG_FUNC(column_or_expression), … FROM mytable JOIN another_table ON mytable.column = another_table.column WHERE constraint_expression GROUP BY column HAVING constraint_expression ORDER BY column ASC/DESC LIMIT count OFFSET COUNT;

Sql order of operations Read More

Sql insert query

sql insert query –sql insert quest example INSERT INTO table_name (column1, column2, column3, …) VALUES (value1, value2, value3, …); sql insert query INSERT INTO table_name (column1, column2, column3, …) VALUES (value1, value2, value3, …); TSQL Insert INSERT INTO TABLE_NAME [(column1, column2, column3,…columnN)] VALUES (value1, value2, value3,…valueN); sql insert into statement SQL INSERT STATEMENT insert into […]

Sql insert query Read More

Sql delete column

sql server delete column ALTER TABLE Customers DROP COLUMN ContactName; sql delete column Deletes a column from a table. Example: Removes the first_name column from the users table. ALTER TABLE users DROP COLUMN first_name alter table delete column ALTER TABLE “table_name” DROP “column_name”; mysql drop column ALTER TABLE `claims_user_settings` DROP COLUMN `super_user`; sql delete all […]

Sql delete column Read More

Sql day from datetime

sql: extract day text from datetime value SELECT DATENAME(dw,’09/23/2013′) as theDayName sql day from datetime SET @@lc_time_names = ‘fr_FR’; SELECT DAYNAME(‘2000-01-01’) dayname; +———+ | dayname | +———+ | samedi | +———+

Sql day from datetime Read More

Uninstall mysql ubuntu 18.04

uninstall mysql ubuntu 18.04 $ sudo apt-get remove –purge mysql-server mysql-client mysql-common -y $ sudo apt-get autoremove -y $ sudo apt-get autoclean rm -rf /etc/mysql # Delete all MySQL files on your server: sudo find / -iname ‘mysql*’ -exec rm -rf {} \; uninstall mysql ubuntu 18.04 $ sudo apt-get remove –purge mysql-server mysql-client mysql-common […]

Uninstall mysql ubuntu 18.04 Read More