I am stuck onto a problem and would appreciate some help on this! Here’s the problem: I am using aggregate functions (eg. SUM) of MySQL in a query where two tables are joined. I also need to filter the results based on some WHERE clause. Now the problem is, SUM sums up the values multiple […]

Here’s a great thing I learned about MySQL today: [sql]CREATE TABLE newtable LIKE oldtable[/sql] Will create a copy of the table along with structure and keys (primary keys, auto increments etc) but not the data. This is perfect solution to create new tables based on an existing one – we use it to create a […]