l machine)
snapshot, and revert to that after the tests. Filesystem snapshots will require
your database to be stopped and started, though.
/Johan
- Original Message -
From: "Lars Nielsen"
To: "MySql"
Sent: Tuesday, 23 January, 2018 23:19:29
Subject: Re: Examples of
Kind Regards / Med venlig hilsen
Lars Nielsen
> - Original Message -
>> From: "Lars Nielsen"
>> To: "MySql"
>> Sent: Tuesday, 23 January, 2018 23:19:29
>> Subject: Re: Examples of savepoints and transactions
>
>>> D
em snapshots will require
your database to be stopped and started, though.
/Johan
- Original Message -
> From: "Lars Nielsen"
> To: "MySql"
> Sent: Tuesday, 23 January, 2018 23:19:29
> Subject: Re: Examples of savepoints and transactions
> Den 22-01
for rolling back test data is to
use savepoints and rollback. I think it is hard to find examples of
this scenario. Are there some good guides or tutorials out there
somewhere? Any suggestions are welcome.
Best regards
Lars Nielsen
Can you mock up an example (a simple text walkthrough) of how
and
rollback. I think it is hard to find examples of this scenario. Are there some
good guides or tutorials out there somewhere? Any suggestions are welcome.
Best regards
Lars Nielsen
Can you mock up an example (a simple text walkthrough) of how you think
a savepoint should work with what you
Hi,
I have a system that uses begin and commit transactions. It works like a dream!
;)
Now I want to test it by creating test data. This how ever cannot be rolled
back. I think the solution for rolling back test data is to use savepoints and
rollback. I think it is hard to find examples of this
up to you - will depend on how well you and the
system you are building will tolerate machines going belly up due to
hardware failure.
Dan
On 4/26/07, lightbulb432 <[EMAIL PROTECTED]> wrote:
What exactly are examples of "commodity servers"? I know what
characteristics
they
What exactly are examples of “commodity servers”? I know what characteristics
they have, but could somebody point out several examples that’d be used in a
MySQL scale-out? e.g. What do you use?
Also, would these servers be 1U or other configurations that take up very
little room in a rack
Hi
I have bought the MySQL certification study guide (v 5.0) and am almost
ready for the exams, does anyone know if the questions in the self study
guide are very similar to the ones that you get in the exam? and is
there anywhere else that i can get more questions like this for practice
pur
Hi all,
Willing to test an upgrading path from 4.0 to 4.1 database of MySQL.
Could someone provide a link or some slice of unload from a 4.0 with
encodings different from "latin1" ?
Thanks in advance,
Francesco R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Hello.
Among links from the manual mentioned in the other messages see these as
well:
http://www.planetmysql.org/
http://dev.mysql.com/tech-resources/articles/mysql-triggers.html
Carlos J Souza <[EMAIL PROTECTED]> wrote:
> Hello For All
>
> I need a pra
Carlos,
I need a pratic examples of Triggers in Mysql 5.x
There are examples at
http://dev.mysql.com/doc/mysql/en/create-trigger.html and
http://dev.mysql.com/doc/mysql/en/using-triggers.html.
PB
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338
Hello
CJS> I need a pratic examples of Triggers in Mysql 5.x
Chapter 20. Triggers
http://dev.mysql.com/doc/mysql/en/triggers.html
Sincerely,
Michael,
http://xoib.com/ http://3d2f.com/
http://qaix.com/ http://ryxi.com/
http://gyxe.com/ http://gyxu.com/
http://xywe.com/ http://xyqe.
Hello For All
I need a pratic examples of Triggers in Mysql 5.x
Regards For all
Carlos Souza
From Brazil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have arranged some MySQL C API examples at
http://www.geocities.com/jahan.geo/mysql_c_by_example.html
Comments/ Suggestion welcome.
--
Aftab Jahan Subedar
CEO/Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
North Jatrabari
Dhaka 1204
Bangladesh
http
"Carlos J Souza" <[EMAIL PROTECTED]> wrote:
> Hello ALL,
>
> I need a examples of stored procedures and triggers in mysql 5.0.
>
> Please send me all sintaxes of this
>
Triggers are not supported in v5.0.
Example of stored procedure you can find in the manua
Hello ALL,
I need a examples of stored procedures and triggers in mysql 5.0.
Please send me all sintaxes of this
regards
Carlos J Souza
[EMAIL PROTECTED]
2004-05-31
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi Chris,
> Hmm
>
> The question is, does MySQL's optimiser do enough planing to result in a
> tree of any non-trivial interest?
I don't know - apparently, you think it doesn't?
> I love MySQL as much as the next geek with a significant other that
> loves dolphins, but I'm not sure that MySQ
Hmm
The question is, does MySQL's optimiser do enough planing to result in a
tree of any non-trivial interest?
I love MySQL as much as the next geek with a significant other that
loves dolphins, but I'm not sure that MySQL 4.0 would provide a lot of
data for funky tree-drawing (MS SQL tool
Hi,
I was wondering if there's a neat way to get the "explain" output
in a tree-like structure so it can be visualized in an easy way.
Is it possible to get it into a tree-structure at all?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
I am designing an web based application using MySQL and Perl. Part of
the requirements include a somewhat complex scheduling module, which
must accommodate scheduling multiple human and physical resources across
multiple facilities. For example, medical patients will be scheduled
for one or more
Ive seen plenty examples in books but are there any
working MySQL examples someone can use immediately..Anything anywhere?
Thank You,
Martin
- Original Message -
From: "Marko Hrastovec" <[EMAIL PROTECTED]>
To: "'gerald_clark'" <[EMAIL PROTECTED]
web.mysql.com (8.11.6/8.11.6) id
h1LJVhi24085; Fri, 21 Feb 2003 20:31:43 +0100
Date: Fri, 21 Feb 2003 20:31:43 +0100
Message-Id: <[EMAIL PROTECTED]>
From: [EMAIL PROTECTED]
To: Michael T. Babcock <[EMAIL PROTECTED]>
Subject: Re: Re: Examples needed of MYSQl/PHP update, delete scripts and
rele
t; <[EMAIL PROTECTED]>
To: "Scott" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 11:46 AM
Subject: Re: Examples needed of MYSQl/PHP update, delete scripts and
relevant forms
> Hi Scott,
>
> Can you please explicitly state what you want to
Email:[EMAIL PROTECTED]
Web :http://www.cfi.co.ug
On Fri, 21 Feb 2003, Scott wrote:
> I am looking for a set of examples of the relevant form pages and the php
> backends that connect to eitehr a YSQL or MSSQl database where the user can
> select certain records and then delete or update t
I am looking for a set of examples of the relevant form pages and the php
backends that connect to eitehr a YSQL or MSSQl database where the user can
select certain records and then delete or update them. I ma having a
nightmare designing one and examples always help me.
Does anyone know of any
On Wed, Jan 29, 2003 at 09:22:50AM -0500, Bill Lovett wrote:
> I was reading about user defined functions, and although they sound
> interesting, I can't find many examples of their use. If anyone is using
> them, what are you using them for? Are they a way to manipulate data
> go
I was reading about user defined functions, and although they sound
interesting, I can't find many examples of their use. If anyone is using
them, what are you using them for? Are they a way to manipulate data
going into a record, or a way to run pre-defined queries?
> thanks
>
>
>
> [EMAIL PROTECTED] wrote:
>
> > corereader will help you do a point&click join of up
> > to four tables.
> >
> > you can operate corereader without it, but reading
> > the documentation is strongly recommended.
> >
IL PROTECTED] wrote:
>
> > corereader will help you do a point&click join of up
> > to four tables.
> >
> > you can operate corereader without it, but reading
> > the documentation is strongly recommended.
> >
> >
> >
> >>Is there
* Michael T. Babcock
> Its well appreciated to see examples of what works and what doesn't too;
> its nice to know how to get one's queries in an order that makes the
> MySQL optimizer's life easier. I'm trying to decide if there's some
> logical way to info
Josh Trutwin wrote:
>The first query averages about 0.085 seconds from the mysql prompt, the
>second about 0.075 seconds and the 3rd 0.065 seconds.
>
>Thanks for some great advice, this has been bugging me for a while!
>
>
Its well appreciated to see examples of what works an
rly part of the front
end. Instead consider intelligent multi-table queries that retrieve for
example "Vancouver, BC, Canada" and "Vancouver, WA, USA". This makes your
front end smarter and your back end more resilient.
Examples of this are abundant. A front end that permits you
eader without it, but reading
> the documentation is strongly recommended.
>
>
>
>>Is there a document that compiles examples on different ways of joining
>>two or more tables? I found a few on
>>http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
Here is the query that I had in a PhP script that joins a bunch of
tables (I'll try to make this look readable). If you're curious, it's for
a motorcross site (www.springcreekmx.com):
SELECT standings.rank, race.race_date, class.class_name,
racer.racer_name, cycle.cycle_desc, race_event.racer_
) ...
Odd, the example I typed was from a working, albeit slow example. Maybe
that's why the performance of that query is so dang slow.
Thanks for the examples, this is great stuff for my archives. Looks like
I have some work to do...
Josh
> SELECT PhoneNumbers.
age -
From: "Josh Trutwin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 3:57 PM
Subject: Re: Is there Examples and Documents on joining tables?
>
> > Is there a document that compiles examples on different ways of joining
> > two
Josh Trutwin wrote:
>>SELECT table1.bunch, table2.of, table3.stuff FROM table1
>> INNER JOIN table2 ON table2.some_id
>> INNER JOIN table3 ON table3.some_id
>>WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id;
>>
>
>
Your where is sort of in the wrong place ...
SEL
clare within it).
Then you can inspect the code it writes and tweak it to suit using EXPLAIN.
hth,
Arthur
- Original Message -
From: "damovand" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 12:31 PM
Subject: Is there Exa
corereader will help you do a point&click join of up
to four tables.
you can operate corereader without it, but reading
the documentation is strongly recommended.
> Is there a document that compiles examples on different ways of joining
> two or more tables? I found a few
tinships that you declare within it).
> Then you can inspect the code it writes and tweak it to suit using EXPLAIN.
>
> hth,
> Arthur
>
> - Original Message -
> From: "damovand" <[EMAIL PROTECTED]>
> To: "mysql" <[EMAIL PROTECTED]>
> Sent:
> Is there a document that compiles examples on different ways of joining
> two or more tables? I found a few on
> http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
> than two tables.
>
> Thanks for any suggestions.
I wish there were more examples as
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
than two tables.
Thanks for any suggestions
Hi!!
try this ::
gcc -I/usr/local/mysql/include custom1.cc
-I is used to specify the path of include files
Regards,
Ritu
On Mon, 29 Apr 2002, adelpfe wrote:
> hi every body
> i have installed mysql++ for linux. when i try to compile examples , i
> get this message:
> gcc cu
hi every body
i have installed mysql++ for linux. when i try to compile examples , i
get this message:
gcc custom1.cc
i obtain
...
/usr/local/include/mysql.h :no file or directory with
this name.
should i put some option or what??
help me please
Troy writes:
> Hi all,
> Just wondering if there are any examples on the web that will compile
> using VC++ 5.0 SP3. I have downloaded the MySQL++ 1.7.1 API and cannot get
> the example to compile.
>
> Thanks in advance
>
> Troy
HI!
MySQL++ require
Hi all,
Just wondering if there are any examples on the web that will compile
using VC++ 5.0 SP3. I have downloaded the MySQL++ 1.7.1 API and cannot get
the example to compile.
Thanks in advance
Troy
-
Before posting
Tim Williams writes:
>
> I've downloaded the mysql++ api and I'm trying to compile the examples
> but I keep getting these warnings I don't understand. When I compile ,
> using the Makefile provided I get the following warnings:
> custom1.cc:8:1 : warning: pa
I've downloaded the mysql++ api and I'm trying to compile the examples
but I keep getting these warnings I don't understand. When I compile ,
using the Makefile provided I get the following warnings:
custom1.cc:8:1 : warning: pasting "~" and "stock"
Hi,
I'm working on my first program witk mysql c api.
I meet problem to link c program that use it.
One symbol "compress" cannot be resolved.
Has anybody a sample script that compile and link ?
What are the options to compile and link ?
Thanks a lot.
Bye
Hi Steve,
To achieve mirroring, MySQL can be run in a master/slave replication ring
with two servers (look up replication in the manual). That way you can split
reads and writes over both servers and get better read performance, and also
more resilience.
The way to achieve transparent failove
> Unless you're going to have a LOT of users accessing a HUGE database, the
> system you've outlined below will be overkill (do you have any current usage
> statistics ? Are you using the system (is it an E450 ?) for any other
> applications/processes ?).
It would be, if it was dedicated to
HAHA! You'll be a good example, since I'm pretty
sure you buy data from us... hehe.
FT Interactive Data
> We use MySQL quite a lot and even manage to generate money once in a
> while...
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (40
L PROTECTED]]
>Sent: Saturday, March 31, 2001 1:13 PM
>Cc: [EMAIL PROTECTED]
>Subject: Re: Need examples of companies using mysql
>
>
>I use MySQL for my personal web site, but as the Director of Information
>Systems (I suppose I am one of those higher ups) I can't imagi
quot;Jason Maderios" <[EMAIL PROTECTED]>
To: "'Mike Roberts'" <[EMAIL PROTECTED]>; "Anthony R. J. Ball"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 4:35 PM
Subject: RE: Need examples of companies using mysql
>
ay, March 30, 2001 8:53 PM
Subject: Re: Need examples of companies using mysql
> I read that SGI (sgi.com) uses all kinds of MySQL DBMS's behind the
scenes.
> Presumably, they're running on Irix. ;-)
>
> HTH,
> Jed
>
> On 3/30/01 11:48 AM, you wanted me to know this:
>
Hi
"!Big money" customers in the UK include
British Telcom, Lloyd-TSB Bank andd the Hurst Newspaper Group
At 14:56 30/03/2001 -0500, Anthony R. J. Ball wrote:
>Hehe, yeah, I mentioned slashdot... for some reason,
>they just weren't impressed :)
>
>You know the type... unless they are
> want to know is a few examples of medium to large
> companies using mysql for mission critical stuff.
I too am in a similar situation, needing links to large organisations on
mySQL. This would help me to replace the largest-ever (proposed) deployment
of MSSQL (as per the official rele
How are you supposed to convince people that MySQL is a worthy
DBMS with boring testimonials about millions of dollars worth of dataflow
and incredible fault tolerance?
If you REALLY want to sell MySQL, point them to http://m4m4sex.com/, a web site
that is dedicated to helping men find men for re
Greetings Steve:
At 12:01 AM 3/31/2001 +0100, Steve Allsopp wrote:
>"Dexterus (www.dexterus.com) is a VC-funded company set up to provide
>application services to the banking industry in the City of London. While
>we are still in the pre-launch stages (we launch Tuesday!), we are aiming
>for a
Not sure how much use to you it would be, but my employers, Dexterus Ltd,
trust my judgement enough to have adopted my recommendation to use MySQL
as an "embedded" DBMS in our smallscale PC-based systems. It has been
deployed in a "farm" of PC's running Linux to co-ordinate virus scanning
of emai
If he is talking about the Samples that come with Paul DuBois book MySQL
thay are at:
http://www.mysql.com/Downloads/Contrib/Examples/samp_db.tar.gz
Jason Maderios
-Original Message-
From: Mike Roberts [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 5:21 PM
To: Anthony R. J
of one of the systems)
"Anthony R. J. Ball" wrote:
> Now that our use of MySQL is being questioned (but
> they are pretty much convinced). What the higher-ups
> want to know is a few examples of medium to large
> companies using mysql for mission critical stuff.
>
>
ey are pretty much convinced). What the higher-ups
>want to know is a few examples of medium to large
>companies using mysql for mission critical stuff.
>
> If any one can provide some I would be much appreciated.
>We are a financial company using mysql to back a bunch
>of our ne
Some MySQL Users
http://www.mysql.com/documentation/mysql/bychapter/manual_Users.html#Users
Regards,
Ernesto Vargas
- Original Message -
From: "Anthony R. J. Ball" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 2:48 PM
Subject: Need
om: "Anthony R. J. Ball" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 2:48 PM
Subject: Need examples of companies using mysql
>
> Now that our use of MySQL is being questioned (but
> they are pretty much convinced). What the higher-ups
&g
t;To: [EMAIL PROTECTED]
>Subject: Re: Need examples of companies using mysql
>Date: Fri, 30 Mar 2001 15:14:12 -0500
>
>Greetings:
>
>We Manage Servers (http://www.wemanageservers.com/) - Their ASP-based
>advanced monitoring service utilizes the power of mySQL.
>
>While I don&
Greetings:
We Manage Servers (http://www.wemanageservers.com/) - Their ASP-based
advanced monitoring service utilizes the power of mySQL.
While I don't have the institutions name, I was told by Verio Advanced they
have a financial institution running mySQL.
XOXO Clothes (http://www.xoxo.com/)
I know that www.yahoo.com uses it somewhere... but I can't remember where I read that
(probably on this list a while ago)
- Original Message -
From: "Anthony R. J. Ball" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 30, 2001 12:48 P
On Fri, Mar 30, 2001 at 02:56:53PM -0500, Anthony R. J. Ball wrote:
>
>Hehe, yeah, I mentioned slashdot... for some reason,
> they just weren't impressed :)
>
>You know the type... unless they are a big money
> company, then they can't be doing anything mission critical :)
We use My
Hehe, yeah, I mentioned slashdot... for some reason,
they just weren't impressed :)
You know the type... unless they are a big money
company, then they can't be doing anything mission critical :)
> www.livejournal.com www.slashdot.org www.everything2.com
--
___ __ ____ _ _
www.livejournal.com www.slashdot.org www.everything2.com
At 02:48 PM 3/30/2001 -0500, Anthony R. J. Ball wrote:
> Now that our use of MySQL is being questioned (but
>they are pretty much convinced). What the higher-ups
>want to know is a few examples of medium to large
>companies
e higher-ups
> want to know is a few examples of medium to large
> companies using mysql for mission critical stuff.
>
> If any one can provide some I would be much appreciated.
> We are a financial company using mysql to back a bunch
> of our new fast-cgi stuff that is about to
Now that our use of MySQL is being questioned (but
they are pretty much convinced). What the higher-ups
want to know is a few examples of medium to large
companies using mysql for mission critical stuff.
If any one can provide some I would be much appreciated.
We are a financial company
Hai,
I am using Red Hat Linux 7. From where can I get example programmes of
connectiong to MYSQL using PERL under Linux.
Thankyou
Rajeev Ramanujan
quot;'MySQL List'" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 7:33 PM
Subject: Looking for tutorials/examples of ways of accessing mysql via
apache.
>
> Hi,
>
> I've been struggling over the last couple of weeks to setup
> perl/DBI/apache/mysql/
49 (0) 21 02 / 97 2453
mailto:[EMAIL PROTECTED]
www.vodafone-telecommerce.de
-Ursprüngliche Nachricht-
Von:MacDonell, Dennis [SMTP:[EMAIL PROTECTED]]
Gesendet am:Mittwoch, 31. Januar 2001 01:34
An: 'MySQL List'
Betreff: L
For begining PHP and MySQL this 10-part series is great!
http://www.webmasterbase.com/article.php?aid=228&pid=0
To control your database remotely check out
http://www.phpwizard.net/projects/phpMyAdmin/
It's very easy to use.
Hope this helps!
-Daniel
-
tml, but I understand the basics.
I was wondering if someone out there had some simple scripts/examples that
could take me through the basics of accessing a database located on a unix
machine from PC's running Internet Explorer.
First I would like to just like to get users to fill in a form and the
3 PM
> To: [EMAIL PROTECTED]
> Subject: examples of large mysql databases
>
>
> I have been using mysql for many years and have failry reliable
> web-based applications using tables with 3 million+ records.
>
> I am curious as to other people's experiences with larger a
r updates I haven't done much of that so I cannot comment on the speed.
Michael Thomas
www.abcxyz.com
-Original Message-
From: Brett Paden [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 6:13 PM
To: [EMAIL PROTECTED]
Subject: examples of large mysql databases
I have b
On Fri, Jan 19, 2001 at 08:12:49PM -0600, Brett Paden wrote:
> I am curious as to other people's experiences with larger amounts of
> data, like 5 to 50 million record tables (I am assuming each record
> has dozens of columns of various datatypes).
~35 million records in one table without any tr
I have been using mysql for many years and have failry reliable
web-based applications using tables with 3 million+ records.
I am curious as to other people's experiences with larger amounts of
data, like 5 to 50 million record tables (I am assuming each record
has dozens of columns of various da
I've read the books, searched the archives and experimented for a couple
days. Now I ask you. If it is possible, do you know where there are
any examples of populating a datagrid in VB from MySQL running on RedHat
6.2.
There are no connection problems. I can set up a recordset and popul
84 matches
Mail list logo
