Id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, Below is another example of the CREATE TABLE statement: CREATE TABLE users ( When defining columns there are also various options you may specify. active, inactive, pending).įor all intents, the above column types are all that you need to write well constructed mySQL database schemas. Good for things such as a status column (eg. Only allows the value to be one of the pre-defined values specified within the parentheses. Supports maximum size of 64kb, and the following with respective size limits are also supported: Used to store binary data such as images. The following are also available with their respective ranges: Large blocks of text, can store up to 65k characters. Similar to DATETIME except it only stores the date in YYY-MM-DD format, and does not store the time. created at, lst updated, etc.) and DATETIME for all other dates (eg. You should use TIMESTAMP for all row meta data (ie. For example, DECIMAL(8,2) would allow numbers to be maximum six digits in length plus formatted to two decimal points.īoth hold the date and time in YYY-MM-DD HH:II:SS format. The numbers within the parentheses of (x,y) define the maximum length of the column, and the number of decimal points to store. Stores decimal / float values, such as prices or any numeric values that aren't whole numbers. The xxx within parentheses is the maximum length the column can hold. Variable length string that supports virtually all non-binary data. Most communly used integer type, but the following with respective ranges are also available: Integer, supports values up to (+/-) 2.14 billion.
0 kommentar(er)
