I have discovered that in MySQL client program I can define "definer" and
"sql security". This is the detail.
Thanks everybody.
Best regards,
Antonio.
Hi everybody,
Firstly thanks for your reply.
I'm using MySQL only in one server (I have only one), without replication
and without cluster configuration. I have defined the stored procedure as a
normal user, not as a root. And the call is make as a normal user also.
Occurs with MySQL 5.1.49 on De
>>>> 2013/04/17 14:16 +0200, Antonio Fernández Pérez >>>>
I have a doubt with stored procedures functionality. Is possible that a
stored procedure works with all databases form the server? I have created a
stored procedure on dataBaseA and also works with dataBaseB. Is tha
- Original Message -
> From: "Antonio Fernández Pérez"
> Subject: Doubt with stored procedures
>
> I have a doubt with stored procedures functionality. Is possible that
> a stored procedure works with all databases form the server? I have
> created a store
Hi everybody,
I have a doubt with stored procedures functionality. Is possible that a
stored procedure works with all databases form the server? I have created a
stored procedure on dataBaseA and also works with dataBaseB. Is that
correct? Independently of the user privileges defined.
Thanks
ilto:h...@tbbs.net]
> Sent: Saturday, March 16, 2013 6:23 AM
> To: Reindl Harald
> Cc: mysql@lists.mysql.com
> Subject: Re: a little doubt on text about MySQL
>
> >>>> 2013/03/16 03:44 +0100, Reindl Harald >>>>
> what are you speaking about?
>
> yo
2013/03/16 03:44 +0100, Reindl Harald
what are you speaking about?
you can define it in my.cnf and YOU are responsible for
the configuration as you are also responsible the
develop php code with error_reporting = E_ALL
These SQL-modes that pertain to type-safety are really part
2013/03/15 12:43 -0300, Marcus Vinicius
Does anyone knows the author of this:
http://grimoire.ca/mysql/choose-something-else
Title: "Do Not Pass This Way Again"
Not I
--but, as to automatic type-conversion, I find me in agreement with the author.
When I first began to use MyS
Am 16.03.2013 01:51, schrieb h...@tbbs.net:
> He makes a point that had not come to me, that type-security somewhat depends
> on SQL_MODE, which belongs to the connection. It is, quite rightly, stored in
> saved program code, but not in any table. At least these affect table behavior
what are
Hello all,
Does anyone knows the author of this:
http://grimoire.ca/mysql/choose-something-else
Title: "Do Not Pass This Way Again"
Thanks a lot,
Marcus Vinicius.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
tmare on your hands to
> fix the broken replication.
>
> > -Original Message-
> > From: Stillman, Benjamin [mailto:bstill...@limitedbrands.com]
> > Sent: Monday, September 24, 2012 11:56 AM
> > To: Shawn Green
> > Cc: mysql@lists.mysql.com
> > Sub
; Sent: Monday, September 24, 2012 11:56 AM
> To: Shawn Green
> Cc: mysql@lists.mysql.com
> Subject: Re: Doubt Regd. Circular Replication In Mysql
>
> I stand corrected and apologize. Numerous multi-master setup
> descriptions I've read have said to set this (including the one linked
I stand corrected and apologize. Numerous multi-master setup descriptions I've
read have said to set this (including the one linked in the original question).
However, as you said, the entry in the manual clearly says it defaults to 0.
Learn something new every day. Thanks Shawn.
On Sep 24, 2
Hello Benjamin,
On 9/24/2012 10:52 AM, Stillman, Benjamin wrote:
replicate-same-server-id = 0 keeps MySQL from replicating binary log entries
from itself. For instance, here's a rough overview:
You write to Server A.
Server A writes that to its binary log.
Server B reads Server A's binary log
log
entries with its own server ID.
From: Adarsh Sharma [mailto:eddy.ada...@gmail.com]
Sent: Monday, September 24, 2012 10:39 AM
To: Stillman, Benjamin
Subject: Re: Doubt Regd. Circular Replication In Mysql
Yes I fixed , but i solve the issue by enabling log-slave-updates only
Why we use the be
om: Adarsh Sharma [mailto:eddy.ada...@gmail.com]
Sent: Monday, September 24, 2012 10:23 AM
To: mysql@lists.mysql.com
Subject: Doubt Regd. Circular Replication In Mysql
Hi all,
Today i set up a circular replication between three nodes A,B & C successfully.
I expect whatever writes on A will p
Hi all,
Today i set up a circular replication between three nodes A,B & C
successfully.
I expect whatever writes on A will propagated to B & then Propagated to C
because the structure is like below :-
A -> B - > C -> A
I created a sample table stag in test database in A and insert few records
th
On Thu, June 9, 2011 11:59, Jerry Schwartz wrote:
>
>
>>
>>A single table is
always consistent. Data inconsistency occurs in sets of
>>interrelated tables, in other words, on the database level.
>>
> [JS] Not even a single table is always consistent
(unless there is
> transactions). Consider a
>
>A single table is always consistent. Data inconsistency occurs in sets of
>interrelated tables, in other words, on the database level.
>
[JS] Not even a single table is always consistent (unless there is
transactions). Consider a single transaction that consists of two steps:
1. Delete recor
Hi! Inline, again.
On Jun 9, 2011, at 4:58 AM, Johan De Meersman wrote:
> True, but I have never seen an application that checks for inconsistency in
> it's tables. Making sure all users have stopped using the app ensures no
> in-flight transactions, and then you have a consistent database - s
- Original Message -
> From: "Karen Abgarian"
>
> This however means that the resulting snapshot will be consistent.
> The fact of taking a backup really cannot create more consistency
> than what the application has by design. If the application inserts
> related rows in say two relate
Hello, comments inline. Regards, Karen.
>
>
> I checked up in the mean time, and it does not make a truly consistent backup
> of MyISAM - it locks all tables - yes, ALL tables - and then copies the
> files. Given that MyISAM doesn't support transactions, that means that any
> "transactions" (
- Original Message -
> From: "Adarsh Sharma"
>
> Not getting U'r point marked as bold & Underline
I checked up in the mean time, and it does not make a truly consistent backup
of MyISAM - it locks all tables - yes, ALL tables - and then copies the files.
Given that MyISAM doesn't supp
Johan De Meersman wrote:
- Original Message -
From: "Claudio Nanni"
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
consistent backups of MyISAM ta
- Original Message -
> From: "Claudio Nanni"
>
> I think this is the best option for you:
> http://www.percona.com/docs/wiki/percona-xtrabackup:start
I must say, I still haven't looked very well at xtrabackup. How does it take
consistent backups of MyISAM tables? I didn't think that was
Both MYISAM & Innodb Engines are used.
Thanks
Nilnandan Joshi wrote:
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma
mailto:adarsh.sha...@orkash.com>> wrote:
Dear all,
Is it possible to take backups of a table or complete database
Hi
We use the --single-transaction switch thinking it does less locking or waiting
for a required table lock. You then get a snapshot without stopping.
Subject should have included the word 'hot'? Looking forward to other
suggestions.
Mark
On 2011/06/07 08:00, Adarsh Sharma wrote:
> Dear all,
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma wrote:
> Dear all,
>
> Is it possible to take backups of a table or complete database without
> stopping the application that continuously inserts and select data from the
> tables.
>
> For taking c
Hi Adarsh,
I think this is the best option for you:
http://www.percona.com/docs/wiki/percona-xtrabackup:start
There is also a commercial alternative, InnoBackup, but I imagine you like
it free.
Cheers
Claudio
On Jun 7, 2011 7:59 AM, "Adarsh Sharma" wrote:
> Dear all,
>
> Is it possible to take
Dear all,
Is it possible to take backups of a table or complete database without
stopping the application that continuously inserts and select data from
the tables.
For taking complete backup of a database I follow the below steps :-
1. First stop the application that insert & modifies table
Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
> Sent: Friday, February 11, 2011 12:17 AM
> To: mysql@lists.mysql.com
> Subject: Doubt Regarding Truncate
>
> Dear all,
>
> Today I performed the below commands on a 553 GB InnoDb table .
>
> truncate table page_c
sage-
From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com]
Sent: Friday, February 11, 2011 12:17 AM
To: mysql@lists.mysql.com
Subject: Doubt Regarding Truncate
Dear all,
Today I performed the below commands on a 553 GB InnoDb table .
truncate table page_crawled;
optimize table page_cra
Dear all,
Today I performed the below commands on a 553 GB InnoDb table .
truncate table page_crawled;
optimize table page_crawled;
But I couldn't find the free space available after truncation. The
below structure is same as before truncation
/dev/sda2 29G 9.5G 18G 36%
x27;,'300','11');
>> INSERT INTO `articulo` VALUES ('1-CHA01','KIT CHACARERO AZUL
>> (GDFGO,PORTAF,LLANT-DEL/POST)','0.00','0.00','0.00','0.00','','0.00
>> ','
;,'0.00','0.00','0.00','','0.00
> ','300','14');
> INSERT INTO `articulo` VALUES ('1-P0001','CASCOS DE MOTOS
> HONDA','0.00','0.00','0.00','0.00','','
27;','0.00','300','14');
INSERT INTO `articulo` VALUES ('1-P0001','CASCOS DE MOTOS
HONDA','0.00','0.00','0.00','0.00','','0.00','300','10');
i need like the
Use --skip-extended-insert as another mysqldump option
-Original Message-
From: dr_pompeii [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2008 2:43 PM
To: mysql@lists.mysql.com
Subject: doubt: mysqldump in linux like windows
Hello guys
i have this situation
in widnows with the
7;,'0.00','0.00','0.00','','0.00','300','11'),('1-CHA01','KIT
CHACARERO AZUL
(GDFGO,PORTAF,LLANT-DEL/POST)','0.00','0.00','0.00','0.00','','0.00','
HI
*sql
in datawarehousing*
i was using the ETL tool INFORMATICA - version 6.2 . and i am creating a
TARGET TABLE manually, in oracle database. using the option Targets >
create.
created the table with generation optio
Hi Ricardo,
Ricardo Conrado Serafim wrote:
Hi Group!
I've a doubt about indexes and I hope that you can help me.
If I've a table index with 5 columns (col_1,col_2,col_3,col_4,col_5) and
I do a query where the clause "where" use just col_1, col_2, col_4 and
col_5.
Thi
Hi Group!
I've a doubt about indexes and I hope that you can help me.
If I've a table index with 5 columns (col_1,col_2,col_3,col_4,col_5) and
I do a query where the clause "where" use just col_1, col_2, col_4 and
col_5.
This query will use the index at least with
Ysgrifennodd ViSolve DB Team:
Hi Renish,
If you want to capture the entries which are entered more than once.
Here's the answer for it.
mysql> select * from a;
++
| b |
++
| pen|
| pencil |
| rubber |
| pen|
| paper |
| paper |
++
6 rows in set (0.00 sec
SELECT DISTINCT a,b,c,d,e FROM tbl;
Renish wrote:
How abt to return the distinct rows?
- Original Message - From: "Peter Brawley"
<[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple
How abt to return the distinct rows?
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple doubt
>But if I do like this..
>select dist
Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple doubt
>But if I do like this..
>select distinct store, price from Item
>will both become distinct?
SELECT DISTINCT returns one result row per distinct _result_ row
(which will be the same as 'per distinct table row' only if
Smart. and simple .I should have thought for a while:-(
- Original Message -
From: "ViSolve DB Team" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>; "Hal Wigoda" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 28, 2006 11:58 AM
Subj
D]>
Cc:
Sent: Tuesday, November 28, 2006 9:03 AM
Subject: Re: Simple doubt
Hello all,
I think u guys have mistaken my question,..
The questiion is How will capture the entries which are entered more than
once...
Like
For example
Item table
Mango
Orange
Carrot
Papaya
Mango
Mango
I
Dupes
- Original Message -
From: "Peter Brawley" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple doubt
>But if I do like this..
>select distinct store, price from Item
>wi
om Item
will both become distinct?
How can I make only one distinct ie "store" distinct
regards,
- Original Message - From: "Peter Brawley"
<[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, November 28, 2006 11:18 AM
Sub
Message -
From: "Hal Wigoda" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>
Sent: Tuesday, November 28, 2006 11:11 AM
Subject: Re: Simple doubt
select unique
On Nov 27, 2006, at 8:45 PM, Renish wrote:
Gurus,
How do I go about to selecting an item whic
ECTED]>
Cc:
Sent: Tuesday, November 28, 2006 11:18 AM
Subject: Re: Simple doubt
SELECT DISTINCT ...
Renish wrote:
Gurus,
How do I go about to selecting an item which is repeated more than one in
a field in a table.
For example
Item table
Mango
Orange
Carrot
Papaya
Mango
Mango
SELECT DISTINCT ...
Renish wrote:
Gurus,
How do I go about to selecting an item which is repeated more than one
in a field in a table.
For example
Item table
Mango
Orange
Carrot
Papaya
Mango
Mango
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409
Gurus,
How do I go about to selecting an item which is repeated more than one in a
field in a table.
For example
Item table
Mango
Orange
Carrot
Papaya
Mango
Mango
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
Message -
From: Renish <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Sent: Sunday, November 26, 2006 10:15:43 PM GMT-0500 US/Eastern
Subject: MySql doubt.
Hi Guys,
I have an easy doubt..
Table A consist of field Item and Table B consist of field Price. Table A
consists of Items which
Great Thanks,,
- Original Message -
From: "ViSolve DB Team" <[EMAIL PROTECTED]>
To: "Renish" <[EMAIL PROTECTED]>;
Sent: Monday, November 27, 2006 4:57 PM
Subject: Re: MySql doubt.
Hi Renish,
In case if you dont have the Item field in the Table B.
D]>;
Sent: Monday, November 27, 2006 12:48 PM
Subject: Re: MySql doubt.
Thanks if in case if we dont have the Item field in the Table B. wat to
do..I know the primary key to connect both the tables/
- Original Message -
From: ViSolve DB Team
To: Renish ; mysql@lists.mysql.com
Sent:
Thanks if in case if we dont have the Item field in the Table B. wat to do..I
know the primary key to connect both the tables/
- Original Message -
From: ViSolve DB Team
To: Renish ; mysql@lists.mysql.com
Sent: Monday, November 27, 2006 12:48 PM
Subject: Re: MySql doubt
uot;Renish" <[EMAIL PROTECTED]>
To:
Sent: Monday, November 27, 2006 8:45 AM
Subject: MySql doubt.
> Hi Guys,
>
> I have an easy doubt..
>
> Table A consist of field Item and Table B consist of field Price. Table A
> consists of Items which has price aswell the it
Hi Guys,
I have an easy doubt..
Table A consist of field Item and Table B consist of field Price. Table A
consists of Items which has price aswell the items which doesnt have
price. But In Table B,I have kept only the item which has price . Now, I
want to subtract the total items in
Hi Guys,
I have an easy doubt..
Table A consist of field Item and Table B consist of field Price. Table A
consists of Items which has price aswell the items which doesnt have price.
But In Table B,I have kept only the item which has price . Now, I want to
subtract the total items in Table A
Ratheesh K J wrote:
Hello all,
I have a doubt on Index Merge.
We are currently using MySQL server 4.1.11. As a part of DB management I am
currently doing an analysis on all the Tables.
While looking into the table structures, their columns and Indexes I found that
most of the tables have
Hello all,
I have a doubt on Index Merge.
We are currently using MySQL server 4.1.11. As a part of DB management I am
currently doing an analysis on all the Tables.
While looking into the table structures, their columns and Indexes I found that
most of the tables have an Index on fields that
method of
forcing the output to be in a specific order.
--
Rhino
- Original Message -
From: "subramani" <[EMAIL PROTECTED]>
To:
Sent: Friday, April 07, 2006 10:22 AM
Subject: A doubt in SELECT query
hello all,
In which order the datas are displayed, when the SEL
subramani wrote:
hello all,
In which order the datas are displayed, when the SELECT quey is used ?
Is it random or the order in which the datas are inserted?
-- r.subramani
My log file: http://subramanitce.blogspot.com
Random
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(
hello all,
In which order the datas are displayed, when the SELECT quey is used ?
Is it random or the order in which the datas are inserted?
-- r.subramani
My log file: http://subramanitce.blogspot.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I think this is what you want to do:
SELECT t1.Division,t1.year, t1.units this_year_units, t2.units
last_year_units, case when t2.units is null then t1.units else
(t1.units-t2.units) end as Difference_Units
FROM `narra_table` t1 left join narra_table t2
on (t1.Division=t2.Division) and (t1.Ye
i have to write one query
DivisionUnitsYear
a 200 2004
a 300 2005
b 500 2004
b 800 2005
b 900 2006
c
i have to write one query
DivisionUnitsYear
a 200 2004
a 300 2005
b 500 2004
b 800 2005
b 900 2006
c
Hi Gleb Paharenko,
ThanQ for assistance
--
veerabhadrarao narra,
+91-988-556-5556
I-ONE TECH LABS Pvt Ltd.
HYDERABAD, INDIA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello.
set @s:=0;
select Division, Units, Year from (select v1.Division, [EMAIL PROTECTED] as
Units, v1.Year, @s:=v1.Units from veer v1) as v2;
Veerabhadrarao Narra wrote:
> i have to write one query
>
> DivisionUnitsYear
> ameerpet 200 2004
>
i have to write one query
DivisionUnitsYear
ameerpet 200 2004
ameerpet 300 2005
ameerpet 500 2006
>From these values i want to retreive as like this
DivisionUnitsYear
Eric,
Can you send us the actual show indexes from table and explain output that
isn't shortend?
Thank you for answer my question.
Actually, the real query and tables are much more complex than
the data in the previous message.
A just tryed to optimize the information for you better understan
Can you send us the actual show indexes from table and explain output
that isn't shortend?
Ronan Lucio wrote:
Hello,
I´m using MySQL-4.1.7, and I have a query that seems,
even using where clause, an specific table isn´t being optimized
properly:
I have four tables:
real_state: cod, name, ci
Hello,
I´m using MySQL-4.1.7, and I have a query that seems,
even using where clause, an specific table isn´t being optimized
properly:
I have four tables:
real_state: cod, name, city, ag_cod, sell
agency: cod, name, ag_status
front: cod, rs_cod, ag_cod
photo: cod, rs_cod
These table have the
Ashok Kumar wrote:
Hi friends,
I'm now started to using the Redhat-Linux. Now i want
to start MySQL on Linux. I'm not having much idea
about Linux. I'm new to this. For Linux which MySQL
installation i've to choose from the site. there are
lot of binary distributions, i don't which one is
compat
Hi friends,
I'm now started to using the Redhat-Linux. Now i want
to start MySQL on Linux. I'm not having much idea
about Linux. I'm new to this. For Linux which MySQL
installation i've to choose from the site. there are
lot of binary distributions, i don't which one is
compatible for my OS.
Lin
Shawn,
Thank you very much for your tips.
I´ll do that.
Ronan
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Ronan Lucio" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, January 18, 2005 6:36 PM
Subject: Re: Doubt about Performance
"Ronan Lucio" <[EMAIL
> -Original Message-
> From: Ronan Lucio [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 18, 2005 10:13 AM
> To: mysql@lists.mysql.com
> Subject: Doubt about Performance
>
> Hello,
>
> Trying to keep the database and the application fast, I´d
>
"Ronan Lucio" <[EMAIL PROTECTED]> wrote on 01/18/2005 02:53:39 PM:
> Shawn,
>
> Your tips are realy good but I can´t use cache neither for
> queries nor for pages because our site serves hundreds of
> clients, each one with your own code make a different
> query, returning different rows.
>
> It
Sasha,
> I assume you mean "has serious performance impact" when you say "weight".
If
> this is not what you meant, please correct/clarify.
Yes, you´re right.
>>
>> 1) Is a SELECT DISTINCT over 5,000 records a weight
>> query? (Supposing it has about 20 different option the the
>> DISTIN
"Ronan Lucio" <[EMAIL PROTECTED]> wrote on 01/18/2005 01:13:10 PM:
> Hello,
>
> Trying to keep the database and the application fast,
> I´d like to clearify my mind about it.
>
> 1) Is a SELECT DISTINCT over 5,000 records a weight
> query? (Supposing it has about 20 different option the the
Ronan Lucio wrote:
Hello,
Trying to keep the database and the application fast,
I´d like to clearify my mind about it.
Ronan:
I assume you mean "has serious performance impact" when you say "weight". If
this is not what you meant, please correct/clarify.
1) Is a SELECT DISTINCT over 5,000 records
Greg,
Thank you very much for your help.
> An index the full size of the distinct key is probably very quick
especially
> if it only has 20 distinct values. OTOH, if you already know you have a
> small number of distinct values, could you just store them normalized in a
> different table?
Actua
Hello,
Trying to keep the database and the application fast,
I´d like to clearify my mind about it.
1) Is a SELECT DISTINCT over 5,000 records a weight
query? (Supposing it has about 20 different option the the
DISTINCT key).
2) Is SELECT ORDER BY RAND() over 1,500 records
a weight q
= price.product_id)
WHERE rent_price BETWEEN 300.00 and 500.00
My doubt is if the table product will be optimized.
Will optimization process be done over all rows from the
product table or only the rows related to the price table?
In other words:
If table price has other columns and LEFT JOIN is
Hi,
I use MySql version 4.0.18.
We do a lot of bulk inserts and there is no need for transaction integrity.
Currently the isolation level of the database is REPEATABLE-READ.
Iam planning to change that to READ UNCOMMITTED as I dont have any
transactions.
Will this improve DB performance ?
Is ther
On 27-Apr-2004 Paul DuBois wrote:
> At 13:29 -0400 4/27/04, Keith C. Ivey wrote:
>>On 27 Apr 2004 at 13:59, Ronan Lucio wrote:
>>
>>> OK, I understood it, but I didn´t understand why is there an
>>> option
>>> TINYINT(n)
>>
>>See http://dev.mysql.com/doc/mysql/en/Numeric_types.html
>>
>>| Ano
At 13:29 -0400 4/27/04, Keith C. Ivey wrote:
On 27 Apr 2004 at 13:59, Ronan Lucio wrote:
OK, I understood it, but I didn´t understand why is there an option
TINYINT(n)
See http://dev.mysql.com/doc/mysql/en/Numeric_types.html
| Another extension is supported by MySQL for optionally
| specify
On 27 Apr 2004 at 13:59, Ronan Lucio wrote:
> OK, I understood it, but I didn´t understand why is there an option
> TINYINT(n)
See http://dev.mysql.com/doc/mysql/en/Numeric_types.html
| Another extension is supported by MySQL for optionally
| specifying the display width of an integer value
Paul,
> I don't know what "minor than" means
Sorry by my english.
I´d like to say "less than" (or something like this).
> , but TINYINT is a single-byte
> type. The range for TINYINT is -128 to 127, and the range for
> TINYTINT UNSIGNED in 0 to 255.
OK, I understood it, but I didn´t understand
At 11:53 -0300 4/27/04, Ronan Lucio wrote:
Hi,
If I create a column with the type TINYINT(2) UNSIGNED.
Will the content can have the value minor than 510 (like a number 499),
or will the content can have two values minor than 255 (like 11)?
I don't know what "minor than" means, but TINYINT is a s
Hi,
If I create a column with the type TINYINT(2) UNSIGNED.
Will the content can have the value minor than 510 (like a number 499),
or will the content can have two values minor than 255 (like 11)?
Thanks,
Ronan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
"Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]> wrote:
> Dear Friend
>
> an friend of mine told that the follow line bellow dont work with mysql
> version 4.0.x
>
> * Support for subqueries and derived tables
> This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A
> WHERE C
Dear Friend
an friend of mine told that the follow line bellow dont work with mysql
version 4.0.x
* Support for subqueries and derived tables
This mean query like : SELECT A.* FROM (SELECT * FROM TESTE WHERE X = Y) A
WHERE COL1 = 3
is this true, or mysql version 4.0.x work properly with this
Re
Hi,
I made a table with a primary key,and all
the columns i declared char got converted into
varchar.
plz someone throw a light on it as i had seen somewhere
that using primary key increase search speed and using varchars
decrease so im in confusion. :(
http://www.mysql.com/doc/en/Silent_column_cha
Hi,
I made a table with a primary key,and all
the columns i declared char got converted into
varchar.
plz someone throw a light on it as i had seen somewhere
that using primary key increase search speed and using varchars
decrease so im in confusion. :(
--
On Friday 21 March 2003 08:01, sivakumar wrote:
> Hai, am having the problem in creating CD of my project(Online
> Tutorial).While creating the CD only am having the problem. Actually am
> working in SSH(linux),right.
>
> I have to make a dump of my source code and mysql ..to copy (from server to
>
How are you dumping the database? It doesn't seem like you should have
problems going either direction, especially to a case-insensitive
filesystem.
Copying databases with something like
$ mysqldump | mysql -h
works for me, even if it is fairly slow.
-jeff
(formerly kilpatjr_at_lupus.omrf.ou
Hai, am having the problem in creating CD of my project(Online Tutorial).While
creating the CD only am having the problem. Actually am working in SSH(linux),right.
I have to make a dump of my source code and mysql ..to copy (from server to C:\ of my
PC with windows not case- sensitive, right).
Hai, am having the problem in creating CD of my project(Online Tutorial).While
creating the CD only am having the problem. Actually am working in SSH(linux),right.
I have to make a dump of my source code and mysql ..to copy (from server to C:\ of my
PC with windows not case- sensitive, right).
1 - 100 of 130 matches
Mail list logo