Create table: fulltext : FullText « Data Type « SQL / MySQL

1. SQL / MySQL
2. Data Type
3. FullText

Create table: fulltext

Drop table Product;

CREATE TABLE Product
(
   ID SMALLINT UNSIGNED NOT NULL,
   ModelID SMALLINT UNSIGNED NOT NULL,
   ModelName VARCHAR(40),
   PRIMARY KEY (ID),
   FULLTEXT (ModelName)
);

Describe Product;
           
       

Related examples in the same category