Linuxpizi/case_insert.md

Created May 15, 2020 15:06

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

Select an option

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

Download ZIP

MySQL条件插入数据

Raw

case_insert.md

MySQL 条件插入数据

INSERT INTO tbl_employee_info(lname, fname, mname)
VALUES
(
   (CASE lname WHEN '' THEN NULL ELSE lname END),
   (CASE fname WHEN '' THEN NULL ELSE fname END),
   (CASE mname WHEN '' THEN NULL ELSE mname END)
);

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