| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<edster> Is there any other takers out there on helping me write a complex sql statement dealing with JOINs?
<NeoThermic> !perror 5
<SQL> System error: 5 = Input/output error
<Kalavera> guys an example for create a very simple table into a mysql db
<niku> I'm trying to insert some a value into a table if a key for it doesn't exist and update the value if it does. I'm getting an error on my syntax and I was hoping someone wouldn't mind taking a look and letting me know what I'm doing wrong. I looked it up in the mysql manual and thought I was doing it right, so perhaps I'm just misunderstanding:
<niku> insert words set 'Date:' = '1' ON DUPLICATE KEY UPDATE 'Date:' = ( 'Date:' + 1 );
<niku>
<niku> ERROR 1064 at line 1: 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 ''Date:' = '1' ON DUPLICATE KEY UPDATE 'Date:' = ( 'Date:' + 1
<niku> I cut off ");" at the end of the line in my paste.
<firewire> 'Date:' = '1'?
<firewire> wtf is that
<niku> firewire, what do you mean? I"m trying to ***ign 'Date:' the value 1
<Kalavera> guys somebody knows the metalogo project ?
<Kalavera> is a java app
<firewire> 'Date:' is a string, you can't ***ign things to it
<niku> ah, 'cause I quoted the 1?
<firewire> what is Date:
<niku> ah, I am being retarded, eh?
<firewire> yes
<bronson> Does anyone know of a diff-like utility that works on tables?
<bronson> Or table dumps?
<Sembiance> :)
<firewire> yeah, diff
<bronson> well then, is there a way of getting a normalized dump?
<bronson> mysqldump dumps colums in different order, has different conventions for wrapping, ...
<firewire> mysqldump will order the columns the way they are in your table
<bronson> End result is that I have to do a lot of hand-editing on dumpfiles before I can diff them.
<Joran> need to write a good sed script then ;-)
<bronson> True, but because of migraitons, some of my databases have columns in different orders.
<firewire> so drop one of them :)
<bronson> So, it sounds like the answer is "no". :)
<Melbell> if i have a table with 2 columns, one an ID with autoincrement, and the other just for a name, what kind of query do i need to give a name and it will get the next available ID number and put both in the table?
<firewire> just put in the name
<firewire> the id will be ***igned automatically
<edster> firewire: you don't have to put null for the id?
<firewire> you can just not specify that column or use null
<firewire> either way works
<edster> ah ok tks
<edster> melbell: if you want an actual query - INSERT INTO table VALUES (NULL, 'name')
<Melbell> edster: thanks!
<Joran> this is definitely a pthreads/uml interaction problem... but where in tux's name can I get support for that? ;-)
<Melbell> edster: it says that ID can't be null (fyi, it's the primary key and autoincrement)
<vole> so to see what SQL my application is sending to mysql, I should set MYSQL_DEBUG=d:t:O,/tmp/client.trace right?
<Joran> any way to make mysql not use mutex' ?
<bobbyd> hi
<firewire> Joran what should it use instead?
<bobbyd> I have the tables from a dead mysql server, is there any way to ressurect the data on a new server?
<Joran> firewire, dunno but in uml it can't mutex.
<firewire> why not?
<Joran> not sure yet... I'm just trying to sort the TLS problem... but that's the next error
<firewire> mysql relies heavily on pthread_mutex
<bronson> bobbyd, yes. How difficult it will be, though, depends on a lot of things.
<bobbyd> bronson, any ideas on where to find info about that?
<null> Is there any way to increment the value of a field without running two queries? - One to get the value and another to store the incremented value after some processing.
<bronson> null, beyond autoincrement?
<Joran> firewire : http://pastebin.com/529559
<firewire> null update t set col=col+1
<null> bronson, i'm not adding another row to the db, merely adjusting an existing row
<firewire> Joran try starting it with --skip-bdb
<bronson> bobbyd, dunno. why not just try it?
<bronson> with backups, of course.
<null> firewire, ooh, that looks promising, does it work with mysql 4.1?
<firewire> yes
<Joran> firewire: oooh... it's running!
<null> Cl***y.
<Joran> firewire: what does that do, and should I leave it that way?
<firewire> it disables the berkely db storage engine
<Joran> i.e. edit the init script to always run it without it
<firewire> which you probably aren't using anyay
<Joran> YAY!!!!! Thankyou so much... I've had to disable TLS for libc and that is the last hurdle...
<firewire> make sure you can create and lock tables before you declare victory
<Joran> firewire, is there a my.cnf option to do the --skip-bdb?
<firewire> skip-bdb
<Joran> =true? =1?
<firewire> no
<firewire> just like I said
<Joran> =true works too :-)
<bobbyd> bronson, I'm getting: warning : 1 client is using or hasn't closed the table prop
<bobbyd> erly
<bobbyd> is there a way to force mysqld to close the tables?
<Joran> firewire, create and lock work :-) thankyou very much
<bobbyd> looks like FLUSH TABLES should do it, but how do I run that if the server won't start up?
<lunaphyte> if i do a mysqldump --all-databases> alldatabases.sql - is it necessary to specify all of the database names when i do a restore with something like 'mysql < alldatabases.sql'
<vole> how do I found out my mysql version?
<zircu> vole: in what role?
<bobbyd> vole, mysqladmin version
<zircu> vole: aka, how are you accessing mysql?
<mxktmdude> hello all
<vole> uhhh, I type mysql from the commandline
<mxktmdude> i have installed munin, a server monitoring chart program. and it has a chart called mysql throughput. Im wondering what is mysql throughput?
<zircu> vole: then mysql --version
<vole> bobbyd, thanks
<vole> ok this must get asked LOTS
<vole> how can I delete the rows of a table that have values not in another table... doing delete from group_control_map where group_id not in (select group_id from group_control_map,groups where group_id = groups.id); gives me the error ERROR 1093 (HY000): You can't specify target table 'group_control_map' for update in FROM clause
<marcz908> I have a table customer, and a table phone, I want to find out all of the customers that have phone numbers, so I'm using an inner join, some customers have 2 phone numbers and so obviously I'm getting that same customer back in 2 rows, but I only want it to come back once, I tried 'select distinct', but that didn't work, how do I accomplish this?
<imodiris> hello
<imodiris> i've got a big big pb
<imodiris> i've export my database with phpmyadmin, then formatm y server, redo ot
<imodiris> and now when i want to reimport my data base i've got
<imodiris> ou have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line
<SD___> hi there
<SD___> can anyone help me with a quick mysql 3.23 question please? i cant find the answer anywhere
<SD___> select a, b, min(c) from t1 group by a; wont give me the correct value of a for min(c). What will?
<SD___> can't use subqueries
<firewire> use the max concat trick
<SD___> max concat trick
<SD___> okay ill look that up
<SD___> thanks
<firewire> yeah
<paq> does anyone know how the builtin mysql fulltext search compares (performance-wise) to dedicated tools like apache lucene?
<firewire> fulltext is pretty basic
<paq> i need to offer fulltext search for 10mio items (255 chars body each) and mysql seems to bog down in my tests even with "only" about 1.5mio items
<firewire> how many queries/second?
<paq> at least 15
<firewire> did you actually build the full text index on that column?
<paq> yes, ofcourse
<firewire> show me the explain output
<paq> sec
<muhoo> my replication is all screwed up
<paq> can i paste here?
<paq> its 5 lines
<muhoo> my slave is linking to mysql-public-bin.000001, but my master is on mysql-public-bin.000041
<muhoo> how can i get the slave up to date with the latest?
<muhoo> do i need to iterate through each one from 00001 to 00041?
<RokSteady> muhoo: check your error log and show slave status
<RokSteady> has it even connected to the master yet?
<muhoo> RokSteady: show slave status shows everything ok
<paq> firewire, it's using the key, if thats what you're after :)
<firewire> I want to see how well
<firewire> 15 queries/second is horrible
<muhoo> RokSteady: it seems to be, processlist says yes
<RokSteady> muhoo: what does Exec_master_log_pos say?
<RokSteady> muhoo: ok
<RokSteady> what does the processlist entries for System user say then?
<muhoo> 2476
<paq> firewire, what figures should i look out for? i notice i just cleared the key on the test db
<muhoo> "Has read all relay log; waiting for the slave I/O thread to update it"
<firewire> paq can you show me the explain output?
<muhoo> oh wait, Connecting to master
<paq> firewire, not right now, i'll rebuild the index, hold
<RokSteady> exactly, so check your network/permissions/whatever error
<firewire> muhoo what does the error log say?
<muhoo> which error log?
<RokSteady> mysql error log of course
<RokSteady> mysqld
<muhoo> gotta find it, hold on
<sc_fc4> my work or some reason wants to use ASPX instead of php =/ to pull DB info from. Anyone know of a good place to find tutorials for grabbign data outta mysql with asp?
<sc_fc4> and what is the most secure way to do that? just reference the internal IP or DNS name from the internal number?
<sc_fc4> (RUnning fedora core 4 with mysql and 2003 server with asp.
<sc_fc4> Im not doing a work project. But the more I can prove I know the easier it will be to get a job with em. Im used to php/mysql
<sc_fc4> so Im emulating work.
Return to
#mysql
or
Go to some related
logs:
build msdos fsck.msdos gentoo
install vhcs on ubuntu
serial mouse configure xubuntu
gentoo saslpasswd2: SQL engine 'mysql' not supported
ubuntu modprobe usbmouse
mythtv kernel_ulong_t
#css
#css
wperl vs perl
kfrb autostart
|
|
