Archive: Basic MySQL Tutorial
-
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...
-
Jul 26, 2011
No CommentsManaging Databases in MySQL
Summary: In this tutorial you will learn how to manage database in MySQL. You will learn how to create a new database, list all databases in the MySQL database server and remove databases from database catalog. Let’s start creating a new database in MySQL. Creating Database To create a database in MySQL, you use the...
-
Jul 26, 2011
No CommentsWhat is MySQL’s Database hostname?
This documentation details your database hostname. Database Hostname: 127.0.0.1 (also known as “localhost“) Usage: When setting up a WordPress, ZenCart, OsCommerce, Magento, Drupal or Joomla style of website, you will need to specify where your database is located. Note: For advanced users, if connecting to our server from your local machine, simply use your domain...