`Categories`

Bdd.database_name • Bdd.columns_count

Bdd.column_name	Bdd.column_type	Bdd.column_null	Bdd.column_key	Bdd.column_default	Bdd.column_extra
`CategorieID`	int(11)	Bdd.no	Bdd.primary_key	Bdd.null_default	auto_increment
`NomCategorie`	varchar(255)	Bdd.no	-	Bdd.null_default	-

Bdd.total_columns

Bdd.create_table_query

CREATE TABLE `Categories` (
  `CategorieID` int(11) NOT NULL AUTO_INCREMENT,
  `NomCategorie` varchar(255) NOT NULL,
  PRIMARY KEY (`CategorieID`)
) 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 Categories LIMIT 10;

SELECT COUNT(*) FROM Categories;

DESCRIBE Categories;

Bdd.ready_to_test

Bdd.open_sql_editor