[Koha-devel] MySQL specific queries
Pierrick LE GALL
pierrick at koha-fr.org
Thu Apr 6 09:59:11 CEST 2006
Hi koha-devel,
Working in admin/stopwords.pl, I've found an SQL query I didn't know :
"REPLACE stopwords (word) values (?)". I've searched in my MySQL
cookbook and found what was the purpose of this statement (it's great
by the way, too bad I didn't know it, it would have saved me many code
lines).
What the cookbook also told me is that "INSERT IGNORE" and "REPLACE"
are MySQL specific statement. Maybe we already use "SELECT ... LIMIT
X,Y" but this one is much more difficult to /translate/ into standard
SQL. What is the official coding guideline concerning SQL queries? Can
we use such specific statements?
Cheers,
--
Pierrick LE GALL
INEO media system
More information about the Koha-devel
mailing list