I can sure that connection didn't overflow. But I don't
know how to check running out of socket and locking.
Can you tell me how I can check that status?
And I think the socket is right. Because the program
has no problem most of time. The problem does not
usually happen, but if happen it is cr
> 1. I found I had a RPM Install of PHP and a compiled version. (Off my book
> cdrom)
:-(( happened to me 2
> 4. I want to start from scratch but don't want to have to re-format
nah. you've rpm -e'd the rpm. I had to build from scratch to compile mysql +
php in as I couldn't find an off-the-she
Hi !
I've made a quite simple program in C using
libmysqlclient. The program runs as daemon
in Solaris 8 (sparc) and checks some values
in the database every 5 minutes.
I have only ONE malloc/realloc call in "my" code
and this code is called only when needed (when DB check
is signaling it to do
I am running mysql version 3.23.47 on a RedHat Linux 6.2 box with very
low loading. The Linux is acting as a gateway for my company which
connects to an ISP via ADSL.
The daemon safe-mysqld and mysqld keep shutting down
accasionally,especially when ADSL disconnects.
-
Have you run out of sockets ?
Max connections ?
Is the server there ?
Is this the right socket ?
Is the socket locked up ?
Andrew
-Original Message-
From: °í¼ø¹Î [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 25 April 2002 2:09 PM
To: [EMAIL PROTECTED]
Subject: Connection Failed.
I made p
$db = mysql_connect(
Fatal Error: Call to undefined function: mysql_connect()
1. I found I had a RPM Install of PHP and a compiled version. (Off my book
cdrom)
2. How can you get rid of file that you have gunziped ? in reverse, ie
'remove the following files' instead of 'install the following fi
I am currently using MySql. I am using the mm.mysql-2.0.4-bin.jar
downloaded from mysql site as the DB driver on SOLARIS. Java version
being used is Java 1.2.1
I Tested using Test programs and i found everything to be fine.
Our application creates JVM in its address space and loads Java
programs.
I made program using mysql C api, And every two minute my program
connects to mysql-server. But from time to time some error occur
accidently.
In the mysql.err file, this message was written.
020424 15:18:44 Aborted connection 2127 to db: 'dcmdb' user: 'dcmuser'
host: `10.1.10.27' (Got an error
Hi !!
> -Original Message-
> From: Michael Grover [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 24, 2002 5:51 PM
> To: Gerald R. Jensen
> Cc: [EMAIL PROTECTED]
> Subject: Re: Multi Line SQL Statements
>
>
> It's The MySQL Control Center program.
> I can take and save the sql sta
> I am not sure if the include statement is design to add mysql BINARIES or
> SOURCE CODE ??
Neither. It's eventually going to link the final php binary with
the mysql shared libraries (probably libmysqlclient).
I'm not too familiar with PHP, so I don't know if '--with-mysql=' wants
the location
Fatal Error: Call to undefined function: mysql_connect() in
/var/www/html/results.php
+ I think my PHP does not have mysql included, although I put in the
./configure --with mysql=/usr/local/mysql \
+ When I type "which mysql" it says "/usr/bin/msql"
+ So should I put:-
./configure --with-mys
> Guten Tag Donna Robinson,
Hi 2u2 sir!
and god bless your cotton socks.
> i hope this will help you..
...
it didn't but it gave me enough of a clue so that this did:
select dancedetails.coupletypes.*
from dancedetails.coupletypes
left join dancedata2.couples
on dancedetails.coupletypes.name=d
I am running mysql version 3.23.47 on a RedHat Linux 6.2 box with very
low loading.
But the daemon safe-mysqld and mysqld kept shutdown randomly,two or
three times a day.
The Linux is acting as a gateway for my company which connects to an
ISP via ADSL.
---
I am considering using MySQL for a large project that could
potentially require 10k connections (roughly 9% inserts, 1%
updates, 90% selects). If I throw enough hardware at it (i.e. dual
P4 2Ghz, 2 gigs RAM, 100 gig SCSI RAID, etc.) will MySQL handle
the load? If so, what kind of response ti
I'm not entirely sure if MySQL supports these (I assume so, but not
positive). Try these two queries instead:
To find similar:
(SELECT * FROM ddetails)
INTERSECT CORRESPONDING BY name
(SELECT * FROM ddata)
Find differences:
(SELECT * FROM ddetails)
EXCEPT CORRESPONDING BY name
(SELECT * FROM
Hi,
I am going nuts!
I am querying two databases which are very similar to find the differences
between various tables.
These two tables are 15 rows and 14 rows respectively.
Why does this work (finds all similar rows):
select ddetails.name, ddata.name
from dancedetails.coupletypes as ddetails,
Alex Pilson had this question:
> Does anyone know if there is a way to preserve the trademark
> character when importing it into to MySQL?
Have you checked your charset? That would be the first place to start,
wouldn't it?
> Using Lasso 5 I can add it through a form submission and retrieve it
Further to this, I removed the "@" symbol and got:-
Fatal Error: Call to undefined function: mysql_connect() in
/var/www/html/results.php
@ $db = mysql_pconnect("localhost", "user", "password");
$db = mysql_pconnect("localhost", "user", "password");
Ideas ? Why is it now a undefined function
+ PHP Installed and going - I can write to files, retrieve flatfiles
+ Apache running servers outpages nop probes
Trying to talk to SQL using PHP.
--
Go to SQL now
Number of books found: ".$num_results."";
?>
How can i set the default values of a datetime field in a mysql table as the
current date.
I am trying
alter table copy_tbl add create_date datetime default now() but it does not
work.
Please help.
Regards,
Harpreet Kaur
_
MSN
oops I meant "MySql < c:\sql.txt"
Jeremy Zawodny wrote:
>
> On Wed, Apr 24, 2002 at 02:32:52PM -0400, vlady wrote:
> > Hi,
> > Setting an replication for the first time, I get the following error
> > message in my slave:
> >
> > 020424 13:59:28 Slave: connected to master
> > '[EMAIL PROTECTED]:
It's The MySQL Control Center program.
I can take and save the sql statements from Mycc to a text file and
call "MySql > c:\sql.txt" and it runs fine...
wierd
"Gerald R. Jensen" wrote:
>
> Michael ...
>
> Works for me ... at the console:
>
> mysql> create table zipsta2 (zip char(5), state
On Wed, Apr 24, 2002 at 02:32:52PM -0400, vlady wrote:
> Hi,
> Setting an replication for the first time, I get the following error
> message in my slave:
>
> 020424 13:59:28 Slave: connected to master
> '[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at
> position 4
> 020424 13
Michael ...
Works for me ... at the console:
mysql> create table zipsta2 (zip char(5), state char(2));
Query OK, 0 rows affected (0.06 sec)
mysql> create table zipstates (state char(2), zip char (5));
Query OK, 0 rows affected (0.06 sec)
Put the same query in a script piped into MySQL with sam
I have a dumb Question...
When I try to enter a Multiple line SQL statement like:
create table ZIPSTA2 (zip char(5), state char(2)) ;
create table ZIPSTATES (state char(2), zip char(5));
I get this error:
[root@localhost:3306] ERROR 1064: You have an error in your SQL syntax
near '; create t
Subject: variant type
From: "deco" <[EMAIL PROTECTED]>
===
i need to have a table column holding multiple numeric values (double, int,
float, etc)... I was thinking of using a variant type for this. Does Mysql
support this?
-
At 12:23 AM +0300 4/25/02, Gelu wrote:
>Hi,
>because you must use the optional command for fields or lines :
>Eg.
>load data infile 'yourfile' into table your_table fields terminated by
>'\your_delimiter_char_for_fields' lines terminated by '\r\n';
I do. So how does that have anything to do w
Hi,
because you must use the optional command for fields or lines :
Eg.
load data infile 'yourfile' into table your_table fields terminated by
'\your_delimiter_char_for_fields' lines terminated by '\r\n';
_
G.NET SOFTWARE COMPANY
Permanent
i write a program using MyIsam,and i want uses Innodb.
the query:
select max(date_comp) as mdate from pieces
on MyIsam mdate is a date.
on InnoDB mdate is string.
win2000
delphi6
zeosdbo
it's normal?
-
Before posting, plea
On Wed, Apr 24, 2002 at 03:49:17PM -0500, JW wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Hey,
>
> At various places on the MySQL web site there's mention of 3.23.50
> and 3.23.51, and the new autoextend feature.
>
> However, the most recent on the download page is 3.23.49a.
>
I haven't found the problem, but I seem to have found the solution. If
I dump the data and re-import it (causing the index files to be
re-created from scratch), the indexes work fine. I think this problem
started when I upgraded from MySQL 3.22.30 to 3.23.44 and converted the
tables from ISA
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey,
At various places on the MySQL web site there's mention of 3.23.50 and 3.23.51, and
the new autoextend feature.
However, the most recent on the download page is 3.23.49a.
Was .50/.51 not released because of bugs or something?
- --
- -
Hi!
> "kennonward" == kennonward <[EMAIL PROTECTED]> writes:
kennonward> I have mysql installed on a linux platform. I have no problem running
every thing as root. When I try to run mysql as a user other than root, I entered
command use mysql. I get error 1044:access denied for user:
Thanks!!! for the advice it works perfectly now
on 4/24/02 2:19 PM, Don Vu at [EMAIL PROTECTED] wrote:
> make sure the directory where mysqladmin lives is in your $PATH in that
> script, i.e. add $PATH=$PATH:/usr/local/bin (or where ever it is...) in the
> beginning of your script where en
Hi,
> how can I generate a list of deltas between columns in different rows for
> the entire table?
> what I need is an sql command that does something like this:
> for N =0 to i do : select "colA of current rowN" - "colA of pervious
> row(N-1)" from tab1;
>
> ColA = floating point number.
Yo
Nick Gilliam wrote:
>
>
> Egor Egorov wrote:
>
>> Nick,
>> Wednesday, April 24, 2002, 3:59:26 PM, you wrote:
>>
>> NG> I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which
>> I am NG> unable to bet a lock on a table with any userid except root.
>>
>> NG> Here is my environment:
>>
Don't put quotes around your password.
Dion Wickander wrote:
>I set up a script to rotate my logs for mysql and cron fires it off
>perfectly the logs are rotated but when the shell script gets to the last
>line which is...
>
>mysqladmin -u usernam -p"Password" flush-logs
>
>it will not execute i
make sure the directory where mysqladmin lives is in your $PATH in that script, i.e.
add $PATH=$PATH:/usr/local/bin (or where ever it is...) in the beginning of your
script where environment variables are set.
-Don
-Original Message-
From: Dion Wickander [mailto:[EMAIL PROTECTED]]
Sent
At 12:04 PM 24/04/2002 +1000, you wrote:
>Using the commands you have offered...
>
>Egor> Your 'root' user doesn't have GRANT privilege ...
>Egor>
>Egor> You should change Grant_priv to 'Y'
>Egor> You can do this using UPDATE statement:
>Egor> UPDATE user SET Grant_priv='Y' WHERE user='root'
Don't include a from clause with the last_insert_id(), or you will get
a full table scan.
The last_insert_id will only give you the insert id for the last record
inserted.
mysql mailing list user wrote:
> Hi,
> I have a big problem with last_insert_id() query.
> I am adding records to a tabl
In the MYSQL struct in the C API, how does one access the MYSQL_FIELD data?
for example, and MYSQL struct has
MYSQL_FIELD *fields;
as a member variable. However, when I try to access any of the variables within fields
for example, mysql.fields[0].name, I get a segmentation fault.
Does anyone
Ken,
Thanks for your help. I got it working. For now I needed to reverse
engineer the database. The trickier part was the username and password.
I initially gave mysql login name. But actually you have to give either
DB owner or root.
Unfortunately we do not have support contract. Somebody p
To Mysql Team
how can I generate a list of deltas between columns in different rows for
the entire table?
what I need is an sql command that does something like this:
for N =0 to i do : select "colA of current rowN" - "colA of pervious
row(N-1)" from tab1;
ColA = floating point number.
Thanks
Does anyone know if there is a way to preserve the trademark
character when importing it into to MySQL?
Using Lasso 5 I can add it through a form submission and retrieve it
in tact, so there must be a way...
I am using LOAD DATA to import my text file...
--
<---
Hello:
I have run comparative tests using
both
python2.1 with Andy Dustman's MySQLdb-0.9.1
and
rebol/core 2.5.0.4.2
tests are on Linux RH 7.2, 1.4 Ghz machine Gig RAM
comparative commands:
insert db "SELECT * FROM AH" ; using rebol
I set up a script to rotate my logs for mysql and cron fires it off
perfectly the logs are rotated but when the shell script gets to the last
line which is...
mysqladmin -u usernam -p"Password" flush-logs
it will not execute it - my file that logs the execution of the cron script
says it doesn't
Hi,
Setting an replication for the first time, I get the following error
message in my slave:
020424 13:59:28 Slave: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at
position 4
020424 13:59:29 Slave: did not get the expected error running query
from maste
Basically these two servers are not connected to each other. Also I am
using win2k. I believe the syntax that you give me is in Unix. So I am
thinking I should use the dump text file sorry not providing enough
info... Thanks thought.
Andrew
- Original Message -
From: "Jason Yates
Thanks for the reply. Using the IP address in the host field does not fix
the problem, however. The delay in problem 1 changes from 1 - 2 seconds to
10 seconds. No impact on problem 2. Do I need to change the parameters to
the server?
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL
To whom it may concern,
Where can i find the documentation for mysqlgui?
thanks
bd
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Easy, =)
mysqldump -p | mysql -h
192.168.1.1 -p
That will dump the database and remotely insert in to the other server.
-Jason
On Wed, 2002-04-24 at 13:46, Andrew Chan wrote:
> Hello,
>
> I am trying to transfer tables/data from one server to another, say server A
> to B. mysqldmup helps
Egor Egorov wrote:
>Nick,
>Wednesday, April 24, 2002, 3:59:26 PM, you wrote:
>
>NG> I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am
>NG> unable to bet a lock on a table with any userid except root.
>
>NG> Here is my environment:
>NG> Sun 450
>NG> Solaris 2.8
>NG> MyISAM t
At 06:04 PM 23/04/2002 -0700, you wrote:
>http://www.google.com/search?hl=en&q=Views+Mysql
> ...
>
> MySQL Manual | 1.7.4.6 Views
> ... It is planned to implement views in MySQL Server around Version
>4.1. Views are mostly
> useful for letting users access a set o
Hello,
I am trying to transfer tables/data from one server to another, say server A
to B. mysqldmup helps me to dump table structure and data from server A.
Wonder what command I should use to load those dump result into server B.
Both server A and B are using the same version of MySQL.
Any hel
What sql function can I use to examine blob in a table. I need to display
part of the blob in hex values. Shouldn't the following sql command work :
select hex(substring(col1,1,10)) from table tbl1;
Thanks
-
Before posting, p
John Derrick writes:
> I'm having a couple of problems running mysqlgui on Windows XP Pro.
>
> 1) Intermittent 1 - 2 second delays on connecting and executing queries
> 2) 30 second delay on connecting and occasionally when executing queries
> when a dial-up connection is present
>
[skip]
>
>
I'm having a couple of problems running mysqlgui on Windows XP Pro.
1) Intermittent 1 - 2 second delays on connecting and executing queries
2) 30 second delay on connecting and occasionally when executing queries
when a dial-up connection is present
The problems appear to be related to DNS looku
Is there any way to be a slave to multiple masters from a single instance of
a mysql server?
If not, I suppose we can run multiple instances of mysql server, each with
its own data directory and reading its own my.cnf file ( which I dont think
would be too hard to do on a linux pc BUT)
How
Hello,
I am new in mysql, and I am trying to set an reclication. I followed the
instruction in the manual but steel I have a problem.
The problem is that even the replication thread works on my slave it is
not doing eny updates. The "master.info" file is updating every minute
and there is not e
Tewfic,
Wednesday, April 24, 2002, 6:14:58 PM, you wrote:
TK> Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function:
TK> mysql_connect()
TK> both PHP and MySQL are working on their own, but i have something missing
TK> form the PHP setup where it doesn't recognise MySQL.
I
D,
Wednesday, April 24, 2002, 6:16:31 PM, you wrote:
DO> Having followed instructions from various sources and installed from source
(twice) and binary (once), I still get the following problem.
DO> ---
DO> [root mysql]# /usr/local/mysql/bin/safe_mysqld &
DO> [1] 16168
DO> [root
Hi,
Did you use dbexpmysql.dll(not dbexpmys.dll) ?
Alexander Burbello wrote:
>
> I tryed to use Delphi 6.0 and dbExpress, but I didn't got.
>
> What component and what property I have to set for use correct??
>
> Regards
>
> Alexander
>
> >-- Mensagem Original --
> >
> >> Hi, Haroldo
>
Opps sorry.
Found the problem. Not starting as proper user.
Thanks.
D.
--
On Wed, 24 April 2002, D Okonkwo wrote:
>
> Having followed instructions from various sources and installed from source (twice)
>and binary (once), I still get the following problem.
> ---
> [root m
Hello:
My name is Gerardo Hernandez, in last time I triying installation MySQL
in
one machine with IBM/AIX 4.3.3.10, but when running createUser.sh show me
message below:
Could not load program mysql:
Dependent module libmysqlclient.a could not be loaded.
Could not load module libmys
TK> Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function:
TK> mysql_connect()
This question belongs on a/the PHP mailing list, but the answer is that
you need to compiled PHP --with-mysql. Please read the PHP
installation instructions in the very handy manual at
http://ww
Hi, all:
I read the document, it says "MySQL Server runs as a
native Windows application" and "You will need VC++
6.0 compiler" for MySQL Windows source distribution.
But we I try to download Windows binary package, it
says "Since mysqlc contains Cygwin runtime DLLs, we
also offer you the Cygwin
Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function:
mysql_connect()
both PHP and MySQL are working on their own, but i have something missing
form the PHP setup where it doesn't recognise MySQL.
I'd really appreciate any help.
---
Having followed instructions from various sources and installed from source (twice)
and binary (once), I still get the following problem.
---
[root mysql]# /usr/local/mysql/bin/safe_mysqld &
[1] 16168
[root mysql]# Starting mysqld daemon with databases from /usr/local/mysql/var
02
There are tools for benchmark on win32 via ODBC ?
I would like to test sql query in my VB6 application.
Thank you.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
I try to install mysql on a sparc 250 / solaris 7.
I have problem when I come at the "configure step" : I don't have a
"configure program" on my computer.
With a "find", I find one on the /usr/local/share/libtool/libltdl directory
but when I try to use it, I receive a message : "can not find sourc
What year was the web page http://www.mysql.com/doc/S/t/Standards.html
created/updated.
Exact month and day would be helpful if it is available.
I am referencing this page in an assignment and a year would be useful.
Your thoughts.
Thanks lots
David Ayliffe
ICQ# 125646758
Query, table, dat
I am needing to do a connection delphi 6 / ADO with the mysql that is in a
linux Freebsd of the qmail. Does anybody know as I can make that?
Thankful,
Marcos Birro Calixto
[EMAIL PROTECTED]
Webmaster - WebDeveloper - Delphi
UIN: 9151558
-
Hi,
Does it make sense to use temporary tables as a substitute for Views?
Where do I look in the docs for info?
Thanks.
Mysql.
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming.
--
I've installed MySQL 2.23.49 on Solaris 2.7. I've downloaded the binary
installation (mysql-3.23.49-sun-solaris2.7-sparc).
I'm using gcc 2.95.3 and make 3.78.1, both downloaded from SunFreeware site
(gcc-2.95.3-sol7-sparc-local and make-3.78.1-sol7-sparc-local).
I've installed the modules Data
kennonward,
Wednesday, April 24, 2002, 4:51:26 PM, you wrote:
k> I have mysql installed on a linux platform. I have no problem running every thing
as root. When I try to run mysql as a user other than root, I entered command use
mysql. I get error
k> 1044:access denied for user:@localhost
Nick,
Wednesday, April 24, 2002, 3:59:26 PM, you wrote:
NG> I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am
NG> unable to bet a lock on a table with any userid except root.
NG> Here is my environment:
NG> Sun 450
NG> Solaris 2.8
NG> MyISAM tables
NG> Any ideas on how this
bob,
Wednesday, April 24, 2002, 4:28:12 PM, you wrote:
bn> can any one tell me if there is any function to get
bn> the average of some values in the mysql database.
Sure, take a look at AVG() function:
http://www.mysql.com/doc/G/r/Group_by_functions.html
bn> tnx
bn> plz mail to [EMAIL PRO
Create a mysql user using phpMyAdmin or using the best way you find!
I thing that using phpMyAdmin is the most user-friendly way to do it!
mysql will ask you to give permisions on that user.
Give any permission you would like and that's all!
On Wed, 24 Apr 2002 [EMAIL PROTECTED] wrote:
>
>
>
If you are ruing as user mysql do
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/var
chgrp -R mysql /usr/local/mysql
Change to sute tast (or what you database is)
Simon
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2002 13:51
I have mysql installed on a linux platform. I have no problem running every thing as
root. When I try to run mysql as a user other than root, I entered command use
mysql. I get error 1044:access denied for user:@localhost to database 'mysql'.
is there a file that I need to change the per
Hi,
I have a big problem with last_insert_id() query.
I am adding records to a table with about half a million records in it. The
insert takes well under a second. I then call last_insert_id as I need to
make a link to another table.
The last_insert_id takes around 2 minutes!!! Yes *minutes*
I am hoping someone can shed light on this for me. We have a fairly simple
query that is pulling data from numeric fields and concatenating the field
contents into a single results column. The problem is the resulting data is
reported to be BLOB instead of the expected concatenated stringwhich
Do you use phpadmin? If not download it. The first task is pretty simple
with that.
Download from www.phpwizard.net
-
Joseph Jude
www.cephire.com
- Original Message -
From: Jumac
To: [EMAIL PROTECTED]
Sent: Thursday, April 25, 2002 3:36 AM
Subject
* bob nt
> can any one tell me if there is any function to get
> the average of some values in the mysql database.
Yes, the AVG() function:
http://www.mysql.com/doc/G/r/Group_by_functions.html >
--
Roger
-
Before posting, ple
Hi Jumac,
Jumac wrote:
> Greetings all,
> Special greetings to Nathan,Andrew and Jan for previous help.
>
> I have some new problems ( big surprise! ) some of which will seem stupid
> for sure
> but i'm using the excuse of being a newbie..so i should be forgiven :-).
>
>
> 1.Like i said before
* Jari Mäkelä
> How could I turn the first letter of each entry to Uppercase letter?
>
> the UCASE turns each and every letter and all I need is the first
> one to be changed
You can use a combination of UCASE(), MID() and CONCAT():
SELECT CONCAT(UCASE(MID(name,1,1)),MID(name,2)) AS name FROM
hi,
can any one tell me if there is any function to get
the average of some values in the mysql database.
tnx
plz mail to [EMAIL PROTECTED]
bobbie
__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
--
Use the application that you are using to save the information into the
database to verify that the first letter of each entry is uppercase.
I know for a fact that this can be done with perl, VB, c/c++, php, asp,
javascript, and java.
I have found that sometimes it is better to let the applicatio
If you can't do it within MySQL (I don't know the answer to that one) you
might be able to dump the information to a text file and process it using awk
and then reload it. Awk is perfect for this kind of thing. There is a Windows
version, if that is your OS.
On Wednesday 24 April 2002 08:49 am
Greetings all,
Special greetings to Nathan,Andrew and Jan for previous help.
I have some new problems ( big surprise! ) some of which will seem stupid
for sure
but i'm using the excuse of being a newbie..so i should be forgiven :-).
1.Like i said before I am running Apache,PHP and MySql on a wi
Samuel,
Tuesday, April 23, 2002, 8:55:00 PM, you wrote:
SM> Victoria Reznichenko
>> Samuel,
>> Tuesday, April 23, 2002, 4:04:20 PM, you wrote:
>>
>> SM> file serwer.err:
>> SM> 020422 19:16:29 mysqld started
>> SM> 020422 19:16:32 /usr/libexec/mysqld: Table 'mysql.host' doesn't
>> exist SM> 020
Gavin,
Tuesday, April 23, 2002, 7:24:14 PM, you wrote:
GM> When using the REPLACE() function in a query, are there any wildcards
GM> allowed? If so what are they?
Nope.
GM> Also are regular expressions only usable for matching or can one also do a
GM> regular expression substitute in some way?
I have encountered a problem with MySQL 4.0.0 and 4.0.1 in which I am
unable to bet a lock on a table with any userid except root.
Here is my environment:
Sun 450
Solaris 2.8
MyISAM tables
Any ideas on how this problem could be solved?
Thanks,
Nick Gilliam
---
sql,query
Hi,
How could I turn the first letter of each entry to Uppercase letter?
the UCASE turns each and every letter and all I need is the first one to be changed
JAri Mäkelä
-
Before posting, please check:
http://w
On Wed, Apr 24, 2002 at 02:27:40PM +0300, Sinisa Milivojevic wrote:
> > mysqld.cc:2428: at this point in file
> > /usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request
> > _info *)'
> > mysqld.cc:2429: at this point in file
> > /usr/include/tcpd.h:153: too few arguments
Try MyODBC from the downloads page at www.mysql.com. Erwin works fine
for reverse engineering databases, on forward engineering I do have
to make some patchs by hand to script before I can generate a model.
Maybe I need to learn to use Erwin better.
Also if you have a support contract please ca
Hi all,
I have a script in perl accessing a db in another machine every 5
minutes (by crontab), and I have had this error 'host blocked' 2 or 3
times, in 2 or 3 weeks (not regularly).
http://www.mysql.com/doc/B/l/Blocked_host.html
>From this link, I read that it is due to interrupted connexion
Hello,
Is there a way of checking if a temporary table exists?
I've been using "show tables like '%tablename%'" to see if an ordinary table
exists..
but show table wont display temporary tables so this wont work.. any
suggestions?
// Leif Högberg
And so the spam filter will let this through: SQ
Andrey Kotrekhov writes:
> Hi!
>
> %> g++ -v
> Using builtin specs.
> gcc version 2.95.3 20010315 (release) [FreeBSD]
> And libstdc++ is include in compiller
> How can I see version of libstdc++ ?
> In /usr/src/contrib/libstdc++/Makefile.in I see
> VERSION = 2.10.0
> INTERFACE = 3
> Is there righ
[EMAIL PROTECTED] writes:
> >Description:
> I get the following error:
>
> c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr\""
>-
> DDATADIR="\"/var/lib/mysql\"" -DSHAREDIR="\"/usr/share/mysql\"
> " -DHAVE_CONFIG_H -I
1 - 100 of 122 matches
Mail list logo
