Tuesday, April 7, 2015

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database university;
Query OK, 1 row affected (0.03 sec)

mysql> create table department(id int,name varchar(30));
ERROR 1046 (3D000): No database selected
mysql> use university;
Database changed
mysql> create table department(id int,name varchar(30));
Query OK, 0 rows affected (0.33 sec)

mysql> create table student(id int,code varchar(8),fname varchar(30),lname varch
ar(30),phone int,email varchar(30),int depid);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'int d
epid)' at line 1
mysql> create table student(id int,code varchar(8),fname varchar(30),lname varch
ar(30),phone int,email varchar(30),depid int);
Query OK, 0 rows affected (0.35 sec)

mysql> show tables;
+----------------------+
| Tables_in_university |
+----------------------+
| department           |
| student              |
+----------------------+
2 rows in set (0.00 sec)

mysql> alter table department add primary key(id);
Query OK, 0 rows affected (0.65 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> create table lesson(id int,name varchar(30));
Query OK, 0 rows affected (0.28 sec)

mysql> alter table lesson add primary key(id);
Query OK, 0 rows affected (0.66 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table student add primary key(id);
Query OK, 0 rows affected (0.67 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table student add foreign key(depid) references department(id);
Query OK, 0 rows affected (0.74 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table lesson add foreign key(depid) references department(id);
ERROR 1072 (42000): Key column 'depid' doesn't exist in table
mysql> alter table lesson alter column credit int;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'int'
at line 1
mysql> alter table lesson add credit int;
Query OK, 0 rows affected (0.63 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table lesson add depid int;
Query OK, 0 rows affected (0.47 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> alter table lesson add foreign key(depid) references department(id);
Query OK, 0 rows affected (0.68 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> insert into department values(1,"Computer science");
Query OK, 1 row affected (0.07 sec)

mysql> insert into department values(2,"Information Technology");
Query OK, 1 row affected (0.05 sec)

mysql> insert into department values(3,"Multimedia");
Query OK, 1 row affected (0.04 sec)

mysql> insert into department values(4,"Internet Business");
Query OK, 1 row affected (0.06 sec)

mysql> insert into department values(5,"Electronic Engineering");
Query OK, 1 row affected (0.06 sec)

mysql> insert into department values(6,"Medical Engineering");
Query OK, 1 row affected (0.05 sec)

mysql> insert into student values(1,IC11D001,"bat","dorj",99898989,"bat@yahoo.co
m",1);
ERROR 1054 (42S22): Unknown column 'IC11D001' in 'field list'
mysql> insert into student values(1,'IC11D001','bat','dorj',99898989,'bat@yahoo.
com',1);
Query OK, 1 row affected (0.07 sec)

mysql> insert into student values(1,'IC11D001','bat','dorj',99898989,'bat@yahoo.
com',1);
Posted by at No comments:

Friday, April 3, 2015

domain name


Posted by at No comments:

Tuesday, March 31, 2015

Tom.and.Jerry.The.Lost.Dragon.2014.DVDRip.AC3.x264.Multi.-tomcat12[ETRG].part1.rarТатах
Tom.and.Jerry.The.Lost.Dragon.2014.DVDRip.AC3.x264.Multi.-tomcat12[ETRG].part2.rarТатах
Tom.and.Jerry.The.Lost.Dragon.2014.DVDRip.AC3.x264.Multi.-tomcat12[ETRG].part3.rarТатах

Posted by at No comments:

Wednesday, March 11, 2015

Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015

Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part13.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part01.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part02.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part03.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part04.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part05.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part06.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part07.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part08.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part09.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part10.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part11.rarТатах
Windows 7 Ultimate SP1 x86+x64 OEM PreActivated 02.2015_.part12.rarТатах
Posted by at No comments:

Thursday, March 5, 2015

Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015

Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part01.rarТатах
Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part02.rarТатах
Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part03.rarТатах
Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part04.rarТатах
Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part05.rarТатах
Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part06.rarТатах
Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part07.rarТатах
Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part08.rarТатах
Windows 7 SP1 Ultimate AIO 18in1 ESD OEM da-DK Feb 2015.part09.rarТатах
Posted by at No comments:

Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015

Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part01.rarТатах
Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part02.rarТатах
Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part03.rarТатах
Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part04.rarТатах
Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part05.rarТатах
Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part06.rarТатах
Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part07.rarТатах
Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part08.rarТатах
Windows 8.1 Pro VL X64 with Update Dec15 ESD OEM en-US Feb 2015.part09.rarТатах
Posted by at No comments:

Tuesday, December 9, 2014

datacom











Posted by at No comments:

Wednesday, November 19, 2014

loop

/* Task 1

****
***
**
*


#include<stdio.h>

int main()
{
int i, j;

for (i = 4; i >= 0; i--)
{
for (j = i; j>0; j--)
{
printf("*");
}
printf("\n");
}
}

*/

/* Task 2

*
**
***
****

#include<stdio.h>

int main()
{
int i, j;

for (i = 0; i <= 4; i++)
{
for (j = 0; j<i; j++)
{
printf("*");
}
printf("\n");
}
}

*/

/* Task 3

   *
  * *  
 * * *
* * * *

#include<stdio.h>

int main()
{
int i, j, k;

for (i = 0; i <= 4; i++)
{
for (k = 1; k <= 4 - i; k++)
{
printf(" ");
}
for (j = 0; j<i; j++)
{
printf(" *");
}
printf("\n");
}
}

*/

/* Task 4

* * * *
 * * *
  * *
   *

#include<stdio.h>

int main()
{
int i, j, k;

for (i = 4; i >= 0; i--)
{
for (j = 0; j<i; j++)
{
printf(" *");
}
printf("\n");
for (k = 0; k <= 4 - i; k++)
{
printf(" ");
}
}
}
*/

/* Task 5

   *
  * *
 * * *
* * * * 
 * * *
  * *
   *


#include<stdio.h>

int main()
{
int  i, j, k;

for (i = 0; i <= 4; i++)
{
for (int j = 1; j <= 4 - i; j++)
{
printf(" ");
}
for (int j = 0; j<i; j++)
{
printf(" *");
}
printf("\n");
}

for (i = 2; i >= 0; i--)
{
for (k = 2 - i; k >= 0; k--)
{
printf(" ");
}
for (j = i; j >= 0; j--)
{
printf(" *");
}
printf("\n");
}

}

*/
Posted by at No comments:

Thursday, October 30, 2014

[R.G. Mechanics] FINAL FANTASY XIII.part094.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part001.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part002.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part003.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part004.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part005.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part006.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part007.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part008.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part009.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part010.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part011.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part012.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part013.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part014.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part015.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part016.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part017.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part018.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part019.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part020.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part021.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part022.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part023.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part024.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part025.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part026.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part027.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part028.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part029.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part030.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part031.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part032.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part033.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part034.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part035.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part036.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part037.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part038.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part039.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part040.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part041.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part042.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part043.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part044.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part045.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part046.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part047.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part048.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part049.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part050.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part051.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part052.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part053.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part054.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part055.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part056.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part057.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part058.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part059.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part060.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part061.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part062.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part063.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part064.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part065.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part066.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part067.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part068.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part069.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part070.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part071.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part072.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part073.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part074.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part075.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part076.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part077.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part078.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part079.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part080.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part081.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part082.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part083.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part084.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part085.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part086.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part087.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part088.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part089.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part090.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part091.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part092.rarТатах[R.G. Mechanics] FINAL FANTASY XIII.part093.rarТатах

Posted by at No comments:

Friday, October 17, 2014

Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.17 MySQL Community Server (GPL)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database 2014_10_17;
Query OK, 1 row affected (0.08 sec)

mysql> use 2014_10_17;
Database changed
mysql> create table
    -> (
    -> ID varchar(8),
    -> Department varchar(2),
    -> Class int
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(
ID varchar(8),
Department varchar(2),
Class int
)' at line 2
mysql> create table(ID varchar(8),Department varchar(2),Class int);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '(ID v
archar(8),Department varchar(2),Class int)' at line 1
mysql> clear
mysql> use 2014_10_17;
Database changed
mysql> create table oyutan
    -> (
    -> ID varchar(8),
    -> Department varchar(2),
    -> Class int
    -> Class int
    ->
    ->
    ->
    ->
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'Class
 int




)' at line 6
mysql> use 2014_10_17;
Database changed
mysql> create table oyutan
    -> (
    -> ID varchar(8),
    -> Department varchar(2),
    -> Class int,
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near '' at
line 5
mysql> delete table oyutan;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'table
 oyutan' at line 1
mysql> use 2014_10_17;
Database changed
mysql> create table oyutan
    -> (
    -> ID varchar(8),
    -> Name varchar(35),
    -> Department varchar(2),
    -> Class int
    -> );
Query OK, 0 rows affected (0.50 sec)

mysql> create table hicheel
    -> (
    -> ID int,
    -> Name varchar(30),
    -> Credit int
    -> );
Query OK, 0 rows affected (0.31 sec)

mysql> create table hicheelsongolt
    -> (
    -> SID varchar(8),
    -> CID int
    -> );
Query OK, 0 rows affected (0.41 sec)

mysql> insert into oyutan values('CS11D002','Bat','CS','2');
Query OK, 1 row affected (0.06 sec)

mysql>
Posted by at No comments:
Subscribe to: Posts (Atom)