求一条MySql
梅子 2014-03-10 01:34:01 表table:
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| t_id | bigint(21) | NO | | 0 | |
| name | varchar(32) | YES | | NULL | |
| g_ id | bigint(21) | YES | | NULL | |
+-------------+-------------+------+-----+---------+-------+
表g_table
+-------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-------------+------+-----+---------+-------+
| g_id | bigint(21) | NO | | 0 | |
| name | varchar(32) | YES | | NULL | |
两表内数据都有近百万条
现在要更新table表的g_id字段,对应的条件为table.name=g_talbe.name
name字段是唯一的
这条sql要怎么写啊?
求大大指教