MySQL command-line client commands<\/p>\n\n\n\n
This command allows us to connect with MySQL<\/p>\n\n\n\n
Server with a username and passwords using below syntax.<\/p>\n\n\n\n
mysql -u [username] -p;<\/strong> <\/p>\n\n\n\n If you want to connect with a particular database, use this syntax:<\/p>\n\n\n\n mysql -u [username] -p [database]; <\/strong> <\/p>\n\n\n\n If you want to set a new password, use this syntax:<\/p>\n\n\n\n mysqladmin -u root password your_password; <\/strong><\/p>\n\n\n\n We can use the “exit” command to quit the MySQL command-line client.<\/p>\n\n\n\n We can clear the console window in Linux using the below command:<\/p>\n\n\n\n mysql> system clear; <\/strong> <\/p>\n\n\n\n CREATE DATABASE IF NOT EXISTS db_name; <\/strong><\/p>\n\n\n\n If you want to change the current database with another database on which you are working, use the below syntax:<\/p>\n\n\n\n mysql> use db_name; <\/strong><\/p>\n\n\n\n We can delete a particular database along with its associated files permanently using the below syntax:<\/p>\n\n\n\n DROP DATABASE IF EXISTS db_name; <\/strong><\/p>\n\n\n\n To show all databases in the current server, use this syntax:<\/p>\n\n\n\n mysql> SHOW DATABASES; <\/strong> <\/p>\n\n\n\n A table is a collection of related data stored in a row and column format within a database. We can create a new table using the below syntax. It also checks the table name, whether it already exists or not.<\/p>\n\n\n\n CREATE TABLE IF NOT EXISTS tab_name ( <\/strong><\/p>\n\n\n\n column_list (s) <\/strong><\/p>\n\n\n\n ); <\/strong><\/p>\n\n\n\n to add a record into the table, which is given below:<\/p>\n\n\n\n INSERT INTO table_name ( field1, field2,…fieldN ) VALUES ( value1, value2,…valueN ); <\/strong><\/p>\n\n\n\n We can delete a particular table along permanently using the below syntax:<\/p>\n\n\n\n DROP TABLE IF EXISTS tab_name; <\/strong> <\/p>\n\n\n\n mysql> SHOW TABLES<\/strong>; <\/p>\n","protected":false},"excerpt":{"rendered":" MySQL command-line client commands This command allows us to connect with MySQL Server with a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/90"}],"collection":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/comments?post=90"}],"version-history":[{"count":1,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/90\/revisions"}],"predecessor-version":[{"id":91,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/posts\/90\/revisions\/91"}],"wp:attachment":[{"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/media?parent=90"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/categories?post=90"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/itnotes.apjsoftwares.in\/index.php\/wp-json\/wp\/v2\/tags?post=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}