; INDEX(comment_id, hashtag)
>> > ) ENGINE = InnoDB;
>> >
>> > One might want to "normalize" the hashtags, but it does not seem
>> > warranted in this situation.
>> >
>> >> -Original Message-
>> >> From: Hank [mail
gt;
> > One might want to "normalize" the hashtags, but it does not seem
> warranted in this situation.
> >
> >> -Original Message-
> >> From: Hank [mailto:hes...@gmail.com]
> >> Sent: Friday, October 19, 2012 8:58 AM
> >> To: MySql
to "normalize" the hashtags, but it does not seem warranted in
> this situation.
>
>> -Original Message-
>> From: Hank [mailto:hes...@gmail.com]
>> Sent: Friday, October 19, 2012 8:58 AM
>> To: MySql
>> Subject: Schemas for storing and reporting on ha
)
) ENGINE = InnoDB;
One might want to "normalize" the hashtags, but it does not seem warranted in
this situation.
> -Original Message-
> From: Hank [mailto:hes...@gmail.com]
> Sent: Friday, October 19, 2012 8:58 AM
> To: MySql
> Subject: Schemas for storing and repor
Are there any established "best practices" or schemas for
incorporating twitter-like hashtags into a database ?
Let's say I have a blog with a commenting system, and I want to allow
people to add hashtags to the comments.
I could certainly create one on my own (it's not that difficult), but
I'd
Debian squeeze, mysql Ver 14.14 Distrib 5.1.49, for debian-linux-gnu
(i486) using readline 6.1, PHP 5.3.3-2 with Suhosin-Patch (cli) (built:
Oct 21 2010 18:58:27).
I'm not sure if this group or the php one is more appropriate but
thought I would try here first as it is perhaps a mysql setting I
Another tidbit about this:
Windows-based browsers apparently translate between CP-1252 and UTF-8
automatically. This generally doesn't cause trouble, but it cost me a lot of
sweat and tears to figure out.
I never looked to see what *nix-based browsers do, I ran out of time and
energy.
Regards
On 1/19/10 2:19 AM, "Ningappa Koneri" wrote:
> 3.It worked even after removing tag from the head tag as well <-- plz
> through some light y it got displayed at the browser ?
this is not a mysql question. but see:
http://www.w3.org/TR/1999/REC-html401-19991224/charset.html#h-5.2.2
the likelih
style | www.comviva.com
-Original Message-
From: fsb [mailto:f...@thefsb.org]
Sent: Tuesday, January 19, 2010 2:35 AM
To: Ningappa Koneri; mysql@lists.mysql.com
Subject: Re: Regarding storing non-english chars in mysql
you can specify the character encoding (called CHARSET in mysql) and
co
ginal Message-
> From: Ningappa Koneri [mailto:ningappa.kon...@comviva.com]
> Sent: Sunday, January 17, 2010 11:32 PM
> To: mysql@lists.mysql.com
> Subject: Regarding storing non-english chars in mysql
>
> Dear all,
>
> I have a problem in migrating a GUI app(displays multi lingua
http://dev.mysql.com/doc/refman/5.0/en/charset.html
-Original Message-
From: Ningappa Koneri [mailto:ningappa.kon...@comviva.com]
Sent: Sunday, January 17, 2010 11:32 PM
To: mysql@lists.mysql.com
Subject: Regarding storing non-english chars in mysql
Dear all,
I have a problem in
Dear all,
I have a problem in migrating a GUI app(displays multi lingual data like
Arabic) which currently uses oracle as backend db to mysql (5.1). Currenly in
oracle I am using NVARCHAR datatype to store the Arabic chars. How do I
incorporate the same functionality in mysql ? I have tried a s
For whatever it's worth, some years ago I wrote a database that kept track
of IPs. I found it very easy if I treated the IPs as numbers.
Each IP is a quartet of digits, each in the range 0-255. This really means
an IP is a 4-digit number in base 256 and you can use use standard
conversion functi
Hi,
I need to be able to store data from our Radius servers that includes IP
addressing and IP blocks into a MySQL field that is easily searchable.
Basic IP addreses I have sorted with INET_ATON(), but is there a way to
store blocks of IP's as in "192.168.1.0/24" in a way that would allow it
ssed locations
_handledLocations.Add(_locationToProcess);
}
return _shortestPaths;
}
Thanks
Martin-
- Original Message -
Wrom: PKYLEJGDGVCJVTLBXFGGMEPYOQKEDOTWFAOBUZXUWLSZL
To:
Sent: Saturday, March 01, 2008 7:19 PM
Subject: Re: Efficiently storing a directed graph
Kelly,
I&#x
Kelly Jones wrote:
I have a directed graph (nodes and edges) that I want to store
"efficiently": given two nodes, I want to quickly find the shortest
path between them. The graph is NOT acyclic (it's not a tree), is
fairly "sparse" (about 1 edges for 2500 nodes), and changes
occasionally.
I
WFAOBUZXUWLSZL
To:
Sent: Saturday, March 01, 2008 7:19 PM
Subject: Re: Efficiently storing a directed graph
> Kelly,
>
> > I'm not married to using SQL: are there other efficient solutions to
> > store directed graphs? Could I hack something up in Perl or Ruby and
>
Kelly,
I'm not married to using SQL: are there other efficient solutions to
store directed graphs? Could I hack something up in Perl or Ruby and
then serialize my in-memory graph to a file (for efficient
saving/reloading)?
Did you look at Dijkstra's algorithm?
PB
--
MySQL General Mailing Lis
I have a directed graph (nodes and edges) that I want to store
"efficiently": given two nodes, I want to quickly find the shortest
path between them. The graph is NOT acyclic (it's not a tree), is
fairly "sparse" (about 1 edges for 2500 nodes), and changes
occasionally.
I know PostgreSQL/MySQL
I'm curious if anyone has any thoughts on how I can handle a data
retention issue I've been facing with a larger dataset.
My process, roughtly is run mysqldump against the DB and gzip the
output. Then I transfer it off to a different machine for archival
onto optical media (yes I know the
Hey all,
I'm curious if anyone has any thoughts on how I can handle a data
retention issue I've been facing with a larger dataset.
My process, roughtly is run mysqldump against the DB and gzip the
output. Then I transfer it off to a different machine for archival
onto optical media (yes I
Hi,
Thanks for the link
Is there standalone jar/zip Just for auto_ef
Also see Perl module Encode::Guess. There are others out there as well.
Regards,
Jeremy
--
high performance mysql consulting
www.provenscaling.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Solaris Express Developer
Edition [x86] is a wonderfully simple install.
~mm
>
> Thanks again
> Martin--
> - Original Message -
> From: "Michael Monaghan" <[EMAIL PROTECTED]>
> To: "Bharat" <[EMAIL PROTECTED]>
> Cc:
> Sent: Wednesd
t encoding.
Free Solaris download for x86 platforms at developers.sun.com/sxde ]
~mm
> it is storing the text like ("??"), but when i retrieve it display
> proper rabic text.
>
> my table structure like that
>
>
> CREATE TABLE `mdl_jobs` (
> `id` int(11)
ت").
one more thing that when i edit any fields with arabic text. it is storing the
text like ("??"), but when i retrieve it display proper rabic text.
my table structure like that
CREATE TABLE `mdl_jobs` (
`id` int(11) NOT NULL auto_increment,
`company` varchar(200) c
This however is not an option at all when you run Apache in prefork
mode. Because the sum of your MaxClients will be equal to the
connections to your MySQL Server.
You can use connection pooling eg SQLrelay
--
Filip Krejci <[EMAIL PROTECTED]>
Linux - und Spass dabei!
--
MySQL General Ma
Hi,
An easier method may be to install mod_log_mysql on each of the Apache
servers and log directly to the central MySQL installation.
Regards
Ian
This however is not an option at all when you run Apache in prefork
mode. Because the sum of your MaxClients will be equal to the
connectio
On 9 Nov 2007 at 10:44, Shaun T. Erickson wrote:
> I pull Apache (combined format) logs, daily, from a number of mirrors,
> back to a central server for processing. I'd like to somehow load them
> in MySQL for analysis.
>
> 1) Does anyone know of a script that can parse the logs and load them?
>
I pull Apache (combined format) logs, daily, from a number of mirrors,
back to a central server for processing. I'd like to somehow load them
in MySQL for analysis.
1) Does anyone know of a script that can parse the logs and load them?
(I presume I can get the DB schema from it.)
2) Can MySQL han
:[EMAIL PROTECTED]
Sent: Monday, October 01, 2007 9:47 AM
To: Rick Faircloth
Cc: MySQL List
Subject: Re: Having trouble storing monetary values...
Hi Rick,
(I'm CCing the list in again -- keeping the discussion on-list lets
everyone see it and potentially solve their own problems by searchi
mber 30, 2007 11:03 AM
To: Rick Faircloth
Cc: mysql@lists.mysql.com
Subject: Re: Having trouble storing monetary values...
Rick Faircloth wrote:
Hi, all.
I'm having trouble storing monetary values.
When MySQL 5.0 stores the entered value of 5.23,
it storing it as 5, dropping off the
Rick Faircloth wrote:
Hi, all.
I'm having trouble storing monetary values.
When MySQL 5.0 stores the entered value of 5.23,
it storing it as 5, dropping off the values after the decimal.
The field is the decimal type with 2 specified as the number
of values to store afte
Hi, all.
I'm having trouble storing monetary values.
When MySQL 5.0 stores the entered value of 5.23,
it storing it as 5, dropping off the values after the decimal.
The field is the decimal type with 2 specified as the number
of values to store after the decimal.
Can a
t: Friday, September 28, 2007 1:55 PM
> > To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> > Subject: Storing Devnagari unicode data in MySQL
> >
> > Namaskar,
> >
> > I am using Windows Xp SP2 and Mysql 5.0.45 and MyODBC 3.51.19 with
> > Microsoft
> > Mar
> -Original Message-
> From: C K [mailto:[EMAIL PROTECTED]
> Sent: Friday, September 28, 2007 1:55 PM
> To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Storing Devnagari unicode data in MySQL
>
> Namaskar,
>
> I am using Windows Xp SP2 and Mysql 5.0
Namaskar,
I am using Windows Xp SP2 and Mysql 5.0.45 and MyODBC 3.51.19 with Microsoft
Marathi Indic IME 1 version 5.
I am storing data in both languages i.e. Marathi and English. So I changed
database character set to 'utf8 -- UTF-8 Unicode' and collation to
'utf8_unicode_ci'
Celko also discusses them in SQL For Smarties.
Baron
Peter Brawley wrote:
Matt
>I'd like to store paths to specific destinations...
See
-- Tropashko's 'materialized modell' eg
http://www.dbazine.com/oracle/or-articles/tropashko4
-- the airports example at
http://www.artfulsoftware.com/mysq
Matt
>I'd like to store paths to specific destinations...
See
-- Tropashko's 'materialized modell' eg
http://www.dbazine.com/oracle/or-articles/tropashko4
-- the airports example at
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html
PB
-
Matt Juszczak wrote:
Hi all,
I'
How about:
$id1 = 1;
$id2 = 0;
while ($id1) /** or ($id2 != 8) **/
{
$sql = "select * from table where id1=$id1";
$row=query($sql);
$id1=$row->id1;
$id2=$row->id2;
do_stuff();
$id1 = $id2
}
On Tue, June 19, 2007 10:58, Matt Juszczak wrote:
> Hi
Hi all,
I've got a table such as the following:
id1 char
id2 char
sample data looks like this:
id1 id2
1 3
2 4
3 5
5 6
6 8
And of course another table has something like:
id info1 info2 info3
1 blahblahblah
2 blahblahblah
Hi,
I ve recently been playing with storing trees in mysql using nested
set, and I was wondering if anyone knows if this could be extended to
forests (set of trees) to be stored in one table?
Many Thanks in advance,
Nathan
--
MySQL General Mailing List
For list archives: http
Nathan,
>I ve recently been playing with storing trees in mysql using nested
>set, and I was wondering if anyone knows if this could be extended to
>forests (set of trees) to be stored in one table?
Dead simple, add a treeID smallint column to the table that holds the
nested sets
- Original Message -
From: "Rolando Edwards" <[EMAIL PROTECTED]>
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, March 22, 2007 3:40 PM
Subject: Re: comparing storing engines
Assuming you have a database, let's call it DAT1 which contain all MyIS
2.
Now you set up tests between DAT1 and DAT2 to compare how all queries behave:
SELECTs OUTER JOINS, VIEWs, ect.
Have fun.
- Original Message -
From: "Octavian Rasnita" <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Wednesday, March 21, 2007 4:14:25 PM (GMT-0500) Auto
Hi,
Is there somewhere a speed comparison between the storage engines that can
be used in MySQL?
Thank you.
Octavian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If your storing files in mysql, it's best to chunk/shard your data if your
not doing so already. Example article/code at:
http://www.dreamwerx.net/phpforum/?id=1
On Thu, 16 Nov 2006, Shain Lee wrote:
> Hi ,
>
> I wanted to store images , musics, videos ..etc in mysql da
From: Shain Lee [mailto:[EMAIL PROTECTED]
> Sent: Thursday, November 16, 2006 5:52 AM
> To: MySql
> Subject: Contents storing in mysql
>
> Hi ,
>
> I wanted to store images , musics, videos ..etc in mysql
> database.storing contents as content type BLOB , i don't
Hi ,
I wanted to store images , musics, videos ..etc in mysql database.storing
contents as content type BLOB , i don't have any issues with that setup.
But , now i need to store that contents in folders and should be kept the
contents path with referrence ofcontents file name .
for ea
Hi,
In my honest opinion, uploading the image to a "preset" directory in the
code, and setting the code to submit the image name, extension, and if
needs be (it shouldnt, because you can set it in the HTML), the
directory. Google has a lot of useful resources on this.
But, if you are really
I've stored millions of images/files in mysql with minimal performance
hit, performance loss is mostly based on your storage implementation.
Checkout this article:
http://www.dreamwerx.net/phpforum/?id=1
On 10/11/06, Greg Donald <[EMAIL PROTECTED]> wrote:
On 10/10/06, Rodney Courtis <[EMAIL PRO
On 10/10/06, Rodney Courtis <[EMAIL PROTECTED]> wrote:
I want to store jpeg images in a mysql database from php in the form of 'blob'
types.
Is this possible and can you detail for me the steps to achieve this?
For a nice size performance hit, yup:
http://www.zend.com/zend/trick/tricks-sept-2
Hi
I want to store jpeg images in a mysql database from php in the form of 'blob'
types.
Is this possible and can you detail for me the steps to achieve this?
Regards and thanks
Rodney Courtis
That is up to 64k bytes, not chars, which might not be the same thing if
UNICODE is used using utf-8/utf-16 or ucs-2 for example. Although this
is usually not an issue in the specific case of an URL.
/Karlsson
Johan Höök wrote:
Hi Peter,
I'd thought I'd just mention that the varchar length
dep
the urls never repeat. and it's a very active table so I don't wanna
compress right now.
And you're right, most URLs are < 255chars, but some are bigger, so
can't use varchar.
I guess I'll just use TEXT :)
Thanks!
Peter
On 9/12/06, Mike Wexler <[EMAIL PROTECTED]> wrote:
Peter Van Dijck wrote:
Peter Van Dijck wrote:
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like th
Hi Peter,
I'd thought I'd just mention that the varchar length
depends on your MySQL version and character set.
5.0.3 and later handles upto 64k chars.
See: http://dev.mysql.com/doc/refman/5.0/en/char.html
/Johan
Peter Van Dijck skrev:
Hi,
URL's have a practical limit of 2083 characters it seem
Hi,
URL's have a practical limit of 2083 characters it seems. To store
these in a space efficient way (I have 1,000,000s of url rows), what's
the best approach? varchar has a 255 maximum, right? Should I just use
TEXT? I'm not searching *in* the urls, I am selecting like this:
"where url = 'xxx'".
Hi Byron,
This should be a relatively simple question but after looking through
the manual for a while I didn't see how to do it. I am working in php
and need to store a large binary number in the database. When I try and
convert it to a int in php its too big so it converts it to a float and
I
You could use the mysql CAST or CONVERT functions
Byron.Albert wrote:
Hey all,
This should be a relatively simple question but after looking through
the manual for a while I didn't see how to do it. I am working in php
and need to store a large binary number in the database. When I try and
co
Hey all,
This should be a relatively simple question but after looking through
the manual for a while I didn't see how to do it. I am working in php
and need to store a large binary number in the database. When I try and
convert it to a int in php its too big so it converts it to a float and
I lo
Hello.
Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I suggest you to check the max_allowed_packet. See:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
Celestino Gomez Cid wrote:
>
Dear All,
I am trying to store (using the C API) a long field in a longblob table
field. The size of the sentence is 2361408 Bytes and when using the
function mysql_real_query it returns an error saying that the MySQL
server has gone. However, if I reduce the data to be stored in a factor
of 4.
Hello.
> If I retrive the same value with the slash (\), not able to display
> properly in the GUI. Do we need to use any MySQL specific functions to
> select such values?.
If you're retrieving the same values which have stored, that this is
rather a GUI problem, not MySQL.
> Is there any way in
Hi,
From the front end I need to use double slashes i.e (\\) to enter
one slash (\) into the MySQL database. I.e, if I enter "Gelb\Paha", it
stores in the mySQL as "GlebPaha", If I enter "S\\Greeen", it stores as
"S\Green" in the database.
Is there any way in MySQL so that I can enter an
Thanks,
I am running MySQL 5.0. So the solution is applicable.
Kuldeep Malik
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 10:00 AM
To: Malik Kuldeep-LKM041; mysql@lists.mysql.com
Subject: Re: Always Storing Upper Case Text in a Table
"Malik Kuldeep-LKM041" <[EMAIL PROTECTED]> wrote on 11/03/2005
10:48:21 AM:
> Hi,
> I have a requirement to always store the UPPER CASE text for the VAR and
> VARCHAR type columns in a table. Is there a way I can specify it during
> the CREATE TABLE statement?
>
> Kuldeep Malik
>
No.
That is
could create an INSERT BEFORE trigger that
uppercases the relevant column values before storing them.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hi,
I have a requirement to always store the UPPER CASE text for the VAR and
VARCHAR type columns in a table. Is there a way I can specify it during
the CREATE TABLE statement?
Kuldeep Malik
--- [EMAIL PROTECTED] wrote:
> Please, please! read up on normalization. The way I
> would probably handle
> this design issue is by creating a separate table of
> taxonomic names (I
> know this is very different than my previous advice
> but I have had longer
> to think about it).
OK, I'll ha
genustaxon_id,speciestaxon_id) to prevent
duplication
a second UNIQUE index would probably also be defined on (commonname) to
also guard against duplicates there as well.
But these taxons also exist in a hierarchy. Using a modified preordered
tree traversal model similar to the one you are tr
David Blomstrom wrote:
I'm still stuck on the problem I asked about a day or
two ago. I'm working on a page at
http://www.geozoo.org/stacks/ that draws data from a
table that lists animal taxons (orders, families,
species, etc.) in a child-parent relationship.
It works exactly the way it should
(Sorry if this is a repeat; I think my first post
didn't go through.)
I'm still stuck on the problem I asked about a day or
two ago. I'm working on a page at
http://www.geozoo.org/stacks/ that draws data from a
table that lists animal taxons (orders, families,
species, etc.) in a child-parent rela
C.F. Scheidecker Antunes wrote:
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
decoding it.
The whole point of MD5 is that you cannot decode it once encoded.
When someone enters their password, just MD5 what th
C.F. Scheidecker Antunes wrote:
I am sorry. I meant another thing and wrote something else.
If I issue: INSERT INTO table1 values ('username',MD5('password'))
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
dec
I am sorry. I meant another thing and wrote something else.
If I issue: INSERT INTO table1 values ('username',MD5('password'))
I will have the password stored in the database with MD5.
What I actually need is a manual way to get the password back, that is
decoding it.
By using a software th
et (0.18 sec)
Partha
--
Partha Dutta, Senior Consultant
MySQL Inc, NY, USA, www.mysql.com
Are you MySQL certified? www.mysql.com/certification
> -Original Message-
> From: C.F. Scheidecker Antunes [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 11, 2005 7:21 PM
> To: mysql
Hello all,
Is there any function that I could use on a SQL statement to store a
password on a table manually using an algorithm like MD5?
Thanks,
C.F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
d: You have an error in your SQL syntax near 'temp'
>
> how do stop mysql from trying to interperate this data and blindly store it
> ??
Another solution would be to base64 encode the data before storing it in the
database.
--
Lamont R. Peterson <[EMAIL PROTECTED]>
F
Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysq
Gregory Machin wrote:
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysq
Hi all.
I'm writing a php script to store the contents of html and php pages
in a data base, it works well until there are mysql queries in the
pages source then give errors such as this one.
Query failed: You have an error in your SQL syntax near 'temp'
how do stop mysql from trying to interper
Per Jessen wrote:
3. Again, as you can understand, I want to minimize the cost here. If
you don't think I can use mysql, do you think Microsoft SQL server is
good enough for this task?
I don't think so, no.
what are you basing this on?
SQL Server is a truly great database package, don't l
he InnoDB engine,
which is not prone to corruption in the same way as MyISAM.
I don't have experience storing large amounts of binary data, so I can't
say anything about MySQL's performance in that area specifically.
2. Can I implement this using regular SCSI disks wit
Cabbar Duzayak wrote:
> So my questions are:
>
> 1. The main question is, do you guys have any experience with this
> much binary and regular data? Do you think Mysql can handle this much
> data in a reliable manner (without corrupting data and/or
> degrading/terrible performance) ?
I would say
Sometimes, the easiest way to do this is to use the file system of the linux
machine to store the files, and make reference to them in the DB...storing
not data in the DB and getting rid of all your possible problems.
Thanks,
Matt Babineau
Criticalcode
858.733.0160
[EMAIL PROTECTED]
http
Hi Everyone,
I will be starting a project for which I will need to store about 1
million image files all of which are about 50-100K in size. I will be
using Linux for this project. The database won't be very busy, there
will be batch image uploads 1-2 times a day, and around 100-200
concurrent use
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
nding date, you can get a list of dates in that period when
> a recurring event occurs.
>
> This should get you going with all the options you need.
>
> Chris Hood
>
> -Original Message-
> From: Ramsey, Robert L [mailto:[EMAIL PROTECTED]
> Sent: Sunday, June
:[EMAIL PROTECTED]
Sent: Sunday, June 12, 2005 8:51 AM
To: mysql@lists.mysql.com
Subject: storing recurring dates
Hi,
I'm doing an event project and some of the events will be reccuring. For
example:
Monday, Wednesday, Friday from 10-11:30 am starting June 1 with no end
date
Every third M
Hi,
I'm doing an event project and some of the events will be reccuring. For
example:
Monday, Wednesday, Friday from 10-11:30 am starting June 1 with no end date
Every third Monday at 3-4 pm starting July 1 and ending January 1 (last event
is third Monday in December)
Every other Friday start
[EMAIL PROTECTED] wrote:
Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,"INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s'))",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,t
Uh-oh ;-)
I think you put the HEX in the wrong part. Shouldn't it be in the VALUES
clause?
snprintf(query_length,query,"INSERT INTO
idsmatch(sip,sport,dip,dport,payload)
VALUES('%s',%d,'%s',%d,HEX('%s'))",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp);
Shawn Green
Database A
Hi,
snprintf(query_length,query,
"INSERT INTO
idsmatch(sip,sport,dip,dport,HEX(payload))VALUES('%s',%d,'%s',%d,'%s')",
inet_ntoa(ip->saddr),dbsport,inet_ntoa(ip->daddr),dbdport,temp);
--
Philippe Poelvoorde
COS Trading Ltd.
--
MySQL General Mailing List
For list archives: http://lists.m
Hello,
I am writing a program for packet sniffing in Linux platform using C
language. I am using MYSQL as my database for storing packet information like
IP, port, packet payload, etc. I have created a table using the following query:
create table idsmatch(sip text,sport integer,dip text
I would like to store the complete database into a WORM device (Write Once Read
Many). I would like to access this database directly from the WORM device and
perform read only SQL statements against this device.
I intend to create the database on a re-writable device (not WORM). At some
point, w
Matthew Boehm wrote:
Hey guys,
(Why is there no C API specific list?)
I want to write a C application that can take some audio file, store it in
MySQL, then at a later date/time (upon request) pull from db and write to
temporary file to be streamed.
I've got the storing portion of the code
Hey guys,
> (Why is there no C API specific list?)
>
> I want to write a C application that can take some
> audio file, store it in
> MySQL, then at a later date/time (upon request) pull
> from db and write to
> temporary file to be streamed.
>
> I've got the storing
Hey guys,
(Why is there no C API specific list?)
I want to write a C application that can take some audio file, store it in
MySQL, then at a later date/time (upon request) pull from db and write to
temporary file to be streamed.
I've got the storing portion of the code down. The problem I
. I have the list configured so
that it
displays the "interest" while the value stored is the "ID". PHP stores
this
entry as an Array which I can easily turn into a comma delimited list
before
storing in the database.
Here's my problem. If I store a comma-delimited lis
- Original Message -
From: "Robb Kerr" <[EMAIL PROTECTED]>
To:
Sent: Sunday, April 03, 2005 12:50 PM
Subject: Multiple Select storing
> Please excuse the length and complexity of this post. I am facing a
> complicated problem and need to find a solution. Also,
1 - 100 of 364 matches
Mail list logo
