Selecting All Columns or Specific columns in mysql – mysql tutorials

In this section you will be learn how to create database and create a specific columns in MySQL . 
CREATE Statement
The CREATE statement is used to create the table.
Example:
Create the tables:
 
 

mysql> CREATE TABLE Employee (
-> id int unsigned not null auto_increment primary key,
-> f_name varchar(20),
-> l_name varchar(20),
-> age int,
-> salary int,
-> email varchar(60)
-> );
Query OK, 0 [...]

MySQL Select Statement – Mysql Tutorials

In this lesson you will be learn how to use SELECT statement in MySQL and you can also learn how to use SELECT statement with WHERE clause. The SELECT statement is used to retrieve the records from the table. There are some keywords uses in SELECT statement that are described in the following table
 

Keywords
               Description

SELECT 
SELECT [...]

Mysql Operators & Functions – Mysql Tutorials

In this section we are describing the function and operators, which are allowed for writing expressions in MySQL. If any expression, which contains NULL then it always produce a NULL value unless else indicated in the documentation for a particular function or operator.
   
MySQL Operator Table 

Name

Symbol 

EQUAL
 = 

 OR
  ||

AND 
&&

GRATER THEN EQUAL
>=

GRATER THEN 
>

LESS THEN 
<

LESS THEN OR GRATER THEN 
<>

NOT EQUAL [...]

Identifiers & Qualifiers – mysql tutorials

In this section you will learn about describing the allowable syntax for identifiers in MySQL. The identifiers are Database, table, index, column and alias name. The following table describes the maximum length for each type of identifier.
      

Identifier
Maximum length 

Database
64

table
64

column
64

Index 
64

Alias
255

Some restriction on the character, which may appear in identifier are given below :

No identifier can contain [...]

Database Designing – mysql tutorials

There are some rules are available for designing the database. These are given below :

MySQL use the alpha numeric character .
MySQL limited the 64 characters . 
MySQL use the underscore (_) to separate word.
MySQL is entirely lowercase word .
MySQL use the plural table name to indicate multiple value store  and singular column names .

MySQL Database Normalization
Normalization [...]