At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
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;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.