Tutorials and web chats for the How To Code Well Youtube channel
How To Code Well Tutorials and Web Chats
MYSQL Console Q&A #1 How to delete records without knowing the field headers
1 liked this
In the first MYSQL Console Questions and Answer episode we take a look at a question from Praveen Kadam.
Praveen Kadam asks:
"I am using mysql 5.5.
I want to delete data from the table. And I want to insert new data in the table. But I dont know the column headers.
I also want yo change the type from double to decimal.
Please help me out."
This MYSQL Q&A covers 2 examples:
- How to delete records using the delete query
- How to truncate records
- The difference between delete and truncate