M27Lab – Build Your Wordpress Website,Mobile App & Web Application

riseup

How To Find Duplicate Values in MySQL

http://www.mysqltutorial.org/mysql-find-duplicate-values/ SELECT mem_name, COUNT(mem_name) FROM mem_password GROUP BY mem_name HAVING COUNT(mem_name) > 1       ***************************************************************************************************************** compare row number and value form two different table SELECT COUNT(member_info.mem_name) as milon, mess_info.mess_mem_num,mess_info.mess_name FROM member_info INNER join mess_info on mess_info.mess_name=member_info.mess_name GROUP BY member_info.mess_name

Insert – Subquery returns more then 1 row

Insert – Subquery returns more then 1 row Reference: https://www.tek-tips.com/viewthread.cfm?qid=1557007   INSERT INTO mem_password ( `mem_name` , `password`, `hash_password`) SELECT mem_name , ‘No password’,’f8cf7801bd44f47bdf08e4ab122ab5bc’ FROM member_info AS a WHERE NOT EXISTS ( SELECT * FROM mem_password AS b WHERE a.mem_name=b.mem_name ) and a.version=’7.2.2′ and a.mem_role!=’admin’

Reset Firebase Auth Password

FirebaseUser user = FirebaseAuth.getInstance().getCurrentUser(); // Get auth credentials from the user for re-authentication. The example below shows // email and password credentials but there are multiple possible providers, // such as GoogleAuthProvider or FacebookAuthProvider. AuthCredential credential = EmailAuthProvider .getCredential(“user@example.com”, “password1234”); // Prompt the user to re-provide their sign-in credentials user.reauthenticate(credential) .addOnCompleteListener(new OnCompleteListener<Void>() { @Override public …

Reset Firebase Auth Password Read More »

Error: null, Cannot fit requested classes in a single dex file (# methods: 98549 > 65536)

Error: null, Cannot fit requested classes in a single dex file (# methods: 98549 > 65536) Solution: app.gradle file add defaultConfig { applicationId “com.m27lab.messmanager.app” minSdkVersion 16 targetSdkVersion 28 versionCode 15 versionName “7.2.2” multiDexEnabled true testInstrumentationRunner “androidx.test.runner.AndroidJUnitRunner” //vectorDrawables.useSupportLibrary = true }