| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> I belive my extension=mysql.dll thing is turned on, in php.ini
<1> put headers in a myisame table for the search
<2> archivist: if I was to roll my own, what general strategy should I follow?
<0> Also, my server is set on a port other than 80, if this has anything to do with it
<1> trhaynes I cut the words and put them in an index table (source id), and a word count table, and a nasty self join
<2> hmmm ok
<2> what about something with the existing DB and some select * and PHP
<1> my index build is php(batch job)
<1> some thoughts on searching www.archivist.info/search
<3> it's more difficult to create a mysql server to put on line
<4> hello, I'have a table with fields ID (auto inc uniq) RID(int) SID(int). i want to make RID and SID uniqe like RID=2 SID=4 and this must be uniqe values. how I can do it ?
<1> CalvadoS, put a unique index on them
<5> ;i have a small logic problem here
<5> SELECT * FROM spider.koppel WHERE siteid=42903 AND gedaan=2 OR gedaan=1;
<6> anyone know how i can get every result from todays timestamp where TIMESTAMP is autoupdate
<6> ON UPDATE CURRENT_TIMESTAMP its using that
<4> archivist ok ty i will try.
<5> i want to select the siteid, where gedaan=2 OR gedaan=1
<5> but in this way it will select every site with gedaan=2 or gedaan=1
<5> how to this?
<5> i found out i think.
<4> archivist: hmm i couldnt find the way to do it. how we put unique index ?
<1> unique (sid,rid)
<4> ok ty
<7> Hey
<7> how can i select some data from 2 rows the date from the 2th table depends on information from the first
<8> !m Hamsa join syntax
<7> from 2 tables*
<9> Hamsa: (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<7> thx :)
<7> hmm thats a little confusing can i please get and example (like thers not enuff in the doc)
<7> theres*
<10> is there a easy way to compare dates without UNIX_TIMESTAMP function?
<7> = ?
<10> with <, >= , etc...?
<8> as long as they're both of the same type
<8> ie datetime or timestamp
<8> if one is a unix_timestamp you'll have to convert it first
<10> shabbs ok, thanks
<11> !perror 104
<9> System error: 104 = Connection reset by peer
<12> i'm using "EXPLAIN SELECT ...". Can you explain me what extra field "Using where; Using filesort" means?
<12> what is a "filesort"?
<12> i get that on BLOB search
<12> same request on VARCHAR search give me "Using where; Using index"
<13> it means it can't use a memory temporary table to do the sorting
<13> because the memory table doesn't support blobs/texts
<13> http://dev.mysql.com/doc/internals/en/filesort.html
<12> hum. i do benchmark on mysql. i try to choose between blob and varchar.
<12> so, does it mean that blob is slower? :-)
<13> it means blob is slower if you plan to sort a resultset including blobs a lot
<13> what are you storing in your blobs?
<12> yep, a lot is 2,000,000 rows :-)
<12> gleam-: IPv6 (raw 16 bytes)
<13> oh lord
<13> don't use blob for that
<12> hehe
<12> VARCHAR(32) looks faster
<12> gleam-: why not?
<13> because it's a really inappropriate use for that data
<13> it's meant for big binary objects
<12> gleam-: for cl***ic search (blob == value // blob like "value%"), varchar and blob are both fast
<12> but comparaison are slow on blob
<12> (blob >= low and blob <= high)
<12> gleam-: (i'm using tinyblob, not "blob")
<13> then it shouldn't make a big difference, but i'd still use varbinary or something
<12> gleam-: i have an index of the tinyblob (index: 16 bytes)
<12> gleam-: varbinary? is it a column type?
<13> yeah, just use varbinary or char(16) binary
<13> varbinary = varchar(X) binary
<12> ok
<12> varchar(X) binary is different thant tinyblob ?
<13> it's a different column type
<13> http://dev.mysql.com/doc/refman/5.0/en/binary-varbinary.html
<13> varchar binary : varchar :: blob : text
<12> ok, i'm trying binary(16)
<14> hey all
<14> when I create table at beginning, all primary key already defined
<14> can I add primary key after the table created ?
<15> Yes\
<16> !man primary key
<9> (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<8> !m lkthomas alter table
<9> lkthomas: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<17> Hello
<14> alla, ok, thanks
<14> ahha :)
<17> How do I find out what the next auto increment value is for a table?
<13> why doy ou need to know?
<12> gleam-: hum, BINARY(16) looks good
<12> (fast)
<13> good haypo
<12> (check with EXPLAIN ...)
<17> I need it for my C program
<13> why?
<17> why does it matter why?
<12> gleam-: "Using where; Using index"
<13> good haypo
<12> ok, i prefer to read "index" than filesort :-)
<1> Braden`, you can only get lastinsertid not next
<17> well, the last insert id is fine
<13> you can find what will get inserted next, but it's better to use last_insert_id()
<13> or mysql_insert_id()
<13> http://dev.mysql.com/doc/refman/5.0/en/mysql-insert-id.html
<17> That is perfect
<17> thanks!
<13> good :)
<18> how do i create a database named "amxbans" ?
<19> is that different from creating a database not called "amxbans" ?
<18> huh?
<18> Im new to mysql, I created a user called amxbans, And i need to create a database called amxbans (I guess?)
<19> no
<1> !m Old tutorial
<9> Old: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<19> that sounds like Oracle
<18> I've read it
<18> oh well, one second
<1> !m Old create
<9> Old: (CREATE PROCEDURE and CREATE FUNCTION) : http://dev.mysql.com/doc/mysql/en/CREATE_PROCEDURE.html
<1> !m Old create database
<9> Old: (CREATE DATABASE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
<20> how do you nicely loop through the values of a 'set' field?
<21> !m alter table syntax
<9> alter: (ALTER TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html
<18> nevermind, this mysql stuff makes me go nuts
<12> gleam-: hey! you was 200% right :-)
<13> i was?
<12> gleam-: BINARY is faster (1,4sec instead of 1,7sec) and use less memory
<13> oh good
<12> you _are_ 200% right :-)
<13> you should probably put an index on that column if you haven't already
<13> wait you said it was laready
<13> nevermind
<12> sure, i always put index everywhere :-)
<22> hej! I'm searching for an expression to get similar words from a database. A close example to what I'm trying to do is http://dict.leo.org/ende?search=slup
<22> I don't have to use expressions often, so I know I'm stumbling on something simple here.
<22> Later I would sort these words by levenshtein (number of replacements/additions needed).
<23> mysql has built-in soundex, and there's MATCH... AGAINST, but nothing AFAIK that'd do what you're asking.
<12> sum up of 3 days of benchmark: 1) "binary" column type is my solution 2) mysql rocks (really fast)
<22> nah soundex isn't good. gonna be german
<22> what is match against?
<1> !man fulltext
<9> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<22> i want to comprise a quite big range of similar words
<22> thanks i'll take a look
<24> hi
<1> or are you looking for a thesaurus type
<23> scornflakes: you'd probably have to go for a user-defined function, in that case. Try this page: http://empyrean.lib.ndsu.nodak.edu/~nem/mysql/udf/
<22> you know urbandictionary.com? they had something very similar
<22> yeah i had that link with levenshtein etc.
Return to
#mysql
or
Go to some related
logs:
FB_S3TRIO
#css
Oh, ho, ho it's magic, you know
#proftpd
#perl
replayer codec fedora
suse 10 dual monitor
cannot open dir sudo
#mysql
#web
|
|