PHP and MySQL syntax: Difference between revisions

Jump to navigation Jump to search
Line 159: Line 159:


== documentation ==
== documentation ==
<pre>
How to generate the table schema
EXPLAIN table_name;
# Using [https://www.phpmyadmin.net/ phpMyAdmin] or other MySQL client
</pre>
# Input the SQL query: <pre>EXPLAIN table_name;</pre>
# Print view (with full texts)
# Easy to copy the table to other work processor
# (optional) Adjust the text size to 10
 
== debug ==
== debug ==
[[SQL syntax debug]]
[[SQL syntax debug]]

Navigation menu