| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> WHO HAS AN EMAIL LONGER THAN 100 CHARACTERS?
<0> If someone gave me an E-mail address longer than 100 characts, I'm not going to E-mail them.
<1> some city official from that welsch city?
<2> llannf............gogogoch
<3> it's Llanfairpwllgwyngyllgogerychwyrndrobwllllantysiliogogogoch
<4> osfameron, thanks for advice , how about URL , text is ok ?
<1> Jax: group by doesn't do what you want either?
<5> let me try to actually make the view first.
<6> seekwill: fair enough, but a database is probably better at remembering email addresses than you are
<6> mephis1987: depends on what you're trying to do. I'd usually use varchar(255) for that too.
<0> osfameron, But you have to understand the context of what it's storing. The practicallity of the data...
<0> osfameron, Why not make the E-mail address field a LONGTEXT then?
<6> seekwill: er, because blob/text is handled differently than varchar?
<0> How so?
<6> seekwill: anyway, I'm not giving out tablets of stone. I've specifically said "look at your data", "I'm not deciding for you" :-)
<0> :)
<6> seekwill: er... well, I thought it was :-) maybe I need to follow my advice and go back to the manual
<5> flupps would a GROUP BY product_id be faster than a SELECT DISTINCT ?
<6> but I tend to use varchar for stuff I'm going to LIKE/eq query, and TEXT for stuff I'm going to MATCH query
<0> It's better to think about the data, and use the best (and smallest) possible types. Help the DB remember E-mail addresses better than me.
<0> osfameron, :)
<1> Jax: if they'd get the same result, DISTINCT is better to use, optimizer can do some tricks in rare cases
<6> mephis1987: the moral of this story is, don't be too worried about what I say is ok. Read the manual and think about your data
<5> !man view
<7> (ALTER VIEW Syntax) : http://dev.mysql.com/doc/mysql/en/ALTER_VIEW.html
<5> !man create view
<7> (CREATE VIEW Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_VIEW.html
<6> mephis1987: but my opinion would be that varchar(255) was ok for an url string
<0> osfameron, Not saying you're wrong or anything. Just applying some of your logic back "against" you...
<4> osfameron, yes , i should read more manual as i m newbie here ,thanks for the idea
<0> !man column type
<7> (Column Type Overview) : http://dev.mysql.com/doc/mysql/en/Column_type_overview.html
<4> !m mephis1987 longtext
<7> mephis1987: (Overview of String Types) : http://dev.mysql.com/doc/mysql/en/String_type_overview.html
<8> hello, is there a way to do this? : INSERT into table(foo,bar) VALUES (anothertable.foo,'whatever') WHERE anothertable.id=someid;
<8> i need to insert data into a table which uses keys from other tables, eg users will be supplying type, and i want to insert typeid from the type table
<9> thefish: use INSERT...SELECT instead of INSERT...VALUES
<8> Duesentrieb: like INSERT INTO table(foo,bar) VALUES ((SELECT bla), whatever); ?
<9> no
<10> got it, SELECT * FROM `Item_All_Author`, Author, Item WHERE ((`Item_All_Author`.AuthorIdentity = Author.Identity) AND (`Item_All_Author`.ItemIdentity = Item.Identity));
<9> remove the VALUE ( ) part
<9> thefish: look into the manual...
<8> cheers mate
<11> Hi
<8> Duesentrieb: got it, thanks
<10> why does the mysql-query-browser generate endless rows, wasted space.....?
<11> How can I backup the whole mysql database
<11> I just have access to the files
<12> So I'm trouble-shooting a setup where there are a couple of different my.cnf files
<8> msg43: maybe install phpmyadmin then
<8> or make a php file that execs mysqldump
<11> thefish, I just have the files on a hard drive
<11> I don't have it hooked up to a system or anything
<11> I was told I can just copy /var/lib/mysql
<12> And I wonder if there's a good config setting I can set as a test case to see if a particular file is being read
<8> msg43: not sure
<12> Like 'harmless_comment = foo'
<12> and 'show harmless_comment\G'
<4> !man primary
<7> (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
<10> SELECT * FROM Item I WHERE I.Titel='Stadium'; <- does mysql a *Stadium* search in the Titel field in this case?
<13> if you mean does it do the wildcard search, I dont think so
<13> I think the correct one is WHERE I.Titel LIKE '%Stadium%'
<2> Spion that cant use an index
<13> indeed :/
<10> Spion, thx
<13> its not really an efficient way though, because of what archivist said
<2> use a fulltext index
<10> whats an index in this case?
<14> ?
<10> i guess you refer to CREATE INDEX?
<14> metalfan_ - as FULLTEXT
<2> an index is what makes a book and a database useful
<9> CREATE FULLTEXT INDEX, in this case
<14> !tell metalfan_ fulltext
<7> Could you be a little more clear?
<14> !tell metalfan_ about fulltext
<7> But I don't know a thing about that.
<14> !tell metalfan_ about fulltext index
<7> But I don't know a thing about that.
<9> hahaha
<14> !man metalfan_ fulltext
<7> Nothing found.
<2> !man fulltext
<7> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<10> thx
<14> why did your work :)
<14> yours*
<2> it likes me
<14> o0
<14> anyways metalfan_ - read that page it is self explainatoryyy .. you will understand how to use fulltext
<2> man searches for stuff in the manual, tell is extra stuff
<14> !man fulltext
<7> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<14> !man archivist fulltext
<7> Nothing found.
<10> looks like fulltext indexes are only available for myisam tables...
<14> im afraid so
<10> have to use innodb (integrety...)
<9> then you can only use a substrin search
<9> which will not use an index
<10> anyway searching with ...WHERE....LIKE is enougt, the project will start with 400 items and it wont grow much in the next time...
<9> metalfan_: you could have a separate table for the search index, which is MyISAM and updated once per hour/day/week by a script.
<9> oh
<9> with like 400 entries, substrin search should be fast enough
<9> though not as flexible
<14> jup
<14> what does GA mean?
<14> General Announcement?
<9> Grand Admiral?
<9> Gay Asian?
<14> ^^ topic says 5.0.20 GA
<14> hah
<2> generaly available
<9> oh, the possibilities...
<14> oh
<14> okay
<10> Duesentrieb, not as flexible...what else could a fulltext index do....? i will probably search the title and descripton fields....
<10> gameboy advanced ;)
<9> metalfan_: fulltext index can search multiple fields at once, can search for "foo AND bar", "foo OR bar", etc, etc...
<9> read the man page
<10> ok
<9> it also gives you a ranking by relevance
<15> provide the man page if you're going to refer to it
<15> !man full text index
<7> Nothing found.
<15> god damnit
<15> !man fulltext
<7> (Full-Text Search Functions) : http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<9> Darien: archivistalready did
<9> and the bot does not like me
<15> well archivist is like that sometimes
<15> but it saves scrolling back :p
<15> hey DJ, bring that back
<15> I forgot to charge my iPod, so now I have nothing to listen to while I'm out on the town
<15> travesty :/
<2> brain pacemaker
<10> Duesentrieb, a seperate table is a nice idea, thx
<4> how can i print struture of a table command line ?
<4> hello , how can i print struture of a table command line ?
<10> you mean the structure of a table?
<4> yes
<10> describe table;
<13> mysql dies on me :/
<4> it works , thanks
<13> Starting mysqld daemon with databases from /var/lib/mysql ; 060416 20:22:09 mysqld ended
<2> look at the error log to see why
<16> can anyone see the syntax error in this query? I'm going nuts and when I googled for it, it looks like it's fine according the examples I see...
Return to
#mysql
or
Go to some related
logs:
config_hwmon gentoo
install su mandrina
#debian
#php
#gentoo
Unable to find a suitable Athena Widget library (Xaw)
#openzaurus
#osdev
#math
fs-driver raid0
|
|