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
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
--- [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
NULL and
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 a
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
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
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
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
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
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
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
--
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
---BeginMessage---
If I am not mistaken deleting from the production server would delete
the data on the
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
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
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
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, it makes the
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
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
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
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
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
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:
[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
[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!
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)
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
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',
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
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]
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.
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
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.
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:
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 all \
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
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.
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. 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)
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
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.strokes)
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 moving
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
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 application
43 matches
Mail list logo