Im trying to select an IP from a TEXT (details) type field, which works if I do
this:
select id from `table` where `details` like '%192.168.0.1%' :
But If I want any record with an IP in that TEXT type field it seems a little
tricky.
I have tried:
select id from `table` where INET_ATON(details)
Im trying to select an IP from a TEXT (details) type field, which works if I do
this:
select id from `table` where `details` like '%192.168.0.1%' :
But If I want any record with an IP in that TEXT type field it seems a little
tricky. I have tried:
select id from `table` where INET_ATON(details)
I have a TEXT field in my db (4.0) that has lists of IP numbers; can a
full-text search be done for IP numbers?
If so could you show me an example query?
Thanks
Rob
I am storing ips in a mysql 4.0.17 db as int. I am Converting them using
a perl script with inet_aton to create a four-byte string.
My goal:
Is to return the ip as a normal dotted ip for the user to see after a select
statement is done
via a php web page. The ip is entered in as a dotted ip on the
Is there any benefit to having the .MYD files on one drive, and the .MYI on
its own dedicated hard drive??
rm
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
eed Innodb?
On Fri, 16 Jan 2004 13:43:55 -0800
"Ron McKeever" <[EMAIL PROTECTED]> wrote:
> Scenario 1:
> I have noticed that if two users open a record to edit it
> in two different browsers
> and they edit the same field and then click update,
> the last user/browser
Hi
I have a web app that use's PHP/Mysql/MYISAM. I am starting to think I need
INNODB table type.
Scenario 1:
I have noticed that if two users open a record to edit it
in two different browsers
and they edit the same field and then click update,
the last user/browser gets written to the db,
where
I'm trying to use mysqimport instead of LOAD DATA INFILE from a shell
script. I notice an option for mysqlimport is not working or im doing it
wrong.
This works with LOAD DATA INFILE :
mysql -e "LOAD DATA INFILE 'x' INTO TABLE x IGNORE 2 LINES"
but when i try:
mysqlimport --ignore-lines=2 -uro
Hello,
I have a db(logs) that I have been working on. This db has tables that are
created every month, they are Nov03,Dec03,Jan04, etc..
Each month/table has about 480,000,000 records. Data file is about 80GB the
index file is about 40GB.
Mysql/apache run on a Dell 2550 4gb ram 2cpu's OS - RH 9. I
Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:55 AM
To: [EMAIL PROTECTED]
Subject: Re: unixtime update syntax
On 2 Dec 2003 at 7:57, Ron McKeever wrote:
> I have a db that gets data dumped into it. One of the columns gets
> unix timestamp data
(0.00 sec)
Any ideas?
Ron
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:30 AM
To: Ron McKeever; [EMAIL PROTECTED]
Subject: RE: unixtime update syntax
The time zone matters... your results are exactly 8 hours off... PST is
gmt -8.
Anyone have a response to the following:
Hi
I have a db that gets data dumped into it. One of the columns gets unix
timestamp data "utime".
I what to covert that into a datetime column so I can utlize indexes and
such.
But I still what the unixtime to remain.
I know I can get the data I want wit
Hi
I have a db that gets data dumped into it. One of the columns gets unix
timestamp data "utime".
I what to covert that into a datetime column so I can utlize indexes and
such.
But I still what the unixtime to remain.
I know I can get the data I want with php or mysql to convert it, but I need
b
Chris,
Thats not what i think im Asking.
I was wondering if its possible to have a
AUTO_INCREMENT ID
number also have the format mmddyy.
So when you query the table it would be the PRIMARY KEY AUTO_INCREMENT ID
field:
select * from table:
name email phone ID
Bugs [EMAIL
Hi
I have a .txt file that is loaded into my table. This is done
using LOAD DATA INFILE
One of the columns data is a unix timestamp from the .txt file.
The column is called begin.
I have created the column as a varchar before
and then converted the date using FROM_UNIXTIME(), so it can be rea
Hello
I have a table that gets appended to every night with the LOAD DATA command.
The column 'start' is a unix timestamp. So when the LOAD DATA is done I then
want to update the Column to be human readable.
I was thinking of the following:
UPDATE table SET start = UNIX_TIMESTAMP(start);
I issu
16 matches
Mail list logo