YW CHAN (Cai Lun e-Business) wrote:
> Gleb,
>
> Thanks, eventually I find that the problem is not the special.
>
> But the statement concat(field1,',',field2) as something will
> generate NULL if the field1 is NULL.
>
> Not sure if it's documented anywhere, or just a simple programming
> concept
>Thanks for your inputs Eric.
>I tried this but it couldn't give me any insight abt
>how can optimize this
>for space saving of temp tables.
>Maybe I am not expert enough to interpret this
output, >so here it is -
>- Manish
Seeing the explain log, it looks to me like you donot
have any index def
Gleb,
Thanks, eventually I find that the problem is not the special.
But the statement concat(field1,',',field2) as something will generate NULL if
the field1 is NULL.
Not sure if it's documented anywhere, or just a simple programming concept
that null plus anything equal null..
-- O
Hi,
Set the value as
SET @SoftwareID:=7;
Now, use
WHERE
s.softwareID = @SoftwareID at the end of your query.
Thanks,
Narasimha
-Original Message-
From: Erich Beyrent [mailto:[EMAIL PROTECTED]
Sent: Monday, December 13, 2004 8:30 PM
To: [EMAIL PROTECTED]
S
Can anybody tell me how AUTO_INCREMENT works in MySQL especially when we are
using DB Replications.
At times I get duplicate key error though taken care that the insertions and
updations are done in the master db.
check your .myd file size. if table type is myisam and it it is more than 4
GB then convert it to InnoDB.
--Anil
-Original Message-
From: matt_lists [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 14, 2004 8:36 PM
Cc: [EMAIL PROTECTED]
Subject: Re: Restore help! been going 2 weeks
matt_lists wrote:
Dathan Pattishall wrote:
From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outa
Nobody else has problems with restores on 8+ gig tables?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here's a SQL statement that converts dates to epoch time in Oracle.
I'm too lazy to convert it to MySQL but it should give you a start.
select 86400 * ( to_date('14-feb-2000 10:38:39', 'dd-mon-
hh24:mi:ss')
- to_date('01-jan-1970', 'dd-mon-') )
from dual;
--Walt
>
What does the show processlist look like?
Have you ran top/vmstat/iostat when the `hanging` occurs?
Hjalmar Gislason wrote:
Hi there,
I've been having some trouble with an application that I'm running
(www.spurl.net).
I have a database that consists of about 20 tables. The largest tables are a
litt
Hi there,
I've been having some trouble with an application that I'm running
(www.spurl.net).
I have a database that consists of about 20 tables. The largest tables are a
little more than one million rows and the database in total around 1GB - so
nothing serious there. The amount of queries is on
Hi,
I used mysqldump to recreate the a DB in another machine:
% mysqldump -A -u root --opt -p > backup.sql
But I guess that duplicates some columns in the mysql database, `cause
when want to add a new user to a new database:
mysql> grant all on some_db.* to [EMAIL PROTECTED] identified by 'pwd'
Thanks, Shawn, this helped a lot, although I'm not there yet.
(..and you got it absolutely right, I just couldn't explain it correctly).
I tried to execute this in OpenOffice, but it seems to use a function called
executeQuery(). I don't know if it's part of OpenOffice or a library routine
in th
Title: Double conversion error
I have a query where I perform an update "where (CALL_ID = 2.37000e+002);"
This query updates nothing, even though my "CALL_ID" column has an id of "237".
If I change the end of this query to read: "where (CALL_ID = 237);", then the row with "CAL
Hi all
having a table with one text field in which I store text (sic!) I need
to extract from it every occurence of a term (or a phrase) with its
context, litteraly extract 30 char before and 30 char after the term
I have searched.
thx for any suggestions
ciao
Mario
--
MySQL General Mailing
Hi,
I have Apache 2, PHP 5 and MySQL 4.1 installed on an XP pro box.
I have created a new database 'ijdb' with a single table 'joke' and have
entered data into two of the three fields in the table.
I can access the database / tables / data from a command prompt, and I can
access and extract the
Thanks,
I did think of it but not having the option as this is
linked to executables, which I'm sure have some sorts
of calculation for this field to calculate the next
value.
regards
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> > I want to create entries in the child table
> (table2)
>
> I want to create entries in the child table (table2)
> for the missing records. In table2 the primary key is
> of type Integer,
> for each new entry it should be
> Max(table2.PrimaryKeyfield) + 1.
Why not make the primary key in table2 autoincrement? If you have an
autoincrement field as primar
Hi, I have a problem with mysql 4.0.22 on fedora core 2.
..when I try:
#/usr/bin/mysqladmin -u root password ''
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: Can't connect to local MySQL server through socket '/var/lib/mysql.sock
(2)'
Check that mysql is running and that
It's not a hard as you are making it out to be. You are already able to
"Group" you data on a value that breaks your data into "useful chunks". In
your case you already figured out one way to differentiate one hour from
another and one weekday from another. (The value 'Sun 00' is different
tha
Check here. You will find examples here.
http://www.geocities.com/jahan.geo
[EMAIL PROTECTED] wrote:
Hi,
I am building the insert string for inserting into particular table t1
using C program. The below string is stored in a variable.
say sqlstmt = 'INSERT INTo T1 values(:id,:ename);'
The values fo
SciBit is proud to announce the release of the newest version of MyCon, v2.6
This version includes many new and improved features as well as all reported
bugfixes. Amongst others:
1. Built-in support for the new 4.1 authentication, i.e. without need for an
external libmysql.dll
2. Improved Cop
Steve Grosz wrote:
This is a follow up message to a earlier threat this week (which is included
in the message below)
"model","CREATE TABLE `model` (
PRIMARY KEY (`PID`)
"vendor","CREATE TABLE `vendor` (
PRIMARY KEY (`PID`)
"specs","CREATE TABLE `specs` (
PRIMARY KEY (`SpecID`)
Like Rhi
I have a table like:
CREATE TABLE `user_details` (
`id` bigint(6) unsigned NOT NULL auto_increment,
`user_name` varchar(100) NOT NULL default '',
`user_email` varchar(50) NOT NULL default '',
`user_ref_from` varchar(100) default 'Not Given',
`other_ref` varchar(255) default 'Not Given',
`pro
Hello.
Use:
$link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
or die("Could not connect : " . mysql_error());
to determine what error occurs when you are connecting. Turn on
error reporting in php.ini.
>Hi,
>I have Apache 2, PHP 5 and MySQL 4.1 installed on an XP
Hello.
You may use OPTIMIZE TABLE.
Duncan Hill <[EMAIL PROTECTED]> wrote:
> I'm having to run some purges of data to clean up disk space until the new
> storage array arrives. I've got the data archived, and the rows deleted from
> the table. The only method I know to reclaim the space
Hello there,
I do have a table in mysql 4.x with redundant info. Only the autoincrement
ID is different.
Example:
ID citycc
2559756 Witkop SF
2559757 Witkop SF
This turns to be a huge problem since I cant find a way to delete the
redundant rows with a mysql query. Is there a solutio
Description:
When I try to call mysql_init() several times in my program it finishes with
segmentation fault.
This happens in different places of my program but always in mysql_init().
This is the gdb output:
#0 0x007ba6ae in malloc_consolidate () from /lib/tls/libc.so.6
#1 0x007b9e6a in _int_
At 19:32 +0100 12/13/04, Alina Bikowska wrote:
Description:
When I try to call mysql_init() several times in
my program it finishes with segmentation fault.
This happens in different places of my program but always in mysql_init().
This is the gdb output:
#0 0x007ba6ae in malloc_consolidate ()
Dathan Pattishall wrote:
From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outage. If you
can't
John Berman wrote:
I have a table that has start_date and expire_date in the format: 2004-12-31
That is an output format... yes? If the column is a string type
(char/varchar/text...), you should change it to a DATE type, or maybe
TIMESTAMP. The default output format for DATE type columns is -
Hi all
having a table with one text field in which I store text (sic!) I need
to extract from it every occurence of a term (or a phrase) with its
context, litteraly extract 30 char before and 30 char after the term
I have searched.
thx for any suggestions
ciao
Mario
--
MySQL General Mailing
Hi.
Is there a way to in the mysql client (4.0.18) to for a list of "IDs"
execute 2 queries with each ID...
I.e. : I have a list of IDs 1,2,3,24,19,4,5 ... and would like to
"loop" through them to execute 2 queries for each one so that I can
pull the proper records out and print out the results..
I'm having to run some purges of data to clean up disk space until the new
storage array arrives. I've got the data archived, and the rows deleted from
the table. The only method I know to reclaim the space in the table is to
use myisamchk -r. Is there any other faster method for reclaiming t
>From the brief sound of it your using myISAM, and the query taking the
most time is not indexed or using an index properly.
Alters will lock the table, and once it starts it should finish or your
going to have to recover the table. I suggest taking an outage. If you
can't
Make a replica of the
Is there any way to limit drive usage per thread?
I have a problem where an update thread will use 100 % of the drive, and
simple index searches that should be instant will wait and wait and wait
before responding.
I dont want one user to kill everybody else
I'm adding a column to a large table
Walter Pucko wrote:
Hello there,
I do have a table in mysql 4.x with redundant info. Only the autoincrement
ID is different.
Example:
ID citycc
2559756 Witkop SF
2559757 Witkop SF
This turns to be a huge problem since I cant find a way to delete the
redundant rows with a mysql query.
Hello,
You can try delete/filter the redundant rows with this code:
(this is an option :D)
create table yourtable
(
id int not null auto_increment,
city varchar(20),
cc varchar(2),
primary key(id)
);
insert into yourtable values (0,'AAA','AA');
...
insert into yourtable values (0,'DDD'
Roger Baklund wrote:
[...]
You are joining the model table on vendor.PID=model.VendorID, and
model.VendorID is not a primary or unique key, it could contain
duplicates.
... probably the four rows you want. This is ok. It's probably the other
join that causes the problem.
--
Roger
--
MySQL Gene
In the last episode (Dec 13), Duhaime Johanne said:
> I have a script that check the status of all innodb tables. It works
> fine interactively.
>
> But not from the crontab tab.
>
> Here is the error message and also a list of the environment variables
> from the crontab
>
> The message is abou
In the last episode (Dec 13), Dan Nelson said:
> In the last episode (Dec 13), Duhaime Johanne said:
> > I have a script that check the status of all innodb tables. It works
> > fine interactively.
> >
> > But not from the crontab tab.
> >
> > Here is the error message and also a list of the envi
Hi
I have a table that has start_date and expire_date in the format: 2004-12-31
I also have a start field and expire field
I need to convert the start_date to Epoch seconds and place in start and
convert the expire_date and place in expire.
I'm unsure how to convert and how to do this in one
For me, a Newbie, this is a tricky one. I've been through the manual and this
archive, but haven't found a solution. Could someone of you experienced please
help?
Is it possible to make this query in one single SQL-statement? (Using MySQL
4.0.15 - If this can be done smarter in 4.1.x, please she
Hello
I have a script that check the status of all innodb tables. It works
fine interactively.
But not from the crontab tab.
Here is the error message and also a list of the environment variables
from the crontab
The message is about libz.so that does not exit: but:
l /usr/local/lib/libz.s
This is a follow up message to a earlier threat this week (which is included
in the message below)
Ok, here's the model table:
"Table","Create Table"
"model","CREATE TABLE `model` (
`PID` tinyint(3) NOT NULL auto_increment,
`VendorID` tinyint(4) NOT NULL default '0',
`Model` varchar(15) NOT
To be perfectly honest I believe you have completely confused the
programming language you are using with the SQL statements you need to use
to interact with the server. These are two separate languages and have
their own separate syntaxes.
You can use almost any programming language and the
hi all,
I've just upgraded one of the replicate servers from 4.0.22 to 4.1.7,
just as a test before upgrading all the others.
Apparently I had just this problem: datetime data inserted in ISO format
is not accepted -- strings like '20041210T104201' when inserted get
silently translated to "-
[snip]
This does not work. It appears that the user variable is not picked up
in
the WHERE clause - the query works fine if I have:
[/snip]
You have a fundamental lack of understanding of user variables. A quick
read of http://dev.mysql.com/doc/mysql/en/Variables.html will reveal
"User variables
I am having a problem with a query:
SET @SoftwareID = 7;
SELECT
s.softwareID,
s.softwareName,
s.softwareVersion,
s.softwareCreated,
s.softwareChanged,
b.buildName,
s.supportFlag,
s.softwareDesc,
s.softwareLicense,
s.s
Need help with mysql restore speed
Table crashed, had to restore from backup, I started the restore 2 weeks
ago, the last change date on the files is the 8th, so mysql has not
wrote data into the files sense then, but it's still running! (or is it?)
the data restore is pretty quick, the index re
The statement Create Trigger was added in MySQL 5.0.2.
> Hi,
> I have problem in using "create trigger" in MySQL
> 4.1. I had read through the MySQL manual and found
> that "create trigger" may not be supported by MySQL
> 4.1.
> Here's the question, how should I do to make
> MySQL 4.1 to do the
Hello.
See:
http://dev.mysql.com/doc/mysql/en/mysql_real_escape_string.html
Can you send complete test for your problem?
"YW CHAN (Cai Lun e-Business)" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I find there seems problem with this select statement when there is a special
> character i
Mike,
Try select * from foo order by x+0, x;
x+0 converts x to an integer by taking the digits from the beginning of the
string.
== original message follows ==
Date: Sat, 11 Dec 2004 15:36:34 -0600
From: Mike Blezien <[EMAIL PROTECTED]>
To: MySQL List <[EMAIL PROTECTED]>
Subject
Hello.
I can't find such feature in documentation and archives.
The best way I've found is to comment or uncomment line in your my.cnf file
and restart server.
Remigiusz Soko?owski <[EMAIL PROTECTED]> wrote:
> Hi!
> I wonder if there is any possibility to switch log off on running server?
>
> Us
Hello.
I don't know if it is exactly what you want, but look at this:
http://dev.mysql.com/doc/mysql/en/SQLPS.html
http://dev.mysql.com/doc/mysql/en/C_API_Prepared_statements.html
>I am building the insert string for inserting into particular table t1
>using C program. The below st
Hello.
You should use my-xxx files as examples for creating your own.
--defaults-file=path_to_file points mysqld to location of config file.
Also see:
http://dev.mysql.com/doc/mysql/en/Option_files.html
Hiu Yen Onn <[EMAIL PROTECTED]> wrote:
> hi,
>
> i compiled mysql-4.1.7 from
Hi!
I wonder if there is any possibility to switch log off on running server?
Usually I have here general logs disabled due to performance and space
saving reasons - but of course sometimes it is needed to find out full
info about queries executed. It'd be fine to have possibility to run
server
Hello.
Usually clients are blocked with insert or update statements until
table became unlocked. Their threads just sleep and then continue
execution (but they can got an error if query doesn't return for a long time).
INSERT queries are not buffered in that sense you've ment, unlike they are
INSE
Hi,
I am building the insert string for inserting into particular table t1
using C program. The below string is stored in a variable.
say sqlstmt = 'INSERT INTo T1 values(:id,:ename);'
The values for the field's id, name will come from the front end. The
sql string will be executed using Pro *C
Hello.
Before doing anything you should read:
http://dev.mysql.com/doc/mysql/en/Windows_vs_Unix.html
http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html
lan Scott - Yahoo Acct wrote:
> We have 2 distinct groups of developers - Windows vs. Linux. Our production
> server is g
Hello.
See:
http://dev.mysql.com/doc/mysql/en/Backup.html
To backup one database to another on the same MySQL instance
you may FLUSH TABLES WITH READ LOCK and use CREATE TABLE ... SELECT ...
to create tables in the second database from tables in the first one.
Don't forget to UNLOCK TAB
Hello.
I don't think that a lot of people can answer on your question.
Windows ME is rarely found to be an OS for MySQL users.
You may report a bug at bugs.mysql.com.
Hassan Shaikh <[EMAIL PROTECTED]> wrote:
> The MySQL Query Browser online documentation clearly mentions that it
> runs on 32-
Hello.
May be you should think about commercial support:
https://order.mysql.com/?ref=ensita
>Dear Sirs,
>
>Our company is developing software for SetTopBox STI 5528. We are interested
>in using your
>DBMS.
>
>Our target platform is STI5528 (SH4 (Hitachi) compliant) platform.
>OS
Hello.
I've submitted a bug:
http://bugs.mysql.com/7137
>Sure enough... I just installed the latest 4.1 linux binaries, I didn't
>realize that the server itself had to be compiled with the debug enabled
>(although now that I realize that it makes complete sense). It woul
Hello
REPAIR QUICK is a recommended method to rebuild FULLTEXT indexes. See:
http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html
Haitao Jiang <[EMAIL PROTECTED]> wrote:
> Hi,
>
> If I remember correctly, if table is ok, then if one does a table
> repair, the command should ret
Hello.
Yes, may be LIKE operator should check the type of column and
remove trailing spaces from the comparsion varchar-string, but in
TEXT columns trailing spaces are allowed.
Thomas Spahni <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> recently I encountered the following problem:
Hello.
Please send the complete output of SHOW CREATE TABLE on all tables, which you
want to put into merged table. You may check if your new merged table is ok by
running queries of your web application in MySQL-Admin.
[EMAIL PROTECTED] wrote:
> Hello!
> I have been struggling with this, and d
Hello.
Put in you [client] section of my.cnf
character_set=latin1
[EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> 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:
>
> #
Hello.
Cardinality of index is updated by running ANALYZE TABLE or
myisamchk -a. See:
http://dev.mysql.com/doc/mysql/en/SHOW_INDEX.html
>I've created a table with several indexes as follows:
>
>$query = "CREATE TABLE `data_raw` (
>id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
>run_id VARCHAR(20)
Hi,
I am building the insert string for inserting into particular table t1
using C program. The below string is stored in a variable.
say sqlstmt = 'INSERT INTo T1 values(:id,:ename);'
The values for the field's id, name will come from the front end. The
sql string will be executed using Pro *C
Hi,
I have problem in using "create trigger" in MySQL 4.1. I had read through the
MySQL manual and found that "create trigger" may not be supported by MySQL 4.1.
Here's the question, how should I do to make MySQL 4.1 to do the same thing as
"create trigger"? Thank you!
Regards,
Alexander Chai
Frank,
- Original Message -
From: ""Frank Denis (Jedi/Sector One)"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, December 13, 2004 12:25 AM
Subject: InnoDB status: why do I see MyISAM requests?
Just curious...
While running SHOW INNODB STATUS, the "list of tran
I am building the insert string for inserting into particular table t1
using C program. The below string is stored in a variable.
say sqlstmt = 'INSERT INTo T1 values(:id,:ename);'
The values for the field's id, name will come from the front end. The
sql string will be executed using Pro *C in O
Hi,
I read Trudy Pelzer's article on Temporal Functionality in MySQL 4.1.
http://dev.mysql.com/tech-resources/articles/4.1/time.html
A few open questions to time zone internals remain:
(1) How are DATETIME and TIMESTAMP columns saved internally? I would
guess, UTC. One could also interpret the 4.1
74 matches
Mail list logo