TAILIEUCHUNG - MySQL 2

MySQL Cheat Sheet The MySQL cheat sheet is designed to act as a reminder and reference sheet, listing useful information about MySQL. It includes a list of the available functions in MySQL, as well as data types. It also includes a list of MySQL functions available in PHP, | MySQL Cheat Sheet Mathematical ABS SIGN MOD FLOOR CEILING ROUND MySQL Brought To You By Control Flow IFNULL NULLIF IF String ASCII DIV EXP LN LOG LOG2 LOG10 ROW POWER SQRT PI COS SIN TAN ACOS ASIN ATAN ATAN2 COT RAND LEAST GREATEST DEGREES RADIANS TRUNCATE Date and Time DAYOFWEEK WEEKDAY DAYOFMONTH DAYOFYEAR MONTH DAYNAME MONTHNAME QUARTER WEEK YEAR YEARWEEK HOUR MINUTE SECOND PERIOD ADD DATE SUB ADDDATE SUBDATE EXTRACT TO_DAYS FROM_DAYS DATE-FORMAT TIME-FORMAT CURRENT-DATE CURRENT-TIME NOW SYSDATE UNIX_TIM ESTAMP FROM_UNIXTIME SEC_TO_TIME TIME-TO SEC Group COUNT AVG MIN MAX SUM GROUP CONCAT VARIANCE STD STDDEV DATA TYPES MYSQL FUNCTIONS IN PHP CHAR String length 0 - 255 my sq 1 .affected- TO ws VARCHAR String length 0 - 255 mysql-dose TINYTEXT String length 0 - 255 mysql-Connect TEXT String length 0 - 65535 mysql_data_seek BLOB String length 0 - 65535 mysql_db_name MEDIUMTEXT String length 0 - 16777215 mysql_errno MEDIUMBLOB String length 0 - 16777215 mysql_error LONGTEXT String length 0 - 4294967295 mysql_fetch_array LONGBLOB String length 0 - 4294967295 mysql_fetch_assoc TINYINT Integer -128 to 127 mysql-fetch-field SM ALLI NT Integer -32768 to 32767 mysql-fetch-lengths MEDIUMINT Integer -8388608 to 8388607 mysq l_fetch_object IN1 Integer -2147483648 to mysq 1-fetch ro w 2147483647 mysql_fleld_flags BIGINT Int -9223372036854775808 mysql_field_len to 9223372036854775807 mysql-field name FLOAT Decimal precise to 23 digits mysql_fleld_seek DOUBLE Decimal 24 to 53 digits mysql_fleld_table DECIMAL DOUBLE stored as string mysql_field_type DATE YYYY-MM-DD my sq 1 -free .result DATETIME YYYY-MM-DD HH MM SS mysql_insert_id TIMESTAMP YYYYMMDDHHMMSS mysql-hst-dbs TIME HH MM SS mysql_list_processes ENUM One of preset options mysql-list-tables SET Selection of preset options mysql_num_fields mysql_num_rows Note UNSIGNED TINYINT SMALLINT mysql-pconnect MEDIUMINT INT BIGINT have the same mysqLquery range of values but start at 0 . .

• Kỹ thuật lập trình
• máy tính
• mạng máy tính
• internet
• phần mềm
• ứng dụng
• lập trình
• dữ liệu
• MySQL 2
• Phần cứng máy tính
• lắp ráp máy tính
• sửa chữa máy tính
• lỗi máy tính
• hệ thống mạch máy tính
• điện máy tính
• Tài liệu máy tính