or be
prepared for performance hits whenever you need numeric ordering. If you
compare them alphabetically, 8 comes after 1 so 8 is greater than
10, 100, 1000, 20, 30, or any other word that starts with a
letter smaller than 8.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Test USER
applications.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Test USER [EMAIL PROTECTED] wrote on 12/19/2005 08:28:36 AM:
Great, :)
But do you know how to write a good select query using this design?
For example if i want to select all TV with widescreen and inch
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
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
using numbers that are stored in a varchar column. it is not
possible to store
only the results
- 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 :)
You suggestion is to have a seperate column with the name numericvalue
and
insert userinput into that and add a zero, right?
Could you explain
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
Test USER [EMAIL PROTECTED] wrote on 12/09/2005 04:56:21 PM:
Hi again :)
The table contains a column
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 the format
varchar(255).
This column
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
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
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 ?
, 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 PROTECTED]
Sent: 12/01/2005 04:55 AM
To: mysql@lists.mysql.com
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 stored in a varchar column
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
--
13 matches
Mail list logo