RUN MySQL with DOS

  Press the Windows key + R, then type CMD - Enter


Type a command following:cd \ EnterEnter cd mysqlEnter cd binmysql-h localhost-u root-p EnterEnter Password "Empty Me" EnterMessage:Welcome to the MySQL monitor.Indicates mysql is ready for use.Ket:cd \: Goes to Outer Directory.cd: Go inside the folder.-H: local hosting-U: username on mysql-P: password on mysql

Several functions MySQL HelpHelp (\ h) Display List HelpClear (\ c) Clear commandExit (\ q) Exit from MySQL

SQL command to know the current date.

SQL command to know the current time.

SQL command to determine the current date and time now.

SQL command to display all the available databases.

SQL command to select a specific database.

SQL command to display the currently active database.

SQL command to display the contents of the table in the selected database.

SQL commands to create a new database named akademik_abc.

SQL command to activate akademik_abc database.

SQL commands to create a new table named students.

SQL command to display the tables that have been made.

SQL command to change the name of the student tables and display updates

SQL command to see the table structure

SQL command to change the name of the field

SQL command to add a new field

SQL command to delete a field

SQL command to create a primary key

SQL command to insert new data

SQL Commands for Displaying All data in the table

SQL command to change the contents of the table

SQL command to delete the contents of the table

share this article to: Facebook Twitter Google+ Linkedin Technorati Digg

Posted by Unknown, Published at 00:31 and have 0 comments