| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> include directory
<0> not increment
<1> Is it possible to copy just the structure of a table without doing a mysqldump and re-importing it?
<0> Where mysql.h is located
<0> RiotGeek: 4.1 or later?
<0> RiotGeek: CREATE TABLE t2 LIKE t1;
<0> RiotGeek: OTherwise, SHOW CREATE TABLE and copy/paste
<1> Thanks
<2> whereis mysql.h
<2> mysql: /usr/bin/mysql /usr/lib/mysql /usr/share/mysql /usr/share/man/man1/mysql.1.gz
<0> locate mysql.h
<0> find / -name mysql.h
<0> You may not have installed it, anyway
<0> If you use RPMs, you need lib/header RPM
<0> Debian, you need the -devel package
<0> etc
<3> i'm trying to understand charset and collation, not sure what is the difference between the two, actually. well, I have a database with japanese content. I want to move the website to another host. but I lose the encoding in the transfer. and even on the source server, even though the site looks fine, in phpmyadmin, i only see broken stuff... why ?
<2> i have installed mysql..but i cant find mysql.h
<2> <0> Your MySQL connection id is 2 to server version: 3.23.54
<4> larcenhaido- if you're using a binary package, install the mysql-devel package
<0> ye gods don't install 3.23
<0> much less 3.23.54
<0> somekool: collation is how the characters in the character set are sorted/weighted/compared
<2> ok
<2> i try it first
<4> somekool, I think I answered this for you earlier. you need to dump it with the right character set, and re-import it to the new server, also with the correct character set. Right now it is stripping bits/bytes from your multi-byte characters.
<4> (thanks to Therion sometime 2 years ago that also explained how that worked to me ;)
<5> Therion: you work with c++ and mysql to write client apps?
<0> mishehu: I have, sure
<0> mishehu: why?
<3> infi, i tried, it still does not work... but I have a question I have not asked you before... how come, the same database, on the same server, is ok on the website, but not in phpmyadmin ?
<5> Therion: it's a bitch, I am making a test program to do prepared statements, and even though I included <mysql.h> and tried to build it with -I/usr/include/mysql -L/usr/lib64/mysql -lmysqlclient, I can't make an std::vector<MYSQL_BIND>, it complains that it's an empty type.
<4> somekool: I can only rudely speculate on why that might be the case, as I do not use PHP
<4> I would surmise that phpmyadmin does not work correctly.
<5> Therion: as I'm trying to simplify the process of binding things to a statement.
<3> it could be a bug with this software, yeah
<5> infi: real users prefer the CLI
<5> heh
<0> mishehu: working for me
<0> dellis@leithe:~/local/t$ g++ test.cc `mysql_config --libs --include`
<0> dellis@leithe:~/local/t$
<5> Therion: you making an std::vector<MYSQL_BIND> in your test?
<0> std::vector< MYSQL_BIND >;
<0> with spaces
<0> vector< MYSQL_BIND > x;
<0> MYSQL_BIND y;
<0> x.push_back( y );
<0> cout << "blah" << endl;
<0> hee
<5> Therion: odd, last I knew there shouldn't be a problem with whitespace... any idea why this requires the spaces?
<6> hello
<0> mishehu: template syntax, until next version of C++ standard, requires spaces
<5> Therion: leh, then it worked for many other items that I didn't realize I had to leave spaces for...
<0> mishehu: luck? ;)
<5> Therion: I guess.
<0> It's one of the main annoyances of templates
<5> I'll try the spaces.
<0> Bjarne says it will be changed in next round
<0> mishehu: worth a try :)
<4> Bjorn is taking lessons from Guido on syntactically-significant whitespace.
<4> er, Bjarne
<0> Funny for my two favorite languages today to be C++ and Python, both with at least one whitespace "issue".
<2> guys
<5> Therion: the other annoyance is that anytime you need to send a string to anything in C you have to convert it back...
<4> Guido is a dominatrix
<0> gals
<2> thank you
<2> it works fine
<0> mishehu: string.c_str() works fine :P
<2> i owe u all
<0> larcenhaido: That will be $18,347 US!
<5> Therion: works fine unless the function is expecting char* instead of const char*
<0> mishehu: const_cast! :P
<0> but yeah, lots of annoyances like that out there
<5> Therion: I thought const_cast casts something to be const no?
<0> mishehu: can also strip const
<0> it's a Bad Thing TO Do
<0> !google const_cast is evil
<7> const_cast is evil: http://www.lenholgate.com/archives/000283.html
<0> Hee
<8> Did someone say Eeevvviiilll?
<6> w0000t!
<0> CONST_CAST IS OF TEH DEBIL
<9> what the hell is eq2
<8> It's like Second Life, with bigger swords.
<9> ah lame
<6> Jagger Lies!
<10> thx for crossposting
<8> With lips like that, of course he does.
<4> Formidable: you hit 3 of the channels I'm on with that, but you forgot ##c.
<6> that's cause
<6> I'm not in ##c
<5> Therion: What's the Debel Devil then? (twice as bad as CONST_CAST)
<6> I just used /amsg
<5> err
<5> Debel Debil
<2> -L/usr/lib/mysql -lmysqlclient -lz -lm
<2> gcc -g -O2 -Wall -o vchkpw vchkpw.o md5.o hmac_md5.o libvpopmail.a -L/usr/lib/mysql -lmysqlclient -lz -lm -lcrypt
<2> /usr/bin/ld: cannot find -lz
<2> collect2: ld returned 1 exit status
<2> make[2]: *** [vchkpw] Error 1
<2> make[2]: Leaving directory `/downloads/qmailrocks/vpopmail-5.4.9'
<2> make[1]: *** [all-recursive] Error 1
<2> make[1]: Leaving directory `/downloads/qmailrocks/vpopmail-5.4.9'
<2> make: *** [all] Error 2
<2> guys..this is my second error message
<4> $your-distro-package-installer install zlib
<4> and probably zlib-devel
<2> <4>is that for me?
<4> yes
<2> thank you infi
<4> cheers
<2> <4> it works...thank you
<11> ok, funny thing: in this freaking country we have one of the world's biggest hidroelectrical generators, and yet we have power losses
<5> Therion: I'm having trouble still with the vector. I'm going to post the code. I hope you're still around to take a peek at it.
<1> I'm trying to get a list of columns in a table that my app can use. But the best way I've found is to have the app run 'describe tablename' and then parse the results. Is there an easier way?
<12> RiotGeek, SHOW COLUMNS?
<12> Cicciux, Hydro-electrical? Which country? Why does that matter anyways? Hydro-electrical does not mean unlimited power, nor does it guarantee delivery.
<13> how would i optimize this query? "SELECT k.userid, k.to_user, DATE_FORMAT(u.last, '%Y-%m-%d %H:%i') AS last FROM m_adressbok k, m_users u WHERE ((k.userid = '$getid' OR k.to_user = '$getid') AND u.id IN (k.userid, k.to_user) AND u.id <> '$getid'"
<12> loef, Did you really want a cross join? Or did you mean an INNER JOIN?
<12> Use EXPLAIN
<13> ok..
<11> will Paraguay...
<12> You need nuclear energy... that is the future.
<14> you guys are probably going to shoot me for even considering this, but here goes .. how much damage could be done if I allow the users to enter a free-form 'where clause' and just insert it into a query of a table like 'select * from table where <users where clause>'? I'd of course filter out bare ';'s
<4> do whatever you like, man. just remind me never, ever, EVER to hire you.
<4> EVER.
<14> that's why I'm asking first
<14> lol
<15> virgomoon: you need to think it through
<16> virgomoon: Right. That's a mistake.
<14> ok
<15> you don't allow user strings at your database
<15> *EVERY*
<14> I'll find another way, then
<4> in fact, put it on your resume that you did that, so you can warn future potentian employers.
<4> potential.
<15> what you do is write a query builder, controlled by user input
<15> but the actual query is constructed by your code alone
<14> Sneaky_Bastard, that was the initial plan .. better go with my 1st guess on this one
<3> infi,... then encoding was latin1 ;)
<3> the problem is on server A, the command mysql default to latin1 and the mysqldump command default to utf8,... so all dump get converted
<3> kinda dumb this dump ;)
Return to
#mysql
or
Go to some related
logs:
command libpci.a not found
#math
#fluxbox
#osdev
ucslugc kernel 2.6.18
apt-spy couldn't connect to host
#gentoo
Ubuntu ssh x11forward
revdep-rebuild command not found
#ubuntu
|
|