fancyPants

fancyPants has asked 1 questions and find answers to 185 problems.

Stats

About

fancyPants questions

Weird behaviour when using read_line in a loop

fancyPants answers

Load data local infile with IF statement
Select a record just if the one before it has a lower value takes too long and fail
INSERT INTO with Increment variable
Is it possible to set MySQL session variables using mysqlimport?
Does SQL_NO_CACHE apply to the enitre query, including subqueries?
Why some spatial functions does not exists on my mysql server?
How can i optimize MySQL query, event if it have index
How can I ignore the resultset of a stored procedure in a trigger?
SSIS Error while executing data flow task - import excel into sql table
GROUP by in the query - What I'm doing wrong with it?