| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> Is there any other takers out there on helping me write a complex sql statement dealing with JOINs?
<1> !perror 5
<2> System error: 5 = Input/output error
<3> guys an example for create a very simple table into a mysql db
<4> 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:
<4> insert words set 'Date:' = '1' ON DUPLICATE KEY UPDATE 'Date:' = ( 'Date:' + 1 );
<4>
<4> 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
<4> I cut off ");" at the end of the line in my paste.
<5> 'Date:' = '1'?
<5> wtf is that
<4> firewire, what do you mean? I"m trying to ***ign 'Date:' the value 1
<3> guys somebody knows the metalogo project ?
<3> is a java app
<5> 'Date:' is a string, you can't ***ign things to it
<4> ah, 'cause I quoted the 1?
<5> what is Date:
<4> ah, I am being retarded, eh?
<5> yes
<6> Does anyone know of a diff-like utility that works on tables?
<6> Or table dumps?
<7> :)
<5> yeah, diff
<6> well then, is there a way of getting a normalized dump?
<6> mysqldump dumps colums in different order, has different conventions for wrapping, ...
<5> mysqldump will order the columns the way they are in your table
<6> End result is that I have to do a lot of hand-editing on dumpfiles before I can diff them.
<8> need to write a good sed script then ;-)
<6> True, but because of migraitons, some of my databases have columns in different orders.
<5> so drop one of them :)
<6> So, it sounds like the answer is "no". :)
<9> 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?
<5> just put in the name
<5> the id will be ***igned automatically
<0> firewire: you don't have to put null for the id?
<5> you can just not specify that column or use null
<5> either way works
<0> ah ok tks
<0> melbell: if you want an actual query - INSERT INTO table VALUES (NULL, 'name')
<9> edster: thanks!
<8> this is definitely a pthreads/uml interaction problem... but where in tux's name can I get support for that? ;-)
<9> edster: it says that ID can't be null (fyi, it's the primary key and autoincrement)
<10> so to see what SQL my application is sending to mysql, I should set MYSQL_DEBUG=d:t:O,/tmp/client.trace right?
<8> any way to make mysql not use mutex' ?
<11> hi
<5> Joran what should it use instead?
<11> I have the tables from a dead mysql server, is there any way to ressurect the data on a new server?
<8> firewire, dunno but in uml it can't mutex.
<5> why not?
<8> not sure yet... I'm just trying to sort the TLS problem... but that's the next error
<5> mysql relies heavily on pthread_mutex
<6> bobbyd, yes. How difficult it will be, though, depends on a lot of things.
<11> bronson, any ideas on where to find info about that?
<12> 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.
<6> null, beyond autoincrement?
<8> firewire : http://pastebin.com/529559
<5> null update t set col=col+1
<12> bronson, i'm not adding another row to the db, merely adjusting an existing row
<5> Joran try starting it with --skip-bdb
<6> bobbyd, dunno. why not just try it?
<6> with backups, of course.
<12> firewire, ooh, that looks promising, does it work with mysql 4.1?
<5> yes
<8> firewire: oooh... it's running!
<12> Cl***y.
<8> firewire: what does that do, and should I leave it that way?
<5> it disables the berkely db storage engine
<8> i.e. edit the init script to always run it without it
<5> which you probably aren't using anyay
<8> YAY!!!!! Thankyou so much... I've had to disable TLS for libc and that is the last hurdle...
<5> make sure you can create and lock tables before you declare victory
<8> firewire, is there a my.cnf option to do the --skip-bdb?
<5> skip-bdb
<8> =true? =1?
<5> no
<5> just like I said
<8> =true works too :-)
<11> bronson, I'm getting: warning : 1 client is using or hasn't closed the table prop
<11> erly
<11> is there a way to force mysqld to close the tables?
<8> firewire, create and lock work :-) thankyou very much
<11> looks like FLUSH TABLES should do it, but how do I run that if the server won't start up?
<13> 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'
<10> how do I found out my mysql version?
<14> vole: in what role?
<11> vole, mysqladmin version
<14> vole: aka, how are you accessing mysql?
<15> hello all
<10> uhhh, I type mysql from the commandline
<15> i have installed munin, a server monitoring chart program. and it has a chart called mysql throughput. Im wondering what is mysql throughput?
<14> vole: then mysql --version
<10> bobbyd, thanks
<10> ok this must get asked LOTS
<10> 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
<16> 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?
<17> hello
<17> i've got a big big pb
<17> i've export my database with phpmyadmin, then formatm y server, redo ot
<17> and now when i want to reimport my data base i've got
<17> 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
<18> hi there
<18> can anyone help me with a quick mysql 3.23 question please? i cant find the answer anywhere
<18> select a, b, min(c) from t1 group by a; wont give me the correct value of a for min(c). What will?
<18> can't use subqueries
<5> use the max concat trick
<18> max concat trick
<18> okay ill look that up
<18> thanks
<5> yeah
<19> does anyone know how the builtin mysql fulltext search compares (performance-wise) to dedicated tools like apache lucene?
<5> fulltext is pretty basic
<19> 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
<5> how many queries/second?
<19> at least 15
<5> did you actually build the full text index on that column?
<19> yes, ofcourse
<5> show me the explain output
<19> sec
<20> my replication is all screwed up
<19> can i paste here?
<19> its 5 lines
<20> my slave is linking to mysql-public-bin.000001, but my master is on mysql-public-bin.000041
<20> how can i get the slave up to date with the latest?
<20> do i need to iterate through each one from 00001 to 00041?
<21> muhoo: check your error log and show slave status
<21> has it even connected to the master yet?
<20> RokSteady: show slave status shows everything ok
<19> firewire, it's using the key, if thats what you're after :)
<5> I want to see how well
<5> 15 queries/second is horrible
<20> RokSteady: it seems to be, processlist says yes
<21> muhoo: what does Exec_master_log_pos say?
<21> muhoo: ok
<21> what does the processlist entries for System user say then?
<20> 2476
<19> firewire, what figures should i look out for? i notice i just cleared the key on the test db
<20> "Has read all relay log; waiting for the slave I/O thread to update it"
<5> paq can you show me the explain output?
<20> oh wait, Connecting to master
<19> firewire, not right now, i'll rebuild the index, hold
<21> exactly, so check your network/permissions/whatever error
<5> muhoo what does the error log say?
<20> which error log?
<21> mysql error log of course
<21> mysqld
<20> gotta find it, hold on
<22> 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?
<22> and what is the most secure way to do that? just reference the internal IP or DNS name from the internal number?
<22> (RUnning fedora core 4 with mysql and 2003 server with asp.
<22> 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
<22> 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
|
|