ocking for these) and put all
the lookup tables in MyISAM.
The benchmarks I have looked at don't seem to reveal either as a clear winner,
but I am probably not interpreting them properly.
Thanks for much in advance for any help on this question.
Richard
--
MySQL General Mailing List
Fo
Hello,
I'm programming with PHP+Mysql a CMS system to easily update my site.
I want to have a list of titles to which I can add new ones either at
the end of the list or in a chosen position so I can choose what order
they show up in.
The first solution that I thought of was to add one to all
why I would need to be able to combine : "SELECT
a.message,a.date,b.surname,b.name,b.title FROM messages a JOIN info b ON
a.from=b.code WHERE a.id='28'"
and "ORDER BYnum DESC LIMIT 1"
I hope I've been clear enough ... thanks in advance :)
Richard
ame
---
message1 | name3
message2 | name3
message3 | name3
Of course I have simplified everything down to the minimum :)
Thanks in advance,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Richard a écrit :
Sorry about my last email which was long and not clear.
This is what I want to do
Join two tables on "code table1" = "code table3" where messageid = for
example 28
table 1 contains :
message from
Hello, I'm in the process of programming a customer area with a list of
subscriptions :
Reference | Title | Type | Date of first subscription | Expires
Each item in this list will have a link to it's details with will show a
list like this :
Subscribed on : date of first subscription
Renewed
Richard a écrit :
Hello, I'm in the process of programming a customer area with a list
of subscriptions :
Reference | Title | Type | Date of first subscription | Expires
Each item in this list will have a link to it's details with will show
a list like this :
Subscribed on : dat
Richard a écrit :
Richard a écrit :
Hello, I'm in the process of programming a customer area with a list
of subscriptions :
Reference | Title | Type | Date of first subscription | Expires
Each item in this list will have a link to it's details with will
show a list like this :
bruce a écrit :
Hi..
Fairly new to mysql, in particular tuning.
I have a test mysql db, on a test server. I've got a test app that runs on
multiple servers, with each test app, firing/accessing data from the central
db server.
the central server is on a 2GHz, 1GMem, 100G system. MySQL is the b
don't want :
Colour
Red
Blue
Green
Red
Red
Blue
How would I achieve the first result with mysql ? Is it possible?
Thanks in advance,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
To: Richard
Cc: mysql@lists.mysql.com
Subject: Re: select unique ?
Try:
SELECT DISTINCT Colour FROM table;
Or, if you want to do it correctly:
SELECT Colour FROM table GROUP BY color;
Richard wrote:
Hello,
I don't know if it is possible to do this with mysql alone ...
Here goes :
I
Hello,
I need to insert one entry(one line) containing 10 values, some from a
form(ok) but some from two other tables, what is the best way to do this ?
Say for example I need to enter this information :
first_name - last_name - age - sexe - username - email - favorite_colour
- hobby - inscr
Thanks it works great ! :)
Dan Buettner wrote :
Richard, it's possible, & your syntax is pretty close.
Try this:
INSERT INTO info_stamp
(fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date)
SELECT $fav_colour, $hobby, $time, a.firstname, a.
first_name, a.last_name,b.(SELECT COUNT(*) AS count
FROM login_table b WHERE a.username = b.username) FROM user_list a
I know that the above query can not work but It's just to give a better
idea about what I'm trying to do . :)
If I do a join, I will the username repeated for each
once the result is 1 (because of the group by ...).
Thankyou
Peter Brawley a écrit :
Richard,
>Can I do something like this :
>SELECT a.username, a.first_name, a.last_name,b.(SELECT COUNT(*) AS count
>FROM login_table b WHERE a.username = b.username) FROM user_list a
Try ...
SE
Sorry it's me again, I made a mistake, it counts the number of logins
correctly, but does not show members with 0 logins !
Any idea how to do this?
Thanks :)
Peter Brawley a écrit :
Richard,
>Can I do something like this :
>SELECT a.username, a.first_name, a.last_name,b.(S
also suggested a LEFT OUTER JOIN but have read that it is a
synonym to LEFT JOIN, is this the case or is there a difference between
the two?
Thanks again,
Richard
David Schneider-Joseph a écrit :
Try this one:
SELECT a.username, a.first_name, a.last_name,COALESCE(COUNT(b.username),
0) AS count
Hello,
I've got a table which containes two date colomns.
The first one is called `date` and the second `update`
In the first one I put the ticket creation date, and on update I add or
change the update value.
So the update colomn does not contain a value until the first update has
been done.
I
eated end desc;
/Kristian
On Tue, Apr 8, 2008 at 1:04 PM, Richard <[EMAIL PROTECTED]> wrote:
Hello,
I've got a table which containes two date colomns.
The first one is called `date` and the second `update`
In the first one I put the ticket creation date, and on update I add or
ch
ocess.). I hope my explanation in understadable ...
:)
Rafael Barbolo Lopes a écrit :
Can't you do Something like:
ORDER BY (update,date)
The major column of ordering would be update and the second date.
I'm not sure about this "solution"
On Tue, Apr 8, 2008 at 8:54 AM,
0 | 90 | 100 |
| 2 | 10 | 60 | 70 |
| 6 | 50 || 50 |
| 4 | 30 || 30 |
| 3 | 20 || 20 |
| 1 |1 ||1 |
+-+--++--+
Richard wrote:
Thanks,
I think that your solution will be sufficient for my needs, howeve
to have a limited number of results on one page.
Every time a question is answered the update date will change, and the
status could also change. So I don't see how to easily do this by
creating another table.
Ben Clewett a écrit :
Richard,
No problem, glad it works. But note: this i
differentiate between rows that are new vs rows that
are updated, (date = update) => new. You can put an index on this field
and not have the performance issue to worry about.
Just a thought.
andy
Richard wrote:
Thanks,
This is for the unanswered list of questions, so the output list (not
the list sto
Hi I think you would do this :
SELECT
sf_conferences.id,
sf_conferences.name,
count(*) AS `count`
FROM
((
LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
LEFT sf_threads ON sf_forums.id = sf_threads.forumidfk)
LEFT JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk
GROU
Hi,
I have a table (structure below) which will hold 2.5 billion rows. I'm
currently choosing the hardware i'll need. Does anybody know what the
minimum spec of machine is likely to be that I comfortably use? I
imagine the table will have to be Innodb split across a number of files.
It will
Hello everyone,
I'm new to this list, so I hope that this is the right one for this
question.
My system runs on Debian sarge with Apache2 and mysql-server-5.0
installed with apt-get, the mysql package comming from the dotdeb backdoor.
My server is going to host a forum that is actually on a
Juan Eduardo Moreno a écrit :
What a fu...?
On 2/24/07, nessah arezki <[EMAIL PROTECTED]> wrote:
Bonjour ;
Je suis un étudiant en fin de cycle. Dans le
cadre de mon projet de fin d'étude, je devais transférer une base de
données
sous Access à MySQL. J'ai effectué le
Peter Brawley a écrit :
S/he is asking how to transcend a 2G table size limit.
Nessah, file size limits are usually due to the operating system. I
think Windows FAT32 systems impose a 2G limit.
PB
-
Juan Eduardo Moreno wrote:
What a fu...?
On 2/24/07, nessah arezki <[EMAIL PROTECTED]>
Hello,
Is it possible to restaure a .sql file encoded in utf8 to mysql with
mysql client set to latin1?
I've got a forum on a server which has got it's client set to utf8
I need to move the forum to a new server. But this new server has got
postfix and proftp that seem to need the mysql clie
e any setting that seems
to block this. If you need any further information please let me know
Thanks in advance,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have a server (master version 4.0.1) that has a database that I want
to replicate on another server (slave version 4.1.20).
The slave already has another db on it. Is is possible to have a mixture
of replicated and non replicated dbs running on a slave?
cheers
Rich
--
MySQL General M
; of course
>
> setup by the option replication-do-db or replication-ignore-db :)
>
> richard wrote:
>>
>> Hi,
>>
>> I have a server (master version 4.0.1) that has a database that I
>> want to replicate on another server (slave version 4.1.20).
>> The
Ian P. Christian wrote:
> richard wrote:
>
>> as far as I can see, these commands select which db's to replicate on
>> the slave that currently exist on the master server.
>> What i am asking is, if I set a server up as a slave, can I have other
>> database
le and get the correct error when I try to add or update the table
with duplicate key fields.
--
Cheers Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ssage, reference and name ...
Is this possible with one query?
Thanks !
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ess I will have to manage this with the php code and not get the
result directly from the sql query; thanks anyway !
Peter Brawley a écrit :
That query will give one row per table1 row matching your WHERE
clause, with matched row from table2. Is that what you want?
PB
Richard wrote:
Than
t;Mrs Harrison"
"message4 text"| "Mr Smith"
Is this clearer ?
Thanks :)
Peter Brawley a écrit :
Richard,
This is elementary---you most definitely do not need to do it with PHP
code. Given tables messages(senderid, message, reference) and
senders(senderid, name, addre
7;Mrs Harisson' );
SELECT m.message, m.reference, s.name
FROM messages m
JOIN senders s ON m.sender=s.memberid
WHERE m.reference='05';
+---+---+--+
| message | reference | name |
+---+---+--+
| message1 text | 0
Hello, I've got a good book for learning php, very complete and goes
through almost everything. However I'm now looking for a good mysql
book. I don't want ebooks, only paper versions.
I know how to connect and the real basics of mysql (I can connect, do a
basic search, insert data etc ... but
r if you say it's good in english then I will go ahead and order it !
sol beach a écrit :
MYSQL Third Edition by Paul DuBios (a frequent list contributor)
On 8/2/07, Richard <[EMAIL PROTECTED]> wrote:
Hello, I've got a good book for learning php, very complete and goes
t
nglish?
Thanks,
Bob
On 8/2/07, *Richard* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
wrote:
Hello, I've got a good book for learning php, very complete and goes
through almost everything. However I'm now looking for a good mysql
book. I don't want ebook
Sorry maybe this is completly out of topic, but why do you need it to
synchronise in two locations, can't you just get both servers to connect
to the same database?
And then if you need you can set a cron to backup your database hourly
or daily to the other server using mysql dump and scp.
I d
> Date: Wednesday, March 09, 2016 14:38:45 +
> From: lejeczek
>
> hi everybody
>
> I imagine this is theoretical rather than practical question,
> albeit I don't have much practice, so I hope experts could comment
> logical view of the procedure is: mysqldump && truncate - what are
> the ch
> Date: Monday, October 03, 2016 18:39:22 -0700
> From: James Moe
>
> opensuse v42.1
> linux 4.1.31-30-default x86_64
> 10.0.26-MariaDB
>
> I have a database named "sma-v4-01". The GRANT statement does not
> like that database name:
>
> MariaDB [sma-v4-01]> GRANT ALL ON 'sma-v4-01'.* TO
> 'xxx
> Date: Monday, October 03, 2016 23:18:14 -0700
> From: James Moe
>
> On 10/03/2016 08:16 PM, Richard wrote:
>> If you want/need to use it I believe you need to use the
>> "backtick" to quote the name
>>
> Yes, that worked. Thank you.
> Is the
then have to go re-code
half the scripts/databases.
Thank you in advance for any tips/advice you have.
Richard
FRHweb
;
Just checking a second time for anything where the year is less then the
current will cover previous year, regardless of the month, then everything
within this year is covered by the first check.
So far it's working. I'm still open to better ways though ;o)
Thanks,
Richard
- Or
Okay, that sounds good and all, but how does that help me, since the date is
chosen
from the javascript "calander" in this format: mm/dd/
So then, when I'm selecting a date of at least todays value, or less in the
database
how would I do it, since it's in mm/dd/yy
Does anybody know of any issues when have a large (+1000) databases in
MySQL?
It will be running on RedHat 9. Would there be any problems running backups
with this many DBs on
one box?
Regards
Richard
- Original Message -
From: "Harald Fuchs" <[EMAIL PROTECTED]>
To: &
, is it possible ?
How ?
Thank for your help.
--
Regards,
Richard
___
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>
>mysql,query
>
>
>Hi , is there any way of performing something like the below statement?
>
>select * from table1,table2 where table1.column1 like table2.column2
>
>thanks in advance
>
>Rich
-
Before posting, please check:
Hi,
SELECT columns
INTO OUTFILE 'path/to/directory/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n"
FROM table
for more info checkout:
http://www.mysql.com/doc/S/E/SELECT.html
cheers
Richard
At 11:06 04/03/20
Hi I have 2 SQL fragments that pull up 2 differing results and I have no
idea why. The two pieces of code are identical bar one line which is :
AND individual_id ='AB00090004' AND Category = 'DXS1047'
The code that produces the correct code is:
select Raw3_2.category,
Raw3_2.Individua
>
>Hi I have 2 mySQL fragments that pull up 2 differing results and I have no
>idea why. The two pieces of code are identical bar one line which is :
>
>AND individual_id ='AB00090004' AND Category = 'DXS1047'
>
>The code that produces the correct code is:
>
>select Raw3_2.category,
> Ra
he concept (as I did).
--Richard
>
> By the way you're using the terms, I would guess you're hoping
> to make a new database, and place it "on the web".
>
> In that case, Mysql is probably at too low a level of
> detail for your needs. To solve your probl
ts to it, such as
"DELETE FROM table1" or DROP DATABASE. You can protect it in a variety of ways
such as: put it in a password protected directory, have it test for and reject
operations you don't want to happen,
require additional parameter(s) which validate the user, etc.
-
or sequentially.
However, I suggest you just try it if you can, and let us know what you find.
--Richard
> Can you please tell me, is it possible to do queries that join MySql tables that
> are in different databases?
>
> I have a couple of Delphi database programs that use Parado
join tables in the
> local and the server db's.
--Richard
> It's perfectly possible to join tables from different databases, as long
> as the databases are managed by the same server. Just qualify your
> table names with a leading database name.
>
> For example, a join
> where can I find a simple php to generate a default html table
> from a MySql table ?
Try this (but specify your own username, password, database name, and query string
in the first three lines):
");
$numcols = mysql_num_fields($res);
// output field names for column headings:
for ($i=0;
'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/redhat/BUILD/mysql-3.23.49'
make: *** [all-recursive-am] Error 2
Has anyone seen this before?
Thanks,
Richard
-
Before posting, please chec
27;
make: *** [all-recursive-am] Error 2
if I follow this with a make install, it craps out...
\/apps/ is where I keep all my applications before I run and install them...
please help, I have a presentation to do on Monday and this is the LAST
thing I needed !
in desparation,
Richard
[EMAIL PROTE
re: my last email on a failed mySQL database install
sorry !
forgot hte os etc...
OS : RedHat 7.0
running on a Del CPi laptop with 128MEG ram, 4GIG Hd, pentII 266 CPU.
Richard
[EMAIL PROTECTED]
www.stirlingbrig.com
Stirling Brig - Music to Live to
"Great spirits have a
eived
> the following error message: "Can't connect to mysql server or
> localhost (10061)". Any suggestions?
========
Richard Czerwonka, Partner,
FYI Systems, Pe
I have two favourites:
http://www.scibit.com
http://www.microolap.com/index.htm
> Wich VCL is the best to access MySql
> I used Interbase for long time and I think to switch to MySql ofr My
> Delphi Application.
====
Richard Czerwonka, Par
ead, e-mail <[EMAIL PROTECTED]> To
> unsubscribe, e-mail
> <[EMAIL PROTECTED]> Trouble
> unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
> A programming environment;
> A database maintenance utility;
> A database query tool;
> A report builder
====
Richard Czerwonka, Partner,
FYI Systems, Perth, Western Australia,
Delphi dev
er your users to create reports, databases, forms
> and the like, FileMaker is actually a lot easier than Access.
========
Richard Czerwonka, Partner,
FYI Systems, Perth, Western Australia,
Delphi development
o unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
Richard Czerwo
line 288.
make[1]: *** [test_dynamic] Error 255
make[1]: Leaving directory
`/usr/rushclient/src/Mysql_Mod/Msql-Mysql-modules-1.2
214/mysql'
make: *** [test] Error 2
The mysql server is up and running and I do have have
Hi,
How do I Create a Database with Userid and Passwords. Eg. CREATE DATABASE
USER. Such that I am able to login and access the database using this userid and
password.
Thanks
Richard
act updating any rows, I tried:
UPDATE price SET
open='334.25',high='334.25',low='334.25',close='334.25',volume='1' WHERE
assetid=202690 AND date='2006-05-18';
Query OK, 0 rows affected (0.02 sec)
Rows matched: 1 Changed: 0 Warnings: 0
what happens if the row is neither inserted nor updated? Right now it
appears to returns '2'. I think it should return '0'.
Cheers,
Richard.
-Original Message-
From: Richard Dale [mailto:[EMAIL PROTECTED]
Sent: Friday, 19 May 2006 11:23 a.m.
To: mysql@lists.mysql.com
file a bug report.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]
An update - it also occurs in 4.1.19
Bug filed here:
http://bugs.mysql.com/bug.php?id=19978
Cheers,
Richard.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
are really "desperate" to do it using the BLOB type,
http://www.wellho.net/solutions/php-example-php-form-image-upload-store-in-mysql-database-retreive.html
was a help to me when I first started learning.
Hope this helps,
r
#####
Richard Harris
PHP, MYSQ
Hi,
got a Really Simple question, which is probably really easy, but it's
just not starign me in the face.
Is there any "query" in MYSQL (or function in PHP that works with MYSQL)
to remove a value from a field when a new week comes across, or to
remove something from a field on a defined da
* FROM (SELECT * FROM Tbl1, Tbl2) AS foo ORDER BY A;
Why is this? Is it a bug?
Thanks,
Richard
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
sing mytop to see if there are queries going on.
It's like the unix "top" command.
http://jeremy.zawodny.com/mysql/mytop/
Also try:
SHOW PROCESSLIST;
If you use InnoDB:
show innodb status;
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futur
Opteron (x86_64) HOWTO:
http://hashmysql.org/index.php?title=Opteron_HOWTO
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
MySQL General Ma
instance matches 7, but not 5).
Does anyone know how i can get around this problem?
Thanks in advance to anyone who can help! :-)
Richard.
--
Richard Hobbs
[EMAIL PROTECTED]
Visit my web sites: http://mysites.mongeese.co.uk
Would you like jokes in your email? http://jokes.fishsponge.co.uk
Hello,
Perfect :-)
Thank you,
Hobbs.
Quoting Peter Brawley <[EMAIL PROTECTED]>:
Richard
>I would like to display all messages which match both 5 and 7 in terms
>of the parent_id, meaning messages 10 and 13 would be displayed.
SELECT f1.child
FROM foo AS f1
INNER JOIN foo AS f2
tle=Opteron_HOWTO
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: http://lists.mysq
ting area. You will need to install a package
called mysqlclient10-3.23.58-6.x86_64.rpm - I found such a package at my
local mirror here:
http://mirror.pacific.net.au/linux/redhat/fedora/test/3.92/x86_64/os/Fedora/
RPMS/mysqlclient10-3.23.58-6.x86_64.rpm
Best regards,
Richard Dale.
Norgate Investor
OK.
Best regards,
Richard Dale.
Norgate Investor Services
- Premium quality Stock, Futures and Foreign Exchange Data for
markets in Australia, Asia, Canada, Europe, UK & USA -
www.premiumdata.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
MySql v3.23 is part of the Fedore Core 3 distribution. MySQL v4.1 only
became standard in Fedora Core 4.
I suspect it's one of the non-Fedora repositories you're using. Check your
logs and also check /etc/yum.repos.d
grep enabled /etc/yum/repos.d/*
Best regards,
Richard Dal
On Sun, November 6, 2005 2:17 am, Chris W wrote:
> I just tried to use the output of the export function on phpmyadmin
> and
> got a million errors. After looking at the file I found that certain
> columns that are strings were not quoted at all. I can't find any
> reason why some are and some ar
On Wed, November 9, 2005 11:05 am, Chris W wrote:
> Richard Lynch wrote:
>
>>On Sun, November 6, 2005 2:17 am, Chris W wrote:
>>
>>
>>>I just tried to use the output of the export function on phpmyadmin
>>>and
>>>got a million errors. After look
--disable-keys.
The --extended-insert option is responsible for the behavior you´re
getting in inserts statement.
To avoid the --opt option use --skip-opt option and inform other options
separately...
good luck!!!
Richard AB.
- Original Message -
From: "Michael Wil
Hi.
Use the --insert-ignore option of mysqldump.
You can type 'mysqldump --help' on command line to see all options available.
Richard AB.
- Original Message -
From: "Michael Williams" <[EMAIL PROTECTED]>
To:
Sent: Sunday, December 11, 2005
when a new row is
appended or when a old
one is updated.
It seems that MySQL timestamp have changed a lot in 4.1 version.
Good luck!
Richard AB
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Sunday, December 18, 2005 5:03 PM
Subject: timestamp
hi!
I'm
2003-10-09"|23.00|
Obviously my table has many more entries.
Thank you for any help.
Sincerely,
Richard Reina
A people that values its privileges above its principles soon loses both.
-Dwight D. Eisenhower.
3.23.54
Thanks.
Rhino <[EMAIL PROTECTED]> wrote:
- Original Message -
From: "Richard Reina"
To:
Sent: Thursday, January 05, 2006 10:29 AM
Subject: SELECT help.
> Can someone help me write a query to tell me the customer numbers (C_NO)
> of those
Thank you very much to all who responded. I ended up using Shawn's solution,
the others seem good as well.
Thanks again. Have a great weekend.
Richard
[EMAIL PROTECTED] wrote:
Try this:
SELECT c_no
, SUM(1) as total_tx
, SUM(if(`date` >= now() - interval 6 m
I am a novice when it come to queries such as this and was hoping someone
could help me write a query that tells me how many records have the same ID and
vendor number.
|ID | vendor_no | date|
|2354 | 578 | "2005-12-23"|
|2355 | 334 | "2005-12-24
I's so sorry. You are very correct. The sample data is bad. ID should be
unique. Here it is corrected.
|ID| vendor_no| date|
|2354 | 578 | "2005-12-23"|
|2355 | 334 | "2005-12-24"|
|2356 | 339 | "2005-12-26"|
|2357 | 339
table_name_here
GROUP BY ID, vendor_no
HAVING dupes >1;
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Richard Reina <[EMAIL PROTECTED]> wrote on 02/23/2006 12:49:28 PM:
> I's so sorry. You are very correct. The sample data is bad. ID
> should b
ctual length, lots of rows, or both, then varchar
> columns may be faster.
I still think a CHAR field would be faster than a VARCHAR because of
the fixed row length (assuming every thing else is fixed). Perhaps
someone from the MySQL list could clarify...?
--
Richard Heyes
HTML5 Graphing for
on Attributes Null Default Extra Action
space_id int(10) UNSIGNED No auto_increment
scheme_id int(10) UNSIGNED No 0
campaign_id int(10) UNSIGNED No 0
type enum('Text', 'Banner', 'Rich', 'Text in List') latin1_swedish_ci No Text
as you can see campaign_id cl
Nevermind, the problem was not with the DB :\
On Tue, Mar 3, 2009 at 10:44 AM, Richard Whitney wrote:
> Hello.
>
> I am running MySQL 5.0.45
> and have the following query and error:
>
> SQL query:
>
> SELECT SQL_CALC_FOUND_ROWS CONCAT( 'Edit Space' ) A
Sorting a varchar field alphabetically with correct numerical order help
needed
I have a varchar 50 field that contains product names, which are typically
numerical, alphabetical and punctuation thrown in. I would like to have them
returned in some sort of order that is roughly alphabetical, b
1 - 100 of 836 matches
Mail list logo