2013/04/30 17:17 +0200, Martin Koch
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
Try this: _binary X'36a461c81cab40169791f49ad65a3728'
SHOW CREATE VIEW is the command for the client.
--
MySQL General Mailing List
Fo
WHERE id = UNHEX('36a461c81cab40169791f49ad65a3728')
> -Original Message-
> From: Martin Koch [mailto:m...@issuu.com]
> Sent: Tuesday, April 30, 2013 8:18 AM
> To: mysql@lists.mysql.com
> Subject: Long integer constant problem in views
>
> Hi List
>
> I have a table with a primary key
See also Percona XtraDB Cluster.
Will you nodes be in the same physical location? If so, what about floods,
earthquakes, etc?
"Clouds are ephemeral; data wants to persist"
> -Original Message-
> From: Andrew Morgan [mailto:andrew.mor...@oracle.com]
> Sent: Tuesday, April 30, 2013 12:36
OR would not show dups.
WHERE duespaid AND cat1 OR cat2
means
WHERE (duespaid AND cat1) OR cat2
That is probably not what you wanted -- add parens like
WHERE duespaid AND (cat1 OR cat2 ...)
But...
That is not a good way to build a schema. What will happen when you add
category9?
Plan A: Have
Please provide
SHOW CREATE TABLE cdsem_event_message_idx \G
EXPLAIN SELECT * FROM cdsem_event_message_idx where event_id in () \G
SHOW VARIABLES LIKE 'autocommit';
These can impact DELETE speed:
* secondary indexes
* whether event_id is indexed.
* disk type and speed -- ordin
Or
SELECT ... \G
(replace ';' with '\G')
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs.net]
> Sent: Wednesday, April 24, 2013 9:55 AM
> To: mysql list
> Subject: Re: how to list record in column (instead of a row)
>
> 2013/04/24 09:06 -0700, Rajeev Prasad
> t
2013/4/30 Richard Reina
> I have a few slaves set up on my local network that get updates from
> my main mysql database master. I was hoping to turn one into a master
> while keeping it a slave so that I can set up a chain. Does anyone
> know where I can find a "how to" or other documentation fo
Hi List
I have a table with a primary key with type binary(16) and a few columns.
I'd trying to create a view that looks up all rows with a particular key,
i.e. something like
CREATE OR REPLACE VIEW foo AS
SELECT *
FROM mytable
WHERE id = X'36a461c81cab40169791f49ad65a3728';
I use the mysq
Hi Neil,
If you use MySQL Cluster then you have synchronous replication between the 2
data nodes which means that if one should fail you're guaranteed that the other
contains the effects of every committed transaction and that the change has
already been applied and so there is no delay while
