I think you'll find that's BIGINT, max INT is 11
Moon's Father wrote:
The maximum width is int(20).
On Thu, May 22, 2008 at 5:15 PM, Saravanan <[EMAIL PROTECTED]> wrote:
what kind of datatype it is int(50)
parent_id| int(50)
is that big int?
Saravanan
--- On Thu, 5/22/08, Norb
Thanks Mike!
Le 2008-05-22 à 17:13, Mike a écrit :
If your taking a dump of the master open two windows. Don't close
either
In the first lock all tables with FLUSH ALL TABLES WITH READ LOCK; &
master status;
Then in the second window procedure with mysqldump.
The exact syntax was FLUSH
On Fri, May 23, 2008 at 1:35 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>>> SELECT
>>> p1.POPS AS `POPA`,
>>> p2.POPS AS `POPZ`
>>> FROM
>>> circuits
>>> INNER JOIN pops.POPS as p1 WHERE circuits.popID_A =p1.popID
>>> INNER JOIN pops.POPS as p2 WHERE circuits.pop_ID_Z =p2.popID
Wow... I can't be
On Fri, May 23, 2008 at 3:06 PM, <[EMAIL PROTECTED]> wrote:
>
> - Original Message -
> From: "Rob Wultsch" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Cc: "MYSQL General List"
> Sent: Friday, May 23, 2008 11:10:56 AM GMT -08:00 US/Canada Pacific
> Subject: Re: Query Output Issue
>
> On
Moon's Father schrieb:
You can manually restart the slave process.
Sure I can.
But that's not sufficient. For now, I scripted some log watch thing that
re-starts the slave in the particular situation. But this is not good.
On Wed, May 21, 2008 at 9:11 PM, Dominik Klein <[EMAIL PROTECTED]
<
Hi all,
I'm receiving an error when trying to invoke a procedure from a
[EMAIL PROTECTED] which is not the definer. I created the procedure with the
statement 'SQL SECURITY INVOKER' but is still not working. Does anyone
know why? The MySQL version is 5.0.36.
Both users [EMAIL PROTECTED] and
I think you should check the error with perror at first.
On Sat, May 24, 2008 at 12:46 AM, Mike <[EMAIL PROTECTED]> wrote:
> On Fri, May 23, 2008 at 12:08 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> > Hi Mike,
> > Since i have done a fresh backup from master (with master db down), and
> > cop
Didn't you google it ?
On Thu, May 8, 2008 at 1:59 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote:
> Hi All,
> I am getting below error. This is the only table of INNODB ENGINE, the
> default storage engine is MyISAM
>
> mysql> create table tmp_dc as select gid,siteid,has_gy,starts from dc_tc;
> ERRO
Here is my test.
Any way can retrieve the metadata.
On Fri, May 9, 2008 at 10:45 PM, Martijn Tonies <[EMAIL PROTECTED]>
wrote:
>
>
> > SHOW CREATE TABLE ...
>
> Yes, I thought so :-(
>
>
> From a coding point of view, this requires parsing...
>
> Why isn't there anything in "show full columns".
>
- Original Message -
From: "Rob Wultsch" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Cc: "MYSQL General List"
Sent: Friday, May 23, 2008 1:42:07 PM GMT -08:00 US/Canada Pacific
Subject: Re: Query Output Issue
On Fri, May 23, 2008 at 1:35 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>>> SELEC
I would start by understanding MySQL spatial located at
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
FWIWMartin__Disclaimer and
confidentiality noteEverything in this e-mail and any attachments relates to
the official business of Send
If you create all your databases and tables with utf8,then every thing is
fine.
On Mon, Apr 28, 2008 at 1:43 AM, Velen <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm storing some ascii codes in a table. When I do a dump using mysqldump
> from the server and then restoring it on another station, the as
This is a classic error.
You just reconfigurate the parameter master_log_file and master_log_pos
.Good luck.
On Fri, May 23, 2008 at 5:13 AM, Mike <[EMAIL PROTECTED]> wrote:
> On Thu, May 22, 2008 at 10:41 AM, François Beausoleil <
> [EMAIL PROTECTED]>
> wrote:
>
> > Hi all!
> > I must be stupid
You can manually restart the slave process.
On Wed, May 21, 2008 at 9:11 PM, Dominik Klein <[EMAIL PROTECTED]> wrote:
> Hello mysql list
>
> I posted this problem to the list earlier this month:
>
> Error reading packet from server: Out of memory (Needed 6560 bytes) (
> server_errno=5)
>
> I was
The maximum width is int(20).
On Thu, May 22, 2008 at 5:15 PM, Saravanan <[EMAIL PROTECTED]> wrote:
>
> what kind of datatype it is int(50)
>
> parent_id| int(50)
>
> is that big int?
>
> Saravanan
>
> --- On Thu, 5/22/08, Norbert Tretkowski <[EMAIL PROTECTED]> wrote:
>
> > From: Norbert
15 matches
Mail list logo
