Part 5
MySQL
Install MySQL, build databases and tables, and master every form of SELECT, UPDATE, ALTER, DELETE, keys, constraints, safe update mode and user privileges – the knowledge behind SQL injection and its defence.
Chapters in this part
10. MySQL Part 1: Install, Create, Insert and SELECT
11. MySQL Part 2: UPDATE, ALTER, DELETE, Keys, Constraints and Users
- 11.1 UPDATE
- 11.2 Safe Update Mode, Error 1175 and Transactions
- 11.3 ALTER TABLE: Add, Modify, Rename and Drop Columns
- 11.4 DELETE, TRUNCATE and DROP
- 11.5 Keys: Primary, Foreign, Unique, Composite, Candidate, Super, Alternate
- 11.6 Constraints: NOT NULL, DEFAULT, CHECK, AUTO_INCREMENT
- 11.7 Users, GRANT, REVOKE and Least Privilege