Nate,
The absence of details on the db and table structure prevent testing.
However, if you 'View Source' you'll see thet the form isn't being sent to
any response page, so there's nothing to handle the query and show the
results.
'form action=?form=yes method=post'
Hope this helps
George in
En réponse à George Pitcher [EMAIL PROTECTED]:
-- Début du message d'origine
Nate,
The absence of details on the db and table structure prevent
testing.
However, if you 'View Source' you'll see thet the form isn't
being sent to
any response page, so
I have an intranet, a database mysql (i admin with phpmyadmin)
I use a program java in order to put data in mysql and i want to know
if it is possible to put prog java in php page on my intranet ?
I want to start my program on the web ?
please help!
excuse me for my english
antoine
--
MySQL
Thanks Michale. The problem is solved.:)
Michael Satterwhite [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 20 July 2003 14:18, Veysel Harun Sahin wrote:
Hello,
I have to join two columns from different tables in a query. Assume that
I have two tables:
hi listers
does this option only apply when the mysqld starts up or each time a table is opened
for read/write?
thanks
_ ___ _ __
/______/ / ___/ / \ //
/ / / // / / ^ v /
/ / / /__/ / / / \/ / /
Hello,
On Sun, 2003-07-20 at 14:59, Stefan Hinz wrote:
Matthew,
Hi, I'm clear as to what is meant by The mysql client in the MySQL core
certification revision check list. I understand that the mysql database
itself is the server. Would client then be any program that talks to the
Hi,
I've set up a ODBC DSN to connect to Mysql. This DSN works fine with MS Excel.
However, it returned the following error when I tried to link some Mysql tables from
Access 2000:
ODBC--call failed.
[MySQL][ODBC 3.51 Driver][mysql-4.0.4-beta-max-nt]Access denied for user: '@my ip
address
[EMAIL PROTECTED] wrote:
I was reading the manual and it said that the subselect is only
available in 4.1 or using the 4.0.12 with the mysqld ?new command line
to start it.
But it doesn?t working!! So I downloaded the 4.1 alpha version with the
same problem. The error is:
ERROR 1064:
Michael Satterwhite [EMAIL PROTECTED] wrote:
I'm trying to add a foreign key to a table. All tables are INNODB. Table a has
following partial Definition:
TableA
( Fld1 int Primary Key,...
)
TableB
(Fld2 int Primary Key,
Fld1 int not null, ...
)
I use the following Statement:
Hello,
I am using a threaded C program and each thread creates its own
connection to mysql database using mysql_init(). When I run Valgrind on
the program it reports that there has been a small leak stemming from
several mysql_init and one mysql_real_connect. I have read
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 20 July 2003 22:59, Tanamon wrote:
++---+--+
| id | file_name | max(version) |
++---+--+
| 6 | ffour |2 |
| 1 | fone |3 |
| 5 | fthree|
Hi
I have 3 machines M1 M2 and M3, i need to setup the following :
M1 is the master
M2 is reading from M1
M2 is a master for M3
M3 is reading from M2
The problem i got, is when i run a command in M2, it's replicated in M3,
but when the command is being run in M1, it's replicated in M2 but not in
Naoufal Rih [EMAIL PROTECTED] wrote:
Hi
I have 3 machines M1 M2 and M3, i need to setup the following :
M1 is the master
M2 is reading from M1
M2 is a master for M3
M3 is reading from M2
The problem i got, is when i run a command in M2, it's replicated in M3,
but when the command is being
Tom Roos [EMAIL PROTECTED] wrote:
does this option only apply when the mysqld starts up or each time a table is opened
for read/write?
On open.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__
PaT! [EMAIL PROTECTED] wrote:
I need a hint how to use myisamchk
I use this syntax in a shell but it doesn't work
myisamchk -R=ID \mysql\data\db\mytable.myi
ID is the index name I want to use to sort the table
I'm using mysql 4.0.13 on Win 2K server
myisamchk -Rindex_number
Hi,
I'll have the same problem, too, in some months...
What I was thinking about is to create a cron job that runs say every hour and
calculates each user's database size. Comparing it with a stored per-user value, the
script (running as kind of a mysql superuser) REVOKEs or re-GRANTs UPDATE
Download mysqlcc instead. It works much better and is easier to use.
mysqlgui is deprecated as far as i know.
Curtis
On Thursday 17 July 2003 18:08, Emanuele wrote:
HI!
I have problem to download
http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip
Is there some
#!/usr/bin/perl
use DBI;
my $database = desired database;
my $dbhost = desired database host;
my $username = your username;
my $password = your password;
my $data_source = DBI:mysql:$database:$dbhost;
my $dbh = DBI-connect($data_source, $username, $password);
my $sourcefile = the name and path
unsuscribe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is it at all possible to group by and have it return all variables from
a single row based on a max() criteria of a single variable?
For instance in SPSS I can sort by id number descending then in an
aggregate have it say that newvar2=first(newvar) or last(newvar).??
Just a thought?? any
Hmmm. Do F1 or F3 produce the last command given?
--
Ray Thompson
I remember in WIN NT 4 if we type cmd at the run prompt, then
command prompt use to come up
and we can repeat the commands i.e. doskey feature is available.
--
MySQL General Mailing List
For list archives:
Depending on your version of windows you may have to type doskey at the
command prompt to turn on the doskey feature.
-Original Message-
From: Ray Thompson [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 7:47 AM
To: Neeraj Vasudeva; [EMAIL PROTECTED]
Subject: RE: doskey feature in
I suppose datetime would be the better option here
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Friday, July 18, 2003 10:00 AM
To: [EMAIL PROTECTED]
Subject: Re: mysqlbinlog suggestion
Luc Foisy [EMAIL PROTECTED] wrote:
allowing date range options to
Has anyone gotten this to compile, and if so can you point me in the right direction
of the library?
Thanks
Yves Goergen [EMAIL PROTECTED] wrote:
I'm wondering if I can set safe_show_database on my Windows 2000 MySQL 3.23.56-nt.
Here's what I did:
--- (c:\winnt\my.ini)
[mysqld]
set-variable = safe_show_database=1
---
- NT Service didn't want to (re)start anymore.
You should specify:
[mysqld]
There might be an error in the code.
Some Tech books will have a website dedicated to any corrections of it's contents.
The site location might be mentioned in the intro or you can search the publisher's
web site for it.
Ok so the mysql_send.php loads great. ( Apache 2 is the web
server
Hi everyone,
I have recently installed MySQL 4.0.13 on a freebsd box, and I have
stumbled into the following problem:
I have set the following in /etc/my.cnf:
set-variable= max_connections=100
set-variable= wait_timeout=60
(tried with and w/o 'set-variable ='). Then I
I would export the makefile
and try to include the MySQL library with the other libraries
nmake -f makefile
-Martin
- Original Message -
From: Ron Ohmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 6:15 AM
Subject: MySQL++ Visual Studio.Net
Has anyone gotten
mysqladmin has the capability to specify the my.ini file to read on startup
under my.ini Setup
hth,
Martin
- Original Message -
From: Bogdan TARU [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 6:37 AM
Subject: set/show variables
Hi everyone,
I have recently
Hi Martin,
Hm. Don't really get it. Basically both mysqladmin and 'show variables'
should read these variables from the mysql server, right? Why then would
they give separate results?
Thanks,
bogdan
On Mon, 21 Jul 2003, Martin Gainty wrote:
mysqladmin has the capability to
At 16:02 +0200 7/21/03, Edgar Kraus wrote:
Hello,
is there any detailed documentation out,
which explains the new character set feature in version 4.1,
where a specific character set can be used for tables and/or columns?
Thanks
Eddie Kraus
http://www.mysql.com/doc/en/Charset.html
--
Paul
Bogdan TARU [EMAIL PROTECTED] wrote:
Hi Martin,
Hm. Don't really get it. Basically both mysqladmin and 'show variables'
should read these variables from the mysql server, right? Why then would
they give separate results?
mysql command-line client runs in interactive mode and gets
At 01:12 AM 7/20/2003, you wrote:
my table is small but I can't tell what is faster.. a max or a limit
mysql select max(counter) from web;
mysql select counter from web order by counter desc;
They seem to be the same in performance.
Regards,
Jake Johnson
[EMAIL PROTECTED]
Jake,
I tried
Creigh Shank [EMAIL PROTECTED] wrote:
It appears that an application I've been trying to run (RelataMail/Relata
CRM) deletes the mysql.sock from my system. I'm running Redhat 8.0 with
MySQL 4.0.13. Is there any way to restore the mysql.sock file (eg, from
the rpm) without having to
I had a power failure on the master and it bounced rather ungracefully.
Now I'm getting this error on the slave and it's not replicating. Both
are ver 3.23
mysql slave start;
Query OK, 0 rows affected (0.00 sec)
mysql show slave status \G;
*** 1. row
Try recreate the replication (shut down the servers, copy the master
database into the slave place and so on).
- Original Message -
From: Jeff McKeon [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Monday, July 21, 2003 7:20 PM
Subject: Slave not working
I had a power
Hi, you don't oblige to reinstall MySQL.
One solution is to stop de mysqld (daemon) and restart it, this will
recreate
the socket file.
Hope this help.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: lundi 21 juillet 2003 15:59
To: [EMAIL PROTECTED]
Subject: Re:
I was hoping not to have to do that...
Jeff McKeon
IT Manager
Telaurus Communications LLC
[EMAIL PROTECTED]
(973) 889-8990 ex 209
***The information contained in this communication is confidential. It
is intended only for the sole use of the recipient named above and may
be legally privileged.
Hi,
I am trying select field / 1 as Number from table1 where id = 1;
I don't want any rounding taking place, but MySQL is currently doing it.
How can I ask for a specific number of digits with division?
The field contains 1234.5678, MySQL returns 1234.57, don't want that!
Thanks,
Cory
Hey guys,
Anyone ever notice that when you restart mysql ( whether is be thru
mysql.server or ${MYSQL}/bin/sae_mysqld the tty stays connected.
Thanks,
Chad
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
It appears that an application I've been trying to run (RelataMail/Relata
CRM) deletes the mysql.sock from my system. I'm running Redhat 8.0 with
MySQL 4.0.13. Is there any way to restore the mysql.sock file (eg, from
the rpm) without having to rebuild the whole system?
It writes a status message to the screen, and overwrites your shell prompt.
Hit enter, and you will probably find that you have a prompt afterall.
chad kellerman wrote:
Hey guys,
Anyone ever notice that when you restart mysql ( whether is be thru
mysql.server or ${MYSQL}/bin/sae_mysqld the
Since you are hoping to not repeat the replication setup, your one
chance is that the slave was fully synced at the time of the power
failure. If you check the master, you will see that it is now using a
different log file (whenever mysqld stops/starts a new log is
created). You can shutdown
At 13:43 -0400 7/21/03, chad kellerman wrote:
Hey guys,
Anyone ever notice that when you restart mysql ( whether is be thru
mysql.server or ${MYSQL}/bin/sae_mysqld the tty stays connected.
Thanks,
Chad
This may be a function of your operating system. I notice this when
I connect via ssh
Actually evern if I hit enter it keeps the tty. The only way I can get
it to release is to nohup the ${MYSQL}/bin/sae_mysqld, if not I actually
have to shutdown the term window and reconnect..
Chad
On Mon, 2003-07-21 at 13:57, gerald_clark wrote:
It writes a status message to the screen, and
Hi,
I'd found a bug when I'd tried to use blob fields and innoDb.
To see the bug, do the follow:
*) Create a database.
*) Import the dump file that is attached to this e-mail.
(cfgimpressao.dump)
*) Use the following commands:
select Ci_Descricao from cfgimpressao;
HI List
Need advise on a suitable my.cnf for 3.23.56 on SunOS5.8
MySQL is installed on a virtual machine with plenty of ram and swap space.
However, there is no my.cnf file currently, and mysql seems to lock up
completely from time to time even though system seems fairly stable
(although I saw
Does MySQL have support for calling functions in C/C++ DLLs from trigger
scripts similar to the Extended Stored Procedures functionality provided in
SQL Sever? Thanks.
Charles...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Is it possible to run a query that will just alter text possibly using a regular
expression? I have about 250 rows that I want to strip quotes out of. Does anyone
know of an easy way to do this?
Dean
UPDATE mytable SET mytext = REPLACE(mytext,'','');
Assuming you wised to strip a double quote, modify to suit.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 2:49 PM
To: [EMAIL PROTECTED]
Well it turned out we had table and index corruption on the master db
(db01) so I've fixed it and am rebuilding db02. We're having a mgmt
meeting this wed to discuss updating the production servers to MySQL ver
4.x.
The current servers run RedHat 7.1 with a single Pent-III 933mhz with
256k L2
Worked like a charm! I couldn't find anything about this in MySQL docs
though... Neither before I knew what to search for nor after. What's up
with that?
Dean
- Original Message -
From: Mike Hillyer [EMAIL PROTECTED]
To: Dean Householder [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent:
You have to search for 'string functions' to find it. Problem is that a
search for REPLACE will bring up the REPLACE syntax, not the REPLACE()
syntax (not the brackets ;-) )
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Dean Householder [mailto:[EMAIL PROTECTED]
Worked like a charm! I couldn't find anything about this in
MySQL docs
You have to search for 'string functions' to find it. Problem is that a
search for REPLACE will bring up the REPLACE syntax, not the REPLACE()
Or you can look at the function index
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 04:14, Egor Egorov wrote:
Michael Satterwhite [EMAIL PROTECTED] wrote:
I'm trying to add a foreign key to a table. All tables are INNODB. Table
a has following partial Definition:
TableA
( Fld1 int Primary Key,...
)
Hello guys, I have this question:
I need to replicate 2 databases (each one resides in a different
server) to a single slave server. Reading the documentation I have
running the master/slave replication, but i need to replicate the
other database too, the problem is: I need replicate the other
I've read it now a few times around here and was curious what
innodb means. Is it a table-type for MySQL or a completely
different DBMS?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
This is no problem
To do this,
1 - Duplicate database A, creating second database B, ensuring that both
have separate serve IDs.
2 - Configure both A+B to replicate each other, but enable log-update on
database A. This will allow database A to act as a master to both databases.
3 - Create
No problem, this is:
Kardex Table:
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| Nro | bigint(20) | | PRI | 0 | |
| Fecha
On Mon, 2003-07-21 at 16:38, Michel Albert wrote:
I've read it now a few times around here and was curious what
innodb means. Is it a table-type for MySQL or a completely
different DBMS?
It's a table type, see here:
http://www.mysql.com/doc/en/InnoDB_overview.html
for info
gabe.
Dyego,
thank you for an excellent bug report. You probably tested the 4.0.14 tree?
That was where I was able to repeat the bug.
The bug was that InnoDB first deleted the old record and only after that
tested if the new record is too long (table handler error 139). You have
lots of BLOBs in the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Monday 21 July 2003 18:48, [EMAIL PROTECTED] wrote:
Cod Product date
10Nissan Car 2003-06-20
20Guitar Yamaha 2003-07-01
10Nissan Car 2003-05-01
30Stereo Cables 2003-01-20
20Guitar
What tools are available for importing delimted text files into MySQL tables?
I've got several very large, but simple (just seven columns of integer and
varchar) text files to import into a table.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
At 21:04 -0600 7/21/03, Jim McAtee wrote:
What tools are available for importing delimted text files into MySQL tables?
I've got several very large, but simple (just seven columns of integer and
varchar) text files to import into a table.
Use the LOAD DATA statement or the mysqlimport command-line
You are right above the max date query and I really appreciate your
help, but the subselect query its other question. I try the subselect
query with the 4.0.12-max win32 with the --new option in the command
line to start the server, according to the manual this should enable the
subselect feature,
At 1:04 -0400 7/22/03, [EMAIL PROTECTED] wrote:
You are right above the max date query and I really appreciate your
help, but the subselect query its other question. I try the subselect
query with the 4.0.12-max win32 with the --new option in the command
line to start the server, according to the
66 matches
Mail list logo