অ্যাপ এম এল রেফারেন্সঃ ডাটা ফাইল (AppML Reference – Data Files)

রিদওয়ান বিন শামীম

 

ডাটাবেসের বৈশিষ্ট্য

ডাটাবেসের বৈশিষ্ট্য ডাটাবেসকে ডাটা সোর্সরূপে প্রদর্শন করে।এর কিছু উপবৈশিষ্ট্য আছে,

উপাদান বিবরণ
“type” ডাটা ফাইলের ধরণ (“csvfile”, “xmlfile”, or “jsonfile”)
“filename” ফাইলের নাম
“record” এক্সএমএল ডাটা নডের নাম (যদি xmlfile হয়)
“items” ডাটা আইটেম

 

টেক্সট ফাইল থেকে ডাটা

এই মডেল কমা দিয়ে আলাদা করা টেক্সট ফাইল থেকে টাইটেল, আর্টিস্ট, মূল্য এসব রেকর্ড খুঁজে নেয়,(আইটেম ১, ২, ৫ এর মত)।

উদাহরণ


{
 "data": {
     "type"    : "csvfile",
     "filename": "cd_catalog.txt",
     "items"   : [
         {"name": "Title", "index": 1},
         {"name": "Artist","index": 2},
         {"name": "Price", "index": 5}
     ]
 }
 }

উদাহরণের ব্যাখ্যা টেক্সট ফাইলের অনুরূপ

 

এক্সএমএল ফাইল থেকে ডাটা

এই মডেল এক্সএমএল ফাইলের সিডি নড থেকে টাইটেল, আর্টিস্ট, মূল্য এসব রেকর্ড খুঁজে নেয়।

উদাহরণ


{
 "data": {
     "type"    : "xmlfile",
     "filename": "cd_catalog.xml",
     "record"  : "CD",
     "items"   : [
         {"name": "Artist", "nodename": "ARTIST"},
         {"name": "Title",  "nodename": "TITLE"},
         {"name": "Country","nodename": "COUNTRY"}
     ]
 }
 }

উদাহরণের ব্যাখ্যা এক্সএমএল ফাইলের অনুরূপ

 

জেএসওএন ফাইল থেকে ডাটা

এই মডেল জেএসওএন ফাইলের সিডি অবজেক্টের আরি থেকে টাইটেল, আর্টিস্ট, মূল্য এসব রেকর্ড খুঁজে নেয়।

উদাহরণ


{
 "data" : {
     "type" : "jsonfile",
     "filename" : "cd_catalog.js",
     "record" : "cd",
     "items" : [
         {"name" : "Title", "nodename" : "title"},
         {"name" : "Artist", "nodename" : "artist"},
         {"name" : "Price", "nodename" : "price"}
     ]
 }
 }

উদাহরণের ব্যাখ্যা জেএসওএন ফাইলের অনুরূপ

 

অ্যাপ এম এল রেফারেন্স (AppML Reference)

রিদওয়ান বিন শামীম

 

অ্যাপ এম এল এইচটিএমএল এট্রিবিউট

উদাহরণ,


<div appml-include-html="inc_header.htm"></div>
 
 <h1>Customers</h1>
 <table appml-data="customers.js" appml-controller="myController">
   <tr>
     <th>Customer</th>
     <th>City</th>
     <th>Country</th>
   </tr>
   <tr appml-repeat="records">
     <td>{{CustomerName}}</td>
     <td>{{City}}</td>
     <td>{{Country}}</td>
   </tr>
 </table>
 
<divappml-include-html="inc_footer.htm"></div>

 

 

 

Attribute Description Explained
appml-controller AppML controller হিসাবে বিবৃত AppML Controllers
appml-data এপ্লিকেশনের জন্য ডাটা সোর্স বিবৃত করে AppML Data
appml-include-html যে এইচটিএমএল ব্যবহৃত হবে তার বিবরণ AppML Includes
appml-repeat যে এইচটিএমএল পুনরাবৃত্ত হবে তার বিবরণ AppML Howto

 

অ্যাপ এম এল ম্যাসেজ

উদাহরণ,


function myController($appml) {
     if ($appml.message == "display") {
         if ($appml.display.name == "CustomerName") {
             $appml.display.value = $appml.display.value.toUpperCase();
         }
     }
 }

 

 

 

Message Description
“ready” অ্যাপ এম এল শুরুর পরে দেখায়, লোড করতে প্রস্তুত
“loaded” অ্যাপ এম এল লোডেড, ডাটা দেখাতে প্রস্তুত
“display” অ্যাপ এম এল কোনও ডাটা আইটেম দেখানোর আগে দেখায়।
“done” অ্যাপ এম এল সম্পন্ন হওয়ার পর দেখায়
“submit” অ্যাপ এম এল ডাটা সাবমিটের আগে দেখায়
“error” অ্যাপ এম এল কোনও ভুলের সম্মুখীন হলে দেখায়

 

অ্যাপ এম এল ম্যাসেজ অধ্যায়ে এগুলো আরও বিস্তারিত ব্যাখ্যা করা হবে।

 

অ্যাপ এম এল মডেল

উদাহরণ ,


{
 "security": "admin",
 "rowsperpage" : 10,
 
 "database": {
     "connection": "mysql",
     "sql"       : "SELECT * FROM Customers",
     "orderby"   : "CustomerName"}},
 
 "filteritems" : [
     {"item" : "CustomerName", "label" : "Customer"},
     {"item" : "City"},
     {"item" : "Country"}], 
 
 "sortitems" : [
     {"item" : "CustomerName", "label" : "Customer"},
     {"item" : "City"},
     {"item" : "Country"}]
 }

 

 

অ্যাপ এম এল মডেলের বৈশিষ্ট্য

 

উপাদান বর্ণনা
“data” মডেলের ফাইল সোর্স বর্ণনা করে।
“database” মডেলের ডাটাবেস সোর্স বর্ণনা করে।
“filteritems” ফিল্টারের সীমাবদ্ধতা নির্দেশ করে
“rowsperpage” প্রতি পেজে সারির সংখ্যা খুঁজে, বিবৃত করে
“security” মডেলের নিরাপত্তা বিবৃত করে
“sortitems” সর্টিং সীমাবদ্ধতা বিবৃত করে।

 

এপ্লিকেশন নিরাপত্তা

এপ্লিকেশনে ঢুকতে এডমিন মেম্বার হিসেবে লগ ইন করতে হবে।

উদাহরণ,


{
 "security": "admin",
 "database": {
     "connection": "mysql",
     "sql"       : "SELECT * FROM Customers",
     "orderby"   : "CustomerName"}
 }
প্রাইভেট মডেলঃ মডেলে নিজের প্রাইভেট ডাটা যোগ করার উপায় আছে, এই উদাহরণে ডাটার ক্ষেত্রে সীমাবদ্ধতা দেখানো হল,
"restrictions" : {
     "fname" : {"maxlength": 40},
     "price" : {"max": 999,"min": 100}
     }

 

 

মডেল ডাটা সার্ভার এপ্লিকেশনেও ব্যবহৃত হয়, অ্যাপ এম এল কন্ট্রোলার দ্বারা।

নিচের উদাহরণে ইনপুট ভ্যালিডেশনের জন্য মডেল ডাটা ব্যবহৃত হয়েছে।


function myController($appml) {
     if ($appml.message == "submit") {
         var price = document.getElementById("price").value;
         if (price < $appml.model.restrictions.price.min) {
             $appml.displayError(15, "Price too low!");
             return;
         }
 }

 

 

 

অ্যাপ এমএল এ অ্যামাজন ডাটাবেজ ব্যবহার করা (AppML using Amazon Database)

হ্যালো বন্ধুরা,

আমাদের সাইটে আসার জন্য ধন্যবাদ…

এখানে আমরা আমাজন ডাটাবেজ সম্পর্কে আলোচনা করব। ডাটাবেজ এ সংযুক্ত হওয়া খুব একটা কঠিন কাজ নয়। একটু জানলই তোমরা সহজেই ডাটাবেজ এর সাথে সংযুক্ত হতে পারবে

আস জেনে নেই…

আমাজন রিলেশনাল ডাটাবেস সার্ভিস কি (RDS)

বিভিন্ন ডাটাবেজ প্রতিষ্ঠানের মধ্যে আমাজন হলো একটি প্রতিষ্ঠান। এই প্রতিষ্ঠান বিভিন্ন ডাটাবেজের সুবিধা দিয়ে থাকে।

কেন আমরা আমাজন ডাটাবেজ ব্যবহার করব?

আমাজন রিলেশনাল ডাটাবেস সার্ভিস (RDS) একটি চলমান ডাটাবেজ এর অনেক চ্যালেঞ্জ মুখোমুখি পরিচালনা করে।

আপনার প্রয়োজন অনুসারে আমাজন রিলেশনাল ডাটাবেস সার্ভিস (RDS) এর সাথে কর্মক্ষমতা এবং স্টোরেজে এর পরিমান পরিবর্তন করতে পারেন।

রিলেশনাল ডাটাবেস সার্ভিস (RDS) স্বয়ংক্রিয় ব্যাকআপ, সংস্কার এবং পুনরুদ্ধারের পরিচালনা করে।

এটি জনপ্রিয় ডাটাবেজ পণ্যগুলো সমর্থন করে। যেমন:

  • MySQL
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • and the new, MySQL-compatible Amazon Aurora DB engine

শুরু করা যাক

আমাজন রিলেশনাল ডাটাবেস সার্ভিস (RDS) শুরু করার আগে, অবশ্যই আমাজান ওয়েব সার্ভারে সাইন আপ করে নিতে হবে এবং ডাটাবেস ব্যবহারকারী এবং নিরাপত্তা গ্রুপ সেট আপ করে নিতে হবে।

আমাজন ওয়েব সার্ভিসেস এ সাইন আপ

যখন আপনি আমাজন ওয়েব সার্ভিসেস (AWS) এ সাইন আপ করবেন, AWS অ্যাকাউন্ট স্বয়ংক্রিয়ভাবে আমাজন রিলেশনাল ডাটাবেস সার্ভিস (RDS) সহ AWS এর সকল সেবার সাথে সাইন আপ করা হয়ে যাবে।

আপনি যদি  AWS এর নতুন গ্রাহক হন তাহলে, বিনামূল্যে প্রদত্ত অ্যামাজন RDS দিয়ে শুরু করতে পারেন।

বিনামূল্যে প্রদত্ত AWS সাইন আপ করার ১২ মাস পর্দন্ত বিনামূল্যে ব্যবহার করার সুযোগ দেবে। আরো জানার জন্য দেখুন বিনামূল্যে AWS ব্যবহার

মুক্ত স্তর আপনি সাইন আপ করার পরে আপনাকে 12 মাসের জন্য বিনামূল্যে জন্য Aws চেষ্টা করতে পারবেন না. আরো তথ্যের জন্য, Aws ফ্রী ব্যবহার টিয়ার দেখতে.

আপনার ফ্রী ব্যবহারের সময় শেষ হওয়ার পরও (বা ফ্রী ট্রায়য়াল অফার এর চেয়ে বেশি স্টোরেজ বা কার্যকারিতা প্রয়োজন হলে) আপনি যদি আপনার ব্যবহার চালিয়ে যেতে চান, তাহলে আপনি শুধুমাত্র যে রিসোর্স ব্যবহার করবেন তার উপর ভিত্তি করে মূল্য প্রদান করবেন।

AWS অ্যাকাউন্ট তৈরি করার জন্য http://aws.amazon.com/, এবং তারপর সাইন আপ এ ক্লিক করুন।

পর্দায় প্রদর্শিত নির্দেশাবলী অনুসরণ করুন। AWS একাউন্ট নম্বর লিখে রাখুন, কেননা এটি পরবর্তীতে প্রয়োজন হবে।

একটি মাইএসকিউএল ডাটাবেস ইনস্ট্যান্স তৈরি

এন এই উদাহরণে আমরা মাইএসকিউএল চলমান একটি বিনামূল্যে ডাটাবেস ইনস্ট্যান্স সেট আপ হবে. (এটা পরীক্ষার জন্য দেয়ার উদ্দেশ্যে করা হচ্ছে, কারণ এটি বিনামূল্যে).

একটি মাইএসকিউএল ডিবি উদাহরণস্বরূপ তৈরি করুন:

  1. আমাজান RDS কনসোল এ যান: https://console.aws.amazon.com/rds/
  2. নেভিগেশন প্যানেল থেকে Instances এ ক্লিক করুন
  3. Launch DB Instance এ ক্লিক করুন
  4. নির্বাচিত ইঞ্জিন পৃষ্ঠায় MySQL আইকন এ ক্লিক করুন এবং তারপর MySQL DB engine এ ক্লিক করে নির্বাচন করুন।
  5. উৎপাদন? (Production?) পৃষ্ঠায় “No, this instance is intended for use outside of production…….” লেখা চেক বক্স এ ক্লিক করুন এবং তারপর Next Step এ ক্লিক করুন
  6. Specify DB Details পৃষ্ঠার নির্দেশাবলী অনুসরণ করুন। (বিনামূলে টেস্ট ডাটাবেজ সেটিং করতে এই নির্দেশাবলী অনুসরণ করুন)
  7. Configure Advanced Settings পৃষ্ঠার নির্দেশাবলী অনুসরণ করুন। (বিনামূলে টেস্ট ডাটাবেজ সেটিং করতে এই নির্দেশাবলী অনুসরণ করুন)
  8. Launch DB Instance এ ক্লিক করুন।
  9. View Your DB Instances এ ক্লিক করুন।
  10. ডিবি ইনস্ট্যান্স এর তালিকায় নতুন ডিবি ইনস্ট্যান্স দেখা যাবে (এটি ব্যবহার করার উপযুক্ত অবস্থা আসার আগ পর্যন্ত “creating” অবস্থা দেখাবে)।
  11. যখন অবস্থা পরিবর্তীত হয়ে “available” হবে তখন আপনি ডাটাবেজ এ সংযুক্ত হতে পারবেন।
  12. বিস্তারিত দেখার জন্য details আইকনে ক্লিক করুন এবং “Endpoint” থেকে পোর্ট সহ URL কপি করুন।

নোটঃ URL এর শেষের দিকে অনেকটা এরকম দেখা যেতে পারে:


databasename.aaabbbcccddd.region.rds.amazonaws.com:3306


 

 

আ্যাপ এম এল -এ ডাটাবেজ সংযোগ স্থাপন

AppML ডাটাবেস সংযোগ কনফিগার
ডাটাবেস সংযোগ কনফিগার করার জন্য, appml_config ফাইল এডিট:


{
 "dateformat" : "yyyy-mm-dd",
 "databases" : [{
 "connection" : "mydatabase",
 "host" : "yourDatabaseURL",
 "dbname" : "yourDatabaseName",
 "username" : "yourUserName",
 "password" : "yourPassword"
 }]
 }

 

নিম্নোক্ত বিষয়গুলো পরিবর্তন করুন

  1. mydatabase – আপনার অ্যাপ্লিকেশন এ ডাটাবেজ কানেকশন কল করা প্রয়োজন হলে এটি পরিবর্তন করুন।
  2. yourDatabaseURL – পূর্ববর্তী ধাপ থেকে Endpoint URL পরিবর্তন করুন।
  3. yourDatabaseName – আপনার Amazon RDS এর নাম অনুসারে আপনার ডাটাবেজ এর নাম পরিবর্তন করুন।
  4. yourUserName – আপনার Amazon RDS অনুসারে ইউজার এর নাম পরিবর্তন করুন।
  5. yourPassword – আপনার Amazon RDS অনুসারে পাসওয়ার্ড পরিবর্তন করুন।

অ্যাপ এমএল এখন Amazon RDS এর সাথে সংযুক্ত হওয়ার মতো কনফিগার করা হয়েছে।

আপনি এখন আপনার ডাটাবেজ কে ডাটা দ্বারা পূরণ করতে পারবেন:

 

  • আপনার যদি পিএইচপি সার্ভার এ প্রবেশাধিকার থাকে তাহলে তা AppML PHP অধ্যায় এ আলোচনা করা হয়েছে।
  • আপনার যদি ASP.NET সার্ভার এ প্রবেশাধিকার থাকে তাহলে তা AppML .NET অধ্যায় এ আলোচনা করা হয়েছে।
  • আপনার যদি কোন সার্ভার এ প্রবেশাধিকার না থাকে তাহলে তা AppML WebMatrix অধ্যায় এ আলোচনা করা হয়েছে।

 

অ্যাপ এম এল -এ গুগল ক্লাউড এসকিউএল ব্যবহার করা (AppML using Google Cloud SQL)

রফিকুল ইসলাম

 

গুগল ক্লাউড এসকিউএল কী

গুগল ক্লাউড এসকউএল হচ্ছে ক্লাউড ভিত্তিক ডাটাবেজ সেবা।

 

গুগল ক্লাউড এসকিউএল কেন?

গুগল ক্লাউড এসকিউএল, মাই এসকিউএল ডাটাবেজকে কোন অতিরিক্ত  বিরম্বনা ছাড়াই ক্লাউড এ স্থাপন করে।

গুগল শক্তিশালী ডাটাবেজ অফার করে এবং এর ব্যয় খুবই নমনীয় (যতটুকু ব্যবহার সেইঅনুপাতে বিল প্রদান করতে হয়)

গুগল স্বয়ংক্রিয় ব্যাকআপ, সংস্কার, এবং পুনরুদ্ধার পরিচালনা করে।

 

শুরু করা যাক

গুগল ক্লাউড এসকিউএল এর ব্যবহার শুরু করার আগে আপনার একটি গুগল একাউন্ট থাকতে হবে এবং গুগল ডেভেলপার কনসোল (Google Developers Console) এ সাইন আপ করতে হবে।

আপনার যদি গুগল একাউন্ট না থাকে তাহলে এখান থেকে গুগল একাউন্ট খুলুন।

 

গুগল ডেভেলপার কনসোল (Google Developers Console) এ সাইন আপ করা

যখন আপনি গুগল ডেভেলপার কনসোল এ সাইন আপ করবেন তখন, আপনার গুগল একাউন্ট সয়ংক্রিয়ভাবে গুগল ক্লাউড ও এসকিউএল এর সকল সেবার সাথে সাইন আপ করা হয়ে যাবে।

যদি আপনি ক্লাউড এর নতুন ব্যবহারকারী হন, তাহলে শুরু করার জন্য নির্দিষ্ট সময় বিনা মূল্যে ব্যবহার করতে পারেন। (ক্লাউড এসকিউএল প্রথম ৬০ দিনের জন্য বিনামূল্যে ব্যবহার করা যায়)। আরো জানতে বিনামূল্যে ক্লাউড দেখুন।

আপনার ফ্রী ব্যবহারের সময় শেষ হওয়ার পরও (বা ফ্রী ট্রায়য়াল অফার এর চেয়ে বেশি স্টোরেজ বা কার্যকারিতা প্রয়োজন হলে) আপনি যদি আপনার ব্যবহার চালিয়ে যেতে চান, তাহলে আপনি শুধুমাত্র যে রিসোর্স ব্যবহার করবেন তার উপর ভিত্তি করে মুল্য প্রদান করবেন।

গুগল ডেভেলপার কনসোন একাউন্ট খুলতে গুগল ডেভেলপার কনসোন একাউন্ট এ ক্লিক করুন এবং নির্দেশাবলী অনুসরণ করুন।

 

উদাহরণস্বরূপ মাইএসকিউএল  ডাটাবেজ তৈরি করন

এই উদাহরণে চলন্ত মাইএসকিউএল এ আমরা ডাটাবেস ইনস্ট্যান্স সেট আপ করবো।

মাইএসকিউএল ডিবি ইনস্ট্যান্স তৈরি

  • আপনি যখন আপনার একাউন্ট তৈরি করবেন তখন সয়ংক্রিয়ভাবে গুগল আপনার জন্য “My First Project” নামে একটি প্রোজেক্ট তৈরি করবে। আমরা এই উদাহরণে উক্ত প্রোজেক্টটি ব্যবহার করবো
  • মেনু থেকে “Storage” এ ক্লিক করুন এবং তারপর “Cloud SQL” এ ক্লিক করুন
  • “Create an instance” এ ক্লিক করুন
  • “Create Cloud SQL instance” পেজ এ আপনার ডিবি এসকিউএল ইনস্ট্যান্স এর জন্য নাম, অঞ্চল এবং কর্মক্ষমতা স্তর ইত্যাদি নির্বাচন করুন। এই উদাহরন এর জন্য আপনি এডভান্স অপশন ছেড়ে যেতে পারেন।
  • “Create” এ ক্লিক করুন।
  • ডিবি ইনস্ট্যান্স এর তালিকায় নতুন ডিবি ইনস্ট্যান্স দেখা যাবে (যখন এর অবস্থা “Runnable” থাকবে তখন এটি ব্যবহারের জন্য উপযুক্ত অবস্থায় থাকবে)।
  • ইনস্ট্যান্স এর নামের উপর ক্লিক করুন এবং নেভিগেশন প্যানেল এর “Access Control” এ ক্লিক করুন।
  • সাব নেভিগেশন প্যানেল এর “IP address”  এ ক্লিক করুন এবং “Request IPv4 address” বাটন এ ক্লিক করুন।
  • এই আইপি এড্রেসটি সংরক্ষণ করে রাখুন। এই আইপি এড্রেসটি ডাটাবেজ এ সংযুক্ত হওয়ার সময় প্রয়োজন হবে।
  • সাব নেভিগেশন প্যানেল এর “Users”  এ ক্লিক করুন এবং “New user” বাটন এ ক্লিক করুন।
  • আপনার ডাটাবেজ এর জন্য একটি ইউজার নেম ও পাসওয়ার্ড নির্দিষ্ট করে দিন।
  • সাব নেভিগেশন প্যানেল এর “Authorization”  এ ক্লিক করুন এবং তারপর Allowed Networks এর অধিন “+ Add item” বাটন এ ক্লিক করুন।
  • এখানে আপনি নির্দিষ্ট করে দিতে পারবেন কারা আপনার ডাটাবেজ এ প্রবেশ করতে পারবে, এটা হতে পারে
    • আপনার নিজস্ব আইপি বা আপনার সার্ভার এর আইপি। এভাবে আপনি আপনার ডাটাবেজ এ প্রবেশ করতে পারবেন।
    • বা 0.0.0.0/0, যা বাহিরের যেকোন আইপি এড্রেস আপনার ডাটাবেজ এ প্রবেশ করতে পারবে (এটি নিরাপত্তা ঝুকি সৃষ্টি করতে পারে এবং আপনাকে এর জন্য অতিরিক্ত মুল্য প্রদান করতে হতে পারে)
  • “Save” এ ক্লিক করুন।
  • নেভিগেশন প্যানেল থেকে “Databases” এ ক্লিক করুন এবং “New database” বাটন এ ক্লিক করুন।
  • আপনার ডাটাবেজ এর জন্য একটি নাম নির্দিষ্ট করুন। (আপনার প্রয়োজন অনুসারে অন্যান্য অপশনগুলে ছেড়ে যেতে পারেন)।

এখন আপনার একটি গুগল ক্লাউড এসকিউএল ডাটাবেজ আছে, সাথে আছে একটি আইপি আপনার ডাটাবেজ এ সংযুক্ত হওয়ার জন্য।

 

আ্যাপ এম এল -এ ডাটাবেজ সংযোগ স্থাপন

ডাটাবেজ সংযোগ স্থাপন করতে appml_config ফাইল কি সম্পাদনা করুন

PHP example: appml_config.php


<?php echo("Access Forbidden");exit();?>
{
"dateformat" : "yyyy-mm-dd",
"databases" : [{
"connection" : "mydatabase",
"host" : "yourDatabaseURL",
"dbname" : "yourDatabaseName",
"username" : "yourUserName",
"password" : "yourPassword"
}]
}

 

নিম্নোক্ত বিষয়গুলো পরিবর্তন করুন

  1. mydatabase – আপনার অ্যাপ্লিকেশন এ ডাটাবেজ কানেকশন কল করা প্রয়োজন হলে এটি পরিবর্তন করুন।
  2. yourDatabaseURL – পূর্ববর্তী ধাপ থেকে আইপি পরিবর্তন করুন এবং 3306 পোর্ট যোগ করুন। (উদাহরণ স্বরুপ:  192.168.1.1:3306)
  3. yourDatabaseName – আপনার গুগল ক্লাউড এসকিউএল এর নাম অনুসারে আপনার ডাটাবেজ এর নাম পরিবর্তন করুন।
  4. yourUserName – আপনার গুগল ক্লাউড এসকিউএল অনুসারে ইউজার এর নাম পরিবর্তন করুন।
  5. yourPassword – আপনার গুগল ক্লাউড এসকিউএল অনুসারে পাসওয়ার্ড পরিবর্তন করুন।

অ্যাপ এমএল এখন গুগল ক্লাউড এসকিউএল এর সাথে সংযুক্ত হওয়ার মতো কনফিগার করা হয়েছে।

আপনি এখন আপনার ডাটাবেজ কে ডাটা দ্বারা পূরণ করতে পারবেন।

 

  • আপনার যদি পিএইচপি সার্ভার এ প্রবেশাধিকার থাকে তাহলে তা AppML PHP অধ্যায় এ আলোচনা করা হয়েছে।
  • আপনার যদি ASP.NET সার্ভার এ প্রবেশাধিকার থাকে তাহলে তা AppML .NET অধ্যায় এ আলোচনা করা হয়েছে।
  • আপনার যদি কোন সার্ভার এ প্রবেশাধিকার না থাকে তাহলে তা AppML WebMatrix অধ্যায় এ আলোচনা করা হয়েছে।

 

 

 

SSC Quiz 07 : কম্পিউটার শিক্ষা : অধ্যায় ০৭ (ডাটাবেজ)

[slickquiz id=9]

অ্যাপ এম এল ওয়েবম্যাট্রিক্স (AppML WebMatrix)

রিদওয়ান বিন শামীম

 

কারো যদি ওয়েব সার্ভার না থাকে তবে অ্যাপ এম এল ওয়েবম্যাট্রিক্স ব্যবহার করে তৈরি করে নেয়া যায়।

 

ওয়েবম্যাট্রিক্স

ওয়েবম্যাট্রিক্স হল এক প্রকার ফ্রী ওয়েব ডেভেলাপমেন্ট টুল যেটি সহজে ওয়েবসাইট তৈরি করতে দেয়। এর উপাদানগুলো হল,

  • ওয়েবের উদাহরণ ও টেম্পলেট,
  • বিভিন্ন ওয়েব ল্যাঙ্গুয়েজের জন্য সাপোর্ট(যেমন পিএইচপি, এএসপি ডট নেট, নড জেএস ইত্যাদি),
  • একটি ওয়েব সার্ভার,
  • ডাটাবেস সার্ভার(মাইএসকিউএল, এসকিউএল সার্ভার কমপ্যাক)

ওয়েবম্যাট্রিক্স দিয়ে একদম ফাঁকা ওয়েব সাইট দিয়ে শুরু করে বা বিভিন্ন টেম্পলেট ব্যবহার করে সাইট তৈরি করা যায়।

ওয়েবম্যাট্রিক্সে কিছু বিল্ট ইন টুল আছে ডাটাবেস, নিরাপত্তা, সার্চ ইঞ্জিন অপটিমাইজেশন ও ওয়েব পাবলিশিং সংক্রান্ত। ওয়েবম্যাট্রিক্স ইন্সটল করার জন্য লিঙ্ক, http://www.microsoft.com/web/webmatrix

 

শূন্য পিএইচপি সাইট

ওয়েবম্যাট্রিক্স থেকে Template Gallery, সেখান থেকে PHP, তার ভেতর থেকে Empty Site সিলেক্ট করতে হয়। সেখান থেকে সাইট নেম চেঞ্জ করে DemoAppml বা অন্য কিছু দিতে হয়। এরপর Next বাটন চাপতে হয়।

new web

 

এইচটিএমএল টেস্ট পেজ তৈরি

ওয়েবম্যাট্রিক্সে New থেকে New File সেটি থেকে HTML টাইপ হিসেবে নির্ধারণ করতে হয়। ফাইল নেমকে customers.htm বা অন্য কোনও নামে চেঞ্জ করে দিতে হয়, এরপর OK বাটনে চাপতে হয়।

pic_matrix

নতুন ফাইলে এইচটিএমএল যেভাবে পরিবর্তিত হবে তা নিচের উদাহরণে দেখানো হল,

customers.htm


<!DOCTYPE html>
 <html lang="en">
 <title>Customers</title>
 <link rel="stylesheet" href=
 "http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script> 
 <body>
 
 <div class="container" appml-data="customers">
 <h1>Customers</h1>
 <table class="table table-striped table-bordered">
 <tr>
   <th>Customer</th>
   <th>City</th>
   <th>Country</th>
 </tr>
 <tr appml-repeat="records">
   <td>{{CustomerName}}</td>
   <td>{{City}}    </td>
   <td>{{Country}} </td>
 </tr>
 </table>
 </div>
 
 <script>
 var customers = {
 "records":[
 {"CustomerName":"Alfreds Futterkiste","City":"Berlin","Country":"Germany"},
 {"CustomerName":"Ana Trujillo Emparedados y helados","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Antonio Moreno Taquería","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Around the Horn","City":"London","Country":"UK"},
 {"CustomerName":"B's Beverages","City":"London","Country":"UK"},
 {"CustomerName":"Berglunds snabbköp","City":"Luleå","Country":"Sweden"},
 {"CustomerName":"Blauer See Delikatessen","City":"Mannheim","Country":"Germany"},
 {"CustomerName":"Blondel père et fils","City":"Strasbourg","Country":"France"},
 {"CustomerName":"Bólido Comidas preparadas","City":"Madrid","Country":"Spain"},
 {"CustomerName":"Bon app'","City":"Marseille","Country":"France"},
 {"CustomerName":"Bottom-Dollar Marketse","City":"Tsawassen","Country":"Canada"},
 {"CustomerName":"Cactus Comidas para llevar","City":"Buenos Aires","Country":"Argentina"},
 {"CustomerName":"Centro comercial Moctezuma","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Chop-suey Chinese","City":"Bern","Country":"Switzerland"},
 {"CustomerName":"Comércio Mineiro","City":"São Paulo","Country":"Brazil"}
 ]};
 </script>
 
 </body>
</html>

 

 

টেস্টপেজ রান করানোর জন্য ওয়েবম্যাট্রিক্সে Right-click করে Launch in browser সিলেক্ট করতে হবে।

 

ডাটাবেস তৈরি করা

ওয়েবম্যাট্রিক্সে Databasesথেকে New Databaseসেখান থেকে MySQL Database নির্দিষ্ট করে দিতে হবে, ডাটাবেস নেম চেঞ্জ করে OK করে দিতে হবে।

 Web Mattix

ওয়েবম্যাট্রিক্সে Files সিলেক্ট করে web.config ফাইল ওপেন করতে হবে।

 

 

অ্যাপ এম এল কনফিগার করা

ফাইলনেম চেঞ্জ করে appml_config.php করতে হয়,

appml_config.php


<?php echo("Access Forbidden");exit();?>
 {
 "dateformat" : "yyyy-mm-dd",
 "databases" : [{
     "connection" : "mydatabase",
     "host" : "localhost",
     "dbname" : "DemoDB",
     "username" : "DemoDBUkbn5",
     "password" : "l6|U6=V(*T+P" 
 }]
 }

 

 

 

কনফিগারেশন ফাইলের ব্যাখ্যা

 

বৈশিষ্ট্য বর্ণনা
dateformat মডেলে ব্যবহৃত ডেট ফরম্যাট
connection মডেলে ব্যবহৃত কানেকশন নেম
host সার্ভারের আইপি বা হোষ্ট নেম
dbname ডাটাবেসে থাকা নাম
username ইউআইডিতে থাকা নাম
password আইডির পাসওয়ার্ড

 

 

অ্যাপ এম এল কপি করা

http://www.w3schools.com/appml/2.0.3/appml.php.txt. থেকে ডাউনলোড করে ওয়েবসাইটে কপি করে appml.php নামে রিনেম করতে হয়।

pic copy

ডাটাবেস টেবিল তৈরি করা

Create_Customers.js


{
“database” : {
“connection” : “mydatabase”,
“execute” : [
“DROP TABLE IF EXISTS Customers”,
“CREATE TABLE IF NOT EXISTS Customers (CustomerID INT NOT NULL AUTO_INCREMENT,PRIMARY KEY (CustomerID),CustomerName NVARCHAR(255),ContactName NVARCHAR(255),Address NVARCHAR(255),City NVARCHAR(255),PostalCode NVARCHAR(255),Country NVARCHAR(255))”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Alfreds Futterkiste\”,\”Maria Anders\”,\”Obere Str. 57\”,\”Berlin\”,\”12209\”,\”Germany\”)”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Around the Horn\”,\”Thomas Hardy\”,\”120 Hanover Sq.\”,\”London\”,\”WA1 1DP\”,\”UK\”)”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Blauer See Delikatessen\”,\”Hanna Moos\”,\”Forsterstr. 57\”,\”Mannheim\”,\”68306\”,\”Germany\”)”
]
}}


 

 

Create_Customers model রান করাতে এইচটিএমএল পেজ তৈরি করতে হয়,

Create_Customers.htm


<!DOCTYPE html>
 <html lang="en-US">
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script>
 <body>
<div appml-data="appml.php?model=Create_Customers"></div>
</body>
 </html>

 

 

এইচটিএমএল পেজ রান করাতে ওয়েবম্যাট্রিক্সে Right-click করে Launch in browser সিলেক্ট করতে হবে।

 

এপ্লিকেশন তৈরি করা

কাস্টমার এপ্লিকেশন মডেল তৈরি করে customers.js নামে সংরক্ষণ করতে হয়।

Customers.js


{
 "rowsperpage" : 10,
 "database" : {
 "connection" : "mydatabase",
 "sql" : "SELECT * FROM Customers",
 "orderby" : "CustomerName"
 }
 }

 

 

কাস্টমার এপ্লিকেশন রান করাতে এইচটিএমএল পেজ তৈরি করতে হয়,

customers.htm


<!DOCTYPE html>
 <html lang="en">
 <title>Customers</title>
 <link rel="stylesheet" href= "http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script>
 <body>
<div class="container" appml-data="appml.php?model=customers">
 <h1>Customers</h1>
 <table class="table table-striped table-bordered">
 <tr>
 <th>Customer</th>
 <th>City</th>
 <th>Country</th>
 </tr>
 <tr appml-repeat="records">
 <td>{{CustomerName}}</td>
 <td>{{City}}</td>
 <td>{{Country}}</td>
 </tr>
 </table>
 </div>
</body>
 </html>

 

 

এইচটিএমএল পেজ রান করাতে ওয়েবম্যাট্রিক্সে Right-click করে Launch in browser সিলেক্ট করতে হবে।

 

অ্যাপ এম এল ডট নেট (AppML .NET)

রিদওয়ান বিন শামীম

 

ডট নেট সার্ভারে প্রবেশযোগ্যতা থাকলে নিচের প্রক্রিয়ায় অ্যাপ এম এল সার্ভার এপ্লিকেশন তৈরি করা যাবে, প্রবেশযোগ্যতা না থাকলে ওয়েবম্যাট্রিক্সের জন্য প্রযোজ্য প্রক্রিয়া অনুসরণ করতে হবে।

 

টেস্ট পেজ তৈরি করা

প্রথমে টেস্ট পেজ তৈরি করে সেটিকে পিএইচপি সার্ভারে customers.htm নাম দিয়ে(বা অন্য কোনও নামও চলবে) সংরক্ষণ করতে হবে।

customers.htm


<!DOCTYPE html>
 <html lang="en">
 <title>Customers</title>
 <link rel="stylesheet" href=
 "http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script>
 <body>
 
 <div class="container" appml-data="customers">
 <h1>Customers</h1>
 <table class="table table-striped table-bordered">
 <tr>
      <th>Customer</th>
      <th>City</th>
      <th>Country</th>
 </tr>
 <tr appml-repeat="records">
      <td>{{CustomerName}}</td>
      <td>{{City}}    </td>
      <td>{{Country}} </td>
 </tr>
 </table>
 </div>
 
 <script>
 var customers = {
 "records":[
 {"CustomerName":"Alfreds Futterkiste","City":"Berlin","Country":"Germany"},
 {"CustomerName":"Ana Trujillo Emparedados y helados","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Antonio Moreno Taquería","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Around the Horn","City":"London","Country":"UK"},
 {"CustomerName":"B's Beverages","City":"London","Country":"UK"},
 {"CustomerName":"Berglunds snabbköp","City":"Luleå","Country":"Sweden"},
 {"CustomerName":"Blauer See Delikatessen","City":"Mannheim","Country":"Germany"},
 {"CustomerName":"Blondel père et fils","City":"Strasbourg","Country":"France"},
 {"CustomerName":"Bólido Comidas preparadas","City":"Madrid","Country":"Spain"},
 {"CustomerName":"Bon app'","City":"Marseille","Country":"France"},
 {"CustomerName":"Bottom-Dollar Marketse","City":"Tsawassen","Country":"Canada"},
 {"CustomerName":"Cactus Comidas para llevar","City":"Buenos Aires","Country":"Argentina"},
 {"CustomerName":"Centro comercial Moctezuma","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Chop-suey Chinese","City":"Bern","Country":"Switzerland"},
 {"CustomerName":"Comércio Mineiro","City":"São Paulo","Country":"Brazil"}
 ]};
 </script>
 
 </body>
 </html>

 

 

এরপর পেজটিকে ব্রাউজারে টেস্ট করতে হবে।

 

ডাটাবেস কানেকশন তৈরি করতে হবে

এসকিউএল সার্ভার ডাটাবেসে প্রবেশযোগ্যতা থাকলে(বা অন্য কোনও OLEDB ডাটাবেস যেমন এমএস এক্সেস) ডাটাবেস কানেকশন ডিফাইন করে সার্ভারে appml_config.aspx নাম দিয়ে সংরক্ষণ করতে হয়।

appml_config.aspx (SQL Server Example)


<%
 Response.write("Access Forbidden")
 Response.end
 %>
 {
 "dateformat" : "yyyy-mm-dd",
 "databases" : [
 "connection" : "mydatabase",
 "provider"   : "SQLOLEDB",
 "host"       : "myserver",
 "dbname"     : "DemoDB",
 "username"   : "DemoDBUkbn5",
 "password"   : "l6|U6=V(*T+P"
 }]
 }

 

appml_config.aspx (MS Access Example)


<%
 Response.write("Access Forbidden")
 Response.end
 %>
 {
 "dateformat" : "yyyy-mm-dd",
 "databases" : [
 {
 "connection" : "mydatabase",
 "connectionstring" :
 "Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\\database\\Northwind.mdb"
 }
 }

 

উপরের উদাহরণের কানেকশন বাস্তব নয়, নাম ও পাসওয়ার্ড উদাহরণমাত্র।

 

কনফিগারেশন ফাইলের ব্যাখ্যা

বৈশিষ্ট্য বর্ণনা
dateformat মডেলে যে ডেট ফরম্যাট ব্যবহৃত হবে
connection মডেলে যে কানেকশন নেম ব্যবহৃত হবে
connectionstring OLEDB ড্রাইভার যেমন এমএস এক্সেস ইত্যাদির ক্ষেত্রে প্রযোজ্য
provider ডাটাবেস সফটওয়ারের পরিবেশক
host ডাটাবেসের আইডি বা হোষ্ট
dbname ডাটাবেসের নাম
username ডাটাবেসের ইউজারনেম
password ডাটাবেসের পাসওয়ার্ড

 

ডাটাবেস টেবিল তৈরি করা

ডাটাবেসে কাস্টমার টেবিল তৈরির মডেল নিচের উদাহরণে দেয়া হল,

create_customers.js


{
“database” : {
“connection” : “mydatabase”,
“execute” : [
“DROP TABLE IF EXISTS Customers”,
“CREATE TABLE IF NOT EXISTS Customers (CustomerID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,(CustomerID), CustomerName NVARCHAR(255),ContactName NVARCHAR(255),Address NVARCHAR(255),City NVARCHAR(255),PostalCode NVARCHAR(255),Country NVARCHAR(255))”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Alfreds Futterkiste\”,\”Maria Anders\”,\”Obere Str. 57\”,\”Berlin\”,\”12209\”,\”Germany\”)”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Around the Horn\”,\”Thomas Hardy\”,\”120 Hanover Sq.\”,\”London\”,\”WA1 1DP\”,\”UK\”)”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Blauer See Delikatessen\”,\”Hanna Moos\”,\”Forsterstr. 57\”,\”Mannheim\”,\”68306\”,\”Germany\”)”
]
}}


 

 

create_customers.js model চালু করার জন্য এইচটিএমএল পেজ তৈরি করতে হয়,

create_customers.htm


<!DOCTYPE html>
 <html>
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script>
 <body>
 
 <div appml-data="appml.aspx?model=create_customers"></div>
 
 </body>
 </html>

 

এইচটিএমএল পেজটিকে ওয়েব ব্রাউজারে চালু করতে হয়।

 

 

এপ্লিকেশন তৈরি করা

কাস্টমার এপ্লিকেশনের মডেল তৈরি করে তাকে customers.js নাম দিয়ে সংরক্ষণ করতে হয়।

 

customers.js


{
 "rowsperpage" : 10,
 "database" : {
     "connection" : "mydatabase",
     "sql" : "SELECT * FROM Customers",
     "orderby" : "CustomerName"
 }
 }

 

 

এইচটিএমএল পেজ তৈরি করে তাতে কাস্টমার এপ্লিকেশন রান করাতে হয়,

customers.htm


<!DOCTYPE html>
 <html lang="en">
 <title>Customers</title>
 <link rel="stylesheet" href= "http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script> 
 <body>
 
 <div class="container" appml-data="appml.aspx?model=customers">
 <h1>Customers</h1>
 <table class="table table-striped table-bordered">
   <tr>
     <th>Customer</th>
     <th>City</th>
     <th>Country</th>
 </tr>
   <tr appml-repeat="records">
     <td>{{CustomerName}}</td>
     <td>{{City}}</td>
     <td>{{Country}}</td>
 </tr>
 </table>
 </div>
 
 </body>
</html>

 

 

 

 

অ্যাপ এম এল পিএইচপি (AppML PHP)

রিদওয়ান বিন শামীম

 

যদি কোনও পিএইচপি ডাটাবেসে প্রবেশযোগ্যতা থাকে তাহলে তাহলে নিচের নির্দেশ মোতাবেক অ্যাপ এম এল সার্ভার এপ্লিকেশন তৈরি করা সম্ভব হবে। পিএইচপি ডাটাবেসে প্রবেশযোগ্যতা না থাকলে ওয়েবম্যাট্রিক্সের জন্য প্রযোজ্য উপদেশ দেখতে হবে।

 

টেস্ট পেজ তৈরি করা

টেস্ট পেজ তৈরি করে customers.htm রূপে (বা অন্যকোনও রূপে) পিএইপি সার্ভারে সংরক্ষণ করতে হবে।

customers.htm


 <!DOCTYPE html>
 <html lang="en">
 <title>Customers</title>
 <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script>
 <body>
 
 <div class="container" appml-data="customers">
 <h1>Customers</h1>
 <table class="table table-striped table-bordered">
 <tr>
     <th>Customer</th>
     <th>City</th>
     <th>Country</th>
 </tr>
 <tr appml-repeat="records">
     <td>{{CustomerName}}</td>
     <td>{{City}}    </td>
     <td>{{Country}} </td>
 </tr>
 </table>
 </div>
 
 <script>
 var customers = {
 "records":[
 {"CustomerName":"Alfreds Futterkiste","City":"Berlin","Country":"Germany"},
 {"CustomerName":"Ana Trujillo Emparedados y helados","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Antonio Moreno Taquería","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Around the Horn","City":"London","Country":"UK"},
 {"CustomerName":"B's Beverages","City":"London","Country":"UK"},
 {"CustomerName":"Berglunds snabbköp","City":"Luleå","Country":"Sweden"},
 {"CustomerName":"Blauer See Delikatessen","City":"Mannheim","Country":"Germany"},
 {"CustomerName":"Blondel père et fils","City":"Strasbourg","Country":"France"},
 {"CustomerName":"Bólido Comidas preparadas","City":"Madrid","Country":"Spain"},
 {"CustomerName":"Bon app'","City":"Marseille","Country":"France"},
 {"CustomerName":"Bottom-Dollar Marketse","City":"Tsawassen","Country":"Canada"},
 {"CustomerName":"Cactus Comidas para llevar","City":"Buenos Aires","Country":"Argentina"},
 {"CustomerName":"Centro comercial Moctezuma","City":"México D.F.","Country":"Mexico"},
 {"CustomerName":"Chop-suey Chinese","City":"Bern","Country":"Switzerland"},
 {"CustomerName":"Comércio Mineiro","City":"São Paulo","Country":"Brazil"}
 ]};
 </script>
 
 </body>
</html>

 

ব্রাউজারে সেই ওয়েবপেজটি পরীক্ষা করে দেখতে হয়।

 

একটি ডাটাবেস কানেকশন তৈরি করতে হয়

পিএইচপি ডাটাবেসে প্রবেশযোগ্যতা থাকে তাহলে তাহলে নিচের নির্দেশ মোতাবেক অ্যাপ এম এল ডাটাবেস কানেকশন তৈরি করতে হয়। এক্ষেত্রেও পিএইচপি ডাটাবেসে প্রবেশযোগ্যতা না থাকলে ওয়েবম্যাট্রিক্সের জন্য প্রযোজ্য উপদেশ দেখতে হবে। ডাটাবেস কানেকশন তৈরি করে সার্ভারে appml_config.php নামে সংরক্ষণ করতে হয়,

 

appml_config.php


<?php echo("Access Forbidden");exit();?>
 {
 "dateformat" : "yyyy-mm-dd",
 "databases" : [{
     "connection" : "mydatabase",
     "host" : "localhost",
     "dbname" : "DemoDB",
     "username" : "DemoDBUkbn5",
     "password" : "l6|U6=V(*T+P" 
 }]
 }

 

উপরে বিবৃত কানেকশন বাস্তব নয়, নাম আর পাসওয়ার্ড উদাহরণমাত্র।

 

কনফিগারেশন ফাইলের বিস্তারিত

 

বৈশিষ্ট্য বর্ণনা
ডাটা ফরম্যাট মডেলে যে ডাটা ফরম্যাট ব্যবহৃত হবে
কানেকশন মডেলে যে কানেকশন ব্যবহৃত হবে
হোস্ট ডাটাবেসের আইপি হোস্ট
dbname ডাটাবেসের নাম
username ডাটাবেসের ইউজার নেম
password ডাটাবেসের পাসওয়ার্ড

 

create_customers.js


{
“database” : {
“connection” : “mydatabase”,
“execute” : [
“DROP TABLE IF EXISTS Customers”,
“CREATE TABLE IF NOT EXISTS Customers (CustomerID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,(CustomerID),CustomerName NVARCHAR(255),ContactName NVARCHAR(255),Address NVARCHAR(255),City NVARCHAR(255),PostalCode NVARCHAR(255),Country NVARCHAR(255))”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Alfreds Futterkiste\”,\”Maria Anders\”,\”Obere Str. 57\”,\”Berlin\”,\”12209\”,\”Germany\”)”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Around the Horn\”,\”Thomas Hardy\”,\”120 Hanover Sq.\”,\”London\”,\”WA1 1DP\”,\”UK\”)”,
“INSERT INTO Customers(CustomerName,ContactName,Address,City,PostalCode,Country)VALUES (\”Blauer See Delikatessen\”,\”Hanna Moos\”,\”Forsterstr. 57\”,\”Mannheim\”,\”68306\”,\”Germany\”)”
]
}}


 

create_customers.js model চালানোর জন্য এইচটিএমএল পেজ তৈরি করতে হয়,

create_customers.htm


 <!DOCTYPE html>
 <html>
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script>
 <body>
 
 <div appml-data="appml.php?model=create_customers"></div>
 
 </body>
 </html>

 

এখন ব্রাউজারে এইচটিএমএল পেজটি চালাতে হবে।

 

এপ্লিকেশন মডেল তৈরি করা

কাস্টমারের এপ্লিকেশনের জন্য মডেল তৈরি করতে হয়। এটিকে customers.js নাম দিতে হবে।

customers.js


{
 "rowsperpage" : 10,
 "database" : {
     "connection" : "mydatabase",
     "sql" : "SELECT * FROM Customers",
     "orderby" : "CustomerName"
 }
 }

 

কাস্টমারের এপ্লিকেশন রান করানোর জন্য এইচটিএমএল পেজ তৈরি করতে হবে,

 

customers.htm


<!DOCTYPE html>
 <html lang="en">
 <title>Customers</title>
 <link rel="stylesheet" href="http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css">
 <script src="http://www.w3schools.com/appml/2.0.3/appml.js"></script>
 <body>
 
 <div class="container" appml-data="appml.php?model=customers">
 <h1>Customers</h1>
 <table class="table table-striped table-bordered">
   <tr>
     <th>Customer</th>
     <th>City</th>
     <th>Country</th>
 </tr>
   <tr appml-repeat="records">
     <td>{{CustomerName}}</td>
     <td>{{City}}</td>
     <td>{{Country}}</td>
 </tr>
 </table>
 </div>
 
 </body>
</html>

 

 

অ্যাপ এম এল ডাটাবেস (AppML Database)

আপনার নিজের ওয়েব SQL ডাটাবেস তৈরি করুন

নীচের ছোট ইউটিলিটি ব্যবহার করে, AppML ব্যবহার করে আপনি আপনার নিজের ওয়েব SQL ডাটাবেস তৈরি করতে পারেন।

নিজেই নিজের এসকিউএল লিখুন, অথবা প্রদত্ত এসকিউএল ব্যবহার করুন:

নোটঃ ওয়েব এসকিউএল শুধুমাত্র ক্রোম এবং সাফারি ব্রাউজারে কাজ করে।

কাস্টোমার


DROP TABLE IF EXISTS Customers;
CREATE TABLE IF NOT EXISTS Customers (CustomerID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,CustomerName NVARCHAR(255),ContactName NVARCHAR(255),Address NVARCHAR(255),City NVARCHAR(255),PostalCode NVARCHAR(255),Country NVARCHAR(255));
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Alfreds Futterkiste”,”Maria Anders”,”Obere Str. 57″,”Berlin”,”12209″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Ana Trujillo Emparedados y helados”,”Ana Trujillo”,”Avda. de la Constitución 2222″,”México D.F.”,”05021″,”Mexico”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Antonio Moreno Taquería”,”Antonio Moreno”,”Mataderos 2312″,”México D.F.”,”05023″,”Mexico”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Around the Horn”,”Thomas Hardy”,”120 Hanover Sq.”,”London”,”WA1 1DP”,”UK”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Berglunds snabbköp”,”Christina Berglund”,”Berguvsvägen 8″,”Luleå”,”S-958 22″,”Sweden”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Blauer See Delikatessen”,”Hanna Moos”,”Forsterstr. 57″,”Mannheim”,”68306″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Blondel père et fils”,”Frédérique Citeaux”,”24, place Kléber”,”Strasbourg”,”67000″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Bólido Comidas preparadas”,”Martín Sommer”,”C/ Araquil, 67″,”Madrid”,”28023″,”Spain”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Bon app'”,”Laurence Lebihans”,”12, rue des Bouchers”,”Marseille”,”13008″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Bottom-Dollar Marketse”,”Elizabeth Lincoln”,”23 Tsawassen Blvd.”,”Tsawassen”,”T2F 8M4″,”Canada”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“B’s Beverages”,”Victoria Ashworth”,”Fauntleroy Circus”,”London”,”EC2 5NT”,”UK”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Cactus Comidas para llevar”,”Patricio Simpson”,”Cerrito 333″,”Buenos Aires”,”1010″,”Argentina”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Centro comercial Moctezuma”,”Francisco Chang”,”Sierras de Granada 9993″,”México D.F.”,”05022″,”Mexico”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Chop-suey Chinese”,”Yang Wang”,”Hauptstr. 29″,”Bern”,”3012″,”Switzerland”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Comércio Mineiro”,”Pedro Afonso”,”Av. dos Lusíadas, 23″,”São Paulo”,”05432-043″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Consolidated Holdings”,”Elizabeth Brown”,”Berkeley Gardens 12 Brewery “,”London”,”WX1 6LT”,”UK”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Drachenblut Delikatessend”,”Sven Ottlieb”,”Walserweg 21″,”Aachen”,”52066″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Du monde entier”,”Janine Labrune”,”67, rue des Cinquante Otages”,”Nantes”,”44000″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Eastern Connection”,”Ann Devon”,”35 King George”,”London”,”WX3 6FW”,”UK”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Ernst Handel”,”Roland Mendel”,”Kirchgasse 6″,”Graz”,”8010″,”Austria”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Familia Arquibaldo”,”Aria Cruz”,”Rua Orós, 92″,”São Paulo”,”05442-030″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“FISSA Fabrica Inter. Salchichas S.A.”,”Diego Roel”,”C/ Moralzarzal, 86″,”Madrid”,”28034″,”Spain”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Folies gourmandes”,”Martine Rancé”,”184, chaussée de Tournai”,”Lille”,”59000″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Folk och fä HB”,”Maria Larsson”,”Åkergatan 24″,”Bräcke”,”S-844 67″,”Sweden”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Frankenversand”,”Peter Franken”,”Berliner Platz 43″,”München”,”80805″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“France restauration”,”Carine Schmitt”,”54, rue Royale”,”Nantes”,”44000″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Franchi S.p.A.”,”Paolo Accorti”,”Via Monte Bianco 34″,”Torino”,”10100″,”Italy”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Furia Bacalhau e Frutos do Mar”,”Lino Rodriguez “,”Jardim das rosas n. 32″,”Lisboa”,”1675″,”Portugal”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Galería del gastrónomo”,”Eduardo Saavedra”,”Rambla de Cataluña, 23″,”Barcelona”,”08022″,”Spain”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Godos Cocina Típica”,”José Pedro Freyre”,”C/ Romero, 33″,”Sevilla”,”41101″,”Spain”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Gourmet Lanchonetes”,”André Fonseca”,”Av. Brasil, 442″,”Campinas”,”04876-786″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Great Lakes Food Market”,”Howard Snyder”,”2732 Baker Blvd.”,”Eugene”,”97403″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“GROSELLA-Restaurante”,”Manuel Pereira”,”5ª Ave. Los Palos Grandes”,”Caracas”,”1081″,”Venezuela”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Hanari Carnes”,”Mario Pontes”,”Rua do Paço, 67″,”Rio de Janeiro”,”05454-876″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“HILARIÓN-Abastos”,”Carlos Hernández”,”Carrera 22 con Ave. Carlos Soublette #8-35″,”San Cristóbal”,”5022″,”Venezuela”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Hungry Coyote Import Store”,”Yoshi Latimer”,”City Center Plaza 516 Main St.”,”Elgin”,”97827″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Hungry Owl All-Night Grocers”,”Patricia McKenna”,”8 Johnstown Road”,”Cork”,””,”Ireland”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Island Trading”,”Helen Bennett”,”Garden House Crowther Way”,”Cowes”,”PO31 7PJ”,”UK”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Königlich Essen”,”Philip Cramer”,”Maubelstr. 90″,”Brandenburg”,”14776″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“La corne d’abondance”,”Daniel Tonini”,”67, avenue de l’Europe”,”Versailles”,”78000″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“La maison d’Asie”,”Annette Roulet”,”1 rue Alsace-Lorraine”,”Toulouse”,”31000″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Laughing Bacchus Wine Cellars”,”Yoshi Tannamuri”,”1900 Oak St.”,”Vancouver”,”V3F 2K1″,”Canada”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Lazy K Kountry Store”,”John Steel”,”12 Orchestra Terrace”,”Walla Walla”,”99362″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Lehmanns Marktstand”,”Renate Messner”,”Magazinweg 7″,”Frankfurt a.M. “,”60528″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Let’s Stop N Shop”,”Jaime Yorres”,”87 Polk St. Suite 5″,”San Francisco”,”94117″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“LILA-Supermercado”,”Carlos González”,”Carrera 52 con Ave. Bolívar #65-98 Llano Largo”,”Barquisimeto”,”3508″,”Venezuela”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“LINO-Delicateses”,”Felipe Izquierdo”,”Ave. 5 de Mayo Porlamar”,”I. de Margarita”,”4980″,”Venezuela”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Lonesome Pine Restaurant”,”Fran Wilson”,”89 Chiaroscuro Rd.”,”Portland”,”97219″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Magazzini Alimentari Riuniti”,”Giovanni Rovelli”,”Via Ludovico il Moro 22″,”Bergamo”,”24100″,”Italy”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Maison Dewey”,”Catherine Dewey”,”Rue Joseph-Bens 532″,”Bruxelles”,”B-1180″,”Belgium”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Mère Paillarde”,”Jean Fresnière”,”43 rue St. Laurent”,”Montréal”,”H1J 1C3″,”Canada”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Morgenstern Gesundkost”,”Alexander Feuer”,”Heerstr. 22″,”Leipzig”,”04179″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“North/South”,”Simon Crowther”,”South House 300 Queensbridge”,”London”,”SW7 1RZ”,”UK”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Océano Atlántico Ltda.”,”Yvonne Moncada”,”Ing. Gustavo Moncada 8585 Piso 20-A”,”Buenos Aires”,”1010″,”Argentina”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Old World Delicatessen”,”Rene Phillips”,”2743 Bering St.”,”Anchorage”,”99508″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Ottilies Käseladen”,”Henriette Pfalzheim”,”Mehrheimerstr. 369″,”Köln”,”50739″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Paris spécialités”,”Marie Bertrand”,”265, boulevard Charonne”,”Paris”,”75012″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Pericles Comidas clásicas”,”Guillermo Fernández”,”Calle Dr. Jorge Cash 321″,”México D.F.”,”05033″,”Mexico”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Piccolo und mehr”,”Georg Pipps”,”Geislweg 14″,”Salzburg”,”5020″,”Austria”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Princesa Isabel Vinhoss”,”Isabel de Castro”,”Estrada da saúde n. 58″,”Lisboa”,”1756″,”Portugal”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Que Delícia”,”Bernardo Batista”,”Rua da Panificadora, 12″,”Rio de Janeiro”,”02389-673″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Queen Cozinha”,”Lúcia Carvalho”,”Alameda dos Canàrios, 891″,”São Paulo”,”05487-020″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“QUICK-Stop”,”Horst Kloss”,”Taucherstraße 10″,”Cunewalde”,”01307″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Rancho grande”,”Sergio Gutiérrez”,”Av. del Libertador 900″,”Buenos Aires”,”1010″,”Argentina”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Rattlesnake Canyon Grocery”,”Paula Wilson”,”2817 Milton Dr.”,”Albuquerque”,”87110″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Reggiani Caseifici”,”Maurizio Moroni”,”Strada Provinciale 124″,”Reggio Emilia”,”42100″,”Italy”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Ricardo Adocicados”,”Janete Limeira”,”Av. Copacabana, 267″,”Rio de Janeiro”,”02389-890″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Richter Supermarkt”,”Michael Holz”,”Grenzacherweg 237″,”Genève”,”1203″,”Switzerland”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Romero y tomillo”,”Alejandra Camino”,”Gran Vía, 1″,”Madrid”,”28001″,”Spain”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Santé Gourmet”,”Jonas Bergulfsen”,”Erling Skakkes gate 78″,”Stavern”,”4110″,”Norway”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Save-a-lot Markets”,”Jose Pavarotti”,”187 Suffolk Ln.”,”Boise”,”83720″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Seven Seas Imports”,”Hari Kumar”,”90 Wadhurst Rd.”,”London”,”OX15 4NB”,”UK”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Simons bistro”,”Jytte Petersen”,”Vinbæltet 34″,”København”,”1734″,”Denmark”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Spécialités du monde”,”Dominique Perrier”,”25, rue Lauriston”,”Paris”,”75016″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Split Rail Beer & Ale”,”Art Braunschweiger”,”P.O. Box 555″,”Lander”,”82520″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Suprêmes délices”,”Pascale Cartrain”,”Boulevard Tirou, 255″,”Charleroi”,”B-6000″,”Belgium”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“The Big Cheese”,”Liz Nixon”,”89 Jefferson Way Suite 2″,”Portland”,”97201″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“The Cracker Box”,”Liu Wong”,”55 Grizzly Peak Rd.”,”Butte”,”59801″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Toms Spezialitäten”,”Karin Josephs”,”Luisenstr. 48″,”Münster”,”44087″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Tortuga Restaurante”,”Miguel Angel Paolino”,”Avda. Azteca 123″,”México D.F.”,”05033″,”Mexico”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Tradição Hipermercados”,”Anabela Domingues”,”Av. Inês de Castro, 414″,”São Paulo”,”05634-030″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Trail’s Head Gourmet Provisioners”,”Helvetius Nagy”,”722 DaVinci Blvd.”,”Kirkland”,”98034″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Vaffeljernet”,”Palle Ibsen”,”Smagsløget 45″,”Århus”,”8200″,”Denmark”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Victuailles en stock”,”Mary Saveley”,”2, rue du Commerce”,”Lyon”,”69004″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Vins et alcools Chevalier”,”Paul Henriot”,”59 rue de l’Abbaye”,”Reims”,”51100″,”France”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Die Wandernde Kuh”,”Rita Müller”,”Adenauerallee 900″,”Stuttgart”,”70563″,”Germany”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Wartian Herkku”,”Pirkko Koskitalo”,”Torikatu 38″,”Oulu”,”90110″,”Finland”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Wellington Importadora”,”Paula Parente”,”Rua do Mercado, 12″,”Resende”,”08737-363″,”Brazil”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“White Clover Markets”,”Karl Jablonski”,”305 – 14th Ave. S. Suite 3B”,”Seattle”,”98128″,”USA”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Wilman Kala”,”Matti Karttunen”,”Keskuskatu 45″,”Helsinki”,”21240″,”Finland”);
INSERT INTO Customers (CustomerName,ContactName,Address,City,PostalCode,Country)
VALUES (“Wolski”,”Zbyszek”,”ul. Filtrowa 68″,”Walla”,”01-012″,”Poland”);


 

পণ্য


DROP TABLE IF EXISTS Products;
CREATE TABLE IF NOT EXISTS Products
(ProductID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,ProductName NVARCHAR(255),SupplierID INT,CategoryID INT,Unit NVARCHAR(255),Price DECIMAL(10,2));
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (1,"Chais",1,1,"10 boxes x 20 bags",18);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (2,"Chang",1,1,"24 - 12 oz bottles",19);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (3,"Aniseed Syrup",1,2,"12 - 550 ml bottles",10);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (4,"Chef Anton's Cajun Seasoning",2,2,"48 - 6 oz jars",22);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (5,"Chef Anton's Gumbo Mix",2,2,"36 boxes",21.35);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (6,"Grandma's Boysenberry Spread",3,2,"12 - 8 oz jars",25);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (7,"Uncle Bob's Organic Dried Pears",3,7,"12 - 1 lb pkgs.",30);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (8,"Northwoods Cranberry Sauce",3,2,"12 - 12 oz jars",40);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (9,"Mishi Kobe Niku",4,6,"18 - 500 g pkgs.",97);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (10,"Ikura",4,8,"12 - 200 ml jars",31);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (11,"Queso Cabrales",5,4,"1 kg pkg.",21);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (12,"Queso Manchego La Pastora",5,4,"10 - 500 g pkgs.",38);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (13,"Konbu",6,8,"2 kg box",6);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (14,"Tofu",6,7,"40 - 100 g pkgs.",23.25);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (15,"Genen Shouyu",6,2,"24 - 250 ml bottles",15.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (16,"Pavlova",7,3,"32 - 500 g boxes",17.45);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (17,"Alice Mutton",7,6,"20 - 1 kg tins",39);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (18,"Carnarvon Tigers",7,8,"16 kg pkg.",62.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (19,"Teatime Chocolate Biscuits",8,3,"10 boxes x 12 pieces",9.2);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (20,"Sir Rodney's Marmalade",8,3,"30 gift boxes",81);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (21,"Sir Rodney's Scones",8,3,"24 pkgs. x 4 pieces",10);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (22,"Gustaf's Knäckebröd",9,5,"24 - 500 g pkgs.",21);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (23,"Tunnbröd",9,5,"12 - 250 g pkgs.",9);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (24,"Guaraná Fantástica",10,1,"12 - 355 ml cans",4.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (25,"NuNuCa Nuß-Nougat-Creme",11,3,"20 - 450 g glasses",14);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (26,"Gumbär Gummibärchen",11,3,"100 - 250 g bags",31.23);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (27,"Schoggi Schokolade",11,3,"100 - 100 g pieces",43.9);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (28,"Rössle Sauerkraut",12,7,"25 - 825 g cans",45.6);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (29,"Thüringer Rostbratwurst",12,6,"50 bags x 30 sausgs.",123.79);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (30,"Nord-Ost Matjeshering",13,8,"10 - 200 g glasses",25.89);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (31,"Gorgonzola Telino",14,4,"12 - 100 g pkgs",12.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (32,"Mascarpone Fabioli",14,4,"24 - 200 g pkgs.",32);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (33,"Geitost",15,4,"500 g",2.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (34,"Sasquatch Ale",16,1,"24 - 12 oz bottles",14);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (35,"Steeleye Stout",16,1,"24 - 12 oz bottles",18);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (36,"Inlagd Sill",17,8,"24 - 250 g jars",19);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (37,"Gravad lax",17,8,"12 - 500 g pkgs.",26);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (38,"Côte de Blaye",18,1,"12 - 75 cl bottles",263.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (39,"Chartreuse verte",18,1,"750 cc per bottle",18);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (40,"Boston Crab Meat",19,8,"24 - 4 oz tins",18.4);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (41,"Jack's New England Clam Chowder",19,8,"12 - 12 oz cans",9.65);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (42,"Singaporean Hokkien Fried Mee",20,5,"32 - 1 kg pkgs.",14);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (43,"Ipoh Coffee",20,1,"16 - 500 g tins",46);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (44,"Gula Malacca",20,2,"20 - 2 kg bags",19.45);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (45,"Røgede sild",21,8,"1k pkg.",9.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (46,"Spegesild",21,8,"4 - 450 g glasses",12);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (47,"Zaanse koeken",22,3,"10 - 4 oz boxes",9.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (48,"Chocolade",22,3,"10 pkgs.",12.75);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (49,"Maxilaku",23,3,"24 - 50 g pkgs.",20);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (50,"Valkoinen suklaa",23,3,"12 - 100 g bars",16.25);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (51,"Manjimup Dried Apples",24,7,"50 - 300 g pkgs.",53);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (52,"Filo Mix",24,5,"16 - 2 kg boxes",7);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (53,"Perth Pasties",24,6,"48 pieces",32.8);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (54,"Tourtière",25,6,"16 pies",7.45);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (55,"Pâté chinois",25,6,"24 boxes x 2 pies",24);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (56,"Gnocchi di nonna Alice",26,5,"24 - 250 g pkgs.",38);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (57,"Ravioli Angelo",26,5,"24 - 250 g pkgs.",19.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (58,"Escargots de Bourgogne",27,8,"24 pieces",13.25);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (59,"Raclette Courdavault",28,4,"5 kg pkg.",55);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (60,"Camembert Pierrot",28,4,"15 - 300 g rounds",34);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (61,"Sirop d'érable",29,2,"24 - 500 ml bottles",28.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (62,"Tarte au sucre",29,3,"48 pies",49.3);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (63,"Vegie-spread",7,2,"15 - 625 g jars",43.9);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (64,"Wimmers gute Semmelknödel",12,5,"20 bags x 4 pieces",33.25);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (65,"Louisiana Fiery Hot Pepper Sauce",2,2,"32 - 8 oz bottles",21.05);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (66,"Louisiana Hot Spiced Okra",2,2,"24 - 8 oz jars",17);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (67,"Laughing Lumberjack Lager",16,1,"24 - 12 oz bottles",14);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (68,"Scottish Longbreads",8,3,"10 boxes x 8 pieces",12.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (69,"Gudbrandsdalsost",15,4,"10 kg pkg.",36);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (70,"Outback Lager",7,1,"24 - 355 ml bottles",15);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (71,"Fløtemysost",15,4,"10 - 500 g pkgs.",21.5);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (72,"Mozzarella di Giovanni",14,4,"24 - 200 g pkgs.",34.8);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (73,"Röd Kaviar",17,8,"24 - 150 g jars",15);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (74,"Longlife Tofu",4,7,"5 kg pkg.",10);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (75,"Rhönbräu Klosterbier",12,1,"24 - 0.5 l bottles",7.75);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (76,"Lakkalikööri",23,1,"500 ml ",18);
INSERT INTO Products (ProductID,ProductName,SupplierID,CategoryID,Unit,Price)
VALUES (77,"Original Frankfurter grüne Soße",12,2,"12 boxes",13);

 

 

সরবরাহকারী


DROP TABLE IF EXISTS Suppliers;
CREATE TABLE Suppliers (SupplierID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,SupplierName NVARCHAR(255),ContactName NVARCHAR(255),Address NVARCHAR(255),City NVARCHAR(255),PostalCode NVARCHAR(255),Country NVARCHAR(255),Phone NVARCHAR(255));
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Exotic Liquid”,”Charlotte Cooper”,”49 Gilbert St.”,”Londona”,”EC1 4SD”,”UK”,”(171) 555-2222″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“New Orleans Cajun Delights”,”Shelley Burke”,”P.O. Box 78934″,”New Orleans”,”70117″,”USA”,”(100) 555-4822″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Grandma Kelly’s Homestead”,”Regina Murphy”,”707 Oxford Rd.”,”Ann Arbor”,”48104″,”USA”,”(313) 555-5735″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Tokyo Traders”,”Yoshi Nagase”,”9-8 Sekimai Musashino-shi”,”Tokyo”,”100″,”Japan”,”(03) 3555-5011″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Cooperativa de Quesos ‘Las Cabras'”,”Antonio del Valle Saavedra “,”Calle del Rosal 4″,”Oviedo”,”33007″,”Spain”,”(98) 598 76 54″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Mayumi’s”,”Mayumi Ohno”,”92 Setsuko Chuo-ku”,”Osaka”,”545″,”Japan”,”(06) 431-7877″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Pavlova, Ltd.”,”Ian Devling”,”74 Rose St. Moonie Ponds”,”Melbourne”,”3058″,”Australia”,”(03) 444-2343″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Specialty Biscuits, Ltd.”,”Peter Wilson”,”29 King’s Way”,”Manchester”,”M14 GSD”,”UK”,”(161) 555-4448″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“PB Knäckebröd AB”,”Lars Peterson”,”Kaloadagatan 13″,”Göteborg”,”S-345 67″,”Sweden “,”031-987 65 43”);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Refrescos Americanas LTDA”,”Carlos Diaz”,”Av. das Americanas 12.890″,”São Paulo”,”5442″,”Brazil”,”(11) 555 4640″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Heli Süßwaren GmbH & Co. KG”,”Petra Winkler”,”Tiergartenstraße 5″,”Berlin”,”10785″,”Germany”,”(010) 9984510″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Plutzer Lebensmittelgroßmärkte AG”,”Martin Bein”,”Bogenallee 51″,”Frankfurt”,”60439″,”Germany”,”(069) 992755″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Nord-Ost-Fisch Handelsgesellschaft mbH”,”Sven Petersen”,”Frahmredder 112a”,”Cuxhaven”,”27478″,”Germany”,”(04721) 8713″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Formaggi Fortini s.r.l.”,”Elio Rossi”,”Viale Dante, 75″,”Ravenna”,”48100″,”Italy”,”(0544) 60323″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Norske Meierier”,”Beate Vileid”,”Hatlevegen 5″,”Sandvika”,”1320″,”Norway”,”(0)2-953010″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Bigfoot Breweries”,”Cheryl Saylor”,”3400 – 8th Avenue Suite 210″,”Bend”,”97101″,”USA”,”(503) 555-9931″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Svensk Sjöföda AB”,”Michael Björn”,”Brovallavägen 231″,”Stockholm”,”S-123 45″,”Sweden”,”08-123 45 67″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Aux joyeux ecclésiastiques”,”Guylène Nodier”,”203, Rue des Francs-Bourgeois”,”Paris”,”75004″,”France”,”(1) 03.83.00.68″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“New England Seafood Cannery”,”Robb Merchant”,”Order Processing Dept. 2100 Paul Revere Blvd.”,”Boston”,”02134″,”USA”,”(617) 555-3267″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Leka Trading”,”Chandra Leka”,”471 Serangoon Loop, Suite #402″,”Singapore”,”0512″,”Singapore”,”555-8787″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Lyngbysild”,”Niels Petersen”,”Lyngbysild Fiskebakken 10″,”Lyngby”,”2800″,”Denmark”,”43844108″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Zaanse Snoepfabriek”,”Dirk Luchte”,”Verkoop Rijnweg 22″,”Zaandam”,”9999 ZZ”,”Netherlands”,”(12345) 1212″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Karkki Oy”,”Anne Heikkonen”,”Valtakatu 12″,”Lappeenranta”,”53120″,”Finland”,”(953) 10956″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“G’day, Mate”,”Wendy Mackenzie”,”170 Prince Edward Parade Hunter’s Hill”,”Sydney”,”2042″,”Australia”,”(02) 555-5914″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Ma Maison”,”Jean-Guy Lauzon”,”2960 Rue St. Laurent”,”Montréal”,”H1J 1C3″,”Canada”,”(514) 555-9022″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Pasta Buttini s.r.l.”,”Giovanni Giudici”,”Via dei Gelsomini, 153″,”Salerno”,”84100″,”Italy”,”(089) 6547665″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Escargots Nouveaux”,”Marie Delamare”,”22, rue H. Voiron”,”Montceau”,”71300″,”France”,”85.57.00.07″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Gai pâturage”,”Eliane Noz”,”Bat. B 3, rue des Alpes”,”Annecy”,”74000″,”France”,”38.76.98.06″);
INSERT INTO Suppliers (SupplierName,ContactName,Address,City,PostalCode,Country,Phone) VALUES (“Forêts d’érables”,”Chantal Goulet”,”148 rue Chasseur”,”Ste-Hyacinthe”,”J2S 7S8″,”Canada”,”(514) 555-2955″);


 

 

শ্রেণীবিভাগ


DROP TABLE IF EXISTS Categories;
CREATE TABLE Categories (CategoryID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,CategoryName NVARCHAR(255),Description NVARCHAR(255));
INSERT INTO Categories (CategoryID,CategoryName,Description) VALUES (1,”Beverages”,”Soft drinks, coffees, teas, beers, and ales”);
INSERT INTO Categories (CategoryID,CategoryName,Description) VALUES (2,”Condiments”,”Sweet and savory sauces, relishes, spreads, and seasonings”);
INSERT INTO Categories (CategoryID,CategoryName,Description) VALUES (3,”Confections”,”Desserts, candies, and sweet breads”);
INSERT INTO Categories (CategoryID,CategoryName,Description) VALUES (4,”Dairy Products”,”Cheeses”);
INSERT INTO Categories (CategoryID,CategoryName,Description) VALUES (5,”Grains/Cereals”,”Breads, crackers, pasta, and cereal”);
INSERT INTO Categories (CategoryID,CategoryName,Description) VALUES (6,”Meat/Poultry”,”Prepared meats”);
INSERT INTO Categories (CategoryID,CategoryName,Description) VALUES (7,”Produce”,”Dried fruit and bean curd”);
INSERT INTO Categories (CategoryID,CategoryName,Description) VALUES (8,”Seafood”,”Seaweed and fish”);


 

 

চাকুরীরত ব্যক্তি


DROP TABLE IF EXISTS Employees;
CREATE TABLE Employees (EmployeeID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,LastName NVARCHAR(255),FirstName NVARCHAR(255),BirthDate DATE,Photo NVARCHAR(255),Notes LONGTEXT);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (1,”Davolio”,”Nancy”,”1968-12-08″,”EmpID1.pic”,”Education includes a BA in psychology from Colorado State University. She also completed (The Art of the Cold Call). Nancy is a member of ‘Toastmasters International’.”);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (2,”Fuller02-19″,”EmpID2.pic”,”Andrew received his BTS commercial and a Ph.D. in international marketing from the University of Dallas. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.”);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (3,”Leverling”,”Janet”,”1963-08-30″,”EmpID3.pic”,”Janet has a BS degree in chemistry from Boston College). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate and was promoted to sales representative.”);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (4,”Peacock”,”Margaret”,”1958-09-19″,”EmpID4.pic”,”Margaret holds a BA in English literature from Concordia College and an MA from the American Institute of Culinary Arts. She was temporarily assigned to the London office before returning to her permanent post in Seattle.”);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (5,”Buchanan”,”Steven”,”1955-03-04″,”EmpID5.pic”,”Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree. Upon joining the company as a sales representative, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London, where he was promoted to sales manager. Mr. Buchanan has completed the courses ‘Successful Telemarketing’ and ‘International Sales Management’. He is fluent in French.”);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (6,”Suyama”,”Michael”,”1963-07-02″,”EmpID6.pic”,”Michael is a graduate of Sussex University (MA, economics) and the University of California at Los Angeles (MBA, marketing). He has also taken the courses ‘Multi-Cultural Selling’ and ‘Time Management for the Sales Professional’. He is fluent in Japanese and can read and write French, Portuguese, and Spanish.”);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (7,”King”,”Robert”,”1960-05-29″,”EmpID7.pic”,”Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan and then joining the company. After completing a course entitled ‘Selling in Europe’, he was transferred to the London office.”);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (8,”Callahan”,”Laura”,”1958-01-09″,”EmpID8.pic”,”Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French.”);
INSERT INTO Employees (EmployeeID,LastName,FirstName,BirthDate,Photo,Notes) VALUES (9,”Dodsworth”,”Anne”,”1969-07-02″,”EmpID9.pic”,”Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.”);


 

 

ক্রয় আদেশ


DROP TABLE IF EXISTS Orders;
CREATE TABLE Orders (OrderID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,CustomerID INT,EmployeeID INT,OrderDate DATE,ShipperID INT);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10248,90,5,”1996-07-04″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10249,81,6,”1996-07-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10250,34,4,”1996-07-08″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10251,84,3,”1996-07-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10252,76,4,”1996-07-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10253,34,3,”1996-07-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10254,14,5,”1996-07-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10255,68,9,”1996-07-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10256,88,3,”1996-07-15″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10257,35,4,”1996-07-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10258,20,1,”1996-07-17″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10259,13,4,”1996-07-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10260,55,4,”1996-07-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10261,61,4,”1996-07-19″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10262,65,8,”1996-07-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10263,20,9,”1996-07-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10264,24,6,”1996-07-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10265,7,2,”1996-07-25″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10266,87,3,”1996-07-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10267,25,4,”1996-07-29″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10268,33,8,”1996-07-30″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10269,89,5,”1996-07-31″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10270,87,1,”1996-08-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10271,75,6,”1996-08-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10272,65,6,”1996-08-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10273,63,3,”1996-08-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10274,85,6,”1996-08-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10275,49,1,”1996-08-07″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10276,80,8,”1996-08-08″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10277,52,2,”1996-08-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10278,5,8,”1996-08-12″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10279,44,8,”1996-08-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10280,5,2,”1996-08-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10281,69,4,”1996-08-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10282,69,4,”1996-08-15″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10283,46,3,”1996-08-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10284,44,4,”1996-08-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10285,63,1,”1996-08-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10286,63,8,”1996-08-21″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10287,67,8,”1996-08-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10288,66,4,”1996-08-23″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10289,11,7,”1996-08-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10290,15,8,”1996-08-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10291,61,6,”1996-08-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10292,81,1,”1996-08-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10293,80,1,”1996-08-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10294,65,4,”1996-08-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10295,85,2,”1996-09-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10296,46,6,”1996-09-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10297,7,5,”1996-09-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10298,37,6,”1996-09-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10299,67,4,”1996-09-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10300,49,2,”1996-09-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10301,86,8,”1996-09-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10302,76,4,”1996-09-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10303,30,7,”1996-09-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10304,80,1,”1996-09-12″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10305,55,8,”1996-09-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10306,69,1,”1996-09-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10307,48,2,”1996-09-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10308,2,7,”1996-09-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10309,37,3,”1996-09-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10310,77,8,”1996-09-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10311,18,1,”1996-09-20″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10312,86,2,”1996-09-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10313,63,2,”1996-09-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10314,65,1,”1996-09-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10315,38,4,”1996-09-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10316,65,1,”1996-09-27″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10317,48,6,”1996-09-30″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10318,38,8,”1996-10-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10319,80,7,”1996-10-02″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10320,87,5,”1996-10-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10321,38,3,”1996-10-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10322,58,7,”1996-10-04″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10323,39,4,”1996-10-07″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10324,71,9,”1996-10-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10325,39,1,”1996-10-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10326,8,4,”1996-10-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10327,24,2,”1996-10-11″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10328,28,4,”1996-10-14″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10329,75,4,”1996-10-15″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10330,46,3,”1996-10-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10331,9,9,”1996-10-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10332,51,3,”1996-10-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10333,87,5,”1996-10-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10334,84,8,”1996-10-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10335,37,7,”1996-10-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10336,60,7,”1996-10-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10337,25,4,”1996-10-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10338,55,4,”1996-10-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10339,51,2,”1996-10-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10340,9,1,”1996-10-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10341,73,7,”1996-10-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10342,25,4,”1996-10-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10343,44,4,”1996-10-31″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10344,89,4,”1996-11-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10345,63,2,”1996-11-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10346,65,3,”1996-11-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10347,21,4,”1996-11-06″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10348,86,4,”1996-11-07″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10349,75,7,”1996-11-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10350,41,6,”1996-11-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10351,20,1,”1996-11-11″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10352,28,3,”1996-11-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10353,59,7,”1996-11-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10354,58,8,”1996-11-14″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10355,4,6,”1996-11-15″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10356,86,6,”1996-11-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10357,46,1,”1996-11-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10358,41,5,”1996-11-20″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10359,72,5,”1996-11-21″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10360,7,4,”1996-11-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10361,63,1,”1996-11-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10362,9,3,”1996-11-25″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10363,17,4,”1996-11-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10364,19,1,”1996-11-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10365,3,3,”1996-11-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10366,29,8,”1996-11-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10367,83,7,”1996-11-28″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10368,20,2,”1996-11-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10369,75,8,”1996-12-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10370,14,6,”1996-12-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10371,41,1,”1996-12-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10372,62,5,”1996-12-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10373,37,4,”1996-12-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10374,91,1,”1996-12-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10375,36,3,”1996-12-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10376,51,1,”1996-12-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10377,72,1,”1996-12-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10378,24,5,”1996-12-10″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10379,61,2,”1996-12-11″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10380,37,8,”1996-12-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10381,46,3,”1996-12-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10382,20,4,”1996-12-13″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10383,4,8,”1996-12-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10384,5,3,”1996-12-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10385,75,1,”1996-12-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10386,21,9,”1996-12-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10387,70,1,”1996-12-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10388,72,2,”1996-12-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10389,10,4,”1996-12-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10390,20,6,”1996-12-23″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10391,17,3,”1996-12-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10392,59,2,”1996-12-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10393,71,1,”1996-12-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10394,36,1,”1996-12-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10395,35,6,”1996-12-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10396,25,1,”1996-12-27″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10397,60,5,”1996-12-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10398,71,2,”1996-12-30″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10399,83,8,”1996-12-31″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10400,19,1,”1997-01-01″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10401,65,1,”1997-01-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10402,20,8,”1997-01-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10403,20,4,”1997-01-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10404,49,2,”1997-01-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10405,47,1,”1997-01-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10406,62,7,”1997-01-07″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10407,56,2,”1997-01-07″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10408,23,8,”1997-01-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10409,54,3,”1997-01-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10410,10,3,”1997-01-10″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10411,10,9,”1997-01-10″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10412,87,8,”1997-01-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10413,41,3,”1997-01-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10414,21,2,”1997-01-14″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10415,36,3,”1997-01-15″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10416,87,8,”1997-01-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10417,73,4,”1997-01-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10418,63,4,”1997-01-17″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10419,68,4,”1997-01-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10420,88,3,”1997-01-21″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10421,61,8,”1997-01-21″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10422,27,2,”1997-01-22″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10423,31,6,”1997-01-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10424,51,7,”1997-01-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10425,41,6,”1997-01-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10426,29,4,”1997-01-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10427,59,4,”1997-01-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10428,66,7,”1997-01-28″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10429,37,3,”1997-01-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10430,20,4,”1997-01-30″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10431,10,4,”1997-01-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10432,75,3,”1997-01-31″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10433,60,3,”1997-02-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10434,24,3,”1997-02-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10435,16,8,”1997-02-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10436,7,3,”1997-02-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10437,87,8,”1997-02-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10438,79,3,”1997-02-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10439,51,6,”1997-02-07″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10440,71,4,”1997-02-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10441,55,3,”1997-02-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10442,20,3,”1997-02-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10443,66,8,”1997-02-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10444,5,3,”1997-02-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10445,5,3,”1997-02-13″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10446,79,6,”1997-02-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10447,67,4,”1997-02-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10448,64,4,”1997-02-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10449,7,3,”1997-02-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10450,84,8,”1997-02-19″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10451,63,4,”1997-02-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10452,71,8,”1997-02-20″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10453,4,1,”1997-02-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10454,41,4,”1997-02-21″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10455,87,8,”1997-02-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10456,39,8,”1997-02-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10457,39,2,”1997-02-25″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10458,76,7,”1997-02-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10459,84,4,”1997-02-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10460,24,8,”1997-02-28″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10461,46,1,”1997-02-28″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10462,16,2,”1997-03-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10463,76,5,”1997-03-04″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10464,28,4,”1997-03-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10465,83,1,”1997-03-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10466,15,4,”1997-03-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10467,49,8,”1997-03-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10468,39,3,”1997-03-07″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10469,89,1,”1997-03-10″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10470,9,4,”1997-03-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10471,11,2,”1997-03-11″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10472,72,8,”1997-03-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10473,38,1,”1997-03-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10474,58,5,”1997-03-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10475,76,9,”1997-03-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10476,35,8,”1997-03-17″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10477,60,5,”1997-03-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10478,84,2,”1997-03-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10479,65,3,”1997-03-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10480,23,6,”1997-03-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10481,67,8,”1997-03-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10482,43,1,”1997-03-21″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10483,89,7,”1997-03-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10484,11,3,”1997-03-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10485,47,4,”1997-03-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10486,35,1,”1997-03-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10487,62,2,”1997-03-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10488,25,8,”1997-03-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10489,59,6,”1997-03-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10490,35,7,”1997-03-31″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10491,28,8,”1997-03-31″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10492,10,3,”1997-04-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10493,41,4,”1997-04-02″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10494,15,4,”1997-04-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10495,42,3,”1997-04-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10496,81,7,”1997-04-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10497,44,7,”1997-04-04″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10498,35,8,”1997-04-07″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10499,46,4,”1997-04-08″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10500,41,6,”1997-04-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10501,6,9,”1997-04-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10502,58,2,”1997-04-10″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10503,37,6,”1997-04-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10504,89,4,”1997-04-11″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10505,51,3,”1997-04-14″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10506,39,9,”1997-04-15″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10507,3,7,”1997-04-15″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10508,56,1,”1997-04-16″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10509,6,4,”1997-04-17″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10510,71,6,”1997-04-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10511,9,4,”1997-04-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10512,21,7,”1997-04-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10513,86,7,”1997-04-22″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10514,20,3,”1997-04-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10515,63,2,”1997-04-23″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10516,37,2,”1997-04-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10517,53,3,”1997-04-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10518,80,4,”1997-04-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10519,14,6,”1997-04-28″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10520,70,7,”1997-04-29″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10521,12,8,”1997-04-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10522,44,4,”1997-04-30″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10523,72,7,”1997-05-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10524,5,1,”1997-05-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10525,9,1,”1997-05-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10526,87,4,”1997-05-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10527,63,7,”1997-05-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10528,32,6,”1997-05-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10529,50,5,”1997-05-07″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10530,59,3,”1997-05-08″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10531,54,7,”1997-05-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10532,19,7,”1997-05-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10533,24,8,”1997-05-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10534,44,8,”1997-05-12″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10535,3,4,”1997-05-13″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10536,44,3,”1997-05-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10537,68,1,”1997-05-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10538,11,9,”1997-05-15″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10539,11,6,”1997-05-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10540,63,3,”1997-05-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10541,34,2,”1997-05-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10542,39,1,”1997-05-20″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10543,46,8,”1997-05-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10544,48,4,”1997-05-21″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10545,43,8,”1997-05-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10546,84,1,”1997-05-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10547,72,3,”1997-05-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10548,79,3,”1997-05-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10549,63,5,”1997-05-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10550,30,7,”1997-05-28″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10551,28,4,”1997-05-28″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10552,35,2,”1997-05-29″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10553,87,2,”1997-05-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10554,56,4,”1997-05-30″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10555,71,6,”1997-06-02″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10556,73,2,”1997-06-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10557,44,9,”1997-06-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10558,4,1,”1997-06-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10559,7,6,”1997-06-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10560,25,8,”1997-06-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10561,24,2,”1997-06-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10562,66,1,”1997-06-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10563,67,2,”1997-06-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10564,65,4,”1997-06-10″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10565,51,8,”1997-06-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10566,7,9,”1997-06-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10567,37,1,”1997-06-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10568,29,3,”1997-06-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10569,65,5,”1997-06-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10570,51,3,”1997-06-17″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10571,20,8,”1997-06-17″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10572,5,3,”1997-06-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10573,3,7,”1997-06-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10574,82,4,”1997-06-19″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10575,52,5,”1997-06-20″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10576,80,3,”1997-06-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10577,82,9,”1997-06-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10578,11,4,”1997-06-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10579,45,1,”1997-06-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10580,56,4,”1997-06-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10581,21,3,”1997-06-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10582,6,3,”1997-06-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10583,87,2,”1997-06-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10584,7,4,”1997-06-30″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10585,88,7,”1997-07-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10586,66,9,”1997-07-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10587,61,1,”1997-07-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10588,63,2,”1997-07-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10589,32,8,”1997-07-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10590,51,4,”1997-07-07″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10591,83,1,”1997-07-07″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10592,44,3,”1997-07-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10593,44,7,”1997-07-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10594,55,3,”1997-07-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10595,20,2,”1997-07-10″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10596,89,8,”1997-07-11″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10597,59,7,”1997-07-11″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10598,65,1,”1997-07-14″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10599,11,6,”1997-07-15″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10600,36,4,”1997-07-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10601,35,7,”1997-07-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10602,83,8,”1997-07-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10603,71,8,”1997-07-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10604,28,1,”1997-07-18″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10605,51,1,”1997-07-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10606,81,4,”1997-07-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10607,71,5,”1997-07-22″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10608,79,4,”1997-07-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10609,18,7,”1997-07-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10610,41,8,”1997-07-25″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10611,91,6,”1997-07-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10612,71,1,”1997-07-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10613,35,4,”1997-07-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10614,6,8,”1997-07-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10615,90,2,”1997-07-30″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10616,32,1,”1997-07-31″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10617,32,4,”1997-07-31″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10618,51,1,”1997-08-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10619,51,3,”1997-08-04″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10620,42,2,”1997-08-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10621,38,4,”1997-08-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10622,67,4,”1997-08-06″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10623,25,8,”1997-08-07″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10624,78,4,”1997-08-07″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10625,2,3,”1997-08-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10626,5,1,”1997-08-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10627,71,8,”1997-08-11″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10628,7,4,”1997-08-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10629,30,4,”1997-08-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10630,39,1,”1997-08-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10631,41,8,”1997-08-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10632,86,8,”1997-08-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10633,20,7,”1997-08-15″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10634,23,4,”1997-08-15″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10635,49,8,”1997-08-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10636,87,4,”1997-08-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10637,62,6,”1997-08-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10638,47,3,”1997-08-20″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10639,70,7,”1997-08-20″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10640,86,4,”1997-08-21″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10641,35,4,”1997-08-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10642,73,7,”1997-08-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10643,1,6,”1997-08-25″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10644,88,3,”1997-08-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10645,34,4,”1997-08-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10646,37,9,”1997-08-27″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10647,61,4,”1997-08-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10648,67,5,”1997-08-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10649,50,5,”1997-08-28″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10650,21,5,”1997-08-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10651,86,8,”1997-09-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10652,31,4,”1997-09-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10653,25,1,”1997-09-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10654,5,5,”1997-09-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10655,66,1,”1997-09-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10656,32,6,”1997-09-04″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10657,71,2,”1997-09-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10658,63,4,”1997-09-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10659,62,7,”1997-09-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10660,36,8,”1997-09-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10661,37,7,”1997-09-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10662,48,3,”1997-09-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10663,9,2,”1997-09-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10664,28,1,”1997-09-10″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10665,48,1,”1997-09-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10666,68,7,”1997-09-12″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10667,20,7,”1997-09-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10668,86,1,”1997-09-15″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10669,73,2,”1997-09-15″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10670,25,4,”1997-09-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10671,26,1,”1997-09-17″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10672,5,9,”1997-09-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10673,90,2,”1997-09-18″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10674,38,4,”1997-09-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10675,25,5,”1997-09-19″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10676,80,2,”1997-09-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10677,3,1,”1997-09-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10678,71,7,”1997-09-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10679,7,8,”1997-09-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10680,55,1,”1997-09-24″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10681,32,3,”1997-09-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10682,3,3,”1997-09-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10683,18,2,”1997-09-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10684,56,3,”1997-09-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10685,31,4,”1997-09-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10686,59,2,”1997-09-30″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10687,37,9,”1997-09-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10688,83,4,”1997-10-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10689,5,1,”1997-10-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10690,34,1,”1997-10-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10691,63,2,”1997-10-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10692,1,4,”1997-10-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10693,89,3,”1997-10-06″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10694,63,8,”1997-10-06″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10695,90,7,”1997-10-07″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10696,89,8,”1997-10-08″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10697,47,3,”1997-10-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10698,20,4,”1997-10-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10699,52,3,”1997-10-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10700,71,3,”1997-10-10″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10701,37,6,”1997-10-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10702,1,4,”1997-10-13″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10703,24,6,”1997-10-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10704,62,6,”1997-10-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10705,35,9,”1997-10-15″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10706,55,8,”1997-10-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10707,4,4,”1997-10-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10708,77,6,”1997-10-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10709,31,1,”1997-10-17″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10710,27,1,”1997-10-20″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10711,71,5,”1997-10-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10712,37,3,”1997-10-21″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10713,71,1,”1997-10-22″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10714,71,5,”1997-10-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10715,9,3,”1997-10-23″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10716,64,4,”1997-10-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10717,25,1,”1997-10-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10718,39,1,”1997-10-27″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10719,45,8,”1997-10-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10720,61,8,”1997-10-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10721,63,5,”1997-10-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10722,71,8,”1997-10-29″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10723,89,3,”1997-10-30″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10724,51,8,”1997-10-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10725,21,4,”1997-10-31″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10726,19,4,”1997-11-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10727,66,2,”1997-11-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10728,62,4,”1997-11-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10729,47,8,”1997-11-04″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10730,9,5,”1997-11-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10731,14,7,”1997-11-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10732,9,3,”1997-11-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10733,5,1,”1997-11-07″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10734,31,2,”1997-11-07″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10735,45,6,”1997-11-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10736,37,9,”1997-11-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10737,85,2,”1997-11-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10738,74,2,”1997-11-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10739,85,3,”1997-11-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10740,89,4,”1997-11-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10741,4,4,”1997-11-14″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10742,10,3,”1997-11-14″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10743,4,1,”1997-11-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10744,83,6,”1997-11-17″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10745,63,9,”1997-11-18″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10746,14,1,”1997-11-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10747,59,6,”1997-11-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10748,71,3,”1997-11-20″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10749,38,4,”1997-11-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10750,87,9,”1997-11-21″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10751,68,3,”1997-11-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10752,53,2,”1997-11-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10753,27,3,”1997-11-25″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10754,49,6,”1997-11-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10755,9,4,”1997-11-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10756,75,8,”1997-11-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10757,71,6,”1997-11-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10758,68,3,”1997-11-28″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10759,2,3,”1997-11-28″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10760,50,4,”1997-12-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10761,65,5,”1997-12-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10762,24,3,”1997-12-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10763,23,3,”1997-12-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10764,20,6,”1997-12-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10765,63,3,”1997-12-04″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10766,56,4,”1997-12-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10767,76,4,”1997-12-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10768,4,3,”1997-12-08″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10769,83,3,”1997-12-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10770,34,8,”1997-12-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10771,20,9,”1997-12-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10772,44,3,”1997-12-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10773,20,1,”1997-12-11″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10774,24,4,”1997-12-11″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10775,78,7,”1997-12-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10776,20,1,”1997-12-15″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10777,31,7,”1997-12-15″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10778,5,3,”1997-12-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10779,52,3,”1997-12-16″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10780,46,2,”1997-12-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10781,87,2,”1997-12-17″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10782,12,9,”1997-12-17″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10783,34,4,”1997-12-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10784,49,4,”1997-12-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10785,33,1,”1997-12-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10786,62,8,”1997-12-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10787,41,2,”1997-12-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10788,63,1,”1997-12-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10789,23,1,”1997-12-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10790,31,6,”1997-12-22″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10791,25,6,”1997-12-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10792,91,1,”1997-12-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10793,4,3,”1997-12-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10794,61,6,”1997-12-24″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10795,20,8,”1997-12-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10796,35,3,”1997-12-25″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10797,17,7,”1997-12-25″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10798,38,2,”1997-12-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10799,39,9,”1997-12-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10800,72,1,”1997-12-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10801,8,4,”1997-12-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10802,73,4,”1997-12-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10803,88,4,”1997-12-30″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10804,72,6,”1997-12-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10805,77,2,”1997-12-30″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10806,84,3,”1997-12-31″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10807,27,4,”1997-12-31″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10808,60,2,”1998-01-01″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10809,88,7,”1998-01-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10810,42,2,”1998-01-01″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10811,47,8,”1998-01-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10812,66,5,”1998-01-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10813,67,1,”1998-01-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10814,84,3,”1998-01-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10815,71,2,”1998-01-05″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10816,32,4,”1998-01-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10817,39,3,”1998-01-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10818,49,7,”1998-01-07″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10819,12,2,”1998-01-07″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10820,65,3,”1998-01-07″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10821,75,1,”1998-01-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10822,82,6,”1998-01-08″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10823,46,5,”1998-01-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10824,24,8,”1998-01-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10825,17,1,”1998-01-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10826,7,6,”1998-01-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10827,9,1,”1998-01-12″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10828,64,9,”1998-01-13″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10829,38,9,”1998-01-13″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10830,81,4,”1998-01-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10831,70,3,”1998-01-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10832,41,2,”1998-01-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10833,56,6,”1998-01-15″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10834,81,1,”1998-01-15″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10835,1,1,”1998-01-15″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10836,20,7,”1998-01-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10837,5,9,”1998-01-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10838,47,3,”1998-01-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10839,81,3,”1998-01-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10840,47,4,”1998-01-19″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10841,76,5,”1998-01-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10842,80,1,”1998-01-20″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10843,84,4,”1998-01-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10844,59,8,”1998-01-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10845,63,8,”1998-01-21″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10846,76,2,”1998-01-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10847,71,4,”1998-01-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10848,16,7,”1998-01-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10849,39,9,”1998-01-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10850,84,1,”1998-01-23″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10851,67,5,”1998-01-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10852,65,8,”1998-01-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10853,6,9,”1998-01-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10854,20,3,”1998-01-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10855,55,3,”1998-01-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10856,3,3,”1998-01-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10857,5,8,”1998-01-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10858,40,2,”1998-01-29″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10859,25,1,”1998-01-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10860,26,3,”1998-01-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10861,89,4,”1998-01-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10862,44,8,”1998-01-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10863,35,4,”1998-02-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10864,4,4,”1998-02-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10865,63,2,”1998-02-02″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10866,5,5,”1998-02-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10867,48,6,”1998-02-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10868,62,7,”1998-02-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10869,72,5,”1998-02-04″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10870,91,5,”1998-02-04″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10871,9,9,”1998-02-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10872,30,5,”1998-02-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10873,90,4,”1998-02-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10874,30,5,”1998-02-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10875,5,4,”1998-02-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10876,9,7,”1998-02-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10877,67,1,”1998-02-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10878,63,4,”1998-02-10″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10879,90,3,”1998-02-10″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10880,24,7,”1998-02-10″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10881,12,4,”1998-02-11″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10882,71,4,”1998-02-11″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10883,48,8,”1998-02-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10884,45,4,”1998-02-12″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10885,76,6,”1998-02-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10886,34,1,”1998-02-13″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10887,29,8,”1998-02-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10888,30,1,”1998-02-16″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10889,65,9,”1998-02-16″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10890,18,7,”1998-02-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10891,44,7,”1998-02-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10892,50,4,”1998-02-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10893,39,9,”1998-02-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10894,71,1,”1998-02-18″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10895,20,3,”1998-02-18″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10896,50,7,”1998-02-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10897,37,3,”1998-02-19″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10898,54,4,”1998-02-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10899,46,5,”1998-02-20″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10900,88,1,”1998-02-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10901,35,4,”1998-02-23″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10902,24,1,”1998-02-23″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10903,34,3,”1998-02-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10904,89,3,”1998-02-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10905,88,9,”1998-02-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10906,91,4,”1998-02-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10907,74,6,”1998-02-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10908,66,4,”1998-02-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10909,70,1,”1998-02-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10910,90,1,”1998-02-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10911,30,3,”1998-02-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10912,37,2,”1998-02-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10913,62,4,”1998-02-26″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10914,62,6,”1998-02-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10915,80,2,”1998-02-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10916,64,1,”1998-02-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10917,69,4,”1998-03-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10918,10,3,”1998-03-02″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10919,47,2,”1998-03-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10920,4,4,”1998-03-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10921,83,1,”1998-03-03″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10922,34,5,”1998-03-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10923,41,7,”1998-03-03″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10924,5,3,”1998-03-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10925,34,3,”1998-03-04″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10926,2,4,”1998-03-04″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10927,40,4,”1998-03-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10928,29,1,”1998-03-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10929,25,6,”1998-03-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10930,76,4,”1998-03-06″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10931,68,4,”1998-03-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10932,9,8,”1998-03-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10933,38,6,”1998-03-06″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10934,44,3,”1998-03-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10935,88,4,”1998-03-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10936,32,3,”1998-03-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10937,12,7,”1998-03-10″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10938,63,3,”1998-03-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10939,49,2,”1998-03-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10940,9,8,”1998-03-11″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10941,71,7,”1998-03-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10942,66,9,”1998-03-11″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10943,11,4,”1998-03-11″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10944,10,6,”1998-03-12″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10945,52,4,”1998-03-12″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10946,83,1,”1998-03-12″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10947,11,3,”1998-03-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10948,30,3,”1998-03-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10949,10,2,”1998-03-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10950,49,1,”1998-03-16″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10951,68,9,”1998-03-16″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10952,1,1,”1998-03-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10953,4,9,”1998-03-16″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10954,47,5,”1998-03-17″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10955,24,8,”1998-03-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10956,6,6,”1998-03-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10957,35,8,”1998-03-18″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10958,54,7,”1998-03-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10959,31,6,”1998-03-18″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10960,35,3,”1998-03-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10961,62,8,”1998-03-19″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10962,63,8,”1998-03-19″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10963,28,9,”1998-03-19″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10964,74,3,”1998-03-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10965,55,6,”1998-03-20″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10966,14,4,”1998-03-20″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10967,79,2,”1998-03-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10968,20,1,”1998-03-23″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10969,15,1,”1998-03-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10970,8,9,”1998-03-24″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10971,26,2,”1998-03-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10972,40,4,”1998-03-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10973,40,6,”1998-03-24″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10974,75,3,”1998-03-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10975,10,1,”1998-03-25″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10976,35,1,”1998-03-25″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10977,24,8,”1998-03-26″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10978,50,9,”1998-03-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10979,20,8,”1998-03-26″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10980,24,4,”1998-03-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10981,34,1,”1998-03-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10982,10,2,”1998-03-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10983,71,2,”1998-03-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10984,71,1,”1998-03-30″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10985,37,2,”1998-03-30″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10986,54,8,”1998-03-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10987,19,8,”1998-03-31″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10988,65,3,”1998-03-31″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10989,61,2,”1998-03-31″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10990,20,2,”1998-04-01″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10991,63,1,”1998-04-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10992,77,1,”1998-04-01″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10993,24,7,”1998-04-01″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10994,83,2,”1998-04-02″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10995,58,1,”1998-04-02″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10996,63,4,”1998-04-02″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10997,46,8,”1998-04-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10998,91,8,”1998-04-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (10999,56,6,”1998-04-03″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11000,65,2,”1998-04-06″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11001,24,2,”1998-04-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11002,71,4,”1998-04-06″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11003,78,3,”1998-04-06″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11004,50,3,”1998-04-07″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11005,90,2,”1998-04-07″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11006,32,3,”1998-04-07″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11007,60,8,”1998-04-08″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11008,20,7,”1998-04-08″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11009,30,2,”1998-04-08″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11010,66,2,”1998-04-09″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11011,1,3,”1998-04-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11012,25,1,”1998-04-09″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11013,69,2,”1998-04-09″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11014,47,2,”1998-04-10″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11015,70,2,”1998-04-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11016,4,9,”1998-04-10″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11017,20,9,”1998-04-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11018,48,4,”1998-04-13″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11019,64,6,”1998-04-13″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11020,56,2,”1998-04-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11021,63,3,”1998-04-14″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11022,34,9,”1998-04-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11023,11,1,”1998-04-14″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11024,19,4,”1998-04-15″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11025,87,6,”1998-04-15″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11026,27,4,”1998-04-15″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11027,10,1,”1998-04-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11028,39,2,”1998-04-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11029,14,4,”1998-04-16″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11030,71,7,”1998-04-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11031,71,6,”1998-04-17″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11032,89,2,”1998-04-17″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11033,68,7,”1998-04-17″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11034,55,8,”1998-04-20″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11035,76,2,”1998-04-20″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11036,17,8,”1998-04-20″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11037,30,7,”1998-04-21″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11038,76,1,”1998-04-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11039,47,1,”1998-04-21″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11040,32,4,”1998-04-22″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11041,14,3,”1998-04-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11042,15,2,”1998-04-22″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11043,74,5,”1998-04-22″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11044,91,4,”1998-04-23″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11045,10,6,”1998-04-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11046,86,8,”1998-04-23″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11047,19,7,”1998-04-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11048,10,7,”1998-04-24″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11049,31,3,”1998-04-24″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11050,24,8,”1998-04-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11051,41,7,”1998-04-27″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11052,34,3,”1998-04-27″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11053,59,2,”1998-04-27″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11054,12,8,”1998-04-28″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11055,35,7,”1998-04-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11056,19,8,”1998-04-28″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11057,53,3,”1998-04-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11058,6,9,”1998-04-29″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11059,67,2,”1998-04-29″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11060,27,2,”1998-04-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11061,32,4,”1998-04-30″,3);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11062,66,4,”1998-04-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11063,37,3,”1998-04-30″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11064,71,1,”1998-05-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11065,46,8,”1998-05-01″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11066,89,7,”1998-05-01″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11067,17,1,”1998-05-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11068,62,8,”1998-05-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11069,80,1,”1998-05-04″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11070,44,2,”1998-05-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11071,46,1,”1998-05-05″,1);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11072,20,4,”1998-05-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11073,58,2,”1998-05-05″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11074,73,7,”1998-05-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11075,68,8,”1998-05-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11076,9,4,”1998-05-06″,2);
INSERT INTO Orders (OrderID,CustomerID,EmployeeID,OrderDate,ShipperID)
VALUES (11077,65,1,”1998-05-06″,2)


 

 

SSC কম্পিউটার শিক্ষা Quiz 06 : অধ্যায় ০৬ (স্প্রেডশিট এ্যানালাইসিস)

[slickquiz id=8]