Hello,
I need one help.To enable 8 bit language in bash we are exporting like
this
# For 8 bit Language support
export LC_CTYPE=iso_8859_1
# For less to support 8 bit chars
export LESSCHARSET=latin1
I am using local language for inserting values in mysql.While sorting in
mysql is
sql-problem!
hello,
please could you help me? after you made some
work on your server.. the side of
www.fcliestal.chdoes not work anymore
because i did not change anything on it, i
do not know, what to do... please could you
reactivate the site?
... or at least give me
Hello...
I just encountered the following: let $a be a numeric php expression, a
the corresponding integer field in a table. When I say: UPDATE table
SET a=$a it denies the update. When I say: Update table SET a='$a' it
performs the update. Uhm, now I am wondering. Isn't 'something' supposed
to
Hello,
I'm using mysql-max 3.23.49 binary distribution.
I use mysqldump utility to dump tables from my DB.
for example:
mysqldump --opt -u root -p EFDB users users.sql
users.sql file contains:
--
-- MySQL dump 8.21
--
-- Host: localhostDatabase:
I have a database table containing log files that are written by different individuals
almost every day.
So at any given time I want to be able to go through a web interface and get a list
over logs written in any given month.
People writing in this log also work in different department, a
Hello Andreas,
I just encountered the following: let $a be a numeric php expression,
a
the corresponding integer field in a table. When I say: UPDATE table
SET a=$a it denies the update. When I say: Update table SET a='$a'
it
performs the update. Uhm, now I am wondering. Isn't 'something'
Given a table with some non-unique column theCol, what is the most efficient
way to count the number of different values in theCol? I guess you can use a
temporary table as a subselect:
CREATE TEMPORARY TABLE tmp SELECT UNIQUE theCol FROM theTable;
SELECT COUNT(*) FROM tmp;
DROP TABLE tmp;
But
Torkil,
I have a database table containing log files that are written by
different individuals almost every day.
So at any given time I want to be able to go through a web interface
and get a list over logs written in any given month.
People writing in this log also work in different
-Ursprüngliche Nachricht-
Von: Andreas Dau [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. März 2002 10:37
An: 'DL Neil'
Betreff: AW: syntax Q
-Ursprüngliche Nachricht-
Von: DL Neil [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. März 2002 10:09
An: Andreas Dau; [EMAIL
Rob wrote :
Given a table with some non-unique column theCol, what is the most efficient
way to count the number of different values in theCol? I guess you can use a
temporary table as a subselect:
CREATE TEMPORARY TABLE tmp SELECT UNIQUE theCol FROM theTable;
SELECT COUNT(*) FROM tmp;
Hi ,
I downloaded mysql-3.22.32.tar.gz and began installing the source. I installed this on
Solaris 2.6. However when I 'make', I came across this problem:
--
-Ursprüngliche Nachricht-
Von: DL Neil [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. März 2002 11:03
An: Andreas Dau
Betreff: Re: syntax Q
Hello Andreas,
I just encountered the following: let $a be a numeric php
expression,
a
the corresponding integer field in a
Thx for ur quick help I will check after a short nap *ggg*
-Ursprüngliche Nachricht-
Von: DL Neil [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 4. März 2002 11:03
An: Andreas Dau
Betreff: Re: syntax Q
Hello Andreas,
I just encountered the following: let $a be a numeric
Hi,
We use mysql 1.23.47 as a database for our
PHP based accounting system.
We use mysql_pconnect() to get a
connection to the DB.
This morning we couldn't log in because
mysql sent back a 'too many open connection!'
(or someting like that) error message.
If I use the command SHOW PROCESSLIST
In recent versions, you can do select count(distinct theCol) ... (I'm
actually running one at this moment!!)
On Mon, 2002-03-04 at 09:34, Rob wrote:
Given a table with some non-unique column theCol, what is the most efficient
way to count the number of different values in theCol? I guess
John Hughes wrote:
Please allow me to broaden this thread to include backup for mySQL
users who have accounts with ISPs.
In my case I have mySQL access on a Web server where I have NO access
to the server-level options. What is my best option of making a
backup of the database and tables
Hi.
I just saw that one of the tables in a pretty big MySQL-database here
was corrupted. Checked the table with isamchk (yes, it's an
ISD/ISM-database, not MYD/MYI), and found some errors, but corrected
them. But, still the content are pretty .. uh, bad, and the backup isn't
all that recent...
Hi
How can I export data, from the database tables in Mysql, to a
Comma Seperated File(CSV).
Urgent
Amit Lonkar
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I've a question concerning negations of regular expressions - e.g. I
want the sentence this is nice to match, while the sentence this is
not nice should not match.
I only found possibilities for the negation of single characters on the
MySQL-site, but what about whole words?!
Greetings,
Hi,
SELECT columns
INTO OUTFILE 'path/to/directory/file.csv'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY \n
FROM table
for more info checkout:
http://www.mysql.com/doc/S/E/SELECT.html
cheers
Richard
At 11:06 04/03/2002 +, Amit Dilip Lonkar wrote:
Hi
How can I
Hi,
Suppose i have a table whith ids and two more tables with logs like
this:
table0: id1,id2
table1: id1,id2,date,ip
table2: id1,id2,date,ip
Table0 is where i have all existent pairs (id1,id2).
Table1 logs all events of type 1.
table2 logs all events of type 2.
My problem is that i need to
Angela,
Monday, March 04, 2002, 1:25:44 PM, you wrote:
AH I've a question concerning negations of regular expressions - e.g. I
AH want the sentence this is nice to match, while the sentence this is
AH not nice should not match.
AH I only found possibilities for the negation of single
Michael Villalba writes:
mysql_insert_id returns the correct value to my application when I insert a
single
row using the INSERT...VALUES syntax. However, when I insert multiple rows,
it always returns 0. This is inconsistent with the behavior of
LAST_INSERT_ID,
which returns the id of
Sorry I´ve tried it but I didn´t succeed. When writing: update
tPruefBesch set fdatetime = fTimestamp, datetime and timestamp wont have
the same value. I don´t know why, but there is the same fault.
I´ve created a small database to show my problem.
That´s my table in MySQL 3.23.41.
create
On Sun, 2002-03-03 at 08:39, root wrote:
Description:
Down loaded bin/mysqld Ver 3.23.49-max for pc-linux-gnu on i686 from U of
Wisc
site gunzipped and untarred in /usr/local ran mysql_install_db then ran
./bin/safe_mysqld
from install directory kept coming up with error 020303
Hi!
I'm in the same position as Steve: Considering switching from MyISAM to InnoDB because
of the
row-level locking capabilities. My application has quite a lot of updates/inserts
mixed with
selects, and is starting to suffer from the table-locking policy...
And like Steve, I'm also scared! :)
Excuse me for jumping in.
UPDATE table SET a=$a
1. I assume the double quotes in your original message are meant to highlight the
problem statement.
2. As written, you are attempting to set an integer type column to the string literal
consisting of the characters $
and a. MySQL rejects
Hi, all:
I create a table as following:
CREATE TABLE appsvr_trarte (
rte_id bigint(38) NOT NULL auto_increment,
strConfName varchar(70) NOT NULL default '',
lFromTime int(16) unsigned NOT NULL default '0',
lToTime int(16) unsigned NOT NULL default '0',
iSvrType tinyint(2)
Hi :)
Are there plans on creating more than on tablesspace plus making them
selectable ?
So that I can tell the DB:
- in which datafiles to store the tablespace X
- in which tablespace to store table Y
With MYISAM we could simply move the data+index files to a separate disc,
create symlinks and
Horváth,
Monday, March 04, 2002, 9:51:05 AM, you wrote:
HS Hello everyone!
HS I would like to use my mysql server via Perl.
HS Does anyone send me links or documents about it?
Look at Perl DBI interface. You can read more about it here:
http://www.mysql.com/doc/P/e/Perl.html
You can
Ben,
Monday, March 04, 2002, 7:48:45 AM, you wrote:
BB I am very new at using MySQL, so this may be a stupid
BB question. in my webpage front end, a user logs in,
BB and I pass his username to the form throught a hidden
BB form. The only problem is that the user name are all
BB FirstName
Son,
Sunday, March 03, 2002, 6:53:36 AM, you wrote:
SNIt's like multiple script try to update the same piece of data in
SN the mySQL at the same time.
SNDo I need to provide a method to synchronize to all my scripts.
You can read about
1. LOCK TABLES/UNLOCK TABLES.
LOCK TABLES
Jesse,
Monday, March 04, 2002, 3:11:30 AM, you wrote:
JL This is a definite newbie question. I downloaded
JL the Win32 version of MySQL to my personal pc
JL (windows 98), in order to become familiar with
JL the software. As directed by the section in the
JL online manual 2.6.2.3 Running MySQL
You have to enclose the data in quotes or it cuts off at the first space.
Example:
$resultID = mysql_query(INSERT INTO data_table (name, address) VALUES
($name, $address),$connect);
This will cut off the text at the first space in the text field
This is the method that worked for me:
Hi Heikki,
I don't know if this has been requested, but what about a tool to
'pre-create' dataspace? This tool would allow someone to create a new
dataspace, then a quick restart (After adding the name of the space to
'my.cnf') and the new dataspace is available! Maybe just extract the
On 26 Feb 2002, Arjen Lentz wrote:
On Tue, 2002-02-26 at 12:21, Peter Jennings wrote:
We have been trying to solve a replication issue related to TEMPORARY
tables.
Here's the issue
Every three hours we run a processX (C++ compiled program) on the Master
mysql that goes something
All,
Using MySQL++, how do you check to see whether or not a specific table exist
before you go ahead and create it?
TIA
Thi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
All,
Other than the MySQL++ documentation found at the mysql home site, where
else can I find more examples and/or tutorials of using MySQL++?
Thi
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Have A Great Scouting Day
Ken Hylton
7826 Falcon Ridge Drive
San Antonio, Texas 78239-4032
210-646-9508 (home)
210-949-7261 (work)
210-949-7254 (fax)
210-287-6756 (cell)
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
Hello folks,
I have a large problem during the compilation of mysql under tru64 unix.
I have tried is the 1.7.9 that the 1.7.6a with compiler cxx.
The 1.7.9 jam when the following launch the gmake with message:
gmake all-recursive
gmake[1]: Entering directory `/data/local/src/mysql++-1.7.9'
Hi ,
When ever I am running my query it gives me
1030- got error 134 from table handler.
has anybody come across it.
Any help will be greatly appreciated.
Thanks
Stanley
This email and any attachments
Hi, please help me with this problem...
Suppose i have a table whith ids and two more tables with logs like
this:
table0: id1,id2
table1: id1,id2,date,ip
table2: id1,id2,date,ip
Table0 is where i have all existent pairs (id1,id2).
Table1 logs all events of type 1.
table2 logs all
At 9:43 +0800 3/4/02, Al Caponi wrote:
Check out the MySQL website for altering table structure:
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
You could use MODIFY to change the columns definition in your tables. Note
that specifying NOT NULL on a column will not affect existing rows where
that
At 11:06 + 3/4/02, Amit Dilip Lonkar wrote:
Hi
How can I export data, from the database tables in Mysql, to a Comma
Seperated File(CSV).
If you have the FILE privilege, you can use SELECT ... INTO OUTFILE.
If you don't, I have a Perl script that can export directly as CSV to a
file on the
Hi Stanley
You can get mysql to tell you what an error means by doing
perror error number
In your case the result is 'Record was already deleted (or record file
crashed)'.
You should be able to recover your table with myisamchk -r
james
At 15:09 04/03/2002 +, Stanley Joseph wrote:
Hi
I am having a problem reading a SQL script to recreate a database. I am
runing mysql 3.23 on Redhat linux 7.2. The SQL file contains 35 megs worth
of data. Everytime i try running it to recreate my database from a backup i
get the following error:
ERROR 2006: MySQL server has gone away.
I
* ds
Hi, please help me with this problem...
Suppose i have a table whith ids and two more tables with logs like
this:
table0: id1,id2
table1: id1,id2,date,ip
table2: id1,id2,date,ip
Table0 is where i have all existent pairs (id1,id2).
Table1 logs all events of type 1.
Erminio Efisio Riezzo writes:
Hello folks,
I have a large problem during the compilation of mysql under tru64 unix.
I have tried is the 1.7.9 that the 1.7.6a with compiler cxx.
The 1.7.9 jam when the following launch the gmake with message:
gmake all-recursive
gmake[1]: Entering
torkil,
Monday, March 04, 2002, 10:57:50 AM, you wrote:
tj I have a database table containing log files that are written by
tj different individuals almost every day.
tj So at any given time I want to be able to go through a web
tj interface and get a list over logs written in any given
Buding,
Monday, March 04, 2002, 3:37:08 PM, you wrote:
BC Hi, all:
BC I create a table as following:
BC CREATE TABLE appsvr_trarte (
BC rte_id bigint(38) NOT NULL auto_increment,
BC strConfName varchar(70) NOT NULL default '',
BC lFromTime int(16) unsigned NOT NULL default '0',
BC
Viraj,
Thursday, February 28, 2002, 9:58:32 PM, you wrote:
VA I'm not sure if this is a bug or not, but I've noticed that if I have a
VA 'database=' in my ~/.my.cnf, calling mysqldump with any possible options
VA always returns:
VA mysqldump: option `--databases' doesn't allow an argument
VA
I'm exporting data from Oracle and importing it into MySQL. The problem is Oracle
puts garbage lines at the end of it's output files. Lines like 300 rows selected
and input truncated to 9 chars as well as empty lines. When MySQL loads these
files, I'm getting rows inserted for the empty
Using UltraDev 4 with Phakt 1.2.1, linking to a MySQL server 3.22.23
I want to develop a SQL SELECT query where I can vary what customers are
listed depending on the value of various form fields.
For example if the check box surname_all is ticked then all customers are
displayed if not then it
Dear Sinisa,
thanks for the fast answer. I use the GCC-3.0.3 and have already made
automake, autoconf and ./configure. When I make gmake jams on the error that
I have to you before marked. I use gmake the 3.79.1, automake the 1.5 and
autoconf the 2.52.
Thanks still for the kind aid.
Erminio
Hello Emil
You need to increase the max packet size that mysql can handle... try
putting this in your my.cnf file under [mysqld]:
set-variable = max_allowed_packet=5M
and restarting your server (obv. if you're starting mysql from the command
line use the switch --max_allowed_packet)
james
Does anyone know if there is a good profiler to use on MySql, for example,
in SQL Server, you can start the 'profiler' and it will tell you everything
that is happening on the server.
Thanks,
Eddie
-
Before posting, please
Hello,
I'm looking to port a MySQL replication set that runs 3.23.25-beta to a
later version of MySQL. I understand that the format for the binary log
changed from .25 to .26 and again at 4. It appears, from looking at the
code for 4, that it looks at the version of the replication master and
We have FreeBSD 4.2-RELEASE and I can't say for sure how much
time it might take to upgrade to 4.3 or higher. It might take
anywhere from one reboot to several hours (if something won't
work).
Mysql was built on our server.
Sincerely,
Stephen
-Original Message-
From: Jeremy
At 10:58 -0500 3/4/02, Richard Bolen wrote:
I'm exporting data from Oracle and importing it into MySQL. The
problem is Oracle puts garbage lines at the end of it's output files.
As you've noted, the problem is Oracle.
If you're using Unix, you could use tail to see how many of these lines
Try using something a little different:
if ($surname_all){ //checks to see if the variable is set
$surname_query = WHERE surname between $surname_from and $surname_to;
} else {
$surname_query = ;
}
-Original Message-
From: Craig Shepherd [mailto:[EMAIL PROTECTED]]
Sent: Monday, March
hello
i creates two table t1 and t2;
CREATE TABLE t1 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (id)
) TYPE=InnoDB;
CREATE TABLE t2 (
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
t1id INT UNSIGNED NOT NULL,
PRIMARY KEY (id),
KEY (t1id),
FOREIGN KEY
Thanks for that.
It's actually more the UltraDev/Phakt thing I'm having problems with. I just
wondered how you would set the SQL statement in such a way that UltraDev
wouldn't complain - it doesn't like SELECT * from customers.$surname_query.
Do you know of a good way of handling conditional
John Dean [EMAIL PROTECTED] writes:
Hi
All you need to do is include a symlink on libmysqlclient.so.11 to
point to libmysqlclient.so.10
e.g ln libmysqlclient.so.11 libmysqlclient.so.10
Not a good suggestion for libraries in general. If a library so name
has changed, it means it not
--- Horváth_Szabolcs [EMAIL PROTECTED] wrote:
Hello everyone!
I would like to use my mysql server via Perl.
Does anyone send me links or documents about it?
Thanks
Szabolcs
I am using DBI module in Perl to connect to mySQL database. More
information can be found at the below link
I give this query:
ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY
but it creates tel3 as VARCHAR(30) !
Why?
Makis
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
This has nothing to do with MySQL. Check out freesql.org and talk to them
about your problems.
On Monday 04 March 2002 1:31 am, Zandona Marcello BGV wrote:
sql-problem!
hello,
please could you help me? after you made some
work on your server.. the side of
www.fcliestal.chdoes not
Hi,
What would the plausability of a function like this being implemented in the
future.
create table mytable (id int, val char(255), hits int);
insert some data...
select max(5,hits) from mytable group by id;
This would allow selecting of the top 5 rows for each id according to the
hit
On Monday 04 March 2002 10:50 am, Richard Clarke wrote:
create table mytable (id int, val char(255), hits int);
insert some data...
select max(5,hits) from mytable group by id;
This would allow selecting of the top 5 rows for each id according to the
hit column.
Without this function it
Because that wouldn't give the correct results.
I want the top 5 rows for EACH id.
A short example would be,
mytable:
IdValHits
1 a 10
1 b 15
1 c 17
2 q 200
2 r 205
2 s 101
2 t 50
3 zz 10
3 yy 20
3
Christian Rabe writes:
Are there plans on creating more than on tablesspace plus making them
selectable ?
So that I can tell the DB:
- in which datafiles to store the tablespace X
- in which tablespace to store table Y
This is one of the things I was wondering about.. If I have multiple InnoDB
Hi All,
New to mysql. Running: Win2k as Administrator
mysql-3.23.49-win.zip (binaries)
Keep getting error (complete output below sig):
mysqld: Table 'mysql.host' doesn't exist
I've tried running each binary msqld version (mysqld, mysql-max).
I haven't seen any
At 15:39 +0200 3/4/02, savaidis wrote:
I give this query:
ALTER TABLE `companies` ADD `Tel3` CHAR(30) BINARY
but it creates tel3 as VARCHAR(30) !
You have other variable-length columns in your table.
http://www.mysql.com/doc/S/i/Silent_column_changes.html
Why?
Makis
I need to have access to all the databases on my server using one ODBC
connection. Currently, I have to specify the db and only have access to
that one...is there a way around this? How about SQL Links?
Thanks,
Eddie
-
Currently ezmlm supports mysql, I was wondering if there was a way to get
db2 to talk to mysql, so that when someone subscribes to the mailing list,
their credentials get passed to db2.
Thanks for any help.
Arthur
-
Before
I added the line set feedback off at the beginning of my Oracle report script and
that suppressed the output of the garbage lines.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 11:33 AM
To: Richard Bolen; MySQL Mailing List (E-mail)
Hi everyone,
I'd like to know how to load files, such as MS-Word documents or PDF
documents, in a mySQL database. I've setup a blob type in a table, but
where do I go from there?
The purpose of this is to store files uploaded from a web page and processed
with Java servlets. Then, the files
Correct.
Richard
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Richard Clarke [EMAIL PROTECTED]; Christopher Thompson
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 04, 2002 6:34 PM
Subject: Re: extra max() function possibly very useful?
LIMIT to be applied to
On Mon, Mar 04, 2002 at 11:19:54AM +0100, Takacs Istvan wrote:
Hi,
We use mysql 1.23.47 as a database for our PHP based accounting
system. We use mysql_pconnect() to get a connection to the DB.
This morning we couldn't log in because mysql sent back a 'too many
open connection!' (or
On Mon, Mar 04, 2002 at 12:25:44PM +0100, Angela Harneit wrote:
I've a question concerning negations of regular expressions - e.g. I
want the sentence this is nice to match, while the sentence this
is not nice should not match. I only found possibilities for the
negation of single
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa [EMAIL PROTECTED] writes:
Description:
LOAD DATA LOCAL INFILE ...
leads to 'The used command is not allowed with this MySQL version'
This happens regardless of whether I have a
local-infile = 1
in my /etc/my.cnf.
Is this a true export? Because I've never had garbage lines in my files.
Dave
On Mon, Mar 04, 2002 at 10:33:14AM -0600, Paul DuBois wrote:
At 10:58 -0500 3/4/02, Richard Bolen wrote:
I'm exporting data from Oracle and importing it into MySQL. The
problem is Oracle puts garbage lines at the
Richard,
There has been talk of this before.
(I haven't checked but) wouldn't be surprised if it's on the ToDo list
- did you know that such info is available within the manual?
If it's not, then propose such as a 'wish list'.
Regards,
=dn
- Original Message -
From: Richard Clarke
Hi to all,
I'm new using mysql. I'm trying to load data from a text file to one of my
table. This text file contains duplicate records. My question is how do you
tell mysql to delete duplicate records and load just the ones that are not
duplicate? I already tried the REPLACE and IGNORE key words
At 01:13 PM 3/4/2002 , you wrote:
On Mon, Mar 04, 2002 at 11:19:54AM +0100, Takacs Istvan wrote:
Hi,
We use mysql 1.23.47 as a database for our PHP based accounting
system. We use mysql_pconnect() to get a connection to the DB.
This morning we couldn't log in because mysql sent back a
Spambusting: MySQL
Richard,
There has been talk of this before.
(I haven't checked but) wouldn't be surprised if it's on the ToDo list
- did you know that such info is available within the manual?
If it's not, then propose such as a 'wish list'.
Regards,
=dn
- Original Message
I'm having problems restarting a MySQL server after a certain table
reached maximum capacity. I managed to dump my entire database to a flat
file before I restarted the server however when I tried to re-import my
data the operation failed. My database size set to 500M in the innodb
section of my
On Mon, Mar 04, 2002 at 02:48:06PM -0500, Natividad Castro wrote:
I'm new using mysql. I'm trying to load data from a text file to one
of my table. This text file contains duplicate records. My question
is how do you tell mysql to delete duplicate records and load just
the ones that are not
I am currently implementing a database-ran webserver dll:
Info:
Ms Visual C++
MySQL ++ 1.7.1
MySQL-nt 3.23.47
MyISAM db.
3or 4 Queries in the application
Biggest Query:
66,000 records
using LIKE something%
Question:
I am currently using a connection every time I query, but since this is a
I have the same problem (silent install). In details:
I run setup.exe with command line options -r to create response file needed for silent
installation in InstallShield.
By default it is created in the windows directory with name setup.iss.
Then I move this setup.iss to the same folder as
I'm new using mysql. I'm trying to load data from a text file to one of my
table. This text file contains duplicate records. My question is how do you
tell mysql to delete duplicate records and load just the ones that are not
Why not just filter the data through uniq first?
Erik,
this is probably not a bug.
Your log files probably are not the ones which belong together with the
current data file(s).
When you start the database it tries to use the obsolete log files in
recovery.
From the manual:
If something goes wrong in an InnoDB database creation, you should
On Monday 04 March 2002 03:21 pm, Heikki Tuuri wrote:
Erik,
this is probably not a bug.
Your log files probably are not the ones which belong together with the
current data file(s).
When you start the database it tries to use the obsolete log files in
recovery.
From the manual:
If
Short version: I have 2 identical tables and I created a merge table to query them all
at once (v 3.23.47). I can select on only two of the four keys in the table.
Attempts to select data from the merge table WHERE column = xxx always return 0 rows
for the other two keys. Queries using
Hello,
I am trying to get an accurate (nearest 15 minutes would be
fine) difference between two times that I have in my database. They are
both of type time, and are in the format 00:00:00.
For example, if I want the difference between 09:20:00 and 10:43:00, I
would like it to give me 01:23:00
Using MySQL 3.23.40
App is logging db with 130 clients to a central MySQL db
with 2 million events per day. Aged events of over 7 days
are no longer required. The central table is myisam type
with fixed size (datetime, enum and foreign keys only).
Selects are done infrequently while inserts are
Thank you very much!! that was very helpful. By the way, is there any other
way to get rid of duplicate records from a text file?
Thanks again
Nato
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 3:00 PM
To: Natividad Castro
Cc: [EMAIL
I have the same problem using Linux RedHat 7.2. Just what do I have to
configure my binary MySQL : Ver 8.23 Distrib 3.23.49a, for pc-linux-gnu on
i686?
The rest of MySQL works as advertised.
Regards Tom Birchmire
Michael Widenius [EMAIL PROTECTED] wrote:
Hi!
Sinisa == Sinisa
Hi!
One of the users on a webserver I'm running are having some serious
problems connecting to the MySQL server. He get's the following error:
mysql error: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug.
Hi!
This is the test table:
DROP TABLE IF EXISTS asinfo;
CREATE TABLE asinfo (
asinfoID int(10) unsigned NOT NULL auto_increment,
art char(1) binary NOT NULL default '',
KNR char(5) NOT NULL default '',
RECHNR char(6) NOT NULL default '',
POSNR char(2) NOT NULL default '',
ARTNR
lastout and firstin contain times such as 13:28:01 and 13:27:54.
If I use the query you gave me from within phpMyAdmin, the result I get is
7 seconds, exactly what it should be...but I do not know how to use PHP to
get the correct result, it is giving me 23. I am accustomed to using
mysql_result
1 - 100 of 142 matches
Mail list logo