MySQL Column Type Database – mysql tutorials

In this session you will learn how to support number of column in MySQL . MySQL supports the numeric type , Date and time type, and String type (char) database.
 
MySQL Numeric type and String type Database :
 
 
 

        TYPE
BYTE
 MINIMUM VALUE
MAXIMUM VALUE

TINYINT
 1 Byte
-128
127

BIT
(M+7)/8 Byte 
 -
-

SMALLINT
2 Byte
-32768
32767

MEDIUMINT
3 Byte
-8388608
8388607

INT(M) (UNSIGNED) (ZEROFILL)
4 Byte
-2147483648
2147483647

INTERGER [M]
4 Byte 
-
-

BIGINT [M]
8 Byte
-9223372036854775808
9223372036854775807

FLOAT [precision]
4 Byte
 
 

FLOAT [(M, D)]
8 Byte
 
 

DOUBLE [...]

MySQL Creating and Deleting Database – mysql tutorials

In this section you will learn  how to create and delete the database in MySQL. MySQL provides the both commands. In this section you can learn the following things :

Creation  and Selection of database 
Creation of table 
Load the data into the table 

Once you enter the command prompts then ready to access the database. Before [...]

MySQL Monitoring – mysql tutorials

In this section you can learn how to monitor the MySQL  Database. MySQL system store the all of the critical data and  easy to maintenance in every cases. It is very popular database and make quick easy to store or its access, and update Data.     

MySQL sort key command :

MySQL Use \h for help.
\c command for [...]

MySQL User Interface – Mysql tutorials

In this section you will read how to define the function Interface, Create function syntax , Drop function Syntax .  
MySQL adding new user defined function     
Two ways are available to add new function to MySQL :

You can add function with the help of UDF (user defined function) interface. These are complied as object files. After that [...]

Understanding Various MySQL Executable Files – mysql tutorials

This lesson you learn  how to the execute mysql file. MySQL  Provide the  executable file and uses the MySQL Client  interactive file by  this command “shell> mysql db_name “. It is possible put the SQL statement in file and tell the mysql from input read this file . So the create  text file ” text_file” [...]