Archive for the ‘MySQL’ Category.

MySQL statement terminators

There is the semicolon “;” that every one knows, and “\g” which is just the same:
mysql > SELECT * FROM wp_links;
mysql > SELECT * FROM wp_links\g
Those are exactly the same, and will produce the same result, here is an example:
mysql> select * from wp_links \g
+———+———————–+————–+————+————-+—————+——————+————–+————+————-+———————+———-+————+———————–+
| link_id | link_url [...]

MySQL script files tutorial for beginners

What is a MySQL script file?.. Why use it?
A MySQL script file (aka MySQL batch file) is a regular text file containing MySQL statements separeted by terminantors, statements in a MySQL script file can be executed from the MySQL client, this is very useful, many PHP script available online come with MySQL script files that [...]