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,
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
- Original Message -
From: Antonio Fernández Pérez antoniofernan...@fabergames.com
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 stored
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 that
correct? Independently
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
...@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?
you can define it in my.cnf and YOU are responsible for the
configuration as you
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 of the _type_:
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 MySQL I was dismayed
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
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
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
that
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 propagated to B
: 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 below parameter :-
replicate-same-server-id = 0
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
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,
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
in the original question). However, as you
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
Subject: Re: Doubt Regd. Circular Replication In Mysql
I stand
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 (that
- Original Message -
From: Karen Abgarian a...@apple.com
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
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 -
snip
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
On Thu, June 9, 2011 11:59, Jerry Schwartz wrote:
snip
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
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
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 adarsh.sha...@orkash.com wrote:
Dear all,
Is
Can you tell us which storage engine you are using?
On Tue, Jun 7, 2011 at 11:30 AM, Adarsh Sharma adarsh.sha...@orkash.comwrote:
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
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,
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
adarsh.sha...@orkash.com mailto:adarsh.sha...@orkash.com wrote:
Dear all,
Is it possible to take backups of a
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
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
Johan De Meersman wrote:
- Original Message -
From: Claudio Nanni claudio.na...@gmail.com
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
- Original Message -
From: Adarsh Sharma adarsh.sha...@orkash.com
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
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_crawled;
But I couldn't find the free space available after truncation. The
below structure is same as before
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
-
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_crawled
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 mysql administrador i make backup
i saw in the x.sql these lines for example
/*!4 ALTER TABLE
--extended-insert--password=XXX --user=root somedb
/home/Someuser/somepath/A.sql
with the same undesired results
how i can resolve this??
thanks in advanced
--
View this message in context:
http://www.nabble.com/doubt%3A-mysqldump-in-linux-like-windows-tp16185833p16185833.html
Sent from the MySQL
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
-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
:[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 mysql administrador i make backup
i saw in the x.sql these lines for example
/*!4
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
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 the col_1 and col_2
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.
This query will use
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]; mysql@lists.mysql.com
Sent: Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple doubt
But if I do like
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
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: Monday, November 27, 2006 12:48 PM
Subject: Re
Great Thanks,,
- Original Message -
From: ViSolve DB Team [EMAIL PROTECTED]
To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com
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.
Try the following
]
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 has price aswell the items which doesnt have price
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:
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:
, 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
--
No virus found in this outgoing
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 which is repeated more than one
in a field
distinct?
How can I make only one distinct ie store distinct
regards,
- Original Message - From: Peter Brawley
[EMAIL PROTECTED]
To: Renish [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 28, 2006 11:18 AM
Subject: Re: Simple doubt
SELECT DISTINCT ...
Renish wrote
Dupes
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: 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
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 want to capture only mango cos
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: mysql@lists.mysql.com
Sent: Tuesday, November 28, 2006 11:58 AM
Subject: Re: Simple doubt
Hi Renish
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 all table
columns are selected
How abt to return the distinct rows?
- Original Message -
From: Peter Brawley [EMAIL PROTECTED]
To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Tuesday, November 28, 2006 11:48 AM
Subject: Re: Simple doubt
But if I do like this..
select distinct store, price from Item
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
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
PROTECTED]
To: mysql@lists.mysql.com
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 items which doesnt have price
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
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
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:
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
method of
forcing the output to be in a specific order.
--
Rhino
- Original Message -
From: subramani [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 SELECT
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
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]
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
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
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
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
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,
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.
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
Shawn,
Thank you very much for your tips.
I´ll do that.
Ronan
- Original Message -
From: [EMAIL PROTECTED]
To: Ronan Lucio [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, January 18, 2005 6:36 PM
Subject: Re: Doubt about Performance
Ronan Lucio [EMAIL PROTECTED] wrote on 01
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
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?
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 a
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
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
DISTINCT key).
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 would be
-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
like to clearify my mind about it.
1
= 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
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
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
| Another extension is
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
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
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 why is
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
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
|
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
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 COL1 = 3
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. :(
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
C:\
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).
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 database | mysql -hremote_server database
works for me, even if it is fairly slow.
-jeff
1 - 100 of 127 matches
Mail list logo