I need to replace the pattern: \(d+, to (. How can I do that?
Because when I exported db I need to remove the id column which is auto increment.
INSERT INTO `users` VALUES (22,'[email protected]
(22, should be replace to (NULL,
You can try below,
sed "s/([0-9]*,/(NULL,/" [file name]
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
1 year ago