753 reputation
11534
bio website phpfreaks.com
location United States (but travelling)
age 35
visits member for 2 years, 9 months
seen Jun 7 at 0:20

intentionally left blank


Sep
19
asked How to UPDATE a table for the level of parents in a column?
Sep
17
awarded  Nice Question
Sep
17
comment Do regular ALTERs weaken the performance?
@MaxVernon the project is in beta mode, not alpha. Changes to the database is not about core columns, but additional columns, usually making FK to other tables. The project is conducted based on end-user feedback.
Sep
17
asked How to get missing values in row order?
Sep
16
comment Do regular ALTERs weaken the performance?
@MaxVernon I know that it sounds crazy, but it is a live project in which the database structure is about to modified. Unfortunately, due to the rush, we could now extend the test period.
Sep
16
asked Do regular ALTERs weaken the performance?
Sep
15
accepted JOIN to read first table and get possible relationship in the second table
Sep
15
accepted Is it possible to force drop of mysql tables with FK?
Sep
15
accepted HOW to “SUM” and “JOIN” for single query of a poll results?
Sep
15
accepted How to run a SELECT query within while loop in PHP?
Sep
15
accepted Does a TRIGGER improve the performance?
Sep
15
accepted How to use OR in query with priority?
Sep
15
asked How to update a table by count from another table?
Sep
6
asked How to use OR in query with priority?
Aug
28
accepted Enabling LOAD DATA LOCAL INFILE in mysql
Aug
28
revised Does a TRIGGER improve the performance?
added 66 characters in body
Aug
28
comment Does a TRIGGER improve the performance?
@RaymondNijland innoDB
Aug
27
asked Does a TRIGGER improve the performance?
Aug
27
comment Enabling LOAD DATA LOCAL INFILE in mysql
Thanks for your practical instruction for debugging, what I really needed. In the first step, it revealed, I am on wrong track, as showed local_infile | ON . It seems the problem is not mysql, but PHP or probably the mysql-PHP connector/driver (mysqli).
Aug
26
revised Enabling LOAD DATA LOCAL INFILE in mysql
deleted 167 characters in body; edited title