Posts

Showing posts from February 6, 2020

Mysql commands

__ __ ____ ___ _ | \/ |_ _/ ___| / _ \| | | |\/| | | | \___ \| | | | | | | | | |_| |___) | |_| | |___ |_| |_|\__, |____/ \__\_\_____| |___/ Handy MySQL Commands Description Command To login (from unix shell) use -h only if needed. [mysql dir]/bin/mysql -h hostname -u root -p Create a database on the sql server. create database [databasename]; List all databases on the sql server. show databases; Switch to a database. use [db name]; To see all the tables in the db. show tables; To see database's field formats. describe [table name]; To delete a db. drop database [database name]; To delete a table. drop table [table name]; Show all data in a table. SELECT * FROM [table name]; Returns the columns and column information pertaining to the designated table. show columns from [table name]; Show certain selected rows with the value "whatever". SELECT * FROM [table name] WHERE [field name] = "whatever"; Show all reco...