hi all
where can i can download full mysql tutorial .
thanks
regards
muzaffar
I'm a SQL novice, and I'v been looking at this, and I know I shouldn't,
but I was 'Thinking';
Why wouldn't you do the following?
SELECT * from HowToExample ORDER BY Ranking;
Just curious,
Michael.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I'm not sure that is true. I haven't seen a case where the
architecture matters. I think the floating-point format is the big
issue; as far as I've seen, even InnoDB stores its data in an
endian-neutral manner.
I am not familiar enough with the SPARC architecture to know whether
it uses IEEE sta
Hi,
On Fri, Feb 13, 2009 at 4:52 PM, PJ wrote:
> I am trying to create a php-mysql page to POST new records to several
> tables from one php page and I have to retrieve records from several
> (like 4 to 8) tables in one query.
> Being quite new to php & mysql, I am wondering what is the best way
It actually depends on your table types. With MyISAM it is no problem,
but with InnoDB you are looking at a dump-and-restore..
Walter
OlinData: Professional services for MySQL
Support * Consulting * Administration
http://www.olindata.com
On Fri, Feb 13, 2009 at 6:23 PM, Kurt Cypher wrote:
> O
>-Original Message-
>From: Martijn Tonies [mailto:m.ton...@upscene.com]
>Sent: Friday, February 13, 2009 4:40 PM
>To: mysql@lists.mysql.com
>Subject: Re: Codd's rule 8 (physical data idependence)
>
>Hi Jerry,
>
*Applications should not be logicaly impaired when the physical
>storage
>
Timothy,
On Fri, Feb 13, 2009 at 4:45 PM, Little, Timothy
wrote:
> Ok, I have a select statement which must return the distinct names,
> sorted by ranking (lowest to highest).
>
> Seems absurdly simple, right, and I'm sure it would be... look at this
> example
>
> CREATE TABLE IF NOT EXISTS HowTo
I am trying to create a php-mysql page to POST new records to several
tables from one php page and I have to retrieve records from several
(like 4 to 8) tables in one query.
Being quite new to php & mysql, I am wondering what is the best way to
go about this. My tables consist of
* Structure
Ok, I have a select statement which must return the distinct names,
sorted by ranking (lowest to highest).
Seems absurdly simple, right, and I'm sure it would be... look at this
example
CREATE TABLE IF NOT EXISTS HowToExample
( Name VARCHAR( 32 ),
Ranking INTEGER )
ENGINE=MyISAM;
IN
Quoting Martijn Tonies out of context,
> A non transactional engine is of near no use.
I wouldn't say that ;-) It's of no use for transactional needs, and
indeed I rarely say it's a good idea to use a nontransactional engine,
but there are very important real-world uses for them.
--
MySQL Gene
Hi Jerry,
*Applications should not be logicaly impaired when the physical storage
or
access ethods change.*
Changing the storage engine for tables, for example from a transactional
to non-transactional engine, changes the database logic.
[JS] Is that really an example of Codd's rule #8? It
I thought this article was really good at explaining the differences of
relational DBs and Key/Value stores and some other models coming down
the pipe (i.e. the new buzzword "Cloud Computing").
http://www.readwriteweb.com/archives/is_the_relational_database_doomed.php
Well, no, it's not d
>-Original Message-
>From: Peter Brawley [mailto:peter.braw...@earthlink.net]
>Sent: Friday, February 13, 2009 3:02 PM
>To: Yusuf Khan
>Cc: mysql@lists.mysql.com
>Subject: Re: Codd's rule 8 (physical data idependence)
>
>>*Applications should not be logicaly impaired when the physical sto
On Fri, Feb 13, 2009 at 3:41 PM, Daevid Vincent wrote:
> ...and on a semi-related topic, I've just learned of this mysql engine:
> http://www.tokutek.com and hadn't heard a peep about it on this list
> before?!
Not even in http://lists.mysql.com/mysql/216200 ?
:-) Baron
--
Baron Schwartz, Dire
I thought this article was really good at explaining the differences of
relational DBs and Key/Value stores and some other models coming down
the pipe (i.e. the new buzzword "Cloud Computing").
http://www.readwriteweb.com/archives/is_the_relational_database_doomed.php
Will mySQL be adaptable to p
-- Forwarded message --
From: Arthur Fuller
Date: Fri, Feb 13, 2009 at 3:36 PM
Subject: Re: Codd's rule 8 (physical data idependence)
To: Yusuf Khan
Sad to say, you cannot casually switch engines and hope that everything
shall continue to work. This is after all the real world,
On Feb 10, 2009, at 11:26 PM, Al wrote:
I know that all of the prgramming interfaces have the ability to
issue a Function Call to get
"error number for the most recently invoked MySQL function"
and
"the error message for the most recently invoked MySQL function"
such as in C using " *m
*Applications should not be logicaly impaired when the physical storage or
access ethods change.*
Changing the storage engine for tables, for example from a transactional
to non-transactional engine, changes the database logic.
PB
Yusuf Khan wrote:
Hello all
Does MySQL 5 conform to Codd's
On Feb 12, 2009, at 6:28 PM, csego...@gmail.com wrote:
Andy, Michael, and Walter - thank you!
Adding a [mysqld_safe] group to my.cnf gets me further but the start
still fails. The good thing is that the failure is no longer due to
the
inability to write the log file. The [mysqld_safe] sect
On Feb 13, 2009, at 8:52 AM, Joerg Bruehe wrote:
Michel,
michel wrote:
From the different documentation I was reading that after going to
the root directory I should execute /.configure; but there is no
configure file in the root source directory, just configure.in
there is a difference
Hello all
Does MySQL 5 conform to Codd's rule 8, i.e. physical data independence,
which says that:
*Applications should not be logicaly impaired when the physical storage or
access ethods change.*
Any help would be greatly appreciated.
Thanks
On Feb 13, 2009, at 11:41 AM, Aaron Blew wrote:
All,
I've currently got a project to migrate a LARGE (3.5TB) MySQL data
set from
a Sun SPARC machine to a Sun x86 machine, both running Solaris 10
(though
obviously one is x86 and the other is SPARC). Is it possible to
simply copy
the data f
All,
I've currently got a project to migrate a LARGE (3.5TB) MySQL data set from
a Sun SPARC machine to a Sun x86 machine, both running Solaris 10 (though
obviously one is x86 and the other is SPARC). Is it possible to simply copy
the data files from one host to the other or is a full mysqldump/im
Michel,
michel wrote:
> From the different documentation I was reading that after going to the root
> directory I should execute /.configure; but there is no configure file in the
> root source directory, just configure.in
there is a difference between
"Installing MySQL from the current deve
>From the different documentation I was reading that after going to the root
>directory I should execute /.configure; but there is no configure file in the
>root source directory, just configure.in
Hello,
On Thu, Feb 12, 2009 at 11:54 PM, Kiran Waje wrote:
> I have two Mysql servers and I want to Read data from one Mysql server to
> another using stored procedure.
>
You may be able to use the Federated engine. Check the output of SHOW ENGINES.
--
Baron Schwartz, Director of Consulting,
Hi Ethan,
On Fri, Feb 13, 2009 at 10:50 AM, Ethan Chang wrote:
> Hi All,
>
> I installed a binary mysql version from
> http://mysql.mirror.kangaroot.net/Downloads/MySQL-5.1/mysql-5.1.31-linux-i686-glibc23.tar.gz
>
> I'm curious if I want to make some further personalized build from source.
> How
Hi All,
I installed a binary mysql version from
http://mysql.mirror.kangaroot.net/Downloads/MySQL-5.1/mysql-5.1.31-linux-i686-glibc23.tar.gz
I'm curious if I want to make some further personalized build from source.
How can I get the existing server's build configure option? So it can serves
as c
28 matches
Mail list logo