#mysql
30 September 2007
Total 19 pages. You are browsing page 5/19.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
08:14 <****> let's say someone input a keyword,it will search the database for the tags and the video title
08:14 <****> if both consist of the keywords,then it will come out the research
08:19 <****> for Anchors and assertions is there a consisting instead of start or end with?
08:24 <****> I'm searching the mysqldocs for a function similar to php "max" .. I'e "update x set y=max(y,NewVal)" .. max is a "group function" in mysql.. so I assume it's name is something else.. Any one got a clue?
08:27 <****> Stoneman: greatest
08:28 <****> !m Stoneman comparison operators
08:28 <****> Stoneman see http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html
08:47 <****> http://pastebin.ca/720356 <-- I want to find a Recipe that contains a particular ingredient and the recipe must also contain only vegitrian ingredients.
08:48 <****> possible to do with a single sql command?
08:55 <****> suppose i have table Customer(CustNum, CustName, ...), Order(OrderNum,OrderDate,...), OrderLine(OrderQty,QuotedPrice,...), Part(PartNum,PartDesc...).. how to list the ordernum, orderdate, custnum and custname for every order, and in addition for each order line within the order, list partnum, partdedsc, orderqty and quotedprice?
08:59 <****> what operators are there other than AND and OR
09:01 <****> I have a table like this : http://pastebin.com/m49875b52 I want only one record by name. I mean query result won't return the same name twice or more like this : http://pastebin.com/m236c919 Can I do this.
09:27 <****> hey
09:27 <****> if i try selecting data from a db i get ''1'd='1'd='1'd=''
09:29 <****> http://rpm.pastebin.com/mbfce905 the script im using
09:40 <****> noone? :(
09:45 <****> hi
09:45 <****> hello
09:49 <****> suppose i have table Customer(CustNum, CustName, ...), Order(OrderNum,OrderDate,...), OrderLine(OrderQty,QuotedPrice,...), Part(PartNum,PartDesc...).. how to list the ordernum, orderdate, custnum and custname for every order, and in addition for each order line within the order, list partnum, partdedsc, orderqty and quotedprice?
09:53 <****> Hi, i installed mysql on standard debian install. when i do ps -ef, i get more than one processes of mysqld running. although mysql works fine. why are there more than 1 processes? actually 11 to be precise
09:54 <****> its just running once for me
09:54 <****> apache is running like 15 times lol
09:55 <****> toet: i found in apache settings that you can start number of virtual server threads. i had the same untill i changed it in apache config and restarted it
09:56 <****> tried killing a few mysql processes? i got one mysql process running on my debian (sarge)
09:57 <****> i am using etch
09:57 <****> toet: yes, but as soon as mysql restarts via init or system reboots, they will be back. probably better fix the root cause
09:58 <****> ghatak_mobile compile error perhaps? tried recompiling? i've never restarted mysql though (not gonna try either ;P)
09:59 <****> is there an upper size limit for the int data type?
10:00 <****> at least 1024+
10:00 <****> toet: hmm... i am using the distribution specific mysql. not sure it will be compile error. i recon something in my.cnf needs tuning
10:01 <****> hmm, need an example?
10:02 <****> ghatak_mobile?
10:03 <****> ghatak_mobile: http://pastebin.revpermin.nl/view.php?id=1 here is mine, maybe its any good for you :P
10:04 <****> can anyone tell me what's wrong with my table creation? I'm new to mysql, and I don't understand the error that I'm getting: http://pastebin.ca/720380
10:05 <****> Gm4n: max 1 AUTO_INCRECEMENT per table
10:05 <****> I only have one auto_increment
10:07 <****> toet: am I correct that there's only one auto_increment in that table?
10:07 <****> yea misread
10:07 <****> try setting 'not null' to 0 or something
10:08 <****> had this befor, not completely sure how i fixed it though
10:10 <****> toet: it threw a syntax error at me
10:10 <****> http://pastebin.ca/720384
10:16 <****> doesnt even seem to work in phpmyadmin x/
10:16 <****> or it did
10:16 <****> http://www.revpermin.nl/pastebin/view.php?id=2
10:16 <****> Gm4n
10:17 <****> toet ?
10:17 <****> check the link x/
10:17 <****> Table `mirc`.`signups` has been created.
10:18 <****> Gm4n can leave away the unique though, but handy for registering (no double nicks/email entries)
10:19 <****> leave away what unique?
10:19 <****> Gm4n: http://pastebin.revpermin.nl/view.php?id=2
10:20 <****> thanks, toet! What does ENGINE = MYISAM do?
10:20 <****> the way mysql reads the db
10:20 <****> or something
10:21 <****> and if your new to mysql, and have apache running (with php) i suggest you to use phpmyadmin
10:21 <****> Gm4n: ENGINE=MyISAM specifies to use the myisam engine
10:21 <****> mysql supports several engines (typically)
10:21 <****> MarkR42: what are the virtues of specifying an engine (is it required?)
10:21 <****> You can mix and match them between tables in the same database
10:21 <****> Specifying an engine is not required, it will default (usually to MyISAM)
10:22 <****> toet: I'm new to mysql, but I"m going to be coding some perl scripts to interact with it, so phpmyadmin won't help too much
10:22 <****> myisam is the standard one, it works well for most people for small tables
10:22 <****> toet: but you're assuming that people *like* using GUIs
10:22 <****> phpmyadmin is irrelevant
10:22 <****> MarkR42: is a million entries small?
10:22 <****> proqesi: yes, but also to begin phpmyadmin is very easy to use and maintain your DBs :p
10:22 <****> Depends how big the rows are, but probably, yes
10:23 <****> ok, cool :)
10:23 <****> Using the mysql CLI will avoid becoming a victim to phpmyadmin bugs / shortcomings
10:23 <****> For example, phpmyadmin can't be used easily to do large backup / restore operations
10:24 <****> possibly, but still its very easy for maintaining/using/setting up your DBs/Tables
10:25 <****> any of you guys know much about the interaction between perl and mysql? I'm wondering if I specify email as unique, what happens on the perl end when an entry fails
10:25 <****> it works on my site perfectly
10:25 <****> you prolly need libdbd-mysql-perl - A Perl5 database interface to the MySQL database
10:25 <****> Gm4n: You are using DBI, yes? You probably want to set the option to throw errors
10:26 <****> 1
10:26 <****> Then it should die() or croak() when a mysql error occurs, you could catch it with eval { }
10:26 <****> in the normal way
10:26 <****> alrighty, thanks :)
10:26 * Gm4n is in for quite a coding project
10:26 <****> Mysql usage? :P
10:27 <****> How do i index a database
10:27 <****> toet: I suggested some things before
10:27 <****> it works now
10:27 <****> SQLx: Depends what you want to do, you'll have to be more specific
10:27 <****> 1 010 Connect plt2
10:27 <****> '1'd='1'd='1'd='
10:27 <****> '1'd='1'd='1'd='
10:27 <****> 1 013 Close plt2
10:27 <****> to make queries faster
10:27 <****> But indexes can't always make queries faster
10:28 <****> You need to create them very specifically, and use EXPLAIN to see exactly what difference it makes
10:28 <****> before performance testing any change to validate that it really DOES make your query faster
10:28 <****> toet: in that example you gave me, why did you enclose each var name in ``s?
10:28 <****> and you probably want to performance test your entire system, because indexes can make other things (e.g. INSERTs, UPDATEs) slower
10:28 <****> An index has been added on video_id (Query took 0.2509 sec)
10:28 <****> is that indexing?
10:28 <****> Gm4n: phpmyadmin does that :p
10:28 <****> ooh, you cheater :P
Total 19 pages. You are browsing page 5/19.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last