Delete the duplicated rows in a single line without creating new table.
ALTER IGNORE TABLE table1 ADD UNIQUE INDEX (name1,gender);
Subscribe to:
Post Comments (Atom)
-
I tried to commit script to bitbucket using sourcetree. I first cloned from bitbucket using SSH, and I got an error, "authentication ... -
Previously, I wanted to install "script" on Atom to run PHP. And there was some problem, like the firewall. So I tried atom-runner... -
https://github.com/boto/boto3/issues/134 import boto3 import botocore client = boto3.client('s3') result = client.list_obje...
No comments:
Post a Comment