[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] failover features replication fault-tolerance replication FIELDS clause LOAD DATA INFILE statement FILE privilege 2nd files dump log files binary logs error logs query logs rotating slow query logs turning on filtered data security tips 2nd first normal form (1NF) 2nd 3rd 4th 5th FLOAT column type float data type floating point numbers floor() function flow control functions 2nd 3rd 4th FLUSH command caches, clearing 2nd 3rd FLUSH PRIVILEGES statement 2nd FLUSH TABLES command MERGE tables FOREIGN KEY keyword found rows() function fragmentation MyISAM tables FROM clause joins subqueries derived table 2nd 3rd full joins full-text searching boolean full-text search 2nd 3rd 4th 5th MyISAM tables 2nd 3rd 4th 5th 6th FULLTEXT keyword functional dependencies concepts and terminology functions abs() adddate() avg() BENCHMARK queries 2nd benchmark() built-in CASE 2nd cast 2nd ceiling() concat() convert() 2nd count() curdate() curtime() date and time 2nd 3rd 4th 5th 6th 7th dayname() encrypt() extract floor() flow control 2nd 3rd 4th found rows() grouping 2nd 3rd IF last insert id() length() LIKE wildcard matching 2nd 3rd load file locate() lower() MATCH max() md5() min() mod() now() numeric 2nd 3rd 4th 5th 6th operators arithmethic comparison 2nd 3rd 4th logical 2nd 3rd 4th password() power() quote() rand() replace() RLIKE regular expression matching 2nd 3rd 4th 5th round() soundex() sqrt() std() STRCMP string comparison 2nd 3rd string string comparison 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th string processing 2nd 3rd 4th 5th subdate() substring() sum() timestamp trim() upper() |