| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> i need to somehow modify this query... http://pastebin.com/565769 so that test_attendees.ATTENDEE_ID = test_orders.attendee_records'%|'
<0> but i don't know the syntax for a wild card off of a table.fieldname
<0> could anyone help me?
<0> ehlo?
<1> depends if your just going to swear at us again
<0> i promise
<0> can you help?
<0> i just don't know the syntax for adding a wildcard to the end of test_attendees.ATTENDEE_ID = test_orders.attendee_records
<1> youve had good advise so far and cursed at everybody
<2> how do i use mysqldump to insert data into an existing db?
<0> ok well...
<0> prolly cause whats happening now...
<0> nothing
<3> no-dx: use concat
<3> no-dx: however it is going ot be horribly inefficient, just FYI
<0> i know... i don't wanna use concat
<0> i just wanna add a wildcard to the end...
<4> what happens if mysql doesnt have swap space? does it create files in /tmp?
<3> yes, concat a % then use LIKE
<2> i've got "mysql -u root -p < dump.sql" but how do i just put ALL the tables in the dump to one database (just got tables in the dumb.sql file)
<3> col LIKE 'a%'
<3> winmutt: depends on the operation, it will normally create neccesary items in the tmpdir setting (which under unix is normally /tmp)
<0> i don't wanna use concat
<3> uhm, why not? it does what you want?
<4> HarrisonF: what happens if /tmp get full?
<0> harrisonF... its horribly inefficient...
<3> winmutt: you will start getting errors back for queries where it needs it
<2> any help with mysqldump?
<3> no-dx: yup, a poor database design will do that
<0> i just wanna add a percent like i would here... field = '%".$bleh."'
<3> no-dx: i dunno why you are doing comparisons with wildcards between tables
<0> are you going to keep telling me whats wrong with my database or just help me?
<3> I DID TELL YOU
<3> USE LIKE AND CONCAT
<0> cause unconstructive criticism is useless..
<0> I DON"T WANNA USE CONCAT
<4> HarrisonF: a coworker is running optimize, swap was unmounted at the time, the tmp files were created and deleted
<3> then you can't do what you want.
<0> then why does it work here? field = '%".$bleh."'
<3> that will look for %bleh
<3> do you want a wildcard?
<0> why can't i do it with table.field = table.field'%' or something...
<3> because your syntax is wrong
<4> HarrisonF: can we shutdown during the middle of OPTIMIZE
<0> $bleh being a php variable...
<0> then whats the syntax for that?
<3> CONCAT()
<0> oh my god
<0> bah
<5> hmm
<5> ok i think this is a tough one: how can i tell mysql to count how many words or matches of a certain word are in a field?
<3> winmutt: sure, or you can kill the OPTMIZE, it is okay to terminate
<5> preferably some regular expression
<5> it seems so obvious, but i haven't found a function that counts matches of a substring in a field
<4> tnx harrison
<3> danfg: don't think there is a way to count the number of matches...
<5> isn't that lame?
<0> harrisonF... what about a for statement?
<0> or foreach
<6> danfg: not really, no
<6> it's a database, not a text processing engine
<6> features like that are 'nice', but they're bonuses
<3> you could in theory create a function to do it in 5.0
<5> Darien, what am i processing? mysql counts stuff too. it returns matches too. why can't it count matches? :)
<3> danfg: it just isn't a really common thing to want to know, so it doesn't exist
<3> danfg: but again, you could create a function to do it in 5.0
<5> HarrisonF, i'd argue that, but that would be pointless here :) thanks
<6> danfg: it counts rows
<7> i'm trying to see what mysql.user is. is that a table in the db named "mysql" ?
<5> Darien, i want to try some stuff before giving up. brb
<3> kreg_work: the user table in the mysql database
<7> guess i've never seen a table named with a . before
<6> danfg: writing your own function would not be an entirely terrible idea
<3> kreg_work: the table doesn't have a '.' that is specifying the hierarchy
<8> Hi all. I've just been recommended this room for starting up a database I can use on my website, but I have never even heard of sql. Can anyone point me to an idiots beginners guide?
<5> Darien: agreed. last resort though. i have to make sure mysql can't do that for me somehow. makes sense?
<1> !tell foxgamer about tutorial
<9> Alrighty.
<8> Thanks :)
<10> #1270 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation 'replace'
<10> what does that mean?
<10> i used char() in a replace()
<11> Hello
<11> Hello, is anyone there?
<12> what would be the most efficient way to grab all results from the past 12 months up to this month?
<12> newvermind.. hehe
<13> I'm migrating a database from 4.0 on one server to 5.0 on another, and have problems with certain utf8 characters
<13> what could be the problem
<14> i've got a table called event (with an id/title/description) and a table called eventdatetime (which has an event_id(which references my event table) and a date/time). I want to list all my events that are upcoming. I'm aware of how to JOIN the tables, I'm just stumped as to what I should use in my where clause when joining these tables - thanks
<15> hi all
<15> i have a table that is defined as data1 decimal(10,1) tstamp datetime and id int(10) unsigned auto_increment
<16> how do I set the default value of a new field to current time? I've tried: ALTER TABLE `voip`.`VoIPKickedUsers` MODIFY COLUMN `createtime` DATETIME NOT NULL DEFAULT 'now()';
<15> inside this table the data actually looks like this
<17> Hi. How do I compare a datetime (mysql 4.0) field against a datetime string?
<15> 6.3 2006-02-16 11:07:06 5
<15> i basically have a value for every second in time
<15> my question is is there a way to have mysql average up the data for one minute given the data i have in my table?
<6> BucWheat: sounds like you want date_diff()
<6> you want the last minute of data?
<6> SELECT AVG(data1) FROM table WHERE tstamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 MINUTE);
<6> err, >=
<18> any ideas how I can get mysql 5.0 to accept 4.0-style p***word hashes?
<19> is there a formula to calculate mysqls total memory usage
<6> !m btffmog old client
<9> btffmog: (Client does not support authentication protocol) : http://dev.mysql.com/doc/mysql/en/Old_client.html
<18> thanks
<6> np
<15> Darien let me show you my current query
<6> I'm friggin hungry
<15> SELECT * INTO OUTFILE "foo.txt" FIELDS TERMINATED BY '\t' FROM t_data1 where (tstamp >= date_format(date_sub(now(),interval 13 hour),?)) AND (data1 >= 0) ORDER BY tstamp DESC
<15> Darien this gives me the data from the table for 13 hours
<15> from now to 13 hours ago
<6> ok
<6> did you show me this because what I suggested doesn't give you what you want?
<15> Darien this is what i'm doing now and i wanted you to see it because i have to have the past 13 hours worth of data
<15> Darien i'm trying to add the averaging of data values in a minute based on the tstamp column
<15> this way it will cut down on my data plots when i try to plot this output in gnuplot
<6> did you try what I gave you?
<15> Darien i'm about to put it into console now
<6> ok
<15> the query you submitted works like a treat but it does it for all of the data in the table. i need to fix it to where it gives me the data1 date for every minute within the past 13 hours
<20> what's wrong with..
<20> timestamp datetime not null default 'now()'
<20> i'm getting an error saying that it's malformed or something
<1> timestamp does not need now()
<1> !man timestamp
<9> (Overview of Date and Time Types) : http://dev.mysql.com/doc/mysql/en/Date_and_time_type_overview.html
<18> fixed, thanks all
<15> Darien Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
<16> cyphase: I asked that question 20 minutes ago. Please let me know if you figure it out
<15> i get that error when i run this query
<15> SELECT AVG(data1),tstamp INTO OUTFILE ? FIELDS TERMINATED BY '\t' FROM t_data1 where (tstamp >= date_format(date_sub(now(),interval 13 hour),?)) AND (data1 >= 0) AND (tstamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 MINUTE)) ORDER BY tstamp DESC
<20> BearDK, it seems the author of the code made mroe mistaks then just that
<20> more*
<16> cyphase: I'm trying: ALTER TABLE `voip`.`VoIPChannels` MODIFY COLUMN `createtime` DATETIME NOT NULL DEFAULT 'NOW()';
<1> you cannot default to now()
<1> use a timestamp type
<15> Darien here it is without the outfile: SELECT AVG(gas),tstamp FROM graph where (tstamp >= date_format(date_sub(now(),interval 13 hour),"%Y-%m-%d %H:%M:%S")) AND (gas >= 0) AND (tstamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 MINUTE)) ORDER BY tstamp DESC;
<6> BucWheat: oops
<15> how do i fix that?
<15> !man group by
<9> (GROUP BY Modifiers) : http://dev.mysql.com/doc/mysql/en/GROUP-BY-Modifiers.html
<15> Darien after further testing your query does not work
<15> i will hunt you down tomorrow because i have to run home now
<15> thanks for the help
<6> sure
<21> hi, guys!
<21> hey, one question... does this statement in SELECT table.whatever{1,2} expands to table.whatever1 table.whatever2
<21> anyone?
Return to
#mysql
or
Go to some related
logs:
+ubuntu +ipforwarding
apache key = e74
trivia v5 mckruger donwload
imerge gentoo
#gimp
#mysql
#qemu
#linux
allenknutsonsotherclass
#css
|
|