I’m giving MySQL Tips a quick skim, and I’ve already found a few forehead slappers, such as…
#28: Loading Data into Tables from Text Files - I knew about load data infile, but I didn’t know you could specify the fields by listing them in parentheses at the end of the command. That’ll speed up a few jobs on at least one system I work on.
Tip #31: Getting XML and HTML output. ‘Nuff said.
Tips #33-35: There are spatial extensions in MySql? Interesting…
Probably all of these could have been found through a good dose of RTFM, but hey, we can’t read everything, can we?
Post a Comment