Hopeffully this will be the last question in this series. :)
I want to copy a database from my PC to my Apple laptop. I installed MySQL's
GUI Tools on both computers, created a file named Backup.mpb on my PC, then put
a copy of it on my Mac. Now I'm trying to figure out how to get Backup.mbp
Date: Mon, 02 Oct 2006 13:22:37 -0400
To: mysql@lists.mysql.com
From: Michael Gargiullo [EMAIL PROTECTED]
Subject: RE: Partition Help
Message-id: [EMAIL PROTECTED]
snip/
Daily partitions are created then sub partitioned across 6 data disks
and 6 index disks.
We attempted to build a new
I'm just curious as to which would have better performance for my needs.
backend is a MSSQL server and I want to replicate it into a MySQL
Frontend for user accesses.
replication would be done via mysqlimport/load data infile. I'm
thinking of doing the inserts something like ever 5 seconds or
At 15:01 -0700 7/10/06, David Blomstrom wrote:
Thanks. Is this something I can do through phpMyAdmin?
Yes! Easy:
First, create the database - just the database, no tables or anything
- on the Mac.
Next, go to the database on the PC in phpMyAdmin and without
selecting a table in the
At 17:37 -0700 7/10/06, Cabbar Duzayak wrote:
I am using mysql_pconnect from PHP to connect to our mysql server.
...
Is there a way to configure mysql so that it will kill a process after
a certain period of idle time, just like Apache does?
I may be barking up the wrong tree here, but as
I am trying to find out the difference between the Pro and community
editions of MySQL. If I want to support GPL applications I can install
the community ed. If later want to support a non GPL application do I
need to install anything different.
I have found lots of web pages but they
Здравствуйте, Экономиcт.
Вы писали 8 октября 2006 г., 5:37:00:
АНАЛИЗ ВЗАИМОСВЯЗИ РАСХОДОВ, ОБЪЕМА ДЕЯТЕЛЬНОСТИ И ПРИБЫЛИ (CVP-АНАЛИЗ).
АНАЛИЗ РЕЛЕВАНТНОЙ ИНФОРМАЦИИ ДЛЯ ПРИНЯТИЯ УПРАВЛЕНЧЕСКИХ РЕШЕНИЙ.
ЦЕЛЕВОЕ ПЛАНИРОВАНИЕ ПРИБЫЛИ.
Тренинг • 13 октября • 2006 г.
г. Kиeв • ул.
Hello-
I am running MySQL 5.0 on Windows XP hitting it from Python (2.4) routines.
I have an id column (auto increment, primary key) on every table that I use
to join other tables. I use stored procedures to insert new records into
each table and would like to know how to return the id value of
Let's suppose you have a table `t` with these columns:
id - auto increment, primary key, not null
a
b
c
N
If you do any of these:
INSERT INTO `t` (a, b, c ..., K) VALUES(va, vab, vc, ... vK);
INSERT INTO `t` (id, a, b, c ..., K) VALUES(0, va, vab, vc, ... vK);
INSERT INTO `t` (id, a, b, c
OK, now I get it. I'll give that a try. Thanks for the tip about the OmniWeb
browser, too.
- Original Message
From: Chris Sansom [EMAIL PROTECTED]
To: David Blomstrom [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Sunday, October 8, 2006 1:51:33 AM
Subject: Re: Moving Database from PC
Friends,
I am developing a database for accounting software. I have one problem
regarding calculation of balances on daily basis for all ledgers. I am using
Access 2003 as frontend. While designing I found that maintaining of daily
balances is impossible to client's requirements. But as the
Hi, I am certain this is possible with a single query, but I have had
not joy looking on google or using trial and error in MySQL...
Table1: id, name
Table2: id,member1,member2
In Table2 the member1 and member2 are the ID's from Table1
Table1:
1, Dave
2, Bob
3, Simon
Table2:
1,1,2
2,2,3
On 10/8/06, Critters [EMAIL PROTECTED] wrote:
Hi, I am certain this is possible with a single query, but I have had
not joy looking on google or using trial and error in MySQL...
Table1: id, name
Table2: id,member1,member2
In Table2 the member1 and member2 are the ID's from Table1
Table1:
1,
Hi,
We have a mySQL database running version 3.23.58 on a linux machine.
This database is accessed from both a Windows IIS web server and a linuz zeus
web server. On the linux server I'm not sure of what driver etc is installed,
however the access time to save a record is far quicker than
Hi,
How do i dreate a table, let's say:
CREATE TABLE wl_articles(wl_articles_id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY, title TEXT NOT NULL,
main TEXT NOT NULL, extended TEXT NOT NULL, permalink
VARCHAR(255) NOT NULL, date DATE NOT NULL, ip VARCHAR(15), user_agent
VARCHAR(50), status
At 22:11 +0100 10/8/06, Deckard wrote:
Hi,
How do i dreate a table, let's say:
CREATE TABLE wl_articles(wl_articles_id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY, title TEXT NOT NULL,
main TEXT NOT NULL, extended TEXT NOT NULL, permalink
VARCHAR(255) NOT NULL, date DATE NOT NULL, ip
Hi,
Ok, naow i have this:
CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT, name
VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(32)
NOT NULL, PRIMARY KEY (wl_user_id, name, email, password)) TYPE=MyISAM;
and it lets repeated rows.
How can i avoid the repeates
At 22:21 +0100 10/8/06, Deckard wrote:
Hi,
Ok, naow i have this:
CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT, name
VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(32)
NOT NULL, PRIMARY KEY (wl_user_id, name, email, password)) TYPE=MyISAM;
and it lets
Hi,
Yes, it still allows duplicate (equal) rows to be inserted :(
Best Regards,
Deckard
Paul DuBois wrote:
At 22:21 +0100 10/8/06, Deckard wrote:
Hi,
Ok, naow i have this:
CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT, name
VARCHAR(255) NOT NULL, email VARCHAR(50) NOT
At 01:56 PM 10/8/2006, Neil Tompkins wrote:
Hi,
We have a mySQL database running version 3.23.58 on a linux machine.
This database is accessed from both a Windows IIS web server and a linuz
zeus web server. On the linux server I'm not sure of what driver etc is
installed, however the access
David Blomstrom wrote:
Hopeffully this will be the last question in this series. :)
I want to copy a database from my PC to my Apple laptop. I installed MySQL's
GUI Tools on both computers, created a file named Backup.mpb on my PC, then put
a copy of it on my Mac. Now I'm trying to figure out
Hello everybody, I need a little tip to do this: in postgresql we can
create sequence numbers and them assign sequence numbers from several
others tables make a reference to this sequence number using nextval.
How can I do this in mysql ?
Thanks, Alexandre
On Monday 09 October 2006 09:39, Alexandre Gonçalves Jacarandá wrote:
Hello everybody, I need a little tip to do this: in postgresql we can
create sequence numbers and them assign sequence numbers from several
others tables make a reference to this sequence number using nextval.
How can I do
Is your MSSQL data structure contain such foreign key?
If yes, my isam is not suitable for you
Others... for overall, i prefer innodb :)
On 10/8/06, Ow Mun Heng [EMAIL PROTECTED] wrote:
I'm just curious as to which would have better performance for my needs.
backend is a MSSQL server and I
On Mon, 2006-10-09 at 11:42 +0700, Ady Wicaksono wrote:
Is your MSSQL data structure contain such foreign key?
If yes, my isam is not suitable for you
Actually, you know what? I don't really know.
How does one go about checking?
Others... for overall, i prefer innodb :)
I know it's
25 matches
Mail list logo