Jump to content

JMerrill

Members
  • Posts

    2
  • Joined

  • Last visited

JMerrill's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. Thanks,I'll try the other Site.Other commands did work.I've downloaded MySQL 4.1 and am in the process of Configuring, once that's done all issues should be with me.JM
  2. I am new to the ways of SQL and any other languages.I need to know if these functions (below) work 'on line' or if I'm coding in error.I am enjoying learning SQL but not knowing if it is me or the site is a bit frustrating.Thanks all,JMIn The online “SQL Try It” using the Customers table in the Northwind database:INSERT INTO customers (CustomerID, CompanyName)VALUES ('aasa', 'bobco')Gives this result : Operation must use an updateable query.UPDATE CustomersSET Address = 'Stien 12', City = 'Stavanger'WHERE CustomerID = 'ALFKI'Gives this result : Operation must use an updateable queryDELETE FROM CustomersWHERE CustomerID = 'ALFKI'Gives this result : Could not delete from specified tables.DELETE * FROM CustomersGives this result : Could not delete from specified tables.
×
×
  • Create New...