be able to search on the `AssociatedWith` field
to find all records that rely on that first record's
`KeyField`.
>
>PS: I am curious to know why you would do that anyway
>
>2012/10/17 W. D.
>
>> When creating a record, the first field (KeyField)...
>>
>>
At 02:44 10/17/2012, Claudio Nanni, wrote:
>Take a look at TRIGGERS
>
>C.
>
>PS: I am curious to know why you would do that anyway
Will want this 'AssociatedWith' field to be associated
with an older records' KeyField so I can search for a
group of records by this field.
Start Here to Find
When creating a record, the first field (KeyField)...
KeyFieldBIGINT UNSIGNED NOT NULL AUTO_INCREMENT
...is it possible to copy this auto-generated value into
another field when using the same INSERT that creates the record?
Or would I have to use an UPDATE query using LAST_INSERT_ID()
prise kernels category).
Regards,
--
Raghavendra D Prabhu (TZ: GMT + 530)
Call: +91 96118 00062
mailto:raghavendra.pra...@percona.com
Percona, Inc. - http://www.percona.com / Blog:
http://www.mysqlperformanceblog.com/
Skype: percona.raghavendrap
GPG: 0xD72BE977
pgpSaCsut4xRn.pgp
Description: PGP signature
http://bugs.mysql.com/bug.php?id=65745 which is a pretty serious bug.
Regards,
--
Raghavendra D Prabhu (TZ: GMT + 530)
Call: +91 96118 00062
mailto:raghavendra.pra...@percona.com
Percona, Inc. - http://www.percona.com / Blog:
http://www.mysqlperformanceblog.com/
Skype: percona.raghavendra
eaking existing code. I would then
be able to refactor at a more leisurely pace.
Does the feature exist, or can it be created?
-- Dante
D. Dante Lorenso
da...@lorenso.com
972-333-4139
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello all.
I have recently finished my migration from an older server to a newer
server running RHEL 6. The MySQL version went from 5.0.77 to 5.1.52.
In my application, this query used to work just fine:
$paid_query = mysql_query("UPDATE $table_name SET owed = 0 WHERE s_id
= $student");
Where t
Hey,
MySQLers if you are looking to present at PgEast, now would be a great
time to get your talk in. Yes it is a PostgreSQL conference, but we like
to learn from each other, do we not?
I would be all over seeing talk titled:
What I wish PostgreSQL could do, from a MySQL users perspective!
http
I have a system that imports about 40 million records every 2 days into
a single table in MySQL. I was having problems with LOAD DATA
CONCURRENT LOCAL INFILE where the table I was importing into would lock
until the import was complete. Locks would prevent SELECTs also.
I converted the table
Michael Dykman wrote:
The query is probably fine.. that is just the lock doing it's job.
Take that advice literally.. when you fail with that class of
exception, delay a milli-second or two and retry. For a large PHP
site I designed, we had that behaviour built-in: up to three attempts
waits 5
fferent
> applications, I frequently get these messages:
>
> DB ERROR: SQLSTATE[40001]: Serialization failure: 1213 Deadlock
found when
> trying to get lock; try restarting transaction
>
> Am I writing my query wrong or expecting behavior th
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
e I expect but when I leave it
as it was, it's 100 times slower.
What's so special about NULL?
Quite a bit ;-)
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB
'abc';
And therefor use the index I have on 'somecolumn'? When I manually
rewrite the query, I get the performance I expect but when I leave it as
it was, it's 100 times slower.
What's so special about NULL?
-- Dante
--
D. Dante Lorenso
--
MySQL Genera
ers? Is there a MySQL Storage Engine designed for this kind of
usage, or is there a another server that is commonly used along with
MySQL for this type of thing?
-- Dante
--
D. Dante Lorenso
da...@larkspark.com
972-333-4139
--
--
D. Dante Lorenso
da...@lorenso.com
972-333-4139
Gavin Towey wrote:
Creating a temporary merge table works fine for me on 5.0.
Your table isn't innodb is it? That will fail with an error like you're
getting.
Strange. Now that I am on my home network and trying this again, it
seems to be working.
mysql> SELECT version();
+---
eady not
when the marketing droids force you to.
I have a strong faith (even if I am not technically interested) in the
direction Monty is going with MariaDB. I expect to see great things.
>
> One more time: begone Postgres troll!
Based on your definition of troll, I would say that I am
uture and he's posted a few ideas of how you can prepare.
>
> That said I do agree he's jumped in at the right time to do a bit of Postgres
> pushin' and pimpin' :-)
You have to take your opportunities when you can :)
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP:
c.
There is no FUD here. The question was asked, I supplied my thoughts.
Further I never suggested any of the things you are stating.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667-4564 - http://www.command
on't exist except on the
most tertiary level. Most new projects will be developed in either
PostgreSQL, Interbase or one of the forks (MariaDB, Drizzle).
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
503-667
ase and it took a long way to get
there.
That being said, this is a good point. A team of developers are likely
not to pick up MySQL unless they get paid. There are too many as good or
better options that are also open source.
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.po
On Thu, 2009-04-23 at 08:25 +, Glyn Astill wrote:
> --- On Wed, 22/4/09, Joshua D. Drake wrote:
> > > >what are we gonna run as RDBMS ?
> >
> > How about PostgreSQL?
> >
>
> I second that. You should all have a play with the 8.4 beta
>
I actu
On Tue, 2009-04-21 at 15:19 +0200, Martijn Tonies wrote:
> Hey Gilles,
>
>
> >After MySQL bought by the java maker,
> > and now Sun bought by Oracle,
> >
> >what are we gonna run as RDBMS ?
How about PostgreSQL?
Joshua D. Drake
--
PostgreSQL - X
PostgreSQL Conference East is being held at historic Drexel University
on April 3rd through 5th 2009 . This is the second call for papers. The
call for papers ends Feb 23rd and speakers will be notified on the 27th.
You may submit your talk here: http://www.postgresqlconference.org . We
are looking
x27;t have worked for me. The original site was
not mine and I didn't have permission to do so.
Thanks,
rdc>
--
Robert D. Crawford rd...@comcast.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Olaf Stein writes:
> I think he only has one DB, I guess that is a provider restriction...
True. I would create a separate db for each application if I could.
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL General Mailing List
For list archi
line to
reflect the name of the current db, right?
Thanks for your help. My partner will be rather happy to have her wiki
up.
rdc
--
Robert D. Crawford rd...@comcast.net
Laugh at your problems; everybody else does.
--
MySQL General Maili
hanks in advance for any help or pointers to relevant documentation,
rdc
--
Robert D. Crawford rd...@comcast.net
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
premeire PostgreSQL
conference series for the United States PostgreSQL community! Please
submit your talk here: http://www.postgresqlconference.org/2009/east/ .
Sincerely,
Joshua D. Drake
--
PostgreSQL - XMPP: jdr...@jabber.postgresql.org
Consulting, Development, Support, Training
; $start) { $start = 1; }
2, SELECT col FROM table WHERE $where LIMIT $start, $rows.
Option B is horrible for large result sets. Only drawback to A is the
tediousness of having 2 queries, but you get over that once you develop
a pattern for writing them that way.
-- Dante
------
D. Dante
D. Dante Lorenso wrote:
There's an awesome feature that was added to PostgreSQL a while back
called RETURNING that allows you to make an INSERT, UPDATE, and DELETE
statement behave like a SELECT statement.
...
Does RETURNING exist in any current release of MySQL or is it on the
TODO list
Rob Wultsch wrote:
On Wed, Oct 15, 2008 at 12:25 PM, D. Dante Lorenso <[EMAIL PROTECTED]> wrote:
There's an awesome feature that was added to PostgreSQL a while back called
RETURNING that allows you to make an INSERT, UPDATE, and DELETE statement
behave like a SELECT statement.
G exist in any current release of MySQL or is it on the
TODO list even? If it's not, how can I go about asking to have it put
on there?
-- Dante
--
D. Dante Lorenso
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ready built into MySQL
that I don't know about.
I am using InnoDB, so the solution needs to be transaction safe. Help
would be appreciated.
-- Dante
--
D. Dante Lorenso
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ou give some example?
Thank you!
--
--
D. Dante Lorenso
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL now ... or will it later ... support CONNECT BY
syntax? Help would be appreciated.
-- Dante
--
D. Dante Lorenso
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
rsion of this tool for many years and
just recently started using their MySQL one.
-- Dante
------
D. Dante Lorenso
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Reyna.Sabina schrieb:
> Hi,
>
> I am using MySQL 5.0.45, for redhat-linux-gnu (x86_64).
>
> I created a new database called HYDRO (user: admin). I created a new user
> called 'hydro' in the 'localhost' ([EMAIL PROTECTED]) without a password.
> User 'hydro' has given all provileges except the ' Gr
Hank schrieb:
> On Tue, Sep 9, 2008 at 11:48 AM, Werner D. <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>> wrote:
>
> Hank schrieb:
> > I have the blocked connection problem between three of my servers, all
> > behind two firewalls and on one switc
Hank schrieb:
> I have the blocked connection problem between three of my servers, all
> behind two firewalls and on one switch.
>
> Occaisionally the mysql servers start blocking the hosts.
>
> What's the downside to running a "Flush hosts" once per minute on these
> mysql servers?
better solut
Shaun Adams schrieb:
> When I perform a dump in mysql5 to mysql 4 DB, I get the error (below).
> Does anyone know how I can resolve this?
>
>
>
> QUERY (windows server from the cmd prompt)
>
> mysqldump --lock-tables --user=root [SOURCE DB] | mysql --user=[USERNAME]
> --password=[PASSWORD] --
Hello,
I am looking for someone to give a talk on MySQL at the upcoming
PostgreSQL Conference in October. Something like Why I chose MySQL over
PostgreSQL: A Technical analysis (or similar).
Any takers?
http://www.pgcon.us/west08/talk_submission/
Sincerely,
Joshua D. Drake
--
MySQL
Hi,
first thanks for your response
Are you using InnoDb or MyISAM? If you are using Inno, I would add
--single-transaction to your mysqldump command within the Perl script and
flush the logs prior to doing the backup and not backup the new bin-log file
until the next.
No, there is a mixture b
Hello everybody,
i have a Question concering MySQL-Backups in a Master/Slave Replication-Setup
(MYISAM and InnoDB Tables) and incremental Backups using the Binary-Logs from
the Slave.
Well, in case something will go wrong (hopefully not) I'm currently trying
to implement a recovery System. There
On Mon, 12 May 2008 at 11:58 -0400, [EMAIL PROTECTED] confabulated:
You could also do:
SET GLOBAL expire_log_days=n;
You forgot the 's' in log:
SET GLOBAL expire_logs_days=n;
BTW - this same hint is on the the very same manual page you mentioned
at the beginning of this thread.
--
August
ould ever get decent performance out of this for any
database let alone MySQL.
Tell your boss to suck it up, spend 5k. You can get a new, decent Dell
for that. Or better yet, a HP.
Sincerely,
Joshua D. Drake
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
On Thu, 24 Apr 2008 at 10:16 -0400, [EMAIL PROTECTED] confabulated:
On Thu, Apr 24, 2008 at 2:54 AM, Sebastian Mendel
<[EMAIL PROTECTED]> wrote:
IMHO not in this case, cause it is just a simple "WHERE field IN ()"
I'm pretty sure that just looks like a bunch of ORs to MySQL. If it
didn't us
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed. As
soon as I enabled the option 'log_queries_not_using_in
NO | UNI | NULL||
| wite_desc | varchar(128) | NO | | NULL||
+---+--+--+-+-+----+
Can anyone shed some light if I should index wite_desc to speed things up?
-d
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
Sincerely,
Joshua D. Drake
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, 11 Apr 2008 14:52:30 -0700
"Rob Wultsch" <[EMAIL PROTECTED]> wrote:
> On Fri, Apr 11, 2008 at 2:15 PM, Joshua D. Drake
> <[EMAIL PROTECTED]> wrote:
> > Hello,
> >
> > Can MySQL functions/stored procedures access database data?
> >
Hello,
Can MySQL functions/stored procedures access database data?
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate
On Mon, 10 Mar 2008 at 14:29 -0400, [EMAIL PROTECTED] confabulated:
Hello,
I have a huge database that I would like to migrate from a server
running 4.0.16 to a server running the Windows version 5.0.45. The
database is approximately 3,500,000 records. I get timeout errors using
PHPMyAdmin to e
http://www.otg-nc.com/
General Sponsor
Emma http://www.myemma.com/
Sincerely,
Joshua D. Drake
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/
particular PostgreSQL Gotcha's or
issues that force you to use MySQL?
Sincerely,
Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/
these autoincrementing
numbers as a key that would need to be changed when transfered to the
storage server.
The tables look like: d
data__ProcessedDataFrames
data__RawDataFrames
data__Raw_in_Processed (this has a key into data__ProcessedDataFrames on
the auto_incremented id)
mysql> desc data__ProcessedDa
8 Jun 2007, at 01:04, Daniel Kasak wrote:
On Wed, 2007-06-27 at 20:07 -0400, Eddy D. Sanchez wrote:
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of system
MMM, yes, but I think that CMS isn't the solution, I want to store a
large amount of documents and organize it with best performance for
indexing, searching and viewing.
On 27 Jun 2007, at 22:57, Gary wrote:
David T. Ashley wrote:
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED
Thanks, but there is no problem with copyright, I want scan and store
just internal documents from my enterprise
On 27 Jun 2007, at 21:48, David T. Ashley wrote:
On 6/27/07, Eddy D. Sanchez <[EMAIL PROTECTED]> wrote:
Hello Everyone.
I want to scan a large quantity of books and doc
Hello Everyone.
I want to scan a large quantity of books and documents and store
these like images inside or outside a database, I want use mysql,
anyone have any experience with this kind of systems, can you suggest
me an opensource solution ??
Thanks.
--
MySQL General Mailing List
Fo
Hi List,
What is the practical limit on size of the sql query in mysql 4.1.x
Anil
Use --allow-keywords option with mysqldump command
Anil
-Original Message-
From: Brian Mansell [mailto:[EMAIL PROTECTED]
Sent: Monday, March 26, 2007 11:18 PM
To: Rob Tanner
Cc: mysql@lists.mysql.com
Subject: Re: Getting SQL errors porting databases between MySQL v4 and v5
The 'group'
I searched some more and then I found
Bug # 10897 - FLOAT and DOUBLE obeying precision and scale. No
documentation.
http://bugs.mysql.com/bug.php?id=10897
Regards,
Martin.
>
> Hi,
>
> I've recently changed MySQL versions and I am puzzled by the difference in
> display of float values.
>
Hi,
I've recently changed MySQL versions and I am puzzled by the difference in
display of float values.
CREATE TABLE test (
id int unsigned NOT NULL auto_increment,
val1 float default NULL,
val2 float(3,3) default NULL,
val3 float(5,3) default NULL,
val4 float(10,6) default NULL,
PRIM
Hi everyone,
I have a couple of questions invovling using FOUND_ROWS() and UNION.
The manual states that:
"The value of FOUND_ROWS() is exact only if UNION ALL is used. If
UNION without ALL
is used, duplicate removal occurs and the value of FOUND_ROWS() is
only approximate."
I am using UNION DI
y.
mysql> explain select * from l,d where (l.sId = d.dId and d.sId = 1)
or (l.sId = d.dId and d.sId = 2) \G
*** 1. row ***
id: 1
select_type: SIMPLE
table: d
type: range
possible_keys: PRIMARY
key: PRIMARY
Sorry everyone, forgot to put in my setup detail!
SQL version: 5.0.22-community-nt
Windows 2000 Professional 5.0, SP 4
Dan, I tried your suggestion, but no luck :(.
explain select straight_join * from l,d where (l.sId = d.dId) and
(d.sId in (1,2)) \G
*** 1. row
imary key,
sId smallint unsigned not null,
dId smallint unsigned,
index(sId,dId)
);
table d
(
sId smallint unsigned not null,
dId smallint unsigned not null,
primary key(sId, dId)
);
explain select straight_join * from l,d where l.sId = d.dI
Hi everyone,
I have the following schema:
create table l
(
aId int unsigned not null auto_increment primary key,
sId smallint unsigned not null,
dId smallint unsigned,
index(sId,dId)
);
create table d
(
sId smallint unsigned not null,
dId smallint unsigned not null,
primary key(sId, dId
Ioannis Anifantakis wrote:
> Hello,
>
> I have been using MySQL version 4.0 because I have experienced problems since
> version 4.1 and later versions...
>
> I tried to update to version 5.0 but problems remain, in short
>
> Due to my stupidity I had been using latin1 encoding for my databa
I just completed designing a site for a dentist that had to be HIPAA
compliant. To see how I structured it take a look at
www.brianwilliamsdds.com.
Keith D. Holler
Owner/Senior Network Engineer
AZCAPPY Network Services
www.azcappy.com
623-931-0809
623-321-8177 Fax
-Original Message-
From
that's a php problem afterall huh?
I guess I can live with the extra query, SET NAMES 'utf8';
:)
On 4/13/05, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 9:59 +0800 4/13/05, D. wrote:
> >I don't know if this is the right way to get back to the thread,
> >h
ut I have always changed my to:
>
> ; language for internal character representation.
> mbstring.language = utf8
> ; internal/script encoding.
> mbstring.internal_encoding = utf8
>
> and have never had a problem.
>
> D. wrote:
>
> > Hi, this might not be a
Hi, this might not be a mysql problem, but hopefully someone will be
able to answer, thanks in advance.
I notice a lot of people had asked the same question and the typical
response in the mailing list seemed to be, "make sure you encode the
data to utf-8 before insert into mysql...", or something
= 2M
[mysqlhotcopy]
interactive-timeout
[EMAIL PROTECTED] etc]#
On Mon, 28 Mar 2005 15:05:04 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 17:50 -0300 3/28/05, Alejandro D. Burne wrote:
> >OK, I confuse a little, this is the message:
> >
> >[EMAIL PROTECTED] init.
.cnf came from 5.0.2 and this option it's not supported on 5.0.3?
Alejandro.
On Mon, 28 Mar 2005 14:21:28 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 16:30 -0300 3/28/05, Alejandro D. Burne wrote:
> >Hi, I'm testing 5.0.3.
> >I make a rpm update from 5.0.2.
>
Hi, I'm testing 5.0.3.
I make a rpm update from 5.0.2.
After it mysqld through mysqlamanager doesn't start. I'll be watching
logs and I saw the problem was in mysql section on my.cnf. If I
comment --no-auto-rehash it works.
I can't find info on --no-auto-rehash. Someone can tell what is it?
Thnx. A
Any idea 5.0.3 release date? There are many bugs fixed right now for 5.0.2!
Alejandro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
If I make a connection as follows:
$getcnnctd = @mysql_connect('this', 'that', 'bigsecret');
then select my db, then
$res = mysql_query("select * from thedb");
when finished using the db etc., am I assuming correctly that I should:
mysql_free_result($res); to free the memory up
and
mysql_close(
Time ago I submit a post about temp tables and rights privileges and
it's in my head still.
There is an user privilege to create temporary table
(create_tmp_table_priv) but when the "owner of the table" need drop
this table can't do (if have drop priv can, but it's a bomb time).
Someone have an ide
Dec 2004 22:01:37 +0200, Heikki Tuuri <[EMAIL PROTECTED]> wrote:
> Alejandro,
>
> - Original Message -
> From: ""Alejandro D. Burne"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.myodbc
> Sent: Friday, December 03, 2004 7:20 PM
>
After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't start with error:
"Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)"
I think it's a problem with innodb, if I add skip-innodb on my.cnf
mysqld starts up:
041203 14:04:01 mysqld started
041203 14:04:01 [Warning] Asked for 19660
orrect settings, so you may as
>well just edit the one you already have.
>
>Michael
>
>W. D. wrote:
>
>> Hi Folks,
>>
>> How does one completely remove MySQL from FreeBSD 4.9?
>>
>> My router died, and upon replacement I switched to
>> static IP
Hi Folks,
How does one completely remove MySQL from FreeBSD 4.9?
My router died, and upon replacement I switched to
static IP addresses on my local network. Unfortunately,
When using phpMyAdmin to access a database, it
tries to access the database at the old IP.
I can easily recreate the databa
In your query you have converted the Date column into a string by using
DATE_FORMAT so it is a string of bytes. If you want it to still be a
date then don't format it.
John Bonnett
-Original Message-
From: Thomas Trutt [mailto:[EMAIL PROTECTED]
Sent: Thursday, 7 October 2004 2:29 AM
To:
or... for me this rpm was the solution:
MySQL-shared-compat-4.0.21-0.i386.rpm
from:
ftp://gd.tuwien.ac.at/db/mysql/Downloads/MySQL-4.0/MySQL-shared-compat-4.0.21-0.i386.rpm
Philippe Poelvoorde wrote:
Tim Johnson wrote:
Hello:
Installing MySQL-server-4.0.21-0.i386.rpm
on Red Hat 9.0
Getting the
How come when I am using the terminal on my mac os x 10.3.x and give the command show
databases I only see one database (the 'test' database that is included in the
install') as compared to viewing databases with my browser and phpmyadmin I can see 6
databases (that same 'test' database, a 'mysq
Should mysql version 4.0.20 support the "Insert data from a textfile into table" which
is shown at the bottom of the page while in phpmyadmin with a database and table
selected? I am getting this error:
#1148 - The used command is not allowed with this MySQL version.
Thanks for any help,
Doug
have MySQL 4.0.20 on my mac os x 10.3.x client machine. My question is, how do I go
about getting my MySQL databases that I created to another computer. I have been told
my databases are in /usr/local/mysql/data. When I try to get into the sub-directory
/data it says I do not have permission
help (at least for me) is working with temporary
aaca> tables, spliting one complex query in many littles.
aaca> A simple example:
aaca> 2 tables: header and details
aaca> CREATE TEMPORARY TABLE tmp TYPE=HEAP
aaca> SELECT hdr_code FROM header WHERE ...;
aaca> ALTER TABLE tmp A
Hi,
I have installed mysql 4.0.18 on my debian box. I am
quite new to linux. mysql works fine with the command
line (mysql) and with apache/phpmyadmin too. But when
i try to connect from Windows or if i telnet from
Debian, i got:
Number of processes running now: 0
040622 21:27:33 mysqld restarte
At 03:08 6/17/2004, vanquish, wrote:
>Bonjour Martijn,
>
>>> >> i'm looking for fast reliable driver to connect to MySQL from Delphi 7
>>> >> anyone have an answer for my PLEASE
>>>
>>> I'am using Zeoslib (www.ZeosLib.net). It's fast, free, open source and
>>> powerfull.
>
>MT> Does it require MySQ
the mailing list,
> everyone who monitors the
> list -
> > and anyone who checks the archives in the future!
> - can benefit.
> >
> > The rest of my reply is interspersed in your
> note
> >
> > Rhino
> >
> > - Original Message -
>
Hi,
I am testing the following code that attempts to get a
DB connection, but I keep getting the following error:
database_test.DBConnector
SQLException: No suitable driver
SQLState: 08001
VendorError: 0
The code snippet is below. I know the DB I am trying
to connect to exists and that the user
Thanks for the info!
At 15:01 6/15/2004, Darryl Hoar wrote:
>I'm using the Zeoslib control to do just that.
>www.zeoslib.net. Works like a champ for me.
>And its opensource.
>
>
>> -Original Message-
>> From: W. D. [mailto:[EMAIL PROTECTED]
>> Sent
At 09:04 6/15/2004, Martijn Tonies, wrote:
>Hi,
>
>> i'm looking for fast reliable driver to connect to MySQL from Delphi 7 do
>> anyone have an answer for my PLEASE
>
>We're using the Microolap.com components - they have either
>direct components (TDataset compatible) or a dbExpress driver.
Would
;
// Notice, do not import com.mysql.jdbc.*
// or you will have problems!
/**
* Title: Phone # regex:
^([(]?\d{3}[-)]\d{3}-\d{4})*$
* Description:
* Copyright: Copyright (c) 2004
* Company:
* @author unascribed
* @version 1.0
*/
public class DBConnector
{
//Class State
private
I am trying to programatically connect to my DB, but I
am not sure what the connection string should be. I am
using this statement:
conn =
DriverManager.getConnection("jdbc:mysql://localhost/test?user=scott&password=cuatro");
I am getting this exception message:
database_test.DBConnector
S
Jonathan Villa wrote:
I'm administering a Red Hat machine which is used soley for MySQL. The
person working with the db has more than 15 million records in various
tables...they were trying to run some queries to create one table from
these many tables. When this was happening, they ran out of di
I am a personal user who just downloaded the version
4.0 and
mysql
> administrator. The first time I clicked on the
> "Administrator" icon
> on my desktop I get an error that says "failed
to start because
> msvcr70.dll was not found. Try to reinstall. I
did remove the
> program a
1 - 100 of 516 matches
Mail list logo
