?
Solved

MySQL Error

Posted on 2014-01-14
3
Medium Priority
?
318 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 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 84

Expert Comment

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

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

764 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