sql

[Solved] Highcharts column graph colors via sql data

by

[ad_1] 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′”;} … Read more

[Solved] SQL Error message: [closed]

by

[ad_1] 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, … Read more

[Solved] SQL query returns exception

by

[ad_1] 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) ) [ad_2] solved SQL query returns exception

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

by

[ad_1] –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 … Read more

[Solved] List ocurrences in column – SQL

by

[ad_1] 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 [ad_2] solved List ocurrences in column – SQL

[Solved] MySQL Select from three tables [closed]

by

[ad_1] 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 … Read more

[Solved] Fetching Unmatching/Rejected rows

by

[ad_1] 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 … Read more

[Solved] Error when execute query [closed]

by

[ad_1] 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 … Read more

[Solved] mysql user defined variables as derived table

by

[ad_1] 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(‘ … Read more

[Solved] SQL query to linq to SQL query

by

[ad_1] 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 … Read more

[Solved] Saved View with a timestamp expression

by

[ad_1] 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 … Read more

[Solved] SQL JOIN for three tables

by

[ad_1] 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 [ad_2] solved SQL JOIN for three tables