\u0632\u0628\u0627\u0646 Structured Query Language<\/strong> \u06a9\u0647 \u0628\u06cc\u0634\u062a\u0631 \u0628\u0627 \u0646\u0627\u0645 SQL<\/strong> \u0634\u0646\u0627\u062e\u062a\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0627\u0646\u0639\u0637\u0627\u0641\u200c\u067e\u0630\u06cc\u0631\u06cc \u0628\u0627\u0644\u0627\u06cc\u06cc \u062f\u0631 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 \u062c\u062f\u0648\u0644\u200c\u0647\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc\u200c\u06a9\u0646\u062f. \u0628\u0631\u0627\u06cc \u0645\u062b\u0627\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06a9\u0644\u0645\u0647 \u06a9\u0644\u06cc\u062f\u06cc VALUES<\/strong> \u0631\u062f\u06cc\u0641\u200c\u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u062f\u0633\u062a\u06cc \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f\u060c \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06a9\u0648\u0626\u0631\u06cc\u200c\u0647\u0627\u06cc SELECT<\/strong> \u0645\u062c\u0645\u0648\u0639\u0647\u200c\u0627\u06cc \u0627\u0632 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644\u200c\u0647\u0627\u06cc \u062f\u06cc\u06af\u0631 \u06a9\u067e\u06cc \u06a9\u0646\u06cc\u062f\u060c \u06cc\u0627 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc\u06cc \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f \u06a9\u0647 SQL \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u062e\u0648\u062f\u06a9\u0627\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0631 \u0622\u0646\u200c\u0647\u0627 \u062f\u0631\u062c \u06a9\u0646\u062f.<\/p>\n \u062f\u0631 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627\u060c \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc\u200c\u06a9\u0646\u06cc\u0645 \u06a9\u0647 \u0686\u06af\u0648\u0646\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0633\u06cc\u0646\u062a\u06a9\u0633 INSERT INTO<\/strong> \u062f\u0631 SQL\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0628\u0647 \u0631\u0648\u0634\u200c\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641 \u0628\u0647 \u062c\u062f\u0648\u0644\u200c\u0647\u0627 \u0627\u0636\u0627\u0641\u0647 \u06a9\u0646\u06cc\u0645.<\/p>\n \u0628\u0631\u0627\u06cc \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0631\u0627\u0647\u0646\u0645\u0627 \u0628\u0647 \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f:<\/p>\n \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0645\u062f\u06cc\u0631\u06cc\u062a \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627\u0628\u0637\u0647\u200c\u0627\u06cc (RDBMS) \u06a9\u0647 \u0627\u0632 SQL \u067e\u0634\u062a\u06cc\u0628\u0627\u0646\u06cc \u06a9\u0646\u062f<\/p>\n<\/li>\n \u0645\u062b\u0627\u0644\u200c\u0647\u0627 \u0648 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u062f\u0631 \u0645\u062d\u06cc\u0637 \u0632\u06cc\u0631 \u0628\u0631\u0631\u0633\u06cc \u0634\u062f\u0647\u200c\u0627\u0646\u062f:<\/p>\n \u0633\u0631\u0648\u0631\u06cc \u0628\u0627 Ubuntu 20.04<\/strong><\/p>\n<\/li>\n \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 non-root \u0628\u0627 \u062f\u0633\u062a\u0631\u0633\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a\u06cc \u0648 \u0641\u0627\u06cc\u0631\u0648\u0627\u0644 \u0641\u0639\u0627\u0644 (UFW)<\/p>\n<\/li>\n MySQL<\/strong> \u0646\u0635\u0628 \u0648 \u0627\u06cc\u0645\u0646\u200c\u0633\u0627\u0632\u06cc\u200c\u0634\u062f\u0647 \u0631\u0648\u06cc \u0633\u0631\u0648\u0631<\/p>\n<\/li>\n \u06cc\u06a9 \u06a9\u0627\u0631\u0628\u0631 non-root \u062f\u0631 MySQL<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n \u062a\u0648\u062c\u0647:<\/strong> \u0628\u0633\u06cc\u0627\u0631\u06cc \u0627\u0632 RDBMS\u0647\u0627 \u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc \u0645\u062e\u0635\u0648\u0635 \u0628\u0647 \u062e\u0648\u062f \u0627\u0632 SQL \u0631\u0627 \u062f\u0627\u0631\u0646\u062f. \u0627\u06af\u0631\u0686\u0647 \u062f\u0633\u062a\u0648\u0631\u0627\u062a \u0627\u06cc\u0646 \u0622\u0645\u0648\u0632\u0634 \u062f\u0631 \u0627\u063a\u0644\u0628 \u0633\u06cc\u0633\u062a\u0645\u200c\u0647\u0627 \u06a9\u0627\u0631 \u0645\u06cc\u200c\u06a9\u0646\u0646\u062f\u060c \u0627\u0645\u0627 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0633\u06cc\u0646\u062a\u06a9\u0633 \u06cc\u0627 \u062e\u0631\u0648\u062c\u06cc \u062f\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633\u200c\u0647\u0627\u06cc\u06cc \u063a\u06cc\u0631 \u0627\u0632 MySQL \u06a9\u0645\u06cc \u0645\u062a\u0641\u0627\u0648\u062a \u0628\u0627\u0634\u062f.<\/p>\n<\/blockquote>\n \u0647\u0645\u0686\u0646\u06cc\u0646 \u0628\u0647 \u06cc\u06a9 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0648 \u062c\u062f\u0648\u0644 \u0646\u0645\u0648\u0646\u0647 \u0646\u06cc\u0627\u0632 \u062f\u0627\u0631\u06cc\u062f \u062a\u0627 \u0628\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0631\u062c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062a\u0645\u0631\u06cc\u0646 \u06a9\u0646\u06cc\u062f. \u0627\u06af\u0631 \u0686\u0646\u06cc\u0646 \u0633\u0627\u062e\u062a\u0627\u0631\u06cc \u0646\u062f\u0627\u0631\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0628\u062e\u0634 \u00ab\u0627\u062a\u0635\u0627\u0644 \u0628\u0647 MySQL \u0648 \u0633\u0627\u062e\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0646\u0645\u0648\u0646\u0647\u00bb \u0631\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0646\u06cc\u062f.<\/p>\n \u0627\u06af\u0631 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 SQL \u0634\u0645\u0627 \u0631\u0648\u06cc \u06cc\u06a9 \u0633\u0631\u0648\u0631 \u0631\u0627\u0647 \u062f\u0648\u0631 \u0627\u062c\u0631\u0627 \u0645\u06cc\u200c\u0634\u0648\u062f\u060c \u0627\u0628\u062a\u062f\u0627 \u0627\u0632 \u0637\u0631\u06cc\u0642 SSH \u0628\u0647 \u0633\u0631\u0648\u0631 \u0645\u062a\u0635\u0644 \u0634\u0648\u06cc\u062f:<\/p>\n \u0633\u067e\u0633 \u0648\u0627\u0631\u062f \u0645\u062d\u06cc\u0637 MySQL \u0634\u0648\u06cc\u062f (\u0628\u0647\u200c\u062c\u0627\u06cc \u0627\u06cc\u062c\u0627\u062f \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0628\u0627 \u0646\u0627\u0645 \u062f\u0631 \u0635\u0648\u0631\u062a \u0645\u0648\u0641\u0642\u06cc\u062a\u060c \u062e\u0631\u0648\u062c\u06cc \u0645\u0634\u0627\u0628\u0647 \u0632\u06cc\u0631 \u062f\u0631\u06cc\u0627\u0641\u062a \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f:<\/p>\n \u0627\u0646\u062a\u062e\u0627\u0628 \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633:<\/p>\n \u0641\u0631\u0636 \u06a9\u0646\u06cc\u062f \u0645\u0627\u0644\u06a9 \u06cc\u06a9 \u06a9\u0627\u0631\u062e\u0627\u0646\u0647 \u0647\u0633\u062a\u06cc\u062f \u0648 \u0645\u06cc\u200c\u062e\u0648\u0627\u0647\u06cc\u062f \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u06a9\u0627\u0631\u06a9\u0646\u0627\u0646 \u0631\u0627 \u0630\u062e\u06cc\u0631\u0647 \u06a9\u0646\u06cc\u062f. \u062c\u062f\u0648\u0644 \u0645\u0648\u0631\u062f\u0646\u0638\u0631 \u062f\u0627\u0631\u0627\u06cc \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n name<\/strong>: \u0646\u0627\u0645 \u06a9\u0627\u0631\u0645\u0646\u062f (varchar \u0628\u0627 \u062d\u062f\u0627\u06a9\u062b\u0631 \u06f3\u06f0 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631)<\/p>\n<\/li>\n position<\/strong>: \u0639\u0646\u0648\u0627\u0646 \u0634\u063a\u0644\u06cc (varchar \u0628\u0627 \u062d\u062f\u0627\u06a9\u062b\u0631 \u06f3\u06f0 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631)<\/p>\n<\/li>\n department<\/strong>: \u0628\u062e\u0634 \u0645\u062d\u0644 \u06a9\u0627\u0631 (varchar \u0628\u0627 \u062d\u062f\u0627\u06a9\u062b\u0631 \u06f2\u06f0 \u06a9\u0627\u0631\u0627\u06a9\u062a\u0631)<\/p>\n<\/li>\n hourlyWage<\/strong>: \u062f\u0633\u062a\u0645\u0632\u062f \u0633\u0627\u0639\u062a\u06cc (decimal \u0628\u0627 \u0641\u0631\u0645\u062a 4,2)<\/p>\n<\/li>\n startDate<\/strong>: \u062a\u0627\u0631\u06cc\u062e \u0634\u0631\u0648\u0639 \u0628\u0647 \u06a9\u0627\u0631 (date \u0628\u0627 \u0641\u0631\u0645\u062a YYYY-MM-DD)<\/p>\n<\/li>\n<\/ul>\n \u0633\u0627\u062e\u062a \u062c\u062f\u0648\u0644:<\/p>\n \u0633\u06cc\u0646\u062a\u06a9\u0633 \u06a9\u0644\u06cc \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u062f\u0631 SQL \u0628\u0647 \u0634\u06a9\u0644 \u0632\u06cc\u0631 \u0627\u0633\u062a:<\/p>\n \u0645\u062b\u0627\u0644: \u062f\u0631\u062c \u06cc\u06a9 \u0631\u062f\u06cc\u0641 \u062f\u0627\u062f\u0647 \u062f\u0631 \u062c\u062f\u0648\u0644 \u062a\u0631\u062a\u06cc\u0628 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0645\u0647\u0645 \u0646\u06cc\u0633\u062a\u060c \u0627\u0645\u0627 \u062a\u0631\u062a\u06cc\u0628 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0628\u0627\u06cc\u062f \u062f\u0642\u06cc\u0642\u0627\u064b \u0628\u0627 \u062a\u0631\u062a\u06cc\u0628 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0647\u0645\u0627\u0647\u0646\u06af \u0628\u0627\u0634\u062f<\/strong>. \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0627\u0634\u062a\u0628\u0627\u0647 \u062f\u0631\u062c \u0645\u06cc\u200c\u0634\u0648\u0646\u062f \u06cc\u0627 \u062e\u0637\u0627 \u0631\u062e \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n \u0645\u062b\u0627\u0644 \u062f\u0631\u062c \u0628\u0627 \u062a\u0631\u062a\u06cc\u0628 \u0645\u062a\u0641\u0627\u0648\u062a \u0633\u062a\u0648\u0646\u200c\u0647\u0627:<\/p>\n \u0627\u06af\u0631 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0628\u0627 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0633\u0627\u0632\u06af\u0627\u0631 \u0646\u0628\u0627\u0634\u062f\u060c \u062e\u0637\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u062e\u0648\u0627\u0647\u06cc\u062f \u06a9\u0631\u062f:<\/p>\n \u0644\u0627\u0632\u0645 \u0646\u06cc\u0633\u062a \u0628\u0631\u0627\u06cc \u0647\u0645\u0647 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0645\u0642\u062f\u0627\u0631 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f. \u0627\u06af\u0631 \u0633\u062a\u0648\u0646\u06cc \u0645\u062d\u062f\u0648\u062f\u06cc\u062a NOT NULL<\/strong> \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f\u060c \u0645\u0642\u062f\u0627\u0631 \u0622\u0646 \u0628\u0647\u200c\u0635\u0648\u0631\u062a NULL<\/strong> \u062f\u0631\u062c \u0645\u06cc\u200c\u0634\u0648\u062f:<\/p>\n \u0627\u06af\u0631 \u0628\u0631\u0627\u06cc \u062a\u0645\u0627\u0645 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0645\u0642\u062f\u0627\u0631 \u0648\u0627\u0631\u062f \u0645\u06cc\u200c\u06a9\u0646\u06cc\u062f\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0646\u0627\u0645 \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0631\u0627 \u062d\u0630\u0641 \u06a9\u0646\u06cc\u062f (\u0628\u0647 \u0634\u0631\u0637 \u0631\u0639\u0627\u06cc\u062a \u062a\u0631\u062a\u06cc\u0628 \u062a\u0639\u0631\u06cc\u0641 \u062c\u062f\u0648\u0644):<\/p>\n \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u0627\u0632 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0628\u0647 \u062c\u062f\u0648\u0644 \u062f\u06cc\u06af\u0631 \u0628\u0627 SELECT<\/strong> \u0645\u0646\u062a\u0642\u0644 \u06a9\u0646\u06cc\u062f:<\/p>\n \u0645\u062b\u0627\u0644: \u0633\u0627\u062e\u062a \u062c\u062f\u0648\u0644 \u062c\u062f\u06cc\u062f \u06a9\u067e\u06cc \u062f\u0627\u062f\u0647 \u0627\u0632 \u062c\u062f\u0648\u0644 \u0642\u0628\u0644\u06cc:<\/p>\n \u0647\u0631 \u0628\u0627\u0631 \u0627\u062c\u0631\u0627\u06cc \u0627\u06cc\u0646 \u062f\u0633\u062a\u0648\u0631\u060c \u062f\u0627\u062f\u0647\u200c\u0647\u0627 \u0631\u0627 \u062f\u0648\u0628\u0627\u0631\u0647 \u062f\u0631\u062c \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0627\u0639\u062b \u0627\u06cc\u062c\u0627\u062f \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0634\u0648\u062f.<\/p>\n<\/blockquote>\n \u0628\u0631\u062e\u06cc \u0633\u062a\u0648\u0646\u200c\u0647\u0627 \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u0646\u062f \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u062e\u0648\u062f\u06a9\u0627\u0631 \u0645\u0642\u062f\u0627\u0631\u062f\u0647\u06cc \u0634\u0648\u0646\u062f:<\/p>\n \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0628\u062f\u0648\u0646 \u0645\u0634\u062e\u0635\u200c\u06a9\u0631\u062f\u0646 \u0633\u062a\u0648\u0646\u200c\u0647\u0627\u06cc \u062e\u0648\u062f\u06a9\u0627\u0631:<\/p>\n
\n\u067e\u06cc\u0634\u200c\u0646\u06cc\u0627\u0632\u0647\u0627 (Prerequisites)<\/h2>\n
\n
\n
\n
\n\u0627\u062a\u0635\u0627\u0644 \u0628\u0647 MySQL \u0648 \u0633\u0627\u062e\u062a \u062f\u06cc\u062a\u0627\u0628\u06cc\u0633 \u0646\u0645\u0648\u0646\u0647<\/h2>\n
ssh sammy@your_server_ip
\n<\/code><\/div>\n<\/div>\nsammy<\/code> \u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631 MySQL \u062e\u0648\u062f \u0631\u0627 \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f):<\/p>\nmysql -u sammy -p
\n<\/code><\/div>\n<\/div>\ninsertDB<\/code>:<\/p>\nCREATE<\/span> DATABASE insertDB;
\n<\/code><\/div>\n<\/div>\nQuery<\/span> OK, 1<\/span> row affected (<\/span>0.01<\/span> sec)<\/span>
\n<\/code><\/div>\n<\/div>\nUSE insertDB;
\n<\/code><\/div>\n<\/div>\n
\n\u0633\u0627\u062e\u062a \u062c\u062f\u0648\u0644 \u0646\u0645\u0648\u0646\u0647<\/h2>\n
\n
CREATE TABLE<\/span> factoryEmployees (
\n name varchar<\/span>(30<\/span>),
\n position varchar<\/span>(30<\/span>),
\n department varchar<\/span>(20<\/span>),
\n hourlyWage decimal<\/span>(4<\/span>,2<\/span>),
\n startDate date<\/span>
\n);
\n<\/code><\/div>\n<\/div>\n
\n\u062f\u0631\u062c \u062f\u0633\u062a\u06cc \u062f\u0627\u062f\u0647\u200c\u0647\u0627 (Inserting Data Manually)<\/h2>\n
INSERT INTO<\/span> table_name
\n(column1, column2, ... columnN)
\nVALUES<\/span>
\n(value1, value2, ... valueN);
\n<\/code><\/div>\n<\/div>\nfactoryEmployees<\/code>:<\/p>\nINSERT INTO<\/span> factoryEmployees
\n(name, position, department, hourlyWage, startDate)
\nVALUES<\/span>
\n('Agnes'<\/span>, 'thingamajig foreman'<\/span>, 'management'<\/span>, 26.50<\/span>, '2017-05-01'<\/span>);
\n<\/code><\/div>\n<\/div>\nINSERT INTO<\/span> factoryEmployees
\n(department, hourlyWage, startDate, name, position)
\nVALUES<\/span>
\n('production'<\/span>, 15.59<\/span>, '2018-04-28'<\/span>, 'Jim'<\/span>, 'widget tightener'<\/span>);
\n<\/code><\/div>\n<\/div>\nERROR 1366<\/span> (HY000): Incorrect decimal<\/span> value<\/span>
\n<\/code><\/div>\n<\/div>\n
\n\u062f\u0631\u062c \u0646\u0627\u0642\u0635 \u0633\u062a\u0648\u0646\u200c\u0647\u0627<\/h2>\n
INSERT INTO<\/span> factoryEmployees
\n(name, position, hourlyWage)
\nVALUES<\/span>
\n('Harry'<\/span>, 'whatzit engineer'<\/span>, 26.50<\/span>);
\n<\/code><\/div>\n<\/div>\nINSERT INTO<\/span> factoryEmployees
\nVALUES<\/span>
\n('Marie'<\/span>, 'doodad welder'<\/span>, 'production'<\/span>, 27.88<\/span>, '2018-03-29'<\/span>);
\n<\/code><\/div>\n<\/div>\n
\n\u062f\u0631\u062c \u0686\u0646\u062f \u0631\u062f\u06cc\u0641 \u0628\u0647\u200c\u0635\u0648\u0631\u062a \u0647\u0645\u200c\u0632\u0645\u0627\u0646<\/h2>\n
INSERT INTO<\/span> factoryEmployees
\nVALUES<\/span>
\n('Giles'<\/span>, 'gizmo inspector'<\/span>, 'quality assurance'<\/span>, 26.50<\/span>, '2019-08-06'<\/span>),
\n('Daphne'<\/span>, 'gizmo presser'<\/span>, 'production'<\/span>, 32.45<\/span>, '2017-11-12'<\/span>),
\n('Joan'<\/span>, 'whatzit analyst'<\/span>, 'quality assurance'<\/span>, 29.00<\/span>, '2017-04-29'<\/span>);
\n<\/code><\/div>\n<\/div>\n
\n\u06a9\u067e\u06cc \u062f\u0627\u062f\u0647 \u0628\u0627 SELECT<\/h2>\n
INSERT INTO<\/span> table_A (col_A1, col_A2)
\nSELECT<\/span> col_B1, col_B2
\nFROM<\/span> table_B;
\n<\/code><\/div>\n<\/div>\nshowroomEmployees<\/code>:<\/p>\nCREATE TABLE<\/span> showroomEmployees (
\n name varchar<\/span>(30<\/span>),
\n hourlyWage decimal<\/span>(4<\/span>,2<\/span>),
\n startDate date<\/span>
\n);
\n<\/code><\/div>\n<\/div>\nINSERT INTO<\/span> showroomEmployees
\nSELECT<\/span> name, hourlyWage, startDate
\nFROM<\/span> factoryEmployees
\nWHERE<\/span> name =<\/span> 'Agnes'<\/span>;
\n<\/code><\/div>\n<\/div>\n\n
\n\u062f\u0631\u062c \u062e\u0648\u062f\u06a9\u0627\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627 (AUTO_INCREMENT \u0648 DEFAULT)<\/h2>\n
CREATE TABLE<\/span> interns (
\n internID int<\/span> AUTO_INCREMENT PRIMARY KEY<\/span>,
\n department varchar<\/span>(20<\/span>) DEFAULT<\/span> 'production'<\/span>,
\n name varchar<\/span>(30<\/span>)
\n);
\n<\/code><\/div>\n<\/div>\nINSERT INTO<\/span> interns (name)
\nVALUES<\/span> ('Pierre'<\/span>), (