languages.txt

# MySQL
# connect to the mysql server
$ mysql -u root -p (enter the password to enter the MySQL shell)
# if there are multiple mysql server, you need to specify the ip and port
mysql -h127.0.0.1 -P3306 -uuser -ppassword
mysql>
	show databases;
	create database <database name>;

# SQLite
# create datebase
	$ sqlite3 testDB.db
	$ sqlite3 # for entering the sqlite shell
# check the databases
	sqlite> 
		.databases # check all the databases
		.quit
		# for specific purpose like CREAET, INSERT, SELECT, WHERE, UPDATE, DELETE refer w3school
		.schema <table name> # to check the schema
		# to output all the data in a good view
		.header on
		.mode column
		.width 10, 20, 10 # to modify the column 1 2 3 width
		SELECT * FROM <table name>;
# dump between the .sql file and DB
	$ sqlite3 testDB.db .dump > testDB.sql
	$ sqlite3 testDB.db < testDB.sql

# CPP
# string length
.length()

# python
# POST multipart/form-data without filename in HTTP request
	$ import requests
	$ requests.post('http://url', files = {'value_1': (None, '12345'), 'value_2': (None, '67890')})
	# for more info, check the 1st answer in https://stackoverflow.com/questions/23120974/python-requests-post-multipart-form-data-without-filename-in-http-request