)
) 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 reporting on hashtags
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
)
) 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 reporting on hashtags
Are there any
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 hashtags
Are there any established best practices or schemas for incorporating
twitter-like hashtags into a database
[mailto:hes...@gmail.com]
Sent: Friday, October 19, 2012 8:58 AM
To: MySql
Subject: Schemas for storing and reporting on hashtags
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
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
On 1/19/10 2:19 AM, Ningappa Koneri ningappa.kon...@comviva.com wrote:
3.It worked even after removing meta 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:
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.
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
[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 lingual data like
Arabic) which currently uses oracle as backend db
-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
collation on a per column
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
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
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
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
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
To: mysql@lists.mysql.com
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
then serialize my in-memory
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
_handledLocations.Add(_locationToProcess);
}
return _shortestPaths;
}
Thanks
Martin-
- Original Message -
Wrom: PKYLEJGDGVCJVTLBXFGGMEPYOQKEDOTWFAOBUZXUWLSZL
To: mysql@lists.mysql.com
Sent: Saturday, March 01, 2008 7:19 PM
Subject: Re: Efficiently storing a directed graph
Kelly,
I'm
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
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
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) collate utf8_unicode_ci default NULL
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) NOT NULL auto_increment,
`company` varchar(200) collate utf8_unicode_ci default NULL,
`position` varchar
Developer
Edition [x86] is a wonderfully simple install.
~mm
Thanks again
Martin--
- Original Message -
From: Michael Monaghan [EMAIL PROTECTED]
To: Bharat [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Wednesday, November 14, 2007 9:39 AM
Subject: Re: Arabic text storing problem
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:
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
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
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
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
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 values after the decimal.
The field is the decimal type with 2 specified as the number
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 searching
archives in future).
It looks to me like it ought
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 anyone
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 after
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'. Also I changed
-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.45 and MyODBC 3.51.19 with
Microsoft
, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-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
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 blahblah
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
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,
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
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, and add
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
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-Detected
Subject: comparing storing engines
Hi
- Original Message -
From: Rolando Edwards [EMAIL PROTECTED]
To: Octavian Rasnita [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
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 MyISAM
tables,
you could
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]
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
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
have any issues with that setup.
But , now i need
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 database.storing
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
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
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:
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
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 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
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
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:
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
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
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
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
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 any
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,
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
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
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 something
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
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
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 trying to implement as a
guide (Storing Hierarchical Data in a Database by Gils Van Tulder
--- [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 have
(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
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]
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@lists.mysql.com
Subject: Storing manually
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
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
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
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
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]
Founder [ http://blog.openbrainstem.net/peregrine/ ]
OpenBrainstem
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
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
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
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
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 so,
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 with regular mysql?
Probably.
Or do I have need advanced
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
__
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]
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
:[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 Monday
.
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 12, 2005 8:51 AM
To: mysql@lists.mysql.com
Subject: storing recurring dates
Hi,
I'm doing an event project and some
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
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:
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
[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')),
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,
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 down
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 have
,
(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 have is, how
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 list in a text field in the
Users table, how do I query to determine anyone
- Original Message -
From: Robb Kerr [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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, I have
1 - 100 of 353 matches
Mail list logo