Rick,
sorry, it is not mentioned in the manual that MySQL performs a CREATE INDEX
by doing an ALTER TABLE. And ALTER TABLE has the feature (= documented bug)
that it removes foreign key definitions.
You should define all your indexes within the table create statement, like
in:
CREATE TABLE pare
dear sir,
please help me out to install the mysql windows version.the problem is i
have only windows 98 as stand alone.i donot have windows NT SERVER.
so can mysql be installed on windows 98 as stand alone without the help of a
server.please mail back.
>Is it possible to have global access to all databases using the new odbc
>driver? For example I have an app that uses more than one table owner. In
>Mysql, I had to set up a db for each owner but when I try to connect through
>the odbc, I don't have access to all the databases, just one. How c
Jeff,
Friday, March 01, 2002, 12:05:36 AM, you wrote:
JK> Thanks for the reply. Does it actually hurt to index them on lower volumes
JK> of traffic? Or is it neglible?
Just try and you'll see, it really depends on your context.
JK> --jeff
>> Jeff,
>> Thursday, February 28, 2002, 7:14:51 AM, y
Yeah no problem. I believe you will need to run the following:
mysqld-nt --standalone
HTH
Neil
Rajesh Chabria wrote:
> dear sir,
> please help me out to install the mysql windows version.the problem is i
> have only windows 98 as stand alone.i donot have windows NT SERVER.
> so can mysql be
* Doug Thompson
> On Thu, 28 Feb 2002 22:38:04 -, DL Neil wrote:
>
> >I know it's getting late, so perhaps I'm not following you sufficiently
> >closely. What does "inherited" mean?
> >
>
> "Inherited" referred to using the float(10,4) formatting of the
> "numbers" field in this case.
It seem
Hi ppl,
I am having problem with my existing application (writen in VB with ODBC to
an Access database). The program "starts crawling.." after running for a
period of time. Slow down the entire production process.
I was advise to change the database as the problem was most likely to be due
to th
Hi,
Its okey for the server to installed in windows 98 machinei currently
use it as my database server.
Just download the complete MySQL win32 executable and run MySQLD...and make
sure that you're MY.CNF file is located in c:\and it is set as
needed
Just that simple...I even install
Li,
Friday, March 01, 2002, 8:23:33 AM, you wrote:
Leoen> Hi, all MySQL team
Leoen> How can we get MySQL database size?
If you want to know the size of disk space used for database
you should probably check the size of database directory in the datadir.
To know the table size you can use SHOW
Rajesh Chabria,
Go here: http://www.webmasterbase.com/article/525/8
Pay attention to details, and you will have Mysql, PHP, and Apache,
up and running in no time.
I have Win98 second edition. Every thing is working for me.
Chuck
=
- Original Message -
From: "Rajesh Chabr
Hello ,
I have some problems with borland builder 5.0. I can't connect to mysql server via
API.
I have error in obj file
--
Best regards,
Alexander mailto:[EMAIL PROTECTED]
-
Before posting, pl
Hi,
I am planning to have MySQL database backup and recovery from the web
interface.
Is it possible to do this. If yes, then what procedure I should follow.
If anybody have any idea about this then please, do help me. It's our
requirement.
Thanks and regards,
Chetan Lavti
-
Hi,
If anyone can help me !!
Suppose I have a table :
mysql> select * from flag_test;
++--+
| name | flag |
++--+
| Chetan | Y|
++--+
1 row in set (0.00 sec)
I am setting/unsetting the flag field from the api's ;
Now if the flag is already set and I
Hi
The question concerns HEAP tables and the answer can be found in Chapter 8
section 8.4 HEAP Tables
At 12:04 01/03/2002 +0200, Victoria Reznichenko wrote:
>Li,
>Friday, March 01, 2002, 8:23:33 AM, you wrote:
>
>Leoen> Hi, all MySQL team
>Leoen> How can we get MySQL database size?
>
>If you wan
I have Apache and MySQL both installed on W98 with no problem at
installation or running.
I think, yes, is possible to install and run MySQL only.
But how you can use it without php for example?
Makis
> -Original Message-
> From: Rajesh Chabria [mailto:[EMAIL PROTECTED]]
> Sent: Friday,
Rajesh,
Friday, March 01, 2002, 6:20:07 AM, you wrote:
RC> dear sir,
RC> please help me out to install the mysql windows version.the problem is i
RC> have only windows 98 as stand alone.i donot have windows NT SERVER.
RC> so can mysql be installed on windows 98 as stand alone without the help o
Hi Chetan,
Suppose I have a table :
mysql> select * from flag_test;
++--+
| name | flag |
++--+
| Chetan | Y|
++--+
1 row in set (0.00 sec)
I am setting/unsetting the flag field from the api's ;
Now if the flag is already set and I executes the Query f
At 09:07 01/03/2002 +0200, savaidis wrote:
>I have Apache and MySQL both installed on W98 with no problem at
>installation or running.
>I think, yes, is possible to install and run MySQL only.
>But how you can use it without php for example?
What has PHP got to do with running MySQL. I neither ha
Hi,
What kind of API,Component do you use with C++Builder5?
Alexander Omelanuk wrote:
>
> Hello ,
>
> I have some problems with borland builder 5.0. I can't connect to mysql server via
>API.
> I have error in obj file
--
TAKAHASHI, Tomohiro
-
Hi
I think you need to read a book on C since C has no notion of a boolean value
At 11:40 01/03/2002 +, DL Neil wrote:
>Hi Chetan,
>
>Suppose I have a table :
>
>mysql> select * from flag_test;
>++--+
>| name | flag |
>++--+
>| Chetan | Y|
>++--+
>1 r
Hi,
there are a couple of bugs related to the round() function. (See the thread
'Can somebody help me with "round (columna,columnb) "?')
One bug is already well known and documentet, it is related to different C
library implementations on different platforms: the result of round(2.55,1)
may be 2
Hi, I have a problem accessing MySQL database. I have a database changes_db
and when I access it with mysql -h jon -u join -p changes_db, I have no
problems. But if I use Perl script to access same database I get:
DBI->connect(database=changes;host=jon;port=) failed:
Access denied for user: 'join
Hello All,
I have been lurking here for the past couple of weeks and learning a
bunch, thank you for all of your posts, just listening to you guys is
great.
We are developing a web based file management interface for
collaboration and security.
- Login script
- Add three levels of security
-
Thi Cao writes:
> Hi everyone,
>
> I recently unpacked the Mysqlgui static binary distribution for windows and
> placed the MySQL.help file along with the my.cnf.win file in the c:/ root
> directory. I have the line
>
> help_file=c:/MySQL.help
> (also tried c:\\MySQL.help)
>
> in the my.cnf.
Hi,
I want to convert a MS SQL 7 DB to mysql DB. They make use of sp_addtype to
define user defined data-types in the DB. Does mysql have the possibillity
to define user-defined datatypes? Or is there another way to do it?
greetings,
Patrick
---
Rob Steele writes:
> Thanks. I don't think this feature is working as the documentation says
> it should. Section 4.2.4 of the manual says:
>
> By default all MySQL clients and libraries are compiled with |
> --enable-local-infile|, to be compatible with MySQL 3.23.48 and before.
>
>
Are you using the latest version of DBI? Also, your "if ($dbh) {" seems a
little backward. According to the DBI docs, "If the connect fails (see
below) it returns undef and sets $DBI::err and $DBI::errstr." So shouldn't
your conditional be "if (!$dbh) {". Perhaps you are actually connecting.
I'
I am programming the scripts of the Intranet of my Office, and I am using
PHP and MySql. I would like that when I execute a search the results would
be show on pages with 20 results per page. Is that possible???
Thank you
Daniel F. Castro
---
James wrote:
>
> I'd like to install MySQL on MAC OS X 10.1
>
> I've notice it's using Darwin 1.4
>
> But the binaries for MySQL appear to say for Darwin
> 5.1
>
> What should I do?
Apparently Apple decided to move Darwin's version number to 5.1 when it
shipped the update of OS X 10.1.1. I ha
I am programming the scripts of the Intranet of my office, and I am using
PHP and MySql. I would like that when I execute a search the results would
be show on pages with 20 results per page. Is that possible???
Thank you
Daniel F. Castro
--
Here's my query so far:
mysql> SELECT pj,
> SUM ( hours ) AS 'Totals',
> SUM( IF ( MONTH ( period ) = 01, hours, 0 )) AS 'Jan',
> SUM( IF ( MONTH ( period ) = 02, hours, 0 )) AS 'Feb',
> SUM( IF ( MONTH ( period ) = 03, hours, 0 )) AS 'Mar',
> SUM( IF ( MONTH ( period ) = 04, hours, 0 )) AS 'Apr'
Nope,
Sorry, but nowhere I was thinking about the boolean value.
I was only talking about the return value of mysql_affected_rows(Mysql
*)and it's return type is (unsigned int), which depends upon the no of
rows affected by the last query.
I have just ask you based upon a very rough table( flag_t
Wilbur,
Friday, March 01, 2002, 5:28:56 AM, you wrote:
WS> I'm working on indexing words in web pages, and I'm finding a significant
WS> issue with the performance of MyODBC, even when I resort to using batch
WS> mode inserts..
WS> I'm currently using the older version of MyODBC, and basically
Scalper,
Thursday, February 28, 2002, 10:49:59 PM, you wrote:
S> I am curious about the geographical usage of MySQL. Judging from the users
S> on this list it seems like it is used more heavily in Europe than in Asia
S> and the Americas. To date, has there been any formal studies or polls tak
Uma,
Friday, March 01, 2002, 6:27:17 AM, you wrote:
UST> I am using local language for inserting values in mysql.While sorting in
UST> mysql is checking 7bits from the right.Is there any thing like this for
UST> checking 8 bits in mysql
That's a question of a readline library, not mysql.
Put
Daniel,
Friday, March 01, 2002, 3:22:59 PM, you wrote:
DFC> I am programming the scripts of the Intranet of my Office, and I am using
DFC> PHP and MySql. I would like that when I execute a search the results would
DFC> be show on pages with 20 results per page. Is that possible???
You can us
Hector,
Thursday, February 28, 2002, 7:51:39 PM, you wrote:
HR> Hi Everybody, I have a problem with MySQL when I try to store
HR> image file on it. I use a Blob field but the info that must be
HR> stored there should be between quotations marks right? Like a
HR> string , i mean "GIF89kjflH..
Alvin,
Friday, March 01, 2002, 12:26:20 PM, you wrote:
AA> I am having problem with my existing application (writen in VB with ODBC to
AA> an Access database). The program "starts crawling.." after running for a
AA> period of time. Slow down the entire production process.
AA> I was advise to cha
Chetan,
Friday, March 01, 2002, 5:56:36 AM, you wrote:
CL> I am planning to have MySQL database backup and recovery from the web
CL> interface.
CL> Is it possible to do this. If yes, then what procedure I should follow.
Well, specify what exactly do you need - a backup procedure initiated
from
Sam,
Thursday, February 28, 2002, 5:46:39 PM, you wrote:
S> I had install today THE RPM version 2.23.49 of MySQL,
S> files I took from MYSQL.com (and mirrors). I have a
S> linux computer, RedHat version 7.2.
S> I had no problem with rpm -i, except with the bench
S> rpm file.
I suggest you to up
Adam,
Tuesday, February 26, 2002, 11:12:58 PM, you wrote:
AK> Sasha, I am on Rehat 7.2 and am experiencing exactly the same signal 4
AK> problem. I have pasted the ouput from the rpm install, execution of the
AK> mysqld with --log, and as you requested, the cat info for my box.
AK> RPM -i outpu
xinfo,
Tuesday, February 26, 2002, 6:17:04 AM, you wrote:
>From: [EMAIL PROTECTED]
>Description: Fresh install of Red Hat 7.1 - no patches or updates of
x> any kind. Unable to install MySQL 3.23.49. Following the
x> installation instructions provided. The following ste
- Original Message -
From: "Daniel Ferreira Castro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 1:22 PM
Subject: Showing results of a search
> I am programming the scripts of the Intranet of my Office, and I am using
> PHP and MySql. I would like that when
At 19:22 01/03/2002 +0530, Chetan Lavti wrote:
>Nope,
>Sorry, but nowhere I was thinking about the boolean value.
>I was only talking about the return value of mysql_affected_rows(Mysql
>*)and it's return type is (unsigned int), which depends upon the no of
>rows affected by the last query.
>I hav
Hi,
I'm sure this has been asked before, but I couldn't find it in the archives,
so here goes...
I want to setup a web server that also has MySQL on it, with several user
accounts, each user has their own home directory and a virtual host entry in
Apache for their website. I also want to have ea
Hello,
can MySQL manage transactions?
Someone said me no. Is it true?
Thank you
Paolo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Thanks for your answer;
This morning, as I had no answer, I loaded the binary
mysql-3.23.49a-pc-linux-gnu-i686.tar.gz from mysql.com
and I run it with success.
There is a contradiction with the first point of your
explanation "the .49 was compiled for i686 by
accident; .49a is compiled for i386"
Hi all,
I am a newbie to mysql and I want to setup a web server that also has MySQL
on it, with several user accounts, each user has their own home directory
and a virtual host entry in Apache for their website. I also want to have
each users MySQL database(s)
physically located within their hom
* Paolo Cavicchini
> can MySQL manage transactions?
> Someone said me no. Is it true?
Yes and no... this depends on the version of mysql and the used table
handler: MyISAM is the default table handler, and it does not support
transactions. InnoDB and BDB are two other table handlers, they _do_ su
Is it possible to specify more than one owner in a mysql db? I want to
create tables with different owners.
Thanks,
Eddie
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Hello,
Today, I compiled MySQL (mysql-3.23.49.tar.gz) on a Debian Potato system. I
configure'd with following options:
./configure --prefix=/usr/local/mysql --with-innodb
"make" and "make install" ran without any problems. Then I followed the
instructions in the INSTALL-SOURCE file. Everything
I need to have unique id's for every data element in my system no matter which table
it's in. In Oracle I can create a sequence and with one SQL query I can increment the
value and retrieve it for use in my next insert.
Can I do this in MySQL? I know about AUTO INCREMENT but that appears to
At 14:20 +0800 3/1/02, [EMAIL PROTECTED] wrote:
>Hi, all
>
>How to get the e-books of My SQL via download.
>
>Thanks , Dominic ZHOU
The MySQL Reference Manual is available at: http://www.mysql.com/
Safari has some MySQL books: http://safari.oreilly.com/
The listings include MySQL (New Riders) a
I am attempting to generate a query statement (using PHP) that is generated
based on user input from 2 sets of checkboxes. You can see a
barely-functioning version at this URL:
http://www.nobleaccord.com/view/view.php
The top part of the form just shows what the query statement looks like.
The
At 10:25 -0500 3/1/02, Edward Peloke wrote:
>Is it possible to specify more than one owner in a mysql db? I want to
>create tables with different owners.
Databases and tables in MySQL don't have owners. They just exist.
But you can grant access to them by more than one MySQL user account,
if th
Paolo,
Friday, March 01, 2002, 4:58:54 PM, you wrote:
PC> Hello,
PC> can MySQL manage transactions?
PC> Someone said me no. Is it true?
MySQL has transaction-safe tables, such as InnoDB and BDB. InnoDB and BDB
tables are supported in MySQL-max.
Take a look at the following links where you will f
Edward,
Friday, March 01, 2002, 5:25:23 PM, you wrote:
EP> Is it possible to specify more than one owner in a mysql db? I want to
EP> create tables with different owners.
Yes, it's possible. You can specify many users with different grants
on the same database, table, column...
You should use
Keith,
At 21:51 2002-02-28, you wrote:
>That has certain advantages, but it's a pain for the user if it's in
>a application where you have to enter a lot of dates or fill out a
>form repeatedly. For that sort of data entry, typing digits is far
>preferable to selecting from a dropdown list.
I was wrong. My slave servers are STILL 'hanging' and not continuing
to replicate. They give no errors, the slave appears to stay running,
it just lags behind the master. Nothing I have done has fixed this.
Again I'm running 3.23.49.
To "fix" the problem I issue a slave stop, slave start comm
Hi all,
I just made the stupidest mistake I ever done:
I installed mysql on a RH Linux machine. And as usual I wanted to setup the
users I need and take out the ones that I don't. Only when I executed a
query, I did not realize that instead of deleting two users I deleted all
users...
And gu
Hi,
Is it possible to make simultaneous 2 SQL queries in a MySQL database( update,
insert and the other) on only 1 table.
Because my DB is on a server and i I've 5 clients who works on the same table.
Samuel
-Message d'origine-
De: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Date:
This is the sort of thing I would do
$tmpquery = "SELECT item_pic, cat, sub, item_name, username FROM item_name
WHERE 1=1 AND";
if($category)
{
$filter1 = " cat =\"";
$filter1 .= implode("\",\"",$category);
$filter1 .= " \" ";
$tmpquery .= $filter1;
$tmpquery .= " AND ";
}
if($subcat)
{
$filter2
Cip,
Friday, March 01, 2002, 6:12:54 PM, you wrote:
C> I just made the stupidest mistake I ever done:
C> I installed mysql on a RH Linux machine. And as usual I wanted to setup the
C> users I need and take out the ones that I don't. Only when I executed a
C> query, I did not realize that inste
Hi all,
I have a seperate linux server with just mysql running on it. But there are
alot of other things that I may need to take off. Anyway yesterday I
noticed after running TOP that the memory usage was real high. I did a
shutdown and checked it after the reboot and the memory usage was way d
Hello sql guru's, I need help find SQL to solve a problem:
I have two tables, the first is persons:
person_id int unsigned not null auto_increment
firstname varchar(25)
lastname varchar(25)
The second is person_orgs
person_id int unsigned not null
org_id int unsigned not null
A person may be
I started replicating the MySQL DB on our production server last month.
I was wondering if anyone who has been doing replication for a while has
seen the need to resync the slave. (i.e. snapshot the master, install
on slave, and re-start replication from snapshot)
Are there systems out there th
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I was wondering if anyone knows of a module for perl to talk to mysql w/o
DBI/DBD. Some sort of shell interface or something.
Mike.
- --
*
* Mike Baranski *
* Security Managment Consulting *
* 919-78
Hi.
On Fri, Mar 01, 2002 at 01:14:43PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
>
> there are a couple of bugs related to the round() function. (See the thread
> 'Can somebody help me with "round (columna,columnb) "?')
>
> One bug is already well known and documentet, it is related to different C
Hello, look I'm trying to insert an Image into a blob field with a Normal insert
query. I know that the information that will be contained on the blob field should be
between " (quotation marks), but if inside the info of the image is a quotation mark
it should be escaped with a \ (back slash).
At 11:51 -0500 3/1/02, Mike Baranski wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>I was wondering if anyone knows of a module for perl to talk to mysql w/o
>DBI/DBD. Some sort of shell interface or something.
DBI is mature technology, you're probably better off using it.
Perhaps its
Mike,
http://www.gossamer-threads.com/scripts/mysqlman/index.htm
Its good.
David
At 11:51 AM 3/1/02 -0500, Mike Baranski wrote:
>-BEGIN PGP SIGNED MESSAGE-
>Hash: SHA1
>
>I was wondering if anyone knows of a module for perl to talk to mysql w/o
>DBI/DBD. Some sort of shell interface o
At 10:09 -0700 3/1/02, Hector Rosas wrote:
>Hello, look I'm trying to insert an Image into a blob field with a
>Normal insert query. I know that the information that will be
>contained on the blob field should be between " (quotation marks),
>but if inside the info of the image is a quotation m
I've brand new to Mysql, and for now I have one machine, a private one, with
a mysql database. No I want to move this database over to another computer.
How do I do it?
-
Before posting, please check:
http://www.mysql.com/man
I was thinking more along the lines of creating a db called test and
creating two tables:
test.clients and test2.clients
Like you can do in MSSQL, create many table owners in the same db.
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 200
I've recently upgraded to the newest version of php and since doing so
many of my pages no longer work when it comes to updating, for whatever
reason. I simply do not have the time to waste trying to figure out why
so I'm thinking of going back to the previous revision I had on the box.
I'm ru
At 12:27 -0500 3/1/02, Edward Peloke wrote:
>I was thinking more along the lines of creating a db called test and
>creating two tables:
>test.clients and test2.clients
Huh? Those are two tables in different databases, not two tables in
the same database.
>
>Like you can do in MSSQL, create many
On Fri, Mar 01, 2002 at 09:49:33AM -0700, Guy Davis wrote:
> I started replicating the MySQL DB on our production server last
> month. I was wondering if anyone who has been doing replication for
> a while has seen the need to resync the slave. (i.e. snapshot the
> master, install on slave, and
Edward Peloke wrote:
>
> I was thinking more along the lines of creating a db called test and
> creating two tables:
> test.clients and test2.clients
>
> Like you can do in MSSQL, create many table owners in the same db.
> -Original Message-
Since you read the Grant section at
http://ww
I have a database that tracks letters to the editor published in my
paper. The table includes a date field and a status field. Status can
be either "input" or "published."
What I want to do is create a report that tells me how many letters
were published on each of the last 30 days.
Is there a
* Benjamin Pflugmann
[me about round(2.55,1) -> 2.5 or 2.6 on different platforms.]
> I would argue whether that is a bug... it is inconsistent on different
> platforms, but it is consistent with the behaviour of other programs
> on the same platform. You always break the one or the other thing.
I am trying to get it to work more like it does in MSSQL. In MSSQL, you can
create a db named whatever and have several different "owners" in the
database. For example in a database named 'Eddie' I can create a table
named ed.table1, pe.table2, etc. In MYSQL, I can only create tables
prefixed b
SELECT COUNT(*) AS number_of_letters FROM tablename WHERE TO_DAYS(NOW()) -
TO_DAYS(datefield) <= 30 AND status='published' GROUP BY datefield;
But this won't return anything for the days when no letters has been
published though...
Gurhan
-Original Message-
From: John Hughes [mailto:[E
Hello,
I'm running the latest MySQL on RH Linux 7.2, and I'm trying to figure out
how to make the MySQL server accessible via the net (on port 3306, I assume).
Right now, the server is just accessible from the localhost.
-J
-
Edward Peloke wrote:
>
> I am trying to get it to work more like it does in MSSQL. In MSSQL, you can
> create a db named whatever and have several different "owners" in the
> database. For example in a database named 'Eddie' I can create a table
> named ed.table1, pe.table2, etc. In MYSQL, I c
I need to change the variable ft_min_word_len, in mysql 4.0.1
The manual doesn't say how:
Here's the closest it comes:
SHOW VARIABLES shows the values of some MySQL system variables. You can also
get this information using the mysqladmin variables command. If the default
values are unsuitabl
I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My attempt
to install MySql 4.01 ends there.
I did some reading and found that "libmy
I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My attempt
to install MySql 4.01 ends there.
I did some reading and found that "libmy
Ronald Arenas wrote:
>
> I have installed MySql 3.23.49, PHP 4.06, and Apache 1.3.20 successfully on
> my RH 7.2 box. Now I try to install MySql 4.01 (after removing MySql
> 3.23.49) I get a "Php-mysql.4.xx requires libmysqlclient.so.10". My attempt
> to install MySql 4.01 ends there.
>
> I di
Hi,
Try to upgrade PHP to the latest version (4.1.2) , it should run fine.
Regards,
Jocelyn Fournier
- Original Message -
From: "Ronald Arenas" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 9:18 PM
Subject: Please Help! MySql 4.01/PhP 4.06 looking for
On Friday 01 March 2002 9:21 am, BLANCHET wrote:
> Hi,
> Is it possible to make simultaneous 2 SQL queries in a MySQL database(
> update, insert and the other) on only 1 table. Because my DB is on a server
> and i I've 5 clients who works on the same table. Samuel
For reasonable definitions of
Hi!
On Mar 01, Steve Rapaport wrote:
> I need to change the variable ft_min_word_len, in mysql 4.0.1
>
> The manual doesn't say how:
>
> Here's the closest it comes:
>
> SHOW VARIABLES shows the values of some MySQL system variables. You can also
> get this information using the mysqladmin va
PHP is looking for the client library that gets installed with MySQL
3.23.4+. Now, you can try a QUICK fix that might not work, but it's worth a
shot. Go to the directory that has the libmysqlclient.so.11 file and type
the following:
ln -s libmysqlclient.so.11 libmysqlclient.so.10
That should cr
What is the memory being used for? Linux aggressively caches data, so if
most of the memory is showing up as 'cached' or 'buffered', then the high
memory usage is caused the system's normal response to lots of database
and disk activity. It's trying to keep as much data in RAM as possible.
This
Hi Jeremy,
Just out of curiosity, what kind of tables are you using on your production
system? MyISAM, InnoDB, a mix of the two, etc...
Thanks,
--jeff
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Guy Davis" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday
I'm performing a query on 2 tables:
mysql> SELECT log.id, SUM (log.hours), empnum.lname
> FROM log, empnum
> WHERE log.id = '26009'
> AND log.id=empnum.id
> GROUP BY hours;
Empty set (0.01 sec)
The log table contains id numbers (plus a bunch of other data) but no
corresponding names. The name
Hey All,
I recently got back into mysql again and haven't programmed for it in almost
a year and have a really dumb newbie question. I need to add another row of
data to an existing table what is the command to do so? Not like an UPDATE
command where you input data into the table, but rather a wh
Ronald,
I ran into exactly the same problem you describe after compiling a new MySQL
v4...
I think I can offer you an unsophisticated workaround (read: HACK!), but I'd
defer to others on the list who know much more about this than I do...
Your problem is because your new compile (or binary inst
At 21:02 +0100 3/1/02, Steve Rapaport wrote:
>I need to change the variable ft_min_word_len, in mysql 4.0.1
It's a server variable, so you set it the same way as another other
variable. Here's what's in my my.cnf file:
[mysqld]
set-variable= ft_min_word_len=3
>
>The manual doesn't say how:
>
>
Hi,
I have an application running under Access 2000 with linked MySQL tables.
At the moment I m trying to run a query to populate a second table. Some of
the data in the query is a text description and for some reason is throwing
up an error when I try to insert into the table. The error itself
Hi Big Al:
Here is an example:
INSERT INTO friends_table(first_name,last_name) VALUES('John','Johnson');
Check out: http://www.mysql.com/doc/I/N/INSERT.html
At 15:36 3/1/02 -0600, you wrote:
>Hey All,
>
>I recently got back into mysql again and haven't programmed for it in almost
>a year and
1 - 100 of 150 matches
Mail list logo
