t;
> ability to easily poll for partial matches and easily determine gross
> matching rankings makes it useful for many applications.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> Test USER <[EMAIL PROTECTED]> wrote on 12/19/2005 08:28:36 A
; that starts with a
"letter" smaller than "8".
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Test USER <[EMAIL PROTECTED]> wrote on 12/09/2005 05:47:41 PM:
> Oh, is it really such a bad design? Here is some more.
> What is substring
When using IN should i design the database to use int's or is the performance
equal?
WHERE col IN('test','test2','test3')
vs
WHERE col IN(1,2,3)
-
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
MySQL General Mailing List
Fo
han 120 and
250. And my concerne is that i might be situations where it thinks that 80
should be returned when doing a >=120.
Quoting Michael Stassen <[EMAIL PROTECTED]>:
> Test USER wrote:
> > Hi again :)
> >
> > The table contains a column named value and is in th
esolution`,`hw_port`,`cd_supp_format`
>
> Your data is unmanageable in its present format and you need to scrub
> and
> massage it into shape before what you have will be marginally useful.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
Sorry for the confusion!
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
>
> Test USER <[EMAIL PROTECTED]> wrote on 12/09/2005 04:28:44 PM:
>
> > Hello, thanks for your help!
> > I dont really get it :)
> >
> >
this still have their place.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> Test USER <[EMAIL PROTECTED]> wrote on 12/09/2005 03:30:17 PM:
>
> > in an application i have written there is the need to do a search from
>
> mysql
in an application i have written there is the need to do a search from mysql
using numbers that are stored in a varchar column. it is not possible to store
only the results with numbers in a seperate column.
so i was looking at CAST(), is this a big performance loss? is there some way
of benchma
i´m using mysqldump to dump some tables and then load it into another mysql
server with mysql command.
but can i specify what columns in the tables to dump?
i´m using something like this now
mysqldump -h localhost -u root db tbl | mysql -h xxx.xxx.xxx -u login -pass -w
db
> the wget inline though, or at least write something in shell or perl to
> do it. Is this cron'd or something, or a one time thing?
>
>
>
> -
> Sent from my NYPL BlackBerry Handheld.
>
>
> - Original Message -
> From: Test USER [EMAIL
Can't get this to work, but i would like to specify LOAD DATA to use an INFILE
from an URL.
For example
LOAD DATA LOCAL INFILE 'http://www.testserver.com/data.csv'
But i get an error message saying file not found.
Anyone know if this is even possible ?
-
Thanks i also found the function CAST which works ok.
So now i have three options:
CAST
LPAD
Adding zero
Any other sugestions are welcome!
Quoting [EMAIL PROTECTED]:
> Test USER <[EMAIL PROTECTED]> wrote on 11/23/2005 07:36:43 PM:
>
> > Is the only way to sort numbers s
Is the only way to sort numbers stored in a varchar column to use lpad?
Are there any other columntypes that allow both characters and numbers that can
sort numbers correct?
-
FREE E-MAIL IN 1 MINUTE!
- [EMAIL PROTECTED] - http://www.pc.nu
--
MyS
13 matches
Mail list logo
