« first day (2096 days earlier)   

7:48 AM
hi all, i am new to mysql, is versions like mysql 5.6, 5.7 means we have to install only from server-side or we need to use in our queries also ?
 
8:11 AM
@profile101 SQL syntax doesn't change from version to version. Not much that is.
You may have some new features added, from time to time, or old syntax deprecated.
But most queries will work fine between versions.
 
9:07 AM
1
Q: I have earned a badge but it is not showing anywhere

marcello miorelliI have earned the socratic badged, I formally received a message this morning about this, however, after I clicked track next badge I expected to see it showing on my profile, but it hasn't. This is the only proof I got, when I try to add it for tracking it says that I already have it. No, It d...

 
Happy Friday, Heapers
 
@Phil to you, too
 
Friday was a lovely Spring day. I think this is my favourite time of year - not too cold, not too hot, and lots of things growing/flowering. Maybe I should write a poem :)
 
It's beautiful here this morning. Nice sunny day, the commute in was blue shy with some high-up orange clouds
@MasterDatabase Not sure asking that many questions is something to be proud of, but ho-hum :P
 
100 well-received questions though. It's up to you lot what counts as well-received.
I'm not sure it's worth a gold badge, but hey no one asked me.
 
9:12 AM
They're good quality, I'm not complaining about that
 
Fair enough!
 
Consultant (noun): A person that acts as a proxy between a customer and dba.se
3
 
ha ha ha
 
@TomV where is the link to the question?
 
@dezso I was referring to the socratic badge
 
9:14 AM
@TomV ah
 
The snark is strong with this one.
 
I was long thinking about why is it so that there are people who are answerers (the regulars here are mostly these) and there are askers
is there a mixed type, too?
/me being lazy to ask data.SE
 
@dezso There are lots of people starting as askers evolving into answerers
 
@ypercubeᵀᴹ thats fantastic information, than what php code or mysql queries will work work old versions will work in new version also, right ?
 
@profile101 Almost always.
For example, of something that will break, is the change in 5.7 that the default setting in now ONLY_FULL_GROUP_BY (or something similar)
If you had queries that were misusing GROUP BY, they will break with this new setting.
You can of course change the setting or fix your queries
@profile101 And of course, you can test your application and the queries in an environment you setup, before upgrading the production servers ;)
 
9:23 AM
@ypercubeᵀᴹ Can only be a good thing, though it'll no doubt break a shedload of crappy webapps that've been returning random data for many years :P
 
@ypercubeᵀᴹ than you suggest to go with mysql 5.6 & php 7 versions ?
 
@profile101 No, go with the latest MySQL version.
No idea about PHP
 
PrintScreen, screen capture, screen shot. Different names for a very nice invention. — dezso 11 secs ago
 
@dezso Which you then, of course, have to paste into a word document, then .zip up before e-mailling. It's the law!
 
2
A: using parenthesis in SQL

SirSQL0It's difficult to tell precisely without a sample result set, but I would imagine its your utilization of natural JOINs which is typically bad practice. Reasons being: I would avoid using natural joins, because natural joins are: Not standard SQL. Not informative. You aren't specifying what co...

Was NATURAL JOIN removed from the standrad?
 
9:26 AM
@Phil A comment is not for detailed instructions
 
@ypercubeᵀᴹ why we still using "mysql" when already we have "mysqli" ?
 
@profile101 I'm talking about the MySQL server version.
 
@ypercubeᵀᴹ the utilization was
 
You can use whatever PHP extensions (for connecting to MySQL) are best. mysql, mysqli, PDO no idea what is best now
 
thanks @ypercubeᵀᴹ
 
9:29 AM
@dezso I didn't get that
 
@ypercubeᵀᴹ bad joke on my part, bad wording on their part
 
@dezso I've been thinking about that too, not necessarily related to the site
I think it basically boils down to attitude/curiousity
you have 2 types of people, people trying to learn how things work, and people trying to learn how to do things
The people that learned how things work end up figuring out how to do things by themselves, the people that learn how to do things end up needing constant training and having a never ending stream of questions whenever a minor detail differs from how they did the same thing before
 
drivers like ` mysql, mysqli, pdo ` which is best for performance & security and overall ?
 
@dezso thnx for the comment.
The question reminded of a related question in this site that I have been meaning to answer, but needs a lot of time and keep forgetting it on weekends.
 
9:44 AM
@profile101 please read the PHP manual
mysql is deprecated since ages
 
nice @dezso i will remove mysql driver from my brain, now mysqli, pdo ` which is best for performance & security and overall ?
 
@profile101 great. Now go and read the PHP manual, I didn't touch PHP for years
 
2787
Q: How can I prevent SQL-injection in PHP?

Andrew G. JohnsonIf user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's because the us...

@profile101 We basically have no idea. Not many PHP users in this room. Where many=1
 
@ypercubeᵀᴹ The 1 being @profile101 I suppose?
 
@ypercubeᵀᴹ and you are not that one (many == 1)
 
9:51 AM
@TomV i am php-mysql expert :-) just kidding.....
 
@TomV I wasn't thinking of that but ok
Seems like no one got my joke ...
Now I have to explain it ...
 
@ypercubeᵀᴹ At great length preferably
 
@ypercubeᵀᴹ please, please!
Not many | many == 1 => not (a single) one?
 
@dezso OK. I'm certainly not but your "proof" is not good. I meant to substitute "many" for "1" in that sentence;
 
you can, of course, post a much longer version
 
9:55 AM
Not many PHP users in this room.
becomes:
Not 1 PHP users in this room.
So it was many=1 alright.
 
@ypercubeᵀᴹ oh
 
(assuming that == stands for equality condition and = for substitution (yeah assignment)
 
@ypercubeᵀᴹ assignment
 
Is that true in PHP?
 
$many
and so on, but nevermind
@ypercubeᵀᴹ = for assignment, == for equality, === for identity
 
9:57 AM
@dezso and ==== ?
 
==== for a syntax error (not completely sure about this)
but I prefer talking about Clojure these days
(defn === [var1 var2] (identical? var1 var2))
(= (str "a" 1) (str "a" 1))
(=== (str "a" 1) (str "a" 1))
 
This happened after the database automatically restarted. Is it normal for the database to automatically restart itself? The error message also says "Unknown/unsupported storage engine", I was looking for knowledge, not speculation. — vladkornea 38 mins ago
"I was looking for knowledge, not speculation" -- how to annoy Phil
 
10:14 AM
@Phil Looking at his profile page he is the LAMP expert after all
 
10:54 AM
@ypercubeᵀᴹ read the first sentence in the question :P 5.5.49
 
@Phil Seems like a weird bug then.
I have tried to keep by installation free from mysql so I can only test at SQL fiddle.
The results seems the same 9qand buggy) but the version there is older
 
@Phil Well to be fair opening with "Did you even read the log file?" kinda got you off on the wrong foot.
 
hi all, is mysqlI still don't support for "named parameter" & "prepared statements" ?
 
@profile101 You can ask that in the PHP room
 
thanks @ypercubeᵀᴹ
 
11:03 AM
@ypercubeᵀᴹ I have answered, because I am awesome
@PaulWhite yeah, you're right
 
@Phil Oh, f*** me.
Still seems like a very weird bug/behaviour. Without GROUP BY, 0-1 gives -1. With GROUP BY, 0-1 gives 0
Totally expected from mySQL
 
Indeed
 
@Phil I made some edits, feel free to roll back if you disagree. I won't be upset :)
 
@PaulWhite It's fine mate
 
Sweet as then.
 
11:09 AM
My grumpt often needs editing away :P
 
@Phil "mate" is for Australians ;)
 
@ypercubeᵀᴹ I was once told that an Aussie doesn't like you if they call you "mate". If they call you a "c**t" they DO like you :) Don't know if there's any truth in it
 
@ypercubeᵀᴹ Maaaaate in the accent.
 
@Phil Everything is backwards in those parts of the world. Their nicknames, their seasons, the direction the toilets flush...
 
@Phil Sounds about right
 
11:13 AM
Tom is so funny. He'll soon be the new Bill.
 
Where's TomTom these days? And MrDenny?
Banned again. heh
 
Denny's super busy working and flying around the world.
 
11:43 AM
0
Q: Burninate the [dba] and [database-administration] tags?

Paul WhiteThe database-administration and dba tags are used on 1039 and 148 questions respectively. They seem useless to me (on a site called Database Administrators) but I am curious as to how others feel. Should we burninate (delete) these tags? It would leave 15 unclosed questions tagless, but we cou...

Seeing as master database seems to be asleep.
 
@PaulWhite it's lagging usually. It will wake up and double post in a few minutes (or hours)
 
I was expecting it straight away. That's what usually happens.
After I posted the link manually I mean.
 
ah
But for the meta q, 1000 questions don't seem enough for the tag to be kept.
Just because it conflicts with the site's name?
Only discussing by the way, I haven't made up my mind or seriously thoguth about this really
 
That's a big part of it. Mostly I don't see what value it adds. Looking for opinions though, I'm not 100% convinced.
 
I'm not sure how you would retag the question I answered in that tag. human-resources doesn't sound like a tag we need here :)
 
11:47 AM
@TomV Which question?
 
13
Q: Metrics to prove or disprove the need for additional DBA's?

Jason DavisWe currently have 2 DBA’s, me and one other guy and we both feel the need for an additional resource (or two). I have had the conversation with my direct manager on this topic a couple different times, but am having difficulty in getting the notion sold. Most recently our manager shared with us t...

But maybe the entire question can be considered off-topic (it was closed at some point)
 
That's a gold tag-badge I might be able to actually earn at some point
 
Ha!
 
I've been less active around here for so long I have an entire backlog of silly jokes, just so you're warned
 
11:51 AM
Always good to set expectations.
 
However hard it may then be to live up to them.
 

« first day (2096 days earlier)