MySQL

Collection of MySQL articles

MySQL Delete Database

Introduction The DROP DATABASE command is a basic command of the MySQL language and is used to delete an existing database.Please pay attention to this command because by deleting a database you will also delete all the tables and therefore also your data. Preliminary operations Before to start it is important that you have MySQL …

MySQL Delete Database Read More »

MySQL Create Database

Introduction The CREATE DATABASE command is used to create a new database in MySQL.This tutorial will show you the command syntax and several practical examples to best learn how to use it. Preliminary operations First of all, for this tutorial I assume that you have MySQL installed on your computer. If not, you can download …

MySQL Create Database Read More »

MySQL Delete Table

Introduction MySQL provides the DROP TABLE command to delete a table. This tutorial will show you how to delete a table and how to clear all data without removing the table itself.Don’t worry, each section is full of examples and everything will be explained clearly. Preliminary operations First of all, for this tutorial I assume …

MySQL Delete Table Read More »

MySQL Create Table

Introduction MySQL provides a command to create a new table; this command is called CREATE TABLE.This tutorial will show you the command syntax and several practical examples to best learn how to use it. Preliminary operations Since we are going to be using MySQL it is important that it is installed on your computer.If you …

MySQL Create Table Read More »