| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> is it possible to do something like that: select table.*[exept col1] from table; ?
<1> no, nor is it wise
<2> what does length mean in regards to datetime data types?
<3> sorry i have a bad connection
<3> anyone knows how to hide a column from output
<4> hi
<5> hey guys.
<5> is there known issues with a query such as:
<5> "SELECT user.id,user.name,image.id,image.timestamp,image.path FROM user,image WHERE user.id = image.uid GROUP BY image.uid ORDER BY image.timestamp DESC LIMIT 9"
<5> query executes fine, but it doesn't return the newest image rows.
<5> :(
<5> I think its something to do with using a GROUP BY, and the ORDER BY together
<6> hi
<6> hi can anybody tell me how i can know my mysql servername?
<1> heya criix
<1> long time no see
<7> hello. i need aplication to connect on a server. anyone ?
<1> as123td: http://www.catb.org/~esr/faqs/smart-questions.html might increase your chance of getting a, in your perspective, positive response.
<7> tnx
<8> giggels*
<9> hello
<9> I want to install the mysql-devel and I have some problems
<1> 1) that sounds like a RPM-based system
<1> 2) that doesn't sound like a MYSQL problem but a packaging problem
<1> 3) so why are you here?
<9> I want to install this damn mysql-devel but need to install mysql, if I try to install mysql I get an error 'file /usr/lib/mysql/libmysqlclient_r.so.10.0.0 from install of mysql-3.23.58-13 conflicts with file from package mysqlclient10-3.23.58-6'
<9> any idees?
<1> read 1-3 above
<9> can you tell me more ?
<9> I am not so good
<1> http://www.tldp.org
<1> read some system administration guides
<1> then you read the manual of whichever distribution you use
<9> you can't tell me what the hack to do ?
<1> I have a 1000 USD / day consultancy fee
<1> I'll send you the payment details if you want to continue the inquiery
<9> haha ya, right
<9> another one who wants to help me ?
<10> vEnNoms, yes I would love to help you. I would love nothing more than to read the manual for you and re-type every word into this channel to tell you what you need to do. There's just one problem, that mean old K_F will ban me for flooding. Oh well, it's the thought that counts. ;-)
<8> heh
<10> hey grazzy, how's it going
<1> "old"?
<10> lol
<1> he is long gone by the way
<1> 2-3 hours ago
<10> oh, duh. i see that now. :-/
<10> was wondering why he didn't respond
<1> hehe
<11> hello
<11> how can I do a select of two tables to get the IDs of records present in 1st table and NOT present in 2nd table, provided that I cannot use SELECT ... WHERE ... NOT IN ( SELECT ...)
<11> (imbricated selects don't work on this damn server)
<10> http://tyson.homeunix.org/notes/mysql.html
<10> left join
<11> "select A.item from A left join B on A.item=B.item where
<11> -> B.item is null;
<11> is that this one ?
<10> yes
<11> coz if yes, (am gonna work on it again), I didn't manage to let it work properly
<11> ok, gonna give a look again, thanks
<11> ok, that's a bit more complex, then :)
<11> here is the original query :
<11> SELECT id, ec_nom, ec_prenom FROM usager WHERE id NOT IN ( SELECT distinct(t1.id) FROM usager AS t1, gen_etablissement AS t2, gen_affectations AS t3 WHERE t2.type_etablissement="complet.vsx" AND t1.id=t3.id_usager AND t2.id=t3.id_etablissement AND t3.date_fin IS NULL )
<11> the imbricated selects don't work, which makes it cause an error on this server
<11> the problem is that there are additional conditions, an an other join
<1> SELECT version();
<11> 4.0.17-standard-log
<11> but I cannot change it
<1> and you wonder why a subquery doesn't work?
<11> nope
<11> I wonder how to replace it :)
<1> and read up on OUTER JOIN and IS NULL
<1> http://www.kfwebs.net/links/6 for SQL
<11> as I said, I know imbricated selects don't work
<11> I got it working with the example where the "id IS null", but I want to add some extra clause and an other table :)
<12> can anyone recommend me a "quickstarter guide" for mysql ? i want to be able to make a website with mysql in 2 months
<1> http://www.kfwebs.net/links/6 for SQL
<12> sql is different from mysql ?
<1> okay, read the "introduction to sql for beginners"
<1> you need it
<1> and yes
<1> SQL is structured query language
<1> MySQL is a DBMS
<1> you communicate with MySQL using SQL... now read abou tit
<1> about it*
<12> and mysql is the best choice for stuff like databases, right ?
<1> look at the channel you're in
<1> do you really expect an un-biased answer?
<1> in which case you're more stupid than I thought.
<12> nah i just wanted an open minded answer
<1> it is a matter of the right tool for the job
<12> well i have to make a project for school, in may, and i always wanted to learn to work with databases.. do you think i have enough time to make something working by then ?
<1> how should I know, you just wasted 8 minutes
<1> that you could have been using reading about how to use it
<12> well i have other stuff going on
<1> talk to the hand
<12> why are you so hostile ?
<1> http://www.kfwebs.net/links/43
<1> learned from the master..
<8> hehe
<12> ok, i heard about mysql lite or something, what's that good for ?
<8> dyingflame, best way to start with mysql is to "get into it"
<8> then pick up whatever skills you need by reading the manual, tutorials, books whatever
<12> ok, so first i need to download it, right ? :p
<8> yup
<8> are you running windows?
<8> or linux/unix?
<12> both
<8> k, get the linux-version then, im sure most people are more familiar with that in here
<10> dump windoze
<12> but i want to make the project under linux, windows is just good for doing the work
<8> what language are you planning to access the database from?
<12> uhm, something web-based
<12> so i guess php ?
<8> k. then you should get the source for php aswell, you need to compile them yourself to make it work togheter
<12> isn't that the job of the package manager ?
<8> or atlesat you need to compile php
<8> a package manager can eventually do it (i dont know)
<1> package manger manage binary packages
<8> php needs the mysql libraries compiled in anyway
<1> it has to be compiled at some point
<12> not gentoo
<1> portage can manage binary packages
<12> yeah but it's source by default
<1> but in that case your question doesn't make sense in the first place
<10> dyingflame, you probably won't get your project done in time but you should learn mysql anyway for the future. learn mysql first and then learn php.
<12> beebum you think 3 months are not enough ?
<10> if you are starting from scratch with both mysql and php and you are doing a worthwhile project, i doubt 3 months is enough
<10> unless you have all day to spend on it maybe
<10> heh
<1> okay, if I have enough time on it the "in 7 days" version is more in-depth
<10> dyingflame, are you already versed in database design?
<1> beebum: I'm gonna say no
<10> heh
<1> based on "<12> sql is different from mysql ?"
<10> ah
<10> well, throw that in the mix
<12> beebum well just foxpro for dos :D
<10> and getting familiar with unix
<12> beebum i can handle unix
<1> I think dyingflame has the next 20 years scheduled for him
<1> :)
<12> :)))
<10> lol, you should still learn mysql anyway
<12> i know
<13> anyonehere?
<1> no
Return to
#mysql
or
Go to some related
logs:
fiobian
#networking
chopying
#MissKitten
#linuxhelp
#london
is it posible to see idle time in msn
#linuxhelp
#linux
#london
|
|