Your binary logging is set to statement format - the default, and the only one
available in older versions. Current versions also support row-based logging.
These formats have to do with safe replication, I recommend you check the
release notes and the online documentation for more information.
http://en.wikipedia.org/wiki/Hungarian_notation
On Thu, Aug 4, 2011 at 9:41 AM, Mike Diehl wrote:
> Well, while we're on the subject of SQL style, can anyone tell me why I'm
> always seeing people prefixing the name of a table with something like
> "tbl?"
>
> For example:
>
> create table tblCU
Well, while we're on the subject of SQL style, can anyone tell me why I'm
always seeing people prefixing the name of a table with something like "tbl?"
For example:
create table tblCUSTOMERS ( ... );
Seems to me that you should probably know that CUSTOMERS is a table, or is it
just me?
Lookin
Hi,
I am new to MySQL and this listserv. I have a couple of questions about the
recommendations at the link given below.
1) If autocommit is turned off during the large load, could this cause the
underlying InnoDB log to grow too big?
2) If the unique checks and foreign key checks are turned
We just upgraded our mysql from 5.0.32 on debian lenny, to 5.1.49 on
debian squish.
I wasn't told that it was doing an incremental version upgrade, i was
under the impression it was just going from 5.0.32 to 5.0.8x.
Anyways, I am getting some weird issues now, that is filling up the
syslog, and i
>-Original Message-
>From: David Lerer [mailto:dle...@us.univision.com]
>Sent: Wednesday, August 03, 2011 10:25 AM
>To: mysql@lists.mysql.com
>Subject: RE: Too many aliases
>
>I rarely use aliases (unless rarely required in self-join queries).
>Yes, the column names may be longer this way,
On 8/3/2011 20:36, Nuno Tavares wrote:
The following page has some nice interesting stuff, assuming you have a
reasonable configuration in place (innodb_buffer_pool, etc[1])
http://download.oracle.com/docs/cd/E17952_01/refman-5.5-en/optimizing-innodb-bulk-data-loading.html
...
The same conte
I agree. I use the same column name in all tables where it has the same
function - but I consistently add a suffix or prefix. And yes, it is the
old fashion way David.
-Original Message-
From: h...@tbbs.net [mailto:h...@tbbs.net]
Sent: Thursday, August 04, 2011 8:26 AM
To: r...@grib.n
2011/08/03 12:46 +0200, Rik Wasmus
But the
main thing is it helps to distinguish tables in joins having the same table
more then once (and of course results from subqueries etc.):
SELECT first.*
FROM tablename first
LEFT JOIN tablename second
ONfirst.some_id = second.some_id
