RE: Reg SubQuery

Hi, Thanks for the reply. The main aim is to select the first record or the last record. Is there any direct command for these. Please help me in this. Thanks, Narasimha -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 7:30 PM

Trailing spaces

Hi, I'm just trying to make sure I am going about this the right way. I have a group of String IDs , strings up to 31 characters long, case-insensitive, trailing spaces allowed. I've got these IDs in their own table, to specifiy a numerical ID. So I have a numerical ID and a String ID in a table

unicode urgent

hi i want to do a insert query which contains utf 8 (japanese characters) characters in the database but surprisingly when i done this it stores ??? and also when i retrieves it fails to give actual  picture iam using mysql 4.1.b alpha using mysqlcc as my editor and dos promt   looking for

Hung MySQL queries

Hey everyone - I just migrated a database from one server to another (4.0.18 official RPM on RH ES 3) and now on the new server I'm running into a problem where queries hang in state "statistics" as shown by 'mysqladmin processlist'. I tried to see if there was something wrong with the queries the

Re: MySQL 5.0.2-alpha has been released

wow this is a massive feat, 5 will make many people proud, 4.1 has done the same aswell as 4.0.Well done, if you need testers for solaris or OSX lemme know. I also had a question thoughregarding INNODB and fulltext searching, when is this going to be made available or if ever ? I'vehad to do pat

MySQL 5.0.2-alpha has been released

Hi, MySQL 5.0.2-alpha, a new version of the popular Open Source/Free Software Database Management System has been released. It is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all mirror

Re: If statement in a where query....

Check whether below query helps u ? Select * from db where IFNULL(last_renewal_date,signup_date) between '2004-11-01' and '2004-11-30' Regards --Yoge Mike Morton wrote: I am trying to find a list of people based on renewal dates, the logic of the query would be: Select everything from the db wher

Query--SelectionFromSameTable

hello, Example : i hv a table containg date, flower, perfume,codeno,regno etc There are some row which have only flower entries for a day. there are some rows which have only perfume entries for a day. some rows have both florwer and perfume entries for a day..ie same day contains both entries

Re: Table Locking Problem? Very Slow MyISAM DB - PLS HELP!

The reason I ask is because eight select statements should not bog down a production server. On the MySQL side, is anything being written to the slow query log? On the application side is there any virus scanning or similar activity being performed? Does iostat show any heavy reading or writing

Re: Table Locking Problem? Very Slow MyISAM DB - PLS HELP!

The reason I ask is because eight select statements should not bog down a production server. On the MySQL side, is anything being written to the slow query log? On the application side is there any virus scanning or similar activity being performed? Does iostat show any heavy reading or writing

Re: Table Locking Problem? Very Slow MyISAM DB - PLS HELP!

Hi Victor, How did you deduce that the database server is the bottleneck? Are all your processes running on the same machine? Because 'ps -aux' shows it running at 94% of the CPU and when I stop/start the mysql server, it seems to be ok again for another hour. Any ideas? Andrew Nelson wrote: Hi

Re: Show_db_priv setting ignored

On Wednesday 01 December 2004 22:09, Fraser Campbell wrote: > The manual states "As of MySQL 4.0.2, you will see only those > databases for which you have some kind of privilege, if you > don't have the global SHOW DATABASES privilege." so I see > two possibilities: > > - users have the global SHO

Show_db_priv setting ignored

Hi, It seems that all of my users can issue the "SHOW DATABASES" command and receive a list of all databases even though their Show_db_priv setting is N. I am running mysql 4.0.16. The manual states "As of MySQL 4.0.2, you will see only those databases for which you have some kind of privilege,

Transaction Deadlocks

Howdy all, I've got a series of tables that are used to store a user's session information. The main table is a very simple table that stores a GUID and a last access data-time value. All other tables use the guid as a FK back to this main table. The main table's schema is as follows: CREATE TAB

Re: Correlated subquery help

isn't the where subquery would always return only one record if set of (k1,k2) is a primary key? I dont have 4.1+ installed to test on but if you remove 'limit 10' and run it don't you get the same list as if you ran 'select k1,k2,total_amt from Z' ? - Original Message - From: "Rick Ro

Correlated subquery help

Hi all- I'm using MySQL 4.1.7, trying to do a subquery that's apparently unsupported - I'm hoping someone can provide a quick alternative for me. I have a simple table Z with 3 columns, k1, k2, and total_amt, where k1 and k2 make up the primary key. I want to create a report that lists the the t

Table Locking Problem? Very Slow MyISAM DB - PLS HELP!

Hi, I have a MySQL 3.23.55 server managing accounts on my exim mail server.. The table type on all tables MyISAM.. I have the MTA performing various queries for each incoming email - determining mail aliases, vacation messages and filtering rules etc but they're all pretty much SELECT statements

Re: Table Locking Problem? Very Slow MyISAM DB - PLS HELP!

How did you deduce that the database server is the bottleneck? Are all your processes running on the same machine? Andrew Nelson wrote: Hi, I have a MySQL 3.23.55 server managing accounts on my exim mail server.. The table type on all tables MyISAM.. I have the MTA performing various queries fo

Re: Weird query behaviour

--- Roger Baklund <[EMAIL PROTECTED]> wrote: > The WHERE clause describes EACH of the rows you get > in the result. No > one row can have a value in the School column equal > to "Columbia" AND > "Stamford" at the same time. You should use OR > instead of AND. > Thank you Roger. That is one of

Re: free ERD tool for MySql

Attila Horvath a écrit : No I get the same problem and I'm from U.S.! :-( Attila It was just a temporary problem, I tried it again just now and it worked. Denys -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Weird query behaviour

--- [EMAIL PROTECTED] wrote: > There is nothing weird about that behavior. You > asked for all of the rows > where the School column has both of two different > values at the same time. I thought joins were difficult to comprehend ;) > Try an OR instead or use the IN() operator. > > WHERE Sc

Re: Weird query behaviour

There is nothing weird about that behavior. You asked for all of the rows where the School column has both of two different values at the same time. >> WHERE School='Columbia' and School='Stamford' if School is 'Columbia' the first part is true but the second part can't be and vice versa. Your

Re: Weird query behaviour

Stuart Felenstein wrote: [...] But if in the where statment I add: where School = Columbia and School = Stamford Nothing is returned The WHERE clause describes EACH of the rows you get in the result. No one row can have a value in the School column equal to "Columbia" AND "Stamford" at the same

Weird query behaviour

or maybe it's me :) Anyway here is my table ++--+ | RecordID | School | | PID,AI,INT | Varchar| ++--+ | 108 | Columbia | +|--+ | 108 | Princeton | +|--+ | 108

Re: confirm subscribe to mysql@lists.mysql.com

On Wednesday 01 December 2004 16:34, [EMAIL PROTECTED] wrote: > To confirm that you would like > > [EMAIL PROTECTED] > > added to the mysql mailing list, please click on > the following link: > > > http://lists.mysql.com/s/mysql/41ae38de2b6fe004/fraser=georgetown.wehave.ne >t > > This confirmat

Re: MySQL Newbie: Running in UNIX

This did not mean that's how you should work. I had this suggestion to confirm my doubt that something in the user table of mysql is messed up This was to allow you to setup a password for root or maybe another user (who can create) and then switch back to normal mysqld startup, to enable grant

Re: converting to Innodb.

Fredrik Carlsson wrote: Hi list, I have a question regarding mysql and innodb. My current setup uses myisam and the db size is about 1.6 GB with two table that each have about 500k rows. I perform alot of fulltext search on these tables and they can sometimes take along time to finish and when t

Re: A Select improvement

Dan Sashko wrote: Hi, anyone has suggestions what changes to make to allow this query to run faster? SELECT domain FROM tbl_1 WHERE id > 0 and id < 2 domain = "12.221.190.111" AND score IS NOT Null AND data LIKE "%param=search" GROUP BY domain, data -- every one of those WHERE clauses

Re: free ERD tool for MySql

Denys No I get the same problem and I'm from U.S.! :-( Attila On Wed, 1 Dec 2004, denys wrote: > Date: Wed, 01 Dec 2004 22:02:47 +0100 > From: denys <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Re: free ERD tool for MySql > > Dana Henderson a écrit : >

RE: MySQL support for AMD64

I have 400 AMD 64 box 60 of which have 8 GB of data use for databases. Each server does about 5K qps and many of our clusters do > 30K qps. We use Suse Enterprise Linux 8. I've done numerous benchmarks to know that AMD Operton is a better platform over XEONS period. DVP Dathan Vance Patti

Re: free ERD tool for MySql

Dana Henderson a écrit : Andrew, You can download a FREE version of MY dbPAL for MySQL at www.it-map.com to help you out with this. My product is free, it does database and data migrations, schema editing, data modeling, change management, database documentation and has ETL tools in there as w

Re: If statement in a where query....

- Original Message - From: "Mike Morton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 01, 2004 2:47 PM Subject: If statement in a where query > I am trying to find a list of people based on renewal dates, the logic of > the query would be: > > Select everyth

Re: MySQL support for AMD64

Hey, I haven't used AMD64's, but we're running our production on a machine with a 3ware 9508 running RAID10 with RHES 3. It's a beautiful setup. The 3ware cards are an excellent choice, but as other posts say, use RAID 10. If possible put your InnoDB logs onto a seperate array as well. out. On

RE: free ERD tool for MySql

Andrew, You can download a FREE version of MY dbPAL for MySQL at www.it-map.com to help you out with this. My product is free, it does database and data migrations, schema editing, data modeling, change management, database documentation and has ETL tools in there as well. We were listed in

Re: Utf8 collations

Brown, Brooks wrote: I ran mysqld with arguments --default-character-set=utf8 and --default-collation=utf8_unicode_ci, and created a table with no collation specification. I didn't test specifically with ç, but e and e-acute were equivalent. For me this is was problem, but it sounds like for you

RE: Utf8 collations

I ran mysqld with arguments --default-character-set=utf8 and --default-collation=utf8_unicode_ci, and created a table with no collation specification. I didn't test specifically with ç, but e and e-acute were equivalent. For me this is was problem, but it sounds like for you it's the desired

Re: Help with installation: MySQL, FreeBSD 5, Sparc64

cd /usr/ports/databases/mysql41-server && make install clean - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Richard C Komatz" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 01, 2004 12:00 PM Subject: Re: Help with installation: MySQL, FreeBSD 5, Spa

RE: MySQL support for AMD64

I've got 3 amd64 machines running mysql. One with 32 gigs of memory and 2 with 16gigs. All of them are quad 848's. We use fedora core 2 on all of our boxes. 2 of the boxes are pushing over 3000 queries per second. And one is over 4k per second. Personally, I have about 30 mysql boxes, and I

Re: If statement in a where query....

You don't need an IF only parentheses. This is almost a literal translation of your exact statement Select * from db where (last_renewal_date between '2004-11-01' and '2004-11-30') or (last_renweal_date is null AND signup_date between '2004-11-01' and '2004-11-30' ) order by last_

Re: Help with installation: MySQL, FreeBSD 5, Sparc64

In the last episode (Dec 01), Richard C Komatz said: > I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II > - FreeBSD 5). I can't find any documentation on how to install for this > system, nor can I find the binaries. cd /usr/ports/mysql41-server ; make install should be

RE: MySQL Newbie: Running in UNIX

Fix your mysql privileges http://dev.mysql.com/doc/mysql/en/GRANT.html DVP Dathan Vance Pattishall http://www.friendster.com > -Original Message- > From: Hossain, Ashfaq (Ashfaq) [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 01, 2004 8:39 AM > To: [EMAIL PROTECTED] > S

Help with installation: MySQL, FreeBSD 5, Sparc64

Hi There, I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II - FreeBSD 5). I can't find any documentation on how to install for this system, nor can I find the binaries. Thanks for any help!! Richard

Re: Newbie: making a proper subquery

To answer your question, we need to pretend to be your MySQL server for a second. You appear to be posing the following question to your server SELECT playlist.name as playlist_name , artist.name as artist , artist.'.$language.' as bio , artist.purchaseLink , media

Help with installation: MySQL, FreeBSD 5, Sparc64

Hi There, I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II - FreeBSD 5). I can't find any documentation on how to install for this system, nor can I find the binaries. Thanks for any help!! Richard

If statement in a where query....

I am trying to find a list of people based on renewal dates, the logic of the query would be: Select everything from the db where the last renewal date is between a and b, or if there is no last renewal date then where the signup date is between a and b The query that I have is something like: S

Re: Unicode (utf8) and MySQL (with Perl)

On Wed, 1 Dec 2004, Rhino wrote: > > I'm using mysql 4.1.7 and perl 5.8.1 on OS X 10.3 It also wouldn't hurt you to upgrade past all the minor updates of your other components. That means 4.1.7 (check), 5.8.6, and 10.3.6. I'm sure Perl had a lot of bug fixes or improvements after 5.8.1, especi

Re: free ERD tool for MySql

At 01:09 PM 12/1/2004, you wrote: DBVisualizer, it's great and FREE DBVisualizer is free to try, but it costs $99. http://www.minq.se/products/dbvis/ Mike Attila Horvath wrote: Does anyone know where I can get the [latest] free version of MySchema? Seems both brandosoftware.com fell off the edge

Re: free ERD tool for MySql

DBVisualizer, it's great and FREE Attila Horvath wrote: Does anyone know where I can get the [latest] free version of MySchema? Seems both brandosoftware.com fell off the edge of the world - MySchema along with it. Failing that I'm looking for a free/reasonable ERD tool. Any/all suggestions wel

Collations between English characters and International characters

Can anyone explain how to setup a table that contains text in any language for searching using english characters? Let's say I want to search for the word "Francais", but in the database it is stored as "Français". Any help is appreciated Andrew -- MySQL General Mailing List For list archives:

free ERD tool for MySql

Does anyone know where I can get the [latest] free version of MySchema? Seems both brandosoftware.com fell off the edge of the world - MySchema along with it. Failing that I'm looking for a free/reasonable ERD tool. Any/all suggestions welcome. Thx Attila -- MySQL General Mailing List For l

Re: Need help figuring out indexes for faster SELECT queries

Grant Giddens wrote: I have a new project I'm working for and I was wondering if anyone could help me optimize my selects for speed. I have a table with about 500,000 entries. The table structure I'm using is (via my PHP commands): $sql = "CREATE TABLE $store_data_table ( $store_dat

Re: Utf8 collations

Brooks, this isn't an answer to your question, but a question to you regarding what you have done. I would like to do a query such as: SELECT title FROM books WHERE title LIKE '%Francais%'; And in return get: +--+ | title| +--+ | Français | +--+ Does the "CHARACTER SET

Re: Windows 2003 read-only problem

Have you tried connecting with this user directly from the MySQL monitor? Hathaway, Scott L wrote: I have a server that is Windows 2003 server. It is running php from IIS 6. I access the latest 4.0x MySQL and am having some trouble. My database access is readonly. The user that I connect as has

Re: [SOLVED]Question: Limit search on string

--- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > > --- Roger Baklund <[EMAIL PROTECTED]> wrote: > > Yes, I had not included in my original post I wanted just the area code returned. It works - select SUBSTRING(Telephone, 1 ,3) from SignUp where Left (Telephone, 3) LIKE '4%' ; Thank you S

Re: Question: Limit search on string

--- Roger Baklund <[EMAIL PROTECTED]> wrote: > It's a bit unclear what you are trying to do. Are > you trying to find all > numbers within a 3 digit area code, i.e. numbers > starting with some 3 > digits? Or are you trying to find numbers with any > of the three first > digits equal to 4? >

Re: Question: Limit search on string

--- sol beach <[EMAIL PROTECTED]> wrote: > Of course you do. > You are asking for all of Telephone to be returned. > Duh! > > > > I'm trying something like this but still getting > back > > the whole string: > > > > select Telephone from SignUp > > where > > Left (SUBSTRING(Telephone,1,3), 3

Re: MySQL Newbie: Running in UNIX

Restart mysqld with the --skip-grant-tables option and then try Aman Raheja Hossain, Ashfaq (Ashfaq) wrote: Thanks. But, it confuses the unix "root" with the mysql root. I don't have the unix root previleges. Am I doing something wrong? Here is the error: unix> bin/mysql -uroot ERROR 104

Need help figuring out indexes for faster SELECT queries

I have a new project I'm working for and I was wondering if anyone could help me optimize my selects for speed. I have a table with about 500,000 entries. The table structure I'm using is (via my PHP commands): $sql = "CREATE TABLE $store_data_table ( $store_data_column[sku] VARCHAR

Re: Question: Limit search on string

Stuart Felenstein wrote: I'm storing telephone number (US) in 10 digit varchars. If I want to do a search on just the area code, is there a way to limit it to just the first 3 digits of the string ? I'm trying something like this but still getting back the whole string: select Telephone from Sign

Re: Question: Limit search on string

--- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > I'm storing telephone number (US) in 10 digit > varchars. If I want to do a search on just the area > code, is there a way to limit it to just the first 3 > digits of the string ? > > Thank you > Stuart > I'm trying something like this but s

MySQL Query Browser 1.1.2 and MySQL Administrator 1.0.15 Released

Hi, MySQL Query Browser 1.1.2 and MySQL Administrator 1.0.15 have been released. MySQL Query Browser is a GUI query shell, intended to allow execution of SQL queries from a Web browser alike easy to use interface. It has such handy features as query history and bookmarking, tabular visualization o

Windows 2003 read-only problem

I have a server that is Windows 2003 server. It is running php from IIS 6. I access the latest 4.0x MySQL and am having some trouble. My database access is readonly. The user that I connect as has update privileges (all privileges, actually). We checked the file permissions to the Mysql direct

Question: Limit search on string

I'm storing telephone number (US) in 10 digit varchars. If I want to do a search on just the area code, is there a way to limit it to just the first 3 digits of the string ? Thank you Stuart -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http:/

MySQL Newbie: Running in UNIX

I would like to try out MySQL on my UNIX account (Solaris). I DO NOT HAVE root privilieges in UNIX. I only have a normal user privilege. I have installed MySQL on my user UNIX account. Looks like I get the Server going and can also get the status from the Server. But, I get an error msg wh

Re: multi period sum() selects

It will, but BETWEEN is inclusive of both endpoints, so there would be a possibility of overlap with SELECT SUM(IF(timestamp BETWEEN P1 AND P2,1,0)) period1, SUM(IF(timestamp BETWEEN P2 AND P3,1,0)) period2, SUM(IF(timestamp BETWEEN P3 AND P4,1,0)) period3, ... FROM

Re: update and concat

Spaces on either side of = are not a problem, but you must not put a space between the name of a function and the opening parenthesis. From the manual , "Note: By default, there must be no whitespace between a function name and the parenthesis f

Re: Install problems with phpMyAdmin

You might want to consider the following site and collection of s/w http://www.apachefriends.org I have successfully installed XAMPP on both Windoze & Linux from their downloads. On Wed, 01 Dec 2004 08:44:49 -0500, Jason McKnight <[EMAIL PROTECTED]> wrote: > This may be a bit off-topic for

Re: multi period sum() selects

I wonder, if BETWEEN will work inside IF statement... - Original Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Bgs" <[EMAIL PROTECTED]> Sent: Wednesday, December 01, 2004 10:28 AM Subject: Re: multi period sum() selects Bgs wrote: [...] I have a db whic

Re: writing subquries in 4.0.18 version

4.0.18 does not support subqueries. You need 4.1 for that. In 4.0.18, you'd write this as a JOIN SELECT t1.* FROM table t1 JOIN table t2 ON t1.id = t2.id WHERE t2.one = 4; By the way, I assume that was a made up example, as it really doesn't require either a subquery or join: SELECT *

Re: converting to Innodb.

Roger Baklund wrote: Fredrik Carlsson wrote: Hi list, I have a question regarding mysql and innodb. My current setup uses myisam and the db size is about 1.6 GB with two table that each have about 500k rows. I perform alot of fulltext search on these tables and they can sometimes take along time

Re: multi period sum() selects

Thanks for the tips! I'll be playing with them tomorrow. I think with this method, the processing time will drop from Nx to between 1x-2x pass time. ('N' in my case is usually between 5 and 100). Regards Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: multi period sum() selects

You don't give a lot of details, but perhaps something like SELECT SUM(IF(timestamp>=P1 AND timestamp=P2 AND timestamp=P3 AND timestamp would do the trick. That counts rows. If you want to add up the values in the counter column for each period, you'd change it to SELECT SUM(IF(timestamp>=P

Re: multi period sum() selects

Bgs wrote: [...] I have a db which has among others (including text fields) a timestamp field and a counter field. I want to make statistics from them, doing sum()s with conditions 'timestamp>P1 and timestampP2 and timestamp A trivial way would be to make a cycle for Pn but that takes a lot of

Re: converting to Innodb.

Fredrik Carlsson wrote: Hi list, I have a question regarding mysql and innodb. My current setup uses myisam and the db size is about 1.6 GB with two table that each have about 500k rows. I perform alot of fulltext search on these tables and they can sometimes take along time to finish and when t

Re: Unicode (utf8) and MySQL (with Perl)

- Original Message - From: "angie ahl" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, December 01, 2004 9:26 AM Subject: Unicode (utf8) and MySQL (with Perl) > Hi List. > > Please excuse the cross posting but I've been scouring the archives > and no jo

multi period sum() selects

Greetings, While waiting for the repair table reactions I thought to ask a question that hogged in my head for a while. I have a db which has among others (including text fields) a timestamp field and a counter field. I want to make statistics from them, doing sum()s with conditions 'timestam

Re: Performance impact -- multiple databases Vs multiple tables...

I'm not sure if you have a problem with one large InnoDB table or one large file. With InnoDB you can specify multiple files, limit the size of each file and even specify the location of each file. So you could limit your InnoDB files to say 1GB each (or lower/higher) and specify which disk (or

Re: 4.1.7 character set conversions

On Wed, 1 Dec 2004 14:16:40 +0100 Sergei Golubchik <[EMAIL PROTECTED]> wrote: > > character_set_client = A > > character_set_connection = B > > character_set_database = C > > character_set_results = D > > character_set_server = E > > character_set_system = F > > F is always utf8 > > > a table na

a query to insert values into two different tables using mySQL Server

in MS SQL u can do it by the following query: declare @transool varchar(20) set @transool = 'opcofficelink' begin transaction @transool insert into Table1 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec, @Sine_30_Sec) insert into Table2 (Sine_20_Sec, Sine_30_Sec) values (@Sine_20_Sec, @Sine_30_Se

converting to Innodb.

Hi list, I have a question regarding mysql and innodb. My current setup uses myisam and the db size is about 1.6 GB with two table that each have about 500k rows. I perform alot of fulltext search on these tables and they can sometimes take along time to finish and when the table is locked durin

Re: update and concat

Someone else suggested that I remove all spaces before and after = and between CONCAT and (...). This worked. Too bad the manual is not more specific. Thanks for your concern, Tom On Nov 30, 2004, at 7:14 PM, Michael Stassen wrote: At this point, what you say you are doing should work, but doe

RE: MySQL support for AMD64

I would recommend Raid 10 over Raid 5 even if it's kinda a big hit on your storage cabality. http://www.experts-exchange.com/Storage/Q_20640972.html I'm successfully running a Master/Slave setup with the following machines: Quad Opteron 64 / 32G RAM Dual Opteron 64 / 16G RAM Using gentoo compi

Unicode (utf8) and MySQL (with Perl)

Hi List. Please excuse the cross posting but I've been scouring the archives and no joy as yet. I'm trying to get Perl and MySQL using utf8 happily and I've followed several tutorials but am not getting the same results. I've got a load of utf8 characters like so (perl): my %uni = ( heb

Re: Reg SubQuery

Roger Baklund wrote: That leaves us with the answer from Gleb Paharenko, except the insert query should be "insert into memp select min(salary) from emp;" ... and the select should be: select emp.* from emp,memp where salary=m; He would get all employes with the lowest salary, as opposed to: selec

Re: MySQL support for AMD64

I don't have your configuration but I do have 2 servers running with 3ware controllers (800 or so megs in RAID 5 on each). They are stable and performance is good. I don't run MySQL on these however. I also have an AMD64 box running Fedora/AMD64/MySQL and everything is stable. My AMD64 box is n

Re: Reg SubQuery

[EMAIL PROTECTED] wrote: Or.. Select * from emp order by id asc limit 0,1 if you want to fetch all details. That was what I said, but lets take a closer look at what the original poster asked: "I need to get all the details of an employee whose salary is the lowest." Now, in his example he used

RE: Reg SubQuery

Or.. Select * from emp order by id asc limit 0,1 if you want to fetch all details. -Original Message- From: Jason McKnight [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 7:21 PM To: [EMAIL PROTECTED] Subject: Re: Reg SubQuery You could also do it like this: select min(id)

Re: Reg SubQuery

You could also do it like this: select min(id) from emp; Roger Baklund wrote: [EMAIL PROTECTED] wrote: I need to get all the details of an employee whose salary is the lowest. I can do like this in Oracle select * from emp where id = (select min(id) from emp). Can we have any alternative in MySQL f

Re: Install problems with phpMyAdmin

This may be a bit off-topic for the MySQL List but see below: Gunter Götz wrote: Hello experts, according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as following: shell> su - shell> mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ shell> cd /usr/sbin/ shell> tar -zxf phpMyAdmin-

Install problems with phpMyAdmin

Hello experts, according the desprictions I have installed the phpMyAdmin (2.6.0-pl3) as following: shell> su - shell> mv phpMyAdmin-2.6.0-pl3.tar.tar /usr/sbin/ shell> cd /usr/sbin/ shell> tar -zxf phpMyAdmin-2.6.0-pl3.tar.tar shell> rm phpMyAdmin-2.6.0-pl3.tar.tar shell> mv php

Re: Reg SubQuery

[EMAIL PROTECTED] wrote: I need to get all the details of an employee whose salary is the lowest. I can do like this in Oracle select * from emp where id = (select min(id) from emp). Can we have any alternative in MySQL for the above query, as sub queries are not supported in MySQL 4.0.21 There is

Where overload: Is there such a thing

I'm creating a search form, the query is dynamic. Meaning user can select 1 or all options. All options translates to about 40 "where" statements, including 1 -3 full text searches. Is this too many where statements ? Do I need to watch out for anything. Looking for any advice on this issue. Th

4.1.7 character set conversions

Hi! I've been digging through the web for a few days, but I didn't get any answers for my little question, so I try to ask it here: For example I set the following character sets: character_set_client = A character_set_connection = B character_set_database = C character_set_results = D character

repair table priv

Greetings, I've been trying to find what privilege is needed to 'REPAIR TABLE'. I couldn't find any usefull hint on the net or in the archives. Could anyone help me out? Thanks Bgs -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysq

Re: Reg SubQuery

Hello. Usually such things are done in several steps using temporary table. create temporary table memp(m int); insert into memp select min(id) from emp; select emp.* from emp,memp where id=m; See: http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html >Hi, >I n

Re: Illegal mix of collations with 4.1.7

Hello. The first impression is that you forgot to convert character columns. See: http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html http://dev.mysql.com/doc/mysql/en/Charset-conversion.html "V. M. Brasseur" <[EMAIL PROTECTED]> wrote: > Ever since we upgraded to 4.1.7, we'

Re: Adding Foreign Key

Thanks Mr Heikki I try to remove ON DELETE SET DEFAULT like this mysql> alter table t_quiz_trivia add foreign key (client_id) references t_client(client_id); I found new error ERROR 1216 (23000): Cannot add or update a child row: a foreign key constraint fails Finally i found the error 1. DDL o

Re: Adding Foreign Key

Ady, - Original Message - From: "Ady Wicaksono" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Wednesday, December 01, 2004 6:43 AM Subject: Adding Foreign Key mysql> alter table t_quiz_trivia add foreign key (client_id) references t_client (client_id) on delete set defaul

Re: MySQL support for AMD64

Lynn, - Original Message - From: "Lynn Bender" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, November 30, 2004 9:22 PM Subject: MySQL support for AMD64 I just received a box with the following specs: Dual AMD64 8G ram Two 3ware 2.4 terabyte RAID 5 arrays. My comp

Re: InnoDB Log and binlog files and Solid State Disk?

Richard, - Original Message - From: ""Richard F. Rebel"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, November 30, 2004 6:11 PM Subject: InnoDB Log and binlog files and Solid State Disk? --=-JDf9WlMx8c01FXMbzrGw Content-Type: text/plain Content-Transfer-Encoding

  1   2   >