Learn SQL Database Programming

Understanding how to write clean code

It's important to write clean code for readability and ease of use so that you and others can easily understand what your code is trying to do. This can be done by following these tips:

• Formatting your SQL code for readability is important so that you and others can easily understand your SQL code. SQL ignores whitespace, making it easy to format for readability. You can write SQL code all on one line, but it's much easier to read if you place different parts of the SQL on separate lines.

For example, say that you wrote some code like the following query, which has all the code on one line and wraps around:

CREATE TABLE `managers` (`managerkey` smallint NOT NULL,`playerid` varchar(9) NOT NULL,`yearid` ...