| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> And now,having sat down and written my first PHP code in over a year this will probably turn out to be horrendus, I think I shall go to bed.
<0> Anyone who would like to mock it may do so at http://tinyurl.com/odtm2
<0> Night.
<1> to select the latest row from a table, using a timestamp col, the syntax would be... select max('timestamp') yes?
<2> order by timestamp desc limit 1
<1> ah ty, much more elegant
<3> hi all...can anyone help me build an sql statement where I'm trying to get the records from last day and month and add them...
<3> I want to do this in one statement..like select (lastday*something+lastmonth*something) group by somefield order desc
<4> Hi! Let's ***ume that I have a table with an enum'd column. How do I extend the set of possible values the column may have?
<5> hi,.
<6> any know of a good book to learn mysql
<6> well a book that you recommended
<7> tdd1984 what are you trying to learn?
<7> you can learn to develop with mysql, be a dba, hack mysql..
<6> firewire: actually what im trying to do
<8> hello.. I have question about an error. I have mysql installed on my server .. After I reboot my server I this error when tring to access mysql phpadmin ... #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)
<6> here I'll show you firewire
<8> I have restarted mysql ... But it has not helped
<6> firewire: I'm trying to create a database for http://www.dewitts.biz/test.php that site. I want my client to be able to access a database, and be easy to use, so she can edit the points on the map like add/remove/modify points on the map
<7> ok
<7> indiana eh
<6> lol
<6> yup
<6> firewire: i would really apperciate it if you could help me with this man honestly i been workin on it for like alllll day
<9> lol car audio and web design
<5> your mother
<6> sickdm: yea im just learning the mysql which i nkow a little bit, but not how to make a database for this map
<7> tdd1984 I'm not sure what your question is
<9> my mother only does one of the above
<9> but not both, that's just messed up
<9> even yours wouldnt do it
<5> haha.
<6> firewire: well i'd like to be able to log into a data base that is userfriendly, so it could be edited like add points to the map, and delete points
<5> so this new job. they said i'd be on a 90 day "probation period"
<5> fourth day on the job, i'm now an employee.
<7> tdd1984 that's not really a mysql specific question
<9> haha, nice
<9> did you just do rm -rf /var/db/mysql
<6> firewire: well its gonna take a database to do what i want
<6> isn't it
<6> under my sql
<7> yeah but you need an application on top of that database
<6> or is there another way of creating just a simple stand alone database that don't use mysql
<6> firewire: what kinda of application
<10> that's what you have to write, tdd1984
<6> dannyp: what a standalone database?
<10> no, an application
<10> to use the database
<6> what kinda application you referring to
<10> whatever application you need
<6> k
<10> with a map, or whatever
<6> dannyp: im trying to develop a thing where the client can log in to edit the points on the map
<6> what should i make the application under
<6> once again you guys thanks for helping
<6> this has been really stressin me out
<6> all day
<6> im not giving up either
<10> if this is a web application and based on what I just saw scrolling up, PHP is fine
<6> k cool
<10> lots of web applications written in PHP use MySQL
<6> dannyp: which the google map is a web app?
<10> what?
<10> is the google map a web application? I certainly would say so, yes
<6> So i should use php to write the web app
<10> you can. should you? I can't answer that for you
<6> k
<6> hmm so ill have to code this from scratch
<10> but this question really has nothing to do with mysql
<6> well im getting there lol
<6> sorry dannyp
<10> very, very slowly
<6> lol yea
<6> well once i make the web app it will talk to mysql
<10> this is like going into an IRC channel for a hard drive manufacturer and asking them questions about mysql, because after all, "mysql is on my harddrive"
<6> dannyp: will you please not critize me
<10> tdd1984: fair enough. I'm going to catch some sleep. have a g'night.
<6> k
<6> relaly quick before u leave
<10> no, sorry, I'm gone.
<6> whats a good program to use to write this web app
<11> tdd1984: grab a book, "PHP and MySQL for Web Development" by Laura Thomson and Luke Welling. it'll help you get going with PHP and MySQL.
<11> tdd1984: you may also consider chilling out a bit and nursing a sense of self-humour. people are not obliged to help you and it appears you already made dannyp not care.
<10> now for real, goodnight, I have my second to last final exam before I get my bachelor's degree in 6 hours
<11> quite
<12> anyone know of a good odbc-compatible database admin tool (view tables, columns queries etc)
<13> anyone here?
<13> if so, could you look at this:
<13> http://nopaste.info/index.php?id=c73d82e751
<13> got a little join problem there
<13> Line 3, the table's not declared until a later join statement, but i don't know how else i could do this
<13> there's a workaround in the mysql doc, but that's only for Cross Joins, not left joins
<13> any ideas?
<13> that'd be great, thanks
<14> declare cur1 cursor for select * from table1; open cur1; for i in cur1 loop; I get a syntax error on the "for i in cur1 loop" isnt it possible to traverse thru the cursor with this FOR statement ?
<14> or can i do " for each row in cur1 loop"
<15> does anyone know how to do case sensitive matching on utf8 text columns with the _ wildcard still working on single characters instead of bytes?
<14> Im not shure but search for " string functions" in the mysql manual, and if you find out please tell :)
<16> hello
<16> a simple doubth:
<16> select * from USUARIO, USUARIO_OFERTAS where USUARIO_OFERTAS.DNI=USUARIO.DNI and USUARIO.DNI LIKE '44444444M%'
<16> with this sql, only return result if the usuario.DNI are in two tables
<16> i want to return data if USUARIO.DNI is in USUARIO TABLE or in USUARIO_OFERTAS table
<14> how do i left join with incoming rows?
<16> select * from USUARIO left join USUARIO_OFERTAS on USUARIO_OFERTAS.DNI=USUARIO.DNI GROUP BY USUARIO.DNI
<16> THIS is the sql i need
<17> hi all
<17> why is it everytime i do this query "select * from table1, table2 where table1.field <> table1.field" i get duplicate numbers of data extract for example i get like 166565 from a table that only has 2000 entry.
<18> roders: cause you're not using an ON clause for your join so you get the full cartesian product of your 2 tables.
<17> ON ???
<17> it won't work here tried it before.
<17> this is the exact query
<17> Select current_mail_live_letters.cust_code AS h_cust
<17> sorry here it is
<11> roders: you can't join on negatives
<17> ok
<11> roders: what are you trying to do?
<17> Select current_mail_live_letters.cust_code AS h_cust From current_mail_live_letters, global_letters ON current_mail_live_letters.cust_code <> global_letters.cust_code Order By current_mail_live_letters.cust_code
<17> oh i think i figured it out
<11> roders: what are you trying to do?
<17> am trying to extract all the data from table2 which is not present in table 1
<11> right
<11> SELECT ... FROM a LEFT JOIN b ON a.id=b.id WHERE b.id IS NULL
<11> with outer joins (left/right) you can find stuff that's missing. inner joins can't do that. they only find matches.
<11> think venn diagrams from school (overlapping circles with numbers). an inner join is where the two circles overlap
<19> hello
<19> how do i load a SQL file?
<17> yeah thats what i've just figured out. just missed out the is null bit thx for the tip
<19> local file
<11> roders: note that NULL is not a value, so you can't use =. the IS is essential
<17> yeah
<11> ROBOd: from the mysql cmdline client, you can use 'source path/filename'
<11> ROBOd: phpMyAdmin can also load SQL scripts
<19> arjenAU: thanks
<19> it's for a guy who doesn't know a bit of mysql
<19> and he most likely doesn't use phpmyadmin
<20> ah goody ... more money coming my way .. client said the signed contract is in the mail
<11> lsmith: contracts don't pay, bills do.
<20> well the contract states a 40% advance payment
<11> ah, good'o
<20> and the total is large enough to be able to afford an escape to the bahamas
<20> for 2 months :)
<20> maybe 3
<14> select count(*) from t1 left join t2 on t1.col1 =t2.col1; gives me the amount of rows thats in t1. But i just want how many rows that matched the conditions, how?
<11> lsmith: save.
<19> gotta go, thanks arjenAU
<19> bye
<11> intercool: match what condition?
<20> arjenAU: yeah .. i will save the bulk .. the rest will go into a new office chair .. and maybe a 24" tft .. if i can figure out what my replicator really supports
Return to
#mysql
or
Go to some related
logs:
grub on suse
#perl
gentoo chroot modules_update
how to invoke ubuntu-desktop
amarok hotkeys win+c
canadgroup.com
perl _function_
#perl
python unescape urllib.urlencode
#kde
|
|