if the server is offline , what kind of operation happens on it.
On Thu, Aug 2, 2012 at 11:31 AM, Pothanaboyina Trimurthy <
skd.trimur...@gmail.com> wrote:
> Hi everyone
> i have 4 mysql servers out of those one server will
> be online always and the remaining will be offline and
Hi everyone
i have 4 mysql servers out of those one server will
be online always and the remaining will be offline and online. the
operations takes place at the offline servers i want to replicate the
data from the offline servers to the online server. for this can any
one help me
Sorry, nothing like Roles or Profiles. Copy & Paste.
> -Original Message-
> From: Aastha [mailto:aast...@gmail.com]
> Sent: Wednesday, August 01, 2012 1:56 PM
> To: mysql@lists.mysql.com
> Cc: Aastha
> Subject: create roles/groups in MYSQL
>
> Hello,
>
> I have 10 different users and i
In other words, this might work??
UPDATE Table1 SET
Inventory = REPLACE(Inventory, '"ACRE_PRC119_ID_29"', '"ACRE_PRC119"');
Note: the extra quotes were deliberate.
If it is not always ID_29, then the problem is more difficult.
> -Original Message-
> From: Johan De Meersman [mailto:v
Hello,
I have 10 different users and i have to give different accesses to
different tables.
Is it possible to create a groups with different set of access rights on
different tables.
I know there are ROLES and PROFILES in Oracle. Is there something similar
in MySQL.
Thanks,
Aastha Gupta
Hi,
Use LIMIT 1 to limit the number of output to single record.
Regards,
Vikas Shukla
On Wed, Aug 1, 2012 at 3:56 AM, Paul Halliday wrote:
> On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete
> wrote:
> > I've got a text field called source_recid. It stores half string half
> > number like str
BEGIN;
UPDATE Inno_tbl SET x = 100;
INSERT INTO Myisam_tbl SELECT x FROM Inno_tbl;
UPDATE Inno_tbl SET x = 200;
INSERT INTO Myisam_tbl SELECT x FROM Inno_tbl;
COMMIT;
To get the right values in Myisam_tbl, the transacted and non-transacted
commands must be interleaved. (I am assuming SBR, not RB
On 8/1/2012 1:13 PM, Rick James wrote:
That leads to another question...
Does this 'separate cache' contain an extra copy (vs the 'only' copy) of the
non-transacted events?
I would expect that it must be an extra copy.
No. The non-transacted events are applied to the tables they belong to
as
Hi Monty,
First of all, thanks so much for responding to my question! I am using
MySQLworkbench 5.2.37CE. I'm pretty sure the issue has to do with
something on the administrator side of things. We managed to get it so that
I can click the icon to export the file, but he's still working on getting
That leads to another question...
Does this 'separate cache' contain an extra copy (vs the 'only' copy) of the
non-transacted events?
I would expect that it must be an extra copy.
> -Original Message-
> From: Shawn Green [mailto:shawn.l.gr...@oracle.com]
> ...
> Beginning with 5.5.9, we c
Might need some type coercion:
SELECTSUBSTRING(recid, 13, ) AS numbers FROM table
ORDER BY SUBSTRING(recid, 13, )+0 DESC
> -Original Message-
> From: Paul Halliday [mailto:paul.halli...@gmail.com]
> Sent: Tuesday, July 31, 2012 3:27 PM
> To: Haluk Karamete
> Cc: MySQL
> Subject: Re:
- This mail is in HTML. Some elements may be ommited in plain text. -
Para garantir que os emails provindos da Cordia Comunicações S/A estão sendo
entregues corretamente em sua caixa de email, por favor configure seu filtro de
email para aceitar emails de cordiaip.com.
Email número de conta 4
n imporant error with the MySQL version,
amongst other small issues.
For more information, see
http://www.upscene.com/displaynews.php?item=20120801
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.co
13 matches
Mail list logo