Re: longtext fields in a row

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| and|TEXT| columns count from one to four plus

Re: time stamp specific to columns

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

mysql 4.11, left joins, multiple tables

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 of

Re: What is the equivalent of the minus function?

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