Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] savepoints definition of transactions, controlling 2nd 3rd 4th scalability definition of schema compared to databases definition of scripts executing with MySQL Query Browser searches case-sensitivity SELECT columns retrieving all 2nd retrieving individually 2nd retrieving multiple 2nd purpose of SELECT clauses sequencing 2nd SELECT statements AS keyword 2nd concatenating fields SELECT. 2nd 3rd [See also DISTINCT] [See also WHERE clauses] [See also queries] self joins compared to subqueries overview 2nd semicolons statements, terminating server software. [See also client-server software] server-based results fomatting compared to client-based SET PASSWORD statements 2nd sets matching regular expressions 2nd SHOW overview 2nd SHOW PROCEDURE STATUS SHOW. [See also DESCRIBE] signed datatypes sing values checking against with WHERE clauses 2nd sorting data by multiple columns 2nd 3rd case sensitivity in descending order 2nd overview 2nd SOUNDEX() function overview 2nd spaces removing RTRIM function 2nd special characters regular expressions matching 2nd SQL compared to application filtering overview 2nd syntax portability startup problems, diagnosing 2nd statement syntax 2nd statements case sensitivity formatting SELECT contenating fields terminating with semicolons white space statements. [See also keywords] stopwords definition of stored procedures creating 2nd 3rd cursors. [See cursors] disadvantages of 2nd dropping 2nd executing 2nd inspecting 2nd intelligent stored procedures, building 2nd 3rd overview 2nd parameters 2nd 3rd 4th uses for 2nd string datatypes 2nd 3rd subqueries as calculated fields 2nd 3rd combining queries with definition of filtering by 2nd 3rd 4th formatting effectively order of process self joins self joins, comparing Update statements WHERE clauses subqueries. [See also queries] SUM() overview 2nd SUM() function multiple columns syntax joins syntax (statements) 2nd |