No i do not want an autoincrement key , as i want to be only one row in the
table and it value gets incremented / updated and i to know whats its
current value.
--
Regards
Abhishek Jain
On 4/19/06, Michael Kruckenberg [EMAIL PROTECTED] wrote:
Seems like what you need is an auto-increment key.
Hi all,
I am using PHP and what i know is that without select statement in the query
we can not fetch anything . I mean if we do not give select what will be the
field headers.
Pl. clarify how can we fetch rfom this query.
UPDATE `table_name` SET `field`=`field`+1;
Also can we lock and unlock
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
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
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
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 currently
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
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
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
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.
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.
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 -
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 |
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
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
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
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% ORDER BY
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
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
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.
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:
[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:
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 a
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 JOIN
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
[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
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
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
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 |
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
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,
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]
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] Re:
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 the
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
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'
[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
--
[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'
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
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 |
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.
[/snip]
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',
After you give the query, try :
echo mysql_error().P.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;
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
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
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
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 will be in
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]
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
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
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
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
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!
It would all depend
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!
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
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 |
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:
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
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.
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
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 to be on
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
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
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
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
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
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!
It would all depend on
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
68 matches
Mail list logo