devxlogo

December 26, 2018

Figure Out the Length of Text in a Column in MySQL

Considering the following table STOCKPRICE and its details. CREATE TABLE `STOCKPRICE` (`ID` INT(11) NOT NULL,`NAME` TEXT NOT NULL COLLATE ‘utf8_bin’,`PRICE` INT(11) NOT NULL)COLLATE=’utf8_bin’ENGINE=InnoDB; Also, use the following to create sample