Use a query to determine the value of a variable (MySQL)

advertisements

I am trying to get the value of a count into into a variable to be used with another query.

BUT it does not work, it says:

[Err] 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 'SELECT COUNT(columnname) FROM field WHERE tabid = 4' at line 1

The query I am using is:

SET @_count = SELECT COUNT(columnname) FROM field WHERE tabid = 4;

You're going to need to wrap the SQL Select Query in parenthesis.

SET @_count = (SELECT COUNT(columnname) FROM field WHERE tabid = 4);

Related Articles

The Php script, the query worked from the value that was passed

I am pretty new at php, quick note this is an android application that i am calling this script, I am not having the users make up the script lol. There is a series of checkboxs and when they check off certain ones it appends a script to the string b

dynamically determining the value of a column in the hive

I would like to determine the value of a column in a Hive table by some statement. e.g., the column is age: if(some condition are satisfied) the value is 30, otherwise, the value is 10 so after inserting all the rows, the age of rows which the statem

How to convey the value of a variable in a mongo query?

The following mongo query works correctly: db.data.find({"data.id": "5" }) I want to pass the value of a variable for an argument list to the query in a python program: import pymongo from pymongo import MongoClient client=MongoClient(

How to determine the value of a string?

Sorry for the stupid question, but I've never really understood how to determine the value of a string. For instance, which is greater, "shaft", or "scream" and what? What components should you look for when comparing?Strings are compa