This method let you purge a table completely and also let the primary key start with one or from whatever digit you want. We all have gone through the pain of not getting the primary key back to one once the data (rows) from the table is deleted. Deleting all the rows from atable wont … Continue reading Resetting Auto Increment
Tag: sql queries
Sql Queries
SQL is a standard language for storing, manipulating and retrieving data in databases. Create a new user: CREATE USER 'hokageKvT'@'localhost' IDENTIFIED BY 'hokageKvT'; GRANT ALL PRIVILEGES ON * . * TO 'hokageKvT'@'localhost'; # # Starting with MySQL 8.0.4, the MySQL team changed the # default authentication plugin for MySQL server # from mysql_native_password to caching_sha2_password. … Continue reading Sql Queries
KvT Tech 