Statuts

Bdd.database_name • Bdd.columns_count

Actions.back
Bdd.column_name Bdd.column_type Bdd.column_null Bdd.column_key Bdd.column_default Bdd.column_extra
StatutID int(11) Bdd.no Bdd.primary_key Bdd.null_default auto_increment
NomStatut varchar(50) Bdd.no - Bdd.null_default -
Bdd.total_columns
Bdd.create_table_query 
CREATE TABLE `Statuts` (
  `StatutID` int(11) NOT NULL AUTO_INCREMENT,
  `NomStatut` varchar(50) NOT NULL,
  PRIMARY KEY (`StatutID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci
Bdd.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 Statuts LIMIT 10;
SELECT COUNT(*) FROM Statuts;
DESCRIBE Statuts;
Bdd.ready_to_test
Bdd.open_sql_editor