How to delete all row data in mysql?

Discuss
#1

I want to clear/delete all the data from my table , but not the title of my data.Screenshot_3
I want to delete the Red marked Data only. From user app

#2

Use SQL Delete command.

https://www.w3schools.com/sql/sql_delete.asp

#3

i try to find command , but i dint get in internet

#4

Go to the Sql tab( in phpmyadmin) run one of the below query:

Delete from yourtable

#5

DELETE FROM table_leadr WHERE img; wrong sql error

my table name is = leadr

#6

Where is wrong.
Where img = "something " .

#7

img is the column data only i want to delete

i am trying to use this code…
DELETE FROM table_name WHERE condition ;

#8

Where fieldname = “something”

#9

but if i use some thing it will not delete the entire column. i think

#10

To delete everything, you don’t need where.
“something” is a example

#11

when i use this

DELETE FROM leadr WHERE di=2;
it delete just 1 row

#12

of course yes. there is only one id = 2

#13

if i have 1000 id how i will do that thing so i want to do that in one click

#14

I already answered above.

#15

this one
DELETE FROM leadr WHERE di=2; if i remove where
DELETE FROM leadr di=2;
it will get errror

#16

One more time you didn’t read my answer.

Screenshot_20210419-072655
Screenshot_20210419-072655720Ă—1512 70.2 KB

1 Like
#17

But i dont want to delete my entire table.

#18

No ?

Screenshot_20210419-073258
Screenshot_20210419-073258720Ă—1512 146 KB

#19

But title will be delete
Example my …
di
img

#20

No . There are no titles. They are field names
You need to study the database.

1 Like