Hello,
i have a question regarding the GREATEST function of mysql.
I would like to add the values returned by GREATEST function is mysql, so a
query is like below:
For example table t has 6 fields with values as follows: A = 1, B = 3, C=0,
D = 0, E = 1 and F = 0 and I run a query:
SELECT
Hi,
You could split the table into two and can avoid code changes by creating a
view which matches what code is looking for.
I think loading few fields vs 254 into memory will make a difference but if
your select statement only have specific fields you want and not the whole
row (and also given
probably want to perform this conversion on your client. There
are JSON parser libraries available for Java, PHP and the like. Cheers,
Karr
On Mar 20, 2014, at 11:35 AM, Sukhjinder K. Narula narula...@gmail.com
wrote:
Hello,
I would like to know if there is a way to decode the json
Hello,
I would like to know if there is a way to decode the json string stored in
one of the fields as text without using triggers or stored procedures.
What I want to do is is within the query, I would like to get one row per
element within the json string.
For example: the json string is as
Its called JDBC connector, please see the link:
http://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-connect-drivermanager.html
good luck.
On Wed, Dec 11, 2013 at 10:15 AM, h...@tbbs.net wrote:
I have MySQL 5.5.8 under Windows Vista, and I am minded to write Java
programs to talk
Hi,
You could use regular expression to do this, here is the example with the
reference site that might help you:
If your data is 'test', 'test0', 'test', '111test', '111'
SELECT * FROM myTable WHERE col1 REGEXP '^[0-9]+$';
Result: '111'
In regex ^ mean begin, and $ - end.
SELECT * FROM
Hi,
In your second query, you seem to have MIN(date_time), but you are talking
about maximum. So your group by query is actually pulling the minimum date
for this recipe.
Regards.
On Mon, Sep 23, 2013 at 3:35 PM, Larry Martell larry.mart...@gmail.comwrote:
I want to find the rows from a table
Hello,
I have a question regarding creating a query as follows:
I have several databases (all with same structure), which I to query. For
instansce:
db1, db2, db3 - all have table tb1 with field a, b and table tb2 with
fields flag1, flag2
So I want to query and get field a from tb for all