Some Words about MySQL

The first column should be:

• Field: ID_
• Type: INT or a variation of it!
• Null: NOT NULL
• Extra: AUTO_INCREMENT
• a PRIMARY KEY

example:

 CREATE TABLE `patient` (
`id_patient` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
...//Others instructions
) ENGINE = MYISAM CHARACTER SET latin1 COLLATE latin1_swedish_ci

• ENUM

`gender` ENUM( 'Male', 'Female', 'Unknown' ) NOT NULL

• INT/MEDIUMINT/TINYINT

`npa` MEDIUMINT UNSIGNED NOT NULL COMMENT 'Postal Code',

• TIMESTAMP

`lastmodification` TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL

1. Q: MySQL says: “This is not a number”
   • R: VARCHAR needs a “Length/Values”

`firstname` VARCHAR( 40 ) NOT NULL

• MySQL documentation
• Makes your data as small as possible
• Links on R937.com
• Managing Hierarchical Data in MySQL
• MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN