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 [...]