#include #include #include #include void main() { int Xs,Ys,Xe,Ye,dx,dy; float X,Y,p; int gd=DETECT,gm ; initgraph(&gd,&gm,”C:\\tc\\bgi”); printf (“Enter the value of (Xs , Xs ) & (Xe , Ye)\n”); scanf (“%d%d%d%d”, &Xs ,&Ys , &Xe , &Ye); dy=Ye-Ys; dx=Xe-Xs; p=(2*dy)-dx; X=Xs; Y=Ys; cleardevice( ); putpixel(X,Y,YELLOW); while(X!=Xe && Y!=Ye) { if(p<1) { X=X+1; p=p+(2*dy); putpixel (X,Y,RED); } … Read more
#include #include #include #include void main() { int r,x,y,p,xc=320,yc=240; int gd=DETECT,gm; initgraph(&gd,&gm,”C:\\TC\\BGI”); cleardevice(); printf(“Enter the radius “); scanf(“%d”,&r); putpixel(xc,yc,YELLOW); x=0; y=r; putpixel(xc+x,yc-y,1); p=3-(2*r); for(x=0;x<=y;x++) { if (p<0) { y=y; p=(p+(4*x)+6); } else { y=y-1; p=p+((4*(x-y)+10)); } putpixel(xc+x,yc-y,1); putpixel(xc-x,yc-y,2); putpixel(xc+x,yc+y,3); putpixel(xc-x,yc+y,4); putpixel(xc+y,yc-x,5); putpixel(xc-y,yc-x,6); putpixel(xc+y,yc+x,7); putpixel(xc-y,yc+x,8); } getch(); closegraph(); }
#include #include #include #include void bezier (int x[4], int y[4]) { int gd = DETECT, gm; int i; double t; initgraph (&gd, &gm, “..\\bgi”); for (t = 0.0; t < 1.0; t += 0.0005) { double xt = pow (1-t, 3) * x[0] + 3 * t * pow (1-t, 2) * x[1] + 3 … Read more
To update records in a table we use update quey Syntax:
1 2 | Update table_name set column name=value, column name=value.. where column= value; |
First select the table data
1 2 3 4 5 6 7 8 9 10 | mysql> select * from student; +----+-------------+-----------+-------+------+ | id | name | address | class | age | +----+-------------+-----------+-------+------+ | 1 | Ram Kumar | New Delhi | 5th | 10 | | 2 | Mohan Kumar | New Delhi | 5th | 10 | | 3 | Sohan Kumar | Bhopal | 5th | NULL | | 4 | Rohan Kumar | NULL | 5th | 11 | +----+-------------+-----------+-------+------+ 4 rows in set (0.00 sec) |
by this query we get a table ‘student’ which we have created in our database as shown above. To update the above table, we use the query:
1 | update student set name='Rohan Pandey' where id=4; |
we can see the updated table
1 2 3 4 5 6 7 8 9 10 | mysql> select * from student; +----+--------------+-----------+-------+------+ | id | name | address | class | age | +----+--------------+-----------+-------+------+ | 1 | Ram Kumar | New Delhi | 5th | 10 | | 2 | Mohan Kumar | New Delhi | 5th | 10 | | 3 | Sohan Kumar | Bhopal | 5th | NULL | | 4 | Rohan Pandey | NULL | 5th | 11 | +----+--------------+-----------+-------+------+ 4 rows in set (0.00 sec) |
If you … Read more
To select all records from a table we use following query Syntax
1 | select * from table_name; |
To select all row of student we use
1 | select * from student; |
It will show following result
1 2 3 4 5 6 7 8 9 10 | mysql> select * from student; +----+-------------+-----------+-------+------+ | id | name | address | class | age | +----+-------------+-----------+-------+------+ | 1 | Ram Kumar | New Delhi | 5th | 10 | | 2 | Mohan Kumar | New Delhi | 5th | 10 | | 3 | Sohan Kumar | Bhopal | 5th | NULL | | 4 | Rohan Kumar | NULL | 5th | 11 | +----+-------------+-----------+-------+------+ 4 rows in set (0.00 sec) |
To select perticular column from table we use
1 | select column1,column2, ..column n from table_name; |
If we want to select id and name of student the we will write
1 | select id,name from student; |
ther is no … Read more
Suppose you have created database, to use it , write query: Syntax
1 | use database_name; |
If we want to select ebhor database then use following query
1 | mysq>use ebhor; |
with the help of this query you can work on your created database.
To create database use following query: Syntax
1 | create database database_name; |
To create a database with name ebhor use following query
1 | mysql>create database ebhor; |
This query will create a new database.
To see all the created databases we use show database query Syntax
1 | show database; |
Example
1 | mysql>show databases; |
It will show all the databases created in mysql.
All c statemtns are written inside main() it is the starting point of execution. To represent start and ent of main() we use curly breces{}. To display text in output window we use printf() Example
1 2 3 4 5 6 | #include<stdio.h> int main() { printf("Hello Everyone!"); return 0; } |
Result
1 | Hello Everyone! |