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

SQL INSERT statement

Image
                                                    The INSERT statement - Part I Example :          use employees; SELECT     * FROM     employees LIMIT 10; #insert data insert into employees(     emp_no,     birth_date,     first_name,     last_name,     gender,     hire_date ) values(     999901,     '1999-10-10',     'John',     'wick',     'M',     '2020-08-31'     );     SELECT     * FROM     employees WHERE     emp_no = 999901;                       ...
Read more

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

Stored routines

                                                  Stored routines/procedures   Stored procedures - Example - Part II - exercise Create a procedure that will provide the average salary of all employees. Then, call the procedure.      Stored procedures - Example - Part II - solution DELIMITER $$ CREATE PROCEDURE avg_salary() BEGIN                 SELECT                                 AVG(salary)                 FROM             ...
Read more