On 2015/05/07 19:42, Paul Halliday wrote:
Should have showed the whole thing. Take a look here (click image to see
full output):
http://www.pintumbler.org/tmp
I don't see why this worries you. Joining often increases variation.
Indeed, if in some case an inner join never did, maybe the joined
Should have showed the whole thing. Take a look here (click image to see
full output):
http://www.pintumbler.org/tmp
On Thu, May 7, 2015 at 4:11 PM, shawn l.green
wrote:
> Hi Paul,
>
> On 5/7/2015 10:17 AM, Paul Halliday wrote:
>
>> Fighting a bit with this one...
>>
>> If I do something like (
First, have you tried GROUP_CONCAT(DISTINCT types) ?
Second I see my counts rise just as my group_concat() terms when I do
something similar to what you're talking about. Also, here:
val c_types d_types
3t9,t9,t9 a2,a3,a9
Your column headers don't seem to match your query.
Hi Paul,
On 5/7/2015 10:17 AM, Paul Halliday wrote:
Fighting a bit with this one...
If I do something like (pseudo):
SELECT count(val) AS n, GROUP_CONCAT(types) AS c_types FROM tbl1
returns something like:
n c_types
1 t9
when I add a left join though:
SELECT count(val) AS n, GROUP_CONCAT(
Hello,
mysqladmin and mysql command-line client is included in MySQL-client
package.
mysql_secure_installation is included in MySQL-server but it's a perl
script which calls mysql command-line client internally.
Thus, you should install MySQL-client-*.rpm and try again.
Regards,
2014-05-04 15
Am 04.05.2014 08:29, schrieb EdwardKing:
> I'm newbie to mysql and I want to install mysql under Centos 5.8 using
> MySQL-server-5.5.37-1.linux2.6.i386.rpm, I use following command to intall
> mysql
>
> #[root@master software]# rpm -ivh MySQL-server-5.5.37-1.linux2.6.i386.rpm
> Preparing...
On 09/27/2013 12:48 AM, Anders Karlsson wrote:
Try specifying the utf8_bin collation instead and that will work.
or if you need comparisons to be case insensitive, but still want
to have accented letters be considered different to their base
form and to each other you may want to have a look h
That is because of the collation. It's the collations that determines
character equality. I can't tell what the collation is in your case for
the columns us, es, de, es and fr. Also, that you match character sets
in different columns is usually not a good idea, unless you have a good
reason for
Hi,
> I wold expect this NOT to match.
This should be because the fields you are comparing are utf8_general_ci,
this collation groups characters in 'classes' so that all variants of what
are considered to belong to the same character type, are put in that class.
Equality comparison is done compar
Assuming Linux, check where it's listening using "netstat -lptn".
lx wrote:
>hi all:
>I'm a new one. I have a mysql server in 192.168.27.72 , and a mysql
>client in 192.168.23.73.
>I use this way:
> mysql -h 192.168.27.72 -u root -p
>
>the ERROR message is:
>ERROR 2003 (HY000): Can't connect
- Original Message -
> From: "Eric Bergen"
>
> Anger and OS religious arguments the real answer is that is just how
> the option parsing code works. It doesn't always have to make sense.
Ye gods, it's an outbreak of common sense! Someone quarantine that man before
it spreads!
In all se
Hi, Eric,
Thanks a lot for the GREAT explanation! This perfectly answers my question.
We can close the threads now :-)
Best,
T
On Sat, Nov 24, 2012 at 8:53 AM, Eric Bergen wrote:
> Yes, the missing piece of the puzzle is that configuration files are
> turned into command line arguments intern
Yes, the missing piece of the puzzle is that configuration files are
turned into command line arguments internally. Programs will parse
configuration files and place them at the beginning of the array for
command line arguments. They are made case sensitive because they are
turned into command line
Dear Eric,
Thanks a lot for the explanation of argument directives! The concerns are
very considerate.
Actually, what I'm curious about is the configuration directives in the
configuration file, i.e., my.cnf. To my experience, MySQL is the very few
software who treats these directives in a case s
Anger and OS religious arguments the real answer is that is just how
the option parsing code works. It doesn't always have to make sense.
There are short and long args to programs. For example on the mysql
client there is --port or -P and --pasword or -p. The short options
have to be case sensitive
It is always fun to watch people get into a conflict about something silly and
unimportant...
On 18.11.2012, at 18:13, Reindl Harald wrote:
>
>
> Am 19.11.2012 02:07, schrieb Tianyin Xu:
>> You are saying as long as admins are careful, there's no misconfiguration?
>> But why misconfigura
On Sun, Nov 18, 2012 at 6:13 PM, Reindl Harald wrote:
>
>
> Am 19.11.2012 02:07, schrieb Tianyin Xu:
> > You are saying as long as admins are careful, there's no
> misconfiguration?
> > But why misconfigurations are so pervasive?
> > Simply because the admins are not careful enough?
>
> yes
>
>
Th
Am 19.11.2012 02:07, schrieb Tianyin Xu:
> You are saying as long as admins are careful, there's no misconfiguration?
> But why misconfigurations are so pervasive?
> Simply because the admins are not careful enough?
yes
> I apologize for my lack of respect. I don't know what's your stuff, but
Hi,
On Sun, Nov 18, 2012 at 4:35 PM, Reindl Harald wrote:
>
>
> Am 19.11.2012 01:27, schrieb Tianyin Xu:
> > I'm not saying the file names but the configuration directives.
> > At least for most servers I have managed so far,
> > all the configuration directives are case insensitive. Examples?
>
Am 19.11.2012 01:27, schrieb Tianyin Xu:
> I'm not saying the file names but the configuration directives.
> At least for most servers I have managed so far,
> all the configuration directives are case insensitive. Examples? PostgreSQL,
> Apache httpd, OpenLDAP, Squid, etc.
> That's why I'm cur
Hi, Reindl,
On Sun, Nov 18, 2012 at 3:11 PM, Reindl Harald wrote:
>
>
> Am 18.11.2012 23:59, schrieb Tianyin Xu:
> > Hi,
> >
> > I'm just curious why MySQL parses its configuration directives (i.e., the
> > ones in my.cnf) in a case sensitive way?
> >
> > For example, Having "Port=3309", will re
Am 18.11.2012 23:59, schrieb Tianyin Xu:
> Hi,
>
> I'm just curious why MySQL parses its configuration directives (i.e., the
> ones in my.cnf) in a case sensitive way?
>
> For example, Having "Port=3309", will receive "unknown variable 'Port=3309".
>
> I guess there must be some concern for th
Things like that are hard to optimize. If you have no overlapping ranges, then
this will be much more efficient:
http://mysql.rjweb.org/doc.php/latlng
> -Original Message-
> From: Doug [mailto:d...@hacks.perl.sh]
> Sent: Thursday, July 12, 2012 7:03 PM
> To: mysql@lists.mysql.com
> Sub
> can you tell me why my this query doesn't use the index?
>
>
> mysql> explain select * from iploc where 1902800418 between start_ip
> and end_ip;
Hazarding a very quick guess: if this table is what I think it is (NON-
overlapping IP ranges + (geo)location), you might want to try:
SELECT * FR
On Wed, Jul 11, 2012 at 5:46 AM, Reindl Harald wrote:
> > mysql> show profiles;
> >
> +--++--+
> > | Query_ID | Duration | Query
> > |
> >
> +--
column used in the order by caluse, should be the first column in the
select statement to make the index work
On Wed, Jul 11, 2012 at 3:16 PM, Reindl Harald wrote:
>
>
> Am 11.07.2012 11:43, schrieb Ewen Fortune:
> > Hi,
> >
> > On Wed, Jul 11, 2012 at 10:31 AM, Reindl Harald
> wrote:
> >> the m
Am 11.07.2012 11:43, schrieb Ewen Fortune:
> Hi,
>
> On Wed, Jul 11, 2012 at 10:31 AM, Reindl Harald
> wrote:
>> the mysql query optimizer is somehow stupid
>
> Its not stupid - remember its not trying to find the best index,
> rather its trying to find the least costly plan
> to return the d
Hi,
On Wed, Jul 11, 2012 at 10:31 AM, Reindl Harald wrote:
> the mysql query optimizer is somehow stupid
Its not stupid - remember its not trying to find the best index,
rather its trying to find the least costly plan
to return the data in the quickest manner.
For the optimizer in this case it
the mysql query optimizer is somehow stupid
a simple query, order by with a indexed column and
you have to use where order_by_field>0 - why the
hell is mysqld not happy that a key is on the field
used in "order by"?
mysql> EXPLAIN SELECT * FROM cms1_quickbar_groups ORDER BY qg_sort ASC;
++---
Hi,
The statement will do a Full table scan, because of the following things :
Not using "Where" clause, and selecting "all columns (*)" within the query.
Filesort is used since no index is used, use a where clause with condition
on column which is indexed and notice the explain plan. Also you can
an [mailto:vegiv...@tuxera.be]
> Sent: Monday, May 07, 2012 1:29 AM
> To: Zhangzhigang
> Cc: mysql@lists.mysql.com
> Subject: Re: Why is creating indexes faster after inserting massive
> data rows?
>
> - Original Message -
> > From: "Zhangzhigang"
>
- Original Message -
> From: "Zhangzhigang"
>
> Creating indexes after inserting massive data rows is faster than
> before inserting data rows.
> Please tell me why.
Plain and simple: the indices get updated after every insert statement, whereas
if you only create the index *after* the
which version of mysql are you using.
Is this secondary index.?
On Mon, May 7, 2012 at 12:07 PM, Zhangzhigang wrote:
> hi all:
>
> I have a question:
>
> Creating indexes after inserting massive data rows is faster than before
> inserting data rows.
> Please tell me why.
>
On 24 Apr 12, at 15:57, mysql-digest-h...@lists.mysql.com wrote:
> From: shawn green
>
>
> On 4/22/2012 11:18 PM, Zhangzhigang wrote:
>> Why does not the mysql developer team to do this optimization?
>
> When the Optimizer is told to sort a result set in the order determined
> by a random val
http://www.percona.com/ppc2009/PPC2009_mysql_pagination.pdf
Let me know if that is not clear enough.
> -Original Message-
> From: Zhangzhigang [mailto:zzgang_2...@yahoo.com.cn]
> Sent: Monday, April 23, 2012 6:56 PM
> To: Rick James
> Cc: mysql@lists.mysql.com
> Subject
eft off"?
--- 12年4月24日，周二, Rick James 写道：
> 发件人: Rick James
> 主题: RE: Why does the limit use the early row lookup.
> 收件人: "张志刚" , "mysql@lists.mysql.com"
>
> 日期: 2012年4月24日,周二,上午2:54
> InnoDB or MyISAM?
> PRIMARY KEY (id) is a separate index in My
ort is nearly Order(1),
and the memory is only slightly more than the cost of 10 rows.
> -Original Message-
> From: shawn green [mailto:shawn.l.gr...@oracle.com]
> Sent: Monday, April 23, 2012 5:52 AM
> To: mysql@lists.mysql.com
> Subject: Re: Why does the limit use the ea
InnoDB or MyISAM?
PRIMARY KEY (id) is a separate index in MyISAM, so scanning 110 rows is
faster than for InnoDB, where the PK is "clustered" with the data. That is,
MyISAM scans a narrow, 2-column, index (id + pointer); InnoDB scans wide rows
(all columns).
There is no way to avoid scanni
On 4/22/2012 11:18 PM, Zhangzhigang wrote:
> Why does not the mysql developer team to do this optimization?
>
> --- 12年4月20日，周五, Reindl Harald 写道：
>
>> ...
>>
>> because the mysql optimizer until now is really
>> bad in many situations - order by rand() makes a
>> temporary table wil ALL data as
Why does not the mysql developer team to do this optimization?
--- 12年4月20日，周五, Reindl Harald 写道：
> 发件人: Reindl Harald
> 主题: Re: Why does the limit use the early row lookup.
> 收件人: mysql@lists.mysql.com
> 日期: 2012年4月20日,周五,下午3:50
>
>
> Am 20.04.2012 04:29, schrieb 张志刚:
ld [mailto:h.rei...@thelounge.net]
>> Sent: Friday, April 20, 2012 12:50 AM
>> To: mysql@lists.mysql.com
>> Subject: Re: Why does the limit use the early row lookup.
>>
>>
>>
>> Am 20.04.2012 04:29, schrieb 张志刚:
>>> My point is that the limit can
lto:h.rei...@thelounge.net]
> Sent: Friday, April 20, 2012 12:50 AM
> To: mysql@lists.mysql.com
> Subject: Re: Why does the limit use the early row lookup.
>
>
>
> Am 20.04.2012 04:29, schrieb 张志刚:
> > My point is that the limit can use late row lookup: lookup rows af
Am 20.04.2012 04:29, schrieb 张志刚:
> My point is that the limit can use late row lookup: lookup rows after
> checking indexes to optimize the select speed.
>
> But the mysql optimizer do it with the early row lookup: lookup all rows
> before checking indexes when the one fetch column is not in th
- Original Message -
> From: "Cifer Lee"
>
> it seems none of you hava answered my question.
Yes, that happens :-)
I'm slightly confused as to the difference between "user variables" and "local
variables", though. Are you saying you couldn't just declare @myvar and use it
in your
Am 26.03.2012 14:13, schrieb Cifer Lee:
> why can't be local variable which declared in DECLARE clause?
what are you speaking about?
keep in mind that we can not read your thoughts
signature.asc
Description: OpenPGP digital signature
On 10 Mar, 2012, at 7:06 pm, Cifer Lee wrote:
> when we call procedure
> normally we declare the parameter out of the procedure and pass the
> variable to procedure
> like this
>
> set @x=1;
> call *a_procedure*(@x);
>
> why can not directly pass the digit 1 to the* a_procedure* ?
You can pa
>> ..which I just (earlier this morning) changed to this:
>> export
>> PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:/usr/local/mysql/bin/mysqldump:$PATH"
> You are missing a point, that the proper thing for PATH is directory (or
> effective directory), not runfile in directory. This
;>>> 2012/01/03 11:52 -0500, Govinda
...which strikes me as odd (again, showing how new I am to driving from the
CL), because I do NOT see any entry like this:
/usr/local/mysql/bin/mysqldump
Is "mysql" a symbolic link?
..which I just (earlier this morning) changed to this:
Jan, thanks so much for taking the time with me.
I hesitate to spend much of everyone's inbox space on this as it is getting off
topic, and I am newbie enough with all things CL that folks will tire of me
before I am near ready to complete the thread.
Like it took me a bit of time to think/rese
On 31 Dec 11, at 20:36, Govinda wrote:
>> If you're using MacOS X Server, it should be in /usr/bin, which should be in
>> your default $PATH, or else you couldn't do ANYTHING, including "ls."
>
> I have notes somewhere in my stuff about how to get $PATH to include where
> mysql actually lives,
>>> So then I try (in Mac OS X Terminal, while logged in as me (not root)):
>>> mysqldump -uroot -p myDBname myTableName > ~/myTestDumpedTable.sql
>>> ...and again it produces:
>>> sh: mysqldump: command not found..
>>
>> that is because Mac OSX is missing a package-managment and so you need
>> a
Am 31.12.2011 23:53, schrieb Jan Steinman:
> And for the record, there are at least two excellent package managers
> available for Mac OS, and either MacPorts or Fink
if you call this package-managment from the view of a operating
system you have never seen a real one - this are ADDITIONAL
pro
>> So then I try (in Mac OS X Terminal, while logged in as me (not root)):
>> mysqldump -uroot -p myDBname myTableName > ~/myTestDumpedTable.sql
>> ...and again it produces:
>> sh: mysqldump: command not found..
>
> that is because Mac OSX is missing a package-managment and so you need
> a little
Am 29.12.2011 19:21, schrieb Govinda:
> Just a side note, that:
>
> Govind% which mysqldump
> mysqldump: Command not found.
> Govind% which /usr/local/mysql/bin/mysqldump
> /usr/local/mysql/bin/mysqldump
>
> kind of defeats the purpose of having to know the path in advance in order
> to use th
> [snip]
> that is because Mac OSX is missing a package-managment and so you need
> a little knowledge about your OS to fix the PATH or you have to use
> full-qualified calls or configure/install your software to locations
> which are already in the path
>
> "which mysqldump" as normal user wil t
Am 29.12.2011 18:15, schrieb Govinda:
> ...when I try this:
> mysqldump -uroot -p myDBname myTableName > myTestDumpedTable.sql
>
> ..then I keep getting this:
> myTestDumpedTable.sql: Permission denied.
your unix-user has no write permissions to myTestDumpedTable.sql
this has nothing to do wirh
I would suggest trying:
mysqldump -uroot -p myDBname myTableName > /tmp/myTestDumpedTable.sql
Maybe you don't have permission (or space) to write into /usr/local/mysql/bin.
That would
be an unusual place for such files.
On 12/29/11 9:15 AM, Govinda wrote:
Hi Everyone
This should be quick an
I don't have a direct answer for you, just some thoughts:
* traditionally, "localhost" is thought of as an alias for 127.0.0.1
* mysql however, tends to not interpret it like when connecting to the local
server and instead tries to connect to the socket
* to force mysql client to connect over
> It is seems strange to me why the same command "mysql -hlocalhost
> -uxxx" when it is run from the command line, it will show an error.
> When it is run in a bash script, it runs fine. I guess this might be
> described somewhere, but I'm yet to find the answer. Does anybody know
> why this happen
Hong,
What you are seeing is probably your server's ability to keep up with your
benchmark with some comfort. I assume your benchmark isn't completing in a
couple of seconds but would presume that you are not IO bound and all
changes are happening in memory. Its hard to give you 'the' answer as yo
At 03:36 PM 2/28/2011, Michael Dykman wrote:
One statement will do:
SELECT Min(prod_price) , Max(prod_price), Avg(prod_price) INTO pl, ph, pa
from products;
- michael dykman
Michael,
Brilliant! Thanks. :-)
Mike
On Mon, Feb 28, 2011 at 4:30 PM, mos wrote:
> I want to have a store
One statement will do:
SELECT Min(prod_price) , Max(prod_price), Avg(prod_price) INTO pl, ph, pa
from products;
- michael dykman
On Mon, Feb 28, 2011 at 4:30 PM, mos wrote:
> I want to have a stored procedure that returns 5 columns from a table and do
> some calculations on it. But when I tr
On Fri, 2010-11-05 at 15:46 +0800, Changying Li wrote:
> yes, I tried :
> mysql> explain SELECT forumid,visible,sticky,dateline FROM `abc` WHERE
> `forumid` = 25 AND `visible` = 1 AND `sticky` = 0 order by dateline \G
> *** 1. row ***
>
yes, I tried :
mysql> explain SELECT forumid,visible,sticky,dateline FROM `abc` WHERE
`forumid` = 25 AND `visible` = 1 AND `sticky` = 0 order by dateline \G
*** 1. row ***
id: 1
select_type: SIMPLE
table: abc
type: ref
2010/11/4 Changying Li :
> PRIMARY KEY (`threadid`),
> KEY `dateline` (`dateline`),
> KEY `forumid_2` (`forumid`,`thread_type_id`,`visible`,`sticky`,`dateline`),
> KEY `forumid` (`forumid`,`visible`,`sticky`,`dateline`)
> ) ENGINE=InnoDB AUTO_INCREMENT=660 DEFAULT CHARSET=utf8;
>
> mysql> expla
ets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: j...@bytesmiths.com
> To: mysql@lists.mysql.com
> Subject: Re: Why is MySQL always linked to PHP?
> Date: Thu, 22 Jul 2010 22:23:50 -0700
>
>
> On 22 Jul 10, at 21:01,
Now ur shouting ;) ;) ;) i was not. haha
U can say anything an escape with it without being brushed.go an take
poetry...where u can anything with any other thing...hehehe
Cheers,
Anirudh Sundar
On Fri, Jul 23, 2010 at 10:53 AM, Jan Steinman wrote:
>
> On 22 Jul 10, at 21:01, Anirudh S
On 22 Jul 10, at 21:01, Anirudh Sundar wrote:
SO ONE CANNOT COMPARE PHP WITH C.
I can compare anything I want to -- I took a poetry class in college!
("Her teeth were like the stars, 'cause they came out at night." :-)
If you STOP SHOUTING, people might take you more seriously.
-
Jay,
I am not incorrect.
PHP and C work on different domains.
SO ONE CANNOT COMPARE PHP WITH C. PHP IS A FULLY EVOLVED OBJECT ORIENTED
SERVER SIDE SCRIPTING LANGUAGE.
JUST BECAUSE PHP SYNTAX RESEMBLES C, DOES NOT MAKE IT LESS POWERFUL OR
INFERIOR OR LESS SCALABLE.
PHP IS INDEED A SELF SUFFICIE
On 22 Jul 10, at 01:25, Anirudh Sundar wrote:
Jay,
Actually, that was my comment.
Do not compare it with C. C is a middle -level System programming
language.
PHP's syntax is very much like C.
My point, which I guess wasn't clear, is that one of the reasons PHP
is popular (among the ma
On Thu, Jul 22, 2010 at 9:09 AM, John Daisley wrote:
> Sorry, my bad! Must learn to read the whole message!!
>
>
> This can be caused because when a foreign key is created mysql adds an
> index key to the column in addition to the foreign key. Why I'm not sure,
> but I'm guessing its for performan
Sorry, my bad! Must learn to read the whole message!!
This can be caused because when a foreign key is created mysql adds an index
key to the column in addition to the foreign key. Why I'm not sure, but
I'm guessing its for performance. To drop this foreign key
First do this to get the index nam
On Thu, Jul 22, 2010 at 8:47 AM, John Daisley wrote:
> Most likely a foreign key constraint would be violated if the table were
> dropped. Check those index definitions on `Store` and `User` columns.
>
But I don't want to drop the table, I want to drop the foreign key on Store.
How?
TIA,
V
>
> R
Most likely a foreign key constraint would be violated if the table were
dropped. Check those index definitions on `Store` and `User` columns.
Regards
John Daisley
Microsoft SQL Server 2005/2008 Database Administrator
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI
[snip]
Jay,
PHP is a WEB based Server Side scripting Language.
Do not compare it with C. C is a middle -level System programming
language.
Please stop comparing.
[/snip]
The statements about C were not mine, it was just the way that the
thread was snipped together. Believe me when I say that I
Jay,
PHP is a WEB based Server Side scripting Language.
Do not compare it with C. C is a middle -level System programming language.
Please stop comparing.
On Sat, Jul 17, 2010 at 10:03 PM, Jan Steinman wrote:
> From: "Jay Blanchard"
>>
>>
>> You always have to use the right tool for the job
Try Explain command before execute something
Please google how to use index
- Original Message -
From: "hewei"
To: "Ananda Kumar"
Cc: mysql@lists.mysql.com
Sent: Thursday, June 17, 2010 5:54:23 PM
Subject: Re: why the sql so slowly?
you want to select all
From: "Jay Blanchard"
You always have to use the right tool for the job though. The question
is "are we teaching the inexperienced programmers what the right tools
are?
I doubt it!
PHP looks a lot like C, and people are taught C in college.
So instead of working with something more abstract
[snip]
I merely wished to dispel the common, newb impression that PHP is the
only realistic choice.
[/snip]
I don't think that is the impression but I think that the low barrier to
entry and extensive support community make PHP a widely acceptable
choice. I have seen many a newb turned off by the
.
- md
On Fri, Jul 16, 2010 at 2:38 PM, Daevid Vincent wrote:
>> -Original Message-
>> From: Jay Blanchard [mailto:jblanch...@pocket.com]
>> Sent: Friday, July 16, 2010 5:25 AM
>> To: Michael Dykman; mysql
>> Subject: RE: Why is MySQL always linked to Php?
>&g
> -Original Message-
> From: Jay Blanchard [mailto:jblanch...@pocket.com]
> Sent: Friday, July 16, 2010 5:25 AM
> To: Michael Dykman; mysql
> Subject: RE: Why is MySQL always linked to Php?
>
> [snip]
> PHP applications are, for the most part, not that ambitious
&
[snip]
PHP applications are, for the most part, not that ambitious
and mysql is simply the most accessible database with the best
developed API.
[/snip]
I know that you said "for the most part" and you are absolutely correct.
I just want to point out that there are many corporations relying on PHP
On Thu, Jul 15, 2010 at 7:00 AM, alba.albetti wrote:
> Browsing the Web I've seen that usually companies look for developers working
> on MySQL and Php. Why are the two things linked? I mean I've not found any
> requests for just a MySQL developer or DBA (as for example it happens for
> Oracle)
It's not so much that MySQL goes with PHP as much as PHP goes with
MySQL. PHP applications are, for the most part, not that ambitious
and mysql is simply the most accessible database with the best
developed API.
I have developed applications using MySQL as a back end under a huge
number of enviro
> -Original Message-
> From: alba.albetti [mailto:alba.albe...@libero.it]
> Sent: Thursday, July 15, 2010 7:00 AM
> To: mysql
> Subject: Why is MySQL always linked to Php?
>
> Browsing the Web I've seen that usually companies look for
> developers working on MySQL and Php. Why are the
HIstorical convinience:
A certification program for oracle or db2 requires a lot of money and time.
The facilities oracle and db2 can offer to the dba includes things that the
S.O should to. Exaple: raw spaces and table spaces, hot copy, replication,
etc...
Many of this "facilities" used to be pr
MySQL and PHP go together very well in the web development world. Almost
all of PHP websites use MySQL as their database storage engine, as almost
all hosting companies have installed PHP and MySQL on their servers.
Maybe the jobs you're looking at, are for programmers/developers, who can
take ca
At 09:00 AM 7/15/2010, alba\.albetti wrote:
Browsing the Web I've seen that usually companies look for developers
working on MySQL and Php. Why are the two things linked? I mean I've not
found any requests for just a MySQL developer or DBA (as for example it
happens for Oracle), but it's always
On Monday, July 05, 2010 01:17:57 pm burhan.kha...@gmail.com wrote:
> Michael:
>
> It could be that MySQL is only listening on localhost (127.0.0.1) and not
> your net IP. Check your network settings in your server config.
> Alternately, you can also do a
>
> netstat -anp | grep mysql
>
> As r
BlackBerry® smartphone from Wataniya Telecom
-Original Message-
From: Michael Satterwhite
Date: Mon, 5 Jul 2010 10:04:22
To: Martin Clarke
Cc:
Subject: Re: Why is Host option Failing?
On Monday, July 05, 2010 08:26:03 am you wrote:
> Hi,
>
> dig should be in /usr/bin but its possible
On Monday, July 05, 2010 10:46:48 am Bob Cole wrote:
>
> The remote computer let me into mysql and I typed:
> mysql> use mysql
> mysql> select host, user, Password, Select_priv from user;
> +--+--+---+
> -+
>
> | host
On Jul 5, 2010, at 10:04 AM, Michael Satterwhite wrote:
>> [...snip...]
>> On 5 July 2010 03:35, Michael Satterwhite wrote:
>>> On Sunday, July 04, 2010 06:36:00 pm you wrote:
>>> [...snip...]
>>> I still can't connect via
>>> mysql -h photon -u michael -p??
On my home computer I enter
On Monday, July 05, 2010 08:26:03 am you wrote:
> Hi,
>
> dig should be in /usr/bin but its possible it isn't installed
> I'm not sure about PcLinuxOS but it's in the dnsutils package on
> debian/Ubuntu.
As you said earlier, it's not necessary to use dig to check the ip address.
Ping does the jo
On Sunday, July 04, 2010 06:36:00 pm you wrote:
> What user are you at the time you are running these tests. Would I be
> correct in guessing 'root'?
>
> The reason localhost works is because, in some distros, root is
> enabled localhost with no password .. which is dangerous enough..
> granting
What user are you at the time you are running these tests. Would I be
correct in guessing 'root'?
The reason localhost works is because, in some distros, root is
enabled localhost with no password .. which is dangerous enough..
granting root@'%" would be an invitation to disaster..
>From that sa
you want to select all rows from the table?
===> YES
you want to select all rows from the table
On Thu, Jun 17, 2010 at 2:05 PM, hewei wrote:
> 1.How many records are there in this table.
> ==>6000 rows.
>
> 2.What is the select statement ur running.
> ==>
> ---
>
> I need to select the table 'table_code' per minute,and
1.How many records are there in this table.
==>6000 rows.
2.What is the select statement ur running.
==>
---
I need to select the table 'table_code' per minute,and the sql is like :
select code from table_code;
---
How many records are there in this table.
What is the select statement ur running.
regards
anandkl
On Thu, Jun 17, 2010 at 10:05 AM, hewei wrote:
> now , I need to select a table per minute.
> 1.
> the table struture:
> -
> CREATE
Hi,
On Tue, Jun 8, 2010 at 12:44 AM, Warren Young wrote:
> The Unicode consortium has stated that Unicode will
> never require more than 21 bits per character[*], and 24 bits is the next
> even multiple of 8 up from that.
Maybe off topic, but just curious...If 3 bytes is enough for all
Unicode
1 - 100 of 698 matches
Mail list logo
