Changes between Version 5 and Version 6 of GROUPReplicate2

Timestamp:

06/14/22 09:47:21 (2 years ago)

Author:

krit

Comment:

--

GROUPReplicate2

@@ -86 +86 @@
 Query OK, 1 row affected (0.01 sec)
 }}}
+
+    Or we can create auto increment key
+{{{
+mysql> CREATE TABLE products (
+  product_id int(11) NOT NULL AUTO_INCREMENT,
+  product_name varchar(150) NOT NULL,
+  PRIMARY KEY (`product_id`)
+);
+
+mysql> INSERT INTO products(product_name) VALUES("Shoes"),("Shirt"),("Trouser");
+}}}