Home > Archive > PHP Programming > July 2007 > mysql command line client
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
mysql command line client
|
|
| gerrymcc@indigo.ie 2007-07-28, 6:59 pm |
| Hello, I'm a php/mysql beginner...
Is there any way of making the mysql command line client full-screen?
Sometimes it's easier to use the client than go thru php, but
since it's only about 80 characters wide that limits its usefulness.
Thanks,
Gerard [http://homepage.eircom.net/~gerfmcc]
| |
| Rami Elomaa 2007-07-28, 6:59 pm |
| gerrymcc@indigo.ie kirjoitti:
> Hello, I'm a php/mysql beginner...
> Is there any way of making the mysql command line client full-screen?
> Sometimes it's easier to use the client than go thru php, but
> since it's only about 80 characters wide that limits its usefulness.
That's not really a php question, is it? Please post this question
somewhere else, this is php. :)
--
Rami.Elomaa@gmail.com
"Wikipedia on vähän niinq internetin raamattu, kukaan ei pohjimmiltaan
usko siihen ja kukaan ei tiedä mikä pitää paikkansa." -- z00ze
| |
|
| gerrymcc@indigo.ie wrote:
> Hello, I'm a php/mysql beginner...
> Is there any way of making the mysql command line client full-screen?
> Sometimes it's easier to use the client than go thru php, but
> since it's only about 80 characters wide that limits its usefulness.
>
> Thanks,
> Gerard [http://homepage.eircom.net/~gerfmcc]
>
Ignore the XXXXXXX. Some people would rather spend more energy telling
you to go somewhere else than to simply answer your question. Although
its not a PHP question is certainly is related so let me give you one
place to start. If your using a command line in a windows environment
you can right click on the top title bar, then click properties and
select the layout tab and change the screen buffer size.
As for external clients I love query browser from the mysql developers.
Heres the link: http://dev.mysql.com/downloads/gui-tools/5.0.html
Hope this helps.
| |
| Jerry Stuckle 2007-07-29, 4:00 am |
| zach wrote:
> gerrymcc@indigo.ie wrote:
>
> Ignore the XXXXXXX. Some people would rather spend more energy telling
> you to go somewhere else than to simply answer your question. Although
> its not a PHP question is certainly is related so let me give you one
> place to start. If your using a command line in a windows environment
> you can right click on the top title bar, then click properties and
> select the layout tab and change the screen buffer size.
>
> As for external clients I love query browser from the mysql developers.
> Heres the link: http://dev.mysql.com/downloads/gui-tools/5.0.html
>
> Hope this helps.
Yes, please ignore this XXXXXXX.
This is a PHP newsgroup, for questions on PHP. If you have a mysql
question, you will be better served asking in a MySQL newsgroup, such as
comp.databases.mysql.
Usenet is split up into over 36,000 newsgroups (on my server, anyway),
each with their own purpose. And if people ignore that purpose, soon
you'll get all kinds of off-topic questions in all kinds of newsgroups.
We have enough problems with non-PHP questions in this group without
assholes like Zach encouraging others to post off-topic questions.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
|
| On Sun, 29 Jul 2007 05:44:49 +0200, Jerry Stuckle
<jstucklex@attglobal.net> wrote:
> zach wrote:
>
> Yes, please ignore this XXXXXXX.
>
> This is a PHP newsgroup, for questions on PHP. If you have a mysql
> question, you will be better served asking in a MySQL newsgroup, such as
> comp.databases.mysql.
>
> Usenet is split up into over 36,000 newsgroups (on my server, anyway),
> each with their own purpose. And if people ignore that purpose, soon
> you'll get all kinds of off-topic questions in all kinds of newsgroups.
Indeed, it's not an 'ask a random question' - group. Before you know it,
there's hardly a PHP question in there and this group will be ignored &
lost to that community as a resource.
--
Rik Wasmus
| |
| Captain Paralytic 2007-07-30, 7:59 am |
| On 29 Jul, 04:40, zach <wackzi...@gmail.com> wrote:
> Although
> its not a PHP question is certainly is related
Related? Why, because people can use php to talk to mysql?
So, let's have MS windows questions on this group (because php can run
under windows)
Let's have business process questions (because it can be used to solve
business problems)
Let's have ...
| |
| gerrymcc@indigo.ie 2007-07-30, 7:59 am |
| Jerry Stuckle <jstucklex@attglobal.net> wrote:
>Yes, please ignore this XXXXXXX.
>This is a PHP newsgroup, for questions on PHP. If you have a mysql
>question, you will be better served asking in a MySQL newsgroup, such as
>comp.databases.mysql.
>Usenet is split up into over 36,000 newsgroups (on my server, anyway),
>each with their own purpose. And if people ignore that purpose, soon
>you'll get all kinds of off-topic questions in all kinds of newsgroups.
>We have enough problems with non-PHP questions in this group without
>assholes like Zach encouraging others to post off-topic questions.
>--
>==================
>Remove the "x" from my email address
>Jerry Stuckle
>JDS Computer Training Corp.
>jstucklex@attglobal.net
>==================
I did a search for MySQL newsgroups but there are none available on my
ISP's newsgroup server, hence my request for assistance here.
I think Zach was right; the question was short and near enough
on-topic to be considered relevant, and apparently there was a concise
answer.
Unfortunately, several other people felt it was necessary to wag their
fingers. Please stop for a moment to consider whether such knee-jerk
responses are always appropriate.
Gerard
| |
| Jerry Stuckle 2007-07-30, 7:59 am |
| gerrymcc@indigo.ie wrote:
> Jerry Stuckle <jstucklex@attglobal.net> wrote:
>
>
>
>
>
>
> I did a search for MySQL newsgroups but there are none available on my
> ISP's newsgroup server, hence my request for assistance here.
> I think Zach was right; the question was short and near enough
> on-topic to be considered relevant, and apparently there was a concise
> answer.
> Unfortunately, several other people felt it was necessary to wag their
> fingers. Please stop for a moment to consider whether such knee-jerk
> responses are always appropriate.
>
> Gerard
>
I'm sorry your ISP doesn't support comp.database.mysql or other mysql
newsgroups. But you can still access them through Google Groups.
And where in this newsgroup's name do you see "MYSQL"? Or where in your
inquiry did you even reference "PHP"?
It's not a knee-jerk reaction. Rather, it's trying to keep this
newsgroup to PHP questions like it is intended.
In this and a lot of other newsgroups, if you ask an off-topic question
and you will be told about it.
And it doesn't matter if you agree with Zach or not. He's new to this
newsgroup and obviously doesn't understand how this newsgroup works yet
(his first post was three days ago where he admitted he is a new PHP
user). Rather, you should be listening to people like Rik and Rami, who
have been on here much longer.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
|
| Captain Paralytic wrote:
> On 29 Jul, 04:40, zach <wackzi...@gmail.com> wrote:
>
> Related? Why, because people can use php to talk to mysql?
>
> So, let's have MS windows questions on this group (because php can run
> under windows)
> Let's have business process questions (because it can be used to solve
> business problems)
> Let's have ...
>
Yes...PHP and MySql so closely used in the industry its almost
impossible to learn PHP without learning MySql.
Now, about the topic of posting his question in this group. Yes it was
not the best place to post it, but Rami could have simply answered his
question, and politely informed him that this is not the appropriate
newsgroup to post those kinds of questions. Instead he was as I said and
ass. Maybe you guys forgot what its like being new and not even knowing
what group to post questions. I'm new enough that I still remember times
when I wasn't sure whether or not to post in MySql or PHP when I had a
problem. Some of you need to relax its not like he asked how to perform
a mail merge with word, he wanted an easier way to access his database
than through php.
| |
|
| On Mon, 30 Jul 2007 17:00:39 +0200, zach <wackzingo@gmail.com> wrote:
> Captain Paralytic wrote:
>
> Yes...PHP and MySql so closely used in the industry its almost
> impossible to learn PHP without learning MySql.
Nonsense. I can (and have) use plenty of PHP without MySQL, even without a
database. Nor problems there, MySQL is 'just another possible source of
data'.
> Now, about the topic of posting his question in this group. Yes it was
> not the best place to post it, but Rami could have simply answered his
> question, and
No and, it sets precedents. Even now more and more people keep turning up
here for MySQL questions. Why? Because they get answered. I myself am also
guilty, giving answers to those questions.
> politely informed him that this is not the appropriate newsgroup to post
> those kinds of questions.
Is what should and will be done.
--
Rik Wasmus
| |
| Ivan Marsh 2007-07-30, 7:01 pm |
| On Mon, 30 Jul 2007 19:42:18 +0200, Rik wrote:
>
> No and, it sets precedents. Even now more and more people keep turning
> up here for MySQL questions. Why? Because they get answered. I myself am
> also guilty, giving answers to those questions.
I have no problem that people ask MySQL questions in this group... a lot
of us run LAMP servers after all.
Not to mention the original question had *almost* nothing to do with
MySQL.
The MySQL client will produce output as wide as the terminal you're
running it in. Set the xterm window for 120 characters (for instance) and
the MySQL client will produce 120 character wide output.
| |
| Jerry Stuckle 2007-07-30, 7:01 pm |
| Ivan Marsh wrote:
> On Mon, 30 Jul 2007 19:42:18 +0200, Rik wrote:
>
>
> I have no problem that people ask MySQL questions in this group... a lot
> of us run LAMP servers after all.
>
> Not to mention the original question had *almost* nothing to do with
> MySQL.
>
> The MySQL client will produce output as wide as the terminal you're
> running it in. Set the xterm window for 120 characters (for instance) and
> the MySQL client will produce 120 character wide output.
>
Maybe YOU don't. But most of us would rather see PHP questions here.
If you want MySQL questions, try one of the MySQL newsgroups. That's
what they're there for.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
|
| Rik wrote:
> On Mon, 30 Jul 2007 17:00:39 +0200, zach <wackzingo@gmail.com> wrote:
>
>
> Nonsense. I can (and have) use plenty of PHP without MySQL, even without
> a database. Nor problems there, MySQL is 'just another possible source
> of data'.
>
>
> No and, it sets precedents. Even now more and more people keep turning
> up here for MySQL questions. Why? Because they get answered. I myself am
> also guilty, giving answers to those questions.
>
>
> Is what should and will be done.
>
> --Rik Wasmus
I'm not disagreeing about where it should have been posted. And I
probably overreacted to Rami's response...but the guy was asking a very
simple question, (and only 6-8 off topic questions have been asked in
the last 1000 posts) and is obviously new. I just think he should have
answered and then politely told him there are places where he could get
a better answer as the post is off topic. I've got a lot of help from
yourself and others here, I just hate it when someone doesn't give the
new guys a break. Anyways, this is getting off topic and has nothing to
do with PHP so I'll end my comments on this.
zach
| |
| Jerry Stuckle 2007-07-30, 7:01 pm |
| zach wrote:
> Rik wrote:
>
> I'm not disagreeing about where it should have been posted. And I
> probably overreacted to Rami's response...but the guy was asking a very
> simple question, (and only 6-8 off topic questions have been asked in
> the last 1000 posts) and is obviously new. I just think he should have
> answered and then politely told him there are places where he could get
> a better answer as the post is off topic. I've got a lot of help from
> yourself and others here, I just hate it when someone doesn't give the
> new guys a break. Anyways, this is getting off topic and has nothing to
> do with PHP so I'll end my comments on this.
>
> zach
As Rik said - people come here because they search Google for MySQL and
see questions answered here.
If they see people politely redirected to the correct group, they'll see
that, also.
One way will encourage them to post here. The other will encourage them
to post in the correct place.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| Ivan Marsh 2007-07-30, 7:01 pm |
| On Mon, 30 Jul 2007 15:47:59 -0400, Jerry Stuckle wrote:
> Ivan Marsh wrote:
>
> Maybe YOU don't. But most of us would rather see PHP questions here.
Did I miss the meeting where you were elected talking head for the group?
....and like I said "I don't", which is clearly speaking for myself and
making no suggestion that anyone else wouldn't have a problem with it.
You'll also notice that, as I said, the original question wasn't even a
MySQL question... it was a terminal and/or DOS window question, which
obviously doesn't belong here, but since it was clear the OP had no idea
the scope of his own question, which group he posted it in is pretty much
irrelevant. I simply thought I'd give him an answer.
I'll make sure to check with you before I take action next time.
> If you want MySQL questions, try one of the MySQL newsgroups. That's
> what they're there for.
Thank you Jerry Stuckle... Suuuuuuper-Genius.
| |
| Jerry Stuckle 2007-07-30, 7:01 pm |
| Ivan Marsh wrote:
> On Mon, 30 Jul 2007 15:47:59 -0400, Jerry Stuckle wrote:
>
>
> Did I miss the meeting where you were elected talking head for the group?
>
It was the same meeting where you were elected newsgroup troll.
> ...and like I said "I don't", which is clearly speaking for myself and
> making no suggestion that anyone else wouldn't have a problem with it.
>
> You'll also notice that, as I said, the original question wasn't even a
> MySQL question... it was a terminal and/or DOS window question, which
> obviously doesn't belong here, but since it was clear the OP had no idea
> the scope of his own question, which group he posted it in is pretty much
> irrelevant. I simply thought I'd give him an answer.
>
Actually, it arguably was a MySQL question - which could be answered by
pointing him to certain tools.
> I'll make sure to check with you before I take action next time.
>
>
> Thank you Jerry Stuckle... Suuuuuuper-Genius.
>
Ok, Ivan - Suuuuuuuper-Troll.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
|
| On Mon, 30 Jul 2007 22:28:11 +0200, zach <wackzingo@gmail.com> wrote:
> Anyways, this is getting off topic and has nothing to do with PHP so
> I'll end my comments on this.
Indeed, I'm with you :).
--
Rik Wasmus
| |
| Ivan Marsh 2007-07-30, 7:01 pm |
| On Mon, 30 Jul 2007 17:05:21 -0400, Jerry Stuckle wrote:
> Ivan Marsh wrote:
>
> It was the same meeting where you were elected newsgroup troll.
Brilliant retort... you clearly put me in my place there... but you
should probably look up what "troll" means in an nntp context.
| |
| Jerry Stuckle 2007-07-30, 9:59 pm |
| Ivan Marsh wrote:
> On Mon, 30 Jul 2007 17:05:21 -0400, Jerry Stuckle wrote:
>
>
> Brilliant retort... you clearly put me in my place there... but you
> should probably look up what "troll" means in an nntp context.
>
>
Yep, I know exactly what it means. And it fits you perfectly.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| Ivan Marsh 2007-07-31, 7:00 pm |
| On Mon, 30 Jul 2007 20:22:44 -0400, Jerry Stuckle wrote:
> Ivan Marsh wrote:
>
> Yep, I know exactly what it means. And it fits you perfectly.
You clearly don't. Apparently you think it applies to anyone who disagrees
with you and stands up to you after you've been an ass.
Perhaps you should take a break from posting until you stop menstruating.
| |
| Jerry Stuckle 2007-07-31, 7:00 pm |
| Ivan Marsh wrote:
> On Mon, 30 Jul 2007 20:22:44 -0400, Jerry Stuckle wrote:
>
>
> You clearly don't. Apparently you think it applies to anyone who disagrees
> with you and stands up to you after you've been an ass.
>
> Perhaps you should take a break from posting until you stop menstruating.
>
>
ROFLMAO! Check back through this thread. You started the name calling.
And you kept trying to change the subject because you had no arguments.
And you continue. Just another troll.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| Ivan Marsh 2007-07-31, 7:00 pm |
| On Tue, 31 Jul 2007 12:25:30 -0400, Jerry Stuckle wrote:
> Ivan Marsh wrote:
>
> ROFLMAO! Check back through this thread. You started the name calling.
> And you kept trying to change the subject because you had no arguments.
>
> And you continue. Just another troll.
As I said, you should look up what troll means. Let me look back in the
thread and refresh your memory:
"I have no problem that people ask MySQL questions in this group... a lot
of us run LAMP servers after all."
To which you felt it necessary to act like you own the group and be an ass.
If you can't be civil then don't expect other to be.
| |
| Jerry Stuckle 2007-07-31, 7:00 pm |
| Ivan Marsh wrote:
> On Tue, 31 Jul 2007 12:25:30 -0400, Jerry Stuckle wrote:
>
>
> As I said, you should look up what troll means. Let me look back in the
> thread and refresh your memory:
>
> "I have no problem that people ask MySQL questions in this group... a lot
> of us run LAMP servers after all."
>
> To which you felt it necessary to act like you own the group and be an ass.
>
> If you can't be civil then don't expect other to be.
>
Get it straight in your head, troll. This is a PHP newsgroup. If you
don't believe it, read the charter for the newsgroup. You can find it
at http://www.dbforums.com/archive/ind.../t-400780.html.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| Ivan Marsh 2007-07-31, 7:00 pm |
| On Tue, 31 Jul 2007 14:48:31 -0400, Jerry Stuckle wrote:
> Ivan Marsh wrote:
>
> Get it straight in your head, troll. This is a PHP newsgroup. If you
> don't believe it, read the charter for the newsgroup. You can find it
> at http://www.dbforums.com/archive/ind.../t-400780.html.
You are truly deluded.
Are you suggesting that it would be inappropriate for someone to ask a PHP
related MySQL question in this group?
Do you know what a LAMP server is?
Are you aware that in my post I also pointed out that the question was not
only off topic for this group but for a MySQL group as well?
This argument has nothing to do with what's on or off topic here but the
fact that you're a big whiny dork that thought he should act like the
emperor of the group by parroting information I had already included in my
post back to me as if you were an authority.
If all you can do is call people a troll when they clearly aren't being
one and are incapable of justifying your own statements then your opinion
is pretty much irrelevant.
| |
| Jerry Stuckle 2007-07-31, 7:00 pm |
| Ivan Marsh wrote:
> On Tue, 31 Jul 2007 14:48:31 -0400, Jerry Stuckle wrote:
>
>
> You are truly deluded.
>
> Are you suggesting that it would be inappropriate for someone to ask a PHP
> related MySQL question in this group?
>
> Do you know what a LAMP server is?
>
> Are you aware that in my post I also pointed out that the question was not
> only off topic for this group but for a MySQL group as well?
>
> This argument has nothing to do with what's on or off topic here but the
> fact that you're a big whiny dork that thought he should act like the
> emperor of the group by parroting information I had already included in my
> post back to me as if you were an authority.
>
> If all you can do is call people a troll when they clearly aren't being
> one and are incapable of justifying your own statements then your opinion
> is pretty much irrelevant.
>
>
Read the charter. This group is for PHP questions. I'm not the
authority - the charter for this newsgroup is. And there is nothing in
the charter discussing MySQL. It is all about PHP.
That's what this discussion is about - not the fact that you're a troll.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| Ivan Marsh 2007-07-31, 7:00 pm |
| On Tue, 31 Jul 2007 16:45:15 -0400, Jerry Stuckle wrote:
> Ivan Marsh wrote:
>
> Read the charter. This group is for PHP questions. I'm not the
> authority - the charter for this newsgroup is.
Then don't speak as if you are.
> And there is nothing in the charter discussing MySQL. It is all about
> PHP.
So if someone is trying to figure out why their PHP code that connects to
a MySQL server isn't working they should be refused help?
What if their PHP code is trying to write a file to the file system?
Should they be in a group for the filesystem?
So, help me understand, as far as you're concerned the only questions on
topic here are concerning PHP syntax in a vacuum? Not application?
> That's what this discussion is about - not the fact that you're a troll.
Could you explain how that last statement even makes sense?
| |
| Jerry Stuckle 2007-07-31, 7:00 pm |
| Ivan Marsh wrote:
> On Tue, 31 Jul 2007 16:45:15 -0400, Jerry Stuckle wrote:
>
>
> Then don't speak as if you are.
>
I'm just repeating what the charter said.
>
> So if someone is trying to figure out why their PHP code that connects to
> a MySQL server isn't working they should be refused help?
>
> What if their PHP code is trying to write a file to the file system?
> Should they be in a group for the filesystem?
>
> So, help me understand, as far as you're concerned the only questions on
> topic here are concerning PHP syntax in a vacuum? Not application?
>
That is not what I said. And not what the charter says. Learn to read.
It's simple English.
>
> Could you explain how that last statement even makes sense?
>
>
It's just the fact. This discussion is about whether MySQL questions
are appropriate to this newsgroup. They aren't, according to the
Charter. And just because YOU think it's ok to post MySQL questions in
here doesn't mean it is.
Thats' what the discussion is about. You've already proven yourself to
be a troll. That's not necessary to discuss.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| Ivan Marsh 2007-07-31, 7:00 pm |
| On Tue, 31 Jul 2007 17:32:47 -0400, Jerry Stuckle wrote:
> Ivan Marsh wrote:
>
> I'm just repeating what the charter said.
Your response to my suggesting LAMP questions were fine with me:
"Maybe YOU don't. But most of us would rather see PHP questions here.
If you want MySQL questions, try one of the MySQL newsgroups. That's
what they're there for."
>
> That is not what I said. And not what the charter says. Learn to read.
> It's simple English.
Yea... that's what I thought. Redefine and backpedal.
>
> It's just the fact. This discussion is about whether MySQL questions
> are appropriate to this newsgroup. They aren't, according to the
> Charter. And just because YOU think it's ok to post MySQL questions in
> here doesn't mean it is.
>
> Thats' what the discussion is about. You've already proven yourself to
> be a troll. That's not necessary to discuss.
Just can't admit that you're wrong can you?
| |
|
| Speaking of off- and ontopic, could you both please continue this
discussion in alt.flame or something? All hope that this is going to be
constructive in any way has been long gone..
(Damn, I promised I wouldn't post in this thread anymore....)
--
Rik Wasmus
| |
| Jerry Stuckle 2007-07-31, 10:01 pm |
| Ivan Marsh wrote:
> On Tue, 31 Jul 2007 17:32:47 -0400, Jerry Stuckle wrote:
>
>
>
> Your response to my suggesting LAMP questions were fine with me:
> "Maybe YOU don't. But most of us would rather see PHP questions here.
> If you want MySQL questions, try one of the MySQL newsgroups. That's
> what they're there for."
>
Exactly. MySQL questions go in a MySQL newsgroup. apache questions go
in an apache newsgroup. PHP questions go here.
>
> Yea... that's what I thought. Redefine and backpedal.
>
No back peddling. You just can't read. It's the same thing I've been
saying all along.
>
> Just can't admit that you're wrong can you?
>
No, because I'm not. I'm following the charter for this newsgroup. But
you're just a troll.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
| |
| Jerry Stuckle 2007-07-31, 10:01 pm |
| Rik wrote:
> On Mon, 30 Jul 2007 22:28:11 +0200, zach <wackzingo@gmail.com> wrote:
>
> Indeed, I'm with you :).
>
> --Rik Wasmus
Yea, I guess I should just stop responding to the troll. He tries to
twist everything I say then gets pissed when I don't let him get away
with it.
Typical troll behavior.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
|
|
|
|
|