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

$10-30 USD

En curso

Publicado

hace alrededor de 9 años

$10-30 USD

Pagado a la entrega

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 del proyecto: 7623146

Información sobre el proyecto

10 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

10 freelancers están ofertando un promedio de $24 USD por este trabajo

@Codware

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

$30 USD en 0 día

5,0

(4 comentarios)

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 en 1 día

5,0

(15 comentarios)

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 en 1 día

5,0

(4 comentarios)

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 en 0 día

5,0

(2 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 7 días

0,0

(0 comentarios)

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 en 1 día

0,0

(0 comentarios)

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 en 1 día