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
SQL SERVER – How to Detect Schema Change Across Two Servers
If you are database developer or database administrator, you will absolutely feel the story. You can download the software discussed in this blog post to play it along. Story of My Early Career A very interesting scenario, I have encountered in my earlier career. In earlier days, we used to…
Read MoreSQL SERVER – Q and A from Facebook Page
Social media has changed everything, there were times when we used to send emails but nowadays things have changed. We all have many different ways to connect with each other. Here are a few questions which I have received on the Facebook Page in the month of the march and…
Read MoreSQL SERVER – SQL Server 2014 Developer Training Kit and Sample Databases
SQL Server 2014 RTM is around the corner (2014). There is plenty of the interest in the SQL Server 2014 in recent time. One of the most frequently asked questions is about learning resources of SQL Server 2014. Everybody wants to learn SQL Server 2014 but there is not enough…
Read MoreMySQL – Generate Script for a Table Using SQL
In SQL Server, to generate the CREATE TABLE script for a table, you need to rely on the SQL Server Management Studio (SSMS) tool and there is no inbuilt function supported to do this using SQL. However, in MySQL you can generate the script for a table using SQL. Let…
Read MoreSQLAuthority News – Sign up for SQL Authority Low Frequency Newsletter
One More Newsletter! You might already be receiving our emails in your mailbox, so why should you sign up for SQL Authority Newsletter (Sign-up). Well, a great question. Let me answer this first. Why should you sign up? First of all – it is not going to be a daily…
Read MoreSQL SERVER – SSIS Execution Control Using Precedence Constraints – Notes from the Field #021
[Notes from Pinal]: Lots of people think that SSIS is all about arranging various operations together in one logical flow. Well, the understanding is absolutely correct, but the implementation of the same is not as easy as it seems. Lots of people start with lots of enthusiasm, but when it…
Read More