Gabriel Darezzo gabrieldarezzo

## twitch.gif

      
              1 file
            
          
              0 forks
            
          
              1 comment
            
          
              0 stars
            
          
                gabrieldarezzo
                / twitch.gif
            
            
              Last active
              September 10, 2019 19:43
            
              
                twitch.tv/gabrieldarezzo
              
          
## Normalization
```sql
CREATE TABLE products (
	product_id INT(11) PRIMARY KEY AUTO_INCREMENT,
	product_desc  VARCHAR(250) NOT NULL UNIQUE,
	imagesrc VARCHAR(250)
);

SELECT
CONCAT('INSERT INTO products (product_id, product_desc) VALUES (', @rownum, ',\'', product_id, '\');') AS sql_stmt,
CONCAT('UPDATE local set product_id = ', @rownum, ' WHERE product_id = \'', product_id, '\';') AS sql_stmt,

## gist:22093faedd4d01a98283896b9083485e
[inlocation_map id="1"]
	```sql
	CREATE TABLE products (
	product_id INT(11) PRIMARY KEY AUTO_INCREMENT,
	product_desc VARCHAR(250) NOT NULL UNIQUE,
	imagesrc VARCHAR(250)
	);

	SELECT
	CONCAT('INSERT INTO products (product_id, product_desc) VALUES (', @rownum, ',\'', product_id, '\');') AS sql_stmt,
	CONCAT('UPDATE local set product_id = ', @rownum, ' WHERE product_id = \'', product_id, '\';') AS sql_stmt,