Timeline for Usage of non standardized queries
Current License: CC BY-SA 3.0
3 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Apr 3, 2015 at 19:18 | comment | added | Rick James | Bad solution. (1) ? would put quotes around table name, giving you a syntax error, and (2) you should not use "*" without understanding the ramifications when you do add a new column. | |
Apr 3, 2015 at 18:49 | comment | added | RidableCthulu | What I meant is using the ? in my queries which would then be changed to the table name in code before querying the database. For example I had two tables: cities and schools. For now, both of them have ID and schoolName or cityName depending on the table. The query for this would just be select * from some table which would then be added in code. I didn't like this solution though. | |
Apr 3, 2015 at 17:51 | history | answered | Rick James | CC BY-SA 3.0 |