The WHERE clause
The WHERE clause is used to extract only those records that fulfill a specified criterion.
Syntax
SELECT column_name(s)
FROM table_name
WHERE column_name operator value
FROM table_name
WHERE column_name operator value
MySQL Select with PHP
Select Data From a Database Table
The SELECT statement is used to select data from a database.
Syntax
SELECT column_name(s)
FROM table_name
FROM table_name
MySQL Insert with PHP
Insert Data Into a Database Table
The INSERT INTO statement is used to add new records to a database table.
Syntax
It is possible to write the INSERT INTO statement in two forms.
Creating MySQL Database and Tables with PHP
Create a Database
The CREATE DATABASE statement is used to create a database in MySQL.
We must add the CREATE DATABASE statement to the mysqli_query() function to execute the command.
Connecting to the MySQL Server with PHP
Use the PHP mysqli_connect() function to open a new connection to the MySQL server.
Open a Connection to the MySQL Server
Before we can access data in a database, we must open a connection to the MySQL server.
mysqlhotcopy Utility
The mysqlhotcopy utility is a perl script that uses several basic system and SQL commands to backup a database. More specifically, it will lock the tables, flush the tables, make a copy, and unlock the tables. Although it is the fastest method available for backing up a MySQL database, it is limited to backing up only those databases residing on the same machine as where it is executed.
MySQL Revoke Command
The REVOKE command is used to rescind privileges previously granted to a user. Its syntax is:
REVOKE priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
FROM user_name [, user_name ...]
MySQL Grant Command
The GRANT function is used both to create new users, and to assign privileges to users. Its syntax is:
mysql>GRANT priv_type [(column_list)] [, priv_type [(column_list)] ...]
ON {tbl_name | * | *.* | db_name.*}
TO user_name [IDENTIFIED BY 'password']
[, user_name [IDENTIFIED BY 'password'] ...]
[WITH GRANT OPTION]
Securing a MySQL Database
Security should be the first thought that comes to a MySQL administrator’s mind after creating a new database. Privilege as was discussed in the section, “The Privilege Tables”, securing a database is accomplished through modifications made to the tables found in the mysql database. In this section,
Using mysqladmin
The mysqladmin program is used to administrate various aspects of the MySQL database server. Using it, the administrator can perform tasks such as: create and delete databases, shutdown the database server, update the privilege tables, and view running MySQL processes. The general syntax is:
Read More
