#Tableplus view sql print plus

Mandatory and tells MySQL server to create a function named `sf_name’ with optional parameters defined in the parenthesis. This function rounds a number with decimal places to the nearest whole number.īasic syntax for creating a stored function This function removes decimals places from a number and rounds it to the nearest lowest number. It takes a string as a parameter and converts all the letters to upper case. SQL Functions commands String functions Command to match letters, to match white space, is match punctuations and for upper class letters. The vertical bar (|) is used to isolate alternatives. The caret (^) is used to start the match at beginning. The is used to match any digit from 0 through to 9. The is used to match any lower case letter The is used to match any upper case letter The charlist is used to match any characters excluding the ones enclosed. The charlist is used to match any of the enclosed characters. The dot (.) metacharacter is used to match any single character in exception of a new line. The question(?) metacharacter is used to match zero (0) or one instances of the strings preceding it.

#Tableplus view sql print plus

The plus (+) metacharacter is used to match one or more instances of strings preceding it. The asterisk (*) metacharacter is used to match zero (0) or more instances of the strings preceding it SELECT * FROM table1 WHERE t1 REGEXP X1 Regular expression Metacharacters Command It does not matter whether the “X1” is at the beginning, middle or end of the title. Inserting into a Table from another TableĭELETE FROM table_name Įxample :- all the table1 t1 that have the word X1 in them. INSERT INTO table_1 SELECT * FROM table_2 INSERT INTO table_name(column_1,column_2,…) VALUES (value_1,value_2,…) WHERE clause combined with Not Equal to ()COMPARISON OPERATORS WHERE clause combined with greater than(>) to COMPARISON OPERATORS WHERE clause combined with Equal(=) to COMPARISON OPERATORS WHERE clause combined with – NOT IN Keyword SELECT * FROM table2 WHERE t1 NOT IN (1,2,3) SELECT * FROM table2 WHERE t1 IN (1,2,3) WHERE clause combined with – OR LOGICAL Operator

SELECT * FROM table1 WHERE t1 = 1 OR t1 = 2 WHERE clause combined with – AND LOGICAL Operator SELECT * FROM table1 WHERE t1 = 2 AND t2 = 2008 MySQL WHERE clause with AND, OR, IN, NOT IN commands Command SELECT column_name|value|expression alias_name SELECT Concat(t1, (, t3, )), t4 FROM table2 We are only interested in getting only the t1, t2, t3 and t4 fields only. SELECT FROM tableName ORDER BY fieldName(s) Similar to VARCHAR, difference is texts are stored in binary format. Similar to CHAR, difference is texts are stored in binary format.

Synonym for TINYINT(1), used to store Boolean values

This is also used for storing text values chosen from a list of predefined text values. To store text value chosen from a list of predefined text values. Choice for storing currency values.Ī fixed section from 0 to 255 characters long.Ī variable section from 0 to 255 characters long.Ī string with a maximum length of 255 characters.Ī string with a maximum length of 65535 characters.Ī string with a maximum length of 16777215 characters.Ī string with a maximum length of 4294967295 characters. 9223372036854775808 to 9223372036854775807 normalĪ small approximate number with a floating decimal point.Ī large number with a floating decimal point.Ī DOUBLE stored as a string, allowing for a fixed decimal point. SQL Data Types Cheat Sheet Numeric Data types Command You can see list of existing databases by running following SQL command.ĬREATE TABLE TableName (fieldname dataType ) ENGINE = storage Engine The Latin1 character set uses the latin1_swedish_ci collation which is the Swedish case insensitive order. IF NOT EXISTS let you to instruct MySQL server to check the existence of a database with a similar name prior to creating database.ĬREATE DATABASE IF NOT EXISTS database1 CHARACTER SET latin1 COLLATE latin1_swedish_ci

MySQL GROUP BY and HAVING Clause commandĬreate Database and table commands Command.

In this SQL Query cheat sheet you will learn