On Mon, 2006-10-09 at 13:02 +0700, Ady Wicaksono wrote:
> On 10/9/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
> > 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,
Hi,
The difference is noticeable (sometimes 15 seconds), as it is being performed
on a webpage. The slow server is running at 100mb and ping times to the
database server are 1ms or less.
Could the problem with be IIS ?
Thanks
Neil
> Date: Sun, 8 Oct 2006 17:17:07 -0500> To: mysql@list
On 10/9/06, Ow Mun Heng <[EMAIL PROTECTED]> wrote:
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?
Dump it
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 t
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 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 d
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
___
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
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 t
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(
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 repeat
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 ro
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 VARCH
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 IN
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 t
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
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
3
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 soluti
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 P
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 .
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 t
Здравствуйте, Экономиcт.
Вы писали 8 октября 2006 г., 5:37:00:
>> АНАЛИЗ ВЗАИМОСВЯЗИ РАСХОДОВ, ОБЪЕМА ДЕЯТЕЛЬНОСТИ И ПРИБЫЛИ (CVP-АНАЛИЗ).
>> АНАЛИЗ РЕЛЕВАНТНОЙ ИНФОРМАЦИИ ДЛЯ ПРИНЯТИЯ УПРАВЛЕНЧЕСКИХ РЕШЕНИЙ.
>> ЦЕЛЕВОЕ ПЛАНИРОВАНИЕ ПРИБЫЛИ.
>> Тренинг • 13 октября • 2006 г.
>> г. Kиeв • ул
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 don't
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
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 sidebar
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 s
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]>
Daily partitions are created then sub partitioned across 6 data disks
and 6 index disks.
We attempted to build a new table
27 matches
Mail list logo
