sql

[Solved] Highcharts column graph colors via sql data

by

And I had finally figured out how to make it work colors: [ <?php $num_counts = count($count); $on = 1; foreach($count as $bit => $bit_counts) { if($bit == ‘STEEL’){echo”‘#FF9999′”;} else if($bit == ‘STEEL CROWN’){echo”‘#FF9999′”;} else if($bit == ‘SLIM’){echo”‘#9999FF'”;} else if($bit == ‘KYMERA’){echo”‘#FF2626′”;} else if($bit == ‘HYBRID’){echo”‘#FF2626′”;} else if($bit == ‘EZC’){echo”‘#FFFF26′”;} else if($bit == ‘EZR’){echo”‘#FFFF26′”;} else … Read more

[Solved] SQL Error message: [closed]

by

Hard to guess without as much details as needed, but i think you are escaping the values with aphostropes (‘). That’s php’s habit. MySQL doesn’t escape those values with aphostropes, it uses backtiks (`) or nothing. You could change your query part which you provided to remove those symbols: … 2013-12-10, NULL, dsffsd, dfsfsd, sfdd, … Read more

[Solved] SQL query returns exception

by

Looks like the value which should ALL .. compared to must be in front of ALL SELECT name, continent, population FROM world WHERE continent IN (SELECT continent FROM world x WHERE 25000000> ALL(SELECT population FROM world y WHERE x.continent = y.continent) ) solved SQL query returns exception

[Solved] Lots of updates to a large table. How to speed up?

by

–Requete 40. Performance cost: 3% UPDATE #temp_arbo_of_3 SET PxAchat=NULL, CuTpsAch=NULL WHERE IdBE IS NULL; –Requete 41. Performance cost: 2% UPDATE #temp_arbo_of_3 SET CuTrait = NULL WHERE IdBE IS NOT NULL; –Requete 42. Performance cost: 2% UPDATE #temp_arbo_of_3 SET NrOF_Source = _ofI WHERE IdBE IS NOT NULL; Now if I replace all this by: –Requete 40. … Read more

[Solved] List ocurrences in column – SQL

by

Based upon your question, it is a simple select distinct and then an order by SELECT distinct(Column_Name) FROM Table_name ORDER BY Column_Name DESC Or SELECT distinct(Column_Name) FROM Table_name ORDER BY Column_Name Depending on the Sort order that you want 4 solved List ocurrences in column – SQL

[Solved] MySQL Select from three tables [closed]

by

something like this? QUERY: SELECT country, profession, MAX(money) AS money FROM ( SELECT u.country, g.profession, SUM(um.money) AS money FROM user_money um JOIN users u ON u.id = um.user_id JOIN groups g ON g.id = um.group_id GROUP BY g.profession, u.country ORDER BY um.money DESC ) t GROUP BY country ORDER BY money DESC SEE DEMO OUTPUT: … Read more

[Solved] Fetching Unmatching/Rejected rows

by

It appears that you want to do something like select * from Tab1 LEFT OUTER join Tab2 on Tab1.col1=Tab2.col1 and Tab1.col2=Tab2.col3 and Tab1.col4=Tab2.col5 AND Tab2.col3=<value> LEFT OUTER join Tab3 ON (TAB3.SOMETHING = TAB1.SOMETHING OR TAB3.SOMETHING_ELSE = TAB2.SOMETHING_ELSE) AND Tab3.col2=<value> and WHERE Tab1.col3=<value> and Tab1.col4=<value> AND TAB2.PRIMARY_KEY IS NULL AND TAB3.PRIMARY_KEY IS NULL; Note the use … Read more

[Solved] Error when execute query [closed]

by

The roll number string in your where clause needs to be delimited as a string. This line query = query + ” ” + “WHERE rollNo=” + “2K12-BSCS-37″; should be replaced with query += ” ” + “WHERE rollNo=” + “‘2K12-BSCS-37′”; Note the single quotes. Better still would be to use string format to build … Read more

[Solved] mysql user defined variables as derived table

by

Are you looking for something like this? SELECT * FROM ( SELECT 1 value UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 ) table1 Here is SQLFiddle demo You can easily produce it in php like this using implode() $myArr = array(1,2,3,4); $sql=”SELECT * FROM (SELECT “; $sql .= implode(‘ value … Read more

[Solved] SQL query to linq to SQL query

by

Use OrderBy for the ordering, and First or possibly FirstOrDefault for the equivalent of TOP 1: var session = db.Sessions.OrderBy(x => x.StartTime).FirstOrDefault(); if (session != null) { // Use the session } else { // There weren’t any sessions } You could use a query expression for the first part, but it seems pretty pointless … Read more

[Solved] Saved View with a timestamp expression

by

I can see how this would be misleading. However, a view does not “store” data (except for materialized views, which are a different store). A view is a query which is substituted into the query where it is used. Admittedly, it could be parsed in advance, saving a small amount of effort. However, a function … Read more

[Solved] SQL JOIN for three tables

by

select * from tbl_Service where sId not in (select ser_Id from tbl_quat_ID where quat_Id != <qID>) i hope qID is passed from application side.. you just need to append the string to pass proper value there 1 solved SQL JOIN for three tables