Notes 10

• mysqli
• connect
• close
• query
• fetch_row, fetch_assoc, fetch_array(____) [MYSQLI_NUM,MYSQLI_ASSOC,MYSQLI_BOTH]
• SQL Injection part 1
• prepared statements
• prepare
• bind_param
• execute
• get_result
• bind_result
• store_result

Useful DB Stuff

• unix$ mysqldump -p db_name > db_backup.sql database backup
• unix$ mysqldump -p db_name tb_name > table_backup.sql table backup
• unix$ mysql -p -Ddb_name < SQLtoExec.sql run sql outside of client
• unix$ mysql -p -Ddb_name < table_backup.sqlrestore table/data


• MariaDB>source ./SQLtoExec.sql exec sql from file
• MariaDB>describe Table\G   (\G) vertical output
• MariaDB>SELECT * FROM Table\G   (\G) vertical output