#mysql
09 October 2007
Total 22 pages. You are browsing page 4/22.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
03:06 <****> ah, cool
03:06 <****> buenas noches.
03:07 <****> yep.
03:07 <****> he's related to beach?
03:07 <****> jbalint: wawesome
03:07 <****> alguien habla español ?
03:07 <****> Karcamo[x]: asi asi
03:07 <****> chadmaynard: buenas noches.
03:08 <****> nachos?
03:08 <****> tengo dudas sobre el uso de trigger.
03:08 <****> hay alguien ?
03:09 <****> ToeBee: conoces los trigger ?
03:09 <****> chadmaynard: conoces los trigger ?
03:09 <****> Karcamo[x]: si.
03:09 <****> chadmaynard: me ayudas con mi duda ?
03:10 <****> sure
03:10 <****> Karcamo[x]: ser mas especifico
03:10 <****> create trigger trigger1 before insert on socios for each row insert into socios set fecha=now();
03:10 <****> eso me funciono,
03:10 <****> http://pastie.caboo.se/105139 << can anyone suggest an easier way of doing that... all i'm trying to do is get the most recent record for each group of keys...
03:10 <****> y cuando hice un insert me lanzo un error
03:11 <****> Karcamo[x]: tu deseas update
03:11 <****> si.
03:11 <****> es que no tengo muy claro el objetivo de los trigger..
03:13 <****> Karcamo[x]: DELIMITER // CREATE TRIGGER name BEFORE INSERT ON table FOR EACH ROW BEGIN SET NEW.col = NOW(); END; //
03:14 <****> Karcamo[x]: pienso que deseas esto
03:14 <****> y delimiter ?
03:15 <****> Karcamo[x]: Debes cambiar el delimitador asi que la declaracion no termina demasiado pronto <- i think
03:15 <****> my spanish isn't too great
03:16 <****> hehe
03:17 <****> Karcamo[x]: el thumbs habla espanol mejor
03:18 <****> Karcamo[x]: que pasa?
03:23 <****> thumbs: tengo dudas sobre el objetivo de los trigger
03:24 <****> haha i guess my answer wasn't good enough
03:25 <****> chadmaynard: why so?
03:25 <****> thoughtful: because he asked the same question again
03:26 <****> he wants to create a trigger.
03:26 <****> ah. i wonder what question i'd choose, if i was cursed to repeat the same question endlessly?
03:27 <****> thumbs: no way!
03:27 <****> i like the sound of, "Whither thou, Rannold?"
03:27 <****> thoughtful: maybe he would understand you
03:27 <****> it would be exciting if it ever became relevant, i can tell you.
03:28 <****> well my spanish is roughly the same as chadmaynard, I think
03:30 <****> thoughtful: is yours any better?
03:30 <****> Karcamo[x]: http://dev.mysql.com/doc/refman/5.0/es/create-trigger.html
03:30 <****> oooo
03:31 <****> when I use chroot, mysql server SSL connection error, can some help me?
03:32 <****> when I use chroot, mysql server SSL connection error, can someone help me?
03:32 <****> i lived in mexico for about a month, but all i could manage was to order a coffee, ask the whereabouts of a toilet, and inquire if, by chance, that was my camel.
03:32 <****> thoughtful: lol
03:32 <****> thoughtful: hahaha
03:33 <****> that would probably be my case too, as I never speak with real hispanic people
03:33 <****> I bet thoughtful is a blast when he's drunk
03:33 * thoughtful doesn't drink all that often
03:34 <****> life is too interesting straight and sober.
03:34 <****> thoughtful: estoy leyendo ese link
03:34 <****> What's wrong with this query:
03:34 <****> INSERT INTO `info` (`id`, `background`, `wallpaper`, `furniture`) VALUES(LAST_INSERT_ID (), 0, 0, '');
03:34 <****> can you use LAST_INSERT_ID() that way?
03:35 <****> thoughtful, I saw a reference to it on the MYSQL Manual.
03:35 <****> mmm
03:35 <****> the error tells you what is wrong
03:35 <****> ah, I was looking for that word
03:35 <****> I got stuck on 'reading'
03:35 <****> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near
03:36 <****> that's right, chop the important part
03:36 <****> what's the correct word for 'link' in spanish?
03:36 <****> can someone help me fix the ssl connection? When I no use chroot, it's ok. But when I use the chroot, it show "ERROR 2026 (HY000): SSL connection error";
03:37 <****> Trent: ok i'll go ahead and point you in the right direction. try "SELECT LAST_INSERT_ID();" and "SELECT LAST_INSERT_ID ();" <- then note the differences.
03:37 <****> when specifying relationships in an ER based table for relationships
03:37 <****> chadmaynard, Neither works in the way I am trying =X
03:37 <****> what is a Strong, ID-Dependent, weak relationship?
03:37 <****> what are those simply?
03:38 <****> ID-Dependent is one that relies on a key right?
03:38 <****> thumbs: according to Google, it's 'acoplamiento', but i don't know if that is the right context?
03:41 <****> thoughtful: nope.
03:41 <****> thoughtful: definitely not
03:41 <****> that refers to an interpersonal link, with your father, for example
03:53 <****> how do you determine strong and weak relationships
03:53 <****> ?
03:53 <****> A strong relationship is like with a wife, and a weak relationship is with a mistress
03:54 <****> do you have that backwards?
03:55 <****> Depends on your which ANSI SQL revision you read
03:56 <****> FILE.sql"
03:58 <****> anybody read this http://www.dbms2.com/2007/10/08/the-era-of-memory-centric-bi-may-have-finally-started/
03:58 <****> read - paste tense :)
03:58 <****> what does he mean by memory-centric
04:00 <****> should adding a column to a innodb table that has 6.5M+ preexisting rows take over an hour?
04:01 <****> jereme: yes.
04:01 <****> likely more.
04:02 <****> k
04:02 <****> thanks
04:02 <****> jereme: show processlist;
04:03 <****> yeah, I've been doing that for quite a bit...
04:03 <****> I'm at around 66 minutes
04:03 <****> still building the tmp table
04:03 <****> converting the table to innodb took an hour and a half
04:04 <****> heh
04:04 <****> do as much in one operation as you can to it only has to do that mess once.
04:05 <****> would it have been possible to perform both transformations at once?
Total 22 pages. You are browsing page 4/22.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last