| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> Define "Real time applcation"
<0> in your definnation
<1> DJ_Necrogami: haha, that's not really realtime ;-)
<1> realtime is when you're controlling rockets ;-)
<2> its the standard term when we say rel time its ususlly updation and retrieval in very short time cycle without crashing...
<1> in _guaranteed_ time
<2> domas, exactly... :)
<2> becuase i m working on a real time application
<2> and looking for contribution from open source developers
<2> its known as military gps
<0> in technical defination "Real Time" and internet dont exist
<0> its all about Posting and Queries
<0> unlies you are directly monitoring the DB file .. not the database the file for the dB
<0> i dont think its very possiable
<1> DJ_Necrogami: well, anyway, when you insert data somewhere, you might want to send a notification to those listening for it... ;-)
<1> that can be done with UDFs and triggers or... polling
<0> thats still not real time
<0> because its not going direclty to them
<0> they still hafta query for it
<0> which something else might be new on it
<0> .. basicly same as a infinite loop query
<3> the alpha package has disk based storage for ndb right?
<1> right
<3> do i need anything besides --with-ndbcluster for the disk based part?
<4> Any ideas on why a MySQL 5.0.15 might hang for ~5 seconds before letting me auth?
<5> gcbirzan: maybe dns issue
<4> PTR lookups for the IPs I'm trying to connect from return (NXDOMAIN or the record itself) quite fast.
<4> Hm.
<4> lokus: You might be right.
<4> named 11110 32.9 29.3 304656 303472 ? R Feb22 1425:02 /usr/local/sbin/named -u named -t /chroot/named -c /etc/named.co
<4> lokus: It's under half a second, still... But, who knows...
<4> lokus: That was it. :-P
<4> real 0m0.092s
<1> gcbirzan: still, dns issues.
<6> i have converted my databases from mssql to mysql using the tools which were listed in the migrating to mysql, but what if i want to update those databases ?
<7> i have successfully converted my databases to mysql from mssql using the tools listed in migrating to mysql page in mysql site but what if i want to updated those databases how can i update them
<8> I have a sum(datacount) in my query, can I sort by that result?
<9> have you tried?
<8> yes
<8> it seems to fail
<8> but I may just not be doing it right :)
<8> mysql> select datahost, sum(datacount) from dailyin where timemark <= 1140674400 group by datahost sort by sum(datacount);
<8> ERROR 1064: You have an error in your SQL syntax near 'sort by sum(datacount)' at line 1
<9> pastebin
<8> oh, sorry
<9> "sort by"?
<9> order by
<8> that gives ERROR 1111: Invalid use of group function
<10> If I got a MySQL database with latin1 mixed with utf-8, is there a way for me to convert ALL data to pure utf-8? If I convert it straight from Latin1 to UTF-8, will the data thats already converted be converted once again?
<8> well, here is another question hopefully easier, I want 1234567890 to read 1,234,567,890 How can I do that?
<10> TheMafia: How do you input the data? If it's via script I'd just convert it in the script
<10> There are pre-defined functions for that in PHP for instance
<8> I am doing a direct query
<10> Oh, okay
<8> Trying to learn mysql, will work on php next ;)
<10> Ah, ok
<1> lsmith: isn't "sort by" same as "order by"? ;-)
<1> TheMafia: SELECT .. SUM(datacount) sumdatacount, .. ORDER BY sumdatacount;
<9> yeah .. need to alias
<10> lsmith, domas
<10> If I got a MySQL database with latin1 mixed with utf-8, is there a way for me to convert ALL data to pure utf-8? If I convert it straight from Latin1 to UTF-8, will the data thats already converted be converted once again?
<1> depends.
<1> :))
<1> well, mixed how?
<10> some posts are latin1
<10> some posts are utf-8
<1> then... detect which are in latin1 and use iconv or recode...
<10> how do I detect that? default charset is utf-8 on all tables
<10> and in all cols
<1> I don't care what is on your cols. important thing is what data is inside :)
<1> probably if you didn't set session charset, it's all broken anyway, ha ha ha
<7> i have successfully converted my databases to mysql from mssql using the tools listed in migrating to mysql page in mysql site but what if i want to updated those databases how can i update them ?
<11> what do you mean, 'update' ?
<11> like re-do the import to get the latest data?
<12> has anyone used MySQL Query Browser for OSX? It seems to be dead unstable.
<11> it is
<1> true
<11> if you think *that's* unstable, try workbench
<11> it doesn't even generate sensible SQL
<12> it shoud be called, Alpha - its terrible !
<11> it tried to create an a VARCHAR(150) UNSIGNED once
<12> if its a direct representation of what the SQL Server has to offer, then I don't have a lot of confidence in it
<11> let's put it this way
<11> MySQL's desktop applications are great, unless it's on OS X, in which case they're complete ****e
<11> they don't work at all, and they don't even work well enough to report bugs
<12> yeah, even basic functions to edit rows were out of easy reach
<7> darien: yes
<11> the SQL server, on the other hand, works perfectly, even on OS X
<5> nighty: edit rows in QB only available when there is a primary key
<12> lokus: heh, thats a cute bug.
<11> I've never managed to get QB to create a table
<12> Darien: you can create a table by right clicking on the dbl on the right hand panel
<5> nighty: not a bug, but how does it know which row to edit when there is no primary key to identify the row
<7> i want the latest data to be imported to mysql from mssql since the work is in progress i want that to happen once the work is completed i can no more bother about mssql
<11> nighty: no, I can't
<11> I finally got it to have a table structure I want, but when I clicked on 'save', it literally did nothing
<12> lokus: i guess it depends on which way you look at it, but yeah... thanks for the heads up
<5> create table with QB? use mysql administrator instead
<7> it is time for me to leave i will join the chat tommorow
<11> use Navicat
<13> i can't login to phpmyadmin as a user but i can as root (the p***words im supplying are correct) :(
<13> ERROR 1045: Access denied for user: 'web16_u1@localhost' (Using p***word: YES)
<5> Andy298: connect as root and check this, select user,host from mysql.user where user='web16_u1' or user=''
<13> +----------+-----------+
<13> | user | host |
<13> +----------+-----------+
<13> | web16_u1 | % |
<13> | web16_u1 | localhost |
<13> +----------+-----------+
<13> 2 rows in set (0.00 sec)
<13> seems ok to me
<5> Andy298: should work if p***word is correct, note that the localhsot and the % are considered as 2 different user
<13> yeah the p***word is the same - how can i change it just to check?
<5> Andy298: so they may have different p***word, select user,host,p***word from mysql.user where user='web16_u1'
<13> they have the same p***words
<13> can i reset it at all?
<5> !m Andy298 set p***word
<14> Andy298: (SET P***WORD Syntax) : http://dev.mysql.com/doc/mysql/en/SET_P***WORD.html
<13> thanks
<13> works now! lol
<15> my $prepare = qq~UPDATE `dc_menusContent` SET `createdYN` = 'Y' WHERE `recordID` = '$recordID' LIMIT 1~; my $sth = $dbh->prepare($prepare); # is there something wrong with the $prepare statement?
<15> ( is that how I update something? )
<15> when I do the same thing with phpadmin I get this: UPDATE `dc_menusContent` SET `createdYN` = 'N' WHERE CONVERT( `recordID` USING utf8 ) = '20060220070920' LIMIT 1 ; why is the convert () added by phpmyadmin?
<15> when I pulled the single quotes off of the recordID match it worked
<16> Hi, how do i change a column type to bec ome default null?
<16> to become default 0 not null
<16> i forget to do it when creating the table
<16> forgot
<17> try mysql administrator, its quite useful for simple things like that :)
<16> better to learn thru terminal :)
<17> in that case theres a perfectly working handbook on mysql.com that'll show you the answer in case nobody else here cares to answer :)
<16> ALTER table CHANGE column viewed viewed default 0 NOT NULL?
<17> wouldnt know, I use mysql administrator
<16> ok
<16> then you will get problems if you sometime need to ssh the server to make mysql changes :)
<17> Nopers
<17> I got a remote controllably interface to do that.
<17> and if I can ssh, then I can probably also look the answer up on mysql.com
<17> :P
<17> controllable*
<16> ahh ok :)
<16> hmmm not any other mysql freak alive here?
<17> !m gimmulf tutorial
<14> gimmulf: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<17> I'm 99% sure its written right in there if you take a look :)
<16> yes im already there
<16> but im retarded so i dont understand it
<17> wouldnt it perhaps be an idea to use a program like mysql administrator to help you?
<17> it can solve your issue in 5 clicks with the mouse
<16> congratulations :)
<16> yes its a good tool but i want to know all commands
Return to
#mysql
or
Go to some related
logs:
#web
upload nude pics
#perl
bash pause command
localhost:10.0+xnest
#linux
Ubuntu Enemy Territory Glitches
ubuntu mpeg layer 2/3 missing
msn display picture gaim
ubuntu gnomelook windows dual boot
|
|