The column names do not matter at all, as long as data types match (or can be cast in the assignment). If the data types of the columns don’t match, try casting the values accordingly. Just try with small dummy tables. Be sure to list the target columns explicitly to avoid confusion. Like this: INSERT … Read more
As MySql accepts the date in y-m-d format in date type column, you need to STR_TO_DATE function to convert the date into yyyy-mm-dd format for insertion in following way: INSERT INTO table_name(today) VALUES(STR_TO_DATE(’07-25-2012′,’%m-%d-%Y’)); If you want to select the date in different format other than Mysql format, you should try DATE_FORMAT function SELECT DATE_FORMAT(today, ‘%m-%d-%y’) … Read more
IS NULL and IS NOT NULL work for complex types too, so these two should be appropriate: select * from bla where recipient is not null select * from bla where recipient is null
Extracting my comments into an answer: the index lookup here was very fast — all the time was spent retrieving the actual rows. 23 seconds / 7871 rows = 2.9 milliseconds per row, which is reasonable for retrieving data that’s scattered across the disk subsystem. Seeks are slow; you can a) fit your dataset in … Read more
Simply put the “qa bug” criteria in the join: select t1.*, t2.name from #bug t1 left join #blocking t2 on t1.id = t2.id AND t2.name=”qa bug”
Try boolean_col::int: SELECT item.item_number, SUM(item.item_active::int) FROM public.item GROUP BY item.item_number;
Three useful Linq concepts operating on sets. Given set c and set e: Concat gives you everything in c or e: (From c In db.Customers Select c.Phone).Concat( _ From c In db.Customers Select c.Fax).Concat( _ From e In db.Employees Select e.HomePhone) (From c In db.Customers _ Select Name = c.CompanyName, Phone = c.Phone).Concat(From e In … Read more
If all you want to show is the literal TRUE or FALSE, you can use the case statements like you had proposed. Since PostgreSQL treats TRUE, true, yes, on, y, t and 1 as true, I’d control how I’d want the output to look like. Where clause can be written like: select * from tablename … Read more
Select col1,col2 from as400table where col1=’filter’ order by col1 fetch first N row only Remember to set an ORDER BY clause, because DB2 does not guarantee that the rows returned by FETCH FIRST N ROW ONLY are always the same N.
You will want to use a PIVOT function for this. If you have a known number of columns, then you can hard-code the values: select name, [Bronze], [Silver], [Gold], [Platinum], [AnotherOne] from ( select c.name, cr.description, r.typeid from customers c left join rewards r on c.id = r.customerid left join customerrewards cr on r.typeid = … Read more