The general syntax of SET statement is :
SET variable_assignment [, variable_assignment] …
variable_assignment : user_var_name = expr | [GLOBAL | SESSION] system_var_name = expr | [@@global. | @@session. | @@]system_var_name = expr
SET statement is used for assigning the values for different types of variables which affects the operation of your client or the server. In [...]
In this section we are covering the topics like ANALYZE TABLE, BACKUP TABLE, CHECK TABLE, CHECKSUM TABLE, OPTIMIZE TABLE, REPAIR TABLE, RESTORE TABLE Syntax.
ANALYZE TABLE Syntax
The general syntax of ANALYZE TABLE statement is:
ANALYZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE tbl_name [, tbl_name] …
This syntax is used to analyze and store the key distribution to a table. [...]
In MySQL user account information’s are stored in mysql database tables. In this section we will describe you about Create User, Drop User, Grant Syntax, Rename User, Revoke Syntax and Set Password Syntax.
CREATE USER Syntax
The general syntax of CREATE USER statement is :
CREATE USER user [IDENTIFIED BY [PASSWORD] ‘password’]…..
In MySQL version 5.0.2 include the [...]
MySQL5.0 supports local transactions by statements like START TRANSACTION, SET AUTOCOMMIT, COMMIT and ROLLBACK. Transaction means a group of SQL Statements, which executes as a unit. And MySQL either executes all the statement successfully or it doesn’t execute anyone. This can be achieved by the commit and rollback. When all the statements executes successfully then [...]
MySQL can manage the contention for table contents by using Locking :
Internal Locking can be performed in the MySQL server itself for managing the contention for table content by multiple threads. This locking is known as internal because this locking is performed entirely by the server and it does not involve any other programs.
External locking [...]
 |
