Re: mysql privileges

I would like to thank everyone who gave suggestions about how to fix the mysql privileges. Here's what we did: We did a mysqldump on the mysql table on the old machine. We brought the mysqldump into the mysql table on the new machine We ran mysql_fix_privilege_tables We gave the command

ORDER BY calculated field

Hi, How do I achieve a SQL statement to order my results based on two calculated fields for example : SELECT COUNT(ProductsPurchases.ProductID) as varProductCount, Products.Name, Products.ProductReview FROM ProductsPurchasesINNER JOIN Products ON Products.ProductID =

Re: ORDER BY calculated field

Neil Tompkins schrieb: Hi, How do I achieve a SQL statement to order my results based on two calculated fields for example : what two calculated fields? SELECT COUNT(ProductsPurchases.ProductID) as varProductCount, Products.Name, Products.ProductReview FROM ProductsPurchasesINNER JOIN

RE: ORDER BY calculated field

Hi I want to order by the totalled fields varProductCount and Products.ProductReviewDESC Neil Date: Thu, 20 Mar 2008 11:36:30 +0100 From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: ORDER BY calculated field Neil Tompkins schrieb: Hi,How do I achieve a SQL statement

Re: ORDER BY calculated field

Neil Tompkins schrieb: Hi I want to order by the totalled fields varProductCount and Products.ProductReviewDESC just put them together, separated with comma, like it is written in the manual ORDER BY varProductCount + Products.ProductReviewDESC, COUNT(ProductsPurchases.ProductID) -- MySQL

Re: ORDER BY calculated field

Sebastian Mendel schrieb: Neil Tompkins schrieb: Hi I want to order by the totalled fields varProductCount and Products.ProductReviewDESC just put them together, separated with comma, like it is written in the manual ORDER BY varProductCount + Products.ProductReviewDESC,

Re: ORDER BY calculated field

Neil Tompkins schrieb: Thanks Sebastian, but I now get the error message [MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function i am not familiar with ODBC or MySQL 3.x but possible just GROUP BY is missing check the manual for your mysql version for the exact syntax if

RE: ORDER BY calculated field

Thanks Sebastian, but I now get the error message [MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function Date: Thu, 20 Mar 2008 12:59:22 +0100 From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: Re: ORDER BY calculated field Sebastian Mendel schrieb: Neil

RE: ORDER BY calculated field

Thanks for the help. However I found another solution which is to use the following SELECT COUNT(ProductsPurchases.ProductID)+Products.ProductReview as varProductCount, Products.Name, Products.ProductReviewFROM ProductsPurchasesINNER JOIN Products ON Products.ProductID =

binlog sequence # rollover

do binlog sequences just rollover back to 0 w/o a resetlogs? will it just automatically go back to mysqld.00 after mysqld.99? any replication implications? I know it sounds like a stupid question and I'm sure the developers are smart enought to have thought of that but we'll be crossing

Re: Security overrides in mysql.cnf

At 2:51 PM -0500 3/19/08, Brown, Charles wrote: I inherited a mysql server database. Stuff are not documented. My question is: Are there any security work-arounds in mysql. I have access to the cnf file. I need to get in and dump the database. I was told that the cnf file allows security over

Re: binlog sequence # rollover

Hi, On Thu, Mar 20, 2008 at 9:41 AM, Sid Lane [EMAIL PROTECTED] wrote: do binlog sequences just rollover back to 0 w/o a resetlogs? will it just automatically go back to mysqld.00 after mysqld.99? any replication implications? I know it sounds like a stupid question and I'm sure

Re: the limitaiton of table size

At 10:47 PM -0400 3/18/08, Sookhyun Yang wrote: Dear all, I have a question about the limitatin of table size. If I use the InnoDB engine, I don't have to worry that the total size of table is greater than the single filesize? You can create an InnoDB tablespace that spans multiple files,

Selecting the most recent entry for each object.

Hi, I have a load of reviews in a table and, for each person I want to pull out the most recent review. So, if I wanted to do this for a single person I would order by date desc and use limit 1. But I'm not sure how to do this in bulk. Thanks.

Re: Selecting the most recent entry for each object.

Hi, On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett [EMAIL PROTECTED] wrote: Hi, I have a load of reviews in a table and, for each person I want to pull out the most recent review. So, if I wanted to do this for a single person I would order by date desc and use limit 1. But I'm

RE: Selecting the most recent entry for each object.

Great article. Got me on the right track. Actual solution I went with was something like: select `vPamLearner`.`learnerId`, `vPamLearner`.`usedName`, `vPamLearner`.`surname`, max(prComp.dateSubmitted) latestSubmitted, max(prComp.FProgressReviewId) latestSubmittedId,

2 mysqld instances

Hi, I have a single machine with 2 mysql instances running. One of them was started like this: /home/y/libexec/mysqld --basedir=/home/mysql --datadir=/var/mysql/data --pid-file=/var/mysql/mysqld.pid --port=3306 --socket=/tmp/mysql.sock and, the other one, like this: /home/y/libexec/mysqld

Optimize db update

Hi, Actually I am updating TableA in DatabaseA with values from TableB in DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a .txt file containing data from TableB then using VB6 once more to recronstruct the table in DatabaseA then remove all data which are already in

Re: 2 mysqld instances

In the last episode (Mar 20), Edson Noboru Yamada said: I have a single machine with 2 mysql instances running. One of them was started like this: /home/y/libexec/mysqld --basedir=/home/mysql --datadir=/var/mysql/data --pid-file=/var/mysql/mysqld.pid --port=3306 --socket=/tmp/mysql.sock

Re: Optimize db update

On Thu, Mar 20, 2008 at 1:41 PM, Velen [EMAIL PROTECTED] wrote: Actually I am updating TableA in DatabaseA with values from TableB in DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a .txt file containing data from TableB then using VB6 once more to recronstruct

Re: 2 mysqld instances

On Thu, Mar 20, 2008 at 2:53 PM, Dan Nelson [EMAIL PROTECTED] wrote: -P is only used when connecting to non-localhost addresses. Try adding -h 127.0.0.1 to your commandline. It worked! Thank you!

Re: Optimize db update

Are the table structures identical ? If so, you could just move the data files themselves. Otherwise consider using unload from table B into TAB seperated format (mysql load format) truncate table A load data infile into table A On Thu, Mar 20, 2008 at 2:20 PM, Daniel Brown [EMAIL PROTECTED]

Re: 2 mysqld instances

At 3:25 PM -0300 3/20/08, Edson Noboru Yamada wrote: On Thu, Mar 20, 2008 at 2:53 PM, Dan Nelson [EMAIL PROTECTED] wrote: -P is only used when connecting to non-localhost addresses. Try adding -h 127.0.0.1 to your commandline. It worked! Thank you! You can also force a TCP/IP

doubt: mysqldump in linux like windows

Hello guys i have this situation in widnows with the mysql administrador i make backup i saw in the x.sql these lines for example /*!4 ALTER TABLE `articulo` DISABLE KEYS */; INSERT INTO `articulo`

Re: relational tables

Sorry, I'm a top quoter. This is what I want to do. I'm still told there re problems with my keys. DROP TABLE IF EXISTS `person`; CREATE TABLE `person` ( `person_id` int(11) NOT NULL auto_increment, `name` varchar(255) default NULL, `email` varchar(255) default NULL, PRIMARY KEY

RE: doubt: mysqldump in linux like windows

Use --skip-extended-insert as another mysqldump option -Original Message- From: dr_pompeii [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2008 2:43 PM To: mysql@lists.mysql.com Subject: doubt: mysqldump in linux like windows Hello guys i have this situation in widnows with the

RE: relational tables

See below... -Original Message- From: John Taylor-Johnston [mailto:John.Taylor- [EMAIL PROTECTED] Sent: Thursday, March 20, 2008 2:17 PM To: Sebastian Mendel; mysql@lists.mysql.com Subject: Re: relational tables DROP TABLE IF EXISTS `person`; CREATE TABLE `person` (

RE: doubt: mysqldump in linux like windows

Hi Rolando thanks for the reply it works, thanks, new command used mysqldump --opt --skip-extended-insert --password=XXX --user=root somedb /home/Someuser/somepath/A.sql but i see one difference from windows /*!4 ALTER TABLE `articulo` DISABLE KEYS */; INSERT INTO `articulo`

'mysql.servers' doesn't exist

Hey Folks. I'm getting this error -- I need your input or help. 080320 15:02:16 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 080320 15:02:16 [Note] Event Scheduler: Loaded 0 events 080320 15:02:16 [Note] E:\Apps\Standard\HPRUM\MYSQL\bin\mysqld: ready for

Re: 'mysql.servers' doesn't exist

Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist On Fri, Mar 21, 2008 at 4:23 AM, Brown, Charles [EMAIL PROTECTED] wrote: Hey Folks. I'm getting this error -- I need your input or help. 080320 15:02:16 [ERROR] Can't open and lock privilege tables: Table

Re: doubt: mysqldump in linux like windows

If you skip the extend insert during mysqldump ,the process of the restore is painful. On Fri, Mar 21, 2008 at 5:05 AM, dr_pompeii [EMAIL PROTECTED] wrote: Hi Rolando thanks for the reply it works, thanks, new command used mysqldump --opt --skip-extended-insert --password=XXX

Re: How to import oracle dump?

The following format can be supported by mysql. The first is the pure insert statement. The other is csv file. On Tue, Mar 18, 2008 at 10:00 PM, Rajesh Mehrotra [EMAIL PROTECTED] wrote: Have you tried the MySQL Migration Toolkit? Check http://www.mysql.com/products/tools/migration-toolkit/