mysql - How to get unique number of rows from the secondary table -

- 

create table pro_category (id primary key, product_id int, category_id int) insert pro_category (1, 1, 1) insert pro_category (1, 1, 2) insert pro_category (1, 2, 1) insert pro_category (1, 2, 1)

how unique number of rows secondary table (e.g. in above case there 2 product id's involved answer of 2).

using count(distinct)

select count(distinct product_id) pro_category

Comments

Post a Comment

Popular posts from this blog

mysql - How to insert just year and month into date field? -

-
i have column called table_date using now() insert current date ( 2011-02-23 ). know can manipulate sql/php show me year , monthname. however, want know if it's possible insert table_date current date year-month 2011-02 ? thanks a date field going full date, , far know, required specify full date. it might easiest use 01 , 2011-02-01 february 2011. obviously, can format output of date field liking when querying it: select date_format(fieldname,"%y-%m");
Read more

c# - Detect changes in ObjectSet in Entity Framework 4.0? -

-
i want check if there changes in table in ef 4.0 following code: var = context.users.gethashcode(); addnewuser(); context.savechanges(); var b = context.users.gethashcode(); a == b, don't know why? any helps appreciated! gethashcode has absolutelly different usage . can't detect changes in objectset because entry point related database table(s). can detect changes prepared in objectcontext before accept changes (default savechanges accept changes). changes objectcontext use: context.objectstatemanager.getobjectstateentries(...)
Read more