I think you'd have to do that with a trigger.
On 4/8/15 6:36 AM, Martin Mueller wrote:
I understand how a timestamp column automatically changes when there is a
change in a data row. Is it possible to limit the update to changes in
particular columns? I have a table where I care about changes
I thought that TEXT fields only stored a pointer to the actual data in the
table,
not the data itself - storing 9 to 12 bytes in the table:
|BLOB| https://dev.mysql.com/doc/refman/5.0/en/blob.htmland|TEXT| https://dev.mysql.com/doc/refman/5.0/en/blob.htmlcolumns count from
one to four plus
I would think that:
SELECT email FROM participants
WHERE email NOT IN (SELECT email FROM excluded)
would do the trick
andy
I am trying to do something like this
select email from participants
minus
select email from excluded
It seems there is no minus function in MySQL. I tried
Hi -
I'm having an issue with left joins and multiple tables. I have a table
which is a fairly simple name-value pair table:
create table
{
acnt char(20),
item char(40),
value char (60)
}
I want to pull out all of a subset of the values for a particular account.
It works for
two
