| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Comments:
<0> Alrighty.
<1> I think I'll write a bot that keeps a counter of the people asking that question, so we can generate some useful statistics on the matter
<2> sjrussel, Ungy: thanks.... is there any way you know of doing it safely?.... kill mysql, overwrite files, start mysql maybe?
<3> Ungy: i disagree
<4> sure, if mysql is down it's safe
<5> spiderworm_work, yes you can stop mysql and replace them but I woudln;t suggest it dump drop and replace is safest
<2> alright guys thanks
<4> ... and CVS is a bad choice for backups
<6> infi: what question?
<4> though CVS of dumps (like Ungy said) is ok
<5> Leithal, reset Auto Increment
<7> howdy
<6> ahh
<6> well the stats would be quite high in here ;)
<5> doody?
<4> I don't understand why people do that
<8> they dont either
<1> sjrussel: neither do they
<1> which is really the problem
<1> "BUT I WANT IT PRITTY!"
<5> sjrussel, they don;t know about truncate or they just think they will run out of numbers soon
<1> no, they want it sequential
<1> 99% of the time
<4> run out of numbers: sure, their apps are THAT popular
<6> quite often people just want to reset for a load
<1> heh
<9> lsmith: i want to store a folder tree in the table, with the id being an int(11). I think its safe to truncate the table when I rebuild the data from the filesystem
<1> "I GOT 12 HITS TO MY BLOGZOR THIS MONTH!"
<2> sjrussel: it's not a matter of backups... its a matter of automating the updating of a production database at the same time as the updating of production code
<5> infi, some do some don't some go to the trouble of reorderin gtables throughout the tables to make it sequential yes
<6> sjrussel: You would be suprised at the people that need to reset it when it hits 127 ;)
<7> What would I use if I wanted to select all fields except one? I.e. SELECT * FROM porn.ography _____ anal WHERE oral = '1'; ??
<6> Olsonfold: Don't use SELECT * ;)
<5> kernelpnc, if you truncate it wil reset the auto_increment
<4> spiderworm - that's hard, but storing the differential changes as ALTERS kind of works
<5> Olsonfold, you would type every field out
<2> sjrussel: so you have some experience in this? cool
<10> Olsonfold, Also, don't quote numbers.
<7> there's really no word to do that?
<10> no
<7> that's weak
<7> oh well, thanks
<6> Olsonfold: Also, Pornography is bad for the wrist.
<9> Ungy: exactly what I want :)
<7> hehe
<5> Olsonfold, seriously SQL is a programming language it is not meant for lazy people it is meant for developers
<11> SQL isn't a programming language, it's a query language
<7> are you joking?
<4> since when aren't developers lazy?
<8> heh most devs are lazy
<7> programming languages are FILLED with shortcuts for lazy programmers
<5> Olsonfold, and * is for testing it is not meant to be used for actual applications
<6> Ungy: At least give a decent argument ;)
<7> well, ungy, i'm displaying every field except one
<5> sjrussel, developers are lazy but they are nto that lazy I mean I would do a show table and grab all the names and then put them in y select but that is only semi lazy
<10> !tell us about evil
<0> will asked me to tell you this: Evil is clearly defined at http://www.parseerror.com/sql/select*isevil.html
<4> !tell us about lazy
<0> But I don't know a thing about that.
<6> Olsonfold: You have a table: create table t1 (c1 int, c2 int, c3 int, c4 int, c5 int, c6 int); and you "select * except c6 from t1;" - then somebody adds c7 as type LONGTEXT. What happens?
<10> See, lazy is not for SQL
<5> Olsonfold, you ant somethign liek that go bug the SQL standards commitee seeing how it doesn't exist on any database I know of
<10> You can write a patch.
<9> thank you guys for your quick help, have a good night!
<5> will, certainly lets change it
<6> it will never exist in a standard - as it's simply a bad idea
<7> EXCEPT is a keyword used for comparing two sets...
<7> Leithal
<6> Olsonfold: Well you did your homework! ;)
<6> it was an example
<7> oh, theoretically with what I suggested?
<6> yes
<5> Leithal, I think he is HAVING problems
<4> Olsonfold: those types of things generally don't exist on the data description layer
<4> you could use information_schema to auto-generate the query in your database abstraction layer, though
<6> Ungy: Well HAVING is a problem all of it's own in many cases
<4> ... but that's still a bad idea
<6> but we'll leave that for another day ;)
<10> We should just drop the SQL standard.
<5> Olsonfold, there are many reason why that doesn't exist one was his example if you really wanted to get around this make a view and then select * although yrou view ould still have to list all fields you want ;-)
<4> seriously. What good does it do anyway?
<5> Leithal, HAVING rocks my socks off
<5> sjrussel, certainly nothign since ODBC drivers ****
<6> Woooo it r0x0rs his b0x0rs
<7> that's actually what i'm deciding right now
<7> whether I should stick with select * and just have php ignore that last field
<7> or go ahead and put each field in manually
<10> Put in each field manually.
<7> you think?
<4> best practice is to list the fields
<6> how many fields are there exactly?
<7> alright, that's what i'll do, then
<7> For now there's just 9
<6> ..
<10> lmfao
<5> hahahah .....
<5> holy **** I could have typed them faster then you askign about it
<7> but, there will potentially be quite a few more in the future
<6> are they like 30 characters long each or something?
<6> so add them as you go along
<6> you add the field, you add it to your statements..
<12> for whatever reason after i installed 5.0, mysql is no longer in the path. i cant find it. does anyone know the path I ***ign for the path variable?
<7> the thing is
<5> Olsonfold, I have in one table over 360 fields and I type them out as I need them
<4> 360 fields?
<4> are you serious? Why?
<8> 1 for every degree
<7> it may be the case that someone else is changing the database through phpMyAdmin
<7> who doesn't understand the code at all
<5> sjrussel, long story but yes it is a great table
<4> then you have a management problem, not a code problem
<7> which is why i've been careful to automate everything for them
<4> such a person shouldn't have any access to administrative commands
<4> like ALTER
<6> Agreed
<7> sure they should
<4> uh, no, they shouldn't
<6> why let somebody that has no idea about the application have access to the database like that?
<7> because they know better than to do anything other than what they've been taught
<7> and are still able to do useful work
<4> ahh! what happened to my data?
<7> that I would be doing otherwise
<8> hehe bollocks
<4> bullsh!t
<4> Olsonfold, you are lazy in a scary in dangerous way, instead of a productive and creative way
<13> !perror 1064
<7> that's not an issue of laziness, sjrussel
<7> and if you'd like, I could elaborate and further explain WHY it's set up the way it is
<14> does mtop work with the 5.x series - or is there a similar equivalent?
<7> but honestly, I don't think anyone here cares
<4> no, we're waiting for the inevitable consulting gig that will follow :)
<8> we do care
<6> Olsonfold: Actually, they do, that's why they sit here - and they are only trying to give the best advice possible
<6> Which is what they have given ;)
<7> so you honestly want to hear why it's set up how it is?
<4> sure
<7> okay
<4> if it's really long, pastebin
<6> not mer personally, I have plenty to do
<6> wish I had time to lately ;)
<7> It's a fraternity project. I'm writing web-based tools to help with administrative efficiency
<7> submitting officer reports, etc
<7> and please refrain from fraternity jokes
Return to
#mysql
or
Go to some related
logs:
ohiopctech.com
debian postfix tls make-ssl-cert
rbash homedir
a2enmod gentoo
ubuntu mii-tool dhclient
javasan
vlc: Depends: dbus-1 (>= 0.23.4) but it is not installable
radhostclient linux
firewall dnz 4 network cards
#css
|
|