in both server and client
> >>
> >> --
> >> *From:* Johnny Withers <mailto:joh...@pixelated.net>>
> >> *To:* Neil Tompkins <mailto:neil.tompk...@googlemail.com>>
> >> *Cc:* [MySQL] mail
> >> *To:* Neil Tompkins
> >> *Cc:* [MySQL]
> >> *Sent:* Monday, October 10, 2011 4:13 PM
> >> *Subject:* Re: Fwd: Large insert query gives MySQL server gone away
> >>
> >> Max packet size?
> >>
> >> On Oct 10, 2011 6:12 PM,
member change
>> that value in both server and client
>>
>> --
>> *From:* Johnny Withers
>> *To:* Neil Tompkins
>> *Cc:* [MySQL]
>> *Sent:* Monday, October 10, 2011 4:13 PM
>> *Subject:* Re: Fwd: Large insert query gives
*From:* Johnny Withers
> *To:* Neil Tompkins
> *Cc:* [MySQL]
> *Sent:* Monday, October 10, 2011 4:13 PM
> *Subject:* Re: Fwd: Large insert query gives MySQL server gone away
>
> Max packet size?
>
> On Oct 10, 2011 6:12 PM, "Neil Tompkins"
> wrote:
>
&
Yeah, I think adjusting max packet size may be helpful, remember change that
value in both server and client
From: Johnny Withers
To: Neil Tompkins
Cc: [MySQL]
Sent: Monday, October 10, 2011 4:13 PM
Subject: Re: Fwd: Large insert query gives MySQL server gone
Max packet size?
On Oct 10, 2011 6:12 PM, "Neil Tompkins"
wrote:
> As per the subject we've a large insert query that gives up the error
MySQL server has gone away when we try to execute it. Any ideas why ?
--
MySQL General Mailing List
For list archives: http://lists.
> As per the subject we've a large insert query that gives up the error MySQL
> server has gone away when we try to execute it. Any ideas why ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
No, i dont see any other effect.
On 8/29/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> Hi Anand,
>
> Is there any other way it effects the queries.
>
> Regards,
> Krishna
>
> On 8/29/07, Ananda Kumar < [EMAIL PROTECTED]> wrote:
> >
> > Its all ways better to use integers without quo
Hi Anand,
Is there any other way it effects the queries.
Regards,
Krishna
On 8/29/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
>
> Its all ways better to use integers without quotes. It would effect
> execution plan of the sql.
>
> regards
> anandkl
>
>
> On 8/29/07, Krishna Chandra Prajapati <[E
Its all ways better to use integers without quotes. It would effect
execution plan of the sql.
regards
anandkl
On 8/29/07, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote:
>
> hi all,
>
> create table stu (name varchar(20), roll int(2), id decimal(2));
>
> insert into stu values ('krishna',
hi all,
create table stu (name varchar(20), roll int(2), id decimal(2));
insert into stu values ('krishna', '25', '25');
insert into stu values ('krishna', 25, 25);
The above two queries are working properly.
my question is whether it is going to impact in future.
Integer and decimal values in q
hino wrote:
- Original Message - From: "Jeff" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets
(id,from,dep
- Original Message -
From: "Jeff" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,de
You can use backticks ( ` ) to escape the names:
INSERT INTO `tickets` ( `id` , `from` , `departement` .
hth,
melanie
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it
Many Many wrong SQL syntax error check your symbol (') becareful it 'very
important .
You can do that.
Cheer!!
From: "Jeff" <[EMAIL PROTECTED]>
To:
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it k
Jeff wrote:
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_timestamp(now()),'"[EMAIL PROTECTED]"
<[EMAIL PROTECTED]>','Medium','Open',unix_timestamp(now())
Nevermind, found that usig `from` works.
Jeff
> -Original Message-
> From: Jeff [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 29, 2005 11:43
> To: mysql@lists.mysql.com
> Subject: Insert query problem
>
>
> All,
>
> I can't get this query to
"Jeff" <[EMAIL PROTECTED]> wrote on 11/29/2005 11:42:34 AM:
> All,
>
> I can't get this query to run, it keeps compaining that there is a
> problem:
>
> The Query:
>
> insert into
> tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
> tus,created,fromname,lastpostname,atta
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_time
Hello.
The INSERT ... VALUES and INSERT ... SET forms of the statement insert rows
based on explicitly specified values. So you can't use select in the value
clause.
Instead you should use insert ... select. By the way: don't forget to
escape single quotes in text which you insert.
See:
GH wrote:
I am trying to insert data in the ProgressNotes Table using the
following query but it does not work. Can someone please assist? Thank
You.
[snip]
'Understandably, the consumers were upset. The Dean (SR) was kind
enough to try and help explain to our members that there was a
communication
In my database I have the following tables:
+-+
| Tables_in_AHRC |
+-+
| Attendance |
| Participants|
| ProgressNotes |
| Sessions|
| Staff |
| StaffAttendance |
+-+
I am trying to insert data in the ProgressNotes Table
It's not the insert that are taking a long time, it's the selects.
Trying running the command with and explain in front of it to see where
you query is bottlenecking. Perhaps you don't have an index on one of
your search fields.
The first query is probably running faster because you have a few
cmt.place=y03m02_Acdt.place
AND y03m02_Acmt.charge_id=y03m02_Acdt.charge_id;
-Original Message-
From: Keith C. Ivey [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 5:54 PM
To: [EMAIL PROTECTED]
Cc: Charles Vos
Subject: Re: Speed Up Insert Query Results
On 26 Jun 2003 at 17:45, Charles Vos w
On 26 Jun 2003 at 17:45, Charles Vos wrote:
> Could somebody please enlighten me as to why it takes nearly 2
> hours to put 8 rows of data into my table?
It's not the INSERT that's taking so long -- it's the SELECT. Try
the SELECT alone, and it will probably take the same amount of time
Hello All,
Could somebody please enlighten me as to why it takes nearly 2 hours to put 8 rows
of data into my table?
The insert commands I use are:
insert into mytab2
select y03m02_Pt.person, y03m02_Acdt.place, y03m02_Acdt.charge_id, y03m02_Acdt.disch,
y03m02_Pt.age, y03m02_Pt.sex, y03m02_Pt
Use 'char' instead of 'varchar' and INDEX the fields that you will be using
in the WHERE clause of your SELECTS.
-Original Message-
From: Ulterior [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 10:35 AM
To: [EMAIL PROTECTED]
Subject: Re: Insert query
sow wh
rew Braithwaite" <[EMAIL PROTECTED]>; "'Ulterior'"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 10:47
Subject: RE: Insert query
> -Original Message-
> From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May
> -Original Message-
> From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 12:05 PM
> To: 'Ulterior'; [EMAIL PROTECTED]
> Subject: RE: Insert query
>
>
> Hi,
>
> I would use mediumint rather than int for the ID co
'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 8:05 PM
Subject: RE: Insert query
> Hi,
>
> I would use mediumint rather than int for the ID column (int has support
for
> up to 2.1 Billion records wheras mediumint is up to 8.3 million - more
: <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 3:49 PM
Subject: RE: Insert query
> > -Original Message-
> > From: Ulterior [mailto:[EMAIL PROTECTED]
> > Sent: Saturday, May 31, 2003 7:35 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Insert query
> >
l.com/doc/en/Insert_speed.html
Cheers,
Andrew
-Original Message-
From: Ulterior [mailto:[EMAIL PROTECTED]
Sent: Saturday 31 May 2003 15:35
To: [EMAIL PROTECTED]
Subject: Re: Insert query
sow what would you suggest, Jerry?
( I need a very FAST search on this table's filename field
> -Original Message-
> From: Ulterior [mailto:[EMAIL PROTECTED]
> Sent: Saturday, May 31, 2003 7:35 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Insert query
>
>
> sow what would you suggest, Jerry?
>
> ( I need a very FAST search on this table's filename
TECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, May 31, 2003 3:13 PM
> Subject: Insert query
>
>
> > Hi,
> >
> > I have a database table:
> >
> > CREATE TABLE FTPFILE (
> > ID int(11) NOT NULL auto_increment,
> > FTPSITEID int(11) D
rday, May 31, 2003 1:19 PM
Subject: Re: Insert query
> Don't use varchar unless you absolutely have to, that should help.
>
> Jerry
>
> - Original Message -
> From: "Ulterior" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday,
Don't use varchar unless you absolutely have to, that should help.
Jerry
- Original Message -
From: "Ulterior" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 3:13 PM
Subject: Insert query
> Hi,
>
> I have a database tabl
Hi,
I have a database table:
CREATE TABLE FTPFILE (
ID int(11) NOT NULL auto_increment,
FTPSITEID int(11) DEFAULT '0' NOT NULL,
FILENAME varchar(254) DEFAULT 'Not defined' NOT NULL,
FILEPATH varchar(254) DEFAULT 'Not defined' NOT NULL,
FILEEXTN varchar(3) DEFAULT '---' NOT NULL,
FILE
e
index.
The query is only one insert query with 18MB of data.
Can somebody suggest me the solution for this?
Thanks in advance,
Ganbold
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Stefan Hinz, iConnect (Berlin) wrote:
Murthy,
how to insert only blank spaces into a field using insert query. Its
getting
trimmed off.
If you are using VARCHAR for this, you're right. It's a documented
behaviour of MySQL ("Values are not padded; instead, trai
Murthy,
> how to insert only blank spaces into a field using insert query. Its
getting
> trimmed off.
If you are using VARCHAR for this, you're right. It's a documented
behaviour of MySQL ("Values are not padded; instead, trailing spaces are
removed when values are stored
this helps,
--
Joseph Bueno
Murthy wrote:
> how to insert only blank spaces into a field using insert query. Its getting
> trimmed off.
>
>
> Regards,
> Murthy
>
-
Before posting, please check:
http://
* Murthy
> how to insert only blank spaces into a field using insert query.
> Its getting trimmed off.
The spaces are automatically trimmed off of CHAR and VARCHAR fields, because
they are normally not wanted. You can use TINYTEXT or TEXT to avoid this
trimming.
http://www.mysql.com/
> sql,query,queries,smallint
how to insert only blank spaces into a field. Its getting trimmed off.
Regards,
Murthy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
how to insert only blank spaces into a field using insert query. Its getting
trimmed off.
Regards,
Murthy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
John,
Wednesday, October 23, 2002, 7:06:57 PM, you wrote:
>> $ perror 144
>> 144 = Table is crashed and last repair failed
>>
>> Your table is corrupted, try to repair it with REPAIR TABLE or
>> myisamchk:
>> http://www.mysql.com/doc/en/Repair.html
JP> Hmm. REPAIR TABLE gives
JP> | mydb
> $ perror 144
> 144 = Table is crashed and last repair failed
>
> Your table is corrupted, try to repair it with REPAIR TABLE or
> myisamchk:
> http://www.mysql.com/doc/en/Repair.html
Hmm. REPAIR TABLE gives
| mydb.IDRefs | repair | error| Can't create new tempfile:
'./mydb/IDRefs.T
John,
Wednesday, October 23, 2002, 5:21:38 PM, you wrote:
JP> PHP starts to output the error "Too many references: cannot splice - error
JP> 144"
JP> When logging into mysql, I get:
JP> "Didn't find any fields in table IDRefs"
JP> started with -A, I get:
JP> "cannot open file: IDRefs.MYD (error:
> Error 144 that the table is crashed and the last repair failed. You should
> run a check and optimize on this table if possible. Error 13 indicates
that
> you do not have permission to access the file. If you are the System
> Administrator you may want to check the file permissions. Otherwise, yo
perror 144
144 = Table crashed and last repair failed
perror 13
Error code 13: Permission denied
It looks to me like mysql does not own all the files, and can't repair
the table.
John P wrote:
Another error!
PHP starts to output the error "Too many references: cannot splice - error
144"
Whe
will want to get in touch with the System Administrator.
I hope this has been helpful.
Victor
-Original Message-
From: John P
To: [EMAIL PROTECTED]
Sent: 10/23/02 9:21 AM
Subject: Re: INSERT query crashes MySQL
Another error!
PHP starts to output the error "Too many references: c
Another error!
PHP starts to output the error "Too many references: cannot splice - error
144"
When logging into mysql, I get:
"Didn't find any fields in table IDRefs"
started with -A, I get:
"cannot open file: IDRefs.MYD (error: 144)"
optimize table IDRefs;
"Can't open file: 'IDRefs.MYD'. (errn
> JP> 021022 18:20:16 mysqld ended
> JP> 243749 Query INSERT INTO IDRefs
> JP> VALUES('5136110c98b89de5d389df0754182ff2','','',NOW(),'Not
available','','')
> MySQL server always crashes on this query? What is the structure of
> the table IDRefs?
Not always, just a few times in the last fe
the contents of this table and used OPTIMIZE and it has worked OK since
JP> then.
JP> However, a similar crash occured on Sunday, but I didn't investigate it
JP> fully. So, why is this INSERT query causing MySQL to crash? The table it
JP> uses is the one that keeps track of users
ng like "Cannot get data of
table structure" - I was in a rush to get things up and running!). I deleted
the contents of this table and used OPTIMIZE and it has worked OK since
then.
However, a similar crash occured on Sunday, but I didn't investigate it
fully. So, why is this INSER
54 matches
Mail list logo