--
*From:* Johnny Withers joh...@pixelated.net
*To:* Neil Tompkins neil.tompk...@googlemail.com
*Cc:* [MySQL] mysql@lists.mysql.com
*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
change
that value in both server and client
--
*From:* Johnny Withers joh...@pixelated.net
*To:* Neil Tompkins neil.tompk...@googlemail.com
*Cc:* [MySQL] mysql@lists.mysql.com
*Sent:* Monday, October 10, 2011 4:13 PM
*Subject:* Re: Fwd: Large insert query gives MySQL
:* [MySQL] mysql@lists.mysql.com
*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 neil.tompk...@googlemail.com
wrote:
As per the subject we've a large insert query
:* Re: Fwd: Large insert query gives MySQL server gone away
Max packet size?
On Oct 10, 2011 6:12 PM, Neil Tompkins neil.tompk...@googlemail.com
mailto:neil.tompk...@googlemail.com
wrote:
As per the subject we've a large insert query that gives up
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
Max packet size?
On Oct 10, 2011 6:12 PM, Neil Tompkins neil.tompk...@googlemail.com
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
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 neil.tompk...@googlemail.com
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
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
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', '25',
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 [EMAIL
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 quotes. It would
:
- Original Message - From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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,department,subject,body
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
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
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 run, it keeps compaining
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
Many Many wrong SQL syntax error check your symbol (') becareful it 'very
important .
You can do that.
Cheer!!
From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it keeps
You can use backticks ( ` ) to escape the names:
INSERT INTO `tickets` ( `id` , `from` , `departement` .
hth,
melanie
From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it keeps
- Original Message -
From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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,department
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
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
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,
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.
-
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 wrote:
Could somebody please enlighten me as to why it takes nearly 2
hours
-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 column (int has
support for
up to 2.1 Billion records
]; '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 31, 2003 12:05 PM
To: 'Ulterior'; [EMAIL PROTECTED]
Subject: RE: Insert query
Hi,
I
-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 field)
Ulterior
Don't use varchar unless
-
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)
Ulterior
Don't use varchar unless you absolutely have to, that should
, 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
sow what would you suggest, Jerry?
( I need a very FAST search
: 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
efficient for your data type). I don't think the varchar will cause much
of
a problem
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,
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 table:
CREATE TABLE FTPFILE (
ID int(11
So what would be an alternative to varchar? text? but then how mysql will
index such table?
text is a blob record.
Ulterior
- Original Message -
From: Jerry [EMAIL PROTECTED]
To: Ulterior [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, May 31, 2003 1:19 PM
Subject: Re: Insert query
, 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) DEFAULT '0' NOT NULL,
FILENAME varchar(254) DEFAULT 'Not defined' NOT NULL,
FILEPATH varchar(254) DEFAULT 'Not defined' NOT NULL
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]
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
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)
* 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.
URL: http://www.mysql.com/doc/en
,
--
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://www.mysql.com/manual.php (the manual
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 space removal
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, trailing spaces
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.IDRefs |
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 INSERT query causing MySQL to crash? The table it
uses is the one that keeps track
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 and their shopping bag (online web
JP ordering facility).
JP There was plenty of disk space on the server, Solaris 2.7, using mysql
JP 3.23.51.
MySQL server always
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 few days
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'. (errno: 13)
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: cannot
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
When
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, you
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: 144)
$
$ 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.TMD' |
53 matches
Mail list logo