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

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

Working with Express.js

Image
  Whats in the module :         What is Express.js :   Installing Express.js: To install the expressjs into your app , you have to run - npm install --save express Adding Middleware:   example :       const http = require ( 'http' ); const express = require ( 'express' ); const app = express (); app . use (( req , res , next ) => { console . log ( 'In the middleware!' ); next ();//Allow the request  to continue to the next middleware in line }); app . use (( req , res , next ) => { console . log ( 'In another middleware!' ); }) const server = http . createServer ( app )//app is act As a valid request handler. //listening to a port for request server . listen ( 3000 ); console . log ( 'listening to port 3000' );     Handling Different Routes :                           const express = require ( 'ex...
Read more