Month: September 2020

MySQL welcome image

Welcome to MySQL!

Welcome to MySQL! : Once you understand what a database is, understanding SQL is easy. SQL stands for Structured Query Language. SQL is used to access and manipulate a database. MySQL is a program that understands SQL. SQL can: insert, update, or delete records in a database. create new databases, table, stored procedures, views. retrieve …

Welcome to MySQL! Read More »

installation of my sql

Installation of MySQL

Installation of MySQL : MySQL is one of the most popular relational database management software that is widely used in today’s industry. It provides multi-user access support with various storage engines. The following requirements should be available in your system to work with MySQL: MySQL Setup Software Microsoft .NET Framework 4.5.2 Microsoft Visual C++ Redistributable …

Installation of MySQL Read More »

Data types in my sql

MySQL-Data Types

A MySQL-Data Types specifies a particular type of data, like integer, floating points, Boolean, etc. It also identifies the possible values for that type, the operations that can be performed on that type, and the way the values of that type are stored. In MySQL, each database table has many columns and contains specific data …

MySQL-Data Types Read More »

Drop database in mysql

MySQL-Drop Database

MySQL-Drop Database : We can drop/delete/remove a MySQL database quickly with the MySQL DROP DATABASE command. It will delete the database along with all the tables, indexes, and constraints permanently. Therefore, we should have to be very careful while removing the database in MySQL because we will lose all the data available in the database. …

MySQL-Drop Database Read More »

create table in my sql

MySQL Create Table

MySQL Create Table : A table is used to organize data in the form of rows and columns and used for both storing and displaying records in the structure format. It is similar to worksheets in the spreadsheet application. A table creation command requires three things: Name of the table Name of the fields Definitions …

MySQL Create Table Read More »

drop table in my sql

MySQL Drop Table

MySQL Drop Table statement is to delete the existing table. This statement removes the complete data of a table along with the whole structure or definition permanently from the database. Syntax Dropping Tables from the Command Prompt To drop tables from the command prompt, we need to execute the DROP TABLE SQL command at the …

MySQL Drop Table Read More »

Truncate table in my sql

MySQL Truncate Table

MySQL Truncate Table statement removes the complete data without removing its structure. The TRUNCATE TABLE statement is used when you want to delete the complete data from a table without removing the table structure. MySql Truncate Table Syntax: TRUNCATE TABLE  table_name; Example: This example specifies how to truncate a table. In this example, we truncate …

MySQL Truncate Table Read More »