Re: Hungarian Notation [Was Re: Too many aliases]

2011-08-07 Thread Mike Diehl
only time I let types intrude on names is with booleans, which I try to > name with a state-of-being verb, such as "has_paid", "is_member", > "has_children", etc. > > > On Thu, Aug 4, 2011 at 9:41 AM, Mike Diehl wrote: > >> Well, while we're

Re: Too many aliases

2011-08-04 Thread Mike Diehl
ther it is helpful or not. > > Now I do not do this, but I often see examples where a field for one > purpose has in one table one name, and in another table another, > slightly different, name, and then, too, I see alias used, although, in > this case, no table name at all is needed.

Re: Mysql Failover Recommendations

2011-06-13 Thread Mike Diehl
:26 pm Johan De Meersman wrote: > - Original Message - > > > From: "Mike Diehl" > > > > I'm about to set master-master replication and would like to get > > recommendations as to the best method for getting my applications to > > failove

Mysql Failover Recommendations

2011-06-13 Thread Mike Diehl
might be too http-centric. Would it work for Mysql? Any comments/pointers would be most appreciated. -- Take care and have fun, Mike Diehl. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: How to protect primary key value on a web page?

2011-03-10 Thread Mike Diehl
/password from them, I have a similar situation. What I do is store a random number in their record, which I also include in the url. Access to the record is gained by the combination of id, and tag. Just a thought. -- Take care and have fun, Mike Diehl. -- MySQL General Mailing L

Re: CLI can't read data from table

2010-04-15 Thread Mike Diehl
On Wednesday 14 April 2010 7:39:03 pm Dan Nelson wrote: > In the last episode (Apr 14), Mike Diehl said: > > On Wednesday 14 April 2010 5:49:43 pm Jesper Wisborg Krogh wrote: > > > Lines is a reserved keyword (e.g. like in "LINES TERMINATED BY"), so it > > >

Re: CLI can't read data from table

2010-04-14 Thread Mike Diehl
KEY) > ENGINE=InnoDB; Query OK, 0 rows affected (0.20 sec) Yup, that was it. I'm migrating from Postgres, so it never occured to me that "lines" might be reserved. Thanks. -- Take care and have fun, Mike Diehl. -- MySQL General Mailing List For list archives:

CLI can't read data from table

2010-04-14 Thread Mike Diehl
across replication. Any ideas? -- Take care and have fun, Mike Diehl. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Finding gaps

2008-09-18 Thread Mike Diehl
g. There's no need for those numbers to > >be in the database. > > [JS] They are propagated into other databases that I do not control. They > are managed and used by our main office in Japan. They notice everything > (except misspellings). -- Mike Diehl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]