Advanced SQL Topics

                         Types of MySQL Variables - Local Variables 



finding number of columns a table has : 


SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_name';

Comments

Post a Comment

Popular posts from this blog

preparation analytics

                                                            Preparation Test      date : 28/09/2020    CSS :      1: Explain the CSS “box model” and the layout components that it consists of.             Provide some usage examples.      The CSS box model is a rectangular layout paradigm for HTML elements that consists of the following: Content - The content of the box, where text and images appear Padding - A transparent area surrounding the content (i.e., the amount of space between the border and the content) Border - A border surrounding the padding (if any) and content Margin - A transparent area surrounding the border (i.e., the amount of space between the border and any neighboring elements) Each of t...
Read more

sitemap date format

  Date formating in sitemap.xml file for SEO:     The 'lastmod' element has to be of the format YYYY-MM-DD or YYYY-MM-DDThh:mmTZD so use: gmdate( 'Y-m-d' , strtotime($row[ 'modified' ][ 'value' ])) or gmdate( 'Y-m-d\TH:i:s+00:00' , strtotime($row[ 'modified' ][ 'value' ]))
Read more

SQL SELECT statement

Image
                                                                             SELECT FROM SELECT - FROM - exercise Select the information from the “dept_no” column of the “departments” table. Select all data from the “departments” table.    SELECT - FROM - solution SELECT     dept_no FROM     departments;   SELECT     * FROM     departments;                                                             WHERE clause     It will allow us to set  ...
Read more