Table MYSQL des médecins
mysql> use statdata ; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> describe medecins ; +---------------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------------+------+-----+---------+----------------+ | idmedecin | int(10) unsigned | NO | PRI | NULL | auto_increment | | med_nom | varchar(255) | NO | MUL | | | | med_prenom | varchar(45) | NO | | | | | med_initiales | varchar(4) | NO | | | | +---------------+------------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) mysql> select * from medecins ; +-----------+-------------------+-----------------+---------------+ | idmedecin | med_nom | med_prenom | med_initiales | +-----------+-------------------+-----------------+---------------+ | 1 | TEST | Test | Test | | 2 | ROUSSELET-CHAPEAU | Marie-Christine | MCR | | 3 | MICHALAK | Sophie | SM | +-----------+-------------------+-----------------+---------------+ 3 rows in set (0.00 sec) mysql> quit ;
Retour à la page principale de (gH)