Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering if there is any
great client side tools of it, like the toad for oracle? actually I'm not expecting it
to be that functional, but at least i wish it's better than the one in the mySQL
package.
Any input is greatly appreciat
Tinyint will only go up to 127 when it is signed. Try INT.
Also, please read the Docs section about data types and their sizes. It will
save you more embarassing questions like these. :)
j- k-
On Tuesday 24 April 2001 20:39, Howard Picken wrote:
> -Original Message-
> From: [
"Marc Raeymaekers" <[EMAIL PROTECTED]> wrote:
> I'm a newbie with MySQL, so don't apologize me when I post a stupid
question.
>
> Is it only possible to join tables 2 by 2 or is it possible to join 4
tables in
> only one request?
Yes, you can join 4 tables in one SQL statement.
--
Steve Werby
Pr
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 25 April 2001 2:31 PM
To: Howard Picken
Subject: Why MySQL db will only allow 127 records imported?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filt
> > Hi all,
> >
> > I'm looking for some pointers towards some good information on accessing
> and using MySQL with Java/Javascript.
> >
> > Can anyone point me towards a book you like, or some good web resources?
> >
> > Thanks much,
> > /Rob
> >
You'll need a servlet and/or JSP engine such as
Dear Sir,
My Linux is RedHat Linux 6.0
I follow the below step to install the mysql version 3.23.37 database :
1. tar ¡Vzxvf mysql-3.23.37.tar.gz
2. ./configure ¡Vprefix/usr/local/mysql
3. make
4. make install
5. echo ¡§/usr/local/mysql/lib/mysql¡¨ >> /etc/ld.so.conf
6.
Hi,
I tried to upgrade a 3.22.32 source install of MySQL to the
latest 3.23 source from the MySQL Web site on my RedHat 6.1 box and
ended up breaking Apache and PHP (which were also compiled by source).
Being relatively new to Linux and having gotten it working
originally via a
I'm having problems compiling mysql 3.23.37 on
Solaris 2.7. It gets to the final linking stage
and I get the following error:
/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.1/libgcc.a: could not read symbols:
Bad value
Anyone have this happen to them before and/or
have a fix? I've also compil
Hi
I am using an application (excel) that sends sql requests and fills the
excel sheet.
When i issue an update statements, the update doesnt return data to my
program (*.vba) in excel, so it hangs.
To bypass the problem I was told to use the following ansi compliant sql
statement "SET NOCOUNT ON"
I was under the impression that things end up in a tmp table if the query requires
sorting which is when you have either ORDER BY or GROUP BY or DISTINCT
Is that true of false?
regards,
thalis
On Tue, 24 Apr 2001, Seung-woo Nam wrote:
> I don't think you can avoid having those temporary table
Hello,
I'm a newbie with MySQL, so don't apologize me when I post a stupid question.
Is it only possible to join tables 2 by 2 or is it possible to join 4 tables in
only one request?
Thanks
Marc Raeymaekers
Belgium
-
Before p
I don't think you can avoid having those temporary tables in executing
any kind of SELECT queries since the retrieved information should be
stored somewhere (whether you have ORDER BY or not). I would suggest
that if you have a large database, you should considering putting the
temporary space on
>That ORDER by a calculated_field DESC is killing you.
>It needs to go to a temporary table for sorting.
The problem, though, is that even if I leave the ORDER clause out, or
ORDER BY any other field, the same thing happens. I initially thought
the same thing, but it happens with or without the
Like duh! =)
On Tue, 24 Apr 2001, Rene Tegel wrote:
> RTFM=Read The Fucking Manual
>
> now you know.
>
>
> On Tue, 24 Apr 2001 21:37:44 +0100 (BST)
> Peter Skipworth <[EMAIL PROTECTED]> wrote:
>
> > I for one vote to not bother with abbreviations from now on - let's just
> > spell it out lo
Dear Jason -
Jason Feingold writes:
> Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install
> because of a MySQL-DBI-perl-bin dependency.
Using the RPM mechanism to install perl modules is fraught with
problems. Don't use it; you'll be sorry you did in the long run.
But, fear n
Now gentlemen please let's use appropriate language when posting to the
list, after all it is a public list and we don't want to offend anybody
At 22:04 24/04/2001 +0100, Peter Skipworth wrote:
>Like duh! =)
>
>On Tue, 24 Apr 2001, Rene Tegel wrote:
>
> > RTFM=Read The Fucking Manual
> >
> > now
"Professional JSP", by Wrox Press Ltd, is a quite good book.
Matt
- Original Message -
From: "Robert Alexander" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 24, 2001 2:48 PM
Subject: Info on using MySQL with Java
> Hi all,
>
> I'm looking for some pointers towards
Did you try to put (-1) in it?
Bye!
Facundo Batista
Gestión de Red
[EMAIL PROTECTED]
(5411) 4819-4358
#---Mensaje original-
#--De: Ashley M. Kirchner [mailto:[EMAIL PROTECTED]]
#--Enviado el: Viernes 20 de Abril de 2001 8:15 PM
#--Para: MySQL Mailing List
#--Asunto: largest timesta
lol.
since i'm not native english, what does 'duh' mean ?
:)
rene
On Tue, 24 Apr 2001 22:04:37 +0100 (BST)
Peter Skipworth <[EMAIL PROTECTED]> wrote:
> Like duh! =)
>
> On Tue, 24 Apr 2001, Rene Tegel wrote:
>
> > RTFM=Read The Fucking Manual
> >
> > now you know.
> >
> >
> > On Tue, 24 A
RTFM=Read The Fucking Manual
now you know.
On Tue, 24 Apr 2001 21:37:44 +0100 (BST)
Peter Skipworth <[EMAIL PROTECTED]> wrote:
> I for one vote to not bother with abbreviations from now on - let's just
> spell it out loud and clear ;) *grin*
>
> P
>
> On Tue, 24 Apr 2001, Steve Ruby
> wrote
Hi:
I believe MySQL-bench uses Perl program to benchmark databases so that
it requires Perl-DBI. DBI is a Perl module that provides API for
database connection. I have never installed Perl modules in RPM format
but you should be able to find it on RedHat ftp server. And I think the
name 'MySQL-DBI
It is asking for the current password, and there isn't one.
You should skip the -p until you have one set.
Jason Feingold wrote:
>
> Hi All - I just set up MySQL for the first time and cannot seem to change
> the user 'root' password using mysqladmin. I must be geting the sytax wrong.
> Im typin
I for one vote to not bother with abbreviations from now on - let's just
spell it out loud and clear ;) *grin*
P
On Tue, 24 Apr 2001, Steve Ruby
wrote:
> Matthew Hafner wrote:
> >
> > does mySql support triggers or transactions
> >
> > Matthew Hafner
> > Web Applications Engineer
> > The Oha
COuld try a mysqldump to backup and restore the tables on the new/other
machine. This should get you past the problems you found earlier.
Remember to add the propriate users to the new machine..
Bye,
B.
> >
>mysql> use lum
>Reading table information for completion of table and column names
Hi All - I just set up MySQL for the first time and cannot seem to change
the user 'root' password using mysqladmin. I must be geting the sytax wrong.
Im typing 'bin/mysqladmin -u root -p password', then it prompts me for a
password, i type one in, then it gives me an error as shown below:
[ro
You might want to try downloading "binutils" from the GNU web site. It has a
modified version of the linker libraries (ld). I still wasn't able to get past
the "yacc" compile even with 512MB RAM. Let me know how you make out. I ended up
using the binary distribution.
James Bonham wrote:
>
> Help
Help me please !
installing MySQL 3.23.36 on Ultra SPARC/Solaris 2.7
GNU make 3.79.1, binutils, and libtool latest version, gcc 2.95.2
environment variables:
CC=gcc
CFLAGS=-O6
CXX=gcc
CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti
at the command line:
./configure --prefix= --with
MySQL supports transactions in beta form if you use a Berkley table. Check
the homepage for more information.
Triggers are in the "todo" pile though.
At 09:44 AM 4/24/2001 -1000, Matthew Hafner wrote:
>does mySql support triggers or transactions
>
>Matthew Hafner
>Web Applications Engineer
>Th
Hi all,
I'm looking for some pointers towards some good information on accessing and using
MySQL with Java/Javascript.
Can anyone point me towards a book you like, or some good web resources?
Thanks much,
/Rob
-
Before postin
Matthew Hafner wrote:
>
> does mySql support triggers or transactions
>
> Matthew Hafner
> Web Applications Engineer
> The Ohana Foundation
> 1099 Alakea st
> 22nd floor
> Honolulu, HI, 96813
> 1-877-61-ohana
> [EMAIL PROTECTED]
RTFM
www.mysql.com
-
does mySql support triggers or transactions
Matthew Hafner
Web Applications Engineer
The Ohana Foundation
1099 Alakea st
22nd floor
Honolulu, HI, 96813
1-877-61-ohana
[EMAIL PROTECTED]
-
Before posting, please check:
http://
We encountered no real problems when converting a database from Interbase, with some
stored procedures and triggers as well, to mysql.
Most stored procedures were for things like generating a unique key, getting the
server date/time/year, etc.
Triggers are imho just application _unfriendly_, s
Hi,
Running 3.23.37 on freebsd
We are making about 200-250 requetes per second
on a server with 1Go RAM.
We have lot of problems with the requetes which use
order by, group by. It seems mysqld copies the data to
a tmp table to make sort. The problem is it takes a
while to be done. How to make it
OS Is Linux.
The autoincrement key is defined as INT, so plenty of room there.
Table sizes are getting up there:
attempt.MYD 1,902,291,232inrec.MYD 1,979,795,600
attempt.MYI 280,733,696inrec.MYI 240,460,800
After doing a myisamchk -r on the attempt table, inserts appear to be
Make sure you don't have concurrent accesses to the mysql.sock, for example the
apache authentication module (we had that). docs say you should build php with shared
mysql support, so i guess you'll still just have to do so...
On Tue, 24 Apr 2001 11:06:33 -0700
Hunter Hillegas <[EMAIL PROTECTE
I am running MySQL 3.23.37 compiled by myself on Linux platform.
Here is a repeatable example:
mysql> create table test (id int not null,
-> KEY id (id)) type=InnoDB;
mysql> SELECT id FROM test WHERE id<1;
ERROR 1032: Can't fi
I am using 3.23.36 in conjunction with PHP 4.0.4pl1. When I compiled PHP, I
used --with-mysql and let it use it's own mySQL library, not compiling
against anything build under 3.23.36 (I tried the other way but the
configure failed, never finding mysqlclient libraries, even though they were
right
What operating system are you running, and how big are these files and
indicies?
Is this a 2 Gig file size limit problem?
You are getting near the limit to the size of an unsigned mediumint.
Dan Shapella wrote:
>
> I have a weird one here.
>
> I have an application that inserts records into
Hi - Im installing the MySQL-bench-3.23.37-1.i386.rpm, cant install because
of a MySQL-DBI-perl-bin dependency. Does anyone know what this is(RPM?or
Perl Mod?), and where i can find it?Ive been looking, but no luck yet.
Thanks!jason
__
urSQL also supports multiple queries...
http://www.urbanresearch.com/ursql
On Tue, 24 Apr 2001, Jason Holliston wrote:
> Yes, MySQLFront works much better with multiple queries at once. Nice,
> quick, simple Win32 UI. I was originally using MySQL GUI that's
> downloadable from http://www.mysq
MySQL 3.23.38 is already in the change log. Is there a proposed release
date? I don't want to install 3.23.37 just to have to install 3.23.38
tomorrow.
Thanks.
j-k -
--
Joshua Kugler
Associated Students of the University of Alaska Fairbanks
Information Services Director
[EMAIL PROTEC
> It depends on the gui you're using. Get the one at my.anse.de
>
> At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote:
> >This is probably something I'll smack my head about afterward, but here
> >goes: is it possible to execute multiple queries in the MySQL client GUI
> >on Win32? What's acce
Thanks everyone for the help, you are an awesome crowd. We got it :)
Alan
-Original Message-
From: Peter Pentchev [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 24, 2001 10:19 AM
To: Alan Halls
Cc: [EMAIL PROTECTED]
Subject: Re: Can anyone help with a search?
On Tue, Apr 24, 2001 at 10
On Tue, Apr 24, 2001 at 10:01:50AM -0700, Alan Halls wrote:
> Hi,
> Ok, it is a little off the Mysql topic but I need to know something and I
> know
> someone out there can help. I need to do a search on a UNIX box using either
> egrep or another command that will search for all occurances of a l
I have a weird one here.
I have an application that inserts records into one of 2 different tables.
The other day, an insert attempt on one of the tables failed with a
duplicate key error on key 1, an autoincrement field. About a minute later,
an insert attempt on the other table failed simi
On Thursday 19 April 2001 21:54, Ken Menzel wrote:
> cd /usr/ports/databases/mysql323-server
> make
> make install
> reboot
this aint windows ya know
skip the reboot
/sbin/ldconfig -m /usr/local/lib/mysql
/usr/local/bin/safe_mysqld --user=mysql
if you are using tcsh:
set docroot='path to your html root directory'
find $docroot -name "*.html"> allhtml.list
foreach FILE (`cat allhtml.list`)
echo $FILE >> outhtml.list
grep 'link' $FILE >> outhtml.list
end
you can get more sophisticated than this, but this will work. then look
through outht
> > First, make sure to follow the instructuctions in the manual on symbolic
> > resolve of the stack trace. Without it, numeric trace is not much help,
> > especially when you built your own binary and we do not have a symbol
> table.
> >
> This is output of resolve_stack_dump
>
> 0x813744a pth
grep -ir href http_dir |grep -v # |grep -v "good links"
I use somthing like this.
Best Regards
On Tue, 24 Apr 2001, Alan Halls wrote:
> Hi,
> Ok, it is a little off the Mysql topic but I need to know something and I
> know
> someone out there can help. I need to do a search on a UNIX box usi
How is disk space when this happens?
Hunter Hillegas wrote:
>
> I have several mysqld processes that have 'D' status as shown by ps aux.
>
> >From my limited understanding, that means they are waiting for disk and are
> uninterruptible?
>
> How do they get this way and what can I do to fix thi
Hi,
Ok, it is a little off the Mysql topic but I need to know something and I
know
someone out there can help. I need to do a search on a UNIX box using either
egrep or another command that will search for all occurances of a link. we
have updated part of our website and want to make sure there a
Hi again,
I've sorted this problem out by rtfm.
Used 'REPAIR TABLE ' and got most of the records back.
regards,
Dave
database,sql,query
--
Don't hit me!! I'm in the Twilight Zone!!!
email: [EMAIL PROTECTED]
web: www.largesalad.co.uk/DJMsoft
-
Yes, MySQLFront works much better with multiple queries at once. Nice,
quick, simple Win32 UI. I was originally using MySQL GUI that's
downloadable from http://www.mysql.com/. Oh, and for everyone's
information, http://my.anse.de/ does not appear to work, at least for this
morning. http://www.
I have several mysqld processes that have 'D' status as shown by ps aux.
>From my limited understanding, that means they are waiting for disk and are
uninterruptible?
How do they get this way and what can I do to fix this?
Hunter
---
Hi,
On Tue, Apr 24, 2001 at 10:44:59AM -0400, Vivek Khera wrote:
> > "PJM" == Patrick J Militzer <[EMAIL PROTECTED]> writes:
>
> PJM> I'm using mysql 3.22.27. How can I force mysql to use index's in
> PJM> my select statement?
>
> You don't. SQL is a 4GL and you only describe what you wan
Janos,
You need to install the php3-mysql package, which allows PHP3 to access
MySQL databases. Although, you should think about compiling PHP4 or
downloading the .debs for it. It's better than PHP3.
Oliver
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tue
I need help with this issue. We decompressed a mysql archive on a Solaris
box with gnu tar and tried to run this script ./configure
--prefix=/usr/local/mysql but was unsuccessful and received this error.
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Prepari
It depends on the gui you're using. Get the one at my.anse.de
At 07:49 AM 4/24/2001 -0700, Jason Holliston wrote:
>This is probably something I'll smack my head about afterward, but here
>goes: is it possible to execute multiple queries in the MySQL client GUI on
>Win32? What's accepted on the
Hi all,
I recently had cause to drop and re-create a merge table that maps 80 or so
tables (I'd added an index to all the tables whilst they were mapped, so
causing me to get incorrect results. Duh!).
However, upon re-creating it, I find that I'm now not getting any results
back (or only one or
I believe that stored procedures are still on the TODO list, but that might
not fit into your client's plans.
Recall that stored procedures are a form of "compiled" SQL code. Therefore,
if you want, you could take that SQL code, in the stored procedure, and put
it into your VB application and exe
Hello,
I set up a bi-directional binary replication with mysql. It is very
nice: some tables go one direction, some in the other direction.
Everything over a ssh tunnel (stunnel).
But:
It seems that the slave thread is "pausing", without reason. "SHOW SLAVE
STATUS" shows normal: no error, slave is
This is probably something I'll smack my head about afterward, but here
goes: is it possible to execute multiple queries in the MySQL client GUI on
Win32? What's accepted on the command line or in a .sql script doesn't work
when pasted into it. Thanks in advance!
-Jason
--
> "PJM" == Patrick J Militzer <[EMAIL PROTECTED]> writes:
PJM> I'm using mysql 3.22.27. How can I force mysql to use index's in
PJM> my select statement?
You don't. SQL is a 4GL and you only describe what you want, and it
is up to the language interpreter and optimizer to do it efficiently
Istiaque Hussain wrote:
>
> Dear Friends ,
>
> One of our clients wants to port the Database which was originally in MS SQL , to
>MY SQL . he main problem we are facing is that how to make previous stored procedures
>run . There are a lot in the application . Front end was in VB .
> We are
Hello,
Your column counts don't match. You call out 24 columns in in your
insert statement, but you only have 20 values.
Curtis
On Tue, 24 Apr 2001, J.Heegsma wrote:
> Dear Sir/Madam and mysql users,
>
> I have a mysql database which i can fill with phpadmin, everything is going fine,
>bu
Dear Friends ,
One of our clients wants to port the Database which was originally in MS SQL , to MY
SQL . he main problem we are facing is that how to make previous stored procedures run
. There are a lot in the application . Front end was in VB .
We are now into feasibility study . Please
Once again.. a PHP issue..
You might want to try with PHP4.. latest release. If that doesn't help go
the archives @php.net..
Bye,
B.
mysql, query
At 15:16 24-4-01 +0200, [EMAIL PROTECTED] wrote:
>I have a system built up with Debian potato and apache. I have to install
>(to copy) a database
New Style MySQL Personnel wrote:
>
> >
> mysql> use lum
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Didn't find any fields in table 'users'
> Database changed
> mysql> select * from users;
> ERROR 1017:
My hint is inserted in code. This can help ,if you have connection established and
proper database selected. If you dont't know what I'm talking about, try
http://www.php.net/manual/en/function.mysql-select-db.php
there is also small example included.
Mirek Novak
Require ('connect2.php');
>
Scott wrote:
>
> I am running into a problem here with a general query that is essential
> to the vitality of a website that I run. The problem is that every time
> this query is executed, it is being copied to a temporary table on the
> hard disk, causing an extreme slowdown. In some instances
Hi there
I desperatly need a binary installation of MYSQL that includes the BDB table
format for Windows. I have tried to compile this myself but the
mysqld-max-nt.exe crashes immediatelly on start.
I am trying to migrate my application for a deadline to MYSQL, and I need to
test it with the BDB
I have a system built up with Debian potato and apache. I have to install
(to copy) a database from a Mandrake system - so I installed the php3
modules for apache (restarted the apache) and the Debian package of
mysql-server and mysql-client.
Can you help me, why I get the following error message
N6REJ wrote:
>
> I was looking throught the manual and it seems I should add the --secure and
> the --safe-show-database diretives. But if I try to add them to the
> /etc/rc.d/init.d/mysql script the daemon refuses to start. What is the
> proper way to do this?
>
> Troy
> [EMAIL PROTECTED]
>
Here we go again
This is a PHP issue NOT MySQL.. more info: www.devshed.com
www.phpnewbie.com www.phpbeginner.com www.php.net
One hint.. don't forget ?> to close PHP code..
Bye,
B.
mysql, query
At 14:46 24-4-01 +0200, J.Heegsma wrote:
>Dear Sir/Madam and mysql users,
>
>I have a mysql
jgw wrote:
>
> I'm trying to compile a program using C API. I get the following errors:
>
> /usr/lib/mysql/libmysqlclient.a(my_open.o): In function `my_open':
> my_open.o(.text+0x14): undefined reference to `open64'
> /usr/lib/mysql/libmysqlclient.a(mf_format.o): In function `fn_format':
> mf_f
"Steven P. Kerscher" wrote:
>
> I have installed mysql 3.23.36 for the first time ever
> I did the test (ok)
> I ran the bench mark and could not load DBI
> I installed DBI 1.14
> And Data Showtable 3.3
> Then tried to install (Msql-Mysql-modules-1.2215)
>
> Perl Makefile.pl worked fine
> I run
Dear Sir/Madam and mysql users,
I have a mysql database which i can fill with phpadmin, everything is going fine, but
when I want to fill the database with php and a form. I got the following problem. I
don't know what to do anymore? Can anyone help me?
I have made a form, which visitors can f
Michael Zielinski writes:
> Hi,
> I've tried to install MySQLGUI 1.7.5 on my system. I',ve followed the
> instructions on the webpage and it seems to compile nicely, but when I try to
> start it, I get the following error :
> "./mysqlgui: error while loading shared libraries: libsqlplus.so.1: ca
James Bonham writes:
> Help ! Does anyone have a clue ?
>
> tried to run configure on Ultra SPARC/Solaris 2.7
>
> GNU binutils and libtool latest version, gcc 2.95.2
>
> environment variables:
> CC=gcc
> CFLAGS=-O6
> CXX=gcc
> CXXFLAGS=-O6 -felide -constructors -fno-exceptions -fno-rtti
>
> a
On Tuesday 24 April 2001 04:29, [EMAIL PROTECTED] wrote:
> >Description:
> We have a production server with mysql as db server. Currently we
> are using 1 server for only processing a mysql queries and ther is
> 4 mysql servers running on it each using diiferent IP. When I try
>
Hello,
I have a problem in writing a servlets which access to
mysql database, that can generate a french caracters
like é, à
Can some Help me.
___
Do You Yahoo!? -- Pour faire vos courses sur le Net,
Yahoo! Shopping : http://fr.shopping.yah
At 10:56 AM +0200 4/24/01, Sven Heising wrote:
>Hi list
When posting help requests, it's always helpful to include the error
message you get. You can check quickly this via something like:
mysql_query("DELETE FROM $dtable where loginid = '$userto' ")
or
mysql_error();
One possible
>I have mysql installed on two linux boxes.
>How can i access one system's mysql db from the other system
grant access to the user on the other system. COnnect to the remote system
just like you would on the local.
Bye,
B.
---
COME ON
This_is_not_a_MySQL_issue.. It has everything to do with PHP.. please keep
this discussion in the PHP lists..
By the way, crossposting isn't the way to make friends..
Looking for more info on PHP and MySQL go to some URL's mentions a
million times in several PHP lists.
Bye,
I have mysql installed on two linux boxes.
How can i access one system's mysql db from the other system
thanks
Harish
Hi!
On Apr 24, Scott Vanderweyst wrote:
> I know that the web-page says it may return bizzare results in small
> cases, but I would have expected it to return consistant results though.
>
> I came across this due to an inconsistancy that I ran across in an
> application that I've been working on
I'm probably out of my depth here, but please have a look at my forum at
http://forum.celinestar.org.uk. The error messages are like this:
Warning: 0 is not a MySQL result index in functions.php on line 16
Warning: 0 is not a MySQL result index in functions.php on line 21
Warning: Oops, php3_
hi All,
I have in Tomcat JDBCRealms, A broken pipe SQLException, So I wonder
what is wrong in my code. This exception occur only after a long period of
time, while sessions should be dead long times ago. So I wonder if the
connection Pool I use ( org.ewin packadge ), released correctly the
>
mysql> use lum
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'users'
Database changed
mysql> select * from users;
ERROR 1017: Can't find file: './lum/users.frm' (errno: 13)
> >
My application is written in .asp and the database is mysql. do i need
myodbc to set the DSN/connection? (running in linux box)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
>Description:
We have a production server with mysql as db server. Currently we
are using 1 server for only processing a mysql queries and ther is
4 mysql servers running on it each using diiferent IP. When I try
to make 1 common mysql server it just recieving signa
I am having a problem with setting up a query in using MySql. The query uses a
user-defined parameter and searches the table against it. e.g.
int search//user peramater
select * from table
where member_id = :search;
When trying to run this query (using powerbuilder) it doesnt return the de
> >If there is a function to sum values, why there isn't one to sum strings
> >i.e. concat strings. Or how should i use it?
>
> You use concat to put two strings together.
I know, i have read the manual. /concat('string1','string2')/, but it
doesn't works with group by.
>>>
I would like to get t
Barry,
I suspect you might have more luck sending your question to a
PowerBuilder list (what is it anyway ? A Borland product ?), althought
you might have some luck here...
regards,
P
On Tue, 24 Apr 2001, Barry Reynolds wrote:
> I am having a problem with setting up a query in using MySql. Th
>Hi
>SQL troubles:
>I have a table containing 4 columns: "name" - string, "distance"-
>double,
>"speed" - time and "id" - AUTO_INCREMENT (Primery key)
>I want a list of the fastest (speed) runner (name) of each distance and
>the
>speed.
>I use:
>select name, distance, min(speed) from table1 group
> Installing all prepared tables
> 010423 11:09:07 Warning: setrlimit couldn't increase number of open files
> to more than 200
> 010423 11:09:07 Warning: Changed limits: max_connections:
> 100 table_cache: 64
> scripts/mysql_install_db[284]: 15102 Memory fault(coredump)
> Installation of grant ta
I am running into a problem here with a general query that is essential
to the vitality of a website that I run. The problem is that every time
this query is executed, it is being copied to a temporary table on the
hard disk, causing an extreme slowdown. In some instances it takes up
to 5 minute
Hi Everyone,
It looks like I have a common problem running the mysql_installation_db
script on a HP/UX 10.20 workstation:
Installing all prepared tables
010423 11:09:07 Warning: setrlimit couldn't increase number of open files
to more than 200
010423 11:09:07 Warning: Changed limits: max_connec
Hi list
got a problem againcan't delete :
$db=mysql_pconnect($host,$dbuser,$pass) or
die($dbfehler);
echo "$userto";
mysql_query("use $dbase;");
mysql_query("DELETE FROM $dtable where loginid = '$userto' ");
what is wrong with this?
thanx in advance
sven
-
Hi,
I've tried to install MySQLGUI 1.7.5 on my system. I',ve followed the
instructions on the webpage and it seems to compile nicely, but when I try to
start it, I get the following error :
"./mysqlgui: error while loading shared libraries: libsqlplus.so.1: cannot
open shared object file: No su
1 - 100 of 103 matches
Mail list logo
