| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> lol i meant i only wanna select duplicate songs
<0> title artist column
<1> gleam-: huh?
<0> different artists can make the same song
<0> so i want to create a new table and only insert songs by the same artist once
<2> will, it would probably be most useful as 0-6 for the day of week and a unix timestamp for the date, but is this really the best solution for the column types?
<3> linolium, Like I said, depends on how you query the tables.
<0> so would CREATE TABLE lyrics2 SELECT DISTINCT title,artist FROM lyrics; achieve this? Create a new table and insert distinct songs by same artist~
<3> TRY IT
<3> DISTINCT works at a row level, meaning title,artist have to be distinct.
<0> cool
<0> and yeah i tried it like 5 minutes ago~
<3> snakeman, I don't use MySQL Administrator. So I don't know. But there is a reason why you're getting that error, and that page explains.
<4> akumanz: when will gets annoying kick him with '!kick will'
<3> akumanz, So why did you ask?
<3> blobaugh...
<4> will: :D
<0> cause i couldnt' relaly tell if it worked correctly
<3> Why not?
<0> i know now anyway. works at row level. sweet
<5> will: yeah, thanks
<2> will: it would be nice to be able to SELECT and get something like "Wednesday at 9:30 PM"
<3> !m linolium date and time functions
<6> linolium: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<3> MYSQL ROCKS
<0> yeah
<0> my gay university cl*** uses SQL+ oracle
<2> would it be inefficient to use a 0-6 integer and create a date object every time with that to get the name of the day of the week?
<3> Nothing wrong with Oracle.
<0> mysqls better
<3> Depends
<7> I went to a straight university, and we were taught on Oracle too.
<0> oracle sql+ is pretty lame from what i've grasped of it so far. mysql seems to have more features
<3> linolium, You could do that...
<2> or would it be better to DAYNAME(FROM_UNIXTIME(x*24*60*60))
<8> when you do groupby can you concatenate as an agregated function so that for each group you end up with an agregated concat of a column ?
<3> linolium, It all depends on the situation.
<3> You have to define "better".
<2> faster.
<9> hmm.... any wicked nerds out there?
<3> Nope
<9> =)
<9> thanks
<3> We're just plain nerds
<9> well ill just throw it out there....
<7> dos000: See GROUP_CONCAT()
<3> Bah! That's the name of the function...
<3> Couldn't remember it.
<7> eekrano: No but a few saintly ones.
<9> i have a redhat9 VDS through godaddy, mysql 3.23.58 and php 4.4.2 ..... queries in php aren't working.... php or mysql problem?
<3> Define "Aren't working"
<3> 3.23?
<9> yeah... they all fail
<3> I would not be using them.
<7> On strike
<3> WITH WHAT ERROR MESSAGE?
<7> !tell us about doesn't work
<6> mhillyer asked me to tell you this: Look buddy, doesn't work is a strong statement. Does it sit on the couch all day? Does it want more money? Is it on IRC all the time? Please be specific! Give us the FULL EXACT error message. Tell us what it does and/or does not do.
<9> Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in <page> <line>
<7> Oh bot
<7> boy even
<9> same with mysql_fetch_rows()'
<3> Means that the mysql_query() was bad. Put a mysql_error()
<10> is there a way to refer to a field in a table by its column number rather than field name?
<7> I'd rather sleep, night all.
<3> nite
<4> nite mhillyer
<3> SubOne, Why would you want to do that?
<10> so that i dont have to p*** a field name through pages
<9> well, weird thing is... i saw this on a new site i was putting together.... then i checked my old site which has worked fine for years.... same errors
<7> SubOne: No, only the columns from the SELECT, but it is bad even then.
<3> SubOne, No
<9> so it isnt the query structure
<3> eekrano, Yes it is.
<10> no way to do it in an update?
<3> no
<10> ****s
<3> You should be checking your data too.
<3> You can use numbers, but then in your app transform them.
<10> yeah i suppose
<9> well... the same query when cut from php and pated into a mysql prompt works fine...
<9> ?
<10> is there a way to first get the field names?
<8> will, i am on debian sarge .. and stuck with mysql 4.0 ! so i cant do group_concat. workarounds exist ?
<11> or you could p*** th column names around in the session data or something.
<3> SubOne, Sure!
<3> dos000, Nope! Upgrade! 4.0 is OLD
<10> howso
<3> Many many ways
<11> if you insist on using debian's packages you should use backports
<11> i'd advise not using debian's packages and downloading the official binaries.
<9> will, any tests / ideas / suggestions?
<3> GIVE ME AN ERROR MESSAGE
<3> Like I asked for earlier.
<9> Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in <page> <line>
<10> will, how would i do it
<3> The mysql_query() is bad. Use mysql_error to find out why _query failed and not giving you a result resource.
<3> Which I said earlier!
<3> SubOne, Check INFORMATION SCHEMA
<3> I'm trying to find a date online! People stop bothering me!!!
<11> will is spending the big bucks for eharmony
<3> When you get desparate!
<3> How much is eharmony?
<11> i haven't a clue
<11> but i think it's reallly expensive
<3> Why? You said it was big bucks so I want to know!
<11> 1 month $60
<11> 3 months $37/mo
<3> OUCH
<2> why does " SELECT STR_TO_DATE('04/31/2004', '%m/%d/%Y'); " generate a syntax error?
<3> haha
<11> 6 months $29/mo
<11> year $21/mo
<3> mysql> SELECT STR_TO_DATE('04/31/2004', '%m/%d/%Y');
<3> +---------------------------------------+
<3> | STR_TO_DATE('04/31/2004', '%m/%d/%Y') |
<3> +---------------------------------------+
<3> | 2004-04-31 |
<3> +---------------------------------------+
<3> 1 row in set (0.01 sec)
<3> Works for me!
<3> Probably the ; at the end.
<2> eh?
<2> it's called a statement terminator?
<3> It's called not necessary in YOUR situation.
<2> well it doesn't do anything unless I put one
<3> But not knowing what you are really doing...
<0> question. is it possible to find an Replace a certain string ONLY if it is right at the start of a field?
<3> Ok what is the error message?
<2> perhaps I'll just ***ume 4.0.22 does not have that function
<3> !m linolium date and time functions
<6> linolium: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<2> it says: ERROR 1064: 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 '('04/31/2004', '%m/%d/%Y')' at line 1
<2> yes thank you, I'm there
<11> it doesn't, linolium
<12> use a version that supports it
<3> akumanz, Yes
<0> how do you do that
<2> ok, thanks gleam-
<3> akumanz, Well be more specific on what you want
<3> Leithal, Howdy
<9> will, i've got to apologize
<0> in my lyrics column i have strings of text called <NewLine>. I just wanna find & replace it with nothing if it's at the very beginning of the field
<3> To?
<9> i must be a tired toolbag right about now
<12> hey will
<12> I'm in VEGAS!
<3> Nice!
<12> with Therion
Return to
#mysql
or
Go to some related
logs:
#math
grenitch time zone
statistics: max connection rate 1/60s for (smtp:
crossdev glibc-2.4 is nptl-only
#lgp
PHP PEAR must be installed
SILI GOTCHA
ubuntu pcsx2
search files in ubuntu
#lisp
|
|