update stuffset TYPE1 = TYPE2where TYPE1 is null; update stuffset TYPE1 = TYPE2where TYPE1 ='Blank';
Category: Mysql
Select next sequence and update next sequence in mysql
SELECT Auto_increment FROM information_schema.tables WHERE table_name='the_table_you_want'; ALTER TABLE users AUTO_INCREMENT=1000;
Install phpMyAdmin di Ubuntu 20.04
1. Install phpMyAdmin Menggunakan APT Perbarui database repositori: $ sudo apt update Install phpMyAdmin dengan perintah: $ sudo apt -y install phpmyadmin Akan muncul tampilan Configuring phpMyAdmin dengan 2 pilihan yaitu apache2 dan lighttpd. Jangan pilih keduanya karena kita menggunakan Nginx. Tekan TAB pada keyboard untuk mengarahkan ke pilihan OK. Tekan Enter. Kemudian ada pertanyaan Configure database with dbconfig-common. Pilih Yes. Lalu isi password … Continue reading Install phpMyAdmin di Ubuntu 20.04
MySQL Backup and Restore Commands for Database
A simple and easy method for creating MySQL backups is to use the mysqldump command. This command will create a simple .sql file of an existing database, which can then be restored to any other empty MySQL database. This article will work for any Linux distribution running MySQL. 1. Back up the database using the … Continue reading MySQL Backup and Restore Commands for Database
My Note 