Find solution
How to do SQL inner queries through SQLAlchemy?

What is like.sql queries?

  • I'm lost with this (my first script install ever) script instructions say...you'll need to run like.sql queries in your database manager I assumed I was supposed to input "like.sql queries" or just "like.sql" into the Run SQL query under the SQL tab, but those both resulted in this error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'like.sql queries' at line 1 so obviously I'm not doing it right...?? hrrrm lol

  • Answer:

    "like.sql" is an invalid SQL query construct. To search a database for data similar to some known chunk of data, the term like is represented with a percent symbol: %. In the perspective of what you were attempting to do, it is meant for you to have executed (read: run) "equivalent" (hence: like) queries in your database manager...so, re-read your script instructions and execute the different queries according to them. You can also visit www.w3schools.com for a helpful and free SQL tutorial. Best of luck.

greeneye... at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

I think that you should open in database manager the files *.sql from what you got and execute them.

SELECT * FROM table WHERE field like '%What ever%' The field is the filed in the table you are searching in and the what ever part is the value you are looking for. Hope this works.

I'm not too sure what steps you are doing but you probably need the keyword "execute" in front of the sql script if you are running it from a query/procedure editor.

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.