Archive: Mysql Interview Questions
-
Jul 26, 2011
No CommentsChanging Table Structure Using MySQL ALTER TABLE
Summary:In this tutorial you will learn how to use MySQL ALTER TABLE statement to change the structure of existing tables. MySQL ALTER TABLE syntax MySQL ALTER TABLE statement is used to change the structure of existing tables. You can use MySQL ALTER TABLE to add or drop column, change column data type, add primary key,...
-
Jul 26, 2011
No CommentsWorking with Database Table – Part I
Summary: In this tutorial you will learn how to create, show and describe tables in MySQL. Database table or table in short is one of the most important objects of relational database. How to create databases tables correctly is crucial when you work with any database system especially MySQL. In this tutorial, you will learn...
-
Jul 26, 2011
No CommentsUnderstanding MySQL TIMESTAMP
Summary: The MySQL TIMESTAMP is a temporal data type that store combination of date and time values. In this tutorial you will learn how MySQL TIMESTAMP values are stored in the database and how to use automatic initialization and automatic update to create created on and last changed on column in a table. How MySQL...
-
Jul 26, 2011
No CommentsMySQL Data Types
estamp value in ‘CCYY-MM-DD hh:mm:ss’ format YEAR A year value in CCYY or YY format Spatial Data Types MySQL support many spatial data types as below table which contains various kind of geometrical and geographical values. Spatial Data Types Description GEOMETRY A spatial value of any type POINT A point (a pair of X Y coordinates)...
-
Jul 26, 2011
No CommentsUnderstanding MySQL Table Types
Summary: In this tutorial, you will learn various table types in MySQL. It is essential to know what kind of table types or storage engine you use for your database to maximize the performance of your application. MySQL supports various of table types or storage engines to allow you to optimize your database. The table...