| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> shabbs: yea we were told to use these guys by people who are more familiar with the reqs.. i just do it.. all cards need to be encrypted blah blah
<1> Anil: Well, that wasn't very nice. I was just about to do your homework for you, but you had to go and shat on my joke.
<2> !m Anil update syntax
<3> Anil: (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<2> read young gr***hoppa
<4> thanks
<4> CSWookie - thank you, but it's not homework, we don't have cl***ess on mySQL (thankfully)
<0> or sql ?
<4> nope
<2> he missed his homework a couple of times so now he has to hack the school's system and up his grade
<5> Antagonist,: About your answer, well, usually I expect polite persons that see that it is a very easy question so could answer, instead of use "**** off"-like sentences.
<1> At my uni, SQL cl***es were on Oracle.
<1> Bleh was their client a piece.
<2> yeah, my db cl*** was with oracle
<4> at my university there are no database cl***ess as per the CS department requirements :)
<1> I think I would have been a lot better served with a math cl*** on set theory. I took too much practical stuff.
<0> no DB as per CS requirements ?
<6> SQL92 hadn't been formalized when I was in school last
<6> hee
<0> oww
<2> must be a well known uni
<0> are you serious ?
<2> </sacrasm>
<2> ack
<2> </sarcasm>
<0> it's 2006 who would not teach DB with CS ?
<0> shabbs, i meant to Anil
<2> oh :D
<4> Princeton doesn't :P
<0> i've known you long enough to know sarcasm usually
<0> princeton .. like new jersey ?
<0> my ex is from there.. explains everything
<2> princeton, texas :D
<1> alphablue: DB usage is practical. If you're getting a theoretical degree, it's not really necesary.
<6> The City Formerly Known As Prince Town
<1> alphablue: DB was an elective at Purdue.
<2> it was an elective at mine too iirc
<0> cswookie: heh ok.. i shouldn't talk i dropped out after 3 semesters
<0> i forgot what they had
<0> oh he has shells at MIT and princeton
<4> yeah :P
<4> like godel.princeton.edu is a shell
<4> :)
<0> when i was a warez monkey.. i had many shells too
<4> this is a direct machine fool :)
<0> who you callin fool ?
<2> Anil: that's why you were at MIT on a direct machine a minute ago?
<2> didn't realize they were next door to eachother
<4> shabbs: no, that was a shell
<2> uhhuh
<0> so you have a box at your hall
<0> in your dorm
<7> under the bed?
<1> alphablue: Heh. You use a direct machine. You're so cute.
<0> i use indirect machines
<0> i'm actually typing from a payphone
<7> I'm gettin my secretary to type for me
<1> alphablue: That was supposed to go to Anil actually.
<1> My tab complete has boned me.
<4> oh god, Bunch of idiots live off on #mysql :)
<2> yep that's us
<2> what does it make him if he has to ask a bunch of idiots for help?
<1> We're idiots but...
<0> yes, i eat mysql
<1> He still doesn't have his homework done.
<7> tasty database goodness!
<7> a Cookie!
<6> hee
<0> he'll just use his MIT shell yo!
<6> Cool
<7> it's a learning experience! I'm only doing it for your own good!
<8> MIT programming cl***es teach Lisp (scheme) &c ... not how to program in say, C. It's ***umed that if you know the theory, you can figure out the practice
<8> I'm sure lotsa other schools do the same...
<0> schools are for nerds
<8> nerds rule!
<8> /mode #MySQL -nerd sjrussel
<9> could someone tell me what the problem is with this code? http://iol.homelinux.org/quick.stat.sql.txt
<0> it doesn't work ?
<9> I get a syntax error on line 4
<1> I wish my school had tought Lisp.
<9> I guess I don't understand how to use the syntax for enum correctly
<1> As opposed to Java.
<8> you need to change to the new db
<8> USE db
<9> sjrussel: aaaaaah ok I will do that
<0> i was taught lisp my freshman yr
<8> verdict doesn't have an 'enum' type
<8> has no type
<8> also, you need to quote the enum strings
<8> too many {} :)
<0> i forgot all of it , i'm sure if i see it i'll remember
<1> alphablue: I'm teaching myself Scheme. I believe it to be worthy. But difficult.
<9> sjrussel: ok I will make those changes
<0> i'm teaching myself monkey!
<8> it was designed to teach CS.. not sure it makes sense to learn for other reasons
<9> sjrussel: yah it works!
<9> sjrussel: thanks
<0> sj: don't emacs people use it ?
<10> Whats the easiest way to downgrade from mysql 5 to mysql 4.1 on windows? Using appservnetwork pack.
<9> http://iol.homelinux.org/quick.stat.sql.txt I am trying to insert multiple rows, with one insert statement. How do I change the syntax of this snipet to do two rows at once?
<1> sjrussel: I'm learning to learn functional programming.
<8> lisp, but is it scheme?
<1> emacs is an elisp interpreter.
<1> scheme is more minimal.
<9> I got the answer, I just needed another comma http://iol.homelinux.org/quick.stat.sql.txt
<11> Mornin
<11> I have a situation: my database replication went awry, and IM looking at two month old data... I have a backup that has data until 6:25 am this morning, and hope to put that back into play, but Im wondering if it is wise to just stick it in.
<2> argh, why can't openssl just let mysql ship with it compiled in grr
<12> pythos: you'll need to restore your master, copy across to the slave and restart replication. Thank goodness for that backup :)
<12> shabbs: lol
<2> it's not funny, a simple "we don't have to buy anything, it's available in mysql" has turned into a "we can buy a crypto API that may or may not work in VB6 and perl" or "we can hack it with a perl module that does it and creating a .dll wrapper around a .net cl*** that provides encryption"
<12> can't you just compile your own mysql binary?
<11> inviso, ya. Im kind of shaking right now, so I am fearful that I remember how to put the data in right..
<11> or dont
<12> pythos: just make another backup copy of your backup and burn it to CD. Then, have fun ;)
<12> as long as you don't nuke that backup, you can't really mess it up
<11> inviso, ya.. restoring from a backup is freeking me... What is the string?
<12> pythos: how did you make the backup?
<11> its automated every morning.. I could look I guess
<12> what does it give you as a result? A .sql file?
<11> ya
<0> whatever you do today, make sure you don't use the rm command all day
<11> ahh, ya ab
<0> or mv
<12> ok, to clear your current database, login to mysql and run drop database such_and_such; create database such_and_such; Then, from the bash shell, mysql -u user -p < the_file.sql
<11> just cp'd it... had a hard time pressing 'enter' even on that
<2> or if it has the create db statement in it you can just run the last part
<11> you don't suggest just plopping the backup onto it without a purge first then?
<2> depends if the backup script does it or not
<11> let me look then
<2> might have something like "drop database if exists"
<12> pythos: the purge is the drop database part. It will clean it fast ;)
<0> 1. it would be nice if you knew how you were taking backups, but if it is a .sql then you need to re-import everything
<1> If I have last_name and first_name fields, can a I do WHERE `first_name last_name` LIKE "<input>%"?
<1> Or something similar.
<8> concat
<11> man, the backup script is huge..
<13> CSWookie, use fulltext
<2> it should be, it contains inserts for all your data
<10> Could not start the service MySQL. Error: 0. <-- what does that MEAN?
<0> !perror 0
<2> means check your error log
<3> System error: 0 = Success
<0> cute
<10> This... doesn't seem like a success
<0> success! we could not start the server!
Return to
#mysql
or
Go to some related
logs:
mysql Administrator can't create table
UdontKnow ircop
0XD00D00
rhel4 sata_sil
centos rndc connection refused
bazy84
port nock
#web
dvd decrption
lmbench Permission denied
|
|