The best method will be to adda TIMESTAMP.
But if you are sure that no record gets DELETEd you may use the following
procedure.
CREATE a temporary Table to store the records you want to use. That temp
table needs to have a key or ID.
SELECT from that temp table and order using that ID.
But I
At 15:58 +1000 20-10-2003, Kim Kohen wrote:
Hello all
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
replace this with
I don't know I well understand your problem.
There is a function SESSION_USER() in MySQL that returns the currently
connected user. The user string also returns the host from which he
connected in the form [EMAIL PROTECTED]
So, by issuing the query:
SELECT SESSION_USER(), Table.* from Table
Alexander K?ppe [EMAIL PROTECTED] wrote:
Hi,
I have trouble to connect from a remote host to the mysql-server.
On localhost works all right.
But when I want to establish a connection with
pre
mysql --host=server --user=com75778 --database=com75778 --pass
Enter password:
ERROR 2013: Lost
show statusHi all,
I am running MySQL version 4.0.14-standard-log on Suse Linux 2.4.20 i686.
All tables in my db are InnoDB tables.
Today morning I've got troubles with perfomance...
Generally all queries are slower in 4-5 times than usually.
Also I see that number of deadlocks is in 10-15
On Sun, 19 Oct 2003 22:08:30 -0400, Kelley Lingerfelt
[EMAIL PROTECTED] wrote:
WHERE lookup RLIKE this|that|other|^starts like this|ends like this$|it
contains.*something.*like.*this
I am not yet expert enough in mySQL to even specify my question
accurately (so I will have another go)
In
[EMAIL PROTECTED] wrote:
I recently downloaded MySQL v3.23 on my Windows 2000 laptop. When I try to
create a database at the mysql prompt, I get the message Error 1044:
Access denied for user '@localhost' to database xx. I originally
assigned a username and password when I first ran the
Hi again,
as there was not a single answer to my question I can imagine that no one
encountered the same issue, but anyways, can there be any hints? First of
all, are there any means of looking at mysql memory allocation list
grouped by some major parts - for example,
innodb main pool - can be
Hi again,
as there was not a single answer to my question I can imagine that no one
encountered the same issue, but anyways, can there be any hints? First of
all, are there any means of looking at mysql memory allocation list
grouped by some major parts - for example,
innodb main pool - can be
Hi again,
as there was not a single answer to my question I can imagine that no one
encountered the same issue, but anyways, can there be any hints? First of
all, are there any means of looking at mysql memory allocation list
grouped by some major parts - for example,
innodb main pool - can be
Hi again,
as there was not a single answer to my question I can imagine that no one
encountered the same issue, but anyways, can there be any hints? First of
all, are there any means of looking at mysql memory allocation list
grouped by some major parts - for example,
innodb main pool - can be
Add the -p option to tell mySQL to ask for a password.
For example
c:\mysql\bin\mysql -u root -p
Or if you want to give the password without a prompt
c:\mysql\bin\mysql -u root -p YourPassWord
Or if you are connecting on another Server
c:\mysql\bin\mysql -u root -h RemoteServerAddress -p
Hope
Hi,
Im currently using mysql 4.0.15
what could i do in the my.cnf to make it work better faster :)
i use innodb
and its a linux box with kernel 2.4.23_pre
and its got xfs on it and its got a gig of ram as well as 2x 2.6ghz
hyperthreading xeons
P
--
MySQL General Mailing List
For list
Hi again,
as there was not a single answer to my question I can imagine that no one
encountered the same issue, but anyways, can there be any hints? First of
all, are there any means of looking at mysql memory allocation list
grouped by some major parts - for example,
innodb main pool - can be
Hi again,
as there was not a single answer to my question I can imagine that no one
encountered the same issue, but anyways, can there be any hints? First of
all, are there any means of looking at mysql memory allocation list
grouped by some major parts - for example,
innodb main pool - can be
I'm very sorry for the duplicated posts, my mail softtware behaved wrong
:(
---
Alex
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I've been given a table to work with, and I'm not
meant to change it:
-
| TABLE_NAME| TBL_IDX | KEYW_ID |
-
| PROPERTIES| 108 | 16 |
-
| PROPERTIES| 119 | 16
Hello!
I hope someone can help us with a problem we have:
We had a table that was 35G big and the index file was about 16G (ca 120
million records). We ran into a problem where the database produced an no
more room in index file error.
To fix this we regenerated the table and set max_rows to
-Original Message-
From: Mumba Chucks [mailto:[EMAIL PROTECTED]
I've been given a table to work with, and I'm not
meant to change it:
-
| TABLE_NAME | TBL_IDX | KEYW_ID |
-
| PROPERTIES | 108 | 16
Forgot to mention...
OS is not swapping... The load on MySQL server is the same...
Usually my system has ~100 selects/sec and 0.2 inserts/sec.
And I found that during inserts MySQL uses 100% of CPU,
before it used ~5-10% CPU maximum...
I understand that it's difficult to say what is going
Hi,
We have given up trying to understand why the problem (please see below)
occurs, and have moved on to see what will be the best workaround. We have
three different suggestions. Alternatives 1 and 2 below are under the
assumption that setting the max_rows parameter to 10.000.000.000 caused the
Robert,
If I follow you're email correctly, it looks like you attempting to assign a
password to the root user twice. The first statement you provide:
bin/mysqladmin -u root password **
Sets the password to whatever value you've set in-place of **. Then in
the statement below you
* zhu xiaofeng
Sent: Thursday, October 09, 2003 4:45 AM
An old question, but no replies...
There is a question:
Two tables:
table_out: ( fields ) product_name,out_count , out_date
table_in: ( fields ) product_name,in_count , in_date
I want to create a
Hi all
I'm working on a book database with some special requirements. Each book is associated
with some keywords and put into a category. Category 0 is special, as this is
Unsorted, i.e. not associated with a category (which most books are at the moment).
For thei query, let's simplify the
Hess Yvan [EMAIL PROTECTED] wrote:
I am doing a lot of inserts, updates and reads with big among of data into
longtext and longblob fields using JDBC driver and mysql 4.0.15 for Windows
with innodb tables.
After 1 hours of intensive working the database sent me a message Lock wait
timeout
Hi everybody,
we are trying to transfer Agilent Vee measuring data to MySQL. To my
knowledge programming an active-x component would be a useful way, but
probably somebody has an alternative approach, experience or a program for
the subject.
Recent tries were just partially successful, the
You need to grant privileges to 'root'@'127.0.0.1' because it is not the
same thing
as 'root'@'localhost'.
Timotius Alfa wrote:
Pls help me, I want to know if this connection string can be used for multi user, coz when I change Server=localhost with server=127.0.0.1 it can not work. thanks
Thanks Emery,
That is exactly what I needed, it gives me back the IP of the machine I'm
connecting from.
This is going to allow me to remove so much machine specific code that we
could put up a new server within mins if needed.
Thanks Again
-Chris
- Original Message -
From: Director
as I know in HP-VEE program you can export the data in a text file. in MySQL
you can read a text file by LOAD DATA INFILE command. this helps you to keep
the data in MySQL database without activeX programming.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
* Reto Baumann
I'm working on a book database with some special requirements.
Each book is associated with some keywords and put into a
category. Category 0 is special, as this is Unsorted, i.e. not
associated with a category (which most books are at the moment).
For thei query, let's
You are welcome.
But remember that sometimes it truncates the name.
For example I sometimes connect from my laptop using nzeyimana as username
and it just returns [EMAIL PROTECTED] instead of returning
[EMAIL PROTECTED]
(it just removes the last P).
I don't know why. Maybe someone on the list
I sent this out on last friday but I never actually saw it post to the list so maybe I
messed up the address. If this is showing up a second time, sorry.
I have a database where I want to count the number of days where a field gets to a
certain value. I am using two seperate queries to count
by 4 bytes number (as 1 field) , you can keep 32 bits (criteria). this shows
how much you can save the space. but if the database is not huge, it's
better to select simpler solution (one field for one criteria). this is an
example in MySQL manual to show how to work with bits:
The following shows
Kim Kohen [EMAIL PROTECTED] wrote:
I have a bit of a problem with some characters I'm loading from a Filemaker
Pro database. The single quotes are stored in MySQL as ASCII character 155
(an 'O' with a tilde over it). I have tried everything I can think of to
replace this with the PHP I use
In the data directory for MySQL, you should find a file titled
hostname.err. What is the contents of that file?
-Original Message-
From: Hamid Nouri [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 18, 2003 5:07 PM
To: [EMAIL PROTECTED]
Subject: I can't start mysqld
Hi there
I have
That is good to know Emery..
I think I'll be ok in that respects, I did the permissions so the granted
host is by IP (ex 192.168.0.%), so I'm getting IP back and I'm using the
same username for all and its not truncated - so I think I'm good to go!!
I just my first test on my dev server and
Hi,
I do the following:
somequery ... WHERE CONCAT(anumber, aname) LIKE '12SomeString'
As explained in the manual this is treated as a BINARY comparison i.e.
case of the letters matter. I need a case independent comparison here. Is
there a way to get the usual behaviour of LIKE in this case?
Hi Franz,
Check out
MAX_ROWS = #
and
AVG_ROW_LENGTH = #
options in http://www.mysql.com/doc/en/CREATE_TABLE.html
Set MAX_ROWS to a very very large number
You can set these with ALTER TABLE. See section 6.5.4 ALTER TABLE
Syntax using table options at the end. Use the MAX_ROWS
parameter and set
I cannot start the MySQl Server. I am running Windows XP. I checked the error file
and get the following message.
031020 10:11:56 InnoDB: Started
031020 10:11:56 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't
exist
031020 10:11:56 Aborting
What do I need to do for
CONCAT turns every this in to a string then puts them together?
LIKE is not case sensitive with string?
When is this turned in to BINARY?
What have I missed please
Simon
-Original Message-
From: Thomas Spahni [mailto:[EMAIL PROTECTED]
Sent: 20 October 2003 15:38
To: [EMAIL PROTECTED]
FYI,
If you only want the hostname, and not the user,
combine the USER() with a SUBSTRING_INDEX():
SUBSTRING_INDEX(USER(),'@',-1) -- returns host only
SUBSTRING_INDEX(USER(),'@',1) -- returns username
only
USER(), SESSION_USER(), and SYSTEM_USER() are all
synonymous
CURRENT_USER() however is
On UNIX you need to run a creat datbase using scripts/mysql_install_db
Simon
-Original Message-
From: Larry Wasserman [mailto:[EMAIL PROTECTED]
Sent: 20 October 2003 16:30
To: [EMAIL PROTECTED]
Subject: Starting the mySQL Server
I cannot start the MySQl Server. I am running Windows
That is one of the tables in MySQL database (for privileges and other server
stuffs).
It is located in
MySQL DATA ---mysql ---
MySQL data is the directory containing all data.
On windows systems that is normally c:\mysql\data
So the table file should be in c:\mysql\data\mysql
Thanks
Emery
Fortuno, Adam wrote:
If I follow you're email correctly, it looks like you attempting to assign a
password to the root user twice. The first statement you provide:
bin/mysqladmin -u root password **
Sets the password to whatever value you've set in-place of **. Then in
the
The trouble with this is it returns 1. It seems to pick the max value for the year
instead of by day.
--ja
On Mon, 20 Oct 2003, Franz, Fa. PostDirekt MA wrote:
Hi,
maybe I didn't understand the question wrong.
I have tried to work in the MAX(aqiNumber) into the query but I get a
Simon
you missed this from the manual:
quote
If you want to convert a number to a string explicitly, pass it as the
argument to `CONCAT()'.
If a string function is given a binary string as an argument, the
resulting string is also a binary string. A number converted to a
string is treated as a
Robert,
I also think the read me is a little vague. I see what they're getting at
but I don't understand why it was phrased that way.
When you think about it, the error message makes sense. When you do any
command through mysqladmin your authenticating to MySQL then executing the
command. You
I seem to be unable to get this list in digest format :(
I previously signed up for normal version. I have tried unsubscribing and
re-subscribing with
Digest - MIME instead and I keep getting the normal list (individual e-mails
for every post!)
Thanks for any help!
--
MySQL General Mailing
On Windows machines you do not need to init the mysql
db as it is pre-initialized. But, if you installed
MySQL a directory other than C:\mysql there is
additional work that has to be done. You have to
create either a C:\my.cnf OR
windows-system-dir\my.ini file with the following
settings (example
Whenever you use the Max() function on a column while accessing other
columns at the same time you need a GROUP BY statement so that the MAX()
function knows how to group it's results.
I suggest you look into the manual for this. In fact it has a tutorial
showing you options on how to do exactly
Hello Mumba, Hello Barry,
How do I select out and filter only rows that match
both 16 and 62 in the KEYW_ID col? IE. The query
would return only 119 and 108?
I'm sure this could be done more effeciently other ways, possibly with
a sub select if available, but something like this
Hi Group,
Can anyone tell me which data modelling software is good for the mysql database?
Thanks
Hardik
-
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
hi guys,
i've just finished implementing replication on 2 production servers.
i'm using round robin dns to balance the load between the slave the master.
as you would presume , the master handle all the updates, and 1/2 of the
selects , the slave handle the other 1/2 of the selects.
the
Hi Group,
Can anyone tell me the best software for data modelling? I want to draw the ER diagram
for the new system as well as existing system.
Thanks
Hardik
-
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
Webyog has released SQLyog 3.61 - which includes
SQLyog Job Agent ( SJA ) that enables Zero Install
MySQL Data Synchronization.
SJA is a high-performance, multithreaded, multi
platform application to automate and schedule
Synchronization of Data between two MySQL hosts. On
Windows, it is
Hi all!
Just wanted to know how do I create a table with two primary keys.
Thanks a lot!
Dear reader,
We're looking for beta-testers for a product called
Database Workbench. It's a cross-database developer
tool, currently supporting the database engines
Borland InterBase, Firebird and Microsoft SQL Server.
As we're expanding the product, we're adding MySQL
support.
For this
Hi Carlos,
You can't have 2 primary keys. A table can only have
one primary key. You can, however, also define a
Unique key, and if you set it up such that it is not
null, it will act much like a prmary key:
CREATE TABLE test
( id1 INT UNSIGNED NOT NULL,
PRIMARY KEY (id1),
id2 INT
BTW Carlos,
I'm not sure why you would want or need two primary
keys in a table, but if find you truly do (as opposed
to a PK and some other unique index/key) - there is
probably something wrong with your database design.
You may need to rethink your design. Do some research
and reading on the
Good points Patrick. Thanks for the follow-up :-)
--- Patrick Shoaf [EMAIL PROTECTED] wrote:
-
Mark is correct, you can define only 1 Primary Key,
but the primary keycan be made up of multiple fields.
Example:
CREATE TABLE test (item_code char(5) NOT
That's just what I wanted to do.
1 primary key made up with multiple fields. In my case I will be a Date
Field for Transaction Date and a Integer field for StoreNumber.
Thanks a lot for your advice, guys.
:oD
-Original Message-
From: Mark V [mailto:[EMAIL PROTECTED]
Sent: Monday,
Thanks to you both for your assistance!
--- [EMAIL PROTECTED] wrote:
Hi
- Original Message -
From: Matt W [EMAIL PROTECTED]
To: Jim Mathews [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Saturday, October 18, 2003 10:18 PM
Subject: Re: Pronunciation of ISAM table name
Hi Jim,
Alex,
in FreeBSD user process memory space is often restricted to 512 MB. You have
to reconfigure or recompile the FreeBSD kernel to increase that limit.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup -
Martijn,
are you now aware that MySQL supports transactions and foreign key
constraints? In January you still claimed the contrary in an InterBase
newsgroup.
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot
Hi, everyone
I am new to MYSQL. I got a question in using UDF. Each time I have modified my
UDF function, the MySQL server restart itself automatically. I don't know if
it should be like this or I must do something wrong.
It happened like below:
1) I midify my UDF function and add it to the
Greetings. Can anyone tell me what type of encryption is used when sending
mysql username/password through ODBC. I see that the data and username are
plaintext.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Actually i installed erwin but it doesn't support mysql database directly. How do you
handle it with mysql?
Thanks for your reply.
Fortuno, Adam [EMAIL PROTECTED] wrote:
I like Erwin.
-Original Message-
From: Hardik Doshi [mailto:[EMAIL PROTECTED]
Sent: Monday, October 20, 2003 12:42
The absolute best modeling software I've seen for MySQL (and runner up
for the best modeling software I've ever used) is DBDesigner.
(http://www.fabforce.net/) It's open source, cross platform and very good.
There are a few quirks in it (mainly when editing the fields of a table,
sometimes
I'd like to use the _rowid capability of MySQL to improve the efficiency of a project,
but I have concerns about the reliability of the number it returns. I understand that
_rowid may change over time depending on many factors, but I'd like to know whether
this is true if the row is locked.
You can change your query to something like:
somequery ... WHERE CONCAT(CAST(anumber as CHAR), aname) LIKE
'12SomeString'
Using the CAST function seems to trick CONCAT into thinking that it
only received CHARs.
Not that elegant but it might be a little more efficient that using
LOWER() or
Hello
Having trouble inserting images into a BLOB column. No problems doing
this 'one at a time' via
a third party MySQL GUI Manager, but I need to create an indexed table
containing some
1K + images. Using the recommeded method from the MySQL manaual ie.
UPDATE tbl_name
SET
Checkout http://php.dreamwerx.net/forums/viewtopic.php?t=6
For a PHP example you could easily convert to PERL or just install PHP
standalone binary on the box.
On Fri, 3 Oct 2003, Zafar wrote:
Hello
Having trouble inserting images into a BLOB column. No problems doing
this 'one at a time'
* Guy Smith
I'd like to use the _rowid capability of MySQL to improve the
efficiency of a project, but I have concerns about the
reliability of the number it returns. I understand that _rowid
may change over time depending on many factors, but I'd like to
know whether this is true if the row
Is there a way to have a common C API for MySQL and Oracle. I am writing
some software that I would like to work with both MYSQL or Oracle as the
backend server?
priyanka
_
Enjoy MSN 8 patented spam control and more with MSN 8
Hallo everybody,
can everybody help me, as i would like to save
extention (*.bmp.jpg) on mysql, which i use type data
?
Thank for this help
__
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
MySQL General
At 20:14 -0400 10/20/03, Priyanka Gupta wrote:
Is there a way to have a common C API for MySQL and Oracle. I am
writing some software that I would like to work with both MYSQL or
Oracle as the backend server?
The C API for MySQL is specific only to MySQL. You'd have to write your
own
76 matches
Mail list logo