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

06/05/2016
47 views
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

MYSQL study Books
- MYSQL Cook Book
http://amzn.to/2sqJcVS

- Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5
http://amzn.to/2sq5Lu4

- MySQL (Developer's Library)
http://amzn.to/2sH9CqK

----------------------------------------------------------------

Blog Post: http://peterfisher.me.uk/how-to-code-well/mysql-console-qa-1-how-to-delete-records-without-knowing-the-field-names/

======== MY COURSES AND BOOKS ========

Docker in Motion: http://bit.ly/2vvz2sA
Skillshare courses: http://skl.sh/2gI33M5
Udemy courses: http://bit.ly/2iGhvIE

======== SUPPORT THE CHANNEL ========

Become a Patron: http://bit.ly/2hmVKwX
Donate: https://www.paypal.me/howToCodeWell
Support the stream: https://streamlabs.com/howtocodewell
Help translate the videos: http://bit.ly/2iEyxXB

======== SUBSCRIBE TO THE NEWSLETTER ========

http://bit.ly/2fPlG3v

======== FOLLOW ME ========

Blog: http://peterfisher.me.uk
Facebook: http://facebook.com/howtocodewell/
Instagram: http://instagram.com/howtocodewell/
Twitter: http://twitter.com/howToCodeWell
Pintrest: http://pinterest.co.uk/howtocodewell/
Twitch: http://twitch.tv/howtocodewell

======== MY TALKS ========

How to put your Docker image on a diet: http://bit.ly/2y5KMly

======== RECOMMENDED PROGRAMMING RESOURCES ========

Microservices in Action: http://bit.ly/2xIi4oh
Get Programming in Javascript: http://bit.ly/2gx2G6A
ES6 in Motion: http://bit.ly/2xJ3i0z
PHP Web Services: APIs for the Modern Web: http://amzn.to/2tqiyOl
Responsive Web Design with HTML5 and CSS3: http://amzn.to/2tSo6nH