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 ... -
https://github.com/boto/boto3/issues/134 import boto3 import botocore client = boto3.client('s3') result = client.list_obje...
-
There are some fun tools on Mac/PC which can help you on your studies, life and research. 1. Evernote: https://evernote.com/ To downl...
No comments:
Post a Comment