Tag: MySQL
If you mainly use open-source programs in your company, and there are several MS SQL server databases, you can consider moving to a MySQL database.Below are a few reasons why you might want...
MySQL is probably the best known relational database management system. As the "M" of the LAMP web development platform, this open-source solution is very popular worldwide.However, its...
MySQL DISTINCT statement is used to remove duplicates from the result set. The DISTINCT operator may be used only with SELECT operators. Syntax DISTINCT operator in MySQL SELECT DISTINCT FROM...
MySQL FROM statement is used to display tables and any associations required for querying in MySQL. Syntax of FROM statement in MySQL FROM table1 [ { INNER JOIN | LEFT [OUTER] JOIN | RIGHT...
MySQL statement SELECT LIMIT is used to extract records from one or more tables into MySQL and limit the number of records to be returned based on the limit value. Syntax of SELECT LIMIT in...
MySQL statement SELECT is used to extract records from one or more tables to MySQL. Simple syntax for SELECT statement in MySQL SELECT expressions FROM tables [WHERE conditions]; The full...
In MySQL, you can use the SHOW GRANTS statement to display all grant information for the user. This will display the privileges that have been assigned to the user with the GRANT command. Syntax...
The RENAME USER statement is used to rename a user in a MySQL database. Syntax of RENAME USER statement in MySQL RENAME USER user_name TO new_name; Parameters and arguments of the...
The SET PASSWORD statement is used to change a user password in a MySQL database. Syntax to change the password with the SET PASSWORD statement in MySQL SET PASSWORD [ FOR user_name ] = SET...
MySQL Server supports the validate-config option, which allows checking the startup configuration for problems without starting the server in normal operation mode:If no errors are found,...
MySQL indexes: Starting with MySQL 5.7, you can create indexes for expressions, or functional indexes using the generated columns. Basically you need to first use the generated column to define a...
The DROP USER statement is used to delete a user from a MySQL database. Syntax of DROP USER statement in MySQL DROP USER user_name; Options and arguments of the statementuser_name - the...
The CREATE USER statement creates a database account that allows you to log into a MySQL database. Syntax for CREATE USER statement in MySQL CREATE USER user_name IDENTIFIED BY [ PASSWORD ]...
SQL Server has an interesting feature called Linked Servers. It is about linking other databases to SQL Server and using their data as local. There are many powerful open source systems written...
Thinking about security in MySQL installation, you can consider a wide range of possible procedures/recommendations and their impact on the security of your MySQL server and related...
Reflecting on security in MySQL installation, you can consider a wide range of possible procedures/recommendations and their impact on the security of your MySQL server and related...