Medecins
Bdd.database_name • Bdd.columns_count
| Bdd.column_name | Bdd.column_type | Bdd.column_null | Bdd.column_key | Bdd.column_default | Bdd.column_extra |
|---|---|---|---|---|---|
id_medecins |
int(11) | Bdd.no | Bdd.primary_key | Bdd.null_default | - |
nom |
varchar(50) | Bdd.yes | - | Bdd.null_default | - |
prenom |
varchar(50) | Bdd.yes | - | Bdd.null_default | - |
specialite |
varchar(50) | Bdd.yes | - | Bdd.null_default | - |
cabinet |
varchar(100) | Bdd.yes | - | Bdd.null_default | - |
honoraires |
float | Bdd.yes | - | Bdd.null_default | - |
Bdd.create_table_query
CREATE TABLE `Medecins` (
`id_medecins` int(11) NOT NULL,
`nom` varchar(50) DEFAULT NULL,
`prenom` varchar(50) DEFAULT NULL,
`specialite` varchar(50) DEFAULT NULL,
`cabinet` varchar(100) DEFAULT NULL,
`honoraires` float DEFAULT NULL,
PRIMARY KEY (`id_medecins`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ciBdd.key_types
- Bdd.primary_key Bdd.primary_key_desc
- Bdd.unique_key Bdd.unique_key_desc
- Bdd.index_key Bdd.index_key_desc
Bdd.query_examples
SELECT * FROM Medecins LIMIT 10;
SELECT COUNT(*) FROM Medecins;
DESCRIBE Medecins;