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
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
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
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
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 until
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)
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
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...
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-
style
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
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
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
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 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
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
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
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
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.
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 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)
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
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
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 near 'CHECK
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 tried to issue
3.23.38 does
-Original Message-
From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
Corp.]On Behalf Of MikemickaloBlezien
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
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
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)
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
28 matches
Mail list logo