Reply to thread

Message: <blockquote data-quote="san1020" data-source="post: 13144850" data-attributes="member: 360234">SQL dump [CODE]CREATE DATABASE  IF NOT EXISTS `mydb` /*!40100 DEFAULT CHARACTER SET latin1 */;USE `mydb`;-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)---- Host: localhost    Database: mydb-- -------------------------------------------------------- Server version    5.5.25a/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `item`--DROP TABLE IF EXISTS `item`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `item` (  `itemid` int(11) NOT NULL,  `itemname` varchar(45) DEFAULT NULL,  PRIMARY KEY (`itemid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `item`--LOCK TABLES `item` WRITE;/*!40000 ALTER TABLE `item` DISABLE KEYS */;INSERT INTO `item` VALUES (1001,'marie'),(1002,'marie 100'),(1003,'apple puff'),(1004,'apple puff 100');/*!40000 ALTER TABLE `item` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `loading`--DROP TABLE IF EXISTS `loading`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `loading` (  `loadingid` int(11) NOT NULL,  `itemid` int(11) NOT NULL,  `lorryid` int(11) NOT NULL,  `date` date DEFAULT NULL,  `loadedno` int(11) DEFAULT NULL,  PRIMARY KEY (`loadingid`),  KEY `fk_loading_item` (`itemid`),  KEY `fk_loading_lorry1` (`lorryid`),  CONSTRAINT `fk_loading_item` FOREIGN KEY (`itemid`) REFERENCES `item` (`itemid`) ON DELETE NO ACTION ON UPDATE NO ACTION,  CONSTRAINT `fk_loading_lorry1` FOREIGN KEY (`lorryid`) REFERENCES `lorry` (`lorryid`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `loading`--LOCK TABLES `loading` WRITE;/*!40000 ALTER TABLE `loading` DISABLE KEYS */;INSERT INTO `loading` VALUES (1,1001,1,'2012-07-01',100),(2,1001,2,'2012-07-02',150),(3,1002,1,'2012-07-02',200),(4,1003,2,'2012-07-01',200);/*!40000 ALTER TABLE `loading` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `lorry`--DROP TABLE IF EXISTS `lorry`;/*!40101 SET @saved_cs_client     = @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `lorry` (  `lorryid` int(11) NOT NULL,  `lorry name` varchar(45) DEFAULT NULL,  PRIMARY KEY (`lorryid`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `lorry`--LOCK TABLES `lorry` WRITE;/*!40000 ALTER TABLE `lorry` DISABLE KEYS */;INSERT INTO `lorry` VALUES (1,'lorry1'),(2,'lorry2');/*!40000 ALTER TABLE `lorry` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on 2012-08-02 21:40:36[/CODE]Select query [CODE]SELECT distinct loading.itemid,item.itemname,loading.date from loading left join item on item.itemid=loading.itemid group by itemid order by date desc;[/CODE]හරි යයි කියල හිතනවා , වැරදි නම් වෙනස් කරලා බලන්න query එක .</blockquote>

Verification: Awruddata maasa keeyada?

Top Bottom