| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> lsmith, i just want a value which isnt the same with any other value in the specific column
<1> well without being able to modify the schema
<1> uuid() is your only proper chance
<1> as long as it fits the column
<0> lsmith, int(10)
<1> can you create another table?
<1> then just put the autoincrement there
<1> start trans, insert into separate table, get last insert id, use last insert id for insert
<1> or ..
<1> actually
<0> lsmith, hmm maybe i can just find the max and write max+1
<1> just start a transaction .. loop (look for possible new value) .. insert
<0> how would i do this effeciently?
<2> Showing rows 0 - 29 (234,572,024 total, Query took 0.0005 sec)
<1> psofa: only in a transaction .. actually .. what table type?
<1> err .. anyways you probably want to lock the table
<1> fetch max .. and then insert with max+1
<0> ???
<3> I'm trying to figure out whether there are options to create or emulate an Oracle-type DATABASE LINK from one MySQL instance to another MySQL instance --besides using the Federated Storage Engine. Any ideas out there? The reason for this is that I want to have my application call use its connection to "MySQLDatabase_A" to call a Stored Procedure on "MySQLDatabase_B".
<1> you can do so in a subquery
<4> philverb_tid: Other than federated, no.
<3> lsmith: Were you talking to me?
<1> no
<3> Therion: Thanks.
<1> but i am tired
<1> i shouldnt be talking anyways
<3> lsmith: Okay; thanks anyway.
<5> INSERT INTO Transaktionsdetails (ArtikelDatenID, Verkaufspreis, VK-Datum, EbayNr) VALUES (12, 50 ,#2006-05-26# , '110000170335')" I execute this query for access, therefore # parenthesizers are needed for datetypes (i tried with single quotes too)
<5> Unfortunately, I got a stupid syntax error, anyone has an idea?
<2> The error tells you where.
<5> VK-Datum is a cell which expects date type
<5> nope it doesn't
<5> that was the whole information :/
<5> it works without the date statement
<2> VK-Datum
<5> aahhh
<5> the strange character eh
<5> that*
<5> is it possible to keep that name?
<2> What?
<6> is there a way to dump a mysql SELECT query with output that is basically an INSERT?
<6> I have data that I want to dump from table B without the primary key, so I can turn around and insert it into a different table of identical format
<6> (with existing data)
<6> mysqldump and SELECT INTO OUTFILE are both out, because they include the primary key, which would conflict with the keys of the existing data in the new table
<6> i could just write a perl script, but i thought maybe there was a quicker way
<2> !m dippo insert select
<7> dippo: (INSERT ... SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT_SELECT.html
<8> hello
<9> Is there any way at all to tell how long a CREATE INDEX would take on an InnoDB database?
<10> yes
<9> may I inquire as to how?
<10> you may
<9> Which commands would aide me in being able to determine approximately how long it would take to use CREATE INDEX on a table using the InnoDB storage engine?
<10> you're getting really specific now :P
<9> Because I'm looking for a specific answer.
<9> haha
<10> well i do not know the answer in this case but philosophically speaking it must be possible
<10> it could be a lot of work of course :P
<11> well you cant have a specific answer , there are so many reasons, trying it is the best way
<12> Hi folks. I was wondering if you could tell me why: SELECT * FROM users WHERE name = 'Bob Jones'; returns a result and SELECT * FROM users WHERE LOWER(name) = LOWER('Bob Jones'); does not?
<13> !tell webchick about doesn't work
<7> Alrighty.
<10> pmsl
<12> er. well. Results: 0 found?
<11> webchick, its case insensitive by default
<12> they should both return 1 record, and the first one does, the second one doesnt. Only difference is LOWER.
<13> webchick: version?
<12> inviso, 4.1.13
<12> Could this be a UTF-8 issue?
<13> odd. Is this from the mysql cli?
<12> this does seem to work with a user without the space in the name.
<12> inviso, yes.
<13> webchick: Please put the output from show variables like 'char%'; into the pastebin
<12> inviso, sure. one moment.
<12> inviso, all 100+ vars? ;)
<13> should only be about 7
<9> archivist, I understand that specific times wouldn't be available.
<9> But a ballpark would help :)
<13> dan__t: depends on hardware, current system load, distribution of the data, column size, etc
<11> nobody can possibly tell you as we dont know the size,load, hardware its on etc
<12> inviso, duh. sorry. here you go: http://pastebin.com/740203
<13> dan__t: So, here's the real answer. Create it once and time it. Delete it. Create it again and you'll have a very good approximation on how long it will take.
<14> How can I fail over drbd manually in a single step, I read you use this command 'drbdadm drbd0 primary --do-what-I-say' but it doesn't reconize it,
<14> I am using drbd 0.7 and mysql 5
<13> webchick: blind guess is that the mismatch between system charset and client charset "might" be causing the problem. Very strange though
<12> Hmmm.
<12> Looks like LOWER() works if the username is lowerase to begin with
<13> I'm really reaching though
<13> Could be a 4.1 bug as well
<12> but if it has to do any conversion (e.g. MrBob)
<12> it fails
<15> how to create a user on mysql commandline?
<11> could be a bug in lower(), I wonder which charset from that list it picks up, and does it use the same charset both sides
<9> Not really the answer I waslooking for, but I guess...
<9> thanks, inviso
<9> that's too bad
<13> lol, np
<9> heh
<9> I was thinking someone had to have made a formula or something
<9> Someone, somewhere, HAD to have been that bored at one point or another.
<13> not a chance. Way to many variables
<13> *too
<11> too many variables
<11> how many rows any way
<12> Hm
<12> archivist, do you know how i can figure out what charset I'm using on my system vs. what MySQL is using?
<12> (***uming that was directed at me)
<13> display charset shouldn't matter
<13> what happens if you do select LOWER(name), LOWER('Bob Jones') from table where ...?
<13> do they "look" identical?
<0> whats wrong with that? SELECT * FROM dtv_multiplex AS d LIMIT 0,1 WHERE d.frequency=11117000;
<13> ooooo
<13> !tell us about what's wrong
<7> inviso asked me to tell you this: Don't ask us "What's wrong with this query...". We are not SQL parsers. We do not care to look character by character looking for errors when MySQL will tell all of us WHERE the error is. Paste the FULL error issued by MySQL.
<13> SCORE!
<0> lol
<0> i mean whats wrong with the LIMIT thing
<13> ....
<0> it works fine without it
<12> Ha.
<13> anyway, pasting the error would make it clear that LIMIT is in the wrong spot. Move it to the end
<12> inviso, lower('Bob Jones') returns Bob Jones ;)
<10> lol
<13> woah
<12> nice. :D
<12> hehe
<13> ouch
<12> So I guess what we'll do
<13> My best advice would be to see if an upgrade fixes it. You're behind the 4.1.x current release and you might consider 5.0 anyway
<12> is just make the argument strtolower() w/ PHP
<11> webchick, its case insensitive by default so no need for lower at all
<10> i have 4.1.4 on a test system and it works just fine
<10> er
<10> *4.1.14
<12> archivist, hm. for some reason ='bob jones' doesn't work
<12> so it's behaving case-sensitively
<12> Curses. :P
<10> have you considered just turning off the case-sensitivity ?
<12> sure, I'll google for how to do that.
<11> your collationis blah_bin then
<12> Is it possible for the table to have an incorrect charset? and if so, what would we do to detect that problem?
<12> Or you think it's just plain a bug?
<11> lots of info here http://dev.mysql.com/doc/refman/5.0/en/charset.html
<11> webchick, there are some bugs with lower() in the bug database they seem to be related to the choice of colations so check that (1 bug was fixed at 5.0.18)
<12> archivist, cool. thanks very much.
<12> and thanks inviso too
<16> evening
<16> im having some issues with mysql
<17> anyone who have compared ssh tunneling mysql and using mysql with ssl ? how big is the performance difference ?
<16> wonder if someone can help
Return to
#mysql
or
Go to some related
logs:
#oe
#gentoo
#css
#web
#suse
postfix own transport
Composite extension enabled disabling direct rendering
installing eclipse on dapper
ssh: can't resolve symbol 'fopen64'
python NumPtr windows
|
|