Re: Need a short directive

2014-10-07 Thread Trianon 33
Thanks, later on I'm going to try this, will post results here. Bye, Hans. Johan De Meersman schreef op 07-10-14 om 16:10: - Original Message - From: "Trianon 33" Subject: Need a short directive Values from yearanddate look like this: 2013-12-11 00:00:00. I want to That's only a di

Re: Need a short directive

2014-10-07 Thread Johan De Meersman
- Original Message - > From: "Trianon 33" > Subject: Need a short directive > > Values from yearanddate look like this: 2013-12-11 00:00:00. I want to That's only a display format; internally it's an integer (well, presumably a struct time_t) counting the seconds since epoch. Not especi

Need a short directive

2014-10-07 Thread Trianon 33
All, Normallu just lurking, but as a newbie with MYSQL looking for a direction for this issue: I have a table with a filed called year, integre, 5 positions. I have another field in the same table called yearanddate, which has a date format. Values from yearanddate look like this: 2013-12-1

Re: mysqldump with single-transaction option.

2014-10-07 Thread yoku ts.
Maybe no, as you knew. > It means that after lock is released, dump is made while the read and write > activity is going on. This dump then, would be inconsistent. Not only binary logs, each tables in your dump is based the time when mysqldump began to dump *each* tables. It means, for example,