El Viernes, 26 de Agosto de 2005 08:56, Gordon Bruce escribió:
> If you have the 5.0.x version of MySQL then INFROMATION SCHEMA can give
> you what you want. i.e.
>
> SELECT a.*, b.*
> FROM INFORMATION_SCHEMA.COLUMNS AS a
>INNER JOIN _SCHEMA.COLUMNS AS b
>ON (a.column_name
El Viernes, 26 de Agosto de 2005 08:16, Martijn Tonies escribió:
>
> You could check the table DDL.
>
> Or use a third party tool, like Database Workbench, that can do this for
> you and even generator a change script. Check www.upscene.com
>
> With regards,
>
> Martijn Tonies
Hmmm. No L
Hi:
I need to compare the structure of two tables (fields, field types, field
lengths, indices, etc.) to determine if they have the same schema, even if
the fields may be in a different order. Is there a command in mysql that will
do this? This will be used to determine if the tables are basica
Hi:
I would like to use the DALP libraries
(http://solutions.mysql.com/software/?item=145) to access a MySQL server
4.1.10 on Linux, from my PocketPC (iPAQ 3100 WM 2003 SE). I would appreciate
it if somebody could provide me with a minimal sample that would just connect
to a database so I can
El Lun 14 Mar 2005 14:59, Stephen Andert escribió:
> Hi there,
>
> I searched the archives, but didn't find anything helpful.
>
> I am trying to build a fairly simple application for contact
> management. I already have what I want built in MS Access, but I need
> this application to run on Linux.
Using MySQL 4.1.10, SuSE 8.2 Pro, reiser file system.
Hi:
I have been trying to locate a reference which would provide guidelines to
determine if one ibdata should be used, or when to use several (two, three,
etc.), but I can not seem to find anything in the manual. I have tried a
single ibdat
El Mié 02 Mar 2005 16:04, escribió:
> H, sounds like you are trying to mix OLTP and OLAP in one database
> structure. That's a tough one. You want your tables designed to always
> accept data in real time, but once the data is in, it doesn't change
> and you want to query it. Relational vs. Dim
El Mié 02 Mar 2005 11:41, Brent Baisley escribió:
> Coming in late on this thread. The testing on your laptop, are you just
> running the one query or are you somehow emulating the typical load you
> are trying to design for? As you said, you are trying to improve
> concurrency, so you'll need to c
El Mar 01 Mar 2005 18:29, Heikki Tuuri escribió:
> Alfredo,
>
I have changed my my.cnf to try and include the suggestions from the list, as
much as possible and try to run my program again. It now reads like this:
innodb_data_file_path = ibdata1:2G;ibdata2:2G:autoextend
set-variable = innodb_buf
El Mar 01 Mar 2005 17:32, Gary Richardson escribió:
> What have you actually done to 'tune' the server? How are you doing
> the inserts?
>
> InnoDB uses transactions. If you are doing each row as a single
> transaction (the default), it would probably take a lot longer.
>
> I assume you're doing yo
Hi:
I have switched from MyISAM tables to InnoDB, using MySQL 4.1.10 under SuSE
8.2.
My application, an ERP system developed in-house, uses 70 tables, the largest
one holding a little over one million rows. To assist when changing table
structures, we developed a software that creates a new ta
Hi:
I have not been able to find a precompiled version of mysql-query-browser for
SuSE 8.2, either at mysql web site, or using google. Compiling from source
fails because of version differences in libxml-2.0, for instance. Anybody
know of a URL where I can find a version that will work with SuS
Sorry. This should have gone back to the list.
-- Mensaje reenviado --
Subject: Re: MySQL 4.0 and concat
Date: Lun 11 Oct 2004 11:37
From: Alfredo Cole <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
El Lun 11 Oct 2004 08:35, escribió:
> Have you considered NOT comparing
Hi:
I have a problem in that all statements that include concat execute very
slowly. For instance, if I have three fields in string format that represent
a year, month and day, and want to issue a select like:
select * from cxcmanpag where contact
(year,month,day)<=stringYear+stringMonth+stri
Hi:
I'm using MySQL 4.0, and have setup replication with one server and one slave,
both running LM 9.1. My application creates a temporary table on the master,
which is supposed to be deleted when the connection is closed. When that
happens, replication stops with the following message:
ERROR:
of the tables (MyISAM) had a
corrupt index. After fixing it, everything was fine again.
Regards.
--
Alfredo Cole
Grupo ACyC
www.acyc.com - www.clshonduras.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
El Vie 07 May 2004 00:20, escribió:
(...)
>
> My knowledge of OpenMosix is extremely limited. I've not heard of
> anyone successfully using MySQL with OpenMosix for fail-over. That
> doesn't mean it hasn't been done, but it'd be news to me.
>
> I assume you've also asked on the relevant OpenMosix
El Jue 06 May 2004 11:05, escribió:
> On Thu, May 06, 2004 at 06:55:38AM -0600, Alfredo Cole wrote:
> > Hi:
> >
> > I would like to add an identical server to the one I already have: Double
> > Xeon processors, 4 Gb RAM and RAID 5 (Hardware) HD's. I would als
Hi:
I would like to add an identical server to the one I already have: Double Xeon
processors, 4 Gb RAM and RAID 5 (Hardware) HD's. I would also like to cluster
them using OpenMosix, but I'm told that MySQL 4.0 will not take advantage of
the cluster. Is there a way to cluster MySQL so that quer
El Sáb 07 Feb 2004 02:28, escribió:
> Mr. Alfredo
> Pls, will you give the complete structure as 'create query' of your
> database? that will help us to solve your problem.
> Pradap
This is the structure of the table that holds the sequential numbers for
various documents that need them:
CRE
I am using Mandrake 9.1 and MySQL 4.0.11 from the LM CD's.
In my application, I have a table that stores the sequential numbers of
invoices prepared by several stores. Every time a salesman prepares an
invoice for a customer, the system goes to this table, locks it with lock
tables write, read
I'm using mysql 3.23.55 and Linux Mandrake 9.1. I have about 60 users
connecting to mysql using our accounting system. The users get some times a
"Too many connections" error. I have set max_connections at 200, and the
system opens only one connection per user at start up. Can somebody indicate
El Jue 08 Ene 2004 19:56, Paul DuBois escribió:
> At 19:16 -0600 1/8/04, Alfredo Cole wrote:
> >Hi:
> >
(...)
> >The code I use is:
> >
> >select lock
> >
Sorry. It's select get_lock...
> >get code
> >add one to code
> >write code
Hi:
I have an application that is used by around 40 users who need to access a
table, obtain a sequential code, and write it back. I'm using MyISAM tables,
and mysql 3.23 running under LM 9.0.
A couple of times during the day, the users get the same code, and that is
causing us many problems.
El Lunes, 8 de Septiembre de 2003 09:01, Michael Bacarella escribió:
> Names of vendors who are happy to provide servers
> applicable for high load Linux/MySQL. Willing to
> do custom configurations.
>
> Anyone?
>
> --
> Michael Bacarella24/7 phone: 1-646-641-8662
> Netgraft Corpor
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi:
I'm using MySQL 3.2.3.39 for Win98.
Has anybody been able to develop applications using Mingw32 compiler?
If so, where can I get a version of the libmysqlclient library that
will work with this compiler?
Thank you.
- --
Alfredo J. Cole
http
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi:
Using MySQL version 3.23.39-Max, SuSE 7.2
I have two tables, cbtran with 46564 rows and cbma with 4184 rows.
Both tables are indexed.
The following query:
select tr.*,ma.nombre from cbtran as tr, cbma as ma where
tr.empresa='1' and tr.mes='1
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Lun 26 Nov 2001 00:42, escribiste:
> Hola a todos.
>
> Bueno,ya sabemos todos o casi todos que MySQL no tiene integridad
> referencial ni transacciones.Para mantener la integridad
> referencial es necesario hacerlo a mano. Por ahora todo correcto.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Viernes 16 Noviembre 2001 08:23, escribiste:
> Hola a todos.
> Alguien tiene una herramienta para exportar tablas dbf a MySql?
>
> saludos
> Gastón
>
Puedes usar dbf2mysql. Saludos.
- --
Alfredo J. Cole
Tegucigalpa, D. C., Honduras
http://www.ac
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
El Jueves 15 Noviembre 2001 13:15, escribiste:
> Gyulay Gabor wrote:
> > The problem is that I need to store numbers with lot more
> > than 16 decimal digits - e.g. 1234567890123456789012345.12
> > [...]
> >
> > The reason is why we need this that the
El Miércoles 14 Noviembre 2001 09:00, escribiste:
> Anybody have any tools/tips for converting a foxpro database to
> mysql
>
> ___
> Sean O'Donnell
Try dbf2mysql. It works for me.
--
Alfredo J. Cole
Tegucigalpa, D. C., Honduras
http://www.acyc.com (Accounting Systems)
El Martes 21 Agosto 2001 15:23, escribiste:
> Hello,
>
> I have downloaded your dbf2mysql-1.14.tar file from the
> MySQL.com site. I read through the README and still
> cannot seem to get this to work. Here is the error I'm
> getting:
>
> [info:admin/Desktop/dbf2mysql-1.14] root# make
> /usr/bin/
32 matches
Mail list logo
