RE: Table crashes

2007-10-23 Thread amarnath.shivashankar
Can someone help me out on this..I need a detailed document Regards, Amarnath Shivashankar SQL Database Management | GSMC | Wipro Infotech | Mysore | Toll free: 1800-345-5656 | Spirit of Wipro : Intensity to Win | Act with Sensitivity | Unyielding Integrity F

Re: Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread mysql
[EMAIL PROTECTED] wrote: Daevid Vincent wrote: Nope. I've only ever use mySQL. I only ever care to use mySQL. mySQL puts in plenty of other features that no other RDBMS has or uses, and other RDBMS have features that mySQL has, so what's the problem. Unless I was porting to/from another RDBMS?

Re: Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread mysql
Daevid Vincent wrote: Nope. I've only ever use mySQL. I only ever care to use mySQL. mySQL puts in plenty of other features that no other RDBMS has or uses, and other RDBMS have features that mySQL has, so what's the problem. Unless I was porting to/from another RDBMS? This strikes me as a *ter

RE: Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread Daevid Vincent
Nope. I've only ever use mySQL. I only ever care to use mySQL. mySQL puts in plenty of other features that no other RDBMS has or uses, and other RDBMS have features that mySQL has, so what's the problem. Unless I was porting to/from another RDBMS? It seems stupid that I can't do that though. I can

Re: Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread Peter Brawley
When will I be able to do something seemingly so basic as this re-use of an alias? Do you know an implementation of SQL which allows this? PB Daevid Vincent wrote: When will I be able to do something seemingly so basic as this re-use of an alias? SELECT DATE_ADD('2007-10-23', INTERVAL user_a

Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

2007-10-23 Thread Jeremy Cole
Hi John, Your attachment for the php code got stripped somewhere. Can you post it somewhere (http preferable)? In either case it's going to result in a full table scan, so they are actually both a bad strategy long term, but they should in theory perform as you would expect, with with encry

Re: Replication and AUTO_INCREMENT; is it safe?

2007-10-23 Thread js
Thank you for your reply. But I couldn't under stand how --auto-increment-increment and --auto-increment-offset helps me avoid my problem. Could you please explain? On 10/24/07, Eric Frazier <[EMAIL PROTECTED]> wrote: > js wrote: > > Hi list, > > > > Reading How AUTO_INCREMENT Handling Works in

Why can't I still not use an ALIAS in the SELECT portion of an SQL statement?

2007-10-23 Thread Daevid Vincent
When will I be able to do something seemingly so basic as this re-use of an alias? SELECT DATE_ADD('2007-10-23', INTERVAL user_access_hours HOUR) AS group_duration_date, UNIX_TIMESTAMP(group_duration_date) AS group_duration_date_timestamp FROM end_user

Re: upgrade from 4.1 to 5.0 KO

2007-10-23 Thread Dan Nelson
In the last episode (Oct 23), Ivan Longhi said: > I'm running mysql-server on a linux debian box > > with apt package system I upgraded mysql server from 4.1 to 5.0 (apt > automatically execute mysql_upgrade) > > now on my 5.0.32 server almost everything works fine, except for a > database cont

upgrade from 4.1 to 5.0 KO

2007-10-23 Thread Ivan Longhi
hi, I'm running mysql-server on a linux debian box with apt package system I upgraded mysql server from 4.1 to 5.0 (apt automatically execute mysql_upgrade) now on my 5.0.32 server almost everything works fine, except for a database containing 4 tables: two of them have been upgraded as I can

HOCHGURTEL

2007-10-23 Thread Kay Brown
I have old photos for the HOCHGURTEL family that I'd like to get to the right family. MOTHER & DAD HOCHGURTEL, AUNT LIZZIE (BRANDENBURG) EARLY 1900'S HELEN & LEO HOCHGURTEL ELMER HOCHGURTEL ANNIE HOCHGURTEL GESBECK ROY HOCHGURTEL CARL HOCHGURTEL EARL POULSEN HATTIE HOCHGURTEL POULSEN LARRY HOCHG

Re: Replication and AUTO_INCREMENT; is it safe?

2007-10-23 Thread js
> > If After "delete from table where id = 4" and restart mysqld on server B, > > "insert into table (value) values(e)" is executed on server A. > > > Why would you delete data from the slave? The delete statement is for Master, not slave. -- MySQL General Mailing List For list archives: http://

Re: Replication and AUTO_INCREMENT; is it safe?

2007-10-23 Thread Philip Hallstrom
Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me wonder how is it possible to replicate AUTO_INCREMENTed value to slaves. According to the doc, "If you specify an AUTO_INCREMENT column for an InnoDB table, the table handle in the InnoDB data dictionary contains a special counter c

Replication and AUTO_INCREMENT; is it safe?

2007-10-23 Thread js
Hi list, Reading How AUTO_INCREMENT Handling Works in InnoDB[1] makes me wonder how is it possible to replicate AUTO_INCREMENTed value to slaves. According to the doc, "If you specify an AUTO_INCREMENT column for an InnoDB table, the table handle in the InnoDB data dictionary contains a special

Re: [Replication] - load

2007-10-23 Thread Kevin Spencer
On 10/10/07, Ratheesh K J <[EMAIL PROTECTED]> wrote: > So every morning all the queries will be slow for the first time on the DB > server 2 and thereafter will be served by the query cache as they will be > cached and never invalidated until the night. Sorry for the late reply, I'm trying to ge

Re: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

2007-10-23 Thread John Kraal
Yes, I did, and shutdowns between the tests and between reversing the tests. -- / Humanique / Webstrategie en ontwikkeling / http://www.humanique.com/ - Humanique zoekt een ervaren Web-ontwikkelaar (PHP). Bekijk de vacature op http://www.humanique.com/ - Jerry Schwartz wrote: Have you tried r

RE: Query performance plain/text versus AES_DECRYPT(): LIKE %..%

2007-10-23 Thread Jerry Schwartz
Have you tried reversing the order of your tests, to see if there is some influence from caching? Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-

I'm actually planning the application first instead of coding first!!! :)

2007-10-23 Thread Jason Pruim
Hi Everyone, So having learned my lesson with the last application, I am trying to plan out the addition of a feature to my database application. Basically, some of my customers go south for the winter ("Snow Birds") what I would like to do is have away of storing both their addresses in

Query performance plain/text versus AES_DECRYPT(): LIKE %..%

2007-10-23 Thread John Kraal
Dear you, I've been working on encrypting some data for a customer. They want their personal/sensitive information encrypted in the database, but they want to be able to search it too, through the application. So we've been thinking a bit, and just started trying and benchmarking some solutions w

I hope I won't be thrown off the list for this

2007-10-23 Thread ed
I know it's not 'Mysql help' related, but I hope this gets a smile, and I figure this crowd would appreciate it as much as any crowd; http://xkcd.com/327/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Upgrading PHP + MySQL

2007-10-23 Thread David Zentgraf
Hi, I have a CentOS 3 server that I need to update to MySQL 5 + PHP4. I downloaded and installed the MySQL client and server RPM packages for Red Hat 3, including the Shared Compatibility Libraries which provide /usr/lib/libmysqlclient.so.10, .12, .14 and .15, which seems to be the recomm