Table caching

2005-06-24 Thread Peter Hicks
change often, so slightly stale cached data isn't an issue. Peter. -- Peter Hicks | e: [EMAIL PROTECTED] | g: 0xE7C839F4 | w: www.poggs.com A: Because it destroys the flow of the conversation Q: Why is top-posting bad? -- MySQL General Mailing List For list archives: http

Re: IP Addresses -- How to Store

2003-02-11 Thread Peter Hicks
On Tue, 11 Feb 2003, Dan Nelson wrote: Store your addresses as INTs, so you would have three fields: address, netmask, and gateway. You can either encode the values yourself, or use mysql's INET_NTOA()/INET_ATON() functions. ...and beware, INET_NTOA/ATON calls aren't compatible (as far as I

Converting signed and unsigned integers

2002-12-30 Thread Peter Hicks
All, I have a table which includes IP addresses converted from dotted quads to signed integers using PHP's ip2long() function. To greatly simplify some of my code, I want to convert these signed integers to IP addresses on my MySQL server. The problem I'm up against is that PHP's ip2long uses

Re: mysql.sock

2002-12-22 Thread Peter Hicks
Bruno, Restart mysqld. Peter. - Original Message - From: bruno peracchio [EMAIL PROTECTED] To: mysql-list [EMAIL PROTECTED] Sent: Sunday, December 22, 2002 4:40 PM Subject: mysql.sock Hi how can I do to restore mysql.sock? Thank in advance

Re: reusing auto-increment values

2002-05-20 Thread Peter Hicks
Hi Martin What about using a REPLACE or UPDATE rather than a DELETE/INSERT? Peter. On 20 May 2002, Martin Skjöldebrand wrote: Hi, It's kind of embarrasing this, but ... How do I resuse autoincremented values after a delete? Do I specify it in the table somehow? Like _not_ having

Emulating a subselect

2002-03-17 Thread Peter Hicks
Hi everyone Maybe somebody can help me with what seems like a tricky subselect-avoidance question? In a MySQL database, there are two tables - 'reports' and 'reports_signup'. 'reports' has two columns, 'id' and 'report_name'. 'reports_signup' has three columns - 'id', 'report_id' and