This isn't exactly what I was looking for, but it works like a charm for
both my needs and the sys admins.
Go figure everyone is happy now!
Many Thanks!
-Tyler
Kishore Jalleda wrote:
The delete would definitely depend upon the size of the record set being
deleted, anyway assuming I
I'm trying to wrap my head around a performance problem our institution is
having on our Mysql Server which hosts all of our logs from around campus.
Specifically our MailLogs tables.
What I'm having a hard time with is we have metadata such as:
CREATE TABLE mail00 (
host varchar(32)
Hello!
another simpler solution :
...
Thanks, Mathias!
You helped me greatly!
Now my program works as desired.
--
Good luck!
Vladimir
Please avoid sending me Word or PowerPoint attachments.
See http://www.gnu.org/philosophy/no-word-attachments.html
--
MySQL General Mailing List
For list
Hello!
MySQL v. 4.1.11.
I'm trying to write a subquery, MySQL says Error.
select num, theme, intro
from vt_(select pnid from vt_partition where pnid regexp '^[0-9]{11}$')
order by date desc, timer desc;
describe vt_parition:
+--+--+--+-+--++
Hello!
Many thanks to everybody who tried to help me!
N.B. you should have only one pnid to make your query work (UNIQUE pnid),
or LIMIT the result of the subquery by LIMIT 1.
I need to do the following:
Get one or more than one pnid from vt_partition and then make queries to the
vt_pnid
Last week we upgraded from mysql 4.0 to 4.1.7. Since then some queries
on newly created tables (ie created since the upgrade) are failing with
the error:
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
and (utf8_general_ci,COERCIBLE) for operation '='
I have been doing a
* * * * * * * * * * * * * * * AntiVir ALERT * * * * * * * * * * * * * * *
AntiVir has detected the following in a mail from your address:
Worm/MyDoom.AE
The mail was not delivered.
Please remove any potential malicious software from your computer before
sending a new mail with
I compiles a C application which uses mysql library on two RedHat 9.0 machines.
Both machines are using the same GCC and the same MySQL 4.0.16 :
MySQL-client-4.0.16-0
MySQL-server-4.0.16-0
MySQL-devel-4.0.16-0
MySQL-shared-compat-4.0.16-0
gcc-3.2.2-5
gcc-c++-3.2.2-5
libgcc-3.2.2-5
In the
Can someone help me find out what caused this crash?
My system is a Red Hat 7.3 on a HP Netserver LC2000, dual PIII 800mhz
with 2.5G ram. 3 disks in raid 5.
The MySQL database is 4.0.17
040212 19:27:36 read_const: Got error 126 when reading table
./exp4/sql_cache
Number of processes running
[EMAIL PROTECTED] wrote:
Did you perform a stack trace?
No, how do I do that?
/Jacob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ah that's sheer genius!
Thanks muchly, I never figured in to being able to use SQL with it's own
variables so to speak - I'm sure I'll find more than one use for this new
ability!
Much appreciated Ed :)
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL
Hi all, I'll just get straight to the problem (simplified):
Say I have the following table/columns:
ID, Score, Rank
1, 20, 0
2, 50, 0
3, 10, 0
4, 5, 0
5, 97, 0
Is it possible, in a single query (using sub-queries if necessary), to give
all of these ID's the correct rank... ie if such a thing
Hello,
How can I enable MySQL 4.0.16 log ?
I just compiled and installed it in my RedHat 9.0 system, but I cant see any log
files. I use
default /etc/my.cnf from my-large.cnf.
Sorry, if this question is too newbie, but I cant understand clearly reading MySQL
manual.
Thanks for helping me :)
Hi,
My server is using RedHat 9.0.
I just CHANGED the mysql from 3.23.58 (rpm) to 4.0.16 (rpm).
What I did :
# rpm -e all mysql 3.23.58 rpm
# rm -rf /var/lib/mysql
then install the 4.0.16 (rpm)
# rpm -i MySQL-server MySQL-client ... MySQL-devel ... MySQL-shared-compat
After
---Original Message-
--From: Admin-Stress [mailto:[EMAIL PROTECTED]
--Sent: Tuesday, November 11, 2003 11:44 AM
--To: [EMAIL PROTECTED]
--Subject: After installing MySQL 4.0.16 (rpm), it did not create
--/etc/my.cnf ?
--
--Hi,
--
--My server is using RedHat 9.0.
--
--I just
I have a table called TRANSACTION, it has some fields :
REGDATE - date of the transaction
WHAT - a string (NOT UNIQUE)
CUSTOMER - customer code
I want to query all WHAT that the date of the transaction was 15 days before.
So, my sql query is :
SELECT WHAT FROM TRANSACTION WHERE REGDATE Now()
I have a numeric table field, named CREDIT.
How can I add a number (+50) to that field for all the table record ?
is this correct?
UPDATE ThisTable SET CREDIT=CREDIT+50
Please help,
Thanks
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
Hiya,
Is there any way to do a hexadecimal search via MySQL? I've found that the
data I uploaded from text files has some end-of-line characters in it, and
its causing my data to break in mid-line when spitting out a text file.
Would be cool to search the table for offending characters if
Hello,
On a P4-2.6Ghz, 1Gb mem server of ours, mysql keeps getting slower and
slower because the database gets bigger and bigger.
At the moment the database is 5.5Gb big, the biggest table being 1.1Gb.
'top' shows that mysqld is using 264M of memory. So I presume the rest is
used for disk
I have a table with this structure :
username VARCHAR(32)
address VARCHAR(128)
datereg DATETIME // date of registration
classINT
How is the sql query for username who are their datereg was 30 days ago and class = 1?
thanks
__
In MySQL is it possible to create a temporary table without having to
specify all the properties? On SQL Server (at least via query analyzer) you
can create temp tables fairly easily and the properties of each field are
inherited from the regular table.
Doesn't look like thats the case with
In MySQL, I need to do a multi table join in the context of a left
join. Have three
tables: NAME, ADDRESS, and COUNTRY. Address contains a country code
(ie
CAN) and COUNTRY contains the translation (ie Canada). What I'd
like to
do is get all NAMES, all datat from ADDRESS if it exists,
Hi,
I am new to mySQL, so I need some help.
I have a table, which has record structure like this:
- customer
- name
- register_date
- expired
Every day, I add some records, new customers. The field 'expired' is just a flag,
either '1' or
'0'.
If register_date is 3 months ago then expired =
I would like to return rows, with specific columns, for each individual in
my NAMES table, with address and e-mail if these exist. Thought I had the
syntax down but I'm getting NULL results where I know there is data. I'm
used to using SQL Server shortcut * for outer joins, guess that's catching
Hi,
I finally established a connection to my db after I realized that it was
located in a different directory than that which I kept placing my php
files. As some would say, D'OH!
The code below is intended to select and display all 1300 names from the
NAMES_TBL but is only returning the
Hi,
I wrote an application using mysql C API.
If I exit my application without closing database, will it be closed automatically?
void error(int code) {
printf(error: %d\n, code);
exit(0);
}
int main() {
...
error(-255);
...
}
How to pass the mysql database connector to a function? is
Hi,
I wrote a simple CGI application using mysql. What it does is really simple :
connect to mysql database
... do something ...
update a field
... do something again ...
close mysql
The update is like TOTAL = TOTAL + AMOUNT.
If let say, 1000 users accessing my CGI in the same
Description:
When running mysql-test-run the test aborts with the following message:
Installing Test Databases
Removing Stale Files
Installing Master Databases
021124 1:25:15 Warning: Can't create thread to handle bootstrap
021124 1:25:15 Aborting
Hi,
After I installed mysql, I noticed there is an open port now, port 3306.
Can I restrict this so only from localhost can connect? I meant to close port 3306.
But without using firewall :( I dont have knowledge about this.
If there is no way to do this without firewall, then I will learn it.
Hi,
I am just a starter. Anyone can suggest me good web resources for learning SQL command
that I can
use (compatible) with mySQL ?
I read from www.mysql.com documentation, but it's not complete ...
Well, if you have collection for beginner, please :)
Thanks,
kapot
After playing around with 'test' database, then I would like to create my own database.
I logged in into mysql using root account and created a database.
But, when I logged in using regular user, I got his error :
ERROR 1044: Access denied for user: '@localhost' to database 'card'
What
thing to do) and maybe
do a positive binary dance or some chanting. If I don't make progress
on this in the next day I'm gonna brew up some damn strong coffee and
INSERT the data --- gotta have data!
Admin (aka chris)
BTW thanks for your willingness to help
database on replicated tables
it is not replicated to the slaves (even though the statement is replicated
to the relay log on the slave servers).
Fix:
Unknown
Submitter-Id: miguelryan
Originator:MySQL admin account
Organization: freelance consultant
MySQL support: none
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:FR/I/*KO_TBD// Admin Apache
Organization:
organization of RHODIA F.TOUITOU (multiple lines)
MySQL support: [none | licence | email support | extended email support ]
Synopsis
Hi all,
I have installed a clean RedHatLinux 7.1, and 7.2, and have selected
the PHP and mysqlshare components to install. I also have configured the
httpd.conf to use the php modules with Override ALL option. But when I want
to run any php, including the one that need to access the mysql
can MySQL run as cluster under the platform of IBM AS/400 also??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
Can MySQL or PostgreSQL build up a cluster for failover or improve the
database performance just like Oracle or Sybase ones?
If can, where we can get such setup documentations?
-
Before posting, please check:
Hi,
Thx for all your help, I can export the tables in exportSQL scripts.
But how to make the procedure of inserting data more easy instead of
using mysql daemon od MySQL GUI?? Both of them need to use Sql language to
insert data. Any software or tools like Microsoft Access or Lotus Approach
How to migrate Microsoft .mdb Database into MySQL under Unix
environment?? Who can tell me?? Any Doc??
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi.
I prefer doing like this
$query = CREATE TABLE query ;
$query .= tabledef for col a,;
$query .= tabledef for col b,;
$query .= lots more table defs,;
$query .= welcome to line 400;
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wrote:
Hi.
You forgot around temp example:
mysqlselect datetime,temperatura from temperatura where
datetime=2002-02-08 09:30:00 and temperatura=15.8;
Regards
/PM\
Miguel Figueiredo wrote:
Hello all,
I have a (probably dumb) question.
My table temperatura has two fields described bellow.
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql-connect(undef,database,username,'password');
$sql = select blah from blah;
$sth = $dbh-query($sql);
@arr = $sth-fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is other ways
Hi.
You forgot around temp example:
mysqlselect datetime,temperatura from temperatura where
datetime=2002-02-08 09:30:00 and temperatura=15.8;
Regards
/PM\
Miguel Figueiredo wrote:
Hello all,
I have a (probably dumb) question.
My table temperatura has two fields described bellow.
Hi.
You have to install DBI::DBD module.
Then in perl
use Mysql;
$dbh = Mysql-connect(undef,database,username,'password');
$sql = select blah from blah;
$sth = $dbh-query($sql);
@arr = $sth-fetchrow;
for example if the result is more than one line you have to loop it
Ofcoz there is other ways
Hi.
I prefer doing like this
$query = CREATE TABLE query ;
$query .= tabledef for col a,;
$query .= tabledef for col b,;
$query .= lots more table defs,;
$query .= welcome to line 400;
You get the point i guess
you can do same things many different ways in php:)
/PM\
Alex Aulbach wrote:
the BDB
tables as well,is that using '--with-berkeley-db=./bdb' enough?
I'm waiting for your replying and thank you for that!
admin
[EMAIL PROTECTED]
-
Before posting, please check:
http
Hi.
I would type museum: department or likewise in name field
if its not so many it would work nicely.
But thats just me:)
/PM\
David S. Jackson wrote:
Hi,
I came across a relationship between entities that I hadn't
counted on, and I'm trying to adjust my database tables to handle
Hi.
I would do a simple read file,search database,input record script in
perl
and transfer the files using scp (ofcourse i asume this is in
linux/unix)
put it all under cronjob and it should work fine.
On the other hand i am sure others have better ideas:)
/PM\
David Shields wrote:
Hi, I
Hi.
Not only that you also sent it to the wrong person:)
It was david that asked the question anyway i cc it to the list and him.
sometime i will experiment with that also but time is to short:)
Regards
/PM\
Ed Lazor wrote:
doh... I should go to bed... I just reread what I wrote and it
Hi.
Seems the paths are missing so try running locate mysql or find -name
mysql
from basedirectory.
/PM\
Stephane Pinel wrote:
I've installed mysql 3.23.47 (Binaries) on a Linux RedHat 7.0 box.
Everything seems to be OK (the server runs) but I cannot connect to it using
mysql client:
Jeremy Zawodny wrote:
On Fri, Jan 18, 2002 at 03:16:15PM +0200, Markus Lervik wrote:
Hello all!
We've requested a database from different companies, and
specifically said we wanted MySQL or PostgreSQL because of the open
source angle and we're a library.
One company offered
SNIPSNIP:)
I agree. If they are a seriuos company they should build it after the
customers wishes
i.e if you want mysql the company should build it with mysql.
For 18,000 euro i could build the system myself:)
My two cents
/PM\
What about the customer who asks a car company to
Julian,
The as field is just setting the name of the field or column. For example
in PHP, if you don´t use the as somename, you must use array[2] (I just
use 2 as an example) instead of array['datefield'] to get the information.
Regards,
Ingvar G
Web accounting CRM
us.logiledger.com
-
I was just reading an annoying article from a user who was moving from MySql
to Postgres because of stability problems and because of problems restoring
large MySql data-dumps. I checked his site and it does not have the
appearance of a very heavy loaded site so I am not sure what he means by
Thanks Richard and you others for good input concerning Annoying article,
I myself have nothing but good experience from using the MySql database but
reading articles like this one and another one on the same web talking about
when you outgrow MySql, then you must change to the more advanced
Dear support officer,
The followings are generated by the mysqlbug script:
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `' and `').
SEND-PR:
From: yuzh
To: [EMAIL PROTECTED]
Subject: [50
I am working on a project for a client that got roped into MsSQL7 by her
last hosting company. I am looking for a good way to convert a MsSQL7
Database to MySQL. Anyone know of a piece of software that will convert the
Database files or atleast suck from one database to the another.
Thanks in
Hi Nicole,
I guess the first issue is to be certain that you have the
correct password and a MySQL account set up. If you have a
shell account try something like mysql -u[your user
name] -p[your password]. Sometimes ISP's will use different
passwords for MySQL than the standard log in, we often
Hello,
I'm contacting you because we have recently released a new web development platform,
EO, that I would like for you to try out for use in building dynamic sites.
EO is a portable, flexible yet robust system that you can use to quickly build
interactive sites, plus it has features that
Hi,
I recently had some questions about converting files and
haven't had the chance to work further with it or thank
everyone for the help. So thanks a lot.I found that my
application
needed to have a dedicated MySQL installation. There is
another version of MySQL running on this machine
Hi Paul,
Thanks for the help. I was hoping to accomplish this with MySQl, but in the
end a script works just as good and this is just the first of several I am
using. For what it's worth I ended up using sed. Here is is if somone else
could use it:
sed s/ /|/g
^This is a tab,
Hi,
Being new to MySQL, I am having a problem getting output from it to the
shell that is formatted the way I need. I need a table to be written to a
file with a delimiter.
something like :
#!/bin/sh
mysql -uroot -ptest database sql
Then I run that script like this:
./script.sh output.txt
62 matches
Mail list logo
