Best unofficial Apache Server developers community

Answers

create view

2

votes

1 answer

78 views

Create MySQL view using distinct values as columns

I have searched a while and can't find an answer to my problem. I have a table that looks like this: date name status 2011-01-01 m1 online…

mysql view distinct create values

asked January 30, 2011 3:27 am CST

kelly

1

create view

Tagged: create + view

Related Tags

mysql × 48

sql × 11

database × 8

couchdb × 7

php × 6

sqlite × 6

query × 6

join × 5

performance × 4

table × 4

database-queries × 3

stored-procedures × 3

select × 2

triggers × 2

java × 2

mapreduce × 2

federated × 2

error × 2

fulltext × 2

tags × 2

optimization × 2

hibernate × 2

android × 1

create × 1

multiple-tables × 1

java-ee × 1

nested-loops × 1

sqlite3 × 1

group-concat × 1