Insert into zzzzsys_user from another table

miasoft · Unread post by **miasoft** » Sat Apr 10, 2021 6:47 am

I have several hundred records in client table (from my prev desktop program).I would like to add these entries in zzzzsys_user. Only some fields:
login, password, department. How can I do it programatically (not manual)? Is it possible?

Unread post by **kev1n** » Sat Apr 10, 2021 7:12 am

Does this help ? https://forums.nubuilder.cloud/viewtopic. ... 700#p23700

Unread post by **kev1n** » Sat Apr 10, 2021 9:22 pm

You could also import a csv file with phpMyAdmin and create a trigger to generate a unique primary key and md5 hash the password, e.g. like

Code: Select all

CREATE TRIGGER insert_user 
BEFORE INSERT ON zzzzsys_user 
FOR EACH ROW SET 
NEW.zzzzsys_user_id = Left(Replace(UUID(),'-',''),25), 
NEW.sus_login_password = MD5(NEW.sus_login_password)

After the import, the trigger should be removed again so that there are no problems when users are created manually.

miasoft · Unread post by **miasoft** » Sun Apr 11, 2021 8:47 am

Thanks! The trigger works fine!

nuBuilder Forum

Insert into zzzzsys_user from another table

Insert into zzzzsys_user from another table

Re: Insert into zzzzsys_user from another table

Re: Insert into zzzzsys_user from another table

Re: Insert into zzzzsys_user from another table