MySql Commands Names

Here are listed the most commonly used MYSQL Statements and clauses , mysql commands


ALTER DATABASE


ALTER TABLE


ALTER VIEW


ANALYZE TABLE


BACKUP TABLE


CACHE INDEX


CHANGE MASTER TO


CHECK TABLE


CHECKSUM TABLE


COMMIT


CREATE DATABASE


CREATE INDEX


CREATE TABLE


CREATE VIEW


DELETE


DESCRIBE


DO


DROP DATABASE


DROP INDEX


DROP TABLE


DROP USER


DROP VIEW


EXPLAIN


FLUSH


GRANT


HANDLER


INSERT


JOIN


KILL


LOAD DATA FROM MASTER


LOAD DATA INFILE


LOAD INDEX INTO CACHE


LOAD TABLE...FROM MASTER


LOCK TABLES


OPTIMIZE TABLE


PURGE MASTER LOGS


RENAME TABLE


REPAIR TABLE


REPLACE


RESET


RESET MASTER


RESET SLAVE


RESTORE TABLE


REVOKE


ROLLBACK


ROLLBACK TO SAVEPOINT


SAVEPOINT


SELECT


SET


SET PASSWORD


SET SQL_LOG_BIN


SET TRANSACTION


SHOW BINLOG EVENTS


SHOW CHARACTER SET


SHOW COLLATION


SHOW COLUMNS


SHOW CREATE DATABASE


SHOW CREATE TABLE


SHOW CREATE VIEW


SHOW DATABASES


SHOW ENGINES


SHOW ERRORS


SHOW GRANTS


SHOW INDEX


SHOW INNODB STATUS


SHOW LOGS


SHOW MASTER LOGS


SHOW MASTER STATUS


SHOW PRIVILEGES


SHOW PROCESSLIST


SHOW SLAVE HOSTS


SHOW SLAVE STATUS


SHOW STATUS


SHOW TABLE STATUS


SHOW TABLES


SHOW VARIABLES


SHOW WARNINGS


START SLAVE


START TRANSACTION


STOP SLAVE


TRUNCATE TABLE


UNION


UNLOCK TABLES


USE




String Functions


AES_DECRYPT


AES_ENCRYPT


ASCII


BIN


BINARY


BIT_LENGTH


CHAR


CHAR_LENGTH


CHARACTER_LENGTH


COMPRESS


CONCAT


CONCAT_WS


CONV


DECODE


DES_DECRYPT


DES_ENCRYPT


ELT


ENCODE


ENCRYPT


EXPORT_SET


FIELD


FIND_IN_SET


HEX


INET_ATON


INET_NTOA


INSERT


INSTR


LCASE


LEFT


LENGTH


LOAD_FILE


LOCATE


LOWER


LPAD


LTRIM


MAKE_SET


MATCH AGAINST


MD5


MID


OCT


OCTET_LENGTH


OLD_PASSWORD


ORD


PASSWORD


POSITION


QUOTE


REPEAT


REPLACE


REVERSE


RIGHT


RPAD


RTRIM


SHA


SHA1


SOUNDEX


SPACE


STRCMP


SUBSTRING


SUBSTRING_INDEX


TRIM


UCASE


UNCOMPRESS


UNCOMPRESSED_LENGTH


UNHEX


UPPER




Date and Time Functions


ADDDATE


ADDTIME


CONVERT_TZ


CURDATE


CURRENT_DATE


CURRENT_TIME


CURRENT_TIMESTAMP


CURTIME


DATE


DATE_ADD


DATE_FORMAT


DATE_SUB


DATEDIFF


DAY


DAYNAME


DAYOFMONTH


DAYOFWEEK


DAYOFYEAR


EXTRACT


FROM_DAYS


FROM_UNIXTIME


GET_FORMAT


HOUR


LAST_DAY


LOCALTIME


LOCALTIMESTAMP


MAKEDATE


MAKETIME


MICROSECOND


MINUTE


MONTH


MONTHNAME


NOW


PERIOD_ADD


PERIOD_DIFF


QUARTER


SEC_TO_TIME


SECOND


STR_TO_DATE


SUBDATE


SUBTIME


SYSDATE


TIME


TIMEDIFF


TIMESTAMP


TIMESTAMPDIFF


TIMESTAMPADD


TIME_FORMAT


TIME_TO_SEC


TO_DAYS


UNIX_TIMESTAMP


UTC_DATE


UTC_TIME


UTC_TIMESTAMP


WEEK


WEEKDAY


WEEKOFYEAR


YEAR


YEARWEEK




Mathematical and Aggregate Functions


ABS


ACOS


ASIN


ATAN


ATAN2


AVG


BIT_AND


BIT_OR


BIT_XOR


CEIL


CEILING


COS


COT


COUNT


CRC32


DEGREES


EXP


FLOOR


FORMAT


GREATEST


GROUP_CONCAT


LEAST


LN


LOG


LOG2


LOG10


MAX


MIN


MOD


PI


POW


POWER


RADIANS


RAND


ROUND


SIGN


SIN


SQRT


STD


STDDEV


SUM


TAN


TRUNCATE


VARIANCE




Flow Control Functions


CASE


IF


IFNULL


NULLIF




Command-Line Utilities


comp_err


isamchk


make_binary_distribution


msql2mysql


my_print_defaults


myisamchk


myisamlog


myisampack


mysqlaccess


mysqladmin


mysqlbinlog


mysqlbug


mysqlcheck


mysqldump


mysqldumpslow


mysqlhotcopy


mysqlimport


mysqlshow


perror




Perl API - using functions and methods built into the Perl DBI with MySQL


available_drivers


begin_work


bind_col


bind_columns


bind_param


bind_param_array


bind_param_inout


can


clone


column_info


commit


connect


connect_cached


data_sources


disconnect


do


dump_results


err


errstr


execute


execute_array


execute_for_fetch


fetch


fetchall_arrayref


fetchall_hashref


fetchrow_array


fetchrow_arrayref


fetchrow_hashref


finish


foreign_key_info


func


get_info


installed_versions




last_insert_id


looks_like_number


neat


neat_list


parse_dsn


parse_trace_flag


parse_trace_flags


ping


prepare


prepare_cached


primary_key


primary_key_info


quote


quote_identifier


rollback


rows


selectall_arrayref


selectall_hashref


selectcol_arrayref


selectrow_array


selectrow_arrayref


selectrow_hashref


set_err


state


table_info


table_info_all


tables


trace


trace_msg


type_info


type_info_all


Attributes for Handles




PHP API - using functions built into PHP with MySQL


mysql_affected_rows


mysql_change_user


mysql_client_encoding


mysql_close


mysql_connect


mysql_create_db


mysql_data_seek


mysql_db_name


mysql_db_query


mysql_drop_db


mysql_errno


mysql_error


mysql_escape_string


mysql_fetch_array


mysql_fetch_assoc


mysql_fetch_field


mysql_fetch_lengths


mysql_fetch_object


mysql_fetch_row


mysql_field_flags


mysql_field_len


mysql_field_name


mysql_field_seek


mysql_field_table


mysql_field_type


mysql_free_result


mysql_get_client_info


mysql_get_host_info


mysql_get_proto_info


mysql_get_server_info


mysql_info


mysql_insert_id


mysql_list_dbs


mysql_list_fields


mysql_list_processes


mysql_list_tables


mysql_num_fields


mysql_num_rows


mysql_pconnect


mysql_ping


mysql_query


mysql_real_escape_string


mysql_result


mysql_select_db


mysql_stat


mysql_tablename


mysql_thread_id


mysql_unbuffered_query

0 comments:

Post a Comment