vuuvv/mysql update join 语句

Created December 26, 2017 02:58

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/vuuvv/e8d9ccef6f6420dd9741827cc9cf5efa.js"></script>
Save vuuvv/e8d9ccef6f6420dd9741827cc9cf5efa to your computer and use it in GitHub Desktop.

Download ZIP

Raw

mysql update join 语句

	update
	`t_area` AS a
	JOIN
	t_area as p on a.parent_code=p.`code`
	set a.parent_id=p.id

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment