DATABASE Create display and delete
Database is a collection of structured information or data.Creating a database
CREATE DATABASE my_database;CREATE database IF NOT EXISTS my_database;Listing all Databases
SHOW databases;SHOW databases LIKE '%plus2%';More on SHOW Database and table
Opening a Database
USE my_database;Deleting Database
DROP DATABASE my_database;DROP DATABASE IF EXISTS my_database;SQL Show all tables in Database
This article is written by plus2net.com team.
Math functions used in SQLavg:Getting average of data in MySQLsum:Sum of a range of data in MySQLsum of multiple columns in MySQL & to get Percentage and totalmin:Getting the Minimum value of data in MySQLmax:Getting the Miximum value of data in MySQLmod:Getting the reminder of a division by using Mod functionGetting second highest number from the student tableformat: Formatting MySQL data in a query while managing records of a tablefloor: MySQL function to get highest integer lower than the input valueceil: MySQL function to get lowest integer higher than the input valueabs: MySQL abs function to get absolute valueround: MySQL round function to get rounded value from columnconv: MySQL conv to convert numbers from one base to other truncate: MySQL truncate function to remove decimal placessqrt: square root of number by sqrt functionpow: Power of a number pow function
SQL Video Tutorials