I had to upgrade my SGI server to operating system IRIX 6.5.18m from 6.5.15m
after the upgrade I can access MySql from the command line but I cannot make
an ODBC connection and my web pages using mysql do not work. Other than the
OS upgrade no other changes were made. I have tried reinstalling the
(It sucks; sql,query,mysql,...)
Hello folks
I need to move my database from a WindowsNT environment to a Linux
RedHat7.0 Box. I am now using innodb tables. Is there any easy way of
copying my existing tables in NT Box to Linux?
Thanks for any suggestions
Dear Listers,
This is presenting a challenge to my SQL skills of how to attack this,
hopefully someone else might be able to help point me in the right
direction.
I'm building an application to track sports contests. Essentially players,
each of whom are members of a specific club, guess every
Is anyone else seeing it take 4-8 hours for mail to get thru this list
recently?
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
[EMAIL PROTECTED] | http://jeremy.zawodny.com/
MySQL 4.0.8: up 5 days, processed 145,791,837 queries (323/sec. avg)
And does anyone know what column type I should use if I want a precise
calculation?
I've even tried with text and blob, but they are not working either.
Only the int type is precise?
Thanks.
Teddy,
Teddy's Center: http://teddy.fcc.ro/
Email: [EMAIL PROTECTED]
- Original Message -
From:
you can get all you need from here.
http://www.mysql.com/articles/dotnet/index.html
-- Jeffrey Powell [EMAIL PROTECTED] writes:
Return-Path: [EMAIL PROTECTED]
Received: from mx06.lax.untd.com (mx06.lax.untd.com [10.130.24.66])
by maildeliver04.nyc.untd.com with SMTP id
Dear Helpers,
I want to check one column name is present in how many table in a
databse , and name of those tables. does mysql supports this function ?
Ex :
Tables
1 Item master
columns are ItemID, ItemName
2 Item details
okay - mysql build is killing me here ..
when I run mysql_install_db, gives me the following error
ERROR 1064 : use mysql; INVALID SYNTAX
I cannot get mysqld to start - it keeps saying
ERROR: 1064 syntax error near '' at line 1
what is goign on here ...
How do I download and install My SQL for Mac OS 9?
Thanks, Jonas
*-*-*-*-*-*-*-*-*-*-*-*
Jonas Rosenbloom
1042 Shirley Drive
Henderson, NC 27536
Phone: 252-492-5754
[EMAIL PROTECTED]
*-*-*-*-*-*-*-*-*-*-*-*
-
Before posting,
sql,query,queries,smallint
What became of the discussion between Open Office.org and Monty at LWE?
Ruben
--
__
Brooklyn Linux Solutions
__
DRM is THEFT - We are the STAKEHOLDERS http://fairuse.nylxs.com
http://www.mrbrklyn.com - Consulting
I thought sub-select is a 4.x feature..
-- Frank Peavy [EMAIL PROTECTED] writes:
Return-Path: [EMAIL PROTECTED]
Received: from mx6.nyc.untd.com (mx6.nyc.untd.com [10.140.24.66])
by maildeliver03.nyc.untd.com with SMTP id AAA9DBZJZAVXT492
for [EMAIL PROTECTED] (sender
On Wednesday 22 January 2003 20:28, gordon at hammy dot lonestar dot org
wrote:
Description:
The following silly query (silly because it should return no
records since it is impossible for a.type to have two different
values simultaneously), returns two records when it
Hi Gelu,
I agree with you, and it's an excellent suggestion.
On the other hand, I am generally interested in whether or not it's
within my abilities / available toolset to do this, and it would allow
me to develop far more specific / personalised 'synchronisation'
processes.
Anyone have any
Stefan,
The problem look be solved;
i've just changed structure of the updatable table.
First this table have only 1 primary key, now my table have some indexed unique keys.
and now if i do a replace into command look's like to work fine.
I have just a question:
i need also to change
how to insert only blank spaces into a field using insert query. Its getting
trimmed off.
Regards,
Murthy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 3.23.55, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that
sql,query,queries,smallint
how to insert only blank spaces into a field. Its getting trimmed off.
Regards,
Murthy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Shashi,
please send these general MySQL questions to [EMAIL PROTECTED]
Thank you,
Heikki
sql query
- Original Message -
From: N Shashidhara [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 24, 2003 7:37 AM
Subject: Column present in diffrent tables
Dear Heikki,
* Justin French
I have four (relevant) tables:
category
partner(pid,pname,etc)
service(sid,sname,cid)
sid2pid(sid,pid)
This works fine, listing all services available within a category:
SELECT service.sid,service.sname
FROM service
WHERE cid='3'
ORDER BY service.sname ASC
eg:
Hi.
- Original Message -
InnoDB appears to be losing records.
The version I am using is 3.32.53 in Windows 2000.
Gaps are appearing in the autoincrement sequence when
the application does not permit record deletions.
Records disappear although they have been retrieved
for
Hi everybody:
I 'm actually having an problem trying to mygrate to mysql. it's true
that mysql does not support bind variables ? . Actually the development
in my company is over Centura team developer connected to Centura
Sqlbase , and the code of the aplications is widely using bind
Hi!
InnoDB is a MySQL table type which supports transactions, foreign key
constraints, and a non-free hot backup tool.
Version 3.23.55 is a bugfix release of the stable 3.23 branch, which is
recommended for production use.
Users who have had concurrency problems in INSERT INTO ... SELECT ...
You state that you searched the web and the documentation, but did you
search the MySQL manual?
4.2 General Security Issues and the MySQL Access Privilege System
http://www.mysql.com/doc/en/Privilege_system.html
4.3 MySQL User Account Management
You mean like your inquiry which took 8:01:27 between the time you sent
it and when it hit my mail server?
Doug
On Thu, 23 Jan 2003 20:44:56 -0800, Jeremy Zawodny wrote:
Is anyone else seeing it take 4-8 hours for mail to get thru this list
recently?
Jeremy
--
Jeremy D. Zawodny | Perl,
Robert,
yes, if there are multiple UNIQUE keys in a table, then in the REPLACE
implementation there is a loop which DELETEs all records which have
conflicting UNIQUE key values.
Since you have kept the binlog of your database, you can rerun the SQL
statements and try to find where your rows
If you have the option to change the table structure, just replace
the date and time columns with a timestamp column.
If you must keep the current structure then the following wil
work, but it will not use indexes in the search:
select ...
where concat(today,' ',heure1)
hi all,
i wanted to know how best i could create indexes on a given table.
My database is not normalised, so i have a huge transaction table that i
used to generate my reports.
The thing is that there are at least 5 fields that i can use as indexes in
my queries, to speed them up.
Do you think
* Murthy
how to insert only blank spaces into a field using insert query.
Its getting trimmed off.
The spaces are automatically trimmed off of CHAR and VARCHAR fields, because
they are normally not wanted. You can use TINYTEXT or TEXT to avoid this
trimming.
URL:
Are you using a field of type CHAR or VARCHAR ?
You should use a TEXT field instead.
According to the documentation (http://www.mysql.com/doc/en/BLOB.html) :
There is no trailing-space removal for BLOB and TEXT columns when values
are stored, as there is for VARCHAR columns.
Hope this helps,
--
Good morning everyone,
I'm running short on harddrive space on my Windows
computer. What's the best way to get the smallest
dump file in one step in Windows XP?
On my FreeBSD computer, the following command produces
an 808MB dumpfile from an 11GB database in one step:
mysqldump -q -uusername
Murthy,
how to insert only blank spaces into a field using insert query. Its
getting
trimmed off.
If you are using VARCHAR for this, you're right. It's a documented
behaviour of MySQL (Values are not padded; instead, trailing spaces are
removed when values are stored. (This space removal
Fabrizio,
(still only guessing, as you did not post the table structures ...)
i need also to change structure of the master table (have only a
primary key) or
the changes made on the updatable_table are enough?
Your updatable_table needs to have a unique key (best is a primary
key), so
You can't. The only reason you can get MySQL for OSX is because of it's
Unix underpinnings which made it possible to port MySQL to OSX. MySQL
would have to be completely rewritten to run under OS9.
If you want to use MySQL on a Mac, you need to have at least one OSX
box. You could then design
I noticed a lag yesterday...but simply attributed it to our internal mail
setup (which is bad in oh-so-many-ways).
Peter
^_^
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 23, 2003 11:45 PM
To: [EMAIL PROTECTED]
Subject: High list latency?
Is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Murray --
...and then M Wells said...
%
...
% On the other hand, I am generally interested in whether or not it's
...
%
% Anyone have any thoughts on how this could be achieved?
You could always read the mysqld source code and see how it does it
On Friday 24 January 2003 01:29, Jeffrey Powell wrote:
I am preparing to migrate a client from using a large MS-ACCESS database to
using a linux hosted MySql as the datasource. Or at least I'd like to be
able to export tables as a backup.
Please tell me where I can get a driver.
Take a look
On Friday 24 January 2003 06:24, kayamboo wrote:
I need to move my database from a WindowsNT environment to a Linux
RedHat7.0 Box. I am now using innodb tables. Is there any easy way of
copying my existing tables in NT Box to Linux?
You can use mysqldump utility.
For more info check the
Looking for someone who is willing to write a mysql script(?) for a
website database.
The database has been created. Just need someone to write the
programming.
Will send more information if needed.
Doll
-
Before posting,
sub-selects are not yet (to the best of my knowledge) supported in MySQL.
=C=
*
* Cal Evans
* Techno-Mage
* http://www.calevans.com
*
- Original Message -
From: Frank Peavy [EMAIL PROTECTED]
To: Doug Coning [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 23, 2003 6:24 PM
Hi,
If i undertsand well you wish to make an application which to
synchronization data between your local MySQL with the MySQL which is on the
Web Server.
I think you must have distinct connection to be able to pass the data from
one server to other.
I think you can do this with VB(..using
Any calculation involving a floating point number will be imprecise.
It does not mater what column types are involved.
Octavian Rasnita wrote:
And does anyone know what column type I should use if I want a precise
calculation?
I've even tried with text and blob, but they are not working
Hi.
The below problem isn't realy MySQL problem, but is somehow colegated with
MySQL, so please look below ;)
I got a task to program a search engine for a site which is all around
based on sessions and persistent connections to MySQL.
The problem is that I first have to select a subset of
Unfortunately, we cannot - it's a production environment that runs 24 x 7 (telco) and
we cannot do this without major difficulty.
Is there a general cause of this SIGALRM - is thread 4 significant?
Thx,
R
On Wednesday 22 January 2003 16:34, rick wrote:
I'm running mysql 3.23.42 on multiple
It doesn't appear to build. This is on a RedHat 8 machine with all
current patches applied from RedHat and kernel 2.4.18-19.8.0 Any
ideas?
# rpmbuild -bb --target i686 mysql-4.0.9-gamma.spec
(snip)
rm -rf .libs _libs
rm -f *.lo
rm -f Makefile bdb/Makefile stamp-h stamp-h[0-9]*
rm -f config.h
On Thu, 23 Jan 2003, Jeremy Zawodny wrote:
Is anyone else seeing it take 4-8 hours for mail to get thru this list
recently?
Yes. The message that I sent in yesterday (and that you replied to, which
-WORKED-, by the way! Thank you!) was sent at 12:55EST and I got it back
from the listserv at
1st problem:
SELECT F.id,
F.title,
F.description,
F.created,
(select count(*) from forum F, topic T where F.id=T.forum_id AND
T.reply_id=0 ) count1,
(select count(*) from forum F, topic T where F.id=T.forum_id )
count2
I need to move my database from a WindowsNT environment to a Linux
RedHat7.0 Box. I am now using innodb tables. Is there any easy way of
copying my existing tables in NT Box to Linux?
Download MySQLFront from:
http://mysqlfront.sstienemann.de/
Install it on your windows machine and log in to the
Rogger,
- Original Message -
From: Rogger Vasquez [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, January 24, 2003 4:43 PM
Subject: Re: MySQL/InnoDB-3.23.55 is released
How do I upgrade from a previous version of mysql, to the
Heya Folkth:
I have built mysql (4.0.9) on freebsd (4.7-RELEASE) with linuxthreads
(2.2.3) and still encounter the 'strange threading' behavior described in J.
Zawodny's blog.
Here's the situation...
1/ there are three threads which lock and then write to two different
tables...the locks are
Hi,
With MySQL you can use variables which are represented using @ character.
You can not use this variable like in Oracle or DB2 because ,for the moment,
MySQL didn't have necessary tools which can handle like bind, this
variables.
I guess you can make some improvisations to suit at your needs.
To update on the threading problem that I see even with Linuxthreads on
FreeBSD...
The select thread which isn't given the read lock it requests cycles through
the states 'NULL', 'Waiting for tables', 'Locked', 'System Lock', and
'Reopen Tables' from what I've seen so far (there could be more?
In the last episode (Jan 24), Andrew Gould said:
I'm running short on harddrive space on my Windows computer. What's
the best way to get the smallest dump file in one step in Windows XP?
On my FreeBSD computer, the following command produces an 808MB
dumpfile from an 11GB database in one
Stefan Hinz, iConnect (Berlin) wrote:
Murthy,
how to insert only blank spaces into a field using insert query. Its
getting
trimmed off.
If you are using VARCHAR for this, you're right. It's a documented
behaviour of MySQL (Values are not padded; instead, trailing spaces are
' ;
The $date variable equals 20030124%
What can I do to get this range selection query to work?
Thanks,
Chuck Barnett
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hello community !!!
The software house on i'm work want to store images ( TIF FILES +/-
100kb compressed with gzip ) on database... using InnoDB database...
( files or raw devices )
The discussion is :
- The innodb ( or myisam ) is sufficient robust to allow store
10.000.000 images (
i can help you if you want
tel me what do you need exactly
On Fri, 24 Jan 2003 08:55:04 -0500
Doll Hargrove [EMAIL PROTECTED] wrote:
Looking for someone who is willing to write a mysql script(?) for a
website database.
The database has been created. Just need someone to write the
Hi,
I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on
2003-01-22.
Table schema :
CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser
CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish
SMALLINT(1),DataIntro DATE,DataIese
This looks like it was generated using mysqlbug, but actually I took
another post and pasted in the values.
Description:
The mysql_fetch_field() function returns a MYSQL_FIELD structure with
the flags field set to a value including NOT_NULL_FLAG even if the field
is an aggregate, if that
quick crash-me question
the web page lists several numbers for the performance of several databases (
MySQL sybase access). The one I'm most insterested in is
max table row length
What does that number symbolize?
The maximum number of bytes in a row? the max number of rows? what?
Absolutely it is possible (With cavaets).
The cavaets are...
1. Does you web hosting company allow external access to your MySQL
database. I do not know for sure but it looks like they might (telnet works
to port 3306).
2. Is your Mysql user set up to allow external access.
3. If
I compiled and installed mysql-max-3.23.51. Installation process seems
to go fine.
When I go to run mysql_install_db however, I get the following error :
ERROR : 1064 use mysql; syntax error
I try starting mysqld without grant tables - and I can. However, when I
connect via a client, none of
I'm using temporary tables for this but there is a problem.
Temporary tables are visible trough the entire connection. So in
future
one browser window can interact (can display) with results from
another
browser window. Does anyone have a sugestion how to solve this?
You could do something
...like usually i forget some details:
Table type is MyISAM and was created with MySQL ver 3.23.47
But if i create the table with ver.4.1 the behaviour is the same.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL
On Fri 2003-01-24 at 07:59:16 -0600, [EMAIL PROTECTED] wrote:
sub-selects are not yet (to the best of my knowledge) supported in MySQL.
To be a bit more precise: They are not supported in any stable release
of MySQL. They are going to be supported in Version 4.1, which is
still declared alpha.
Hello folks
I need to move my database from a WindowsNT environment to a Linux
RedHat7.0 Box. I am now using innodb tables. Is there any easy way of
copying my existing tables in NT Box to Linux?
1. Download MysqlFront from
http://mysqlfront.sstienemann.de/
2. Install on Windows machine.
use double with specific precision like
create table b (id double (5, 3));
then:
insert into b values (1.123, 3.14);
and then
select * from b where id 1.123;
shows only one record (3.14).
select * from b where id 1.123;
empty set.
select * from b where id = 1.123;
returns a result
Andrew,
Good morning everyone
Thanks for your optimism. It's 5 o'clock in the afternoon, here in
Berlin ;)
I tried the following in Windows; but stopped
mysqldump after the resulting file exceeded 1GB:
mysqldump -q -C -uusername -ppassword dbname
dbname.dmp
Well, Unix seems to be so much
Is the InnoDB table type available on Windows?
Darren Young
[EMAIL PROTECTED]
mysql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Hi,
I want to use the order by clause to list the birthday field by the
birthday not year. How do i do this?
example birthday=1972/02/14
How do i tell mysql to order by the day (14) only so that I can list same
birthday in a month in acending order.
Thanks
--
Mike Doanh Tran
Shuffle
Thank you very much for the speedy response.
Because of your positive attitude I'm going to try and talk my boss into
purchasing a few MySQL licences to help you with development. (the query
caching has effectively helped us to reduce hardware costs as 65% of our
queries are coming out of memory
Helloo people,
I am looking for a Windows help file (.*hlp or .*chm) or PDF file with
the MySQL manual for version 3.23.5x. Also i would like the HTML version
with multiple HTML files (tar.gz). I have been looking on the MySQL
website, but everything is version 4.0.x . Can anyone help me with
Query.
How can I unsubscribe? I tried it according to the
website, but it didn't work.
Thanks in advance,
Phil
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Dear gurus,
does someone have background information on the following problem (How
does MySQL do this?):
CREATE TABLE myisamFixed (col VARCHAR(10)) TYPE=MyISAM ROW_FORMAT=FIXED;
CREATE TABLE myisamDynamic (col CHAR(10)) TYPE=MyISAM
ROW_FORMAT=DYNAMIC;
SHOW TABLE STATUS LIKE 'myisam%';
Greetings!
I would like to know whether in MySQL I can do an online (hot) backup of
innodb type tables using a 'free' (GPL) tool. Or even if it is possible
by writing my own shell script as you can do in Oracle with:
alter tablespace tablespace_name_1 begin backup;
then use cp to copy the
Where does the mysql client store the query history information? I'm
referring to the information that it pulls up when you hit the up or
down arrow keys. There was a rather complex query that I came up with a
while ago and don't feel like 'up arrowing' all night...
Thanks,
Darren Young
Hi!
I've got the following problem with Version 4.0.9 of Mysql:
The page
http://www.mysql.com/doc/en/COMMIT.html
says:
'If you do a ROLLBACK when you have updated a non-transactional table
you will get an error (ER_WARNING_NOT_COMPLETE_ROLLBACK) as a warning.
All transactional safe tables will
Just wondering whether anyone had a working, compiled mod_auth_mysql
module for doing basic auth against a MySQL database on a Windows system
(XP to be exact). If not, has anyone ever compiled one on Windows?
I found one for Apache 2.0.43 at this site:
Just wondering whether anyone had a working, compiled mod_auth_mysql
module for doing basic auth against a MySQL database on a Windows system
(XP to be exact). If not, has anyone ever compiled one on Windows?
I found one for Apache 2.0.43 at this site:
I have an SQL query that LEFT JOINs four different tables to a main table,
based on several foreign keys.
It's returning only stories in a section that have photos,
but I need it to return all the stories in a section whether
it has a photo or not.
I think the problem is in the
WHERE
Hello community !!!
The software house on i'm work want to store images ( TIF FILES +/-
100kb compressed with gzip ) on database... using InnoDB database... (
files or raw devices )
The discussion is :
- The innodb ( or myisam ) is sufficient robust to allow store
10.000.000
Hi,
I know, it sounds a bit like a stupid question, but can I run a slave mysqld
server on the same machine? The idea of just running a slave for the purpose
of bringing it down, each night, to make a backup, is quite appealing. I now
use the hotcopy method.
Thanks!
- Mark
Hi!
On Jan 24, Gelu Gogancea wrote:
Hi,
I guess is as a bug in ALTER TABLE with MySQL 4.1,compiled from BK TREE on
2003-01-22.
Table schema :
CREATE TABLE cmdlivrare(IDCMD INT(9) NOT NULL PRIMARY KEY DEFAULT 2000,mUser
CHAR(16),Dep CHAR(4),IDCLI INT(16),FactExt CHAR(20),LivrFinish
82 matches
Mail list logo