LIKE '%,8,%' ?
Probably not as elegant as you were looking for, but it works :)
Colin
On Monday 06 July 2009 21:31:51 Highviews wrote:
> Hi,
> I have numbers separated with commas saved into a TEXT Field, for example:
>
> ROW1: 10,5,2,8,
> ROW2: 2,7,9,65
> ROW3: 99,100,55,10,88,
> etc...
>
>
>
On Thursday 27 August 2009 03:35:19 am Sameh Attia wrote:
> Hi,
>Part of our road map is to use an open source database besides
> commercial databases (oracle and sql server), we need to select an open
> source database to build the necessary skills fo
I know this is a mysql mailing list, but
Because these are two quite distinct queries, I don't see an immediate way of
joining them that would make them more efficient. Something that comes to mind
are sub-select statements for example, but that would make this more complex
than it needs to be.
Like Robert said, you aren't giving us
What sort of data? Is it currently stored in a database? If so, how many
tables?
24GB of text data in a single table is quite a bit, but manageable if
maintained properly.
24 GB of binary data on the other hand, is not very much at all.
Colin
On Friday 04 September 2009 12:48:18 pm muhammad
On Friday 04 September 2009 08:15:35 pm muhammad subair wrote:
> On Sat, Sep 5, 2009 at 5:10 AM, mos wrote:
> > At 11:48 AM 9/4/2009, you wrote:
> >> One of my potential clients want to migrate their application to web
> >> based (PHP & MySQL), estimates of the data size is 24GB and growth per
> >
On September 26, 2009 05:10:23 am bharani kumar wrote:
> courier_id consignor_name consignor_address consignor_destination
> consignor_phone
> consignee_name consignee_address consignee_destination consignee_phone
> s_date s_date_mm s_date_ss r_date r_date_mm r_date_ss
> consignment_description no_
On December 13, 2009 01:36:41 pm Richard Reina wrote:
> I was wondering if someone could lend a hand with the following query. I
> have table.
>
> SEARCHES
>
> |ID |trans_no|comp_id|result
>
> 13 | 455| 675| o
> 15 | 302| 675| o
> 16 | 455| 675| o
> 12 | 225|
On January 18, 2010 01:34:15 pm Tompkins Neil wrote:
> Hi
>
> I'm in the process of designing a login system to a secure web page using
> MySQL. One of the features is we need to record and ensure that the user
> password is different from any of the last four passwords he/she has used.
> I was
I agree with Walter, a filesystem is far better suited for this.
That said, mysql does have the ability to do what you are saying, you would
just store it as a
binary blob which is well documented and quite easy to use.
See: http://dev.mysql.com/doc/refman/5.0/en/blob.html
Colin
On January 3
what everyone else said... also, is there a longer version of the error? or is
it literally error 2
or error 22?
Colin
On February 1, 2010 06:38:08 pm kebede teferi wrote:
> Hi, I'm very new to this and I need help.
>
> What I want to do is to execute a source command statement from cmd to
>
Yeah, its just a shell script that acts as a wrapper around the mysql processes
on debian systems(
maybe others, I'm not sure)
You can read it at 'less /usr/bin/mysqld_safe'
Colin
On March 29, 2010 11:51:36 am Glyn Astill wrote:
> --- On Mon, 29/3/10, Brown, Charles wrote:
> > Hello All. wh
Seriously...
I found the answer in the first result.
http://lmgtfy.com/?q=mysqli+multiple+insert+statements
Assuming mysqli, if you are using a different driver, then google that
Colin
On April 11, 2010 10:36:41 pm viraj wrote:
> is it mysqli query or 'multi_query'?
>
> http://php.net/manual/e
t; be a security issue as the vast majority of simple PHP-based SQL
> injection attacks only work on servers that allow multiple statements.
>
> I haven't been deep in PHP land for a little while, but I think you
> will find the default driver/config is expressly preventing you fr
How recent is your source tree? It looks like it may be a recent issue, so
going back 6 months or so
might solve it.
The bug report you noted doesn't seem to have a work-around, though I would
guess you could look at
the source and probably fix the issue quite easily. It looks like you have do
On May 20, 2010 11:35:32 am John G. Heim wrote:
> Right now I have the spamassassin bayesian rules database in mysql myisam
> tables on our mail server. I want to move it to our database server.
> Mysqltuner tells me that the read/write ratio is 10/90. 90% writes.
>
> Given a database that is doi
On May 20, 2010 08:32:56 pm Noel Butler wrote:
> On Thu, 2010-05-20 at 16:27 -0700, Tim Gustafson wrote:
> > Hi,
> >
> > I'm not sure if this is already an open issue or not - a Google search
> > resulted in various discussions but I didn't find any open
> > support/feature request.
> >
> > It w
On May 20, 2010 09:55:41 pm Tim Gustafson wrote:
> > Use postgres, you can assign tablespaces to a partition
> > of the size you want. When it gets full, writes are
> > refused. I'm not sure how nicely that is handled ( in
> > terms of error output ) but the advantage is that Pg is
> > ACID compli
17 matches
Mail list logo
