Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.
CREATE TABLE `note` ( `id` char(36) NOT NULL, `body` text CHARACTER SET utf8mb4, `title` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL, `preview` text CHARACTER SET utf8mb4, `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `user` varchar(34) DEFAULT NULL, `conversation` varchar(34) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
In the output the key column had value NULL
explain select * from note where user='u:ynul5luymmnlys0u' and conversation is not null order by updated desc;