| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> 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 'DEFAULT CHARSET=latin1 COMMENT='Randomly picked numbers'' at li
<1> That's the same error message I remember you having.
<0> dont say nothing rong with " ENGINE = MyISAM "
<1> That's right. ENGINE MyISAM is not the problem,
<0> http://pastebin.com/568151 say error ENGINE=MyISAM .......
<1> The problem is DEFAULT CHARSET
<0> yes
<0> so how to :)
<1> !m TheBest mysqldump
<2> TheBest: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<1> Dump in 4.0 compatibility mode.
<1> Like I explained earlier.
<0> i i read all theat no understund
<0> i am hier now http://dev.mysql.com/doc/refman/4.1/en/static-format.html
<0> http://dev.mysql.com/doc/refman/4.1/en/charset-conversion.html
<3> hxu: if you use CHAR, mysql probably converts it automatically anyway
<4> gaupe: Does the above sentence prove your "3*3 + 4*1" guess?
<1> TheBest, Use --compatible
<0> mysql> Use --compatible
<0> ERROR 1049: Unknown database '--compatible'
<1> ...
<1> Read up on --compatible on the mysqldump page.
<0> i go read about CHARSET a bit. brb
<1> NO
<0> aha i wil
<1> Damn you listen to me.
<0> ok i will lisen
<1> mysqldump page... look up compatible.
<0> but sleepy ... much hourt try :)
<0> ok i will thanks
<1> Go to sleep then.
<0> no i whant to finde out :) the problem to solve
<3> hxu: not really, but it's a guestimate with varchar it's really not a big problem
<5> will: thanks for the tip earlier
<1> Did it help?
<5> well it's definitely faster
<5> but I think I've screwed up the query a bit
<1> Once you have it without the subquery, run the EXPLAIN. Make sure you're using indexes.
<1> (where needed, depending on data)
<5> it's returning a result that is in the table when I want a result that isn't in the table
<4> gaupe: I have to know for sure.
<5> I'll work on it ... but thanks for the tip
<1> Psykick, SELECT a.* FROM a LEFT JOIN b ON a.id = b.id WHERE b.id IS NULL
<1> Do you know about LEFT JOINs?
<5> yip ... just didn't know it speeds things up that much
<3> hxu: you can't know for sure with varchar, if you have to - reserve three bytes per character
<5> that query was taking 12 secs ... now taking less that 2
<1> I mean, do you know how to use LEFT JOINs in the way you can show what is NOT in the other table.
<5> averaging around 1.3
<1> Well, I guess that's good.
<5> yip
<1> yip!
<1> yip!
<1> yip!
<6> stop playing with the bot.
<1> :(
<0> how can i see wich CHARSET i can use
<6> afk
<0> ?
<1> We don't allow bots here.
<1> yip!
<6> who you callin a bot
<1> yip!
<6> stop setting off my highlight
<1> TheBest, You can use anything you want.
<1> :(
<1> Stop using a nick so commonly said then.
<6> you're one to talk there
<0> mysqld --character-set-server=latin1 \
<0> > ;
<0> 060223 8:41:30 mysqld: unknown variable 'character-set-server=latin1'
<0> CREATE DATABASE db_name CHARACTER SET latin1 COLLATE latin1_swedish_ci;
<0> no work on 4.0.x
<1> Why are you trying to do that?
<6> i dont think latin1 is a charset
<1> Why don't you listen to me?
<6> :(
<0> will i PM you
<1> no
<0> to dont SPAM cheannel :)
<1> Everyone here shall learn!
<1> We love SPAM
<0> http://84.244.0.248/VNSB_database.sql
<0> chk theat .sql file i must create all theat TABLE
<1> Dump the SQL in compatible mysql40 mode and you can import into 4.0 just fine.
<0> i dont know how to dump
<0> :(
<1> How did you get the SQL file?
<1> Learn to dump!
<0> i dont use much mysql
<1> !m TheBest mysqldump
<2> TheBest: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<1> Start learning!
<0> i get from a web page
<0> is a score script
<0> for games
<0> :)
<1> There is nothing you can do to import DEFAULT CHARSET into 4.0
<1> UPGRADE TO 4.1+ THEN
<0> how
<0> debian ...no alowed
<1> !m TheBest upgrade
<2> TheBest: (Upgrading MySQL) : http://dev.mysql.com/doc/mysql/en/Upgrade.html
<1> Debian ****s. Don't use it.
<0> is the laste version 4.0.x
<1> Then you are using a crappy distro that makes you use ancient software.
<0> my provider only debia FC3
<0> VDS server
<1> Then switch providers.
<0> i pay them for 1 year.
<0> ;)
<7> will: glad to hear it arrived - took it quite a while, though (almost 2 weeks)
<1> My provider hosts my Web site on WinNT Server SP1...
<8> will, i concur
<1> pCarsten, heh! I thought you'd guys send it from your USA office :)
<7> will: no, they're still all sent from here - we are switching to sending them from across the pond, though
<1> pCarsten, I can't find the NEXT button btw...
<1> :)
<0> ENGINE = MyISAM DEFAULT CHARSET=latin1 " ? COMMENT='Randomly picked numbers'; Can i remove from the line :)) "
<0> CHARSET=latin1
<1> Yes
<7> postal rates are crazy in this country
<1> pCarsten, On the NDA/Logo Usage... heh. :)
<7> will: yes, I know what you're referring to :-)
<1> pCarsten, So now that I got certified, do I get a free p*** to the UC? :)
<5> ok I've got that query working pretty sweet now
<5> thanks a bunch will
<1> How long does it take?
<1> What did you do?
<5> this is the query now
<5> SELECT r.residence_id
<5> FROM residence r
<5> LEFT JOIN campaign_contact cc ON r.residence_id = cc.contacted_residence_id
<5> INNER JOIN location l ON l.location_id = r.location_id
<5> WHERE r.location_id = l.location_id
<5> AND l.location_land_form_id =1
<5> AND l.location_region_id =1
<5> AND l.location_city_id =105
<5> AND l.location_suburb_id =155
<5> AND cc.contacted_residence_id IS NULL
<5> LIMIT 1
<9> it rhymes with "crastefin"
<1> lol
<5> sorry prium
<9> lol i'm just playin
<5> sorry ev re 1
Return to
#mysql
or
Go to some related
logs:
dpkg compiz broken
kxdocker.deb
#perl
fedora mod_file
libXm pkg debian
#python
creative audigy 2 zs *ubuntu
install SQL::Translator, build.pm
atheros 5005g on Edgy
#math
|
|