New answers tagged

2

You should not define a Tcl procedure inside body of SQL function. Instead use only following line as function implementation (and nothing more): expr {sqrt([lindex $argv 0])} If you define a proc inside function definition you will be creating a new Tcl procedure each time you call the SQL function, which makes no sense, especially when you don't call ...


0

Despite of the database you are using, normally you don't add thousands of fields to a table. Your second model is more 'normalized' ( and it's easy to index ), and should work better ( I'm not an expert, anyway ). My opinion is based on normal limits of databases, that are not meant to work that way, so you're going to hit some inner limit of the engine, or ...


-1

The solution to your query will be just one simple query, select id, name from minecraft where name like '%e%o%' and instr(trim(name),' ')=0 Thats the shortest answer that works in sqlite.


1

(Too long for a comment...) MySQL... SHOW VARIABLES LIKE '%buffer%'; -- the main configuraton is the cache allocation. But it depends on which Engine you are using and how much RAM you have. pretty normalized, specifically joining, grouping, slicing and dicing the 3 tables Sorry, but we need to check the details. Please provide SHOW CREATE TABLE, ...


2

time_stamp - 1800 subtracts two numbers. If the value in the time_stamp column is not a number, it is converted. From what you've shown, converting the values in the time_stamp column (which begin with the characters 2015) to a number results in the value 2015; subtracting 1800 from that results in 215. This is probably not what you want. To group by hours ...



Top 50 recent answers are included