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Татах
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>
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>
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>
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>
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>
Thursday, October 9, 2014
Friday, October 3, 2014
33
5 | 2012-12-06 | 3 | undaa |
| 6 | pepsi-500ml | 3 | 750 | 300 | 6 |
5 | 2012-12-06 | 1 | gurilan bvt |
| 6 | pepsi-500ml | 3 | 750 | 300 | 6 |
5 | 2012-12-06 | 2 | zairmag |
| 6 | pepsi-500ml | 3 | 750 | 300 | 6 |
5 | 2012-12-06 | 3 | undaa |
| 7 | cocacola-330ml | 3 | 100 | 500 | 6 |
5 | 2012-12-06 | 1 | gurilan bvt |
| 7 | cocacola-330ml | 3 | 100 | 500 | 6 |
5 | 2012-12-06 | 2 | zairmag |
| 7 | cocacola-330ml | 3 | 100 | 500 | 6 |
5 | 2012-12-06 | 3 | undaa |
| 1 | atar talh | 1 | 650 | 100 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 1 | atar talh | 1 | 650 | 100 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 1 | atar talh | 1 | 650 | 100 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 2 | zuiwan chex | 1 | 830 | 100 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 2 | zuiwan chex | 1 | 830 | 100 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 2 | zuiwan chex | 1 | 830 | 100 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 6 | pepsi-500ml | 3 | 750 | 300 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 6 | pepsi-500ml | 3 | 750 | 300 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 6 | pepsi-500ml | 3 | 750 | 300 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 7 | cocacola-330ml | 3 | 100 | 500 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 7 | cocacola-330ml | 3 | 100 | 500 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 7 | cocacola-330ml | 3 | 100 | 500 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 1 | atar talh | 1 | 650 | 100 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 1 | atar talh | 1 | 650 | 100 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 1 | atar talh | 1 | 650 | 100 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 1 | atar talh | 1 | 650 | 100 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 1 | atar talh | 1 | 650 | 100 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 1 | atar talh | 1 | 650 | 100 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
1 | 2012-12-05 | 3 | undaa |
+------+-----------------------------+------+------------+-------+----------+---
----+------------+------+-------------+
168 rows in set (0.00 sec)
mysql> select * from baraa;
+------+-----------------------------+------+------------+-------+
| DD | Name | Type | Unit_Price | Piece |
+------+-----------------------------+------+------------+-------+
| 1 | atar talh | 1 | 650 | 100 |
| 2 | zuiwan chex | 1 | 830 | 100 |
| 3 | ogooj-eeven | 1 | 2200 | 25 |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 |
| 6 | pepsi-500ml | 3 | 750 | 300 |
| 7 | cocacola-330ml | 3 | 100 | 500 |
+------+-----------------------------+------+------------+-------+
7 rows in set (0.00 sec)
mysql> select * from trade;
+----------+-------+------------+
| Baraa_DD | Piece | Ognoo |
+----------+-------+------------+
| 1 | 3 | 2012-11-30 |
| 2 | 3 | 2012-12-03 |
| 1 | 1 | 2012-12-04 |
| 4 | 10 | 2012-12-05 |
| 6 | 5 | 2012-12-06 |
| 3 | 6 | 2012-12-06 |
| 5 | 12 | 2012-12-05 |
| 5 | 1 | 2012-12-05 |
+----------+-------+------------+
8 rows in set (0.00 sec)
mysql> select * from type;
+------+-------------+
| ID | Name |
+------+-------------+
| 1 | gurilan bvt |
| 2 | zairmag |
| 3 | undaa |
+------+-------------+
3 rows in set (0.00 sec)
mysql> alter table type add primary key(ID);
Query OK, 3 rows affected (0.82 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> alter table baraa add foreign key(Type) references type(ID);
Query OK, 7 rows affected (8.26 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> alter table trade add foreign key(Baraa_DD) references type(ID);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint f
ails (`supermarket`.`#sql-1374_1`, CONSTRAINT `#sql-1374_1_ibfk_1` FOREIGN KEY (
`Baraa_DD`) REFERENCES `type` (`ID`))
mysql> alter table baraa add primary key(DD);
Query OK, 7 rows affected (0.88 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> alter table trade add foreign key(Baraa_DD) references baraa(DD);
Query OK, 8 rows affected (0.78 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql> select * from baraa where Unit_Price>300;
+----+-------------+------+------------+-------+
| DD | Name | Type | Unit_Price | Piece |
+----+-------------+------+------------+-------+
| 1 | atar talh | 1 | 650 | 100 |
| 2 | zuiwan chex | 1 | 830 | 100 |
| 3 | ogooj-eeven | 1 | 2200 | 25 |
| 6 | pepsi-500ml | 3 | 750 | 300 |
+----+-------------+------+------------+-------+
4 rows in set (0.00 sec)
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
.DD where Piece>5;
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 'where
Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
.DD and where Piece>5;
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 'where
Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
.DD;
ERROR 1054 (42S22): Unknown column 'trade.Baraa.DD' in 'where clause'
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD and where Piece>5;
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 'where
Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD where trade.Piece>5;
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 'where
trade.Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD;
+-----------------------------+-------+
| Name | Piece |
+-----------------------------+-------+
| atar talh | 3 |
| atar talh | 1 |
| zuiwan chex | 3 |
| ogooj-eeven | 6 |
| alyaska zairmag-shokolodtai | 10 |
| alyaska zairmag-tsotsgiitei | 12 |
| alyaska zairmag-tsotsgiitei | 1 |
| pepsi-500ml | 5 |
+-----------------------------+-------+
8 rows in set (0.00 sec)
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD where trade.Piece>5;
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 'where
trade.Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD and trade.Piece>5;
+-----------------------------+-------+
| Name | Piece |
+-----------------------------+-------+
| ogooj-eeven | 6 |
| alyaska zairmag-shokolodtai | 10 |
| alyaska zairmag-tsotsgiitei | 12 |
+-----------------------------+-------+
3 rows in set (0.00 sec)
mysql> select sum(Piece) from trade;
+------------+
| sum(Piece) |
+------------+
| 41 |
+------------+
1 row in set (0.00 sec)
mysql> select sum(Piece) from baraa;
+------------+
| sum(Piece) |
+------------+
| 1475 |
+------------+
1 row in set (0.00 sec)
mysql> select * from baraa where trade>'2012.12.03';
ERROR 1054 (42S22): Unknown column 'trade' in 'where clause'
mysql> select * from trade where ognoo>'2012.12.03';
+----------+-------+------------+
| Baraa_DD | Piece | Ognoo |
+----------+-------+------------+
| 1 | 1 | 2012-12-04 |
| 4 | 10 | 2012-12-05 |
| 6 | 5 | 2012-12-06 |
| 3 | 6 | 2012-12-06 |
| 5 | 12 | 2012-12-05 |
| 5 | 1 | 2012-12-05 |
+----------+-------+------------+
6 rows in set (0.00 sec)
mysql>
| 6 | pepsi-500ml | 3 | 750 | 300 | 6 |
5 | 2012-12-06 | 1 | gurilan bvt |
| 6 | pepsi-500ml | 3 | 750 | 300 | 6 |
5 | 2012-12-06 | 2 | zairmag |
| 6 | pepsi-500ml | 3 | 750 | 300 | 6 |
5 | 2012-12-06 | 3 | undaa |
| 7 | cocacola-330ml | 3 | 100 | 500 | 6 |
5 | 2012-12-06 | 1 | gurilan bvt |
| 7 | cocacola-330ml | 3 | 100 | 500 | 6 |
5 | 2012-12-06 | 2 | zairmag |
| 7 | cocacola-330ml | 3 | 100 | 500 | 6 |
5 | 2012-12-06 | 3 | undaa |
| 1 | atar talh | 1 | 650 | 100 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 1 | atar talh | 1 | 650 | 100 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 1 | atar talh | 1 | 650 | 100 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 2 | zuiwan chex | 1 | 830 | 100 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 2 | zuiwan chex | 1 | 830 | 100 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 2 | zuiwan chex | 1 | 830 | 100 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 6 | pepsi-500ml | 3 | 750 | 300 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 6 | pepsi-500ml | 3 | 750 | 300 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 6 | pepsi-500ml | 3 | 750 | 300 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 7 | cocacola-330ml | 3 | 100 | 500 | 3 |
6 | 2012-12-06 | 1 | gurilan bvt |
| 7 | cocacola-330ml | 3 | 100 | 500 | 3 |
6 | 2012-12-06 | 2 | zairmag |
| 7 | cocacola-330ml | 3 | 100 | 500 | 3 |
6 | 2012-12-06 | 3 | undaa |
| 1 | atar talh | 1 | 650 | 100 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 1 | atar talh | 1 | 650 | 100 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 1 | atar talh | 1 | 650 | 100 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
12 | 2012-12-05 | 1 | gurilan bvt |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
12 | 2012-12-05 | 2 | zairmag |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
12 | 2012-12-05 | 3 | undaa |
| 1 | atar talh | 1 | 650 | 100 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 1 | atar talh | 1 | 650 | 100 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 1 | atar talh | 1 | 650 | 100 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 2 | zuiwan chex | 1 | 830 | 100 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 3 | ogooj-eeven | 1 | 2200 | 25 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 6 | pepsi-500ml | 3 | 750 | 300 | 5 |
1 | 2012-12-05 | 3 | undaa |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
1 | 2012-12-05 | 1 | gurilan bvt |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
1 | 2012-12-05 | 2 | zairmag |
| 7 | cocacola-330ml | 3 | 100 | 500 | 5 |
1 | 2012-12-05 | 3 | undaa |
+------+-----------------------------+------+------------+-------+----------+---
----+------------+------+-------------+
168 rows in set (0.00 sec)
mysql> select * from baraa;
+------+-----------------------------+------+------------+-------+
| DD | Name | Type | Unit_Price | Piece |
+------+-----------------------------+------+------------+-------+
| 1 | atar talh | 1 | 650 | 100 |
| 2 | zuiwan chex | 1 | 830 | 100 |
| 3 | ogooj-eeven | 1 | 2200 | 25 |
| 4 | alyaska zairmag-shokolodtai | 2 | 300 | 250 |
| 5 | alyaska zairmag-tsotsgiitei | 2 | 300 | 200 |
| 6 | pepsi-500ml | 3 | 750 | 300 |
| 7 | cocacola-330ml | 3 | 100 | 500 |
+------+-----------------------------+------+------------+-------+
7 rows in set (0.00 sec)
mysql> select * from trade;
+----------+-------+------------+
| Baraa_DD | Piece | Ognoo |
+----------+-------+------------+
| 1 | 3 | 2012-11-30 |
| 2 | 3 | 2012-12-03 |
| 1 | 1 | 2012-12-04 |
| 4 | 10 | 2012-12-05 |
| 6 | 5 | 2012-12-06 |
| 3 | 6 | 2012-12-06 |
| 5 | 12 | 2012-12-05 |
| 5 | 1 | 2012-12-05 |
+----------+-------+------------+
8 rows in set (0.00 sec)
mysql> select * from type;
+------+-------------+
| ID | Name |
+------+-------------+
| 1 | gurilan bvt |
| 2 | zairmag |
| 3 | undaa |
+------+-------------+
3 rows in set (0.00 sec)
mysql> alter table type add primary key(ID);
Query OK, 3 rows affected (0.82 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> alter table baraa add foreign key(Type) references type(ID);
Query OK, 7 rows affected (8.26 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> alter table trade add foreign key(Baraa_DD) references type(ID);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint f
ails (`supermarket`.`#sql-1374_1`, CONSTRAINT `#sql-1374_1_ibfk_1` FOREIGN KEY (
`Baraa_DD`) REFERENCES `type` (`ID`))
mysql> alter table baraa add primary key(DD);
Query OK, 7 rows affected (0.88 sec)
Records: 7 Duplicates: 0 Warnings: 0
mysql> alter table trade add foreign key(Baraa_DD) references baraa(DD);
Query OK, 8 rows affected (0.78 sec)
Records: 8 Duplicates: 0 Warnings: 0
mysql> select * from baraa where Unit_Price>300;
+----+-------------+------+------------+-------+
| DD | Name | Type | Unit_Price | Piece |
+----+-------------+------+------------+-------+
| 1 | atar talh | 1 | 650 | 100 |
| 2 | zuiwan chex | 1 | 830 | 100 |
| 3 | ogooj-eeven | 1 | 2200 | 25 |
| 6 | pepsi-500ml | 3 | 750 | 300 |
+----+-------------+------+------------+-------+
4 rows in set (0.00 sec)
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
.DD where Piece>5;
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 'where
Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
.DD and where Piece>5;
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 'where
Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
.DD;
ERROR 1054 (42S22): Unknown column 'trade.Baraa.DD' in 'where clause'
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD and where Piece>5;
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 'where
Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD where trade.Piece>5;
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 'where
trade.Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD;
+-----------------------------+-------+
| Name | Piece |
+-----------------------------+-------+
| atar talh | 3 |
| atar talh | 1 |
| zuiwan chex | 3 |
| ogooj-eeven | 6 |
| alyaska zairmag-shokolodtai | 10 |
| alyaska zairmag-tsotsgiitei | 12 |
| alyaska zairmag-tsotsgiitei | 1 |
| pepsi-500ml | 5 |
+-----------------------------+-------+
8 rows in set (0.00 sec)
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD where trade.Piece>5;
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 'where
trade.Piece>5' at line 1
mysql> select baraa.Name,trade.Piece from baraa,trade where baraa.DD=trade.Baraa
_DD and trade.Piece>5;
+-----------------------------+-------+
| Name | Piece |
+-----------------------------+-------+
| ogooj-eeven | 6 |
| alyaska zairmag-shokolodtai | 10 |
| alyaska zairmag-tsotsgiitei | 12 |
+-----------------------------+-------+
3 rows in set (0.00 sec)
mysql> select sum(Piece) from trade;
+------------+
| sum(Piece) |
+------------+
| 41 |
+------------+
1 row in set (0.00 sec)
mysql> select sum(Piece) from baraa;
+------------+
| sum(Piece) |
+------------+
| 1475 |
+------------+
1 row in set (0.00 sec)
mysql> select * from baraa where trade>'2012.12.03';
ERROR 1054 (42S22): Unknown column 'trade' in 'where clause'
mysql> select * from trade where ognoo>'2012.12.03';
+----------+-------+------------+
| Baraa_DD | Piece | Ognoo |
+----------+-------+------------+
| 1 | 1 | 2012-12-04 |
| 4 | 10 | 2012-12-05 |
| 6 | 5 | 2012-12-06 |
| 3 | 6 | 2012-12-06 |
| 5 | 12 | 2012-12-05 |
| 5 | 1 | 2012-12-05 |
+----------+-------+------------+
6 rows in set (0.00 sec)
mysql>
Subscribe to:
Posts (Atom)