Selecting All Columns or Specific columns

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:

Insert the Data in the table:
The INSERT statement is used the load the data in the table. Keyword are used in this statement are follows :

INSERT - Insert data into the table
INTO - Specified the Table name for inserting the data
VALUES - Data for the columns in the table.

MySQL creates the table by the name of Employee with the column along the first row. If you want to only select columns, replace the * with the names of the columns, separated by commas. The select statement follow just like the , SELECT * FROM Employee :

Display the MySQL version

For displaying the current date and time

Mysql Evaluating Expression
Expressions have operators and terms and they are evaluated to generate values. Expressions contain constants, function calls and references to table columns. These values can be combined using different kinds of operators like comparison or arithmetic operators. Expression terms can be grouped with parentheses.

When an Expression is encountered MySQL, it evaluates the expression to produce a result.

Writing Expressions
An Writing expression can be as simple as a single constant. Expressions may use function calls. But some function takes arguments and some does not. And multiple arguments are separated by commas.

Example:

CONCAT()
The CONCAT() function uses argument between parenthesis. These can be use columns name or plane text string .

Example