Breaking News: Grepper is joining You.com. Read the official announcement!

copy column data to another column sql with creating slugs

Mr. Samy answered on May 16, 2022 Popularity 1/10 Helpfulness 9/10

answer copy column data to another column sql with creating slugs

copy column data to another column sql with creating slugs

Comment

## Add New Column then UPDATE Old Table Data to New table with Slug type

## Syntax
ALTER TABLE `tblname` ADD `column_slug` VARCHAR(255) NOT NULL AFTER `column_name`;
UPDATE `tblname` SET `column_slug` = replace(lower(column_name), ' ', '-');

## Example
ALTER TABLE `product` ADD `product_slug` VARCHAR(255) NOT NULL AFTER `productname`;
UPDATE `product` SET `product_slug` = replace(lower(productname), ' ', '-');

Popularity 1/10 Helpfulness 9/10 Language sql

Source: Grepper

Tags: copy sql

Link to this answer
Share Copy Link

Contributed on May 16 2022

Mr. Samy

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

copy column data to another column sql with creating slugs

Contents

More Related Answers

copy column data to another column sql with creating slugs

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.