JMerrill
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by JMerrill
-
-
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.
online “SQL Try It” ? WORKING
in SQL
Posted
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