I am running a web site which runs perfectly on my Unix web hosted site. I
have just moved it over to W2K and have undefined variable errors ... my
thought is that mysql 3.23.24 for Windows may not support undefined
variables and on unix they are supported.
Any thoughts on how to get this fixed?
Hello mysql,
I've installed the MySQL from RPM version 3.23.32. Then, I install
also php4.04 from source with option --with-mysql without giving the
path-to-mysql information. It works so far but I get the following
information when using the phpinfo() :
mysql
MySQL Support
Why does it give the old version number ? Have I done something wrong
? Should I put --with-mysql=/path/to/mysql ?
Yes, you should. If you leave out the path, PHP uses a MySQL library shipped
with the PHP source code. You should have gotten a warning after the
./configure for PHP, explaining
Hi!
i use mysql for windown version and i have this problem,
as i know the mysqlGUI is a graphical tool to help you to make tables fields and other
thinks for your database.
I can change the password ,give sql commands but from the menu commands-tables it
doesn't work create table, edit table
Hi,
Im not sure but:
Is it safe to assume that row[0] and row[1] are valid (ie not NULL and not
garbage)!(?)
...
row = mysql_fetch_row(res);
printf("[%s:%s]\n", row[0], row[1]);
...
mysql_data_seek(res, 0);
...
row = mysql_fetch_row(res);
printf("[%s:%s]\n",
Hi!=20
i use mysql for windown version and i have this problem,
as i know the mysqlGUI is a graphical tool to help you to make tables =
fields and other thinks for your database.
I can change the password ,give sql commands but from the menu =
commands-tables it doesn't work create table, edit
i want to replace all occurences of www to http://www in all columns of a
table.
the column contains blocks of text.
is there any way to do this directly in mySQL?
thankx. =)
---
Stephen U. Lee
Folks,
I am totally new to databases, haven't got the foggiest of what's going on here. I
have downloaded and installed MySQL 3.23.29 a while back, but I still don't know how
to even configure it, even though I have read several articles about using it, and
consulted our webmaster, but he's
I have a primary key listed as ID
When I first added about 10 records and then deleted a few records and
then added more records it didn't replace the missing records.
When I select all records to view I now get:
1
2 why didn't it go to 3, 4 and 5 after 2?
6
7
8
When I add a record it
I have not been able to figure this out, yet. I found the file
/usr/share/mysql/make_binary_distribution and tried a make on it; no
luck. I scoured the documentation on the web and in my own distribution
and have not been able to find out what to do next. See Below. I would
appreciate getting
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]
Description:
INSTALL-BIN
I have not been able to figure this out, yet. I found the file
/usr/share/mysql/make_binary_distribution and tried a make on it; no
luck. I scoured the documentation on the web and in my own distribution
and have not been able to find out what to do next. See Below. I would
appreciate
When I first added about 10 records and then deleted a few records and
then added more records it didn't replace the missing records.
That's MySQL's usual behaviour. auto_increment only garantees to create
unique keys. "Holes" left by deleting data are not filled.
Jens
Hello,
We're using MySQL on a small local area network with an average of 4
clients hitting the database with SELECTS, INSERTS and UPDATES. We're
using a Win2K file server with UDMA/100/7200 HD's and 256 MB Ram. Each
client is accessing the DB through MyODBC. Actually it's a VB6 App using
I can understand not wanting to have holes, but..
If it is a primary key, how are you going to handle updating tables that
rely on that key id?
If your id numbers were to shift, like you want, and you had a related sub
table (one to many) and this was say, an shopping cart, then all of a sudden
How would you actually overcome that? Wouldn't it be good if MySQL would be adapted to
actually do this for you?
-- Kobus
"Jens Vonderheide" [EMAIL PROTECTED] 2001-04-08 19:25:48
When I first added about 10 records and then deleted a few records and
then added more records it didn't
No, what is meant here is that:
He has record 1 2 3 and 4. Now deletes 2 and 3. Now create 2 new records. MySQL
creates them as 5 and 6, instead of 2 and 3 again...
--Kobus
Lindsay Adams [EMAIL PROTECTED] 2001-04-08 19:42:12
I can understand not wanting to have holes, but..
If it is a
rpm -qa | grep mysql
if nothing found,
rm -rf /usr/local/var
rm -rf `find /usr/local/bin/ | grep mysql`
rm -rf /etc/my.cnf
This should catch about everything.
cheers,
roel
On Sun, Apr 08, 2001 at 12:24:08AM -0400, David Loszewski wrote:
how do I uninstall MySQL 3.22 after installing it?
Probably should change that first line to
rpm -qa | grep -i mysql
Roel Vanhout wrote:
rpm -qa | grep mysql
if nothing found,
rm -rf /usr/local/var
rm -rf `find /usr/local/bin/ | grep mysql`
rm -rf /etc/my.cnf
This should catch about everything.
cheers,
roel
On Sun, Apr
I don't know if the manual says anything about this but if you check Paul's book page
150 (paul now we are referencing your book down to page level) it says:
"creating a table by selecting data into it does not automatically copy any indexes
from the original table"
regards,
thalis
On Sun,
On Sun, 8 Apr 2001, John Hart wrote:
I am working on a rather large database project, in which I am making a text column
that contains different data, seperated by commas. What I need to do is run a query
where I will return only the datasets that contain any of sets that partially, or
How would you actually overcome that? Wouldn't it be good if
MySQL would be adapted to actually do this for you?
I think that not reusing deleted numbers is easier (i.e. more efficient).
IIRC, earlier versions of MySQL in fact reused the numbers.
There are 2 ways to overcome this:
1) Check
Hi
At 18:13 08/04/2001 +0200, Kobus Myburgh wrote:
Folks,
I am totally new to databases, haven't got the foggiest of what's going on
here. I have downloaded and installed MySQL 3.23.29 a while back, but I
still don't know how to even configure it, even though I have read several
articles
anyone know where (or even just how-to) find info on getting mysql to
start with system boot?
thank you in advance.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Sun, 8 Apr 2001, Stephen U. Lee wrote:
i want to replace all occurences of www to http://www in all columns of a
table.
the column contains blocks of text.
is there any way to do this directly in mySQL?
Check the manual for the infinite String manipulation functions.
If all your
You can do the same thing with like:
where concat(",",myField,",") like "%,$searchString,%"
this will of cause be somewhat slow, how about normalizing your database:
header(id,fields)
type(id,dataset)
header(1,)
type(1,black)
type(1,dark)
...
now you can select * from header,type where
Description:
when doing a select replace(fieldname, 'lookforstring', 'replacestring'), the
replace never occurs. It works fine if searching on a static string. The behaviour is
correct on my Red Hat machine.
How-To-Repeat:
- easy to repeat (bug was in 3.22.23 as well) - just try
Hi,
I have compiled mysql 3.23.36 from tarball source under debian. So I try to
modify some defaults to fit to the filesystem layout, used under debian
(2.2r2, potato, Kernel 2.4.1). All seemed to work fine. So I make a dump
from our database and insert the dump into the new system. After this I
Will mysql operate on a dual processor system under linux? Any
appreciable performance advantages?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
How I learned to love number gaps:
I have a database of colleges and universities. Every degree listing
as a numbered id. This used to be auto-incremented. After several
deletes and additions, I found it advantageous to have gaps between
schools to add new degree listings, so that I didn't
Is there an explanation somewhere about the rules mysql uses when lock
tables?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Suppose I have this:
---
mysql UPDATE blah blah...
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 1
---
How can I see the warning information, such as a detailed message?
(BTW I *did*
Hi (if needed you can find my environment setup below)
I wish to load some data files at the mysql command prompt but seem to be
failing due to Swedish characters being incorporated. Here is the error:
ERROR 1064: You have an error in your SQL syntax near 'insert into category
I'm confused, and wondering if anyone can help me.
I'm running 2 virtual servers, let's say server1.domain.com and
server2.domain.com. These virtual servers sit on servers named host1.isp.com
and host2.isp.com respectively (I hope I haven't lost anyone yet).
I have a perl script, that lists the
Ian,
I may be way off the mark here, but I've found MySQL usually starts quoting
the line from the place at which the error occurred, thus indicating it
didn't like the "insert" part. Not being able to see the preceding lines I
can only suggest it may not have an active database to write to.
On Wed, Apr 04, 2001 at 05:26:39PM +0200, Gunnar von Boehn wrote:
As I asked them why their mysql-server die so often, I got their
standard problem email-answer that claims "mysql is scaling rather
badly".
The truth is probably closer to "we are scaling mysql badly". A well
run MySQL server
Your absolutely right, my question was not clearly
specified. So here's a concrete problem:
Let's say table A has 2 fields: PRODUCT_ID (unique) and
PRODUCT_NAME,
table B has 3 fields: PRODUCT_ID,COMPANY_ID and
LAST_PRODUCTION_DATE,
and finally table C : COMPANY_ID and CONTACT_INFO
Table A is the
--- [EMAIL PROTECTED] wrote:
Hello, I'm new to MySQL and have ran into a
problem in
designing my database. I have a table of items, A,
and
each item should have any number of other records
from
another table, B, associated with it. I also need
to
have any number of records from
Description:
Programs, compiled with mysql++ on that machine, abort with a
segfault at an attempt to connect to the mysql server, while
programs using Mysql C API (for instance, mysql's own
benchmark suite) and the same programs executed on a local
Linux
that worked, thx
I also installed PHP4, should I uninstall that? I installed it as a tar. and
if so how do I do it?
Dave
-Original Message-
From: Steve Ruby [mailto:[EMAIL PROTECTED]]
Sent: Sunday, April 08, 2001 7:46 PM
To: David Loszewski
Subject: Re: uninstalling MySQL
If rpm
Hello,
Is there a new wildcard character in 3.23? I am trying to use the grant
statement
GRANT ALL ON DATA.* TO user1@% IDENTIFIED BY "password"
It doesnt seem to like the % as it returns an sql error
Thanks for your time,
Scott
On Sun, 8 Apr 2001, Realbad Atgames wrote:
--- [EMAIL PROTECTED] wrote:
Hello, I'm new to MySQL and have ran into a
problem in
designing my database. I have a table of items, A,
and
each item should have any number of other records
from
another table, B, associated with
I have a (dumb!) program that performs SELECT statements with a quote around
the table and the fieldname; see the portion from the trace log below:
Cardfivefffe35e1:fffed875 EXIT SQLExecDirect with return code -1
(SQL_ERROR)
HSTMT 0x00cf17ac
UCHAR *
Hi,
Just a guess, but I expect that the first response will be to use gcc 2.95.2
or later
Quentin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, 9 April 2001 1:30 p.m.
To: [EMAIL PROTECTED]
Subject: REXEXP in select only works with short expressions
Description:
When one uses the "alter table tbl_name rename [to] new_tbl_name" command, it works
when "to" is not included in the command, but says there is an error in the SQL syntax
when "to" is included. My understanding is that "to" is optional and it should work
both ways.
Hello,
Does anyone know off hand what the command is (in mySQL interactive mode )
to connect to a remote mySQL server?
Thanks for your time,
Scott
-
Before posting, please check:
http://www.mysql.com/manual.php (the
I was wondering if there is a tool or special way to merge all of the
contents of Filemaker Pro 5 files so they can be used in mySQL.
Here is my scenario: Currently I have a fileserver for my website that uses
FileMaker 5 and I am looking to merge those attributes and settings so they
can be
Mysql has many command line options. Try mysql --help for a list, and you
will see that the -h option is used to specify the host.
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit
First, things, first - I am a newbie to MySQL but I have it up and running quite well.
The only thing I haven't been able to figure out is why I'm losing "\" (back slashes)
in my stored data. I have a application I'm considering MySQL for and one table must
have a column containing a UNC
On Sun, Apr 08, 2001 at 10:34:17PM -0600, Jack A. Tinsley Jr. wrote:
First, things, first - I am a newbie to MySQL but I have it up and
running quite well. The only thing I haven't been able to figure
out is why I'm losing "\" (back slashes) in my stored data. I have
a application I'm
You need to escape it with another "\". Look up the manual about escaping
special chars.
- Original Message -
From: "Jack A. Tinsley Jr." [EMAIL PROTECTED]
To: "[EMAIL PROTECTED]" [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 12:34
Subject: Disappearing "\"
First, things, first - I
hi there,
i have been trying to implement replication, however the error that i
get is
ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111)
i try to do this at the linux prompt at the slave with mysql-h hostname and
the same error is displayed. what could be wrong ??
thanks in
Yeah, yeah alright then...
database,sql,query
Happy?
Now for my message...
I downgraded to 3.22.xx and the same thing happened.
It seems like it's something else.
Slackware Current.
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from
Hi there,
the error that i specifically get when the slave tries to connect to
the master is
010409 10:44:58 Slave thread: error connecting to master:Can't connect to
MySQL
server on '192.168.1.2' (111)(107), retry in 60 sec
even if i try to run mysql -h master the same error happens.
Where is your server located? On the same LAN?
You sure the mysql server is running?
- Original Message -
From: "MCA Department PESIT" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 12:48
Subject: Cannot Connect to remote host for replication
hi there,
i
On Mon, Apr 09, 2001 at 10:37:36AM +0530, MCA Department PESIT wrote:
the error that i specifically get when the slave tries to connect to
the master is
010409 10:44:58 Slave thread: error connecting to master:Can't connect to
MySQL
server on '192.168.1.2' (111)(107), retry in
Hi there,
the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes,
the master is running. the user name and password are correct. actually i
dont think it gets to the state of actually verifying the user name and
password. even if i do just a mysql -h 192.168.1.2 it gives me
57 matches
Mail list logo