Introduction to Mysql
A database is a separate application that stores a collection of data
|
Mysql Installation
All downloads for MySQL are located at MySQL Downloads.
|
Mysql Administration
Running and Shutting down MySQL Server
|
MySQL PHP Syntax
PHP is the most popular one
because of its web application development capabilities.
|
MySQL Connection
MySQL Connection using mysql binary
|
MySQL Create Database
You would need special privilege to create or to delete a MySQL database
|
MySQL Drop Database
Drop Database using mysqladmin
|
Mysql Select Database
Once you get connection with MySQL server,it is required to select a
particular database to work with.
|
MySQL Data Types
Properly defining the fields in a table is important to the overall
optimization of your database.
|
MySQL Create Table
The Table creation command requires.
|
MySQL Drop Table
It is very easy to drop an existing MySQL table.
|
MySQL Insert Query
To insert data into MySQL table you would need to use SQL INSERT INTO command.
|
MySQL Select Query
The SQL SELECT command is used to fetch data from MySQL database.
|
MySQL Where Clause
We have seen SQL SELECT command to fetch data from MySQL table. We can
use a conditional clause called WHERE clause to filter out results. Using
WHERE clause we can specify a selection criteria to select required records from
a table.
|
MySQL Update Query
There may be a requirement where existing data in a MySQL table need to be
modified. You can do so by using SQL UPDATE command. This will modify any
field value of any MySQL table.
|
MySQL Delete Query
If you want to delete a record from any MySQL table then you can use SQL
command DELETE FROM. You can use this command at mysql prompt as well as
in any script like PHP.
|
MySQL Like Clause
We have seen SQL SELECT command to fetch data from MySQL table. We can
also use a conditional clause called WHERE clause to select required
records.
|
MySQL Sorting Results
We have seen SQL SELECT command to fetch data from MySQL table. When
you select rows, the MySQL server is free to return them in any order, unless
you instruct it otherwise by saying how to sort the result. But you sort a
result set by adding an ORDER BY clause that names the column or columns you
want to sort by.
|
MySQL Using Join
The act of joining in
MySQL refers to smashing two or more tables into a single table.
|
MySQL Null Values
when we try to give a condition which compare
field or column value to NULL it does not work properly.
|
MySQL Regexps
MySQL supports
another type of pattern matching operation based on regular expressions and the
REGEXP operator.
|
MySQL Transactions
A transaction is a sequential group of database manipulation operations,
which is performed as if it were one single work unit.
|
MySQL Alter Command
MySQL ALTER command is very useful when you want to change a name of
your table.
|
MySQL Indexes
A database index is a data structure that improves the speed of operations in
a table.
|
MySQL Temporary Tables
The temporary tables could be very useful in some cases to keep temporary
data.
|
MySQL Clone Tables
There may be a situation when you need an exact copy of a table, and CREATE
TABLE.
|
MySQL Database Info
There are three information which you would like to have from MySQL.
|
MySQL Using Sequences
Sequences are frequently used in databases.
|
MySQL Handling Duplicates
Tables or result sets sometimes contain duplicate records.
|
Mysql Injection
Injection usually occurs when you ask a user for input, like their name, and
instead of a name.
|
MySQL Database Export
Exporting Data with the SELECT ... INTO OUTFILE Statement.
|
MySQL Database Import
Importing Data with LOAD DATA.
|
