Yesterday I was in here.

 
Correl: Giza: What’s wrong with that?

Glasglow: I want master id unique id name id 1

Mcinturff: I want master id unique id value of name id 1 value of name id 2

Correl: Giza: You are talking about so called Pivot Table, but why do you think you need it?

Correl: Giza: You have to iterate through the result in your client app code in any case so it doesn’t matter much if values are on same row or different rows

Roesch: Please disregard the first i want, mistyped

Hodel: This is about viewing data in mysql workbench

Keiter: Giza: why do you want to view the data that way with workbench?

Tiley: Keiter: because I want to produce a report based on the results something that cannot be done in the front end the data is there I just need to know how to arrange it correctly

Keiter: Giza: just use a pivot table, then.

Fraklin: Keiter: will that achieve what I want? i have read examples but having trouble translating it to my requirement

Keiter: Giza: SELECT ‘foo’, SELECT value from tbl WHERE id = 1 as 1, SELECT value from tbl WHERE id = 2 as 2

Shermer: Or dump and open in excel

Maslyn: Then pivot all you like

Correl: Aias: Or connect directly from excel to MySQL using ODBC . if you are into masochizm

Garns: I have a child table with a foreign key to a parant table. I’m using CASCADE DELETE so that when an item in the parent table is deleted, all child objects are deleted as well

Fagan: Is it possible to prevent anyone from manually going into the child table and deleting children?

Vergeer: I want to set it up so that the only way for a child to be deleted, is through the DELETE CASCADE of deleting the parent

Galaska: Outside of not giving anyone access, I don’t think so

Viveiros: Matviy: You could simply deny delete privileges to all users on that database – I’m not entirely sure but I think the cascade might still work. Try it! :-

Garrott: Swed: SELECT b FROM table WHERE a INx,y GROUP BY b HAVING COUNTDISTINCT a = 2

Crotty: Vegivamp: thx, I was able to restore things, everything has been working fine now for the past hour, thanks for the directions ;

Baillet: I wrote some simple psuedo-code for a script I want to write: http://codepad.viper-7.com/m7EDhM Can anyone point me in the right direction of functions/constructs to use to accomplish it? I’ve never done the programming aspect of sql and don’t really know where to start :

Lefebre: Hello, I am noticing that SET GLOBAL sql_mode = ‘STRICT_ALL_TABLES’; works when issuing through mysql client, but when I set the same mode in my.cnf, it gets completely ignored.

Solow: What can I do about it

Cunning: MadLems: do you really want to do in in SQL?

Lallemand: Naktibalda: I think so? Where else would I do it? Are you suggesting I consider doing most of the logic in php or something instead?

Sachs: MadLems: or you could use this query: http://pastie.org/10435853

Orto: How do I make sql_mode=STRICT_ALL_TABLES permanent if it is ignored in my.cnf ?

Westmorland: Irqpal: do you put it to the right section?

Wehrheim: I have got a problem while i transfered my database in a chroot-enviroment

Perriott: Naktibalda: yes, it is under mysqld

Lesley: I have a column that has values like blah.foo.bar

Lesley: And i want to change them to blah no foo.bar

Cereceres: I cannot use my file in /debian/var/lib/mysql/

Lesley: Is there a way to do this with REPLACE and some kind of grouping

Livley: Lesley: See http://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_substring-index

Metaxas: Is sqlfiddle slow at the moment?

Keiter: Lucid: it sometimes is.

Lapinta: Keiter: yeah I retried the same thing and now it works, thanks

Croutch: Yesterday I was in here with a query which was apparently not returning the results I expected