Building the Northwind database from an SQL script

Building the Northwind database from an SQL script

Building the Northwind database from a SQL script 1

Click on New in left-hand column and (if needed) the Databases tab. (Currently there is no northwind database) 2

Northwind SQL script http://code.google.com/p/northwindextende d/downloads/detail?name=Northwind.MySQL 5.sql I got a SQL script from the above link and

edited out the Views and Procedures. But I will make the edited version available on my website. 3

Click on the SQL tab. Open the script (say in Notepad++), highlight it all (Ctrl+A), copy (Ctrl+C) and paste (Ctrl+V) it into the text area. Click Go.

4 This took some time. 5

Result. Northwind not showing (yet) on left. 6

But shows when you click Databases tab. 7 After clicking on northwind. Shows the list of tables.

8 After clicking on the products table

9 Northwind shows up on left next time you start PMA 10

Click on Privileges 11

Click on new Add user 12 Add a new user. (I had more luck with permissions

making the Host: Local) 13

Recently Viewed Presentations

  • Channel Models for IEEE 802.15.4q

    Channel Models for IEEE 802.15.4q

    Wan A, Sodini C, Chandrakasan, "Energy efficient modulation and MAC for asymmetric RF microsensor systems," Proceeding ISLPED '01 Proceedings of the 2001 international symposium on Low power electronics and design, pp. 106-111, 2001
  • River-groundwater impact on bank stability

    River-groundwater impact on bank stability

    c = apparent cohesion [kPa] L = length of the failure plane [m] W = saturated soil weight [kN] P = hydrostatic confining force of stream water [kN/m] ϕ' = effective friction angle [°] μ. a = pore-air pressure [kPa]μ....
  • International Document Summer School, Troms, 2005 Documents and

    International Document Summer School, Troms, 2005 Documents and

    Terminology There are different definitions for "document", "documentation," "genre," "media type," etc. Using these terms is part of the method, not the purpose (objective). The purpose is to understand the phenomena of interest and their context. Terminology is subordinate to...
  • International Litigation and Arbitration

    International Litigation and Arbitration

    Transnational Litigation and Arbitration * * Choice of forum forum selection clauses multiple fora w/o clause US perceived as pro-plaintiff US as forum "As a moth is drawn to the light, so is a litigant drawn to the United States."...
  • Parallel Implementation of IIR Filters

    Parallel Implementation of IIR Filters

    A single input, single output implementation of an IIR filter of order N requires 2 N + 1 multipliers. Therefore the theoretical optimum for an implementation handling P simultaneous inputs and outputs is P (2 N + 1) multipliers.
  • Introduction to Essential Skills

    Introduction to Essential Skills

    Building Essential skills into existing training, whether formal or informal, means identifying the underlying Essential Skills required for training and the workplace tasks. Once identified opportunities to refresh or learn the Essential Skills become part of training activities. This strategy...
  • POLAR CURVES Intersections Polar curves KUS objectives BAT

    POLAR CURVES Intersections Polar curves KUS objectives BAT

    WB19aFind the area enclosed by the cardioid with equation: r = a(1 + cosθ). Sketch the graph (you won't always be asked to do this, but you should do as it helps visualise the question…) As the curve has reflective...
  • Trail of tears Stations - Ms. Bunnell

    Trail of tears Stations - Ms. Bunnell

    Would you have tried to resist the removals after hearing Scott's message? 2. ... a stable, 19 acres of cleared bottom land, of which six were on the creek, 30 peach trees and 3 apple trees. Station 3: Choose 2...