can someone please just send me or post a example of editing feilds of a
mysql database within an html form and then updating the values thanks alot
here is a small database u can use i can expand on your example as needed
/*
""RedRed!com IT Department"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jay Blanchard wrote:
>> [snip]
>> I read this as a SQL syntax question, not a math word problem. As in
>>
>> SELECT ..., (some expression equaling sq ft) AS sqft... [/snip]
>>
>> Cool, then do it!
>>
>
>
>
MySQL does seem to have a row number function and the purpose of this is
because it increases the processing time, as you have seen with your
workaround.
I would instead create a temp table with an autoincremented ID, insert the
content of your record set into it and use this autoincremented ID as
I guess the CD could be mounted on MacOS and Unix to be treated as a true
drive but I am confident it would not work on Windows, knowing how every
application has to embed itself with the registry and the system files,
usually register DLLs and what not.
But whatever happens, the CD should never b
Hi,
I am a bit confused by the below, hope I can get some clarification.
In the database (mysql), I have image data stored in a blob. I can perform
operations like: COMPRESS and UNCOMPRESS on it and the data is fine.
Let's say I COMPRESS (ed) the data and then retrieve it use a SELECT
UNCOMPRESS
Hi-
Using MySQL 4.1.11 on Fedora 4.
I moved my data directory to a FAT partition in order to share it with
Windows dual-boot.
Now when I try to start mysqld normally, it fails with these messages in
the log:
060420 18:16:03 mysqld started
060420 18:16:03 [Warning] Can't create test file
/mnt
Jay Paulson wrote:
I have no idea if this is possible or not but is there a way to run Apache,
PHP, and MySQL from a CD? I'd like it to be possible to run it on Windows,
Mac OSX and *nix. If it is possible could someone point me in the right
direction?
Thanks!
XAMPP is a distribution of Apa
Hey! I figured out this one myself:
On Apr 19, Adam Wolff wrote:
> * Question 2:
> Why does introducing an extra WHERE clause make things slower?
> If I do this:
> SELECT * FROM contacts WHERE fullname LIKE "j%" AND user_id=1
> ORDER BY fullname LIMIT 10;
>
It's because the index needs t
First of all thanks all for your answers.
Second I'll explain what I manage to do in regard with this issue,
maybe someone else may need it in the future.
So, first I have started by changing the way I have stored the `ip`
field from varchar(15) to int unsigned and populated this field with
the 4
On Thu, 2006-04-20 at 19:15 -0400, fbsd wrote:
>
>
> can someone please just send me or post a example of editing feilds
> of a
> mysql database within an html form and then updating the values
> thanks alot
These should tell you everything you need to know.
http://www.php.net/manual/en/ref.mys
Yes, that is certainly possible and would be just the same as configuring
replication between different machines.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Thu, 20 Apr 2006, Mohammed Abdul Azeem wrote:
> Hi,
>
> Is it possible to configure a master and slave server on the same
Brian E Boothe wrote:
can someone please just send me or post a example of editing feilds of
a mysql database within an html form and then updating the values
thanks alot
Google for php,mysql,examples.
PB
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7
I have a table with a large number of rows. I have the primary key for a
record within the table. The record I'm looking for looks like this:
+++---+
| id | fullname | email |
+++
As many have pointed out, the arguments on both sides of the mailing
list ReplyTo behavior have serious flaws. There is a good reason for
that. Both arguments are week and use a lot of spin, in a futile
attempt to make their solution appear to be the ideal one. In reality,
both solutions are ba
Thanks for the replies. The database is basically read-only at the moment,
so OPTIMIZE TABLE didn't do anything.
When I force the key to be fullname for the second problem, it runs even
worse. It's not practical to create an additional email,fullname index
because in my app I actually have 3! c
""RedRed!com IT Department"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Jay Blanchard wrote:
>> [snip]
>> I read this as a SQL syntax question, not a math word problem. As in
>>
>> SELECT ..., (some expression equaling sq ft) AS sqft...
>> [/snip]
>>
>> Cool, then do it!
>>
>
This isn't a bug, it's a missing feature. The parent query won't use indexes,
just the subquery.
There's been a lot of complaints about how it renders sub queries less than
useful.
I seem to remember that it might be fixed in 5.1, but I'm not a reliable source
of info on this.
David
Dyego
Andras -
If you create an additional table which contains all possible values
for the order_status field, you can do this. Something like this:
create table orderstatus (
statusname varchar(25) );
insert into orderstatus (statusname) values ('pending'),
('processing'), ('shipped');
Next yo
All excellent information. I have much to ponder.
-Original Message-
From: Eric Braswell [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 11:20 AM
To: Robinson, Eric
Cc: mysql@lists.mysql.com
Subject: Re: How to Verify Replication Status?
You'll need to checksum them at the same
[snip]
can someone please just send me or post a example of editing feilds of a
mysql database within an html form and then updating the values thanks
alot
here is a small database u can use i can expand on your example as
needed
[/snip]
PHP question;
When you click on the form submission but
can someone please just send me or post a example of editing feilds of a
mysql database within an html form and then updating the values thanks alot
here is a small database u can use i can expand on your example as needed
/***
On 4/20/06, Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Apr 20), Jay Blanchard said:
> > [snip]
> > I need to start a prog. as soon as a particular field in the mySQL 4.x
> > is
> > changed. ie. when in Flag table if_flag is set to '1' i need to start a
> > script.
> > The script
Hi Dan,
thank you. That seems to be the Problem solved. Will test it tomorrow in the
Office again. But over VPN the login was more faster then without the
skip-name-resolve value.
Damn, that was so easy, that should i found out by myself ;-)
Kai
Am Donnerstag, 20. April 2006 19:13 schrieb Dan
Hello,
I would like merge this 3 query into a single one...
SELECT COUNT(*) AS count FROM orders WHERE order_status = 'pending',
SELECT COUNT(*) AS count FROM orders WHERE order_status = 'processing',
SELECT COUNT(*) AS count FROM orders WHERE order_status = 'shipped',
I could do :
SELECT orde
You'll need to checksum them at the same point in time, naturally --
which you can do by stopping replication on the slave, then performing
the command on the master, then slave, and compare.
In other words, if you are doing this on a live system, you have to make
sure there are no writes in bet
After you give the query, try :
echo mysql_error()."".mysql_info();
This way, you should be able to see exactly what error is coming back
from PHP/MySQL
-Original Message-
From: Tom Lobato [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 1:55 PM
To: Jay Blanchard; mysql@lists
From: "Jay Blanchard" <[EMAIL PROTECTED]>
More of a PHP question. Echo the UPDATE statement to the browser so that
you can see what it looks like.
It is what I did. As I explain in the mail, I executed the command extracted
from the browser.
The command is:
UPDATE clientes SET tipo='r', nome
In the last episode (Apr 20), Jay Blanchard said:
> [snip]
> I need to start a prog. as soon as a particular field in the mySQL 4.x
> is
> changed. ie. when in Flag table if_flag is set to '1' i need to start a
> script.
> The script will be in PHP.
> Pl. tell me how to do so on mySQL 4.x.
> [/sni
I have a good question, the MySQL Optimizer is broker ? see the querys:
mysql> explain select * from an where an_id in (100,200);
++-+---+---+---+---+-+--+--+-+
| id | select_type | table | type | possible_keys | key | key_le
SELECT DISTINCT 'Service type' FROM 'service_providers'
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 20 April 2006 12:45
To: mysql@lists.mysql.com
Subject: getting unique results
SELECT `Service type` FROM `service_providers`
How do I get only unique resu
[snip]
UPDATE command is not working for only the record that I want, but
for
all in the table. I sees WHERE is not interpretated by Mysql server. At
least the result is identic to it. For example, If my php execute
UPDATE clientes SET tipo='r', nome_fantasia='cc',
estado='24'
WHER
[snip]
I need to start a prog. as soon as a particular field in the mySQL 4.x
is
changed. ie. when in Flag table if_flag is set to '1' i need to start a
script.
The script will be in PHP.
Pl. tell me how to do so on mySQL 4.x.
[/snip]
Triggers are not available in 4.x, you will need 5.x
--
MySQL
Hi!
UPDATE command is not working for only the record that I want, but for
all in the table. I sees WHERE is not interpretated by Mysql server. At
least the result is identic to it. For example, If my php execute
UPDATE clientes SET tipo='r', nome_fantasia='cc', estado='24'
WH
Dear Friends,
I need to start a prog. as soon as a particular field in the mySQL 4.x is
changed. ie. when in Flag table if_flag is set to '1' i need to start a
script.
The script will be in PHP.
Pl. tell me how to do so on mySQL 4.x.
I shall be very grateful.
--
Regards,
Abhishek Jain
Check where u resolve . that could help you
I guess this DNS problem ,correct me if iam wrong .
--Praj
On Thu, 20 Apr 2006 18:43:39 +0200
Kai Schmidt <[EMAIL PROTECTED]> wrote:
> Hi @all
>
> i have a Problem with Login into a MySQL 5 Server. When i try to login from a
> remote Machine into
Thankyou Gabriel.
So how does one set a column comment then?
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Thu, 20 Apr 2006, Gabriel PREDA wrote:
> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> From: Gabriel PREDA <[EMAIL PROTECTED]>
> Subject: [SPAM]
Kai, could this be a DNS issue? MySQL will normally try to look up
which host you are coming from, if it is not localhost. If you have
an incorrect DNS entry on the server, or a malfunctioning DNS server,
this could be the problem.
You can try adding
skip-name-resolve
under the [mysqld] se
Eric, that is very helpful. Thanks.
Assuming the master and slave are in sync, is there a reason the
checksums would not match? I would rather not dump the database and run
an external checksum unless I have to.
--
Eric Robinson
Director of Information Technology
Physician Select Management, LL
James, thanks for the link. It looks promising. Since you have never
used it, you probably won't know the answer to this question, but should
I expect the checksums on the master and slave databases to be the same
if they are in sync?
-Original Message-
From: James Harvard [mailto:[EMAIL
hello,
I run MySQL 4.1.11 [ available for Linux Debian stable ].
and now, ok, the following command display 9 columns :
mysql> SHOW FULL COLUMNS FROM a_table;
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment
BUT now I would just display 2 columns :
Field | Comme
Hi @all
i have a Problem with Login into a MySQL 5 Server. When i try to login from a
remote Machine into the Server, it needs up to 30 seconds. When i login from
the same machine all is at it should be.
After login the Server is responding normal to querys.
My Environment:
SuSE 10.0
MySQL 5.0
Jay Blanchard wrote:
[snip]
I read this as a SQL syntax question, not a math word problem. As in
SELECT ..., (some expression equaling sq ft) AS sqft...
[/snip]
Cool, then do it!
It would all depend on how he has his feet and inches saved in the
table, and of course, the field names. If w
[snip]
I read this as a SQL syntax question, not a math word problem. As in
SELECT ..., (some expression equaling sq ft) AS sqft...
[/snip]
Cool, then do it!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I read this as a SQL syntax question, not a math word problem. As in
SELECT ..., (some expression equaling sq ft) AS sqft...
-Original Message-
From: David T. Ashley [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 11:15 AM
To: Jay Blanchard; Shaun; mysql@lists.mysql.com
Subject
Peter,
Best groupmember,
I am doing this query that works fine.
SELECT
tps.tour_player_id,
sum(if(tsh.hole_number<=9, tps.strokes, '0')) AS 'front_9',
sum(if(tsh.hole_number>=10, tps.strokes, '0')) AS 'back_9',
sum(tps.strokes) AS 'score'
FROM tour_player_score tps
INNER JOI
There is a technique called "unit cancellation" that may serve you well.
The technique is essentially to treat each unit as an orthogonal vector
(orthogonal to all other units), so one unit can't be mixed with any other
unit.
The only way to convert is to multiply by various forms of "1". "1" is
[snip]
I have measurements of rooms stored in a table for each house in feet
and
inches, does anyone know how can I work out the square footage?
[/snip]
Convert to inches, multiply length * width, divide by 144 (one square
foot)
--
MySQL General Mailing List
For list archives: http://lists.mysql
Hi,
I have measurements of rooms stored in a table for each house in feet and
inches, does anyone know how can I work out the square footage?
Thanks for your advice
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Hi friends, I need your help.
I want to configure the Query Cache, but it dosn't work.
I have installed MySQL 5.0.19 in Mandrake Linux. The server has 2GB
memory ram, 150 gb hard disk, exclusive for dbms.
I configure my system how say the home page. I follow step by step the
instructions. (http:
Hi all!
(Sorry for the late reply.)
Puiu Hrenciuc wrote (re-ordered):
"Barry" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Puiu Hrenciuc wrote:
Hi,
I have a table ( MyISAM, MySQL 5.0.20, FreeBSD ) containing network
traffic data :
record_time datetime - time when recording
Hey list,
I'm am currently looking for myODBC 3.21.X but can't seem to find a suited
downloadsite.
Does anyone know a link to this version?
Thanks in advance,
Reinhart Viane
On 4/20/06, Adam Wolff <[EMAIL PROTECTED]> wrote:
> How can I optimize the case where I filter on one key but sort on another?
> This is fast:
>SELECT * FROM contacts WHERE fullname LIKE "j%" ORDER BY fullname LIMIT 10;
>
> But this is slow:
>SELECT * FROM contacts WHERE fullname LIKE "j%"
At 19:14 +0100 14/4/06, Philippe Poelvoorde wrote:
Have a serious look at :
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-3-23.html
http://dev.mysql.com/doc/refman/4.1/en/upgrading-from-4-0.html
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
There is many things likely to
COLUMN COMMENTs are not the same as TABLE COMMENT...
For TABLE COMMENT you should use:
SHOW TABLE STATUS LIKE 'table_name'
*Gilles *(the starter of the thread) wanted COLUMN COMMENTs.
--
Gabriel PREDA
Senior Web Developer
Using MySQL 5.0.18
mysql> use test1;
Database changed
mysql> show tables;
+-+
| Tables_in_test1 |
+-+
| t1 |
+-+
1 row in set (0.00 sec)
mysql> show create table t1 \G
* 1. row *
Table: t1
Create
Hi,
2006/4/20, Adam Wolff <[EMAIL PROTECTED]>:
> Hi. I'm new to database optimization and I have a couple of questions.
>
> I have a table like this:
>
> +++-+-+
> | id | fullname | email | user_id |
> +++-
>
>SELECT `Service type` FROM `service_providers`
>
>
>How do I get only unique results from this query. There are many services
called 'cafe' for example but I only want one.
Well, this could help:
select distinct `service type` FROM `service_providers`
Martijn Tonies
Database Workbench - de
SELECT `Service type` FROM `service_providers`
How do I get only unique results from this query. There are many services
called 'cafe' for example but I only want one.
R.
Hi,
Is it possible to configure a master and slave server on the same
machine ? I have 3 instances of mysql running on the same server. I need
to replicate a database from one server to other 2 servers.
Any links or suggestions required regarding the same.
Thanks in advance,
Abdul.
How about Alfresco as a C/DMS? (http://www.alfresco.com/) Our CEO read an
article about Boise Cascade using this model and thought it would scale well
for us.
There is also this
http://www.mysql.com/news-and-events/web-seminars/mysql-alfresco.php
Which I didn't know about (or necessarily care
Sorry forgot to mention MySQL version 4.1.X
> This option is operational as of MySQL 4.1. (It is allowed but ignored in
> earlier versions.)
--
Gabriel PREDA
Senior Web Developer
hello,
thank you for your answer, but
this DO NOT work for me. I use MySQL 4.0.24 [ Linux Debian sarge stable ].
the "FULL" argument displays ONLY the Privileges, NOT the Comment, neither
Collation.
mysql> CREATE TABLE a_table (a_column CHAR(30) COMMENT 'commentaire');
Query OK, 0 rows affec
Jay Paulson wrote:
> I have no idea if this is possible or not but is there a way to run
> Apache,
> PHP, and MySQL from a CD? I'd like it to be possible to run it on
> Windows,
> Mac OSX and *nix. If it is possible could someone point me in the right
> direction?
>
> Thanks!
Hi Jay,
I am cur
There are only a very limited set of circumstances where slaves could
get out of sync, and if everything is set up right, it basically should
not happen.
See: http://dev.mysql.com/doc/refman/5.0/en/replication-rules.html
And: http://dev.mysql.com/doc/refman/5.0/en/replication-features.html
CHEC
tuxlinsecure wrote:
Hi,
What binaries & directory premissions are required to enable in sudo to start
mysql Instance through sudo.
Thanks,
Hi All,
what user do you want to be able to start MySQL? Just add that
user to your wheel group(be careful though, as that gives that user full
power u
tuxlinsecure wrote:
Hi,
What binaries & directory premissions are required to enable in sudo to start mysql Instance through sudo.
Thanks,
-
How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.
You should ask on a sudo / Unix
66 matches
Mail list logo
