While you are creating a table using command prompt, you should have to take care about the following points Name of the table Name of the fields Definitions for each…
Drop a Database using mysqladmin
You can drop a database from the command line. Make sure you have an access for dropping a database. Be careful while deleting any database, because you will lose all…
Create Database Using MySQLadmin
You can create a MySQL database from the command line. Make sure you have a access for creating a database. Below command will create a database using command line. [root@host]#…
MySQL command and their results
Some commands are listed below here; you can use time to time to work with MySQL. USE Databasename: This command is usded for the select a database in the MySQL…
