Post by account_disabled on Mar 10, 2024 11:15:15 GMT
PpMyAdmin phpMyAdmin is a webbased MySQL administration tool written in PHP. It is one of the most popular tools of its kind because it is very easy to use and completely free. It may lack some advanced features that other tools provide but its basic functionality is enough to help you create working websites without advanced knowledge of MySQL. Some Important MySQL Commands Some important MySQL commands are as followsTo log in mysql dirbinmysql h hostname u username ppassword To log in from windowsmysql dirbinmysql xe h hostname u username.
Ppassword To create a database mysql create database Bolivia Mobile Number List databasename To list all databases on the server mysql show databases To see all tables in the DB mysql show tables To see the field formats of the table mysql describe table name To delete the db mysql drop database database name To delete a table mysql drop table table name To show all data in a table mysql SELECT FROM table name To return columns and column information mysql show columns from table name To show all records containing the name Something and the phone number mysql SELECT FROM table name WHERE name Something AND phone_number To show selected.
Records sorted ascending ascending or descending descending mysql SELECT colcol FROM table name ORDER BY col DESC For the total column mysql SELECT SUM FROM table name To create a new user mysql u root p mysql use mysql mysql INSERT INTO user HostUserPassword VALUESusernamePASSWORDpassword mysql flush privileges To update information in a tablemysql UPDATE table name SET Select_priv YInsert_priv YUpdate_priv Y where field name user To delete a row from a table mysql DELETE from table name where field name fieldvalue To update database permissionsmysql flush privileges To delete a column mysql alter table table name drop column column name.
Ppassword To create a database mysql create database Bolivia Mobile Number List databasename To list all databases on the server mysql show databases To see all tables in the DB mysql show tables To see the field formats of the table mysql describe table name To delete the db mysql drop database database name To delete a table mysql drop table table name To show all data in a table mysql SELECT FROM table name To return columns and column information mysql show columns from table name To show all records containing the name Something and the phone number mysql SELECT FROM table name WHERE name Something AND phone_number To show selected.
Records sorted ascending ascending or descending descending mysql SELECT colcol FROM table name ORDER BY col DESC For the total column mysql SELECT SUM FROM table name To create a new user mysql u root p mysql use mysql mysql INSERT INTO user HostUserPassword VALUESusernamePASSWORDpassword mysql flush privileges To update information in a tablemysql UPDATE table name SET Select_priv YInsert_priv YUpdate_priv Y where field name user To delete a row from a table mysql DELETE from table name where field name fieldvalue To update database permissionsmysql flush privileges To delete a column mysql alter table table name drop column column name.