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',
You can use the back quote(`) to escape the field name. It's the ~
key on the keyboard.
tickets(`from`,`department`,...
If you type SHOW CREATE TABLE tickets, you'll see mysql escapes all
the field names to avoid reserve word conflicts.
On Nov 29, 2005, at 2:14 PM, Rhino wrote:
- Ori
- 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,department,subject,body,lastac
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 keeps compaining that the
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 keeps compaining that there is a
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 run, it keeps compaining that there i
"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
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
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 help.
>
> Jerry
>
> - Original Message -
> From: "Ulterior" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturd
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 table:
>
> CREATE TABLE FTPFILE (
> ID int
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 are
rem
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 dif
Are you using a field of type CHAR or VARCHAR ?
You should use a TEXT field instead.
According to the documentation (http://www.mysql.com/doc/en/BLOB.html) :
"There is no trailing-space removal for BLOB and TEXT columns when values
are stored, as there is for VARCHAR columns."
Hope this helps,
--
* 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/doc/en/String
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
John,
Wednesday, October 23, 2002, 1:17:54 PM, you wrote:
JP> This morning our MySQL exited for no good reason!
JP> mysql.err:
JP> 021020 17:25:53
JP> 021020 17:
JP> 021022 18:20:16 mysqld ended
JP> mysql.log:
JP> 021022 18:20:09
JP> 243748 Connect mysql_user@localhost on
JP> 243748 Init DB
33 matches
Mail list logo
