In what way is it mangling my query?
and why won't the same query work from my php script.
I would accept this if it was just any interface but myphpadmin is supposed to be in
line with mysql standards.
update cdrequest set albumfill = hot shots II, releasedatefill
= 20010708 where requstID
try mssql2mysql; this is a VB/VBA script which can connect directly to
MySQL, thus eliminating the need of temporary files
http://www.kofler.cc/mysql/mssql2mysql.html
Best wishes,
Michael Kofler
-
Before posting, please
On Fri, Aug 10, 2001 at 02:19:21AM -0400, Julian Simpson wrote:
In what way is it mangling my query?
and why won't the same query work from my php script.
I would accept this if it was just any interface but myphpadmin is supposed to be in
line with mysql standards.
update cdrequest set
Hi,
Whats the most efficient way of doing a SELECT ... IN on a field of
datatype 'SET' ?
Say you have four types of 'permissions':
- superuser
- poweruser
- normal
- guest
Each user has a field, permissions, of type SET
(superuser,poweruser,normal,guest);
In what way is it mangling my query?
and why won't the same query work from my php script.
I would accept this if it was just any interface but myphpadmin is supposed to be
in line with mysql standards.
update cdrequest set albumfill = hot shots II, releasedatefill
= 20010708 where
On 10-Aug-2001 Julian Simpson wrote:
In what way is it mangling my query?
and why won't the same query work from my php script.
I would accept this if it was just any interface but myphpadmin is supposed
to be in line with mysql standards.
update cdrequest set albumfill = hot shots II,
On 10-Aug-2001 [EMAIL PROTECTED] wrote:
Hi,
Whats the most efficient way of doing a SELECT ... IN on a field of
datatype 'SET' ?
Say you have four types of 'permissions':
- superuser
- poweruser
- normal
- guest
Each user has a field, permissions, of
On 10-Aug-2001 Bennett Haselton wrote:
Is there any way -- using either MySQL directly, or (ideally) using the DBI
perl module -- to get a list of fields from a (possibly empty) table? (If
the table is nonempty, you can just use a perl function to get the first
record, and then apply
Excuse Me,
I'm a starter to Linux.
I've downloaded the MySQL-3.23.40-1 for my Linux OS.
They are in .rpm form. How can I install the software properly on Linux?
I try to follow the instructions mentioned in manual.txt but it didn't work.
Can you help me and tell my how to install it via RPM?
Corin Hartland-Swann wrote:
Hi there,
I am trying to optimise MySQL for use on a machine with:
Linux 2.4.7-ac9 (only kernel to work with the disk controller)
Dual Pentium III 1000 MHz
4096 MB memory
RAID-1 Mirror over two 76GB 7200 RPM UDMA disks
Reiserfs partition for
rpm -i mysql.rpm ?
louie miranda (axishift.ath.cx)
---
Security is not a product - It is a Process
- Original Message -
From: Alan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 10, 2001 3:45 PM
Subject: Installing MySQL on Linux 7.1
On Fri, 10 Aug 2001, Alan wrote:
I'm a starter to Linux.
I've downloaded the MySQL-3.23.40-1 for my Linux OS.
They are in .rpm form. How can I install the software properly on Linux?
I try to follow the instructions mentioned in manual.txt but it didn't work.
Can you help me and tell my how
Hi!
On Aug 10, Carsten H. Pedersen wrote:
http://www.mysql.com/doc/U/s/User_names.html
says:
MySQL encrypts passwords using a different algorithm than the one used
during the Unix login process. See the descriptions of the PASSWORD() and
ENCRYPT() functions in section 6.4.12
On Thursday 09 August 2001 17:58, Bernhard Doebler wrote:
I have a select statement and want to add a Percent sign to the output of
one expression. Do I have to use Concat-function or is there another way
(for only one character)?
AFAIK concat is the only way in MySQL, viz:
SELECT
Hi,
I try to optimize my tables. To see possible errors I use SELECT statements with
PROCEDURE ANALYSE. I have a table that holds unique strings and an index by whitch
it's referenced to another table. PROCEDURE ANALYSE advises as datatype for the
strings to take an enum of
Luc Foisy wrote:
We are looking for a solution to backing up a remote database, without using
mysqldump, and replication seemed to offer the solution required.
I set up the master/slave configurations on both the master and the slave
exactly the way it was shown in the MySQL documentation
Hi,
Since yesterday I'm reading all I can find on MySQL to solve my problem.
in mysql :
mysqlselect now();
+-+
| now() |
+-+
| 2001-08-10 07:28:56 |
+-+
1 row in set (0.00 sec)
But on the system : (Linux Red Hat 7.1)
On Thu, Aug 09, 2001 at 02:45:23PM +0800, Alan wrote:
Excuse Me,
I'm a starter to Linux.
I've downloaded the MySQL-3.23.40-1 for my Linux OS.
They are in .rpm form. How can I install the software properly on Linux! =
I try to follow the instructions mentioned in manual.txt but it didn't =
Hi!
On Aug 10, Bernhard Doebler wrote:
Hi,
I try to optimize my tables. To see possible errors I use SELECT
statements with PROCEDURE ANALYSE. I have a table that holds unique
strings and an index by whitch it's referenced to another table.
PROCEDURE ANALYSE advises as datatype for the
Date |Thu, 9 Aug 2001 10:36:59 +0800
From |Steve Doig [EMAIL PROTECTED]
Hello!
SD $link = mysql_connect(mySQL_test, mysql_login, mysql_password)
SD or die (Could not connect);
SD print (Connected successfully);
SD mysql_select_db (test)
SD or die (Could not select database);
I think you need
Date |Thu, 9 Aug 2001 10:38:09 +0800 (CST)
From |[EMAIL PROTECTED]
Hello!
T Dear sir,
T I have a problem, I run the MYSQL GUI on my Server, but it always say that Can't
connect to local Mysql through socket (111)
This message tell what you try connect to local mysql and does'nt set
up
Date |Wed, 8 Aug 2001 23:02:26 -0400
From |Wendell Dingus [EMAIL PROTECTED]
Hello!
WD Right after that last C is my # command prompt with no line-ending character
WD in the file. It gets part way through the describe of the table layout and
WD stops. Using phpMyAdmin I can view everything just
Date |Thu, 9 Aug 2001 14:45:23 +0800
From |Alan [EMAIL PROTECTED]
Hello!
A Excuse Me,
A I'm a starter to Linux.
A I've downloaded the MySQL-3.23.40-1 for my Linux OS.
A They are in .rpm form. How can I install the software properly on Linux! =
A I try to follow the instructions mentioned in
Date |Thu, 09 Aug 2001 23:54:16 -0400
From |Bo Green [EMAIL PROTECTED]
Hello!
BG The source package for mysqlgui Makefile references an
BG object 'edfile' which is not included in the source package
BG (at Aug 9, 2001). When I try to compile without that object,
BG I get a missing function
Date |Thu, 9 Aug 2001 20:58:14 -0300 (ART)
From |Raoni Novellino [EMAIL PROTECTED]
Hello!
RN I installed MySQL 3.23.40 perfectly without
RN ploblems... but I installed MySQL for database to PHP
RN 4.0.6 with Apache 1.3.20... but when I compile Apache,
RN this error ocours:
RN === src/modules
Date |Thu, 9 Aug 2001 14:33:37 -0400 (EDT)
From |sachin shetty [EMAIL PROTECTED]
Hello!
SS Hi
SS i think this isnt a purely mysql specific question but surely related. I
SS have a stick bit set on the /tmp directory(Solaris) where the socket file
SS resides.But there is no protection on the
Hi everyone.
I uninstalled mysql and reinstalled using --with-innodb configuration.
After install completed, I entered the command mysqladmin variables and
found that value of have_innodb is DISABLED.
So when I create table with type=InnoDB, this table has type=MyISAM. That
is failure to create
Michael T. Babcock writes:
I've been reapplying transactions to my aforementioned screwed up database.
It seems however, that the binary transaction log doesn't quite work
properly
with user variables (with MySQL 3.23.38). I have this entry from the log:
insert into Projects (ParentID,
Hello ½ÉÃ溸,
Friday, August 10, 2001, 2:27:56 PM, you wrote:
DISABLED means you're running with --skip-innodb AFAIK :)
½ Hi everyone.
½ I uninstalled mysql and reinstalled using --with-innodb configuration.
½ After install completed, I entered the command mysqladmin variables and
½ found
Jeff Tanner writes:
mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown
linkage type in dependency graph
1 fatal error
Ideas?
Thanks
Jeff Tanner
Seattle, WA
Your C++ compiler is broken. Please re-install entire GNU 2.95.2 suite.
--
Regards,
__ ___
At 19:27 10/08/2001 +0900, =?euc-kr?B?vcnD5rq4?= wrote:
Hi!
Are you set the my.cnf file for the InnoDB variables and
created the data and log directories before the start
of the server ?. Take a look in the server_name.err file
if you find the message of InnoDB mentioning that wasn't
be able to
David Ross writes:
Is the freebsd-elf mysql binary available at mysql.com compatible with
BSD/OS (bsdi) 4.1? If not, is there a place to download this
binary...or am I stuck with building it myself?
Thanks,
David
You should build it yourself.
Just follow instructions from the manual.
Hello,
Today, I tried to move a part of one of my websites, a forum (vBulletin,
www.vbulletin.com) to a new server: a FreeBSD server. I installed the package
mysql-3.23.40-unknown-freebsdelf4.3-i386.tar.gz on that server, and everything seemed
to work perfectly: installation complete, and
I have fltk, flvw, fleditor and the mssql++ libraries linked in, I'm
pretty sure
this is not the answer, but I could be wrong...
Bo
Grigory Bakunov wrote:
Date |Thu, 09 Aug 2001 23:54:16 -0400
From |Bo Green [EMAIL PROTECTED]
Hello!
BG The source package for mysqlgui Makefile references
Hello All
I'm new to MySQL although I have experience with SQL Server and MS Access.
My current ISP offers MySQL and I would like to make it possible for one of
my customers to transfer there data from MS Access to MySQL. This is fine
and I know how to do this using ODBC(). But then I
Hi,everybody!
I want to write a Client GUI DBMS for Mysql,but I don't know how to start.
Anyone can tell me about the API,how to get it,how to begin?
(I should use create,drop,insert,delete,update...)
thank you very much
Hi,
I've just seen when the maximum connection number is reached and you try to shutdown
MySQL with mysqladmin shutdown, it couldn't be executed because of too many
connections error.
It would be smarter if mysqladmin could shutdown MySQL whatever the number of
connections, even if the
37 matches
Mail list logo