Mysql\u591a\u8868\u67e5\u8be2\uff0c\u591a\u8868\u63d2\u5165\u548c\u591a\u8868\u66f4\u65b0<\/p>\n
\u591a\u8868\u67e5\u8be2<\/span>\uff1a SELECT c.contact_id, d.droit_id, d.droit FROM contact c, contactdroit cd, droit d \u591a\u8868\u8054\u67e5\u4f8b\u5b50\uff1a select c.nom, e.nom inner join\u65b9\u6cd5\uff1a<\/p>\n select c.nom, e.nom \u591a\u8868\u63d2\u5165<\/span>\uff1a<\/p>\n <?php The mysql_insert_id() function returns the AUTO_INCREMENT ID generated from the previous INSERT operation. This function returns 0 if the previous operation does not generate an AUTO_INCREMENT ID, or FALSE on MySQL connection failure. \u591a\u8868\u66f4\u65b0<\/span>\uff1a mysql> create table two(id int(10), name varchar(20)); mysql> insert one value(1, '1'); mysql> insert two value(22, '22'); mysql> update one o, two t set o.name='oo', t.name='tt'; mysql> select * from one; mysql> select * from two; ==================================================================================<\/p>\n \u5b66\u4e60\u6570\u636e\u5e93\u67e5\u8be2\u7684\u65f6\u5019\u5bf9\u591a\u8868\u8fde\u63a5\u67e5\u8be2\u7684\u6709\u4e9b\u6982\u5ff5\u8fd8\u6bd4\u8f83\u6a21\u7cca\u3002\u800c\u8fde\u63a5\u67e5\u8be2\u662f\u5728\u6570\u636e\u5e93\u67e5\u8be2\u64cd\u4f5c\u7684\u65f6\u5019\u80af\u5b9a\u8981\u7528\u5230\u7684\u3002\u5bf9\u4e8e\u6b64\u6982\u5ff5 employeeid employeename deptid DeptTB\uff08\u90e8\u95e8\u4fe1\u606f\u8868\uff09 \u6211\u4eec\u73b0\u5728\u9700\u8981\u8fdb\u884c\u8fde\u63a5\u67e5\u8be2\uff0c\u8fde\u63a5\u4e24\u5f20\u8868\u68c0\u7d22\u6570\u636e\u3002\u5206\u522b\u68c0\u7d22\u5458\u5de5\u4fe1\u606f\u8868\u7684\u5458\u5de5\u7f16\u53f7\u3001\u5458\u5de5\u59d3\u540d\u548c\u90e8\u95e8\u4fe1\u606f\u8868\u4e2d\u7684\u90e8\u95e8\u540d\u79f0\u3002 employeeid employeename deptname \u800c\u201c\u90d1\u4e03\u201d\u548c\u201c\u5de5\u7a0b\u90e8\u201d\u7684\u4fe1\u606f\u662f\u4e0d\u4f1a\u68c0\u7d22\u51fa\u6765\u3002\u56e0\u4e3a\u91c7\u7528\u5185\u8fde\u63a5\u8ba1\u7b97\u7684\u65f6\u5019\u5fc5\u987b\u8981\u4fdd\u8bc1\u8fde\u63a5\u7684\u6761\u4ef6e.deptid=d.deptid\u5339\u914d\uff0c\u7ed3\u679c\u624d\u4f1a\u88ab\u68c0\u7d22\u51fa\u6765\u3002\u5f53\u6211\u4eec\u8fde\u63a5\u4e24\u5f20\u68c0\u7d22\u6570\u636e\u7684\u65f6\u5019\uff0c\u68c0\u7d22\u7684\u65b9\u5f0f\u662f\u9996\u5148\u9010\u884c\u626b\u63cf\u201c\u5458\u5de5\u4fe1\u606f\u8868\u201d\u4e2d\u7684\u8bb0\u5f55\uff0c\u7136\u540e\u6839\u636e\u8fde\u63a5\u6761\u4ef6\u6765\u51b3\u5b9a\u6b64\u8bb0\u5f55\u662f\u5426\u88ab\u68c0\u7d22\u3002\u6bd4\u5982\u5bf9\u4e8e\u5f20\u4e09\uff0c\u8fd9\u6761\u8bb0\u5f55\u7684deptid\u662f01\uff08\u90e8\u95e8\u7f16\u53f7\uff09\uff0c\u5b83\u5728\u90e8\u95e8\u8868\u4e2d\u80fd\u627e\u5230\u548c\u5b83\u5339\u914d\u7684\u7f16\u53f701\uff0c\u800c\u7f16\u53f701\u7684\u90e8\u95e8\u540d\u79f0\uff08deptname\uff09\u662f\u201c\u6280\u672f\u90e8\u201d\u6240\u4ee5\u5f20\u4e09\u8fd9\u6761\u8bb0\u5f55\u4f1a\u88ab\u68c0\u7d22\uff0c\u6700\u7ec8\u7684\u7ed3\u679c\u80af\u5b9a\u662f\uff1a<\/p>\n 0001 \u5f20\u4e09 \u6280\u672f\u90e8<\/p>\n \u540c\u6837\uff0c\u674e\u56db\u3001\u738b\u4e94\u3001\u8d75\u516d\u4e5f\u80fd\u3002\u4f46\u662f\u90d1\u4e03\u7684\u90e8\u95e8\u7f16\u53f7\u662fNULL\uff0c\u5b83\u5728\u90e8\u95e8\u4fe1\u606f\u8868\u4e2d\u627e\u4e0d\u5230\u5339\u914d\u7684\u9879\uff08\u56e0\u4e3a\u90e8\u95e8\u4fe1\u606f\u8868\u4e2d\u4e0d\u5b58\u5728\u90e8\u95e8\u7f16\u53f7\u4e3aNULL\u7684\u90e8\u95e8\uff09\uff0c\u6240\u4ee5\u90d1\u4e03\u4e0d\u4f1a\u88ab\u68c0\u7d22\u3002 2\u3001\u5de6\u5916\u8054\u7ed3 employeeid employeename deptname \u4f46\u662f\u5728\u8fd9\u91cc\uff0c\u5de5\u7a0b\u90e8\u540c\u6837\u4e0d\u4f1a\u88ab\u68c0\u7d22\uff0c\u56e0\u4e3a\uff0cdeptname\u662f\u5728\u8fde\u63a5\u7684\u53f3\u8fb9\u7684\u8868\u4e2d\uff0c\u201c\u5de5\u7a0b\u90e8\u201d\u5728\u5de6\u8868\u4e2d\u4e0d\u5b58\u5728\u4efb\u4f55\u7684\u8bb0\u5f55\uff0c\u6240\u4ee5\u4e0d\u4f1a\u88ab\u68c0\u7d22\u3002\u8fd9\u91cc\u5173\u6ce8\u7684\u662f\u201c\u8fde\u63a5\u4e2d\u7684\u5de6\u8fb9\u7684\u8868\u201d<\/p>\n 3\u3001\u53f3\u5916\u8fde\u63a5 employeeid employeename deptname \u4f46\u5728\u8fd9\u91cc\uff0c\u90d1\u4e03\u662f\u4e0d\u4f1a\u88ab\u68c0\u7d22\u4e86\uff0c\u56e0\u4e3a\u5b83\u5728\u53f3\u8868\u4e2d\u627e\u4e0d\u5230\u5339\u914d\u9879\uff0c\u8fd9\u91cc\u5173\u6ce8\u7684\u662f\u201c\u8fde\u63a5\u4e2d\u7684\u53f3\u8fb9\u7684\u8868\u201d<\/p>\n 4\u3001\u5b8c\u5168\u5916\u8fde\u63a5 employeeid employeename deptname Mysql\u591a\u8868\u67e5\u8be2\uff0c\u591a\u8868\u63d2\u5165\u548c\u591a\u8868\u66f4\u65b0 \u591a\u8868\u67e5\u8be2\uff1a CREATE TABLE IF NOT EXISTS co […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[35],"class_list":["post-185","post","type-post","status-publish","format-standard","hentry","category-Technical_literature","tag-mysql"],"views":1624,"_links":{"self":[{"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/posts\/185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/comments?post=185"}],"version-history":[{"count":0,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/posts\/185\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/media?parent=185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/categories?post=185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.datarelab.com\/blog\/wp-json\/wp\/v2\/tags?post=185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nCREATE TABLE IF NOT EXISTS contact(
\ncontact_id int(11) NOT NULL AUTO_INCREMENT,
\nuser_name varchar(255),
\nnom varchar(255),
\nprenom varchar(255),
\nmail varchar(64),
\npasscode char(64),
\nPRIMARY KEY(contact_id)
\n);
\nCREATE TABLE IF NOT EXISTS droit(
\ndroit_id int( 11 ) NOT NULL AUTO_INCREMENT ,
\ndroit varchar(255),
\nPRIMARY KEY(droit_id)
\n);
\nCREATE TABLE IF NOT EXISTS contactdroit(
\ncontactdroit_id int(11) NOT NULL AUTO_INCREMENT,
\ncontact_id int( 11 ),
\ndroit_id int( 11 ),
\nPRIMARY KEY( contactdroit_id )
\n);
\nInsert into contact(contact_id, user_name) values(1,'user1');
\nInsert into contact(contact_id, user_name) values(2,'user2');
\nInsert into contact(contact_id, user_name) values(3,'user3');
\nInsert into droit(droit_id, droit) values(1,'admin');
\nInsert into droit(droit_id, droit) values(2,'superuser');
\nInsert into contactdroit(contact_id, droit_id) values(1, 1);
\nInsert into contactdroit(contact_id, droit_id) values(2, 1);
\nInsert into contactdroit(contact_id, droit_id) values(3, 2);<\/p>\n
\nwhere c.contact_id = cd.contact_id
\nand cd.droit_id = d.droit_id;
\n\u7ed3\u679c\uff1a
\ncontact_id \u00a0\u00a0\u00a0 droit_id \u00a0\u00a0\u00a0 droit
\n1 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 admin
\n2 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0 admin
\n3 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2 \u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0 superuser<\/p>\n
\n\u4e24\u4e2a\u65b9\u6cd5\u90fd\u53ef\u4ee5\uff0cinner join on \u66f4\u597d\u70b9\u3002\u8868\u7ed3\u6784\u6ca1\u8d34\u51fa\u6765\uff0c\u4f46\u6bd4\u8f83\u597d\u61c2\u4e86\u3002
\n\u7b80\u5355\u65b9\u6cd5\uff1a<\/p>\n
\nfrom consultant c, affaire a, besoin b, salarie sa, site s, entreprise e
\nwhere c.consultant_id=a.consultant_id and a.besoin_id=b.besoin_id and b.salarie_id=sa.salarie_id and sa.site_id=s.site_id and s.entreprise_id=e.entreprise_id<\/p>\n
\nfrom consultant c
\ninner join affaire a on c.consultant_id=a.consultant_id
\ninner join besoin b on a.besoin_id=b.besoin_id
\ninner join salarie sa on b.salarie_id=sa.salarie_id
\ninner join site s on sa.site_id=s.site_id
\ninner join entreprise e on s.entreprise_id=e.entreprise_id<\/p>\n
\n$conn = mysql_connect(\"localhost\",\"charles\",\"charles\");
\nmysql_select_db(\"test\");
\n$query = \"INSERT INTO contact(user_name,nom, prenom, mail, passcode) values('sa','se','sf', 'safd@p.com', '123')\";
\n$result = mysql_query($query) or die(\"insert contact failed:\".mysql_error());
\n$lastid = mysql_insert_id(); \/\/\u5f97\u5230\u4e0a\u4e00\u4e2a \u63d2\u5165\u7684id\u503c
\necho \"last insert id :\".$lastid.\"<br>\";
\n$query2 = \"INSERT INTO contactdroit(contact_id, droit_id) values('$lastid','11')\";
\necho $query2.\"<br>\";
\n$result2 = mysql_query($query2) or die(\"insert contactdroit failed: \".mysql_error());
\nif(isset($result) && isset($result2)){
\necho \"Good Insertion<br>\";
\necho $lastid;
\n}
\n?>
\n\u9700\u6ce8\u610f\u7684\u662f\uff1a<\/p>\n
\nmysql_insert_id()\u51fd\u6570\u7684\u4f5c\u7528\u662f\uff1a\u53d6\u5f97\u4e0a\u4e00\u6b65 INSERT \u64cd\u4f5c\u4ea7\u751f\u7684 ID\u3002<\/p>\n
\n\u5982\u679c\u5148\u524d\u7684\u64cd\u4f5c\u4e0d\u4ea7\u751f\u4e00\u4e2a\u81ea\u52a8\u589e\u52a0\u7684ID[AUTO_INCREMENT ID]\uff0c\u90a3\u4e48\uff0c\u51fd\u6570\u8fd4\u56de0\uff1b\u5982\u679cMySQL\u8fde\u63a5\u5931\u8d25\uff0c\u5c06\u8fd4\u56deFalse\u3002<\/p>\n
\nupdate contact c, contactdroit cd
\nset c.user_name = '$username', c.nom = '$lastname', c.prenom = '$firstname', c.passcode = '$password', cd.droit_id = '$droitid'
\nwhere c.contact_id = '$id' and c.contact_id = cd.contact_id;
\n\u793a\u4f8b\uff1a
\n\u3010\u4ee5\u4e0b\u4e3a\u5f15\u7528\uff1ahttp:\/\/www.javaeye.com\/problems\/340 \u3011
\nmysql> create table one(id int(10), name varchar(20));
\nQuery OK, 0 rows affected (0.03 sec)<\/p>\n
\nQuery OK, 0 rows affected (0.05 sec)<\/p>\n
\nQuery OK, 1 row affected (0.00 sec)<\/p>\n
\nQuery OK, 1 row affected (1.02 sec)<\/p>\n
\nQuery OK, 2 rows affected (0.00 sec)
\nRows matched: 2 Changed: 2 Warnings: 0<\/p>\n
\n+------+------+
\n| id\u00a0\u00a0 | name |
\n+------+------+
\n|\u00a0\u00a0\u00a0 1 | oo\u00a0\u00a0 |
\n+------+------+
\n1 row in set (0.00 sec)<\/p>\n
\n+------+------+
\n| id\u00a0\u00a0 | name |
\n+------+------+
\n|\u00a0\u00a0 22 | tt\u00a0\u00a0 |
\n+------+------+
\n1 row in set (0.00 sec)<\/p>\n
\n\u6211\u7528\u901a\u4fd7\u4e00\u4e9b\u7684\u8bed\u8a00\u548c\u4f8b\u5b50\u6765\u8fdb\u884c\u8bb2\u89e3\u3002\u8fd9\u4e2a\u4f8b\u5b50\u662f\u6211\u8bb2\u8bfe\u7684\u65f6\u5019\u7ecf\u5e38\u91c7\u7528\u7684\u4f8b\u5b50\u3002
\n\u9996\u5148\u6211\u4eec\u505a\u4e24\u5f20\u8868\uff1a\u5458\u5de5\u4fe1\u606f\u8868\u548c\u90e8\u95e8\u4fe1\u606f\u8868\uff0c\u5728\u6b64\uff0c\u8868\u7684\u5efa\u7acb\u53ea\u4e3a\u8bb2\u8ff0\u8fde\u63a5\u7684\u6982\u5ff5\uff0c\u6240\u4ee5\u5b57\u6bb5\u975e\u5e38\u7684\u7b80\u5355
\nEmployeeTB\uff08\u5458\u5de5\u4fe1\u606f\u8868\uff09\uff1a<\/p>\n
\n0001 \u5f20\u4e09 01
\n0002 \u674e\u56db 01
\n0003 \u738b\u4e94 02
\n0004 \u8d75\u516d 02
\n0005 \u90d1\u4e03 NULL<\/p>\n
\ndeptid deptname
\n01 \u6280\u672f\u90e8
\n02 \u5e02\u573a\u90e8
\n03 \u5de5\u7a0b\u90e8<\/p>\n
\n\u663e\u7136\uff0c\u4e24\u4e2a\u8868\u7684\u8fde\u63a5\u6761\u4ef6\u662f \u5458\u5de5\u8868\u7684\u90e8\u95e8\u7f16\u53f7=\u90e8\u95e8\u8868\u7684\u90e8\u95e8\u7f16\u53f7
\n\u6ce8\u610f\uff1a\u90d1\u4e03\u4e0d\u5c5e\u4e8e\u4efb\u4f55\u90e8\u95e8\uff08\u65b0\u6765\u7684\u5458\u5de5\uff0c\u8fd8\u6ca1\u6709\u5206\u914d\u5230\u4efb\u4f55\u7684\u90e8\u95e8\uff09\uff0c\u800c\u5de5\u7a0b\u90e8\u4e0d\u5b58\u5728\u4efb\u4f55\u7684\u5458\u5de5\uff08\u6bd4\u5982\u662f\u4e00\u4e2a\u65b0\u6210\u7acb\u7684\u90e8\u95e8\uff0c\u8fd8\u6ca1\u6709\u5458\u5de5\uff09
\n1\u3001\u5185\u8fde\u63a5\u67e5\u8be2
\n\u6211\u4eec\u53ef\u4ee5\u6709\u4e24\u79cd\u65b9\u5f0f\uff0c\u8fd9\u4e24\u79cd\u662f\u7b49\u6548\u7684
\n\u4e00\u79cd\u662f\uff1aSELECT e.employeeid,e.employeename,d.deptname FROM EmployeeTB AS e,DeptTB AS d WHERE e.deptid=d.deptid
\n\u53e6\u5916\u4e00\u4e2a\u662f\uff1aSELECT e.employeeid,e.employeename,d.deptname FROM EmployeeTB AS e INNER JOIN DeptTB AS d ON e.deptid=d.deptid
\n\u68c0\u7d22\u7684\u7ed3\u679c\u90fd\u662f\uff1a<\/p>\n
\n0001 \u5f20\u4e09 \u6280\u672f\u90e8
\n0002 \u674e\u56db \u6280\u672f\u90e8
\n0003 \u738b\u4e94 \u5e02\u573a\u90e8
\n0004 \u8d75\u516d \u5e02\u573a\u90e8<\/p>\n
\n\u540c\u7406\uff0c\u6ca1\u6709\u4efb\u4f55\u4eba\u5458\u7684\u90e8\u95e8\u7f16\u53f7\u4e3a03\uff0c\u6240\u4ee5\u5de5\u7a0b\u90e8\u7684\u8bb0\u5f55\u4e5f\u4e0d\u4f1a\u88ab\u68c0\u7d22<\/p>\n
\n\u4f46\u662f\u6709\u4e9b\u60c5\u51b5\u4e0b\uff0c\u6211\u4eec\u9700\u8981\u77e5\u9053\u6240\u6709\u5458\u5de5\u7684\u4fe1\u606f\uff0c\u5373\u4f7f\u4ed6\u4e0d\u5c5e\u4e8e\u4efb\u4f55\u90e8\u95e8\u3002\u8fd9\u6837\u6211\u4eec\u5c31\u53ef\u4ee5\u91c7\u7528\u5916\u8fde\u63a5\uff0c\u5728\u8fd9\u91cc\u4e3a\u5de6\u5916\u8fde\u63a5\uff0c\u4e5f\u5c31\u662f\u8fde\u63a5\u4e2d\u7684\u5de6\u8868\u7684\u8868\u4e2d\u7684\u8bb0\u5f55\uff0c\u65e0\u8bba\u80fd\u4e0d\u80fd\u5728\u53f3\u8868\u4e2d\u627e\u5230\u5339\u914d\u7684\u9879\uff0c\u90fd\u8981\u68c0\u7d22\uff0c\u5982\u679c\u6ca1\u6709\u5339\u914d\u7684\u9879\u76ee\uff0c\u90a3\u4e48\u53f3\u8868\u4e2d\u7684\u5b57\u6bb5\u503c\u4e3aNULL\uff08\u7a7a\uff09\uff0c\u5728\u8fd9\u91cc\u5c31\u4ee3\u8868\uff0c\u6b64\u5458\u5de5\u4e0d\u5c5e\u4e8e\u4efb\u4f55\u90e8\u95e8\u3002
\n\u68c0\u7d22\u8bed\u53e5\u4e3a\uff1a
\nSELECT e.employeeid,e.employeename,d.deptname FROM EmployeeTB AS e LEFT OUTER JOIN DeptTB AS d ON e.deptid=d.deptid
\n\u68c0\u7d22\u7684\u7ed3\u679c\u90fd\u662f\uff1a<\/p>\n
\n0001 \u5f20\u4e09 \u6280\u672f\u90e8
\n0002 \u674e\u56db \u6280\u672f\u90e8
\n0003 \u738b\u4e94 \u5e02\u573a\u90e8
\n0004 \u8d75\u516d \u5e02\u573a\u90e8
\n0005 \u90d1\u4e03 NULL<\/p>\n
\n\u6709\u65f6\uff0c\u6211\u4eec\u9700\u8981\u77e5\u9053\uff0c\u5168\u90e8\u90e8\u95e8\u7684\u4fe1\u606f\uff0c\u5373\u4f7f\u5b83\u6ca1\u6709\u4efb\u4f55\u7684\u5458\u5de5\u3002\u5728\u6211\u4eec\u7684\u67e5\u8be2\u4e2d\u90e8\u95e8\u8868\u5728\u8fde\u63a5\u7684\u53f3\u8fb9\uff0c\u5982\u679c\u6211\u4eec\u60f3\u77e5\u9053\u53f3\u8fb9\u8868\u4e2d\u7684\u6240\u6709\u8bb0\u5f55\u4fe1\u606f\uff0c\u90a3\u4e48\u5c31\u53ef\u4ee5\u91c7\u7528\u53f3\u5916\u8fde\u63a5\uff0c\u5982\u679c\u6b64\u8bb0\u5f55\u5728\u5de6\u8fb9\u7684\u8868\u4e2d\u627e\u4e0d\u5230\u5339\u914d\u9879\uff0c\u5219\u76f8\u5e94\u5b57\u6bb5\uff08employeeid,employeename)\u4e3aNULL
\n\u68c0\u7d22\u8bed\u53e5\u4e3a\uff1a
\nSELECT e.employeeid,e.employeename,d.deptname FROM EmployeeTB AS e RIGHT OUTER JOIN DeptTB AS d ON e.deptid=d.deptid
\n\u68c0\u7d22\u7684\u7ed3\u679c\u90fd\u662f\uff1a<\/p>\n
\n0001 \u5f20\u4e09 \u6280\u672f\u90e8
\n0002 \u674e\u56db \u6280\u672f\u90e8
\n0003 \u738b\u4e94 \u5e02\u573a\u90e8
\n0004 \u8d75\u516d \u5e02\u573a\u90e8
\nNULL NULL \u5de5\u7a0b\u90e8<\/p>\n
\n\u5982\u679c\u6211\u4eec\u60f3\u77e5\u9053\u6240\u6709\u7684\u8bb0\u5f55\u5462\uff1f\u65e0\u8bba\u5458\u5de5\u6709\u6ca1\u6709\u90e8\u95e8\uff0c\u90e8\u95e8\u6709\u6ca1\u6709\u5458\u5de5\uff0c\u6211\u4eec\u90fd\u9700\u8981\u68c0\u7d22\u3002\u8fd9\u91cc\u5c31\u53ef\u4ee5\u4f7f\u7528\u5b8c\u5168\u5916\u8fde\u63a5\u3002\u5173\u6ce8\u8fde\u63a5\u4e2d\u7684\u4e24\u90e8\u5206\u3002\u5982\u679c\u6ca1\u6709\u90e8\u95e8\uff0c\u90e8\u95e8\u4e3a\u7a7a\uff0c\u6ca1\u6709\u5458\u5de5\uff0c\u5458\u5de5\u4fe1\u606f\u4e3a\u7a7a\u3002
\n\u68c0\u7d22\u8bed\u53e5\u4e3a\uff1a
\nSELECT e.employeeid,e.employeename,d.deptname FROM EmployeeTB AS e FULL OUTER JOIN DeptTB AS d ON e.deptid=d.deptid
\n\u68c0\u7d22\u7684\u7ed3\u679c\u90fd\u662f\uff1a<\/p>\n
\n0001 \u5f20\u4e09 \u6280\u672f\u90e8
\n0002 \u674e\u56db \u6280\u672f\u90e8
\n0003 \u738b\u4e94 \u5e02\u573a\u90e8
\n0004 \u8d75\u516d \u5e02\u573a\u90e8
\n0005 \u90d1\u4e03 NULL
\nNULL NULL \u5de5\u7a0b\u90e8<\/p>\n","protected":false},"excerpt":{"rendered":"