| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> it has come up a fair few times tonight :P
<1> hi, i'd like to combine a insert with a nested select.. this it the syntax that I have for it, please could you help as i don't know why this isn't working:
<2> Evening andrewbryson - p***word reset or 'mysql wont start' are FAQs :-0
<0> yup i know
<0> but sometimes it is fun to draw things out
<2> even FFQQs
<2> or even FFAQs
<1> INSERT INTO `REQUEST` (`trans_id`, `delivery_date`, `type_id`, `prod_protoype`, `prod_copy`, `product_id`) VALUES ('0', '0000-00-00', '1', '0000-00-00', '0000-00-00', (SELECT `product_id` FROM `BOOKS_DATA` WHERE `book_id` =1 AND `type_id` = 1));
<0> heh i had a real gaff earlier :$
<1> sorry that wasn't meant to be so long.. basically i would like the `product_id` to be the result of the select query.. how can i set this?
<0> completely missed that someone was trying to use from as a column name :P
<2> OMIGOD !!
<0> i blame the lack of sleep
<2> As good a reason as any
<0> well i haven't touched the white shiraz tonight :P
<2> What is tonight's drop?
<0> nothing at all
<2> Must go for a while - Spicks and Specks is about to be on
<2> Plus dinner is about to be on
<0> wouldn't do to miss dinner
<2> No, the cook might get peeved
<2> bbl
<3> anyone? is there a way to give a directive on my mysql server (windows) to be case sensitive like in linux?
<0> it looks scary infi
<0> ruid0: yes
<3> :)
<1> it would be great if you have a link to anything that might help me even as i'm not sure at all.. i know you can have select statements nested in inserts but i don't know what's wrong with the way that i have done it.. thanks
<0> lol i meant that spicks and specks looks scary
<4> watergl***: what version mysql?
<3> andrewbryson: can you tell me how?
<5> hi, after i've dropped a database the record remains in the mysql.db table - how should i remove this?
<0> ruid0: nope
<3> hehe
<3> ok
<0> ruid0: but at least one of my databases is case sensitive so it must be possible
<1> infi: thanks, it's 4.1.14-standard
<0> have just never bothered to look into why since it is not important for any current projects
<4> watergl***: ok, next question, EXACTLY what error do you receive? (please paste the error message)
<3> i see~
<6> hi all
<3> i don't mean sensitive searches, .. but the name of the tables, and rows itself
<6> is there some easy way to create relations in mysql using phpmyadmin?
<7> table name in mysql is filename, so case sensitiity depends to the filesystem
<6> and what happens when i delete a record, that has a relation, with php? database gives error back?
<7> there are some configuration in mysql though
<3> i can't find those configurations
<3> :(
<7> ruid0: i think it is something like lowercase... something
<7> ruid0: check the list of option in the database administration chapter in the manual
<1> infi: hmmmm i DIDN'T get an error this time.. it worked.. soooo sorry.. but i copied and pasted the queries both times.. confused!
<4> k
<6> anybodyu could help me?
<7> Mosselmaniac: rdbms has no relations as in er diagram, but has constraints and there is foreign key constraint, not sure if that works for you
<3> ok. thanks ,.. i will look at it
<3> gracias
<3> =)
<6> yeah, but i need to write the query for the constraints myself, phpmyadmin doesn't support easy stuff for that?
<4> No, not LEARNING, THINKING, AND TYPING! Say it isn't so, Charlie Brown!
<4> Mosselmaniac: Perhaps you are thinking of MS Access.
<7> if phpmyadmin don't have, then maybe try find another tool that has, maybe workbench has something but I am not sure
<8> hello
<8> how do i allow a mysql function to return a table instead of of a scalar value
<7> not possible
<8> so i can only return scalar values?
<8> it thought mysql was at least good a sql server
<0> well we like it :P
<8> ok
<8> i wanted it tobe thedatabase for my content management system for an SMPP application (SMS)
<0> is there a reason that it cannot be ?
<0> all of my cms use mysql
<8> it can
<8> i just have to change up my design a little
<8> the reason why i go to mysql is becuase of the speed
<0> go to mysql from what ?
<9> bah, figures that this homegrown database regenerator is broke too.
<8> i started to with mysql
<10> Ryugi: procedures can return datasets
<11> let's say I have a function a that returns:
<11> 1 | 1
<11> 2 | 2
<11> how would sql server return SELECT a(col1) FROM t1
<11> if t1 has
<11> 1
<11> 2
<11> 3
<12> From what number of rows there is a point to add optimization index on fields to speed up SELECTs?
<13> Hi Guys, how can I say I want to select all UNIQUE entrys in a column???
<11> Wonderboy: SELECT DISTINCT ... is the syntax you want to look at. that or GROUP BY
<12> Wonderboy: SELECT DISTINCT colname FROM tableNamel
<13> Thanks Guys!
<11> zimnyx: 1 row
<11> or even 0
<11> actually
<12> flupps: tables that i;m concidering won;t reach 1000 rows, but they are often used.
<12> I'm not talking about PK, i'm confidering other columns tht are used in selects.
<11> zimnyx: well, if a table is small, the index will be really small too
<11> but it'll help the optimizer and make it able to shuffle around table(s) join orders
<11> and, it's good practice besides that
<11> scanning also uses a lot of buffers that has to be allocated
<12> I thougth so, thanks!
<3> hei: anyone?
<3> SELECT utilizadores.utilizadorId, utilizadores.grupoId, utilizadores.nome, utilizadores.email, utilizadores.contactos, utilizadores.pai, utilizadores.previlegios, utilizadores.dataEntrada, utilizadores.dataExpiracaoLicenca, utilizadores.activo, datediff( utilizadores.dataExpiracaoLicenca, '2006-5-31' ) , grupos.tipo
<3> FROM utilizadores
<3> in my windows server this works right
<3> in the hosting, it does not
<9> anyone got a quick way to drop tables matching a pattern?
<3> it's linux
<3> the problem is in DATEDIFF syntax
<3> what do i have to change?
<4> ruid0: learn about table aliases ;)
<0> i would worry more about the grupos bit :P
<0> heh and aliases :P
<4> ruid0: SELECT u.col1, u.col2, ... FROM utilizadores AS u WHERE ...
<4> or just "utilizadores u"
<9> i've got probably 300 tables i want to delete, and 4 i want to keep.
<3> you think it's that will make it work different?
<4> no, it will simplify/shorten the SQL though.
<0> ruid0: no it makes it more readable
<3> ahh
<3> defenetly that :)
<0> a *lot* more readable
<4> (or use a stored procedure..)
<3> but how about the datediff?
<4> ruid0: paste the query on the pastebin listed in the topic. it was so long it was cut off.
<3> ok
<14> Hi. I am generating a .sql file. I want to INSERT into one table. Then I want to use that LAST_INSERT_ID() to INSERT f.e eight rows into another table. The file I generate does INSERT INTO table1, SELECT @ID:=LAST_INSERT_ID(); then eight INSERT INTO table2 (ParentID) VALUES (@ID). Is there a better way to do this ?
<14> Ofcourse I insert other values aswell into table1 and table2
<3> the pastebin on topic isn't working
<3> infi , .. sorry lag http://pastebin.us/282
<3> the problem seems to be in datediff, .. note that : utilizadores.dataExpiracaoLicenca is a date
<12> quit
<3> NEVERMIND
<3> ops ,.. caps
<3> seems the host mysql version does not suport datediff
<3> err
<3> gota make a function equivelent to datediff
<3> anytips?
<15> i get now error output in my browser when executing a wrong mysql command with php
<15> i get no error output in my browser when executing a wrong mysql command with php
<3> 2 times?
<3> :)
<15> sorry
<15> do you know howto fix my problem?
<16> wave: display the error with mysql_error()
<15> hm, mysql_error() returns a string?
<16> yes
<16> !php mysql_error
<17> mysql_error: http://us3.php.net/manual-lookup.php?pattern=mysql_error&lang=en
<4> !perl t
Return to
#mysql
or
Go to some related
logs:
#linux
#linux
#web
how to remove IPB trial
#math
boot-admin ubuntu
lineakconfig para ubuntu
ubuntu wrong soundcard
fc5 disk mounter
gentoo Failed on MD5 verification
|
|