| |
| |
| |
|
Page: 1 2 3
Comments:
<0> hi
<0> when was mysql 5 released?
<1> check the readme/changelog?
<0> 1.6.1. What's New in MySQL 5.0
<0> The following features are implemented in MySQL 5.0.
<0> BIT Data Type: Can be used to store numbers in binary notation. See Section 11.1.1, Overview of Numeric Types.
<0> nothing aboun the date
<0> and i wasnt several lines in the website, sorry about that
<0> well i actually need to know if hosting services are already commonly using v5
<0> cause im gonna start a db in my machine and then upload it but i dont want to develop my app for v5 and then find out that hostings are still using v4
<1> why nto just ask your host...
<0> i dont have one yet
<0> thats the thing, that i dont want to end up with a lousy host just because its the only one that is using v5 already
<0> so my question is, how popular is mysql 5 at this moment
<1> fr 150 bucks / month you get a dedicated server at ev1servers.net
<1> run whatever you want
<2> i have a problem getting the date to show on my .php, could anyone help me?
<2> or it could be in mysql
<2> actually, the date works fine, i mean the time, DATETIME NOT NULL, and i used '%m-%d-%y %H:%i')
<3> can anybody *possibly* find a problem with this? Error: add_user MYSQL Error: You have an error in your SQL syntax near '; ' at line 1, query was: INSERT INTO users (UserName, P***word, IsAdmin, LastLoginTime) VALUES ('brett', 'p***word', '1', '1137114829');
<4> fury______ depending on where you made that.
<4> errrr depending on where your making that from
<4> you need
<5> well I'm using mysql++
<5> and I may have a \n after some queries, ie, "select * from table;\n"
<5> my sql server was fine with it
<5> but as I'm moving these binaries over to another box with another version of mysql
<5> I'm getting the error about SQL syntax near ';'
<4> Try just for kicks
<4> INSERT INTO users (`UserName`, `P***word`, `IsAdmin`, `LastLoginTime`) VALUES ('brett', 'p***word', '1', '1137114829');
<5> yah I already had
<5> it was the \n
<5> figured it out, thanks :)
<4> oh
<5> funny how one version is picky about that, another isn't
<4> lol you have no idea
<4> I Have so many problems going between MySQL 4.0 and 4.1
<2> anyone here can help me out on getting the time, the date works, i get this " 01-12-06 00:00 " with '%m-%d-%y %H:%i') and yet the table is on datetime
<6> i am for a way to import a csv file into mysql. Does anyone have any tips?
<6> all i find using google is php related
<2> i don't understand, if the date is working, why isn't the time as well
<2> this is crazy
<2> unless the unix clock is down
<2> do u have to set the clock in mysql in order for it to work?
<2> such as mysql> SET GLOBAL time_zone = timezone;
<2> i give up
<7> some here?
<8> can anyone recommend a GUI-based database design tool similar to dbdesigner (linux based, please)?
<8> guess not.
<9> meh... it's easier to start another terminal then find one that's free
<10> http://blerg.org/?u=Dark
<11> salut
<10> salut Abaris
<11> salut Dark_Rain
<10> ce faci radu
<10> ?
<12> Abaris :D
<12> wsup nenia ?
<12> still alive ?
<11> salut oceanBlue
<13> is there a faster way to pull the bottom x rows from a table than using order by/limit?
<10> nop
<10> i don't know other way
<13> i have a table with > 4.5m records, so it's awful to even take the last 10 rows off
<14> shouldn't be if indexed properly
<1> primary key
<13> how do i check that?
<14> grazzy: jup...
<14> okay, that is scary
<14> "i have a table with > 4.5m records,"
<14> "<13> how do i check that?"
<14> not a good combination
<13> ;)
<14> RTFM
<14> http://www.kfwebs.net/links/6 for SQL
<14> grazzy: http://www.kfwebs.net/news/396/Excuse+Calendar
<13> fair enough.
<14> for some reason I didn't use the excuse calendar on eirom though
<1> perhaps it's the list of clueless questions asked in #mysql the last couple of days?
<14> eirom: Your Flux Capacitor has gone bad.
<1> http://excusecalendar.com/
<1> hah
<1> tahts a lame ****ing page
<1> 1 sentence and a banner
<14> grazzy: do a whois on the domain
<14> Creation Date: 12-jan-2006
<13> ok; if i'm using an order other than the primary key column, would it still be quite slow?
<1> hehe
<14> why the **** would you do that
<14> if you want the last 10, use the fricking PK
<14> and yes
<1> stil
<14> unless they are indexed some way
<1> why try to profit before even having a design
<14> grazzy: fair enough, I was the one that urged him to let me use the calendar though
<14> will probably come up properly sometime today
<13> say the table is indexed by creation #, but i wanted to find the last 10 that were modified after a creation #; will the PK be of any advantage e.g. using where creation > x, order by modified?
<14> huh
<14> eirom: rtfm
<14> and I'd say you're in for a slow query
<13> yha; i am
<14> ... is modified indexed?
<13> no
<14> hmm, index too much and you get very slow insterts though ...
<14> eirom: exactly ..
<14> take a minute to think about that
<14> now rtfm
<14> ORDER BY primarykey DESC LIMIT 10; <- reasonably fast
<14> ORDER BY notindexedfield DESC LIMIT 10; <- fairly slow
<14> and is it just me or does eirom remind you of eicar?
<13> actually, yes, modified is indexed
<15> 3 letters out of 5, that's more then 50%
<14> Alfray: about 60% probably
<16> exactly 60%
<15> yeap
<14> you don't say..
<14> :p
<15> damn, math
<16> ;)
<14> now, the question of course is how many really know what eicar is in the first place
<15> antivirus research?
<14> Alfray: somewhat close
<14> http://www.eicar.org/anti_virus_test_file.htm
<14> so yes, eicar is an organization dealing with antivirus research
<15> i've heard that somewhere
<14> Alfray: do you use OpenPGP?
<13> select * from table order by indexedkey desc limit 10; still takes more than 40 seconds.. (shrug)
<14> eek
<15> nope, actually never thought I'll need to use one for encrypting my emails
<14> SELECT *
<14> Alfray: maybe more for the digital signature for many, http://www.secure-my-email.com if you want to read some reasons for it
<13> not actually *, i'm just not typing out table.key1 table.key2, table.key3
<15> i'll do that, thanks
<14> mine is constantly spoofed
<14> hehe, did I tell you about the latest spam message?
<16> wife's too
<14> Hey Kf, Mike here, I had to tell you about this great hook up site. I joined it 4 days ago and I got laid twice over the weekend(by 2 different girls) How cool is that? Its so easy and these babes want to hook up right away with any guys they meet. I'm tellin you, you will get some action. Check it out and see what you think. I am sure you will be thrilled with results. Oh I forgot to mention, it doesnt cost anything to join in the fun.
<13> K
<15> hehe i'm happy with google's spam system, my spam goes to the spam folder lately
<14> Alfray: I have a 49% SPAM-ratio
<16> that's a wild on K_F. ;D
<15> hahaha, that's high ;)
<14> 4168 spam messages the past month
Return to
#mysql
or
Go to some related
logs:
adeline loget
sigmachat crash firefox
#linux
#chatzone
#linux
#linux
km/h vs mph
#javascript
#java
#linux
|
|