I know I can do this in code, but was wondering if I am overlooking
something in the docs about it.
Table images
---
Id url
Currently, I show a simple list on a page where one can click on the image
and it pops open a new window and loads url as a img src.
I have been as
mysql> use zzz
Database changed
mysql> create table category
-> (
-> id tinyint(4) NOT NULL auto_increment,
-> name varchar(20) NOT NULL,
-> parent tinyint(4) NULL,
-> primary key(id)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql> insert into category
It seems to work on my MySQL (4.0.18).
Tell us which version are you using and the error code/message returned.
-- excerpt --
mysql> create table category
-> (
-> id tinyint(4) NOT NULL auto_increment,
-> name varchar(20) NOT NULL
You can do a two-way replication. According to MySQL docs, however, this
isn't recommended since atomicity of update operations (depending on the
scenario, of course, this isn't a problem).
I'm not sure, but I think that making the master a slave of the slave that
would become a master temporarily
Hi,
Could you take the database down long enough (scheduled downtime) to
make the master a slave to the slave? I seem to remember reading on
this mail list that you can do circular replication... or am I talking
nonsense?
That way when you took the "original" master down for maintenance, the
> Can somebody give me pointers how to store and
> retrieve data in Hindi using MySQL C API and MySQL in
> general. Since alll the hindi text will be in unicode
> format and C API uses char* parameter how do I
> interface between my Hindi text data and C API. DO I
> convert them to some other forma
Hi,
How could I do this insert/select?
create table category
(
id tinyint(4) NOT NULL auto_increment,
name varchar(20) NOT NULL,
parent tinyint(4) NULL,
primary key(id)
);
insert into category (name, parent) values('cc_1',null);
insert into category (name, parent) select 'cc_2a',
Hello,
I have a project where I need to develop a database
product with working handling languages like hindi
etc.
The application will be written in Win32 API so I will
be using MySQL C API().
Can somebody give me pointers how to store and
retrieve data in Hindi using MySQL C API and MySQL in
g
Depending on the size of your databases, it might be a good idea to copy
back your 'data' directory from slave to master.
I think this should work better, even because the master wouldn't get the
INSERT/UPDATEs made on the slave.
[]s,
Conrado
- Original Message -
From: "Batara Kesuma" <
This is for those who love a challenge.
I am trying to come up with a query that would calculate the Standard
Deviation and Variance for 15 fields. Although in theory this is easily done
in Access, MySQL does not have the same mathematical calculations that
Access/SQL does.
Here is the query as i
create table account (
id int(11),
state varchar(2)
);
create table transaction (
id int(11),
user_id int(11),
amount int(6),
added timestamp
);
select sum(transaction.amount)
from transaction, account
where transaction.id = account.id AND
account.state = 'TX' A
You should not have any problem. The only caveat is ensure you have the same
version and directory structure.
Good Luck!
Pat...
Patrick Sherrill
Southwest Florida's First ISP
CocoNet Corporation
- Original Message -
From: "Ansari, Raza (GEI, GEFA)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTEC
Victor,
Will this not work for Innodb tables? If my backup also includes system
tablespaces and .ibd files ( we using multiple tablepsace), will that be a problem?
Thanks
Raza
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, March 15, 2004 9:03 AM
To
Account table has a field state and a field id.
Transaction table has fields id, user_id, amount, added
Id is the PK in the account table, related to the user_id in the transaction
table.
I need to get a sum of the amount column for all users in state of TX in the
year of 2003.
Tried a few ways,
Hi,
does MySQL support composite keys?
I have a table 'Group_Map'
This has 3 fields
contact_id (primary key in another table)
group_id (candidate key in another table)
user_id (primary key in another table)
is it possible / advisable to create and maintain a composite key for this
table?
Brent,
>The problem I run into with my current query is that it fails when
>there are no contacts or regardings for an event. Is this possible in a
>single query? Here is a short version of my current query.
>SELECT DISTINCT EventID, Contact.Name, Regarding.Name
>FROM Events, Contacts, Regarding
>
You're right, it doesn't "fail", it just fails to give me the desired
results.
Left joining won't work because it will only grab one record from
contacts and/or regarding if one exists, when there could be many.
Thanks for the suggestion though.
Thanks
On Mar 15, 2004, at 4:47 PM, Rhino wrote
You have to run the 'mysqld_safe &' command before you run 'mysql'. That
creates the socket for you.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have installed MySQL provided with SuSE Linux 9.0. My intention was to
figure out how it could be used with PHP that is running on Apache. I managed
to install all required RPM packages, but when I try to laynch MySQL (just
typing "MySQL"], the following error message is displayed:
ERROR 200
Remarks interspersed below.
Rhino
- Original Message -
From: "Brent Baisley" <[EMAIL PROTECTED]>
To: "MYSQL list" <[EMAIL PROTECTED]>
Sent: Monday, March 15, 2004 4:32 PM
Subject: Help with a tough query
> I didn't think this was too hard when I first created it, but now that
> I'm loa
It's dead easy; see the example below. By the way, the term you want is
'join', not 'merge'.
In the example, Sample is the name of the database. 'emp' and 'dept' are two
tables that can be joined on a common value; the common value is called
'workdept' in the 'emp' table and 'deptno' in the 'dept'
Don't know if this will help, but this is how I offer web clients to "save
as excel" in cold fusion:
the key is to change the content like above. I am not sure how to do this
in PHP. But I am sure if you look around you will find it.
Then just output the table, with each field broke
I didn't think this was too hard when I first created it, but now that
I'm loading test data it's not working as expected.
The core of the query is three tables: Event, Contact, and Regarding.
There can be zero or more Contacts for each event and zero or more
"Regardings" for each event. There
Dan Vande More wrote:
/* repost: considering I have no answers, is it safe to conclude it's not feasible?*/
I'd like to be able to audit connections to mysql databases. Here is
what I'd like to see:
Who connected to the server.
What IP did they come from.
When they disconnected.
Any permission den
I have a php website connecting to mysql database.
How can i have a user export his database through the webpage to csv format?
I would like the user to have a button he can press that would pop up a
"save as" screen so he can save his database.
I need to also be able that he can only save HIS OWN
Hi,
Is it possible to create a temporary table in mySQL using columns from tables in
two databases? Basically I want to split a table between two databases and if some
logic is satisfied I want to "merge"(the right word?) the
two tables into one in one of these databases. What's the best wa
The problem isn't that it can't connect to the master. The IO is running
fine. It is just the SQL slave thread that won't restart. I have looked
in the server log and that just has a duplication of the message I get
when I try to CHANGE MASTER TO RELAY_LOG_FILE=...
Error initializing relay log
Did you look in the error log for the slave to find out the reason it can
not contact the master?
>> Original Message <<
On 3/15/04, 1:39:44 PM, Daniel Gibby <[EMAIL PROTECTED]> wrote
regarding hard boot killed replication execution:
> My master server was hard
Hi,
Yes, but what about two "masters" doing circular replication with each other and one
slave reading from one of the masters. Since all updates/inserts happen on both
masters, they also happen on the slave, so in effect you have two masters. I just
wish you could do that with three "masters"
> Is there a way (utility, command, etc...) to find out what config settings
> a mysql server was started with?
> For example, someone started a server and I'd like to check to make sure
> the correct .cnf file was used?
> Thanks.
>
> David
e.g.
SHOW VARIABLES LIKE 'key_buffer_size%';
etc.
--
One way is to execute the SHOW VARIABLES command in the mysql client.
Then you can see what all the values are set to and figure it out.
You could also read the documentation and determine the order that
locations are searched for to find my.cnf and figure it out.
Daniel Gibby
David B Hamby wrot
Is there a way (utility, command, etc...) to find out what config settings
a mysql server was started with?
For example, someone started a server and I'd like to check to make sure
the correct .cnf file was used?
Thanks.
David
--
MySQL General Mailing List
For list archives: http://lists.m
My master server was hard booted and now my slave can't execute the
replicated binary sql logs.
mysql> show slave status\G
*** 1. row ***
Master_Host: post.somehost.com
Master_User: replicator
Master_Port: 3306
Conn
While downloading this a I got a number of virus warnings from McAfee. I aborted the
download.
Anyone else experienced this?
I emailed MySQL but didn't hear back.
-:>Kevin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
>Description:
After pulling the 4.1 version from
bk-internal.mysql.com:/home/bk/mysql-4.1,
I compiled with BUILD/compile-pentium-debug and startet tests with
make test. This failed with the gis test.
I try to follow the instructions given at the end of the te
Successfully disregarded !
-Ursprüngliche Nachricht-
Von: Kevin Carpenter [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 15. März 2004 19:33
An: [EMAIL PROTECTED]
Betreff: Test Email - Please Disregard
Test Email - Please Disregard
-:>Kevin Carpenter
CHOP - Biomedical Engineering
Test Email - Please Disregard
-:>Kevin Carpenter
CHOP - Biomedical Engineering
(215) 590-5762
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Monday 15 March 2004 01:02, Chuck Gadd wrote:
> Smartyone wrote:
> > The database used to work, but then something must have broke, because
> > now it is suddenly Read-Only (reports Read Only when I try to add a
> > record using MySQLCC).
>
> Make sure the owner and group of the database files i
Hi,
I use replication with 1 master and 1 slave. Right now the slave is only
used to make a backup. Next week I am going to change my master
motherboard. So I need to take it offline for a while (about 90 minutes).
I am thinking about switching the master for that 90 minutes, so the slave
will bec
We wrote a wrapper with LD_PRELOAD. When mysqld does
pthread_attr_setstacksize() we translate it into an anonymous mmap()
and use pthread_attr_setstackaddr() instead. It's the equivalent
of FLOATING_STACKS. ;)
Our mysqld (which is running as slave) will seg fault if we set
the thread_stack to 25
Hola,
I made 4 changes and it worked. changed 3306 and mysql.sock for both client
and server, now it works fine. Those two options killed so much of my time.
I followed the instructions line by line and there was never any mention of
changing the default my.cnf file.
Gracias,
Chris
-Origina
/* repost: considering I have no answers, is it safe to conclude it's not feasible?*/
I'd like to be able to audit connections to mysql databases. Here is
what I'd like to see:
Who connected to the server.
What IP did they come from.
When they disconnected.
Any permission denied errors they may
On 15 Mar 2004, at 15:35, Victoria Reznichenko wrote:
Probably you specified wrong password in the option file on
'bc-1-1-02' box.
Check the output of mysql --print-defaults.
Nice idea, but no - I typed the password in manually both times, and I
have repeated the experiment several times (and so
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error you must delete
it and notify the sy
Tim Cutts <[EMAIL PROTECTED]> wrote:
>
> Server version: MySQL 4.0.18, running on Red Hat Linux 8.0
>
> Symptoms: All our machines except for one can connect to the database.
> That one machine gets 'access denied'.
>
> All users are affected, even root.
>
> SHOW GRANTS for an example user:
Scott Haneda <[EMAIL PROTECTED]> wrote:
> There are some things I do in mysql often, is there some way to alias or
> otherwise bookmark a a sql statement for simple rapid use in the future?
You can put SQL statements to the file and then execute them from the file.
--
For technical support con
Hi listers,
Using MySQL 4.0.15-max-debug on Windows 2000, I am working with perlscripts.
When one of my program runs, I have an unexpected long time for one query which take
at least 10 min (in the best case, but it stayed blocked most of the time) instead of
10 sec when the query is on the
Tim Cutts <[EMAIL PROTECTED]> wrote:
>
> On 15 Mar 2004, at 12:34, Victoria Reznichenko wrote:
>
>> [EMAIL PROTECTED] wrote:
>>> Hello colleagues:
>>> I would like to know if it's possible to start the log file production
>>> at run time, i.e. without
>>> stopping and restarting the database ...
On 15 Mar 2004, at 12:34, Victoria Reznichenko wrote:
[EMAIL PROTECTED] wrote:
Hello colleagues:
I would like to know if it's possible to start the log file production
at run time, i.e. without
stopping and restarting the database ...
No, you should restart MySQL server.
Which is really irritating
On Mon, 15 Mar 2004, Boyd E. Hemphill wrote:
> Using a tool to generate a data model I go the following statement:
>
> Create table StateN (
> StateId Int NOT NULL AUTO_INCREMENT,
> StateNm Char(50) NOT NULL DEFAULT '',
> StateCd Char(7) NOT NULL DEFAULT '',
> SortInt Int N
You did not state the tool you are using so I am not sure if the syntax
is meant to be a constraint or an index. Since an Index was stated once
for each column I am assuming the first UNIQUE is a constraint while the
actual index is preceded by the INDEX keyword.
>> Original Mes
Using a tool to generate a data model I go the following statement:
Create table StateN (
StateId Int NOT NULL AUTO_INCREMENT,
StateNm Char(50) NOT NULL DEFAULT '',
StateCd Char(7) NOT NULL DEFAULT '',
SortInt Int NOT NULL DEFAULT 0,
UNIQUE (StateId),
If the table types are all MyISAM and you took a consistent backup the
answer is most likely yes.
>> Original Message <<
On 3/15/04, 7:50:39 AM, mt m <[EMAIL PROTECTED]> wrote regarding restoring
a database from tape:
> Hi,
> Recently we EOLed a machine that h
Hi,
Recently we EOLed a machine that had a mysql instance. The /usr/local/mysql
dir was backed up to tape before EOLing.
Having now installed a new machine, we need to copy the old database from
tape to the new machine.
Mysql has been successfully installed on the new machine.
To install the d
Given a table named MyTab that contains a column named TelephoneNumber that
has 8 instances of 123-4567 in it and 3 instances of 444- in it:
select distinct(TelephoneNumber) from MyTab
will give you each of the phone numbers, once each, i.e. the result will be:
123-4567
444-
This query:
"Jan Blomqvist" <[EMAIL PROTECTED]> wrote:
> Hi! Is there a select statement , wich works like the command uniq in unix,
> if I shall list a table with a column wich for example is telephonenumber
> and the same number occurs like 1000 times, and I wan,t i present just once
> and also the count how
I think, the two formats you raised are both that of
foreign key constraint:
when there is a composite foreign key (more than 1
attribute in a table involved), you must use "foreign
key" clause.
if there is only a simple foreign key, you can use
either format.
--- Egor Egorov <[EMAIL PROTECTED]
you can do something like:
select phone_number, count(1)
from your_table_name_here
group by phone_number
> -Original Message-
> From: Jan Blomqvist [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 15, 2004 8:27 AM
> To: [EMAIL PROTECTED]
> Subject: any select statement like uniq in unix
>
Hi! Is there a select statement , wich works like the command uniq in unix,
if I shall list a table with a column wich for example is telephonenumber
and the same number occurs like 1000 times, and I wan,t i present just once
and also the count how many times it occurs in the table.
/Jan Blomqvis
Hey,
Thanks for replying.
I login with username "root" and a password I set in the ensim control
panel, it works perfectly.
I dont really know if I am "in the mysql database"...but there are a couple
of tables or dbs there...
>What id are you using to create the table?
I guess root, coz thats wha
Hi MySQLians,
After such a long span (nearly 1 month) of searching the solution
for the server restart while executing C API prepared statments
I found that the execution met the error in the server ;
040315 17:48:55 Aborted connection 2 to db: 'test' user: ''
host: `localhost' (Got an er
[EMAIL PROTECTED] wrote:
> Hello colleagues:
> I would like to know if it's possible to start the log file production
> at run time, i.e. without
> stopping and restarting the database ...
No, you should restart MySQL server.
> I would like to know also of it's possible to change at run time the
Alex Curvers <[EMAIL PROTECTED]> wrote:
>
> Whats the preferred syntax to insert values in multiple (related) tables
> I insert one record, then i need the ID of the inserted value to add it
> the with the other inserts
>
> with MSSQL stored procs its
>
> INSERT INTO ...
Server version: MySQL 4.0.18, running on Red Hat Linux 8.0
Symptoms: All our machines except for one can connect to the database.
That one machine gets 'access denied'.
All users are affected, even root.
SHOW GRANTS for an example user:
Grants for [EMAIL PROTECTED]: GRANT ALL PRIVILEGES ON *
Hi All
Whats the preferred syntax to insert values in multiple (related) tables
I insert one record, then i need the ID of the inserted value to add it
the with the other inserts
with MSSQL stored procs its
INSERT INTO .
SELECT @MyID = @@IDENTITY
after that y
Hello colleagues:
I would like to know if it's possible to start the log file production
at run time, i.e. without
stopping and restarting the database ...
I would like to know also of it's possible to change at run time the
directory where the log files
are stored after their generation.
I'm wo
[EMAIL PROTECTED] wrote:
> Hello!
> Is there a possibility to install MySQL 3.X and MySQL 4.X parellel on one
> FreeBSD-Machine?
Sure.
> I would like to work with the new version, but a lot of utilities
> published as free php-software don't run with MySQL withoutn massive
> changings.
Some opti
(B
(B
(B
(B
(B
(B
$B2&(B $B;E(B <[EMAIL PROTECTED]> wrote on 15/03/2004 10:30:12:
(B
(B> Dear sir:
(B>I've used MySql for several years. It IS the best database I've used,
(B> small and efficient.
(B>However, I now meet a problem. Can u tell me whether MySql run over
(B> wi
Hi,
Have a look here :
http://www.mysql.com/doc/en/Windows_installation.html
Bye
David
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I'm not sure if I understand your question, but if your asking:
"Does MySQL run on Windows", then: Yes, it does.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
> Dear sir:
>I'v
hi Íõ ÊË,
Yes you can have MySQL for Windows OS ...
visit: http://www.mysql.com/downloads/mysql-4.0.html
---> Windows downloads - OK
--- Íõ ÊË <[EMAIL PROTECTED]> wrote: > Dear sir:
>I've used MySql for several years. It IS the best database I've used,
> small and efficient.
>How
Dear sir:
I've used MySql for several years. It IS the best database I've used,
small and efficient.
However, I now meet a problem. Can u tell me whether MySql run over
windows os? ---Just tell me no. ok?
Thx!
Urs,
thyme
_
享用世
Hello!
Is there a possibility to install MySQL 3.X and MySQL 4.X parellel on one
FreeBSD-Machine?
I would like to work with the new version, but a lot of utilities
published as free php-software don't run with MySQL withoutn massive
changings.
With best regards
Mark Schanovsky
--
MySQL General
MySQL puts an automatic limit of 1000 on all select queries. Try adding
"LIMIT 10", and perhaps then it will take a good long time like
you want.
Tom.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
"Keith" <[EMAIL PROTECTED]> wrote:
> i'm trying to find the max value of a certain field and return a field linked with
> the max value. The tables:
>
> planets--
> population
> government
> sysID
>
> systems--
> sysID
>
>
> For examples sake lets say we are searching through three sysID's. For ea
rb <[EMAIL PROTECTED]> wrote:
> I am a new user trying to learn mysql (using InnoDB tables, mysql
> version 3.23.54) and to create a useful database for a project I am
> working on. In trying to understand how to use foreign keys effectively,
> I studied examples at http://sqlzoo.net - "A Gentle In
Hi,
First, please do not prioritize any emails to a mailinglist. It might be
"high priority" to you, it isn't for the mailinglist readers who are
supposed to respond. It's not good mailinglist-etiquette.
> I am evaluating mysql. Can you please tell the following info related to
Oracle MysqlConver
Hi All,
I am evaluating mysql. Can you please tell the following info related to Oracle
MysqlConversion..
* Decision making steps to decide if an oracle database can be moved to MySql or not
* List of things to be cautious about before developing new applications on MySql
database
T
Hi. I have a query that has been running for 10.7 hours. It is converting a 3.6GB
MyISAM to Innodb.
38448 | copy to tmp table | alter table `MESSAGES` type=innodb
The innodb data file has increased 8.6GB in size since the command started.
How do I tell how far through the conversion the proce
79 matches
Mail list logo
