Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in Mysql
thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hallo list!
I have an autoincrement field (+others of coarse) in myISAM table. When I
try to insert values with queries everything works fine, but when I try to
do it with Borland C++ builder 6's TSQLClientDataSet (dbExpress) it throws
an exception that the field's value must be set. It continues
Kees Hoekzema wrote:
Hello,
On Tuesday 04 February 2003 14:46, Grover Cussi N. wrote:
restore to the original size ?, I see that the tendence of the innodb
tables is to grow, and grow, and never will reduce the size, it is
posible to control this?
I had the same problem, it went on
Hi folks,
I have a problem that normally I'd want to use subselects on. Here
it goes:
Table t1 has a column data_id. Table t2 has a column data_id. Both
are foreign keys for the autoincrement primary column id of the
table called data.
I wish to delete every row from data which is NOT
i have a datbase of about 1.5 million log entries that i want to search based on
subject (not indexed because it's seldom used). when i try, i get a fatal warning
that i cant seem to kick. i have rtfm, and changed max_join_size=200 in my.cnf to
hopefully make it run without the fatal
I think you are coming from the wrong angle. If you want the opposite,
you should reverse your approach. Select all the names in the projects
table, match them with names in the contacts, then filter it so you only
have the ones without a match.
SELECT p.name,p.company FROM projects p
LEFT
Hi
My DBA has created a DTS package that works between two MS SQL machines,
successfully adding characters at either side of the source data on the
publication. However, we have a problem when trying to replicate to MySQL.
If we check the transform data box when creating the SQL Server
Can anyone point me in the right direction for finding a method of only
creating a query that selects records from a dB where today's date is
less than the column 'expire', which is in DATE format. The purpose of
this is to automatically stop display special offers.
Thanks
Stephen
Hello everybody,
Is it possible to set up this kind of replication and what parameters I have
to set in the my.cnf file ?
Table A own by server A and replicated to server B and C
Table B own by server B and replicated to server A
Table C own by server C and replicated to server A
The mysql
I appreciate everyone's suggestions. I wasn't aware of the MERGE
table variation (wasn't in my large mysql book) nor of some of
the file IO optimizing aspects of INNODB.
Re INNODB's ability to return just the fields needed ... ???
I looked via GOOGLE and also dug around in the doc at the
How much work do you want done for you? Perl and Python are great apps for
writing MySQL reports, and you can output all the report to a text file,
which would be great for a reader. But as report applications, can't help
you there.
Sorry.
j- k-
On Tuesday 04 February 2003 09:10,
On 5 Feb 2003, at 14:19, boclair wrote:
I notice some of my colleagues using SET in INSERT statements.
DuBois makes a short reference on p565, DoorStop1.
The Manual has some mention in http://www.mysql.com/doc/en/SET.html
You seem to be confusing two unrelated meanings of SET. The SET
This doesn't directly address the problem you are having, but it
probably is a better way of doing it. Have you looked into using the
REPLACE function instead of a delete and insert. It should be faster and
more reliable.
I assume since you are using the ignore statement in your insert that
I've looked through the mysql manual for information on regualar
expressions, and all that it seems to have are references such as:
SELECT fo\nfo REGEXP ^fo$;
How can the REGEXP be applied to a 'SELECT field FROM table' kind of
statement?
Thanks,
Darren Young
mysql,query
SELECT id,account FROM tablename WHERE detail LIKE '%pattern%' GROUP BY
Account;
-Original Message-
From: Jaime Teng [mailto:[EMAIL PROTECTED]]
I have a MySQL table:
...
It should only return *one* result per account.
On Wed, Feb 05, 2003 at 03:58:21PM +1300, Defryn, Guy wrote:
I was just reading through the Mysql manual section 3.32
And came across a sentence that started like this
Animal sex can be represented in a variety of ways
My mother tongue is not English but doesn't it sound rude ? :-)
At 17:26 + 2/4/03, Ben Clewett wrote:
MySQL,
My first post, please go easy if this is the wrong pleace!
I'm trying to find an IMAP server which used MySQL so that my
Mozilla Email client can file it's email a little faster.
Has anybody heard of such a device?
I believe the Horde IMP
Hi,
I'm trying to optimize the following query:
SELECT *
FROM user LEFT JOIN history ON user.userid = history.touserid OR
user.userid = history.fromuserid
WHERE user.state = 'ready'
GROUP BY user.userid
This causes a full table scan on the second table. If I do the following
however the index
You are inserting 6 values into 7 fields, so it fails.
You don't see the failure because you are doing an insert ignore.
You are also inserting numbers with 4 digits right of the decimal, where
you have specified 2.
Mudit Wahal wrote:
Description:
I have a delete statement and an insert
I have a set of records in a mysql table that are called categories. A query
pulls all the records for category and in turn this are then links to items of
that said category. Simple. Ok here is the bit I want some feeback on. I want
to create another table (if this is the solution) and split
At 15:58 +1300 2/5/03, Defryn, Guy wrote:
I was just reading through the Mysql manual section 3.32
And came across a sentence that started like this
Animal sex can be represented in a variety of ways
My mother tongue is not English but doesn't it sound rude ? :-)
Yes, it does, and current
On Tue, Feb 04, 2003 at 02:58:28PM -0500, Jianping Zhu wrote:
I have mysql in a redhat machine. I need to use mysql do user
authentication to a website.
I have a table like following.
+--+--+
| username | passwd |
+--+--+
| jianping | jian1830 |
|
I love it!!! 8-))
You are correct that it does sound a bit rude, even when English is
your first language and you stop to think about it. However, what the
statement means is identical to The sex of the animal can be
represented... and it is acceptable grammar.
Thanks for making my day.
Doug
I guess it depends on if you have a dirty mind, or, you just ignore it and
understand the point of the example. ;) lol
But yeah, could have been worded slightly different.
Kevin
- Original Message -
From: Defryn, Guy [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 05,
A Left join using IS NULL will work. You can get the syntax and see an
example in the manual
http://www.mysql.com/doc/en/JOIN.html
From the maunal...
If there is no matching record for the right table in the ON or USING part
in a LEFT JOIN, a row with all columns set to NULL is used for the
Does anyone know about an error that occurs when you try to submit into mysql.
Whever i try to imput any text with a comma in it or an appostrophe, i get an error
until i remove it.
Any suggestions. .. anyone...? Im using php and submiting via post, when i get the
error.
Thank you so much
Hey,
I have discovered a strange error in the mysql versions mentioned in subj.
Example.
A table with 10 entries ...i want to draw 3 randomly
= select fieldName from tableName order by RAND() limit 3
this have worked for the last year or so.but after upgrading our redhat
7.2 with mysql
I believe you can do:
select avg(scantime) from percentile;
select std(scantime) from percentile;
std() is the same as stddev() which finds the standard deviation. If
the scantimes are gaussian (pretty good assumption if it's a large
dataset), then the 95th percentile will be avg() +
On Wed, Feb 05, 2003 at 03:58:21PM +1300, Defryn, Guy wrote:
I was just reading through the Mysql manual section 3.32
And came across a sentence that started like this
Animal sex can be represented in a variety of ways
My mother tongue is not English but doesn't it sound rude ? :-)
Heh.
the easiest way to do this is to use mysql's own 'password' function.
to add a new user use:
insert into table (username,passwd) values ('jianping',password('jian1830'))
to validate the password:
select count(*) from table where username='jianping' and
passwd=password('whatwasentered');
or
Are you referring to the data type SET or the Command SET? The manual page
you point to is talking about the data type, but usually when seen in an
insert it is the Command. I can't recall seeing the datatype referred to in
an INSERT, but maybe my brain isn't fully on yet today.
This is probably a dumb question, but are you running all the queries in
eod_stocks? I ran all the queries and they worked fine. I undotted the
select though because my database was not called eod_stocks. Since you did
not include the part where you select the database to run these queries in,
Thank you.
I have set up the grant tables though but it still doesnt work. I
thought it might be because the daemon isnt been run as mysql user, but
when I try and do :
/usr/bin/safe_mysqld user=mysql
like it says in the manual, I get an entry in the log file saying that
there are too many
Jaime,
You should be using the DISTINCT function.
SELECT DISTINCT account, id, FROM etc.
This should give you one instant of 'account' in your SELECT output.
At 09:24 AM 2/5/03 +, Jaime Teng wrote:
I have a MySQL table:
Hi. Simple parent/child table generates some weird output based on the order
possible bug?
Mysql 3.23.54
CREATE TABLE parent(id INT NOT NULL, PRIMARY KEY (id)) TYPE=INNODB;
CREATE TABLE child(id INT, parent_id INT, INDEX par_ind (parent_id),
FOREIGN KEY (parent_id) REFERENCES
I have a small probleme with MySQL in 3.23.55.
I do not manage to create my tables under the format InnoDB by specifying the
type of creation at the end of the command.
Thank you in advance
-
Before posting, please check:
Description:
I'm adding the data in the tables via batch mode. I see that the sql INSERT
statement
returns success. But when I query the data, I get empty set.
How-To-Repeat:
--
create table if not exists CBI (date DATE not null, close DECIMAL(10,2),
Description:
Please IGNORE my previous bug report. I had another script which was
deleting the data. Stupid user error.
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:Mudit Wahal
Organization:
MySQL support: [none | licence | email support |
Thanks again to everyone who replied!
I finally decided on:
MySQL - Second Edition
Professional PHP Programming - Second Edition
After all the responses here and the feedback through the online
bookstores, those are what I'm after.
--
Loren McDonald
[EMAIL PROTECTED]
-Original
Jaime,
You should be using the DISTINCT function.
SELECT DISTINCT account, id, FROM etc.
This should give you one instant of 'account' in your SELECT output.
At 09:24 AM 2/5/03 +, Jaime Teng wrote:
I have a MySQL table:
On Wed, Feb 05, 2003 at 10:37:29AM +0100, RAHARD Matthieu wrote:
Hello everybody,
Is it possible to set up this kind of replication and what parameters I have
to set in the my.cnf file ?
Table A own by server A and replicated to server B and C
Table B own by server B and replicated to
this is exactly what i am asking , when u say new gamma development
release (use this for new development) what does it all mean , is it
stable for production use ? i would like to know to convince work to start
using it ?
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
Is this possible
select nome from categorias where id_categoria in (select id_categoria
from categoriamembro where id_membro=1807)
in MySQL
Thks
[MsR]
-
Before posting, please check:
http://www.mysql.com/manual.php
hi there i was wondering if mysql 4 will become production quality soon
? i would like to convince work to start using it, so i can start using
the transactions, sub selects and query cache
I don't think MySQL 4.0 has sub-selects, that's 4.1.
I've been using 4.0 on two different ISPs for a
In the last episode (Feb 05), Dan Rossi said:
hi there i was wondering if mysql 4 will become production quality
soon ? i would like to convince work to start using it, so i can
start using the transactions, sub selects and query cache
Well, MySQL 3.23 already has transactions with the InnoDB
hello.
You can read lock whole database's tables like this :
FLUSH TABLES WITH READ LOCK ;
and unlock with
UNLOCK TABLES ;
- Original Message -
From: Franz, Fa. PostDirekt MA [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 10:35 PM
Subject: locking tables ,
Hello!
I have a following system.
Server A : a master for server B. MySQL 4.0.9
Server B : a slave for server A, a master for server C. MySQL 4.0.10
Server C : a slave for server B. MySQL 4.0.10
and I wanna that if update occurs on A, it forwarded to B and B forward it to C
But I don't know how
i see that you don't specify any path for
innodb_data_home_dir, innodb_log_group_home_dir and
innodb_data_file_path ... write down the correct path
and retry.
regards.
--- Davy Obdam [EMAIL PROTECTED] ha scritto: Hi
People,
I have been trying to get InnoDb to run on my
windows XP
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 5 Feb 2003, Defryn, Guy wrote:
I was just reading through the Mysql manual section 3.32
And came across a sentence that started like this
Animal sex can be represented in a variety of ways
My mother tongue is not English but doesn't it
i am new to mysql,
my problem is that i cannot create tables with type innodb
i have made the entry innodb_data_file_path in my.cnf
i am using mysql 4.0.2 alpha on red hat 7.1
could anybody plese help me?
thanks
anirudh
-
i am planning to shift my database from mysql to db2
could anybody please send me some details showing the performance of the
mysql server usder varying loads as compared to db2 server
thanks!
-
Before posting, please check:
Hello,
When you say not easily, you say that it's possible.
Can you explain to me what I have to do to realize that even if it's a
complex solution.
Thank's for your help.
-Message d'origine-
De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 6 février 2003 03:05
À : RAHARD
drop database yourdatabasename;
- Original Message -
From: Calvin Lam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 05, 2003 2:50 PM
Subject: Deleting a database in Mysql
Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in Mysql
Hi all
i am working on mysql 4.0 on netware OS.
in the my.cnf file i removed the skip-symlink option under mysqld
program.
then i used the following query:
mysqlcreate table temp ( id int auto increment primary key,
name varchar(20) not null)
data directory = 'sys:/etc';
the table is created
See DROP DATABASE
Doug
On Wed, 5 Feb 2003 22:50:25 +0800, Calvin Lam wrote:
Hi,
I am a newbie with this and I need help with Mysql
How can I delete a database in Mysql
thanks!
-
Before posting, please check:
trying to get mySQLGUI to install on Mac OS X, fltk seemed to install
ok but am getting the follwoing for flvw
[ARTiBook:~/src/flvw/1.0] root# make
=== making src ===
Compiling Flv_List.cxx...
In file included from ../FL/Flv_List.H:45,
from Flv_List.cxx:38:
56 matches
Mail list logo