possible to record changes (trigger I think) msql

yes, that is perfectly possible, and you should start reading this page of the reference manual (you many need to switch to your version of mysql as needed):
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html

Thanks angelIII, i am restricted as using raspberry pi: but will start reading now,,,

ok i thought i followed it correctly but guess i did not as it did not work

Table

CREATE TABLE `F1database`.`f1userhistory` (
  `idf1userhistory` INT ,
  `f1TeamName` VARCHAR(145) NULL,
  `f1submissionID` VARCHAR(45) NULL,
  `f1driverName1` VARCHAR(145) NULL,
  `f1driverName2` VARCHAR(145) NULL,
  `DateStamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`idf1userhistory`));
USE `F1database`;

Select allOpen in new window

Trigger

DELIMITER $$
CREATE
    TRIGGER updatehistory AFTER Update
    ON f1users  
   FOR EACH ROW BEGIN
	
		IF updated THEN
			SET @f1TeamName =  TeamName;
			SET @f1submissionID =  submissionID;
			SET @f1driverName1 =  driver1;
			SET @f1driverName2 =  driver2;	
			SET @DateStamp =  DateStamp;
		END IF;
    
		INSERT INTO updatehistory (idf1userhistory, f1TeamName,f1submissionID,f1driverName1,f1driverName2,DateStamp) VALUES (idf1userhistory, @f1TeamName,$f1submissionID,$f1driverName1,$f1driverName2,CURDATE());
		
    END$$

Select allOpen in new window

when i did a update nothing was stored in table

Hi!

This should work.

ELIMITER $$
CREATE
    TRIGGER updatehistory AFTER Update
    ON f1users  
   FOR EACH ROW BEGIN
	
			SET @f1TeamName =  TeamName;
			SET @f1submissionID =  submissionID;
			SET @f1driverName1 =  driver1;
			SET @f1driverName2 =  driver2;	
			SET @DateStamp =  DateStamp;
    
		INSERT INTO updatehistory (f1TeamName,f1submissionID,f1driverName1,f1driverName2,DateStamp) VALUES ( @f1TeamName,$f1submissionID,$f1driverName1,$f1driverName2,CURDATE());
		
    END$$

Select allOpen in new window

The if statement is causing the values not to be set.
Also make sure that the column idf1userhistory is set to AUTO_INCREMENT

 `idf1userhistory` INT AUTO_INCREMENT 

Select allOpen in new window

then you can skip that column in the insert statement in the trigger. Othervice you would need to put a unique value in the variable.

Regards,
    Tomas Helgi

sorry had to travel with work...

bug thanks for code and explanation

i now get
Error Code: 1235. This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'

Hi!

You need to drop the existing trigger on your table before creating the new one.

Regards,
     Tomas Helgi

cool thanks but 99% they will not change team name: so should i remove it?

Hi!

The update trigger is only triggered on an update on your table and the history table gets a new record.
So select on the history table shows all changes done on the main table.
And only update on the main table changes the data not this trigger.

Regards,
   Tomas Helgi

When I update main table I get nothing in history table...

Thanks for all your help: and explaining... helps me learn