Need SQL script that deletes all values from a column and replaces them with unique random characters, numbers and symbols.

$10-30 USD

진행 중

게시됨

거의 9년 전

$10-30 USD

제출할때 지불됩니다

Need a SQL script that deletes all values from the password column values and replaces them with unique random characters, numbers and symbols that are at least 8 characters in length. For example: IF the value is: Yellow 20, then change it to something random like: RkW2587! Some existing passwords are the same for several users so I need the passwords to all be different. I need this by 8AM pacific time. (0800) Do this correctly and I will give you another project, which involves sending the new passwords to the users. See attached file.

Database Administration

Database Development

Database Programming

SQL

프로젝트 ID: 7623146

프로젝트 정보

10 제안서

원격근무 프로젝트

활동 중 9년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

10 이 프로젝트에 프리랜서들의 평균 입찰은 $24 USD입니다.

@Codware

I'm very experienced with mysql (and mssql) databases. I'm sure I can help you with this, really fast!

$30 USD 0일에

5.0

(4 건의 리뷰)

3.8

@nitinbohra89

Having 4 years of experience in oracle MYSQL database. Have vast knowledge of Database programming and designing. Currently working in Oracle Corporation.

$20 USD 1일에

5.0

(15 건의 리뷰)

4.0

@webstopindia

Hello, I am ready to start the task right now. I will need the mysql table for this. You can pay me once the job is done to your satisfaction. According to the text file attached, I will not change the passwords with "Disabled" and "x" on them. Need to discuss a bit more about it. Thanks and Regards, Soumik.

$25 USD 1일에

5.0

(4 건의 리뷰)

2.6

@arbocomve

I can do it right now, in fact, I have the solution to your requirement already done. Contact me and we can talk about your other requirement too. I only need to know the table name, column name, and how many records it will update. Also which version of SQL are you using? SQL Server?

$25 USD 0일에

5.0

(2 건의 리뷰)

0.6

@Valorez

I always deliver, and with 16 years of high-end development around the world, I can do this within a day for sure. :)

$30 USD 1일에

0.0

(0 건의 리뷰)

0.0

@Jigar120

I have experience of working with millions of data. As I am new to freelancing I don't have any ratings. I will appreciate if you consider me suitable for your project.

$10 USD 7일에

0.0

(0 건의 리뷰)

0.0

@SamirCOX4

Hi, I have the script generated and tested P.S. You say in the txt file "The only ones that wont be changed are passwords labeled Disabled or have an X" but have the WHERE writen as "WHERE userpw <> 'DISABLED' and rpt = 'x'" Can i asume that this was a mistake frome youre side and the WHERE should be "WHERE userpw <> 'DISABLED' OR rpt <> 'x'" (The difference is OR instead of AND and <> instead of =)

$25 USD 1일에

0.0

(0 건의 리뷰)

0.0

@SaumyaVerma

I'm a database developer working for Oracle. I handle all database related activities. Writing script for cleaning up customer's data to remove orphan records, clean business logic etc is my forte.

$20 USD 1일에