Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

http://mindtrickpages.in/mysql-commands/

MySQL commands
MySQL commands :- MySQL commands are easy to learn and execute .MySQL is Open Source Relational SQL database management system.It is very popular database with GUI interface and it is very easy to learn.MySQL is very compatible with php and Linux platform.Founded by David Axmark, Allan Larsson and Michael “Monty” Widenius.MySQL commands are explained below

Developer Company Oracle Corporation
Initial release 23 May 1995;
Written in(Program) C, C++
OS Windows, Linux, Solaris, macOS, FreeBSD[4]
Available in(Language) English
Database Type RDBMS
License GPL
Official Website www.mysql.com

MySQL commands and their working
MySQL commands are used to create ,alter,delete database.here you will get to know all commands one by one and also their working and description

MySQL Commands Description MySQL Commands
This MySQL commands will display all the databases show databases;
it will Switch to a different database. use [db name];
it display all the tables in database show tables;
It Display database’s field formats. describe [table name];
MySQL commands will delete database drop database [database name];
MySQL Commands to delete a table. drop table [table name];
Show all records in a table. SELECT * FROM [table name];
It Returns the columns and column information pertaining to the designated table. show columns from [table name];

Sign In or Register to comment.