If I have this sort of.

Plough: You get more rows because you have multiple attendees per event

Glasby: Yes but this is not how I want it

Rippel: I want it to be clubbed under one result

Parlow: ArtisanIndia: See http://dev.mysql.com/doc/refman/5.6/en/group-by-functions.html#function_group-concat

Rumery: ArtisanIndia, no, you do not want that, believe me ;

Felt: Lets say events has three attendees so i want result like event { events details. , attendees_detail{attendees 1, attendee 2, attendee 3}}

Lather: ArtisanIndia: transform your data in application code

Batra: What is that Naktibalda

Stambach: Something like PHP or Java

Magat: Yes I am using laravel it has ORM named eloquent

Beccue: Then write the code to group attendees

Cargill: But laravel doesnot have any method to calculate distance with cordinates so i have to use raw sql queries

Perricone: Use a query without group by, then iterate results with foreach and aggregate them in code $events $row’event_id”attendees’ != $row

Brelsford: If I do something similar with laravel I get this kind of response http://laravel.io/bin/42r8N

Rumery: ArtisanIndia, as attendees do not change anything from your computation, you can just NOT join them and then make a separate query “select . from attendees where event_id INlist of events returned from your current query”

Troia: You see an element rsvpprofile in the above paste

Laza: Line number 36 to be prices

Rumery: Or even loop “$attendees-getByEventId.” in your orm code maybe

Madill: Boleware: yeah I know :. I just want to gather the resources first :

Abelman: What it means that the maximum key length for MyISAM is 1000 bytes?

Abelman: Each column indexed by the index should not have more than 1000 bytes of data?

Sarkissian: Have you heard about composite indexes?

Chamble: If you do KEYa,b,c a sum of lengths must be less than 1000

Forts: Hi any one got a hint for me? ….i need to insert about 500 cidcompanyID/daydate values to an existing DB. If the CID/DAY Combination already exists, it should ++ the third column COUNTER else it should insert a new row with CID, DAY, COUNTER1


Reising: Hey thx, tried it.ist it possible without uniqkey.just two row values combination?

Bachinski: Flu3d: alter table t1 add uniquea,b; — you can add a unique index on 2 columns

Bachinski: Flu3d: so the combination has to be unique

Abelman: Boleware thanks, yes, I understand the concept, but what is meant by the sum of lengths? in your example, all three columns should never have more than 1000 bytes?

Obray: A VARCHAR200, b VARCHAR300, c VARCHAR500 all latin_1 sum = 1000

Genao: If utf8, sum would be 3000 and creating index would fail

Zhou: Read http://dev.mysql.com/doc/refman/5.6/en/storage-requirements.html

Abelman: Boleware thanks, I got it

Abelman: And what happens if you need to create an composite index to speed up access to table, but you exceed length? you compromise, and use less columns?

Bachinski: Abelman: for a single column, you use an index prefix where possible

Bachinski: Abelman: only indexing the beginning characters of the string. not much use for multiple column though

Abelman: Bachinski ok, I got the second part of your answer, but for the first part: what is meant with an index prefix?

Bachinski: Abelman: an index on a specific number of bytes at the beginning of the string that stays below the maximum allowed

Bachinski: Abelman: not always useful, depends on your data

Bachinski: Abelman: https://dev.mysql.com/doc/refman/5.6/en/create-index.html — search for prefix

Lennington: If I have this sort of data: http://i.imgur.com/SXwqeIX.png would it be better if I stored each item name in a table, and then have a table that has a record for every one of the values for that item?