prepare w from @sel;
execute w;
and got 1000 rows out of 1216; only 216 rows have no NULL
in any field.)
Maybe Lejeczek really wants to make some of his table s
fields NOT NULL?
Thanks! I'm not a sqler and what I needed was a working
piece of a code so I could try to wrap my head a
hi there,
I've been searching the vastness of the net but cannot find
- how - to get all the rows with a NULL.
And like any novice I wonder if this can be done without
reiterating all the columns names(not manually at least)?
Some expert would say it is easy, how easy is it? with an
hi everybody..
would you know how to recover from such a problem:
InnoDB: ok header, but checksum field contains 792537472,
should be 1776874443
2016-04-04 12:41:15 140333716928640 [ERROR] InnoDB: Redo log
crypto: failed to decrypt log block. Reason could be that
requested key version is not
.. that you experts I hope can crack like a digestive
biscuit...
how does one update, or merge or whatever is right technical
term for it - a my.table from my.another table (both are
schematically identical, no foreign keys, one primary key) but..
does it a way so when there is a duplicate
<h.rei...@thelounge.net> wrote:
Am 16.03.2016 um 13:38 schrieb lejeczek:
hi everybody
just another beginner's question.
if I insert into table and there are duplicate primary keys - does mysql
alert about all the duplicates or just the first one and then
exits/abandon the rest of the insert
hi everybody
just another beginner's question.
if I insert into table and there are duplicate primary keys
- does mysql alert about all the duplicates or just the
first one and then exits/abandon the rest of the insert
without any alerts for potential further duplicates?
And is this a
On 13/03/16 14:52, Richard wrote:
Date: Wednesday, March 09, 2016 14:38:45 +
From: lejeczek <pelj...@yahoo.co.uk>
hi everybody
I imagine this is theoretical rather than practical question,
albeit I don't have much practice, so I hope experts could comment
logical view of the pro
hi everybody
I imagine this is theoretical rather than practical
question, albeit I don't have much practice, so I hope
experts could comment
logical view of the procedure is: mysqldump && truncate -
what are the chances that something gets in between and I
loose it?
many thanks
L.
--
AM, lejeczek wrote:
On 02/03/16 00:51, shawn l.green wrote:
On 3/1/2016 6:26 PM, lejeczek wrote:
On 29/02/16 21:35, shawn l.green wrote:
On 2/29/2016 3:13 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:54 schrieb Gary Smith:
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks
On 02/03/16 00:51, shawn l.green wrote:
On 3/1/2016 6:26 PM, lejeczek wrote:
On 29/02/16 21:35, shawn l.green wrote:
On 2/29/2016 3:13 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:54 schrieb Gary Smith:
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks can achieve that way
On 29/02/16 21:35, shawn l.green wrote:
On 2/29/2016 3:13 PM, Reindl Harald wrote:
Am 29.02.2016 um 20:54 schrieb Gary Smith:
On 29/02/2016 19:50, Reindl Harald wrote:
cryptsetup/luks can achieve that way better
Only to a degree.
no - not only to a degree - when the question is
S
On Mon, Feb 29, 2016 at 11:12 AM, lejeczek <pelj...@yahoo.co.uk> wrote:
On 29/02/16 15:42, Gary Smith wrote:
On 29/02/2016 15:30, lejeczek wrote:
On 28/02/16 20:50, lejeczek wrote:
fellow users, hopefully you experts too, could help...
...me to understand how, and what should be
On 29/02/16 15:42, Gary Smith wrote:
On 29/02/2016 15:30, lejeczek wrote:
On 28/02/16 20:50, lejeczek wrote:
fellow users, hopefully you experts too, could help...
...me to understand how, and what should be the best
practice to dump database, then drop it and merge the
dumps..
What I'd
On 28/02/16 20:50, lejeczek wrote:
fellow users, hopefully you experts too, could help...
...me to understand how, and what should be the best
practice to dump database, then drop it and merge the dumps..
What I'd like to do is something probably many have done
and I wonder how it's done best
php perspective nothing should
be different, it should be transparent, no?
many thanks
S
On Mon, Feb 29, 2016 at 8:31 AM, lejeczek
<pelj...@yahoo.co.uk <mailto:pelj...@yahoo.co.uk>> wrote:
hi everybody
a novice type of question - having a php + mysql, can
one
hi everybody
a novice type of question - having a php + mysql, can one
just encrypt (internally in mysql) tables and php will be fine?
If not, would it be easy to re-code php to work with this
new, internal encryption?
thanks.
--
MySQL General Mailing List
For list archives:
fellow users, hopefully you experts too, could help...
...me to understand how, and what should be the best
practice to dump database, then drop it and merge the dumps..
What I'd like to do is something probably many have done and
I wonder how it's done best.
A box will be dumping a database
I'm a novice myself and yes I must say on-line documentation is not easy
nor comprehensive,
let's take this page as an example:
http://dev.mysql.com/doc/refman/5.1/en/replication-howto-rawdata.html
if I don't use InnoDB Hot Backup, doc says..
..Otherwise, you can obtain a reliable binary
of abstractions, no php
or similar scripting techincs?
cheers, lejeczek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
19 matches
Mail list logo