Ipctrd (A Computer Learning Blogs)

C Language  What is C ? C is a programming language developed at AT & T’s Bell Laboratories of USA in 1972. It was designed and written by a man named Dennis Ritchie. Syallabus what we are going to discuss in this series:- Getting Started:- The Decision Control Structure:- The Loop Control Structure The Case Control Structure Functions & Pointers Data Types Revisited The C Preprocessor Arrays Puppetting On Strings Structures Console Input/Output File Input/Output More Issues In Input/Output Operations On Bits Miscellaneous Features Getting Started:- What is C 2 Getting Started with C 4 The C Character Set 5 Constants, Variables and Keywords 6 Types of C Constants 7 Rules for Constructing Integer Constants 8 Rules for Constructing Real Constants 9 Rules for Constructing Character Constants 10 Types of C Variables 11 Rules for Constructing Variable Names 11 C Keywords 12 The First C Program 13 Compilation and Execution 19 Receiving Inp...

MySQL Queries:- A list of commonly used MySQL queries to create database, use database, create table, insert record, update record, delete record, select record, truncate table and drop table are given below. 1) MySQL Create Database MySQL create database is used to create database. For example create database db1;  2) MySQL Select/Use Database MySQL use database is used to select database. For example use db1;  Ipctrd Inc. 3) MySQL Create Query MySQL create query is used to create a table, view, procedure and function. For example: CREATE TABLE customers    (id int(10),     name varchar(50),     city varchar(50),   PRIMARY KEY (id )    );    4) MySQL Alter Query MySQL alter query is used to add, modify, delete or drop colums of a table. Let's see a query to add column in customers table: ALTER TABLE customers  ADD age varchar(50);    5) MySQL Insert Query MySQL ins...

MySQL Drop VIEW You can drop the VIEW by using the DROP VIEW statement. Syntax: DROP VIEW [IF EXISTS] view_name;  Parameters: view_name: It specifies the name of the VIEW that you want to drop. IF EXISTS: It is optional. If you do not specify this clause and the VIEW doesn't exist, the DROP VIEW statement will return an error. Example: DROP VIEW trainer; To see the dropped VIEW(It will never found): Syntax: SELECT * FROM view_name;  Return empty*** Subscribe channel on  YouTube Read this post on  Blogger Like page on  Facebook Tweet about video on  twitter Let's chat on  whatsapp See you at  Instagram

MySQL Update VIEW In MYSQL, the ALTER VIEW statement is used to modify or update the already created VIEW without dropping it. Syntax: ALTER VIEW view_name AS  SELECT columns  FROM table  WHERE conditions;  Example: The following example will alter the already created VIEW name "trainer" by adding a new column. ALTER VIEW trainer AS  SELECT course_name, course_trainer, course_id  FROM courses;  To see the altered VIEW: SELECT*FROM trainer; Subscribe channel on  YouTube Read this post on  Blogger Like page on  Facebook Tweet about video on  twitter Let's chat on  whatsapp See you at  Instagram

MySQL Create VIEW A VIEW is created by SELECT statements. SELECT statements are used to take data from the source table to make a VIEW. Syntax: CREATE [OR REPLACE] VIEW view_name AS  SELECT columns  FROM tables  [WHERE conditions];  Parameters: OR REPLACE: It is optional. It is used when a VIEW already exist. If you do not specify this clause and the VIEW already exists, the CREATE VIEW statement will return an error. view_name: It specifies the name of the VIEW that you want to create in MySQL. WHERE conditions: It is also optional. It specifies the conditions that must be met for the records to be included in the VIEW. The following example will create a VIEW name "trainer". This is a virtual table made by taking data from the table "courses". CREATE VIEW trainer AS  SELECT course_name, course_trainer   FROM courses;  To see the created VIEW: Syntax: SELECT * FROM view_name;  Let's see how it looks the created VIEW: S...