I have just started noticing some bizarre behaivor in tables in our database that
contain a
TIMESTAMP(14) field.
I only shown a small query, but it highlights the error:
mysql SELECT ErrorTime FROM ErrorLog WHERE ErrorTime = 20031210063712;
++
| ErrorTime |
Hi!
Latin1 is the default as i know.
Let's check:
2.3.3 Typical configure Options
4.7 MySQL Localisation and International Usage
I know this. BUT, when I set def char set = cp1251 and do
CREATE DATABASE lalala
I get new database created in latin1
Is this a bug?
--
MySQL General Mailing
Matthew Boulter [EMAIL PROTECTED] wrote:
I have just started noticing some bizarre behaivor in tables in our =
database that contain a=20
TIMESTAMP(14) field.=20
I only shown a small query, but it highlights the error:
mysql SELECT ErrorTime FROM ErrorLog WHERE ErrorTime =3D =
Hi! Is this a bug?
in my.cnf:
[mysqld-4.1]
skip-locking
default-character-set=cp1251
default_collation=cp1251_general_ci
key_buffer=16M
skip-innodb
skip-bdb
after server start:
show variables like '%character_set%'
character_set_servercp1251
character_set_systemutf8
We just developed and re-wrote applications on PHP from a previous ASP
environment.
The performance improvement from ASP-ODBC-MySQL to PHP-MYSQL ranged
from 20-50% in some cases, so it's pretty normal to expect a much slower
response.
Also sorry to hear about the decision.
Terence
-
Anyone has an idea about this issue?
Thanks in advance!!!
Regards,
Stefan
Stefan Egli wrote:
Hi there,
I'm having problems running two versions of mysql simultaneously on
the same box.
The versions I'm using are:
* mysql 3.23.48
* mysql 4.0.16
What happens:
* I have the 3.23 version up and
Ramesh [EMAIL PROTECTED] wrote:
In mysql 4.014, the below INSERT statement works fine:
INSERT INTO TEST_TABLE SELECT 20, name FROM TEST_TABLE WHERE id = 10
But in mysql 4.1, it fails, I get a message:
Error Code : 1066
Not unique table/alias: 'TEST_TABLE'
(10 ms taken)
Question: Is
Hi,
Is there any site with list of libs I need to link with libmysqld
(linux)? I am currently using libmysqlclient and thisone needs
libpthreads and libz to work fine. If I replace libmysqlclient with
libmysqld, there is lot of symbols linker cannot find.
Thanks,
Mirza
--
MySQL General
Juri Shimon [EMAIL PROTECTED] wrote:
Hi! Is this a bug?
What does 'SHOW CREATE DATABASE database_name;' show for this database?
in my.cnf:
[mysqld-4.1]
skip-locking
default-character-set=cp1251
default_collation=cp1251_general_ci
key_buffer=16M
skip-innodb
skip-bdb
after server
Hello
I am looking to create a sequence to use as a primary key for a table, I
have read about them on the mysql website but can?t seem to get them working.
Do they exist for version 4.1 and if so could someone give me some sample
code. If not is there anyway to automatically generate primary
Hi Noel,
I am looking to create a sequence to use as a primary key for a table, I
have read about them on the mysql website but can?t seem to get them
working.
Do they exist for version 4.1 and if so could someone give me some sample
code. If not is there anyway to automatically generate
--local is a valid option for mysqlimport in 3.23.49 according to the
manual. (Source: http://www.cict.fr/app/mysql/manual.html#mysqlimport)
What is the entire command you are using?
Hi,
My command is:
mysqlimport -p -L ilk gwarancje.txt
And I get error:
mysqlimport: Error: The used
[EMAIL PROTECTED] wrote:
I am looking to create a sequence to use as a primary key for a table, I
have read about them on the mysql website but can?t seem to get them work=
ing.
Do they exist for version 4.1 and if so could someone give me some sampl=
e
code. If not is there anyway to
Hello noel.
Wednesday, December 10, 2003, 5:09:30 PM, you wrote:
nkmdi If not is there anyway to automatically generate primary keys for
nkmdi tables in MySQL.
CREATE TABLE ttt (
id int not null auto_increment primary key,
name varchar(100) not null
);
Please note auto_increment
- Original Message -
From: Juri Shimon [EMAIL PROTECTED]
To: Victoria Reznichenko [EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 12:56 PM
Subject: Re: Bug in 4.1.1 Internationalization on Windows2000 ?
Hi!
What does 'SHOW CREATE DATABASE database_name;' show for this
Bryan Harris [EMAIL PROTECTED] wrote:
I'm pretty new to MySQL, but I already like it. Kudos to the developers!
I recently did a mysqlimport on a few data files, and it came back with over
4000 warnings. How can I actually see what the warnings were? I'm still
not sure what it was upset
Hi!
How I can set server variable character_set_system to cp1251 ?
I can use xxx'char' construction - but I need a downward compatibility.
I can select USER() and parse result on clientside - but I wan't rewrite
existing client apps.
mysql -u root -e select
Hi!
create table t(a enum ('','',''));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
and this is a bug!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi,
create table t(a enum ('','',''));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
and this is a bug!
But a bug in what?
I've created the table with Database Workbench, and when doing
a SHOW CREATE TABLE t; It
Hi!
create table t(a enum ('','',''));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
But a bug in what?
CREATE TABLE `t` (
`a` enum('','','') default NULL
) TYPE=MyISAM
Which sounds fine to me (except
Hi all!
I'm connecting from one server (192.168.0.2; 4.1.1-alpha-log) to another
server (192.168.0.1; 4.1.0-alpha-log) like this:
# mysql -h192.168.0.1 -uusername -ppassword
But all I get is:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 82 to server
Hi!
On Dec 09, Steven Roussey wrote:
Does Mysql 4.1.1 have the two level index system integrated into it for full
text searches?
What do you mean ?
Is it used to optimize searches ? No.
Still there could be some speedup because, e.g, MyISAM will use binary
search in the key pages instead of
On Wed, 10 Dec 2003 15:25:57 +0200
Juri Shimon [EMAIL PROTECTED] wrote:
Hi!
create table t(a enum ('','__','__'));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
firstly, upgrade you
hello,
what about using:
aspx (with c#) - c++ api - mysql (nt) - with win 2003
server (iis 6.0)
the only thing where i'm no sure is the c++ api. can
it be used with c# or will there be a .net framework
version of the api? if this set up is possible i
suspect that it may at least match php-...
Hi!
create table t(a enum ('','',''));
show create table t;
CREATE TABLE `t` (
`a` enum('','???','???') default NULL
) TYPE=MyISAM DEFAULT CHARSET=cp1251
firstly, upgrade you mysql to current stable version (4.0.16).
I need 4.1, not 4.0 8)
and imho you need
i want to ask you a question
i have a data in a table `answer` and i want to copy the data which
have a specific value in a filed and inserted into it again but i
will change the value
i try to use this but it's give me an error
===
INSERT INTO `answer` (
I think, there is an error in your syntax. (i am not sure)
After FROM, what do you want to call as a2 ??
INSERT INTO `answer` ( `answer` , `correct`,`qid` ) SELECT a2.`answer` , a2.`correct`
, 3 FROM `answer` where a2.qid=0
Vaso
-Original Message-
From: [EMAIL PROTECTED]
Len,
You shouldn't post private information to a public mailing list
(never do that!). Please send these type of questions to
[EMAIL PROTECTED] But my guess is you should download and install it
if you have not already done so.
Ken
- Original Message -
From: Len Buchanan [EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I'm having trouble composing the right SQL statement for my purpose:
I am building a search interface to a database with research projects. The
research projects (tbl_projects) have assigned keywords in german and
english, which are in a seperate
Christophe DIARRA [EMAIL PROTECTED] wrote:
First, sorry, if my problem is know or documented. I have made a rapid
search on the MySQL site, but without success.
Here is my problem : the following 'create table' command refuses to
execute on 4.1.1, if -1 is not put between a quottation
Greetings,
Didn't find any fields in table 'blah'
031208 18:15:16 InnoDB error:
Cannot find table db/blah from the internal data dictionary
of InnoDB though the .frm file for the table exists. Maybe you
have deleted and recreated InnoDB data files but have forgotten
to delete the
For everyone - I modify these files:
include/mysql_com.h:#define USERNAME_LENGTH 16
tools/mysqlmanager.c:#define MAX_USER_NAME 16
mysql-test/install_test_db.sh: c_d=$c_d User char(16) DEFAULT ''
NOT NULL,
mysql-test/install_test_db.sh: c_u=$c_u User char(16) binary
DEFAULT '' NOT
Michael Sullivan [EMAIL PROTECTED] wrote:
I'm new to MySQL, so this might be a stupid question/problem, but I
can't figure out the answer: I'm trying to install the Popper webmail
client on my web server. I'm following the instructions exactly. It
told me to log in to the mysql console with
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Hi, can anyone tell me what is the problem of my script:
$sql2 = SELECT * FROM Cash WHERE HP='$HP' and
SignUpDate='$SignUpDate';
$rows1 = mysql_query($sql2,$linkptr1) ;
$OwnnerMail =[EMAIL PROTECTED];
$Subject =
From: Abs [mailto:[EMAIL PROTECTED]
hi
the error is in this line:
$newvalue = $row[Password];
make it
$newvalue.= $row[Password];
(notice ^ the dot - for concatenation with the
previous value).
and if u want to see each password in the browser too,
in that same loop, put:
echo
I'm still having trouble figuring this out. Please help!
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, has_openssl is set to NO. I've got
OpenSSL 0.9.7c installed. I'm seeing this on both Solaris and Debian
hosts. I'm not seeing any errors
Carsten Heidmann wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I'm having trouble composing the right SQL statement for my purpose:
I am building a search interface to a database with research projects. The
research projects (tbl_projects) have assigned keywords in german and
english,
I have a database table that has one row entered every day by the user.
If the user skips a day, it throws off our monthly totals. Assume a
table with four columns:
id (which is the key), date (-mm-dd), data1 (int), data2 (int)
Is there a way to say Select the first missing date in the
Hello All,
I am trying to import data from a text file into MySQL. I am using
phpMyAdmin to control the database. When I try to execute the query I
keep getting this error. Access denied for user: '[EMAIL PROTECTED]'
(Using password: YES)
Can anyone throw some light on this.
Thanks in
Several possibilites:
1) Your password for user 'master2' is wrong;
2) master2 doesn't have the proper GRANT rights to do what you want;
3) master2 doesn't exist.
Check the mySQL manual.
Joshua Thomas
Network Operations Engineer
PowerOne Media, Inc.
tel: 518-687-6143
[EMAIL PROTECTED]
---
In
Hello mysql,
MySQL 4.1.0-alpha-max-nt
phpMyAdmin 2.5.4
/* BEGIN DUMP */
CREATE TABLE `sp_tovar_vid` (
`id` int(11) NOT NULL auto_increment,
`id_tovar_vid` int(11) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
UNIQUE KEY
Thanks Josh,
I wish that were the case.. I am already inside phpMyAdmin and I can
manually edit and add new records. However when I try to add records
from a file I keep getting the same error.
If the user master2 did nto exist or have the required GRANT rights,
then I wud not have been
Good Day All,
Let me attempt to provide some clarity on this issues (though it is
important to note that I am not a lawyer or a judge.)
The fundaments of the GPL are easy to understand.
The GPL operates within standard copyright law.
Under copyright law[0], the copyright holder has a bundle of
I'm running 4.0.16 on a dual-Opteron using the 64bit mysql-max binary
distribution (tar.gz, not rpm) from mysql.com. I have 8GB of RAM, and
it was using about 4.5GB at the time of the crash.
031210 9:24:34 InnoDB: Assertion failure in thread 1171265904 in file
row0upd.c line 713
InnoDB:
If the user master2 did nto exist or have the required GRANT rights,
then I wud not have been able to get into the database itslef in the first
place. Thanks again though. Any ideas ?
If you read the GRANT section of the mySQL manual
(http://www.mysql.com/doc/en/GRANT.html) you'll see that you
The following is a transaction from MySQL:
smysql show tables;
Empty set (0.00 sec)
mysql CREATE TABLE Userlist (
- UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY,
- Status VARCHAR(1) NOT NULL,
- EmailAddress VARCHAR(64) NOT NULL,
- Password VARCHAR(32)
Mayuran Yogarajah wrote:
The following is a transaction from MySQL:
smysql show tables;
Empty set (0.00 sec)
mysql CREATE TABLE Userlist (
- UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY,
- Status VARCHAR(1) NOT NULL,
- EmailAddress VARCHAR(64) NOT NULL,
-
Michael Sullivan wrote:
I'm new to MySQL, so this might be a stupid question/problem, but I
can't figure out the answer: I'm trying to install the Popper webmail
client on my web server. I'm following the instructions exactly. It
told me to log in to the mysql console with mysql -u root -p
Mayuran Yogarajah wrote:
Mayuran Yogarajah wrote:
The following is a transaction from MySQL:
smysql show tables;
Empty set (0.00 sec)
mysql CREATE TABLE Userlist (
- UserID MEDIUMINT UNSIGNED NOT NULL PRIMARY KEY,
- Status VARCHAR(1) NOT NULL,
- EmailAddress
Michael Sullivan wrote:
I'm new to MySQL, so this might be a stupid question/problem, but I
can't figure out the answer: I'm trying to install the Popper webmail
client on my web server. I'm following the instructions exactly. It
told me to log in to the mysql console with mysql -u root -p
Environment is MySQL 3.23.33, PHP Version 4.3.2.
Have included a couple of extra columns here in an attempt to clarify what
I am trying to do. In the table rid is a unique, auto-increment. The fields
date_created and date_updated are datetime format mmdd hh:mm:ss.
Passing a begining and
You really need to look at your DW installation/user manual/tutorial: how to
set up a site within DW and how to configure a db resource. The mySQL part
as such seems to work ok, but I doubt there are any db connections defined
yet (ODBC or JDBC). If this is new stuff to you take the ODBC route,
Hello,
Just a quickie. Does anyone know if issueing an ALTER TABLE t ORDER BY c
is as good as an OPTIMIZE TABLE if I know the order I'll mostly be
sorting with? Does the ALTER TABLE operation reclaimed deleted rows,
for example? Or should I OPTIMIZE and then ALTER?
Cheers :)
--
Chris
--
I am trying to get version 4 up and running on Alpha VMS 7.3-1.
I got the process running but every time I try to run admin or mysql against
it is say it can not connect to it
I get this error
ALPHA1::VMS mysql -u user -p
Enter password:
ERROR 2005: Unknown MySQL Server Host
Not sure if this is a MyODBC error or one in my code. I have code
that
inserts/updates records based on information from Lotus Notes
documents. The columns to be inserted/updated are defined statically
in the code so there's no way it's changing from one document to the
next. As the code runs, it
You might want to talk to a real Mysql sales rep person and request a
new license number. You really don't want to be posting info like that
on a public forum!
Best of luck and Happy Holidays
Jacqueline Shaughnessy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi All,
Is there an ETA for MySQL 4.1 Beta release?
Thanks,
Puny Sen
Hi all,
I am following the lessons in Sams Teach Yourself SQL in 10 Minutes
using MySQL as the databse app. I am having some trouble with Lesson 7:
Creating Calculated Fields where you are suppose to concatenate several
fields.
The Input looks like this:
SELECT vend_city+', '+vend_state+'
SELECT vend_city+', '+vend_state+' '+vend_zip
FROM Vendors
ORDER BY vend_name;
SELECT
CONCAT( vend_city, ', ', vend_state, ' ', vend_zip )
FROM
Vendors
ORDER BY
vend_name
The solution is to concatenate the three columns. In SQL SELECT
statements, you can concatenate columns using a
you can use the concat function:
http://www.mysql.com/doc/en/String_functions.html
SELECT concat(vend_city,', ',vend_state,' ',vend_zip)
FROM Vendors
ORDER BY vend_name;
-Original Message-
From: Gilbert Wilson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 2:42 PM
Puny,
- Original Message -
From: Puny Sen [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, December 10, 2003 10:00 PM
Subject: MySQL 4.1 Beta Release
--Boundary_(ID_9gZ0fPFbGnkpio2LXXaaOA)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding:
Don,
it is the assertion below which fails.
Do you use FOREIGN KEY ON UPDATE CASCADE?
Do you have any idea which query causes the crash?
Please run CHECK TABLE on suspicious tables.
Can you test on an x86 computer?
Have you changed the default character set of the server in my.cnf?
Can
mysql, query
I have a situation come up where we want one slave to act
as backup for two different databases located in two
different hosts. Can this be done?
The master setup is easy. The slave setup is unclear.
Can I have two sets of master-host, master-user, and
master-password,
If you want to change the value in qid to 3 when it is 0
You really need an update
update answer
setqid = 3
where qid = 0
-Original Message-
From: ÇÈæ ÇÈÑÇåíã [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 10, 2003 8:14 AM
To: [EMAIL PROTECTED]
Subject: copy from table to
Hello
I try in my program to make a lock.
I try to prevent another session to read and write from the whole table
I tried both
LOCK TABLES pstockx WRITE
and
LOCK TABLES pstockx READ
but no success.
I put in a breakpoint in my program to be sure the lock are held
and then I try to make a
Hi
U lucky man ,,, I can't make my locks work at all :(
BUT
just a little hint , u sure it not ur _ (underscore) in table name which
is a kind of wildcard that give u trouble ??
regards
Kim Pedersen
Fella's,
First of all I'd like to welcome myself to this list. Have been here
before,
I was wonder if anyone here could comment on when prepared statements
might be available in the embedded server, I would find it very
helpful. Will they be in the 4.1 release? Are there plans to add
support in some future release?
Thanks,
Richard Tibbetts
--
MySQL General Mailing List
For list
Hi there, i was wondering when a possible release of 4.1 will happen ? I
can see its in Alpha still, but i am trying to instigate across the board
server upgrades, so its best to wait until then. Please let me know.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hi Heikki,
Heikki Tuuri wrote:
Don,
it is the assertion below which fails.
Do you use FOREIGN KEY ON UPDATE CASCADE?
Nope.
Do you have any idea which query causes the crash?
I didn't, but after Googling for similar problems, I found a thread
where you had talked about a bug in a
What has to be done to mysql to allow for the insertion and extraction of
Japanese and Korean characters? ( I will not be searching by them only
displaying and saving them.) Do I only have to have the set the characater
set in the table declaration or is there more to it? Also does the newest
On Thu, Dec 04, 2003 at 10:33:17AM -0500, Brent Baisley wrote:
Actually, you want to try to match the stripe size to your data size.
The ideal would be to have a stripe size equal to the size of a record
in your database. This way the disk needs only one read or write for
each database
Greetings..
Is their a way to list a time breakdown of a select? Amount of
query waiting on disk-io, in memory, etc...
I have tried the debug-info option with mysql client but it lists several
memory settings. I have a 1.2 ultra-sparcIII that is twice as slow as a
xeon 2.4
MySQL AB is please to announce that the Call for Papers for the 2004
MySQL User Conference is now officially open.
We encourage every MySQL user with something to say - from grey-bearded
hackers and peach-fuzzed power users to corporate code wranglers and
veteran DBAs - to drop by
Kim G. Pedersen wrote:
BUT
just a little hint , u sure it not ur _ (underscore) in table name which
is a kind of wildcard that give u trouble ??
This raises an interesting question. I wrote earlier about troubles with
mismatch field count and missing field errors. I have both tables and
Hello,
When I try and unzip the linux pc binary download file
mysql-standard-4.0.16-pc-linux-i686.tar
I get no further than the first four files before getting this error.
I tried a couple of mirrors with the same result.
ejd
I don't understand why MySQL will create a copy of the table when I'm
adding an index to it.
Example:
Alter Table Tablex Add Index NewIndex (col1,col2);
ProcessList will show copy to tmp table for 99% of the process.
This will physically copy the data to a temporary table. I have a 7gb table
Hi All,
I'd like to use the same column to store content from multiple languages
(English, German, French, Japanese).
Here is my understanding of the options available.
In MySQL 4.0:
- UTF-8 is not currently available as a charset
- we can connect to the database using
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greg G wrote:
I'm still having trouble figuring this out. Please help!
I compiled MySQL 4.1.1 --with-openssl --with-vio and when I look at the
variables with mysqladmin, has_openssl is set to NO. I've got
OpenSSL 0.9.7c installed. I'm seeing
Randy Chrismon wrote:
Kim G. Pedersen wrote:
BUT
just a little hint , u sure it not ur _ (underscore) in table name
which
is a kind of wildcard that give u trouble ??
This raises an interesting question. I wrote earlier about troubles
with mismatch field count and missing field errors. I
At 09:07 PM 12/10/2003, you wrote:
Hi There,
The data needs to be sorted into the key you specified. Any RDBMS does
this type of operation. Some don;t copy the whole table though, just the
columns you are indexing
Cheers
Chris
Chris,
Ok, I see your point. Some of the other
80 matches
Mail list logo
