Help with query.

2011-02-01 Thread Paul Halliday
I have a query (thanks to this list) that uses a join to add country information to an IP. It looks like this: SELECT COUNT(signature) AS count, INET_NTOA(src_ip), map1.cc as src_cc, INET_NTOA(dst_ip), map2.cc as dst_cc FROM event LEFT JOIN mappings AS map1 ON event.src_ip = map1.ip LEFT JOIN mapp

[PR]

2011-02-01 Thread Sergey Lazurenko
Devart dotConnect Data Providers Bring Most Convenient Working with Large Models and Easier Generation of Autoincrement Fields! New versions of Devart dotConnect data providers come with new greatly improved model designer. It delivers the ability to create several diagrams per model and

error

2011-02-01 Thread swaroop jois
Hello  I have a problem in MySQL database installed on a server .I have built a table   and this table gets updated when ever data comes via  gprs  connection   from Siemens Tc65 module .My problem is initially the table gets updated with data ,fine but after some time  i get a sq l error saying t