There are different methods to list out user defined tables in MySQL. We will see two methods in this post.
Let us create the following tables in the database named Test
MySQL – Generate Script for a Table Using SQL
SQL Server needs SSMS to build a CREATE TABLE script, but MySQL can do it in SQL. Here is how SHOW CREATE TABLE returns the script for a table.
Connect to MySQL From the Command Prompt: Host, Port, User
To connect to MySQL from the command prompt, you pass a host, a port, a user and a password to the mysql client. This post runs every switch, then shows the exact error that a wrong port, user, password or database produces.
MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET
FIND_IN_SET searches a comma-separated string for a complete member and returns its position. I keep whitespace in that string deliberate.
SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer
Can you retrieve the last inserted rows from a table with no identity or date column? Here is my chat with Dustin on a question with no good answer.
MySQL – Pattern Matching Comparison Using Regular Expressions with REGEXP
MySQL supports pattern matching using regular expressions with REGEXP. I show how to use ^, $, | and square brackets to match values in a table.
MySQL – How to do Straight Join in MySQL?
How does a straight join in MySQL work? STRAIGHT_JOIN is like an INNER JOIN but always reads the left table first. Here is a simple items and sales example.