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

SQL Joins

Image
JOIN more than two tables in SQL                                                                              SQL Joins   Intro to JOINs - exercise 1 If you currently have the ‘departments_dup’ table set up , use DROP COLUMN to remove the ‘dept_manager’ column from the ‘departments_dup’ table. Then, use CHANGE COLUMN to change the ‘dept_no’ and ‘dept_name’ columns to NULL. ( If you don’t currently have the ‘departments_dup’ table set up , create it. Let it contain two columns: dept_no and dept_name . Let the data type of dept_no be CHAR of 4, and the data type of dept_name be VARCHAR of 40. Both columns are allowed to have null values. Finally, insert the information contained in ‘departments’ into ‘departments_dup’.) Then, insert a record...
Read more