Working with mysql CLI
Login mysql -u username -p Show databases; show databases; Use database; use db_name; List tables; show tables; Show table fields describe table_name; OR show columns from table_name; Select fields from table select column1,column2 from table_name; Update record update table_name set … Continue reading