Hello,
Good post, but not what i'm looking for.
Well, Postgresql seems to be the winner, at least for
handling network addresses.
(Don't take me wrong. I'm not saying Postgresql is better RDBMS)
Thanks.
On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hi,
js wrote:
> Hi Baron.
> Thanks f
Hi,
js wrote:
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
Very true, I didn't quite understand the syntax you were using. But you can still use
bitwise arithmetic to work around this. Scott Noyes wrote a nice
> -Original Message-
> From: js [mailto:[EMAIL PROTECTED]
> Sent: 15 May 2007 15:31
> To: MySQL List
> Subject: Network address functions in MySQL?
>
>
> Hi.
>
> Today I found postgresql's neat feature, inet operators,
> which allows you
Hi Baron.
Thanks for reply.
If I understand correctly,
inet_ntoa() and inet_aton() are not capable of handling CIDR notation.
On 5/15/07, Baron Schwartz <[EMAIL PROTECTED]> wrote:
Hello,
js wrote:
> Hi.
>
> Today I found postgresql's neat feature, inet operators,
> which allows you to do
>
>
Hello,
js wrote:
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' >> inet '192.168.1.5'
http://www.postgresql.org/docs/current/static/functions-net.html
Is there anyway to do this using MySQL?
Yes. Have a look at the inet_ntoa() and i
Hi.
Today I found postgresql's neat feature, inet operators,
which allows you to do
inet '192.168.1/24' >> inet '192.168.1.5'
http://www.postgresql.org/docs/current/static/functions-net.html
Is there anyway to do this using MySQL?
--
MySQL General Mailing List
For list archives: http://lists.
Shoot me now, please.
Thanks - I don't know how I missed that! Thanks - re-ran the query and
things seem to be a-ok!
On Wed, 23 Feb 2005 18:42:17 +0100, Roger Baklund <[EMAIL PROTECTED]> wrote:
> Clarence wrote:
> > I have a log table that records certain transactions on one of my sites.
> > I'm
Clarence wrote:
I have a log table that records certain transactions on one of my sites.
I'm using a timestamp field to mark the date/time of each transaction.
I'm trying to run a query that will display the transactions by date
using the following SQL:
SELECT COUNT(log_id) AS total,
WEEK(FROM_UN
I have a log table that records certain transactions on one of my sites.
I'm using a timestamp field to mark the date/time of each transaction.
I'm trying to run a query that will display the transactions by date
using the following SQL:
SELECT COUNT(log_id) AS total,
WEEK(FROM_UNIXTIME(UNIX_TIM
I guess that would depend on what you consider a "last name" or a "middle
name"
A typical "western" name has 3 parts, like your example. However there are
many names like "van der Plaats" or "de la Hoya" that are not so easy to
detect based simply on what space to split the name at.
What about
Assuming there are no parts of a name that include more than one word
(e.g., "Mary Jo" being someone's first name), an easy way would be to
use SUBSTRING_INDEX.
First Name = SUBSTRING_INDEX( namefield, ' ', 1 );
Middle Name = SUBSTRING_INDEX( SUBSTRING_INDEX( namefield, ' ', 2 ), ' ', -1 );
Last N
How can I extract a middle segment of text in mySQL. For example a column contains
this string: 'William Walker Jones'. I need to split this into the first, middle, and
last names. I can easily extract the first and last names but how do I extract the
Middle name?
Help needed.
To have the possibility to make a nodeview in visual basic, I have made
a child-parent relation in one of my tables.
Table fields:
TTNodeId (autonumber, indicating a node)
NodeParent (NodeNumber of the parent)
NodeLevel (Level of the node)
NodeName (Name of the node)
To make it reada
You could try MySQL 5(it is in alpha state), which comes with stored
procedures, mixing stored procedures and prepered statements could be a
possibility.
About Sybex's book, haven't read it, but Paul's book (Oreilly's) is very
nice. IMHO
Best Regards
On Thu, 2004-03-04 at 23:23, [EMAIL PROTECTE
Hi there, i happened to be peering into the Sybex book on Mysql4 , it was
pretty expensive about 100 AUD is it a good one ? Anyway i had reference to
be able to compile c code into Mysql to add functions into it. Is there
anyway posible to avodi doing this and add it using queries ? Let me know
tha
Try here:
http://www.mysql.com/doc/A/d/Adding_functions.html
--jeff
- Original Message -
From: "a a" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 6:14 AM
Subject: new functions in MySQL ?
> Hi,
>
> Can we create and
Hi,
Can we create and add new functions in MySQL with
windows NT. This fonctions must be developped on
C and C++ ? How compiled this C program in win NT (the
compiled file must be a .so or a .dll file ?)
exemple : SELECT My_Fonction(name) from personnel;
I want to write My_Fonction() and
i [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 12, 2002 3:13 PM
> To: [EMAIL PROTECTED]
> Subject: functions in mysql again
>
>
> Hi again
> I'm getting this message now:
> Supplied argument is not a valid MySQL result resource ..at the 4th line.
> What could be th
Hi again
I'm getting this message now:
Supplied argument is not a valid MySQL result resource ..at the 4th line.
What could be the problem now?
Thx again
function AddItem($OrderID,$ProductID,$Qty)
{
$Datasource = new Datasource;
$result = mysql_query("Select Count(*) FROM orderitemdetail WHERE
Hi
I have a problem with this code. I want to compare the result of the
query that should return the count number of the records in
orderitemdetail. But its not working. What could be the problem?
Thx a lot
function AddItem($OrderID,$ProductID,$Qty)
{
$Datasource = new Datasource;
if (mysql_q
20 matches
Mail list logo
