| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> SQL: stupid bot, answer this!
<1> No
<1> Because that is the wrong code anyways.
<0> !perror 1044
<0> ah, I give up
<1> It is the wrong code.
<2> Hello
<3> hi
<3> where can I find the Mysql C API's (linux) ?
<3> it doesn't seem to be in the documentation of it
<0> it's in the docs.
<0> !m _david c api
<4> _david: (MySQL C API) : http://dev.mysql.com/doc/mysql/en/C.html
<3> no, it really isn't
<3> I've checked
<3> or I must have overlooked something
<0> _david: just visit this url.
<3> I just spent 30 minutes analyzing that url ;)
<3> The C API code is distributed with MySQL. It is included in the mysqlclient library and allows C programs to access a database.
<3> that's the closest I get
<1> mysql.com
<1> Download section.
<1> ?
<0> _david: which distro?
<3> ubuntu
<1> That distro has too many 'u's in it.
<3> :p
<0> apt-get install libmysqlclient-dev?
<3> will: nope, not in the download section
<3> Wulf4: oh, great :)
<0> apt-get install libmysqlclient15-dev? or 14 or whatever
<3> it says 12 or 10
<3> installing 12
<3> great, mysql++ is making
<3> thanks Wulf4 :)
<1> You don
<1> You don't want mysql++
<3> I don't?
<1> Do you know what it is?
<3> C++ wrapper for the mysql c api's
<3> ?
<1> You are better off using the C API directly.
<3> I'm such a noob that I don't want to make things harder on me ;)
<5> that was kind of fun
<5> ooh, there's a haskell API? neat.
<6> http://www.volker-wysk.de/mysql-hs/
<6> there're multiple packages
<6> hehe
<5> I wonder if I could code a BF or Ook MySQL API..
<5> s/could/should/
<7> why isn't this valid: WHERE story_date < (NOW() - 7 DAYS)
<6> lra_: - INTERVAL 7 DAY
<7> ahh! thanks
<7> and it's day - that's so stupid!
<8> why doesnt this work? if ($row['var'] > 11) { $foo = $row['var'] - 12 };
<9> if I want to SELECT a field of a table and this field does multiple exists, how can I skip the duplicates?
<10> which command to list all tables in a database ?
<1> megaTherion, SELECT DISTINCT ...
<1> Noboru, SHOW TABLES;
<9> will: I see
<1> megaTherion, It's on a per row level. Meaning it will return distinct ROWs, not fields.
<10> will, im allowed to run ALTER TABLE in a forum on mysql,can i run that from there ?
<6> wooo
<1> I think so...
<10> i mean, run 'show tables;'
<6> or petaTherion
<11> I don't suppose there's any way to truncate a db?
<9> will: thanks that works
<1> DROP it and recreate it.
<10> will, worked,Thank you
<11> I don't really want to drop and recreate db because I will lose any grants on it. Is that right?
<11> or maybe a way to drop all tables?
<1> No
<1> GRANTs are not affected.
<11> So I can drop and recreate db?
<11> I'm getting this error when importing a schema into a new db: ERROR 1005 (HY000) at line 12: Can't create table './dhruba/AccountTransaction.frm' (errno: 150). (The one I just recreated). Any idea what is causing this?
<6> !perror 150
<4> MySQL error: 150 = Foreign key constraint is incorrectly formed
<6> see! :)
<11> Oh god. How do I find out which one is a problem?
<11> My schema is pretty big.
<6> show innodb status;
<6> it's in there, at the 'last foreign key violation'
<11> Ah yes thanks.
<12> morning, is it possible using mysql (client) to connect to localhost and a non default port (33001) without using a socket
<12> looks like its not listening to -P
<1> Yes
<12> i know its possible by using the external ip of the machine but ive made a ssh tunnel which is bound to localhost
<12> wanna tell me how will :P
<13> How would I do a non-BINARY search in a BINARY column? I have a column that is a BINARY varchar containing e.g. "foo", "FOO", "Foo", and I want to find all those rows.
<1> Make sure MySQL is listening to the port.
<1> Set it in my.cnf. Make sure skip-networking is not enabled. Not sure if bind-address will become a problem .Better to comment both out.
<14> silly question .. is there a way to set the timezone in mysql.. Hve coded a site but only today realised that as its BST here in uk .. Im an hour ahead of GMT !!!!!
<12> no but the problem is it aint a server on this machine, its a ssh tunnel to another network
<12> and i know that works, this is just mysqlclient that doesnt wanna connect to a non default port if there is a socket
<12> on localhost
<1> Then it's all about the tunnel
<1> oh
<1> Use -h
<1> mysql --help
<12> -h 127.0.0.1 and it still uses the socket
<1> Use the ip
<1> Of the client box.
<1> And specify port
<15> heu
<15> whats wring with this:
<15> or wrong for that matter
<15> set @g='LineString(1 1,2 2,3 3)';
<15> SELECT GLength(GeomFromText(@g));
<15> ERROR 1064: You have an error in your SQL syntax
<15> 4.0.23
<15> aw fuk, 4.1 and up
<12> looks like -h works, tnx will
<13> Trying again: is there any way to do a case-insensitive SELECT from a case-sensitive (BINARY) columN?
<16> Spanko: no. would make no sense. if the content is case insensitive, why not store it that way in the first place ;-)
<13> Well, I'm planning to code some tagging stuff, so I figured I could store tags case-sensitive as e.g. "1 - iPod; 2 - IPOD; 3 - ipod" so that people can case it as they wish, but searches for anything tagged with "ipod" would find all three.
<13> But I suppose the best way is another table mapping base forms to variants.
<16> oh please
<13> Hm? Am I doing some silly mistake?
<16> ye, over-engineering. keep things simple.
<16> first come, first in. have only one tag like that.
<16> and on that note, I bid you a good day... gotta run, pack, snooze, fly.
<13> Well, that's under-usabilitying, I'm afraid ;)
<13> OK, thanks :)
<1> Make two columns? :)
<13> WHERE lower(name) == "ipod" worked fine.
<13> Would this be very inefficient? Would it still use indices?
<13> On the name column.
<1> lower(name) will not use an index.
<1> Making a second column will use indexes.
<13> Yeah, but a second column wouldn't be normalized, so I should probably create another table or two :)
<1> No way
<1> You balance normalization with "usability"
<13> Hm? Doing "1 - iPod - ipod"; "2 - IPOD - ipod" seems a bit wasteful.
<1> So?
<1> That's what you want.
<13> Well, isn't it... wrong? ;)
<1> No
<1> It's not wrong when that's what you want/"need"
<1> Normalization is a "guideline".
<1> While it is best to follow it, it does not apply to all situations.
<13> And you figure doing something like "iPod - 1", "IPOD - 1" where another table has "1 - ipod" would be a worse solution?
<1> Try it.
<13> OK, thanks.
<13> does UNIQUE imply INDEX?
<1> Yes
<13> Thanks.
Return to
#mysql
or
Go to some related
logs:
#linux
debian etch bttv tuner
send-mail: Cannot open mail:25
hallx049
#kde
#gaim
#perl
3com pcmcia gentoo yenta
ubuntu select screen
reconfigure debian keyb
|
|