mysql把一个表格的最新数据更新到另一个表格

在网上找了好多资料都没有办法运行出来，下面分享大家正确的法式。

把student的最新年龄更新到newstdent表格中，表结构如下

CREATE TABLE student(
	id INT,
	NAME VARCHAR(32),
	age INT 
	);
SHOW TABLES;
DESC student;

INSERT INTO student VALUES(1,"小明",23);
INSERT INTO student VALUES(2,"小红",24);
INSERT INTO student VALUES(3,"小绿",25);
INSERT INTO student VALUES(4,"小蓝",26);

创建newstudent复制student的age和name

CREATE TABLE newstudent(
	NAME VARCHAR(32),
	age INT 
	);
DESC newstudent;
修改student某个年龄执行一下实现同步
#insert into newstudent (id,name,age) select t.id,t.name,t.age from student t;
INSERT INTO newstudent (NAME,age) SELECT t.name,t.age FROM student t;

UPDATE newstudent,student
SET newstudent.age=student.`age`
WHERE student.name=newstudent.name;