creating a table under a particular database is very easy in sql. To avoid error make sure you select the database where you want to create the table by using the statement below USE “name of the database”. Avoid terminating this statement with semicolon (;) because its not really a query e.g MySQL>USE sola sola […]
DROP DATABASE query is used to delete or drop a particular created database. This query is followed by the name of the database. e.g DROP DATABASE sola;
Showing all the database that has been created, you will need sql query for displaying all the created database in your server. query for showing all database is SHOW DATABASES; NOTE: This syntax enable you to know whether the database has been created
To create database using sql code in command prompt, you must have change the directory of the command prompt to the sql location. click here to read up on using command prompt as the environment for writing sql codes Then type in CREATE DATABASE name_of_the_database; e.g create database sola; sola is the name of the […]
It is interesting to know that you can also use your command prompt as the template or environment for writing sql codes. Before you can use command prompt as the environment for sql codes you need to change the directory to the location of the mysql application inside the folder of wamp server. To achieve […]
Solarex Information Technology World 2020 | All Rights Reserved.
