Dear all,
We have thousands of aes_encrypted data accidentally stored in a text field,
from which we're struggling to recover the data back. Simply convert the
text field to a blob field does not help. Various tricks have been tried,
but with no luck. Now I'm worried that when a blob stored into a
2011/10/20 Halász Sándor :
> Well done--but
>
> Although, it seems, it is everyone s experience that the desired order is the
> order that MySQL yields, all guarantee of that is explicitly deny'd (look up
> 'GROUP BY'). It is better to be safe and to use "MIN":
>
> select * from table1 wher
On Thu, Oct 20, 2011 at 16:11, Shawn Green (MySQL)
wrote:
> We do! First though, are you referencing the online documentation or the
> packaged documentation? The reason I ask is that the online documentation
> does have some user contributions and comments to go along with the text
> itself. Â Th
On 10/20/2011 9:11 AM, Shawn Green (MySQL) wrote:
On 10/19/2011 20:03, Dotan Cohen wrote:
...
Thank you Shawn. I very much appreciate your help, and I also
appreciate your employer's initiative to have such a position
monitoring the mailing list. Is that an Oracle-created position, or
did it
;>>> 2011/10/19 17:06 -0500, Basil Daoust
For me given the sample data the following worked.
The inner select says find all first messages, the outer says give me all
messages that are thus not first messages.
select * from table1 where messageID NOT IN (
select messageID from table1
group by
Hello Hal�sz S�ndor,
On 10/19/2011 17:50, wrote:
I made this query a view, called "MEMBERP", no problem:
SELECT MemberID, ereStart, DateModified, MembershipExpires, MemberSince,
Category, Boardster, GROUP_CONCAT(DISTINCT Salutation ORDER BY Rank) AS
Salutation, GROUP_CONCAT(DISTINCT Give
"I remain convinced that users simply need to learn patience, though."
HAHAHAHAHAHAHAHAHAHAHAHAHAHAHA!!!
Good one!
Sent from my iPad
On Oct 20, 2011, at 8:44 AM, Johan De Meersman wrote:
> I remain convinced that users simply need to learn patience, though.
--
MySQL General Mailing List
Fo
On 10/19/2011 20:03, Dotan Cohen wrote:
...
Thank you Shawn. I very much appreciate your help, and I also
appreciate your employer's initiative to have such a position
monitoring the mailing list. Is that an Oracle-created position, or
did it exist at Sun as well?
MySQL has always encouraged
- Original Message -
> From: "Alex Schaft"
>
> I realize that, I'm just trying to stop the phone calls saying "I
> started a restore, and my pc just froze"
>
> I might just read all the single insert lines, and get a whole lot of
> values clauses together before passing it on to get
Hi!
SQL Maestro Group starts a new product family and announces the
release of Data Sync for MySQL, a powerful and easy-to-use tool for
MySQL database contents comparison and synchronization.
http://www.sqlmaestro.com/products/mysql/datasync/
Key product features:
1. Comparin
On 2011/10/20 11:54 AM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
I'm monitoring a mysqldump via stdout, catching the create table
commands prior to flushing them to my own text file. Then on the
restore side, I'm trying to feed these to mysql via the c api so I
- Original Message -
> From: "Alex Schaft"
>
> I'm monitoring a mysqldump via stdout, catching the create table
> commands prior to flushing them to my own text file. Then on the
> restore side, I'm trying to feed these to mysql via the c api so I can
> monitor progress (no of lines in th
On 2011/10/20 10:53 AM, Alex Schaft wrote:
What can I pass to mysqldump to get more sane statement lengths?
+1 for extended-inserts...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hi,
I'm monitoring a mysqldump via stdout, catching the create table
commands prior to flushing them to my own text file. Then on the restore
side, I'm trying to feed these to mysql via the c api so I can monitor
progress (no of lines in the dump file vs no of lines sent to mysql),
but the li
14 matches
Mail list logo
