| 1.Introduction | ||
| 1.1.Introduction( 5 ) | 1.4.Operator( 3 ) | |
| 1.2.Command( 5 ) | 1.5.semicolon( 1 ) | |
| 1.3.comments( 4 ) | ||
| 2.Select Query | ||
| 2.1.Introduction( 10 ) | 2.13.DISTINCT( 2 ) | |
| 2.2.WHERE( 3 ) | 2.14.EXISTS( 4 ) | |
| 2.3.GROUP BY( 6 ) | 2.15.NOT EXISTS( 1 ) | |
| 2.4.ORDER BY( 12 ) | 2.16.IN( 4 ) | |
| 2.5.HAVING( 3 ) | 2.17.IS NULL( 4 ) | |
| 2.6.LIMIT( 5 ) | 2.18.Like( 2 ) | |
| 2.7.Column( 4 ) | 2.19.Logic Operators( 2 ) | |
| 2.8.Alias( 4 ) | 2.20.Row Constructor( 3 ) | |
| 2.9.AND OR( 4 ) | 2.21.UNION( 2 ) | |
| 2.10.NOT( 2 ) | 2.22.User Defined Variables( 5 ) | |
| 2.11.AS( 5 ) | 2.23.Full Text Search( 2 ) | |
| 2.12.BETWEEN( 3 ) | ||
| 3.Database | ||
| 3.1.Create Database( 3 ) | 3.3.USE( 1 ) | |
| 3.2.Drop Database( 1 ) | ||
| 4.Table | ||
| 4.1.Create Table( 12 ) | 4.11.Column Modifiers( 1 ) | |
| 4.2.Describe Table Structure( 2 ) | 4.12.Drop Column( 3 ) | |
| 4.3.Alter Table( 6 ) | 4.13.Default( 1 ) | |
| 4.4.Copy Table( 3 ) | 4.14.Key( 6 ) | |
| 4.5.Rename Table( 1 ) | 4.15.PRIMARY KEY( 12 ) | |
| 4.6.TRUNCATE TABLE( 1 ) | 4.16.Foreign Keys( 7 ) | |
| 4.7.Drop Table( 2 ) | 4.17.Unique( 4 ) | |
| 4.8.Temporary Table( 2 ) | 4.18.AUTO_INCREMENT( 4 ) | |
| 4.9.Add Column( 2 ) | 4.19.Index( 12 ) | |
| 4.10.Alter Column( 3 ) | 4.20.COLLATION Character Set( 16 ) | |
| 5.Table Join | ||
| 5.1.Cross Join( 3 ) | 5.8.STRAIGHT_JOIN( 1 ) | |
| 5.2.Inner Join( 3 ) | 5.9.ANSI 92 Join( 4 ) | |
| 5.3.Left Join( 8 ) | 5.10.USING( 3 ) | |
| 5.4.RIGHT JOIN( 3 ) | 5.11.UPDATE( 5 ) | |
| 5.5.Self Join( 1 ) | 5.12.DELETE( 4 ) | |
| 5.6.Natural Join( 1 ) | 5.13.Subquery( 2 ) | |
| 5.7.NATURAL LEFT JOIN( 2 ) | ||
| 6.Subquery | ||
| 6.1.Introduction( 14 ) | 6.5.Exists( 2 ) | |
| 6.2.ALL( 3 ) | 6.6.IN( 1 ) | |
| 6.3.ANY( 2 ) | 6.7.SOME( 1 ) | |
| 6.4.Correlated Subqueries( 1 ) | ||
| 7.Insert Update Delete | ||
| 7.1.Insert( 9 ) | 7.5.Default( 1 ) | |
| 7.2.Insert Into Select( 2 ) | 7.6.REPLACE INTO( 1 ) | |
| 7.3.Delete( 6 ) | 7.7.Quotation Mark( 2 ) | |
| 7.4.Update( 7 ) | 7.8.TRANSACTION( 4 ) | |
| 8.Logic Operator | ||
| 8.1.Introduction( 2 ) | 8.4.OR( 3 ) | |
| 8.2.AND( 3 ) | 8.5.XOR( 3 ) | |
| 8.3.NOT( 4 ) | ||
| 9.View | ||
| 9.1.Create View( 10 ) | 9.5.View Structure( 2 ) | |
| 9.2.Alter View( 1 ) | 9.6.Drop View( 1 ) | |
| 9.3.Updatable View( 1 ) | 9.7.Nested View( 1 ) | |
| 9.4.Check( 1 ) | 9.8.Explain View( 1 ) | |
| 10.Data Types | ||
| 10.1.BIGINT( 1 ) | 10.14.INT( 1 ) | |
| 10.2.Bit( 10 ) | 10.15.INTERVAL( 1 ) | |
| 10.3.BLOB( 1 ) | 10.16.Introduction( 10 ) | |
| 10.4.Boolean( 3 ) | 10.17.MEDIUMINT( 1 ) | |
| 10.5.Char Varchar( 6 ) | 10.18.NULL( 7 ) | |
| 10.6.Date( 4 ) | 10.19.Set( 9 ) | |
| 10.7.DATETIME( 1 ) | 10.20.SMALLINT( 4 ) | |
| 10.8.Decimal( 3 ) | 10.21.String( 11 ) | |
| 10.9.Double( 1 ) | 10.22.TEXT( 1 ) | |
| 10.10.ENUM( 7 ) | 10.23.TIME( 1 ) | |
| 10.11.FLOAT( 3 ) | 10.24.timestamp( 6 ) | |
| 10.12.FULLTEXT( 1 ) | 10.25.TINYINT( 2 ) | |
| 10.13.hexadecimal( 5 ) | 10.26.YEAR( 6 ) | |
| 11.Procedure Function | ||
| 11.1.Introduction( 5 ) | 11.29.TEXT( 2 ) | |
| 11.2.Delimiter( 1 ) | 11.30.Default( 2 ) | |
| 11.3.Function( 11 ) | 11.31.Begin End( 1 ) | |
| 11.4.Function Returning( 6 ) | 11.32.Buildin Functions( 5 ) | |
| 11.5.Procedure( 12 ) | 11.33.Declare( 1 ) | |
| 11.6.Call( 6 ) | 11.34.DEFINER( 1 ) | |
| 11.7.Parameters( 8 ) | 11.35.Output( 3 ) | |
| 11.8.Operator( 2 ) | 11.36.Select Into( 3 ) | |
| 11.9.Variable Assignment( 1 ) | 11.37.Update Table( 2 ) | |
| 11.10.Variable Declaration( 2 ) | 11.38.Insert( 3 ) | |
| 11.11.Variable Scope( 5 ) | 11.39.Delete( 1 ) | |
| 11.12.Set( 4 ) | 11.40.Create Table( 3 ) | |
| 11.13.IF statement( 5 ) | 11.41.Drop Table( 1 ) | |
| 11.14.While( 3 ) | 11.42.Dynamic Statement( 2 ) | |
| 11.15.CASE( 5 ) | 11.43.DETERMINISTIC( 1 ) | |
| 11.16.ITERATE( 1 ) | 11.44.Condition HANDLER( 10 ) | |
| 11.17.LEAVE( 2 ) | 11.45.Predefined Exceptions( 3 ) | |
| 11.18.LOOP( 5 ) | 11.46.Procedure Data Dictionary( 5 ) | |
| 11.19.Repeat until( 3 ) | 11.47.Function Data Dictionary( 3 ) | |
| 11.20.CHAR( 1 ) | 11.48.Transaction( 7 ) | |
| 11.21.BIGINT( 2 ) | 11.49.Lock( 1 ) | |
| 11.22.DATE( 3 ) | 11.50.Perl( 2 ) | |
| 11.23.DATETIME( 1 ) | 11.51.PHP( 3 ) | |
| 11.24.DOUBLE( 1 ) | 11.52.Java( 2 ) | |
| 11.25.FLOAT( 2 ) | 11.53.CSharp( 2 ) | |
| 11.26.INT( 1 ) | 11.54.Python( 1 ) | |
| 11.27.VARCHAR( 2 ) | 11.55.VB.net( 1 ) | |
| 11.28.NUMERIC( 2 ) | ||
| 12.Cursor | ||
| 12.1.Declare( 3 ) | 12.4.Close( 1 ) | |
| 12.2.Open( 1 ) | 12.5.Handler( 1 ) | |
| 12.3.Fetch( 7 ) | ||
| 13.Trigger | ||
| 13.1.Introduction( 3 ) | 13.4.Drop Trigger( 2 ) | |
| 13.2.After Trigger( 2 ) | 13.5.NEW( 4 ) | |
| 13.3.Before Trigger( 5 ) | 13.6.Trigger Data Dictionary( 1 ) | |
| 14.Date Time Functions | ||
| 14.1.Introduction( 9 ) | 14.31.MONTHNAME( 3 ) | |
| 14.2.ADDDATE( 2 ) | 14.32.NOW( 3 ) | |
| 14.3.ADDTIME( 2 ) | 14.33.PERIOD_ADD( 1 ) | |
| 14.4.CONVERT_TZ( 2 ) | 14.34.PERIOD_DIFF( 1 ) | |
| 14.5.CURDATE( 2 ) | 14.35.QUARTER( 2 ) | |
| 14.6.CURRENT_TIMESTAMP( 1 ) | 14.36.SECOND( 1 ) | |
| 14.7.CURTIME( 2 ) | 14.37.SEC_TO_TIME( 1 ) | |
| 14.8.DATE( 1 ) | 14.38.SLEEP( 1 ) | |
| 14.9.DATEDIFF( 2 ) | 14.39.STR_TO_DATE( 4 ) | |
| 14.10.DATE_ADD( 42 ) | 14.40.SUBDATE( 3 ) | |
| 14.11.DATE_FORMAT( 40 ) | 14.41.SUBTIME( 2 ) | |
| 14.12.DATE_SUB( 29 ) | 14.42.SYSDATE( 2 ) | |
| 14.13.DAYNAME( 4 ) | 14.43.TIME( 2 ) | |
| 14.14.DAYOFMONTH( 4 ) | 14.44.TIMEDIFF( 2 ) | |
| 14.15.DAYOFWEEK( 2 ) | 14.45.TIMESTAMP( 2 ) | |
| 14.16.DAYOFYEAR( 2 ) | 14.46.TIMESTAMPADD( 9 ) | |
| 14.17.EXTRACT( 21 ) | 14.47.TIMESTAMPDIFF( 11 ) | |
| 14.18.FROM_DAYS( 1 ) | 14.48.TIME_FORMAT( 2 ) | |
| 14.19.FROM_UNIXTIME( 3 ) | 14.49.TIME_TO_SEC( 2 ) | |
| 14.20.GET_FORMAT( 18 ) | 14.50.TO_DAYS( 3 ) | |
| 14.21.HOUR( 1 ) | 14.51.UNIX_TIMESTAMP( 3 ) | |
| 14.22.INTERVAL( 3 ) | 14.52.UTC_DATE( 1 ) | |
| 14.23.LAST_DAY( 4 ) | 14.53.UTC_TIME( 1 ) | |
| 14.24.LOCALTIME( 1 ) | 14.54.UTC_TIMESTAMP( 1 ) | |
| 14.25.LOCALTIMESTAMP( 1 ) | 14.55.WEEK( 2 ) | |
| 14.26.MAKEDATE( 5 ) | 14.56.WEEKDAY( 3 ) | |
| 14.27.MAKETIME( 1 ) | 14.57.WEEKOFYEAR( 1 ) | |
| 14.28.MICROSECOND( 2 ) | 14.58.YEAR( 3 ) | |
| 14.29.MINUTE( 1 ) | 14.59.YEARWEEK( 3 ) | |
| 14.30.MONTH( 6 ) | ||
| 15.Comparison Functions Operators | ||
| 15.1.Introduction( 1 ) | 15.8.INTERVAL( 1 ) | |
| 15.2.BETWEEN AND( 5 ) | 15.9.IS NULL ISNULL( 7 ) | |
| 15.3.COALESCE( 1 ) | 15.10.IS( 2 ) | |
| 15.4.Equal( 5 ) | 15.11.LEAST( 5 ) | |
| 15.5.Greater than( 4 ) | 15.12.Less than( 5 ) | |
| 15.6.GREATEST( 6 ) | 15.13.Not equal( 5 ) | |
| 15.7.IN( 6 ) | 15.14.NULL safe equal( 1 ) | |
| 16.Aggregate Functions | ||
| 16.1.Introduction( 3 ) | 16.8.STDDEV_POP( 1 ) | |
| 16.2.AVG( 5 ) | 16.9.STDDEV_SAMP( 1 ) | |
| 16.3.Count( 8 ) | 16.10.SUM( 7 ) | |
| 16.4.GROUP_CONCAT( 1 ) | 16.11.VARIANCE( 1 ) | |
| 16.5.MAX( 4 ) | 16.12.VAR_POP( 1 ) | |
| 16.6.MIN( 3 ) | 16.13.VAR_SAMP( 1 ) | |
| 16.7.STD( 3 ) | ||
| 17.Cast Functions Operators | ||
| 17.1.Introduction( 1 ) | 17.3.CAST( 7 ) | |
| 17.2.BINARY( 1 ) | ||
| 18.Control Flow Functions | ||
| 18.1.Introdunction( 1 ) | 18.4.IFNULL( 6 ) | |
| 18.2.CASE( 5 ) | 18.5.NULLIF( 2 ) | |
| 18.3.IF( 8 ) | ||
| 19.Encryption Compression Functions | ||
| 19.1.Introduction( 1 ) | 19.9.ENCODE( 1 ) | |
| 19.2.AES_DECRYPT( 1 ) | 19.10.ENCRYPT( 2 ) | |
| 19.3.AES_ENCRYPT( 2 ) | 19.11.MD5( 2 ) | |
| 19.4.COMPRESS( 4 ) | 19.12.OLD_PASSWORD( 2 ) | |
| 19.5.CRC32( 1 ) | 19.13.PASSWORD( 2 ) | |
| 19.6.DECODE( 1 ) | 19.14.SHA( 2 ) | |
| 19.7.DES_DECRYPT( 1 ) | 19.15.UNCOMPRESS( 1 ) | |
| 19.8.DES_ENCRYPT( 1 ) | 19.16.UNCOMPRESSED_LENGTH( 1 ) | |
| 20.Information Functions | ||
| 20.1.Introduction( 1 ) | 20.9.FOUND_ROWS( 3 ) | |
| 20.2.BENCHMARK( 1 ) | 20.10.LAST_INSERT_ID( 2 ) | |
| 20.3.CHARSET( 3 ) | 20.11.ROW_COUNT( 1 ) | |
| 20.4.COERCIBILITY( 3 ) | 20.12.SCHEMA( 1 ) | |
| 20.5.COLLATION( 2 ) | 20.13.SESSION_USER( 1 ) | |
| 20.6.CONNECTION_ID( 1 ) | 20.14.SYSTEM_USER( 1 ) | |
| 20.7.CURRENT_USER( 1 ) | 20.15.USER( 2 ) | |
| 20.8.DATABASE( 1 ) | 20.16.VERSION( 2 ) | |
| 21.Math Numeric Functions | ||
| 21.1.Introduction( 10 ) | 21.19.FORMAT( 1 ) | |
| 21.2.Arithmetic Operators( 7 ) | 21.20.LN( 2 ) | |
| 21.3.ABS( 2 ) | 21.21.LOG( 2 ) | |
| 21.4.ACOS( 2 ) | 21.22.LOG10( 1 ) | |
| 21.5.ASIN( 2 ) | 21.23.LOG2( 1 ) | |
| 21.6.ATAN( 2 ) | 21.24.MOD( 4 ) | |
| 21.7.BIT_AND( 1 ) | 21.25.Modulo( 1 ) | |
| 21.8.BIT_OR( 1 ) | 21.26.OCT( 1 ) | |
| 21.9.BIT_XOR( 1 ) | 21.27.PI( 1 ) | |
| 21.10.CEILING( 2 ) | 21.28.POW( 1 ) | |
| 21.11.CONV( 7 ) | 21.29.RADIANS( 1 ) | |
| 21.12.COS( 1 ) | 21.30.RAND( 3 ) | |
| 21.13.COT( 1 ) | 21.31.ROUND( 7 ) | |
| 21.14.CRC32( 1 ) | 21.32.SIGN( 2 ) | |
| 21.15.DEGREES( 1 ) | 21.33.SIN( 1 ) | |
| 21.16.DIV( 1 ) | 21.34.SQRT( 2 ) | |
| 21.17.EXP( 2 ) | 21.35.TAN( 1 ) | |
| 21.18.FLOOR( 2 ) | 21.36.TRUNCATE( 6 ) | |
| 22.Miscellaneous Functions | ||
| 22.1.Introduction( 1 ) | 22.7.IS_USED_LOCK( 1 ) | |
| 22.2.DEFAULT( 1 ) | 22.8.RELEASE_LOCK( 1 ) | |
| 22.3.GET_LOCK( 1 ) | 22.9.SLEEP( 1 ) | |
| 22.4.INET_ATON( 2 ) | 22.10.UUID( 1 ) | |
| 22.5.INET_NTOA( 1 ) | 22.11.VALUES( 1 ) | |
| 22.6.IS_FREE_LOCK( 1 ) | ||
| 23.String Functions | ||
| 23.1.Introduction( 2 ) | 23.25.LPAD( 2 ) | |
| 23.2.ASCII( 2 ) | 23.26.LTRIM( 2 ) | |
| 23.3.BIN( 2 ) | 23.27.MAKE_SET( 5 ) | |
| 23.4.BIT_LENGTH( 2 ) | 23.28.MID( 1 ) | |
| 23.5.CHAR( 1 ) | 23.29.ORD( 2 ) | |
| 23.6.CHARSET( 1 ) | 23.30.QUOTE( 2 ) | |
| 23.7.CHAR_LENGTH( 1 ) | 23.31.REGEXP( 2 ) | |
| 23.8.CONCAT( 5 ) | 23.32.REPEAT( 2 ) | |
| 23.9.CONCAT_WS( 3 ) | 23.33.REPLACE( 3 ) | |
| 23.10.ELT( 5 ) | 23.34.REVERSE( 2 ) | |
| 23.11.EXPORT_SET( 2 ) | 23.35.RIGHT( 2 ) | |
| 23.12.FIELD( 1 ) | 23.36.RPAD( 2 ) | |
| 23.13.FIND_IN_SET( 2 ) | 23.37.RTRIM( 2 ) | |
| 23.14.FORMAT( 4 ) | 23.38.SOUNDEX( 2 ) | |
| 23.15.HEX( 4 ) | 23.39.SOUNDS LIKE( 1 ) | |
| 23.16.INSERT( 4 ) | 23.40.SPACE( 2 ) | |
| 23.17.INSTR( 2 ) | 23.41.STRCMP( 2 ) | |
| 23.18.LCASE( 2 ) | 23.42.SUBSTRING( 7 ) | |
| 23.19.LEFT( 2 ) | 23.43.SUBSTRING_INDEX( 2 ) | |
| 23.20.LENGTH( 2 ) | 23.44.TRIM( 7 ) | |
| 23.21.LIKE( 5 ) | 23.45.UCASE( 1 ) | |
| 23.22.LOAD_FILE( 1 ) | 23.46.UNHEX( 4 ) | |
| 23.23.LOCATE( 3 ) | 23.47.UPPER( 2 ) | |
| 23.24.LOWER( 2 ) | ||
| 24.Regular Expressions | ||
| 24.1.Introduction( 6 ) | 24.8.Occurrences( 3 ) | |
| 24.2.Anchor End( 2 ) | 24.9.One or More( 2 ) | |
| 24.3.Anchor Start( 2 ) | 24.10.REGEXP( 10 ) | |
| 24.4.Any Character( 1 ) | 24.11.Sequence( 4 ) | |
| 24.5.Bracket( 3 ) | 24.12.word( 1 ) | |
| 24.6.character_class( 13 ) | 24.13.Zero or More( 2 ) | |
| 24.7.Not( 6 ) | 24.14.Zero or One( 2 ) | |
| 25.Data Dictionary | ||
| 25.1.db( 1 ) | 25.11.procs_priv( 1 ) | |
| 25.2.func( 1 ) | 25.12.routines( 1 ) | |
| 25.3.help_category( 1 ) | 25.13.time_zone( 1 ) | |
| 25.4.help_keyword( 1 ) | 25.14.time_zone_leap_second( 1 ) | |
| 25.5.help_relation( 1 ) | 25.15.time_zone_name( 1 ) | |
| 25.6.help_topic( 1 ) | 25.16.time_zone_transition( 1 ) | |
| 25.7.host( 1 ) | 25.17.time_zone_transition_type( 1 ) | |
| 25.8.INFORMATION_SCHEMA( 18 ) | 25.18.triggers( 1 ) | |
| 25.9.mysql Table( 2 ) | 25.19.user( 1 ) | |
| 25.10.proc( 1 ) | ||
| 26.MySQL Utilities | ||
| 26.1.DUMP( 6 ) | 26.7.Priority( 4 ) | |
| 26.2.Import Export Data( 5 ) | 26.8.QUIT( 1 ) | |
| 26.3.mysql( 15 ) | 26.9.SHOW WARNINGS( 1 ) | |
| 26.4.mysqldump( 7 ) | 26.10.SHOW( 7 ) | |
| 26.5.mysqlhotcopy( 1 ) | 26.11.STATUS( 1 ) | |
| 26.6.mysqlimport( 1 ) | ||
| 27.Privilege | ||
| 27.1.columns_priv( 1 ) | 27.5.Remote User( 3 ) | |
| 27.2.FLUSH( 1 ) | 27.6.REVOKE( 5 ) | |
| 27.3.Grant( 9 ) | 27.7.tables_priv( 1 ) | |
| 27.4.Local User( 2 ) | 27.8.User( 5 ) | |