| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> changing the delimiter.. can u pls elaborate?
<1> hellothere greetings fellow newbie smile
<0> he omnie
<1> hellothere are you familiar with the SQL bot??
<0> erm.. nope
<1> hellothere a useful thing i just learned about tonight
<0> yeah.. what does it do?
<1> SQL bot is accessed thusly !m hellothere CREATE PROCEDURE
<1> like this
<1> !m hellothere CREATE PROCEDURE
<2> hellothere: (CREATE PROCEDURE and CREATE FUNCTION) : http://dev.mysql.com/doc/mysql/en/CREATE_PROCEDURE.html
<0> yes i've read that thing
<3> are you sure? ;)
<0> apparently my lack of mysql syntax means i understand none of it
<3> be sure to read the whole chapter: http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-syntax.html
<0> well.. sorta
<3> because it will tell you what exactly they RETURN
<1> Jax are you familiar with UNIX?
<4> unix ?
<4> isnt that the evil hacker software ?
<0> CREATE FUNCTION updateModificationDate () RETURNS DATE
<0> RETURN now;
<5> Hello. Could anyboty tell how to know if two LineStrings intersects. MySQL 4.1... I have this: geomfromtext('linestring(1 1,4 4)') and geomfromtext('linestring(1 4, 4 0')..
<1> apachez LOL
<6> :D - I will take that to mean that I have all the bases covered for learning about stored procedures.
<4> ommie :)
<0> erm... i am confused..
<0> my function above.. what's wrong?
<1> I am getting a lotta 'command not found' errors at the Command line prompt
<1> must I do some kinda PATH statement so my mac (running darwin) can find the commands??
<7> lo
<0> http://hashmysql.org/paste/1836
<0> i think it's just that pma doesnt allow me to do any of these things
<0> i'll just give up hehe
<8> hehe
<9> how can i load a mysql .dmp file ?
<1> shinakuma do you mean a mysql.dmg file???
<1> i mean a Mac disk image file version of mysql??
<10> or is it a text file containing SQL commands? If so, just use mysql databasename < file.dmp
<11> hello! when i try to run mysql i get this error: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
<10> duff_: check if mysql is running (ps faxw | grep -i mysql) and if not, start it. If it is, the path to the mysql socket might be wrong, ask google for help with that.
<12> shinakuma: it has just sql statements inside, so you can pipe it to mysql cli
<12> shinakuma: cat file.dmp | mysql
<12> \o/
<12> kraupu: write your own function, ha ha ha
<5> domas ta prasme? tipo ant mysqlo nera tokio dalyko?
<12> nugi sakiau jau tau, yra mbr'u kodas, kito nera
<12> kadangi tau nereik duomenu valdymo siuo atveju, o tik tokio objektu susikirtimo
<12> tai gali ir aplikacijos pusej darytis
<5> man tik tada keista, kodl tokio dalyko nra / MySQL' /dta... kokie motyvai ne/djimo, jei visokie kitokie dalykai veikia...
<12> kraupu: nu tai gis'o intersect'ai ne toks ir lengvas dalykas ;-)
<12> jeigu nori parasyt toki koda... veliava i rankas! :)
<12> MBR'u susikirtimas yra trivialus uzdavinys
<8> domas: what language is that?
<12> perl_cont: martian
<8> cool
<5> domas, o kaip matematiakai nusistato, ar dvi atkarpos kertasi?
<12> tieses ar atkarpos? :)
<5> atkarpos
<8> oh, lithuanian
<12> kraupu: nu tai sakau, tiesi? susikirtimo ta?k? pasi?mi, o tada pa?i?ri ar patenka ? aib?
<12> kraupu: nu tai sakau, tiesis susikirtimo taak pasimi, o tada pa~ikri ar patenka / aib
<12> vo
<1> tetrarch I am running a script called install_test_db which creates privilege tables for the daemon
<12> http://astronomy.swin.edu.au/~pbourke/geometry/lineline2d/
<12> =)
<12> kraupu: http://www.geog.ubc.ca/courses/klink/gis.notes/ncgia/u32.html
<5> thanks martian domas
<1> mysql script error using a script editor i am getting a syntax error in this line
<1> if [ x$1 = x" --bin" ]; then
<8> domas: how do you find the nearest point in a set of points to a given point?
<1> does anybody see an SQL syntax error in that line???
<12> perl_cont: calculate distance! :)
<8> ugh
<12> perl_cont: I'm not that much of a GIS guy
<8> domas: how do you find the nearest line in a set of lines to a given point?
<12> calculate distances too! :)
<12> I **** even more at computational geometry
<10> ommie: that ain't sql. That's bash - shell script.
<10> ommie: You need to run "sh install_test_db", rather than p***ing it through mysql
<1> ok will do
<1> tetrarch i just searched my hard disk not finding that script
<10> ommie: you just said you were running it? Where did you find the if [ x$1... line?
<12> mysql_install_db is used for that though
<1> tetrarch i was running a different scrip called install_test_db I AM using bash
<1> tetrarch looking in /usr/local/mysql/scripts not finding sh install_test_db
<10> ommie: "sh" is bash, it's in /bin or /usr/bin.
<10> ommie: so you'd type:
<10> install_test_db
<10> or
<10> sh install_test_db
<1> ok i'll look in those places
<1> i was looking for SH .......... db
<10> ommie: it's normally in the path.
<13> ALTER TABLE `replay_comments` ADD UNIQUE (
<13> `text`
<13> );
<13> MySQL:
<13> #1170 - BLOB/TEXT column 'text' used in key specification without a key length
<13> wtf?
<10> Cracker2: text columns can be any length, and mysql keys need to be fixed length (or at least determinable length).
<13> then
<13> text(1000)
<13> like this?
<12> Cracker2: why would you ever want to index comments?
<13> i want that comments would be unique
<12> then put md5(comment) into separate column, then use UNIQUE on that
<13> sec
<13> i think it would be easier to make
<13> text - varchar(1000)
<13> and then unique it
<10> i bow to domas' suggestion, much better than limiting the text field and faster too.
<13> ok
<12> of course expression indexes would rock
<12> but whatever
<1> tetrarch running install_test_db i get 'mysqld is missing looked in ../sql and in ..//libexec
<13> hm
<10> ommie: sure that's mysqld, not mysql?
<13> then put md5(comment) into separate column...
<13> u mean, create new column for example named md5
<1> tetrarch yes it is mysqld in the error mess
<13> there would be md5(comment), and it would be unique?
<10> ommie: where's the script from, out of interest?
<12> Cracker2: right.
<12> Cracker2: so if _same_ comment is posted, you would get immediate hit, instead of having to check for 1k-sized index :)
<1> i have my first install files for mysql in a folder at the root /mysql
<13> hm, didnt really understand
<1> that script is in a sub folder called /mysql/mysql-test
<13> domas can you a write a shortcode of it ?
<12> Cracker2: INSERT INTO (comment,comment_md5) VALUES ('HELLO!!!!',MD5('HELLO!!!!'));
<13> and make comment_md5 unique?
<13> :>
<13> and what type comment_md5 must be? text or varchar?
<10> cracker2: CHAR(32)
<1> tetrarch I can see mysqld at /mysql/bin/mysqld
<13> ok thanx a lot
<10> ommie: search for mysqld in the script, you may need to change the path so it can find it.
<1> tetrarch early in that install script is the line if test -x ../libexec/mysqld
<10> ommie: okay, found which script you're talking about, it's one of the mysql std ones. Quick hack: before vardir, put the line:
<10> ommie: bindir=/mysql/bin
<12> of course one could use triggers for populating the field, ha ha ha
<1> i # 'd that line and wrote instead if test -x ..//mysql/bin/mysqld but still got the error
<10> domas: are triggers up to that level already (in 5.0)?
<1> ok will do
<12> tetrarch: should be ;-)
<12> I HOPE
<10> domas: sweet. about time I read through the 5.0 manual... triggers and stored procedures would be helpful.
<12> about time
<10> ommie: and if that doesn't work, put another line after it with "execdir=/mysql/bin".
<1> tetrarch i put just ABOVE vardir=var bindir=/mysql/bin same error
Return to
#mysql
or
Go to some related
logs:
bbp python
grep....., @Entire_File
aticonfig -initial
Warning: Could not find configuration file
Please copy config
#math
apache_mod_php5
build_static or with_openssl
#math
#python
horizontal frequency adjust fedora
no winkey in glx
|
|