Hi,
I've got a script setup to search two tables in a MySQL database. The
first page asks the user to select which table they'd like to search, and
then enter in some key words.
The second page then determines which table the user selected and performs
the search. Right now, I'm going
Hi,
I have a JDBC application connecting to MySQL database. It was working
fine for the queries that retrieve small amounts of data. But when the
database contains 600,000 records and the query SELECT * is fired it
gives
Java.lang.outofMemoryException. Can any of you help me out what could
be
OS: win XP
mysql : 3.23.54-max
can someone help me with this unexplainable question.
i create this in the mysql database,
CREATE TABLE `foo` (
`num` int(4) unsigned zerofill NOT NULL default
''
) TYPE=MyISAM;
after that, i tried to insert a blank data into it,
INSERT INTO foo set
hello there!
I have a backup (cd) of my former mysql installtion from an old machine
and now want to get the data out of it. in the meantime the disk crashed
and I have no chance to start the old installation again.
does anyone know how to get the data in my current mysql-installation?
just
hi
i have a database with a single table say tbl1 with an index on a
particular field say col1. when i say
select * from tbl1;
it doesn't use the index on that table.
but if i say
select col1 from tbl1;
it uses the index.
how to make mysql use the index on col1 for the first query?
thanks
My dear friend,
I suppose that you already done:
./configure --prefix=PATH_OF_THE_MYSQL_APPLICATION
After compilation you must do:
make install
and after this :
cd /PATH_OF_THE_MYSQL_APPLICATION/bin
and...
./mysql_install_db.
Regards,
Gelu
_
In the first statement you are selecting * (ALL the row) from tbl1 with no
restricting comment (e.g. where) so if you are going to select every thing
in the table you do not need to use the index (MySQL uses B-tree).
Simon
-Original Message-
From: Prasanth Krishna [mailto:[EMAIL
Hi,
hardware : Sun v880 4 CPUs, 8Go RAM, 3 disks (73Go each ; 1 for the system,
2 for datas, logs and dumps)
software : Solaris 8, mySQL 3.23.54 (+innoDB)
database : approx 40 Go of dataspace (2 or 3 tables of 1 or 2 millions of
rows) ; many selects, inserts and few updates
Question : what is
At 2:31 AM -0700 1/16/03, Prasanth Krishna wrote:
hi
i have a database with a single table say tbl1 with an index on a
particular field say col1. when i say
select * from tbl1;
it doesn't use the index on that table.
In this query, I can't see any reason to use an index...MySQL is
simply
Hi,
if I call:
my $record = $sth-fetchrow_hashref();
then:
$sth-finish();
How valid is it for me to keep referring to my $record hash pointer?
Especially if I use $sth in a subsequent transaction.
Thanks,
Jeff Snoxell
Aetherweb Ltd
http://www.aetherweb.co.uk
NB. I know I asked this
Hi,
is it possible to ignore all sql delete statement while doing
mysql replication?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
Hello guy's
The bitkeeper repository of MySQL 4.0 and 4.1 are down ? or are moved
to other machine ? I cant access :
scribthree:/temp/mysql-development/mysql-4.1# bk pull
bk://work.mysql.com:7004: Connection refused
scribthree:/temp/mysql-development/mysql-4.1#
any idea ?
Tanks
On Wed, Jan 15, 2003 at 11:55:44PM +, [EMAIL PROTECTED] wrote:
please look at page 194 of the reference manual...
(and if so how do you ask MySQL to create a temp table from the
results of aquery?)
here's an example:
mysql create temporary table tmp (name varchar(20), owner
Csongor Fagyal wrote:
Jeff Snoxell wrote:
Hi,
if I call:
my $record = $sth-fetchrow_hashref();
then:
$sth-finish();
How valid is it for me to keep referring to my $record hash pointer?
Especially if I use $sth in a subsequent transaction.
It is absolutely legal. Your $record is
In the last episode (Jan 15), Nicolas said:
On Tue, Jan 14, 2003 at 05:49:24PM +0100, Nicolas wrote:
I'm running Freebsd 4.6.2 with mysql server v3.23.49
I have a little question about using Mysql on Freebsd and having
a database on a NT 4 linked drive, using Samba (the drive
Hello friends,
I am trying to connect mySQL thru g++. I could connect the db and
execute a query. But I want to get a value from key board and pass the
same inside the query.
ie,
This is the query I am passing.
mysql_query(connection,insert into table-name values
Dobrý den,
quinta-feira, 16 de janeiro de 2003, 08:29:47, napsal jste:
GR On Thursday 16 January 2003 11:30, you wrote:
Hello guy's
The bitkeeper repository of MySQL 4.0 and 4.1 are down ? or are moved
to other machine ? I cant access :
GR see
GR
Hi,
If i understand well you wish to concatenate different strings.
Are many options but the most handy solution is if you use sprintf.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Description:
When i run scripts/mysql_install_db:
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
mysqld got signal 11;
This could be because you hit a bug. It is also possible
Hello,
I have encountered a problem when trying to compile
MySQL version 3.23.51 on Mandrake version 9.0. I've
been browsing through several pages related to
problems met while compiling that version but didn't
find anything relevant. My nerves are starting to
shake seriously...
The configure
SELECT * from mysql.tables_priv where Table_name = 'myTable';
You will probably have to log on as 'root' unless you have created
another user with the same privileges.
The mysql GRANTs system is used to control USER privileges. This means
that for a given table you can view which users can
Hi,
As per a previous thread I have found that when you use lock Tables MySql will wait
indefinitely for the lock - No timeout or error message.
Therefore let me explain my question.
Scenario:
User 1 locks files for a long running job. (write lock that prevents any access to the
files)
User
Going insane, we have a BSDI 4.2 Version running on an under powered
machine, we are trying to load up a new server with more horsepower also
running BSDI 4.2
We tried several compiled configurations and the binary distribution and the
server hangs after a about 1-2 hours of use (binary within
Muhammed,
- Original Message -
From: Muhammed Syyid [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, January 16, 2003 3:06 PM
Subject: Re: InnoDB Foreign Key Questions
Second the same question :). What does the CONSTRAINT keyword
regarding FOREIGN KEYS do?
the
Hi!
- Original Message -
From: My Deja [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, January 16, 2003 12:39 PM
Subject: InnoDB is losing records, there are gaps in autoincrement sequence
InnoDB appears to be losing records.
The version I am using is 3.32.53 in
Natale,
- Original Message -
From: Natale Babbo [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Wednesday, January 15, 2003 9:33 AM
Subject: innofb foreign keys problem
# - 3rd post - #
# - PLEASE HELP -- #
hi to all,
is it still true
--I´m brazilian. Sorry by my english
hello!
I installed
mysql-4.0.9-gamma-win
on my machine.
What means gamma ?
Thanks,
Elby.
_
MSN Hotmail, o maior webmail do Brasil. http://www.hotmail.com
Per,
we are keeping an eye on Posix AIO in Linux as the well as the DIRECT IO
flush option of files. The file os0file.c contains some rudiments for the
Posix AIO use in InnoDB.
Monty had some bitter experiences from Solaris AIO years ago. We have been
waiting for the Linux support of Posix AIO
On Mon, 2003-01-13 at 23:48, David Rock wrote:
Hello,
This is discouraging after I spent most of the weekend getting OpenSSL
working with our MySQL 4 server. Unfortunately I can't use Stunnel to secure
the connection between our website and our MySQL server because our ISP will
not allow me
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Prasad Budim Ram wrote:
Hi,
I have a JDBC application connecting to MySQL database. It was working
fine for the queries that retrieve small amounts of data. But when the
database contains 600,000 records and the query SELECT * is fired it
gives
Hi
I am attempting a simple union.
select cnumber from spouse where fd_status = A
union
select cnumber from members where fd_status = A
When I run this SQL statement I get the following error.
ERROR 1064 : You have are an error in your SQL syntax near 'union
select cnumber from members where
Heikki Tuuri wrote:
In the future, MySQL might do the following: in
CREATE TABLE abbaguu (
...
FOREIGN KEY (column1) REFERENCES frobboz (column2)
) TYPE=InnoDB;
it could check if there is a suitable index in abbaguu. If not, it would
create the index automatically.
For what its worth, and
On Wednesday 15 January 2003 22:36, Gabe Geisendorfer wrote:
Thanks, I check it out.. Any idea if this 'deficiency' is scheduled to
change?
Yes.
http://www.mysql.com/doc/en/TODO_future.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This
On Thursday 16 January 2003 11:00, Kwok Siang wrote:
OS: win XP
mysql : 3.23.54-max
can someone help me with this unexplainable question.
i create this in the mysql database,
CREATE TABLE `foo` (
`num` int(4) unsigned zerofill NOT NULL default
''
) TYPE=MyISAM;
after that, i
On Thursday 16 January 2003 00:12, vinita Vigine Murugiah wrote:
Rafal Jank wrote:
On Wed, 15 Jan 2003 11:02:44 +1100
vinita Vigine Murugiah [EMAIL PROTECTED] wrote:
HI
I'm not sure what is wrong with my CREATE TABLE syntax, Please advice
There is no index on ifname in table
It's the next step after beta - ie it's release quality, but hasn't been in
release that long. Therefore it's probably not been deployed in production
by that many people.
Bear in mind that even alpha versions have undergone and completely passed
the full set of regression tests.
After a period
* Kwok Siang
OS: win XP
mysql : 3.23.54-max
can someone help me with this unexplainable question.
i create this in the mysql database,
CREATE TABLE `foo` (
`num` int(4) unsigned zerofill NOT NULL default
''
) TYPE=MyISAM;
after that, i tried to insert a blank data into it,
What version of MySQL are you using? UNION is implemented in MySQL 4.0.0.
Check out http://www.mysql.com/doc/en/UNION.html
for more information.
Victor Pendleton
-Original Message-
From: Garry Rothert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 8:11 AM
To: [EMAIL
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
if it can't be done, why is it in the documentation already. i can
understand that if 4.0.x is still in alpha or beta stage. but now it is
almost near release (gamma).
the official
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Elby --
...and then Elby Vaz said...
%
% --I´m brazilian. Sorry by my english
I'm sure your English is better than my Portugese!
%
% hello!
Hi!
%
% I installed
%
% mysql-4.0.9-gamma-win
%
% on my machine.
%
%
On Tue, 2003-01-14 at 20:47, Jeremy Zawodny wrote:
has anyone been able to setup ssl secure replication for mysql?
I don't believe you can do that yet. There's now way to specify the
necessary credentials in the slave setup.
how do i know whether the replication is actually done over
* Elby Vaz
I installed
mysql-4.0.9-gamma-win
on my machine.
What means gamma ?
The mysql server is constantly under development. Most people use 3.23.x,
some still use 3.22.x and even 3.21.x, and some (like you) are running the
new version 4.0.x. There is also a version 4.1.x under
Sorry, messages from the sql list seem to have ceased. It's all gone very
quiet.
Steve
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hai there,
I have created a concat_grouped implementation as a mysql function. And
I thought it might interest other users too. No guarantees here, but you
might learn from it.
Find it at www.cwts.nl/buter/misc.html
Regards,
Renald
Hi.
On Thu 2003-01-16 at 13:54:14 +0200, [EMAIL PROTECTED] wrote:
Hi,
If i understand well you wish to concatenate different strings.
Are many options but the most handy solution is if you use sprintf.
Well, in C++ you would rather use stringstream, because it has better
type and bounds
I would investigate ways of writing that long running job so
that it does not require locking a table for long periods of time.
Use relative updates, break the procedure down into
smaller lockable steps with pauses for other programs etc.
Clyde wrote:
Hi,
As per a previous thread I have found
When connecting from a command line, mysql uses 3 of the columns in the user
table to decide whether or not to grant access. These are host, user, and
password. Note that in your results below, there is no
localhost-newsletter-testPass combination. What the table shows is that
clients from any
On 16 Jan 2003, at 0:37, Stefan Hinz wrote:
There's a formula to calculate the row length for dynamic MyISAM
tables here:
http://www.mysql.com/doc/en/Dynamic_format.html
Thanks for the hint, but this doesn't explain fixed length row
calculations where char(10) will give an average
Hi,
I downloaded and compiled mysql 4.0.9 gamma this morning, and
still get the same error. This doesn't seem to be related to reverse
DNS. I've got the crash from both types of client hosts (with and without reverse).
The official 4.0.9 binary version seems to work well.
What did I miss ?
Hi all,
I have this admin site where the administrators can add new ones of
their kind (admin level) and now I'm trying to make a query so no
usernames are duplicated in MySQL.
The query goes like this:
$query1 = SELECT * FROM r2k_admin WHERE adminuser = $user;
$result1 = mysql_query($query1);
Nasser wrote:
it looks as though you have created the newsletter user with plain text
password. mysql will
compare the user password against the encrypted password and will fail.
Look at the password entry in the results below starting with 61fa
If the password had been stored as plain
At 23:17 +0800 1/16/03, Ivan Hoo wrote:
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
if it can't be done, why is it in the documentation already. i can
understand that if 4.0.x is still in alpha or beta stage. but now it is
Has anybody tried to build mysql for win-ce ?
-arc
Arley Carter
Tradewinds Technologies, Inc. [EMAIL PROTECTED]
Charlotte, NC USA www.tradewindse.com
-
Before posting, please check:
On Thursday 16 January 2003 00:32, Gustavo A. Baratto wrote:
This old bug reappeared after the upgrading mysql from version 3.23.54a
(rpm provided by mysql.com) to version 4.0.8-gamma (binary provided by
mysql.com as well).
Using redhat 7.1 glibc 2.2.4-31 (which is supposed to fix this
On Thursday 16 January 2003 15:46, Elby Vaz wrote:
I installed
mysql-4.0.9-gamma-win
on my machine.
What means gamma ?
'gamma' means stability of release. You can read about different levels here:
http://www.mysql.com/doc/en/Which_version.html
--
For technical support
On Thursday 16 January 2003 09:15, Addison Ellis wrote:
how can i view privileges for a table in a db?
There is no command to see privileges on the certain table/db etc.
If you have privileges on database 'mysql' you can search through tables to
see privileges.
--
For technical
Garry,
You are using mysql version 4? Unions are only supported in version 4.
If so, the only difference I can see from your example to the manual is that
each select is in brackets in the manual. Try the query:
(select cnumber from spouse where fd_status = A)
union
(select cnumber from
At 17:13 16/01/2003 +0100, JC wrote:
Hi,
Hi,
I downloaded and compiled mysql 4.0.9 gamma this morning, and
still get the same error. This doesn't seem to be related to reverse
DNS. I've got the crash from both types of client hosts (with and without
reverse).
Was found that for some GLIBC
Keith,
thanks once again! Well, anyone here from the MySQL developer team? Or
any other guru who can explain why 10 = 11?
Here's the problem once again:
mysql DESCRIBE myrowisam;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
Hi Dave,
Couple of things: Did you see these notes? They apply to BSDi also
http://www.mysql.com/doc/en/FreeBSD.html
Do you have more that 1.2G of free memory? What version of Mysql?
Ken
P.S. my compile script
rm config.cache
CC=gcc CFLAGS=-O3 -DHAVE_BROKEN_REALPATH CXX=gcc \
Hi, Aswering my own question, I had solved the problem above
instaling gcc-c++, gcc-java, gcc-f77, and all other packages of gcc.
Then I´ve installed MySQL without any problems.
[]´s
Mauricio Bracale
-Mensagem original-
De: Mauricio Bracale [mailto:[EMAIL
Cesar,
your PHP problem is here:
$query1 = SELECT * FROM r2k_admin WHERE adminuser = $user;
It's supposed to be WHERE adminuser = '$user' , because $user is a
string.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Heesestr. 6, 12169
You could do something like have a process periodically run the non-delete
queries in the logs against another database and replicate the second
database. Wouldn't be automatic, but you'd have as much control as you like
over what goes in the other db.
Depending on what you're trying to do, it
[2003/1/17 ¤W¤È 02:55:[EMAIL PROTECTED]]
mysql2O01/1702:55:20
³nÅé¦v°tºô01¤ë16¤é·|û§ó·s³qª¾
-
¥»«H¥ó¥Ñ¨§¨§Às¤u§@«Ç¥Nµo,½Ð¤Åª½±µ¦^«H,³o¼Ë§ÚÌ·|¦¬¤£¨ìªº
¦p¤£·Q¦¬¨ì,½Ð¤Wºô§iª¾,§ÚÌ·|±N§Aªº¦W³æ§R°£ªº
On 15 Jan 2003, at 20:13, Ken Easson wrote:
SELECT DISTINCT price FROM sys_bld_foo WHERE catNum IN
('item1', 'partA', 'partB', 'partB');
It's possible that the query you want is
SELECT DISTINCT catNum, price FROM sys_bld_foo
WHERE catNum IN ('item1', 'partA', 'partB', 'partB');
or
On Thursday 16 January 2003 12:16, CheongMeng wrote:
is it possible to ignore all sql delete statement while doing
mysql replication?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___
030116 14:28:01 MySql: Table 'mysql.host' doesn't
exist
http://www.innodb.com/ibman.html
the InnoDB startup options listed in section 2 at
But to get good performance you should adjust for your
hardware
innodb_data_file_path = ibdata1:10M:autoextend
section, for example,
or my.ini. If you want to
It looks to me like 1 bit for deleted, and 1 bit for each column to
store NULL.
1 byte for 1-7 fields.
2 bytes for 8-15 fields.
Stefan Hinz wrote:
Keith,
thanks once again! Well, anyone here from the MySQL developer team? Or
any other guru who can explain why 10 = 11?
Here's the problem once
Hi!
On Jan 16, Stefan Hinz wrote:
Keith,
thanks once again! Well, anyone here from the MySQL developer team? Or
any other guru who can explain why 10 = 11?
Here's the problem once again:
mysql DESCRIBE myrowisam;
+---+--+--+-+-+---+
| Field | Type
Hi Benjamin,
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Gelu Gogancea [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, January 16, 2003 4:23 PM
Subject: Re: g++ and mySQL]
Hi.
On Thu 2003-01-16 at 13:54:14 +0200, [EMAIL PROTECTED]
On Thu, Jan 16, 2003 at 06:47:03PM +0100, Stefan Hinz wrote:
Keith,
thanks once again! Well, anyone here from the MySQL developer team? Or
any other guru who can explain why 10 = 11?
Hi Stefan,
Here is my guess. ;)
CHAR columns are fixed width. A CHAR column with a width of 10 will
Dear mysql ,
ÊÅÐàÇÅÒÊÑ¡¹Ô´à¾×èͤسáÅФ¹·Õè¤ÃÑ¡
www.geocities.com/healthclub999/hc076
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
¢ÍÍÀÑ ËÒ¡¢éͤÇÒÁ¹Õé¶Ù¡Êè§ä»Âѧ¤Ø³â´ÂºÑ§àÍÔ
ËÒ¡¤Ø³µéͧ¡ÒÃãËéÃÒª×èͶ١źÍÍ¡¡ÃسÒÊè§ email ¢Í§¤Ø³ÁÒ·Õè
[EMAIL PROTECTED] â´Âà¢Õ¹ËÑÇ¢éÍÇèÒUnsubscribe
On Thu, Jan 16, 2003 at 01:13:54PM -0300, Cesar Aracena wrote:
Hi all,
I have this admin site where the administrators can add new ones of
their kind (admin level) and now I'm trying to make a query so no
usernames are duplicated in MySQL.
The query goes like this:
$query1 = SELECT *
All -
Sorry for what is most likely a starter question! I am a newbie and
need some help.
I have a mysql DB on server rhserver.mydomain.com running RH7.2 I
installed mysqlcc on my Win2K
PC to access that DB. No matter how I try to access the DB from within
mysqlcc, I get, Host
I'm trying to compile c code with calls to mysql library (under win2000)
and I get these linker errors. any idea why?
I'm using nmake from the command line.
Microsoft (R) Incremental Linker Version 6.00.8168
Copyright (C) Microsoft Corp 1992-1998. All rights reserved.
codecin.obj : error
I am trying to install Mysql server 3.23.54a on openbsd 3.2 and I downloaded the
source.tar.gz and did tar zxvf filename and I get and unexpected end of
file error.. I have downloaded this 4 times now and all 2 times from different
sources. Any ideas what is wrong? I have been working on
It's the first KEY definition it doesn't like. If
I comment out KEY field(field), it works, except
of course then the field called 'field' is not set
as an index. ...
Daniel I'm pretty sure 'field' is a reserved word.
Daniel ... My feeling is that MySQL shouldn't allow
Daniel
I want to disable autocommit for all command-line client connections
by default (through the mysql prompt). I believe I can do this
in the [client] section of the my.cnf config file, but I have no
clue how. Three questions:
1) How?
2) Will it affect other client processes, such as those
Hi,
I compiled MySQL 3.23.54a on HPUX system, everything
runs fine.
But when I run mysql CLI, I got:
Welcome to the MySQL monitor. Commands end with ; or
\g.
Your MySQL connection id is 7 to server version:
3.23.54-log
Type 'help;' or '\h' for help. Type '\c' to clear the
buffer.
Name
While Csongor Fagyal (I belive) is correct about current behavior, the DBI
documentation explicitly says that this will break:
Currently, a new hash reference is returned for each
row. This will change in the future to return the
same hash ref each time, so don't
Sergei,
any other guru who can explain why 10 = 11?
It's because of NULLs.
Extra byte is used to mark, if the column is NULL or not.
Thanks alot for the explanation. Thanks to Gerald Clark, too, who told
me the same.
(in fact it's a bitmap, that is it would be one byte for up to 8
Hi all,
1. I need to store dynamic sized tables with different row and column sizes,
but all small tables ( like 2*5, 3*1,5*3)
2. For this purpose i created a table to store each value of the dynamic
sized table, also with the row and the column number, so this is something
like
aij for an i*j
I installed PhpMyAdmin on a Windows box using EasyPhp...
Will PhpMyAdmin run on a Linux/Apache/MySQL server? (I've got one on my desk
up
running)
If so which version should I download?
(.php files)
- Download phpMyAdmin-2.3.3pl1-php.tar.bz2
- Download phpMyAdmin-2.3.3pl1-php.tar.gz
- Download
Hello, I have a really tough problem here, I can't think of a way to make
this work
Imagine 2 tables, the first one is the main table where I keep listings
of companies and general info about them.
In the second table, I keep 1 row for each employee and an field which
points to the company
I am running 3.23 and am new to mysql
I would like to do something like this:
delete t1
from t1, t2
where t1.col = t2.col
and ...
basically deleting every row in t1 that has a matching row in t2.
4.x has mechanisms to join 2 or more tables in update and delete
statements, 3.x does not. Without
Sorry for what is most likely a starter question! I am a newbie and
need some help.
I have a mysql DB on server rhserver.mydomain.com running RH7.2 I
installed mysqlcc on my Win2K
PC to access that DB. No matter how I try to access the DB from within
mysqlcc, I get, Host
Does the box have PHP installed and configured to use MySQL?
I wouldn't go with the php3 extension, as it is outdated, PHP4 has been
stable for a while.
-Original Message-
From: Will Standley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 16, 2003 3:14 PM
To: [EMAIL PROTECTED]
Will PhpMyAdmin run on a Linux/Apache/MySQL server?
Sure, without any problem.
If so which version should I download?
(.php files)
- Download phpMyAdmin-2.3.3pl1-php.tar.bz2
- Download phpMyAdmin-2.3.3pl1-php.tar.gz
I downloaded this one ^^^
- Download
Will,
Thursday, January 16, 2003, 6:14:11 PM, you wrote:
I installed PhpMyAdmin on a Windows box using EasyPhp...
Will PhpMyAdmin run on a Linux/Apache/MySQL server? (I've got one on my desk
up
running)
Yes..
If so which version should I download?
phpMyAdmin-2.3.3pl1 is the latest
I have managed using the phpmyadmin for editing the root user to allow
another host to connect (home ip), what ever it did it messed it up, root no
longer aloud to connect to the mysql database at all. Any way to fix this?
Before I go and delete the user.MDY file and re-run the mysql_install_db to
SELECT a.* FROM company a, employee b WHERE a.id=b.cid AND b.name='joe' OR
b.name='bill';
however, this would return any companies that has ONLY one Bill or one Joe
.. I only want companies that
have BOTH. It also returns one row with the company per name it found, so
you can imagine I
On Thu, Jan 16, 2003 at 01:54:14PM +0200, Gelu Gogancea wrote:
If i understand well you wish to concatenate different strings.
Are many options but the most handy solution is if you use sprintf.
Thanks I got the answer.
sprintf(QueryStr,INSERT INTO %s VALUES ('%s', '%s', '%s', '%s'),
vinita Vigine Murugiah wrote:
Egor Egorov wrote:
On Thursday 16 January 2003 00:12, vinita Vigine Murugiah wrote:
Rafal Jank wrote:
On Wed, 15 Jan 2003 11:02:44 +1100
vinita Vigine Murugiah [EMAIL PROTECTED] wrote:
HI
I'm not sure what is wrong with my CREATE TABLE syntax, Please
At 17:00 -0700 1/16/03, Matthew Phillips wrote:
I am running 3.23 and am new to mysql
I would like to do something like this:
delete t1
from t1, t2
where t1.col = t2.col
and ...
basically deleting every row in t1 that has a matching row in t2.
4.x has mechanisms to join 2 or more tables in
mysql:ÄúºÃ!
---
±¾ÐÅΪÉÆÒâÉÌÒµÐÅÏ¢£¬·¢Ë͵ÄÄ¿µÄÊÇΪÁ˹¤×÷µÄÐèÒª£¬Èô¸øÄã´øÀ´·´¸Ð£¬Éî±íǸÒâ,ÀÍÄãɾ³ý.
Ò»ÒÚÎåǧÍòÈ«Çò·ÖÀàÓʼþµØÖ·¹âÅÌ380Ôª£¬ÖÕÉúÃâ·ÑÉý¼¶
²©ÉîµØÖ·×ÊÔ´
is there any way you can implement a secure replication via ssh or sth else?
regards,
ivan
At 23:17 +0800 1/16/03, Ivan Hoo wrote:
there seem to be a lack of documentation on this part.
Mostly because it can't be done (that I'm aware of).
if it can't be done, why is it in the
i am new to mysql.
i have got a table tab1 in my database.
i am using 4.0.3 version of mysql and the table type is MyISAM.
the tab1 has got 14 fields and about 600,000 records and is indexed on
col1 which is of varchar type
i have used the query
select * from tab1 order by col1;
which does not
97 matches
Mail list logo