Horje

Tips (Total 3)


# Tips-1) How to delete row id from 1 to 1000 in PHPmyAdmin

Here is steps.

Step-1: Login to Cpanel

First, Login to Your Cpanel

Output should be:

Step-2: Click on phpMYadmin

Second, Click on "phpMYAdmin" from Database

Output should be:

Step-3: Select a Database

Now, Select a Database from leftside menu is listed.

Output should be:

Step-4: Finally Run Code

Finally, Click on "SQL" Copy and Paste Following Code then Click on "Go" Button.

 

DELETE from code WHERE id BETWEEN 1 AND 1000;

Output should be:

Step-5: Confirm

Now, Click on "Ok" Button if you want to run to delete.

Output should be:


# Tips-2) How to delete all Duplicate Rows except for One in MySQL

Editor warning: This solution is computationally inefficient and may bring down your connection for a large table.

NB - You need to do this first on a test copy of your table!

When I did it, I found that unless I also included AND n1.id <> n2.id, it deleted every row in the table.

Step-1: Login to Cpanel

First, Login to Your Cpanel

Output should be:

Step-2: Click on phpMYadmin

Second, Click on "phpMYAdmin" from Database

Output should be:

Step-3: Select a Database

Output should be:

Step-4: Finally Run Code

If you want to keep the row with the lowest id value:

DELETE n1 FROM table_name n1, table_name n2 WHERE n1.id > n2.id AND n1.name = n2.name

Output should be:


# Tips-3) How to remove everything after a string by PHPmyadmin

Step-1: Login to Cpanel

First, Login to Your Cpanel

Output should be:

Step-2: Click on phpMYadmin

Second, Click on "phpMYAdmin" from Database

Output should be:

 

Step-3: Select a Database

Output should be:

Finally

Click on SQL and copy paste following codes and Run it.

Change the table name and Column Name according to you sql

UPDATE Your_Table_Name SET Column_Name = SUBSTRING_INDEX(Column Name, '<quter>', -1);
Look <quter> , All Strings will Remove <quter> and after <quter>.
Original: WWE Raw <quter> New Game
Replace: WWE Raw
index.txt
Example: MYSQL
UPDATE script1 SET name = SUBSTRING_INDEX(name, ' by ', -1); 

Output should be: