-
Notifications
You must be signed in to change notification settings - Fork 18
Home
rap2hpoutre edited this page Feb 7, 2014
·
6 revisions
Welcome to the mysql-xplain-xplain wiki!
- [~done] Analyse cells
- [~done] Analyse rows
- [~done] Link between cell content and MySQL infos from official doc about it (maybe a copy explained/simplified of MySQL doc)
- [done] Create contextual queries (a link for adding a textarea before the query textarea: this textarea must accept multuiple query : create temporary tables, etc.)
- edit
app/base.php
and transform it in static class or something like that - Add hint for "Use Same Column Types for Joins" (compare column type)
- Add hint if no column contains "id"
- PROCEDURE ANALYSE() for tables
- Add hint "Use NOT NULL if you can"
- When "type" is "ref" says something like "Using = for comparison, but not primary key lookup."