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