June 18, 2013

Post: Using VIEW to reduce number of tables used

…if you can simply rewrite software to store multiple users per table it is best way to…have “post” table which has user_id,id, title,body columns and create post123 as view: create view post123 as select…. You could think MySQL would look at the WHERE clause to figure out which value should be used …

Post: Fishing with dynamite, brought to you by the randgen and dbqp

have been reused many times (including for two of these bugs!) This brings us to our first bug: mysql… as a possible WHERE clause for SELECT queries: WHERE X . char_field_name !=…s Views translation module.’ The test value was taken from the … I also wanted to create multiple schemas and we did via …

Comment: Why MySQL could be slow with large tables ?

…web project using MySql, Apache and Php….. The problem I have, is regarding some … as filters (WHERE/JOIN/ORDER CLAUSEs). I’ve…SELECTs in them (not joining them with other tables). Once again, I use multiple inserts into the table, with sets of 150 records each: INSERT INTO T (col1,col2) VALUES