Member-only story
3 MySQL Commands Developers should know.
If you are a developer working in a MySQL environment, this blog post is for you. I share 3 MySQL commands or statements that you should know. That is a bold statement, I know. Turns out, once you do know (of) these commands, you will use them all the time. They minimize guesswork which leads to better productivity in other facets of your programming and querying workflow. I use them myself almost daily and am sure you will too once you see how simple they are to use. So why should you know them? Continue reading and find out…
OS, Software, and DB used:
- OpenSuse Leap 15.1
- MySQL 8.0.20
Self-Promotion:
If you enjoy the content written here, by all means, share this blog and your favorite post(s) with others who may benefit from or like it as well. Since coffee is my favorite drink, you can even buy me one if you would like!
Note: these commands/statements are listed in no particular order.
DESC table_name
If for no other reason than knowing the names of which columns to query and their respective datatypes, you must know DESC table_name.
What columns and their respective datatypes are in the ‘actor’ table? Use DESC for this information:
