♦️mysql

connect

mysql -u username -p 'password' database_name

mysql -u <uname> <db-name> -p
Enter password: <pass>


mysql -u root playsms -p
Enter password:

commands / query

SHOW DATABSES;
SHOW TABLES;

USE <db-name>;

select * from <table_name>;		    #display all contents of that table
select <column_name> from <table_name>;	    #display specific contents of that table

execute query with connect

basic syntax >>

mysql -e 'query_to_execute;' -u username -p 'password' database_name



example >>

mysql -e 'show tables;' -u drupaluser -p 'CQHEy@9M*m23gBVj' drupal

sqlite3

sqlite3	<filename>	#to create or select the particular file
.databases		#show path of database
.tables			#show all present tables
.echo on/off		#show command which we run
.headers on		#turn the headers (columns & rows) of table on/off 
.mode <mode_type>	#display the content of tables in specified mode	
				
modes	= html , box , columns , json .......etc 


select * from <table_name>;	#display all contents of that table
select <column_name> from <table_name>;	#display specific contents of that table

example :- 

select username, password from users;
select * from users where id = 1;	#we can use ( = , < , > .....accordingly)

mysqldump

mysqldump --user=theseus --password=iamkingtheseus --host=localhost Magic