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 tabl
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 k
Thank you guys, let me try in this way, i will come back if i get any
problems.
On 4/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote:
>
> Hi Everybody,
>
> I need a suggestion regarding mysqldump. My problem is my application is
> creatiing around 500Mb of data per day. As i want my applicat
Thanks. That worked smooth as silk!
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 11:42 AM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: where group and inner join
In the last episode (Apr 19), Dan Nelson said:
> It's useful to note
In the last episode (Apr 19), Dan Nelson said:
> It's useful to note that SELECT statements generally work in the
> order they are written. The WHERE clause applies to the records as
> they are read from the source tables, and at that point, no grouping
> has been done, so there's no sum. Try mov
In the last episode (Apr 20), Peter Lauri said:
> 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.
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 tour_sco
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 |
+++-+-+
Where fullname and email are varchar(100) a
Never used it, but this might help:
http://dev.mysql.com/doc/refman/5.0/en/checksum-table.html
James Harvard
At 5:00 pm -0700 19/4/06, Robinson, Eric wrote:
>I have master-slave replication working fine. However, I worry about the
>possibility of the master and slave accidentally getting out of
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! Messengers low PC-to-Phone call rates.
I have master-slave replication working fine. However, I worry about the
possibility of the master and slave accidentally getting out of
synchronization. Are there circumstances (other than a direct INSERT to
the slave) that could cause the master and slave to be out of sync? Is
there a way to peri
Hi,
I'm trying to compile on Tru64 using the configure from the reference guide for
using the HP/Compaq compiler (corrected for 'inline')
CC="cc -pthread"
CFLAGS="-O4 -ansi_alias -ansi_args -fast -inline all -arch host"
CXX="cxx -pthread"
CXXFLAGS="-O4 -ansi_alias -ansi_args -fast -inline a
Have you taken a look at this Samuel?
http://www.mysql.com/products/tools/administrator/index.html
Check out the demo in the TRH corner.
May be of some use to you.
Regards
Keith
In theory, theory and practice are the same;
in practice they are not.
On Wed, 19 Apr 2006, Samuel Ziegler wrote:
Those functions do give useful information, but as you point out, the
trick is associating that information with a specific query. For my
use, there will most likely be other SQL activity going on at the same
time which makes doing a 'SHOW ENGINE ...' before and after the query
not very useful.
T
Is this of any use at all?
>From the 5.0.18 manual:
13.5.4.7. SHOW ENGINE Syntax
SHOW ENGINE engine_name {LOGS | STATUS }
SHOW ENGINE displays log or status information about
storage engines. The following statements currently are
supported:
snip
SHOW ENGINE INNODB STATUS
(or SHOW INNODB S
Is there any way to retrieve per SQL query stats from MySQL?
Specifically for my need, the ability to determine the amount of system
resources required to perform the query, ie CPU, disk usage, etc...
I poked through the docs & did some net searching, but couldn't find
anything that I could use.
Yes -- try www.dwebpro.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Well I have wondered about this as well.
I guess you could do this, but if you want the MySQL
databases to be updateable, then as the CD-ROM is read-only,
the databases would have to remain somewhere on the hard
drive. If you put the databases on the CD-ROM this would
make them read-only and n
2006/4/14, Philippe Poelvoorde <[EMAIL PROTECTED]>:
> Hi,
>
> I have one table :
> CREATE TABLE `ressources_summary` (
> `res_type` tinyint(3) unsigned NOT NULL default '0',
> `res_id` int(10) unsigned NOT NULL default '0',
> `comment_count` smallint(5) unsigned NOT NULL default '0',
> `com
Hi,
Gabriel PREDA wrote:
It is:
SHOW FULL COLUMNS FROM a_table
You will get 2 extra columns:
- Privileges (showing the privileges of the user for that column)
- Comment (showing a per column comment)
As well as "Collation" (the columns collation).
When creating a table you can add
It is:
SHOW FULL COLUMNS FROM a_table
You will get 2 extra columns:
- Privileges (showing the privileges of the user for that column)
- Comment (showing a per column comment)
When creating a table you can add a comment using COMMENT keyword:
CREATE TABLE a_table
(
a_column CHAR(30) CHARS
[snip]
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?
[/snip]
Yippee, cross-posting!
http://www.google.com/s
[snip]
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?
[/snip]
You'd have to have CD's for each OS on which yo
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!
--
MySQL General Mailing List
For list archives: htt
Jay Blanchard wrote:
[snip]
could actually tell me a reason why it is better this way?
[/snip]
Here is the answer;
http://www.unicom.com/pw/reply-to-harmful.html
Interesting. I like the general tone of "this is the only right thing,
and we respect the opinion of anyone who differs, even
Hi.
Anyone know how to create a trigger that update the table that invoked it?
--
Hi all.
I am creating a trigger that update the some table witch call it.
Ex:
create table t1 (
id int, name varchar(50), c int default 0, father int,
primary key(id),
index (father),
foreign key (father
MySQL 5.0.20
I've got two instances running with mysqlmanager. I'm not getting any
logging of any sort.
mysqlmanager --help shows:
- -
log /var/lib/mysql/mysqlmanager.log
pid-file
Heya.
I am in the process of modifying a program to access data from a MySQL database
instead of a SQL Server database. I have a view that is referenced as follows
(through use of a data environment command):
Select * from vwMyView where id = ?
If I run this command, I get the data that I
Daniel da Veiga wrote:
On 4/19/06, Ed Pauley II <[EMAIL PROTECTED]> wrote:
out of curiosity, how do you do that?
Daniel da Veiga wrote:
If I am not mistaken deleting from the production server would delete
the data on the slave in a replication environment.
Don't get me wro
On 4/19/06, Ed Pauley II <[EMAIL PROTECTED]> wrote:
> out of curiosity, how do you do that?
>
> Daniel da Veiga wrote:
> >> If I am not mistaken deleting from the production server would delete
> >> the data on the slave in a replication environment.
> >>
Don't get me wrong, try not to top-post, i
out of curiosity, how do you do that?
Daniel da Veiga wrote:
If I am not mistaken deleting from the production server would delete
the data on the slave in a replication environment.
Not if you disable the binlog of the query that will delete data...
--
Daniel da Veiga
Computer Operator
HI,
Take look at your my.cnf and obtain the location of your mysql data
directory. Login into mysql create the database into which you want to
import the tables. What this effectively does is create a directory under
your "mysql data directory". Now copy the .myd, .myi and .frm files to the
di
> If I am not mistaken deleting from the production server would delete
> the data on the slave in a replication environment.
Not if you disable the binlog of the query that will delete data...
--
Daniel da Veiga
Computer Operator - RS - Brazil
-BEGIN GEEK CODE BLOCK-
Version: 3.1
GCM/IT/
--
Ed Pauley II
Internet Software Developer
Bloodstock Research Information Services
859.223.
800.354.9206 ext. 297
[EMAIL PROTECTED]
http://www.brisnet.com
http://www.brisbet.com
--- Begin Message ---
If I am not mistaken deleting from the production server would delete
the data on the sl
Is it possible to setup replication so you would have another server to do
backups on? Replicate the data, do whatever you want to the spare, and then
delete the data from the production server.
On 4/19/06, balaraju mandala <[EMAIL PROTECTED]> wrote:
>
> Hi Everybody,
>
> I need a suggestion reg
Hi Everybody,
I need a suggestion regarding mysqldump. My problem is my application is
creatiing around 500Mb of data per day. As i want my application run
24*7*365. I need a mechanisem where i can move, previous day's data to
another location(i.e) at any given time i just want to store one or two
Hi all.
I am creating a trigger that update the some table witch call it.
Ex:
create table t1 (
id int, name varchar(50), c int default 0, father int,
primary key(id),
index (father),
foreign key (father) references t1(id) on update restrict on delete restrict
);
create trigger tg_t1
before upd
Ed Pauley II wrote:
I recently changed from SuSE ES 8 to RedHat ES 4 running MySQL 4.0.26
(I will be upgrading to at least 4.1 after busy season). I compiled my
own version this time and when I start the server I see only one
mysqld process. I am used to seeing hundreds as my max connect is se
I think this article explains what I am seeing but I don't know how to
determine which threading I am using. I just know it is not user threads
in a separate process.
http://dev.mysql.com/doc/refman/4.1/en/thread-packages.html
Ed Pauley II wrote:
I recently changed from SuSE ES 8 to RedHat ES
Ed Pauley II wrote:
I recently changed from SuSE ES 8 to RedHat ES 4 running MySQL 4.0.26 (I
will be upgrading to at least 4.1 after busy season). I compiled my own
version this time and when I start the server I see only one mysqld
process. I am used to seeing hundreds as my max connect is set
I recently changed from SuSE ES 8 to RedHat ES 4 running MySQL 4.0.26 (I
will be upgrading to at least 4.1 after busy season). I compiled my own
version this time and when I start the server I see only one mysqld
process. I am used to seeing hundreds as my max connect is set to 1000.
This is fo
Hello
I run MySql 4.0.24 [ the release for the Debian stable Linux ].
when I do a "describe a_table", it displays the 6 following columns :
Field - Type - Null - Key - Default - Extra
It would be nice if I could have a 7th column for a "comment"
that could be used to describe the meaning of
--- [EMAIL PROTECTED] wrote:
> I am using phpmyadmin and I want to add a new field and then set the
> defualt value to all the values to "a". How do I do a mass insert and
> not just create a big empty table row?
>
>
> The filed is called AREA it is a varchar of LENGTH 5 it should be NOT
> NUL
I am using phpmyadmin and I want to add a new field and then set the defualt
value to all the values to "a". How do I do a mass insert and not just create a
big empty table row?
The filed is called AREA it is a varchar of LENGTH 5 it should be NOT NULL and
have a default value of "a"
This is
Hi all,
I’m working in a project that use MySQL.
The data is Vietnamese.
So, I have used MS Access 2003 to test displaying this data.
I have configured ODBC Initial Statement Option as “set names utf8”, and use MS
Acccess link to the database.
But, the data can’t display correctly.
I’m us
45 matches
Mail list logo
