Solved

MySQL Error

Posted on 2014-01-14
3
311 Views
Last Modified: 2014-01-14
I'm getting the error in the attached. The table structure is in the 2nd attachment.

What's wrong?

Thanks
sql-error.jpg
svcs-contr-price-str.jpg
0
Comment
Question by:Richard Korts
  • 2
3 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 39780865
You aren't SELECTING any columns, not even everything which would be '*'.
0
 

Author Closing Comment

by:Richard Korts
ID: 39780873
Thanks, Dave.

Boy, that was a "duuuuuuuuuuuh"! I Couldn't see the forest for the trees.
0
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 39780928
You're welcome, we all do that sometimes.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question