| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> in both tables
<1> I have a table view in mysql but created with I can't remember what program ! now I can't remove it within mysql prompt or phpmyadmin
<2> skogsmaskin: ah, you've indexed the leftmost 32 characters fo track_uid?
<2> is it a uuid?
<0> it's not uuid in a
<1> command mysql> drop table view1; ERROR 1051 (42S02): Unknown table 'view1'
<0> but it's uuid in b :)
<1> but it is there
<3> skogsmaskin: I'd need to see details on all the tables involved to see why it isn't using any of your indexes
<2> skogsmaskin: if it's having to do any type coercion, it could not use indexes
<2> yeah, what Sembiance said :-)
<0> track_uid is not unique in table a, but it unique in table b
<0> the index in a:
<0> Keyname
<0> Type
<0> Cardinality
<0> Action
<0> Field
<0> PRIMARY PRIMARY 20025 Drop Edit id
<0> track_uid INDEX 122 Drop Edit track_uid 32
<0> player_login INDEX 606 Drop Edit player_login 32
<0> uh :o)
<0> same for track_uid in b
<4> i want to know the fastest way to write something that will do this: Check if an id is in a table, if not, add it, if it's already there, increment it
<5> han`: use an auto_increment field
<5> though that won't increment the same row
<4> well i want my table to have an id, counter
<5> aha
<6> create temporary ... select ... - does it make sense that when killed, you see "Repair by sorting" as the state in the process list?
<7> lsmith: I haven't find any workaround for this mysql bug that is connected with my sql query
<1> any idea ? droping a table view ?
<4> so if id 3 exists, UPDATE table set counter = counter + 1 where id = 3, otherwise INSERT
<5> !m ace_me drop view
<8> ace_me: (DROP VIEW Syntax) : http://dev.mysql.com/doc/mysql/en/DROP_VIEW.html
<4> but i was just wondering if there is a really fast way to do that
<5> han`: look into ON DUPLICATE KEY UPDATE on inserts
<4> ok thank you
<9> Can someone help me with an installation problem?
<1> in phpmyadmin it said that VIEW1 in use
<1> I tryed ! command mysql> drop table view1; ERROR 1051 (42S02): Unknown table 'view1'
<1> k
<9> I've been building a testing server on Windows 2003 using IIS6. I've installed PHP 5 and mySQL 5. Both are working. However, when I do run the phpinfo() function I am seeing that the Client API version that PHP is showing for mySQL is version 4.1 and not 5.0.
<9>
<9> I've applied the latest connectors from PHP.net. I've installed the following a number of times:
<9>
<9> C:\PHP
<1> drop view :)
<9> -> libmysql.dll
<1> sorry
<5> make sure you're using the right database
<9>
<9> C:\PHP\ext
<9> -> php_mysql.dll
<9> -> php_mysqli.dll
<9>
<9> Then I have also enabled mysql in the php.ini file located in the C:\Windows directory. I've also restarted the services and the machine mutliple times. I'm at a loss. Any help would be appreciated.
<5> flashinsane: don't do that
<5> use a pastebin
<9> I'm new to IRC.
<5> well now you know
<6> seems like a waste of time for mysql to "repair by sorting" a temporary table create ... select that was killed
<10> arrgghhhh i'lll delete windows!
<1> where could these views be used ?
<3> 0skogsmaskin: by the way, what is this 'pit babe' ?
<10> hehehhee
<9> Pastebin, is that an option native to a particular piece of software? Im using Tillian and dont see that.
<6> keeps the locks on the tables being selected from
<5> flashinsane: it's a webpage (url is in topic)
<9> Still unlcear. I did start a thread on the mySQL forums though. http://forums.mysql.com/read.php?52,80687,80687#msg-80687
<5> flashinsane: hashmysql.org/paste/ next time you have a big chunk of text to paste, go to that url, paste it in the textbox and only paste the resulting URL in here
<5> flashinsane: it sounds like your libmysql.dll didn't get updated properly when you installed 5.0
<9> shabbs: will do thanks.
<10> ok no joke, windows xp with 3.4ghz 2gb ram is slower at mysqlimport, than p2 450mhz 650mb ram....
<10> rephrase: ok no joke, windows xp with 3.4ghz 2gb ram is slower at mysqlimport, than freebsd 6 p2 450mhz 650mb ram....
<10> by 2x
<9> shabbs: 5.0 of which install? PHP or mySQL?
<5> freebsd_fan: no joke, we all know the shortcomings of windows. if you have nothing better to do than bash windows I suggest #asp
<10> i'm still waiting for windows
<5> flashinsane: mysql
<10> asp is windows invention?
<10> asp is probably lame
<5> trust me, they don't like asp
<9> So the libmysql.dll within the mySQL directory needs to be updated? How would you recommend I fix that?
<5> flashinsane: well if you installed 5.0 it has the correct dll within the dir you installed to, but everything else maybe pointing at the old dll somewhere else. I'm not sure where they look for client things in windows
<10> <% %>
<10> heh
<10> 0wned
<11> Hi guys ... I want to SELECT * FROM TEACHERS ... but not if the record has a status of -1 ... what's the easiest way to do this ?
<11> SELECT * FROM TEACHERS WHERE STATUS != -1
<11> ??
<11> SELECT * FROM TEACHERS WHERE STATUS NOT -1
<3> zomg is this a joke or something?
<3> I thought we p***ed april's fools day?
<9> shabbs: In the mySQL install folder there is a "lib" folder. There are 2 folders within that, which both have the dlls. Would those need to be updated?
<5> flashinsane: like I said, if you installed 5.0 the dlls in the install dir should be correct. my guess is php is looking in either an old mysql install dir (if there was one) or in <win>/system32. if you didn't have a previous install then it's possible php came with an old mysql client dll
<9> shabss: Originall PHP was installed with the autoinstaller. Which ended up not working. I uninstalled that, then did the manual install. Which worked. I've since updated those dlls several times in the PHP install directory.
<12> Any ideas why "select 1 as CONCAT('My', 'S', 'QL');" returns syntax error, is it possible to generate dynamic column names at all?
<6> typically, the data is well defined and there's no need for dynamic column names
<12> i agree
<12> but... is it possble or not?
<6> i'm leaning towards "no"
<6> but i don't know :)
<9> shabbs: This is interesting. In the PHP install folder the libmysql.dll is about 1200K. In the mySQL install folder it is a bit larger. Close to 1500K.
<6> zimnyx: perhaps there is another solution to your problem that doesn't require dynamic column names
<6> zimnyx: a temporary table, perhaps.. or maybe a view (if you're using mysql 5)
<12> i need it in view:)
<12> sure there are other solutions.
<12> Btw How views are stored on server?
<9> shabbs: Got it thanks! I fixed it. It WAS incorrect in the system32 folder. Nice job! Thanks you!!!
<6> zimnyx: no idea.. not all that familiar with them yet.. just familiar with the idea at this point
<13> A article can have several sports. If I use "select article.*, article_sport.* from article, article_sport where article.id = article_sports.aid LIMIT 2" I will if I don't have luck only get the same article 2 times
<13> I was told to use "join", but which join, there is hundered of them :/
<6> Moofius: that is a join... but besides that, if you only want unique articles, group by the article id
<14> can anyone explain to me how this is possible: i run "show tables" and one of them is "orders", then i do "desc orders" and i got an error!
<14> ERROR 1064 (00000): You have an error in your SQL syntax near 'order' at line 1
<14> how's this possible?
<6> that seems to indicate you're doing "desc order"
<6> make sure the "s" is on there.. and if that still doesn't work, try backticks: desc `orders`
<6> since "order" is a reserved keyword
<14> smore: the table name is "order"
<6> ahh.. then you must use backticks
<14> smore: ah!! i see!
<6> its the single quote looking thing on the ~ key
<6> only way to use reserved keywords as table names
<14> smore: thanks a lot.
<12> smore: thanks
<12> smore is thanksfull
<6> :)
<6> glad i could help
<6> Moofius: http://mindprod.com/jgloss/join.html
<15> Does MySQL have support for logging?
<6> one thing i can never find on mysql's site is an explanation of what each type of join is
<15> i.e - queries to tables, and soforth
<6> not sure about queries to tables but it can store a binary log that contains the queries
<6> it used to, and may still, support plain text logging of queries as well
<15> i'll rtfm :-D
<16> it still does. --log
<13> uhm, I have no idea which one of them :/
<13> I want to get all the sports when I fetch the article, to show all articles by a specific sport and to show all articles with a specific user in a specific sport
<6> Moofius: i think you want an inner join
<15> Also, is there some form of introduction to stored functions?
<6> Moofius: all records from table A that have records in table B
<6> Moofius: and in that case, table A would be your sport list
<15> Also, is there any way that MySQL can automatically append the current time to a query in a table definition
<5> I thought there were functions that did base64 encoding in mysql
<17> XM167 - like a TIMESTAMP column?
<6> XB167: yes, you can make the current time put into a field in the table def
<6> XB167: in case you're having problems finding it, here's a link to the mysql online manual: http://dev.mysql.com/doc/
<6> XB167: if you're new to mysql, i suggest jumping right into 5.0 or 5.1
<6> if only mysql 5.0 was an option 5 years ago, i wouldn't be migrating right now
<18> smore: what are you migrating from?
Return to
#mysql
or
Go to some related
logs:
#physics
#linux
debian 2.6 psybnc
#php
#oe
#kernel
ERROR 1036 (HY000): Table ' is read only
#debian
#css
Comix cursors
|
|