Forwarded cause HH send reply to me instead of to the list..
>The connections are released... If an INSERT is trying to update a table
>that is locked, won't that cause connections to stack up?
>
>Anyone have any insight?
>
>Hunter
>
> > From: "B. van Ouwerkerk" <[EMAIL PROTECTED]>
> > Date: Tue,
Hi
Start a mysql client session by entering mysql at the command prompts, then
you'll be able to enter SQL statemeents.
At 21:42 18/04/2001 +, [EMAIL PROTECTED] wrote:
>Hi guys,
> I have created databae of mysql on redhat 7. I want to access my
> database by command promt can any bo
well, start with reading a book about designing databases, especially about
the subject 'normalisation'.
normalisation is a way to split up data ('entities') in a way that every
piece of data only occurs once in your database. (although sometimes for
practical reasons you may decide otherwise, but
Ok . No matter for me anymore. cause i solved my problem.
i'm paying attention for other users not to have
the same problem.
Regards
Yusuf Incekara
- Original Message -
From: John Dean <[EMAIL PROTECTED]>
To: Yusuf Incekara <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, April 17
Hi
I tried to connect with MySQL from Java Webserver, it was connected
and got interacted with MySQL thru my programs. No problem for this.
When i tried the same with Apache i am getting the following error
[18/04/2001 05:53:12:063] (ERROR) ajp12: Servlet Error:
java.lang.NullPointerException:
Hi,
I have SuSE 7.1 installed on my machine. SuSE 7.1 comes with MySQL 3.23.32.
When in try to run mysqld, i am getting the following error:
Fatal error: Please read "Security" section of the manual to find out how to
run mysqld as root!!
But i couldn't find any section c
On Tue, 17 Apr 2001, B. van Ouwerkerk wrote:
>
> >I am using php for this project. Right now it is related to mysql. What
> >I want is to display the names of the countries and cities from the
> >Special table instead of the ids. What would be the correct syntax for
> >the select statement?
>
doejari wrote:
>
> Hi,
> I recently downloaded MySQL RPM-packages from your site and right after my
> virusscanner started screaming that it has found a virus?!?
> It didn't display a name and was unable to clean it...here's where it was
> found:
> "mysql-3.23.36-ibm-linux-gnu-s390.tar.gz\mysql-3
Hi,
I recently downloaded MySQL RPM-packages from your site and right after my
virusscanner started screaming that it has found a virus?!?
It didn't display a name and was unable to clean it...here's where it was
found:
"mysql-3.23.36-ibm-linux-gnu-s390.tar.gz\mysql-3.23.36-ibm-linux-gnu-s390.ta
r
>Description:
When i insert into a negative integer into primary key (id int) field, it
works fine.
However, the next insert i do without specifing the id explicitly and relying
on mysql to
generate the next number in the sequence (should be 1) will use the upper
bound (
I'm trying to build a query for a calendar program for a web site.
Basically, I want a query that will print a word if there is an event booked
on that day.
Here's how the relevant tables are laid out and what they mean:
TABLE: activities
AID - Primary Key
ALocation
AEmail
AName
ADay
AMonth
A
Hi guys,
I have created databae of mysql on redhat 7. I want to access my database by
command promt can any body tell me the command syntex.
thanks in advance
atif
-
Before posting, please check:
http://www.mysql.co
use the ORDER BY clause with the SELECT
SELECT * FROM table ORDERBY fieldname ASC
(or replace ASC with DESC for descending order)
Siggy
- Original Message -
From: "Michael M. Ocana" <[EMAIL PROTECTED]>
To: "Mysql Lists" <[EMAIL PROTECTED]>
Sent: Wednesday, April 18, 2001 2:55 PM
Subjec
You wrote:
I am using KaneyanMySQLAdmin to administrator the linux mysql server remotely but i
am unable to connect it.
> From: "Mitunobu Kaneko" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Date: Sat, 14 Apr 2001 15:27:00 +0900
> Subject: Administrator Software
>
>
> The English version o
Hmm. I did the ./mysql-test-run script (/usr/local/mysql-test/) and I
got the following results:
> Starting Tests
>
> TEST USER SYSTEM ELAPSEDRESULT
>
> alias 0.0
Subject: inverse function (database,sql,query)
hello anybody knows how to invert selected records?
example :
i have selected records :
apple
mangoe
cherry
avocado
if i invert it :
avocado
cherry
mangoe
apple
how can i do this? in DBI? or in my SELECT statement?
thanks
I realize this may be a little OT but I'm sure many of us MySQL rookies
would be interested in the responses.
I would be interested in hearing how someone goes about planning the layout
of their database including how they determine what tables, fields, column
types, queries, etc they will need.
I find myself unable to successfully complete a 'make test' on Mac OS
X 10.0.1 with MySQL 3.23.36. The build goes successfully, but one of
the tests freezes up completely. After letting the test run for a
good 12 hours (not a typo), no progress was made. I can find no
errors in the system.log
On 17-Apr-01 Matt \"TrollBoy\" Wiseman wrote:
> How would I word a query to see what tables exist in a db that begin with
> box
>
> for example include
> boxTABLE1
> boxTABLE2
> boxTABLE3
> but exclude
> sphereTABLE1
>
> I'm basically trying lo populate a list box with the tables beginning with
"Matt "TrollBoy" Wiseman" <[EMAIL PROTECTED]> wrote:
> How would I word a query to see what tables exist in a db that begin with
> box
>
> for example include
> boxTABLE1
> boxTABLE2
> boxTABLE3
> but exclude
> sphereTABLE1
>
> I'm basically trying lo populate a list box with the tables beginning
How would I word a query to see what tables exist in a db that begin with
box
for example include
boxTABLE1
boxTABLE2
boxTABLE3
but exclude
sphereTABLE1
I'm basically trying lo populate a list box with the tables beginning with
box in PHP.
Matt "Trollboy" Wiseman
www.shoggoth.net/trollboy/troll
I'm having big problems installing MySQL 3.23.36 on Red Hat 6.2. I've read
some other accounts of the same problem in the archives. I've tried all the
fixes there and nothing works. I've tried removing all files and starting
fresh, changing ownerships, privs, etc. What's happening and how do I
I have a program that creates C-ISAM files and I want to access the data via
mysql.
I have a question about integrating a C-ISAM library into the mysql source.
I noticed that mysql uses myisam files, but I'm wondering what steps would
be involved to have it support C-ISAM.
Would creating a wrappe
At 17:38 17/04/2001 -0400, Gengxin Chen wrote:
At this end of this week will release a new binary with some
bugs fixed.
>Description:
> 1. doesn't save "my.ini" anywhere
I didn't able to repeat this issue, on my machine doesn't have
problem.
> 2. paths in "my.ini S
Description:
1. doesn't save "my.ini" anywhere
2. paths in "my.ini Setup" are all in Unix style (using "/")
3. "Table Columns" display in "Databases" are mis-aligned
How-To-Repeat:
just run it
Fix:
create c:\my.cnf mannually
Synopsis:
Submitter-I
SELECT a.id_user,a.name, a.surname from user a LEFT JOIN workgroup b ON
a.id_user=b.id_user WHERE b.id_user IS NULL;
Daniele Medri <[EMAIL PROTECTED]> wrote:
Hi All,
this is my problem:
2 tables..
1) workgroup(id_survey,id_user,...)
..where i put reference of user with multiple istances.
2
Hi All,
this is my problem:
2 tables..
1) workgroup(id_survey,id_user,...)
..where i put reference of user with multiple istances.
2) user(id_user,name,surname,...)
..where there're all users
i need to select with a single query what user aren't in workgroup.
I've tried some query+join but i d
>What's the best way to figure this out if I can't get into the server at all
>when it locks up?
Few thoughts:
- release the connection in your code..
- use pconnect instead of connect..
Check the logs.. if you have any..
Bye,
B.
query sql
-
hi,
> Hello
>
> I need export data from MySql to Access(MDB), but must to be in
> Web. I'm use PhpMyAdmin.
which platform do you use?
i had a similar problem with access to mssql, where i could not access
the sql server via the administration toolkit. so i wrote
an asp script that created the ta
Hello
I need export data from MySql to Access(MDB), but must to be in Web. I'm use
PhpMyAdmin.
Help-me please.
See U,
Silvio
I have a Web app that uses PHP4 to connect to a mySQL server (3.22.26) on
Red Hat 6.0 (Dual Pentium III).
The site is very popular and every once and a while PHP can't connect to
mySQL because of "Too Many Connections".
I log in to the server and I am unable to execute a mysqladmin shutdown
beca
At 19:31 17-4-01 +0100, John Dean wrote:
>Hi
>Did you leave an old version of the shared libs lying around?
The old version is packed with PHP..
Bye,
B.
query sql
-
Before posting, please check:
http://www.mysql.com/manu
While attempting to configure MySQL on a Sparc platform running Solaris 2.7 using GNU
compiler gcc 2.95.2 the ./configure with the --prefix= option failed with the
following indications:
These messages are from config.log:
This file contains any messages produced by compilers while
running con
Hi,
I am using the newest versions of MySQL,PHPMyAdmin, and PHP4 on IIS server.
The MySQLdatabase and PHP is working like a champ, but when I connect to
localhost/phpmyadmin it asks me for login/password and domain. The problem
is domain. We have a virtual private network here. So the machine is
Greetings from Canada,
Does anyone know of any c++ libraries that are compatible with Cygwin? I
want to connect to mysql db
Thanks,
Kate
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Hi
Did you leave an old version of the shared libs lying around?
At 10:16 17/04/2001 +0200, Administrator wrote:
>I've installed Mysql server version 3.23.36 from source distribution
>(*.tar.gz). When I show the php4 credits () in my browser
>it shows:
>MySQL Support enabled
>Active Persistent Li
Hi
This is not a "bug" in the documentation, it is the way you have
interpreted what it says
On a Win9x/ME system the Windows-System-Directory is called x:\Windows but
in Windows NT and Windows 2000 it is called WinNT. If the author meant to
write windows(winnt)\system that is what he would hav
Pentium III 667 mhz, 256mb ram, 20 gb hd
OpenBSD 2.7
MySQL 3.22.32 (installed with pkg_add mysql-3.22.32.tgz)
started with:
safe_mysqld --user=mysql > /dev/null &
I have several text files that look like this:
use mydb;
create table mytable (
(field defs)
>Description:
WHen running the mysql_install_db, the script failed because it
could not find the lib libz.a, which is not on the AIX system.
We are running AIX 4.3
>How-To-Repeat:
Run the script scripts/mysql_isntall_db
>Fix:
>Submitter-Id:
>Originator
Hi peoples,
I'm slightly confused as to exactly what 'Sending data' means in a
processlist command. I have a query whch outputs precisely one row, and it
takes 40+ seconds to 'Send data'. I'd assumed that this was simply the
sending of the query result from server -> client...am I incorrect ?
re
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_pa
Ken Menzel writes:
> Hi, I got this funny response from [EMAIL PROTECTED]I thought
> someone would want to know. (I deleted my orginal message as it
> included my support contract number!).
> Ken
> -
> Ken Menzel ICQ# 9325188
> www.icarz.c
hi.
the mysql code is compiled into the PHP module within apache, so apache
wouldn't know anything about it.
if you do a you can find out information about the mysql
version that php is using.
hth.
-ravi.
-Original Message-
From: N6REJ [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 17,
Hi, I got this funny response from [EMAIL PROTECTED]I thought
someone would want to know. (I deleted my orginal message as it
included my support contract number!).
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Origi
from http://www.mysql.com/downloads/gui-clients.html, I used the link given in
Please note that these are special versions needed to be downloaded
from our site:
FLTK editor widget 0.4 for MySQLGUI
The newest MySQL C++ library
Then, ./configure; make; find . -name edfile.o
I think I might have goofed somewhere. I just upgraded Mysql and apache and
php on my server, and the server logs state
Apache/1.3.19 (Unix) PHP/4.0.4pl1 mod_ssl/2.8.2 OpenSSL/0.9.5a configured --
resuming normal operations
but should'nt it also say something about mysql being tied in to?
Tr
Hi,
> "dr0asif" == dr0asif <[EMAIL PROTECTED]> writes:
dr0asif> Dear sir/madam, I got following error while connecting and
dr0asif> creating a table kindly inform how can i set it right
dr0asif> sql(): ErrorYou have an error in your SQL syntax near
dr0asif> ';INSERT INTO shop VALUES
dr0
David Relson writes:
> from http://www.mysql.com/downloads/gui-clients.html, I used the link given in
>
> Please note that these are special versions needed to be downloaded
> from our site:
> FLTK editor widget 0.4 for MySQLGUI
> The newest MySQL C++ library
>
> Then, ./c
I could not find a reference in the manual to this error message. What
could be happening? It is the first problem I have with the database since
installation two years ago- well almost three.
Thanks,
---
Claudia M. Castaneda
Phone 301 286 3397
David Relson writes:
> Sinisa,
>
> Please provide a patch for Makefile showing how to "kick out edfile.o".
>
> FWIW, I have fl_editor-0.4 as well as fl_editor-0.4.1 and neither version
> creates edfile.o as best I can tell.
>
> David
>
You can not use regular fl_editor. You must use the one
Go get the book "MySQL" by Paul DuBois ( New Riders Press ).
[EMAIL PROTECTED] wrote:
>
> Dear sir/madam,
> Kindly help me to correct this error
> sql(): ErrorYou have an error in your SQL syntax near 'mysql> SHOW DATABASES;' at
>line 1
> thamks
> asif
> www.kwwda.org
>
>
Deneen Petty writes:
> Hello,
>
> I used to use a version of your client. The program I have is "mysqlgui-win-1.4a".
>I am using Windows 98. Could you tell me what the latest version of your software is
>and what the exact name is? There are so many programs and variations that I seem to
>
That is what the autoincrement ID field is usually used for.
UPDATE mytable SET thisfield=newvalue where id=THISID;
Martin Skjöldebrand wrote:
>
> Hi,
>
> Now I'm completely stuck.
> I am codeing a (basic at this point) stock inventory in PHP/MySQL.
> I have all items in a table displayed in
Rick Mann writes:
> I'd like to get a minor source change into the next revision of MySQL to
> make the standard source distribution compile on Mac OS X. I read somewhere
> to use some diffing tool when providing the bug report, but can't find those
> instructions.
>
> What's the proper way to ge
[EMAIL PROTECTED] writes:
> >Description:
> When running make after ./configure, make stopped at an error
> stating debug.c: In function 'init_dbug_state': debug.c: 344:
> 'MY_MUTEX_INIT_FAST' undeclared. I found out later that this same
> variable is undeclared in other files as well.
Dennis,
Innobase (= InnoDB starting from version 3.23.37) allows you to have
an index on a column which may contain nulls. However, the ANSI SQL
specification requires that the columns in a primary key are declared
as not null. If your main key may can contain nulls, do not define
a primary key a
Are you sure about that number? 1,000 queries per second is pretty high.
Assuming that 10k per second is correct, that translates to 36,000,000
queries per hour. That is quite a lot. BTW, what DB were you using before
and was its inability to handle your load a factor in your decision to
switch? H
Adam Stein writes:
> I have just compiled fl_editor-0.4.1. Here is the list of .o files that get created:
>
> ./src/Fl_Editor.o
> ./src/Fl_FancyEditor.o
> ./src/Fl_FancyMultiEditor.o
> ./src/Fl_MultiEditor.o
> ./src/Fl_ProgressBox.o
> ./src/Fl_StatusPanel.o
> ./src/editengine.o
> ./src/lists.o
>
Hi!
Your two problems are easily explained. You do not have edfile.o,
because you have not built fl_editor.
Second, 2.95.3 has some serious problems with STL libraries, that is
why I suggest you downgrade to 2.95.2.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
>>Hi,
>>I'm having the following sql problem:
>>I have two datetime fields (start and end), I need to find out if the
>>month is either equal to start-month or equal to end-month but also
>>if it's a month between start and end. I also check if the end-date
>>is greater than today so it's a curren
At 09:34 17/04/2001 +0200, Ireneusz Piasecki wrote:
Hi!
I understand the same definition like Mr. Incekara:
Windows directory: c:\windows c:\winnt
Windows system directory : c:\windows\system c:\winnt\system(32)
Anyway I will take a look on Microsoft documentation to be 100%
sure, to change ou
Have you tried EXPLAIN ?
EXPLAIN
SELECT
*
FROM
tables
WHERE
this='this' AND
that='that'
ORDER BY
this, that
;
A query like this would return you some of the stats. Catch the time
Dear sir/madam,
Kindly help me to correct this error
sql(): ErrorYou have an error in your SQL syntax near 'mysql> SHOW DATABASES;' at line
1
thamks
asif
www.kwwda.org
-
Before posting, please check:
http://www.mysql.com/manu
Hi!
Is there a way to get the time the database needed for execution a statement?
I use MySQL and PHP...
--
Berthold Tenhumberg
(live long and prosper...)
-
Before posting, please check:
http://www.mysql.com/manual.php
Hello.
On Tue, Apr 17, 2001 at 04:20:42AM -0400, [EMAIL PROTECTED] wrote:
> Dear sir/madam,
> Kindly help me to correct this error
> sql(): ErrorYou have an error in your SQL syntax near 'mysql> SHOW DATABASES;' at
>line 1
You don't need "mysql> " within your command. Delete it.
"mysql>" stand
>Why it display other version of client api than I install.
>
>It would be nice that You answer me.
Did you compile PHP with --with-mysql=/path/to/mysql
Bye,
B.
-
Before posting, please check:
http://www.mysql.com/manual
>I am using php for this project. Right now it is related to mysql. What
>I want is to display the names of the countries and cities from the
>Special table instead of the ids. What would be the correct syntax for
>the select statement?
Take a look at websites like www.devshed.com www.phpnewb
Dear sir/madam,
Kindly help me to correct this error
sql(): ErrorYou have an error in your SQL syntax near 'mysql> SHOW DATABASES;' at line
1
thamks
asif
www.kwwda.org
-
Before posting, please check:
http://www.mysql.com/manu
I've installed Mysql server version 3.23.36 from source distribution
(*.tar.gz). When I show the php4 credits () in my browser
it shows:
MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 3.23.22-beta
Why it display other version of client api than I install.
It w
DEAR SIR/MADAM,
I am getting following error.Kindly help to correct it
sql(): ErrorYou have an error in your SQL syntax near 'mysql> SHOW DATABASE;' at line 1
www.kwwda.org
asif
-
Before posting, please check:
http://www.my
- Original Message -
From: "Yusuf Incekara" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 17, 2001 9:09 AM
Subject: Bug in Documentation ?
in Mysql documents
section 4.16.5 Options files
it is documented as :
---
Hi all!
The perl module for Mysql expects to find libmysqlclient.a or libmysqlclient.so, at
least when it's compiling under cygwin.
An earlier report of the same issue seems to have turned up no responses, but that was
a couple months back.
Surely I can't be the only unix lover in the world
72 matches
Mail list logo
