You'll need MyODBC to connect from Access to MySQL.
- Original Message -
From: "Manuel Mesquita" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 02, 2001 0:52
Subject: Access to Other Databases Thru MySQL
> Dear Sirs,
>
> We are new in MySQL. We work basically with Micros
P.S. You could also UPDATE 4 first with the new value and then DELETE 2.
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: "Artem Koutchine" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, July 01, 2001 15:03
Subject: Re: UPDATE/REPLACE command
> No there isn't.
hat I am
trying to do:
SELECT ref,SUM(clicks) AS num_clicks FROM referrals
WHERE ref BETWEEN 'p/%/20010601' AND 'p/%/20010630'
GROUP BY ref
The code above is meant to do a group by of all the
clicks generated by each promotion occuring between
June 1 and June 30
I realize that I
No there isn't. You'll need to DELETE first and then UPDATE. Ie. delete 4
first and then update 2.
- Original Message -
From: "Artem Koutchine" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 22:43
Subject: UPDATE/REPLACE command
> Hi!
>
> Was UPDATE/REPLACE co
If each record is being updated with exactly the same information you could
the statement
WHERE key IN (key1, key2, ...)
Otherwise you'll need an update statement for each record.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 21:41
Su
Hi
The SHOW STATUS command:
At status variables list there are some times an explanation using the
expression:
if x is big or This will be high if you are
What basic value can I use to determine what is Big or High ?
Some % of Questions ?
Regards
Rui Torres
>From PHP
PHP 4.0.6 [755Kb] - 23 June 2001
(CGI only, MySQL support built-in, packaged as Windows installer to install
and configure PHP, and automatically configure IIS, PWS and Xitami, with
manual configuration for other servers. N.B. no external extensions
included)
---
greetings,
anyone know where a person could find information on configuring php4
for Win9x
as a PWS in correlation with mysql...have only found information on
configuration for Win2000
which is
different from Win9x?
also, based on the information ive gathered for php4 for Win2000, it
advi
3.23.38 does
-Original Message-
From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
Corp.]On Behalf Of MikeBlezien
Sent: Saturday, June 30, 2001 4:35 PM
To: [EMAIL PROTECTED]
Cc: Werner Stuerenburg; [EMAIL PROTECTED]
Subject: Re: CHECK TABLE
On Sat, 30 Jun 2001 16:34:06 -0
On Sat, 30 Jun 2001 16:34:06 -0600, Colin Faber <[EMAIL PROTECTED]> wrote:
it doesn't work on 3.23.32 either!
>>Check table didn't exist in 3.22
>>
>>Werner Stuerenburg wrote:
>>>
>>> Sorry, I don't understand from the manual how to use this
>>> (running MySQL 3.22.32 on RedHat)
>>>
>>> I tr
Check table didn't exist in 3.22
Werner Stuerenburg wrote:
>
> Sorry, I don't understand from the manual how to use this
> (running MySQL 3.22.32 on RedHat)
>
> I tried to issue
>
> CHECK TABLE tbl_name
>
> as indicated, but get
>
> mysql> CHECK TABLE sessData;
> ERROR 1064: parse error ne
Sorry, I don't understand from the manual how to use this
(running MySQL 3.22.32 on RedHat)
I tried to issue
CHECK TABLE tbl_name
as indicated, but get
mysql> CHECK TABLE sessData;
ERROR 1064: parse error near 'CHECK TABLE sessData' at line 1
--
Herzlich
Werner Stuerenburg
__
mySQL says;
"The easiest and therefor the preferred way to install is to use the mysql-server and
mysql-client ports available on http://www.freebsd.org. "
So my question is ,,do these mysql-server and mysql-client ports from FreeBSD include
the Innodb tables support like mySQL-Max does? I can
I am working with a commercially supplied database of zipcode numbers and
related data. In the documentation, the following pseudo-coded SQL queries are
included. I am mystified by two things here:
1) [Zip Code Distance Extractor] <-- I have no clue as to what this is
referring to
2) t
In the last episode (Jul 01), Manuel Mesquita said:
> To make links, like MSACCESS to other Types of Databases in
> Linux/Windows, using Java, thru MySQL? Our need is to access to
> MSACCESS, ORACLE and SQL Databases in java, having the links to those
> other Databases defined in MySQL, and not by
i was wondering if anyone could help out with some replication stuff. i went through
the instructions from mysql.com and when i restarted the slave, it said that it was
not configured correctly.
powerdesigner from sybase works very well.
it's very expensive though...
you cna get a trial from the sybase web site.
-Original Message-
From: Jack Baty [mailto:[EMAIL PROTECTED]]
Sent: 30 June 2001 09:17
To: [EMAIL PROTECTED]
Subject: Re: Diagrams and Flowcharts on mySQL tables
T
Try Dezign for Databases. Works pretty well and is much cheaper than the big ones
(ER/Studio and ERWin)
http://www.datanamic.com/dezign/
-- Original Message --
From: Robert Goeres <[EMAIL PROTECTED]>
Date: Sat, 30 Jun 2001 16:37:28 +0200
>I have a bu
> i have 3 tables: offers, rewards, and sources. sources has just a source
> name and source id. both the offers and rewards tables have a "source_id"
> field which relates to the sources table. i need to write a query that
> selects the source name and the count in each table with that source id.
i have 3 tables: offers, rewards, and sources. sources has just a source
name and source id. both the offers and rewards tables have a "source_id"
field which relates to the sources table. i need to write a query that
selects the source name and the count in each table with that source id. is
this
im having problems getting results querying two tables but I am not sure of
the correct php syntax for the query statement below. It always yields 0
results.
$query2 = "select * from dir,free where 'dir.inst' = free.inst'";
This is what I use in mySQL database but I get 0 results when querying
> I have a bunch of tables and would like to get an overview. Does a program
> (with pref. Win32) exist with takes mySql tables and represents them
> graphically where you could draw your link and print them out?
I don't know what you mean, but I manage my dbs and tables with
phpMyAdmin and am pr
Dear Sirs,
We are new in MySQL. We work basically with Microsoft Access.
Please can you give us same info about:
To make links, like MSACCESS to other Types of Databases in Linux/Windows,
using Java, thru MySQL? Our need is to access to MSACCESS, ORACLE and SQL
Databases in java, having the link
I have a bunch of tables and would like to get an overview. Does a program
(with pref. Win32) exist with takes mySql tables and represents them
graphically where you could draw your link and print them out?
Regards
Robert Goeres
---
Hi!
>MySQL provides three transaction-safe tables including Berkeley_DB, GEMINI
>and InnoDB Tables, I have some queries on them:
>1. What are the differences between these three type of transaction-safe
> table types?
BDB has only page level locks, InnoDB has row level locks and an Oracle-
sty
Ok could some kind soul point me to the doc's for reseting the index
after deleting a few records below is my database and I did a
delete where rec >0 and it worked however the index is still at 6 how
can I correct this or reset the index to the number of records in the
data base hum...
Than
Hi!
You are probably usinf mysqld.exe from 3.23.38. It was accidentally
compiled with __NT__ defined. Use mysqld-max.exe or
upgrade to 3.23.39.
Regards,
Heikki
http://www.innodb.com
At 14:58 29/06/2001 -0500, Jose Garcia wrote:
>I was trying to install Mysql in win 98 and after several attempt
At 23:46 29/06/2001 -0500, Tyler Longren wrote:
Hi,
The 1067 error, means an MySQL server aborted.
The cause should be:
- Missed (dropped) or corrupted MySQL grant tables.
- Problems with the \share directory or errmsg.sys files.
- Wrong variable(s) on the configuration file (my.ini\my.cnf)
Trou
Hi,
If I have a table:
create table messages (
id int unsigned not null unique,
datalongtext );
and I have a perl script:
1 $sth = $dbh->prepare( "SELECT data FROM messages WHERE id = ?;");
2 $sth->execute($id);
3 $data = $sth->fetchrow;
QUESTION:
will the script stop at line 3 unti
At 14:58 29/06/2001 -0500, Jose Garcia wrote:
Hi,
Please read the Manual on \mysql\docs the chapter:
8.7.2 InnoDB startup options
Notice that you need to create 2 directories before the start
called c:\ibdata and c:\iblogs in the sample.
I you don't want the support of tables InnoDB use the be
Nigel Champion writes:
> Hi,
>
> I have a PIII 800MHz 2GB RAM Linux (Suse 6.4) server running mysql version
> 3.23.28
> I also have 2 Solaris machines a E440R with 2x450MHz CPUs and 512MB of RAM
> (this is results 2 & 3)
> and a E4500 with 4x450MHz 4MB cache CPUs and 2GB of RAM with a 12 disk SCS
X Gogo writes:
> Well, the order in which the queries are made doesn't matter. The query with
> LIMIT is always slower than the one
> without it. When I used EXPLAIN SELECT... I actually
> found that MySQL uses temporary table for the query with
> the DISTINCT / LIMIT combination. I presume this
hello sir,
we are using MySql is my backend in SunSolaries5.8. I got a problem with
present slice (/usr/local/mysql) where mysql is installed. Now i want to chage my
database into another slice(/export/home/database) with out any dirstrubence to
database. Can i move my present directory
I have a problem with a bulletin board type system. When a new
message is posted the script redirects back to the page that displays
the messages. If I do a simple query i.e.
SELECT * FROM messages WHERE subject='$subject'ORDER BY ID
Then all relevant messages are displayed including the one jus
34 matches
Mail list logo
