Access speed INNODB VS. MyISAM

2006-06-03 Thread Richard
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

Inserting a value in an autoincrement list?

2007-10-30 Thread Richard
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

help with a query...

2007-12-28 Thread Richard
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

Help with query, (question simplified as last mail was very complicated to understand :))

2007-12-28 Thread 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]

Re: Help with query, (question simplified as last mail was very complicated to understand :))

2007-12-30 Thread Richard
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

Looking for a more efficient way to achieve the same result.

2008-01-30 Thread Richard
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

Re: Looking for a more efficient way to achieve the same result

2008-01-31 Thread Richard
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

Re: Looking for a more efficient way to achieve the same result -> Found solution but would still like some advice :)

2008-01-31 Thread Richard
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 :

Re: memory usage - mysql tuning!!

2008-02-13 Thread Richard
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

select unique ?

2008-02-14 Thread Richard
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]

Re: select unique ? (solved thankyou :))

2008-02-16 Thread Richard
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

insert new records from other tables

2008-02-17 Thread Richard
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

Re: insert new records from other tables [ solved, thankyou :) ]

2008-02-17 Thread Richard
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.

group a select * and a select COUNT from 2 different tables using result of first table to do the COUNT ... is it possible ?

2008-02-19 Thread Richard
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

Re: group a select * and a select COUNT from 2 different tables using result of first table to do the COUNT ... is it possible ?

2008-02-19 Thread Richard
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

Re: group a select * and a select COUNT from 2 different tables using result of first table to do the COUNT ... is it possible ?

2008-02-19 Thread Richard
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

Re: group a select * and a select COUNT from 2 different [... ] (solved thankyou !)

2008-02-20 Thread Richard
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

Help with ORDER BY using two colomns

2008-04-08 Thread Richard
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

Re: Help with ORDER BY using two colomns

2008-04-08 Thread Richard
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

Re: Help with ORDER BY using two colomns

2008-04-08 Thread Richard
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,

Re: Help with ORDER BY using two colomns [ solved thankyou :) ]

2008-04-08 Thread Richard
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

Re: Help with ORDER BY using two colomns [ solved thankyou :) ]

2008-04-08 Thread Richard
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

Re: Help with ORDER BY using two colomns [ solved thankyou :) ]

2008-04-08 Thread Richard
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

Re: select count(). Help-a-newb

2008-04-09 Thread Richard
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

Minimum hardware requirements

2007-02-14 Thread richard
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

How to compile mysql with ut8?

2007-02-25 Thread Richard
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

Re: Qustion (translated)

2007-02-25 Thread Richard
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

Re: Qustion

2007-02-25 Thread Richard
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]>

restaure a dump.sql file encoded in utf8 to a mysql server with mysql client set to latin1?

2007-02-26 Thread Richard
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

database backup problem, since database over 60mb

2007-04-11 Thread Richard
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]

replication

2007-05-14 Thread richard
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

Re: replication

2007-05-14 Thread richard
; 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

Re: replication

2007-05-14 Thread richard
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

Select problem

2007-07-19 Thread richard
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]

Joining question

2007-08-02 Thread Richard
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]

Re: Joining question

2007-08-02 Thread Richard
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

Re: Joining question

2007-08-02 Thread Richard
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

Re: Joining question

2007-08-02 Thread Richard
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

looking for a good book for learning mysql

2007-08-02 Thread Richard
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

Re: looking for a good book for learning mysql

2007-08-02 Thread Richard
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

Re: looking for a good book for learning mysql

2007-08-03 Thread Richard
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

Re: MySQL database synchronizing from 2 locations

2007-08-05 Thread Richard
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

Re: dump then truncate - in between anything?

2016-03-13 Thread Richard
> 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

Re: Mystery error in GRANT statement

2016-10-03 Thread Richard
> 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

Re: Mystery error in GRANT statement

2016-10-04 Thread Richard
> 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

Getting Records where date is LESS THAN today, AND...

2003-12-14 Thread Richard
then have to go re-code half the scripts/databases. Thank you in advance for any tips/advice you have. Richard FRHweb

Re: Getting Records where date is LESS THAN today, AND...

2003-12-14 Thread Richard
; 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

Re: Getting Records where date is LESS THAN today, AND...

2003-12-15 Thread Richard
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

Large number of Databases

2003-09-18 Thread Richard
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: &

[Setup "language" MySQL ??]

2004-05-16 Thread richard
, 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]

Re: column1 like column2%

2002-02-20 Thread Richard
> >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:

Re: Export Data From Mysql to CSV

2002-03-04 Thread Richard
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

glitch or me?

2002-03-14 Thread Richard
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

glitch or me?

2002-03-14 Thread Richard
> >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

RE: hmm

2002-03-29 Thread Richard
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

Re: access sql statement

2002-04-04 Thread Richard
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. -

Re: Cross-database joins

2002-04-05 Thread Richard
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

Re: Cross-database joins

2002-04-05 Thread Richard
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

Re: a little help for a beginner

2002-04-10 Thread Richard
> 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;

mysql install 3.23.49 *make* cobalt raq2

2002-04-11 Thread Richard
' 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

a re-Install Nightmare.....

2001-04-07 Thread richard
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: more info on a re-install nightmare

2001-04-07 Thread richard
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

Re: MYSQL running under WIN98

2001-12-09 Thread Richard
eived > the following error message: "Can't connect to mysql server or > localhost (10061)". Any suggestions? ======== Richard Czerwonka, Partner, FYI Systems, Pe

Re: Best Delphi VCL to Access MySql.

2001-12-27 Thread Richard
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

Re: Prevent WinMySQLAdmin from auto startup when windows 98 reboots

2002-01-09 Thread Richard
ead, e-mail <[EMAIL PROTECTED]> To > unsubscribe, e-mail > <[EMAIL PROTECTED]> Trouble > unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >

Re: Access replacement...

2002-11-05 Thread Richard
> A programming environment; > A database maintenance utility; > A database query tool; > A report builder ==== Richard Czerwonka, Partner, FYI Systems, Perth, Western Australia, Delphi dev

Re: Access replacement...

2002-11-06 Thread Richard
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

Re: MySQL & Delphi 6

2002-11-19 Thread Richard
o unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > Richard Czerwo

install_driver(mysql) failed: Can't load '../blib/arch/auto/

2001-01-20 Thread Richard
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

Creating of database with userid and password

2001-01-29 Thread Richard
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

INESRT ... ON DUPLICATE KEY - rows affected incorrect?

2006-05-18 Thread Richard Dale
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

RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect?

2006-05-18 Thread Richard Dale
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

RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect?

2006-05-18 Thread Richard Dale
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]

RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect?

2006-05-20 Thread Richard Dale
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]

Re: storing images in the database

2006-11-01 Thread Richard Harris
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

Automatic Removal

2006-11-01 Thread Richard Harris
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

Ambiguous column names in derived table

2005-07-11 Thread Richard Cyganiak
* 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]

RE: Mysqld chewing up cpu in the background.

2005-07-25 Thread Richard Dale
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

RE: Continued x86_64 install problems

2005-07-27 Thread Richard Dale
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

Query matches twice, but not simultaneously...

2005-09-18 Thread Hobbs, Richard
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

Re: Query matches twice, but not simultaneously...

2005-09-19 Thread Hobbs, Richard
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

RE: MySQL 4.1 on 64bit Fedora Core 3

2005-09-22 Thread Richard Dale
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

RE: MySQL 4.1 on 64bit Fedora Core 3

2005-09-22 Thread Richard Dale
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

RE: default table type = innodb is stable??

2005-10-16 Thread Richard Dale
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

RE: Linux Yum DELETED mysql 4! Can I install mysql 5 and be on my way?

2005-11-07 Thread Richard Dale
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

Re: [PHP] phpmyadmin problems with quoting exported text

2005-11-08 Thread Richard Lynch
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

Re: [PHP] phpmyadmin problems with quoting exported text

2005-11-09 Thread Richard Lynch
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

Re: mysqldump: INSERTS for each individual record.

2005-12-10 Thread Richard AB
--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

Re: mysqldump: getting it to dump INSERT IGNORE

2005-12-11 Thread Richard AB
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

Re: timestamp

2005-12-18 Thread Richard AB
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

SELECT help.

2006-01-05 Thread Richard Reina
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.

Re: SELECT help.

2006-01-05 Thread Richard Reina
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

Re: SELECT help.

2006-01-06 Thread Richard Reina
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

query help?

2006-02-23 Thread Richard Reina
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

Re: query help?

2006-02-23 Thread Richard Reina
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

Re: query help?

2006-02-23 Thread Richard Reina
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

Re: [PHP] Because you guys/gals/girls/women/insert pc term here are a smart lot

2009-01-07 Thread Richard Heyes
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

column exists but unknown

2009-03-03 Thread Richard Whitney
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

Re: column exists but unknown

2009-03-03 Thread Richard Whitney
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

MySQL General Discussion question

2009-03-20 Thread Richard Gagnon
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   2   3   4   5   6   7   8   9   >