Daniel,
see the online manual at http://www.innodb.com
It contains a list of Windows and Linux operating system error codes.
Error 3 in Windows means
3 The system cannot find the path specified. ERROR_PATH_NOT_FOUND
Check that the directory path
c:\mysql\data\ibdata
exists.
Regards,
SHAM SUNDAR writes:
When i cannect from my java program i use to get
error General Error: 22.Can u pls help in this.My
mysql version is 3.23.46
perror 22 will tell you that error 22 is 'Invalid argument',
but since you don't state what you're trying to do that is
of little help. Maybe if
Hi all.
How to build index with some function like year() instead of use the whole
column type date.
because I don't need to use the whole lenght (10 bytes) for index but I want
to tuo use only year (first 4 bytes) for index key when I try
ALTER TABLE xxx ADD INDEX yyy (year(BDATE)) error
Hi,
In alot of cases you can use the following query structure (extract from
MySQL 4.0.0alpha manual)to negotiate the need for Sub-Selects.
I hope this helps.
-Rich
1.4.4.1 Sub-selects
MySQL currently only supports sub selects of the form INSERT ... SELECT ...
and REPLACE ... SELECT
I have a big file full of ANSI SQL and a I want a script to be able to
tell Mysql to read this ANSI SQL file every few days because it updates
from a third party in ANSI SQL. I wish to avoid running a little parser
that just passes the SQL to the Perl-DBI module query methods, if I
could just
I can't get this JOIN to work in my SQL-QUERY as it is supposed to!
Could someone check the syntax to se if I missed something?
SELECT students.pnr, students.firstname, students.lastname, students.email,=
=20
students.grupp, students.info, students.lastmod AS lastmod,=20
grupper.courseID,
./mysql -uuser -ppassword database script.sql
might just do that! :-)
- Original Message -
From: Curtis Spencer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 21, 2001 11:56 AM
Subject: Executing a \. or source function from an API
I have a big file full of ANSI SQL
Im's sending this to the list, since I got it in a private
mail and I don't see myself as a substitute for the combined
wisdom, knowledge, and willingness to help that is the MySQL
mailing list.
SHAM SUNDAR writes:
I won't do sql operations using JDBC like insert,delete,select and update.When
Rory,
Take a look at the shell scripts for mysqlbackup here
http://www.ocsny.com/main/index.ocs?url=mysqlbackup It will explain
things quite nicely.
Cheers,
m!
ROry O'Connor wrote:
this is an absolute newbie question - but when i try to run mysqldump with a cron
(like with a shell
Colin Faber writes:
Description:
When attempting to select a result set by subtracting the value
of an unsigned INT column against UNIX_TIMESTAMP() the result set
is invalid.
How-To-Repeat:
Test case:
[skip]
Thank you for your bug report.
I have been able to
hi,
my platform is red hat 6.2.
the rpm packages of mysql are:
mysqlclent9-3.23.22-4
php-mysql-4.0.4pl1-9
mysql-3.23.36-1
mysql-devel-3.23.36-1
mysql-server-3.23.36-1
I can start mysql_install_db.
But I can not start safe_mysqld. The message is, that the file
mysql.sock is not fond.
And that
Hi!
Colin == Colin Faber [EMAIL PROTECTED] writes:
Description:
Colin When attempting to select a result set by subtracting the value
Colin of an unsigned INT column against UNIX_TIMESTAMP() the result set
Colin is invalid.
How-To-Repeat:
Colin Test case:
mysql create table t (ts int
Hy there,
I would like to know if there is a possibility to get all allowed values
of an enum field out of the database.
I know there are methods to get the field type and those give me back
something like enum('value1', 'value2', 'value3'), and I can parse my
possible values out of this with
Hy there,
I would like to know if there is a possibility to get all allowed values
of an enum field out of the database.
I know there are methods to get the field type and those give me back
something like enum('value1', 'value2', 'value3'), and I can parse my
possible values out of this
Using the IN or BETWEEN operator and index
values on an ENUM column fails:
CREATE TABLE test (c enum ('one', 'two'));
INSERT INTO test VALUES (1), (2);
SELECT * FROM test WHERE c='one' OR c='two';
-- works, returns both rows
SELECT * FROM test WHERE c=1 OR c=2;
-- works, returns both rows
Am 21 Dec 2001 15:57:13 +0100 schrieb Carsten H. Pedersen:
I would like to know if there is a possibility to get all allowed
values
of an enum field out of the database.
I know there are methods to get the field type and those give me back
something like enum('value1', 'value2',
On 21 Dec 2001, at 15:57, Carsten H. Pedersen wrote:
SELECT DISTINCT enum_col FROM tablename WHERE enum_col256;
But that's only if you have at least one record representing each
possible value, right? It wouldn't work on an empty table, for
example.
By the way, what's the purpose of the
Henning Sprang wrote:
Am 21 Dec 2001 15:57:13 +0100 schrieb Carsten H. Pedersen:
I would like to know if there is a possibility to get all allowed
values
of an enum field out of the database.
I know there are methods to get the field type and those give me back
something like
At 3:35 PM +0100 12/21/01, Henning Sprang wrote:
Hy there,
I would like to know if there is a possibility to get all allowed values
of an enum field out of the database.
I know there are methods to get the field type and those give me back
something like enum('value1', 'value2', 'value3'), and I
Thanks very much for sharing this, Paul. I got a couple other ideas from it, too. :
Regards,
/Rob
At 09:40 -0600 2001/12/21, Paul DuBois wrote:
Here's an example in Perl.
It actually gets more than the list of values, and it works for
SET columns, too.
# Take a database connection, a table
I have this table:
CREATE TABLE texts (
textid mediumint(9) NOT NULL auto_increment,
languageid char(2) NOT NULL default 'da',
textkey varchar(32) NOT NULL default '',
textvalue text NOT NULL,
PRIMARY KEY (textid),
)
It could contain these data:
(textid,languageid,textkey,textvalue)
You may try this and see if it works (didn't test it, just jotted it down
here):
select t1.textid, t1.textid, t1.textvalue
from texts as t1, texts as t2
where
(t1.languageid='$Primlanguage' and t1.textid=t2.textid) or
(t1.textid=t2.textid and t2.languageid='$Seclanguage' and
This may be of interest to newbies that would like a point-and-click
method of building their web database tables, queries, forms, and reports in
MySQL.
http://webdatapro.com
Description:
Easily create relational database solutions online, requires no
programming or SQL knowledge.
Provides the
I have a mysql table (MySAM), a field in there is set
to unique, however the field does not seem to
recognise the difference between certain ascii
characters, for example it things that
multimedia and multimèdia are the same (I hope it is
shown correctly) but basically it dos not recognise
On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon
Kendrick [EMAIL PROTECTED] wrote:
| I have a mysql table (MySAM), a field in there is set
| to unique, however the field does not seem to
| recognise the difference between certain ascii
| characters, for example it things that
|
| multimedia
* Mats Lindblad
I can't get this JOIN to work in my SQL-QUERY as it is supposed to!
Could someone check the syntax to se if I missed something?
SELECT students.pnr, students.firstname, students.lastname,
students.email,=
=20
students.grupp, students.info, students.lastmod AS lastmod,=20
The problem is that I dont want it case sensitive, but
I do want it to distinguish special characters, any
more ideas?
Thanks
Shannon
--- Michael Brunson [EMAIL PROTECTED] wrote:
On Fri, 21 Dec 2001 11:07:27 -0800 (PST), Shannon
Kendrick [EMAIL PROTECTED] wrote:
| I have a mysql table
The following is a boiled down version of what I want to provide. I'd
appreciate any ideas. I believe views would be idea, but as mysql
doesn't have views I'm looking for a work-around.
I have a table that consists of an id and a text field like so:
ID TEXT
2 sample
The problem is that I dont want it case sensitive, but
I do want it to distinguish special characters, any
more ideas?
You can't do this without a recompilation of MySQL.
The manual sec. 4.6.3 - Adding a New Character Set
gives a thorough explanation on how to go about it.
/ Carsten
--
Michael Widenius wrote:
Hi!
Colin == Colin Faber [EMAIL PROTECTED] writes:
Description:
Colin When attempting to select a result set by subtracting the value
Colin of an unsigned INT column against UNIX_TIMESTAMP() the result set
Colin is invalid.
How-To-Repeat:
Colin
Does anyone know of a way to lock at the row level
instead of table level using MySQL 3.23.46
Thanks
Shannon
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
Shannon Kendrick writes:
Does anyone know of a way to lock at the row level
instead of table level using MySQL 3.23.46
Yep, use InnoDB instead of MyISAM tables.
//C - person of few words. But surprisingly seldom.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL
Whats the drawback of using InnoDB instead of MySAM
tables?
--- Carl Troein [EMAIL PROTECTED] wrote:
Shannon Kendrick writes:
Does anyone know of a way to lock at the row level
instead of table level using MySQL 3.23.46
Yep, use InnoDB instead of MyISAM tables.
//C - person of few
Whats the drawback of using InnoDB instead of MySAM
tables?
--- Carl Troein [EMAIL PROTECTED] wrote:
Shannon Kendrick writes:
Does anyone know of a way to lock at the row level
instead of table level using MySQL 3.23.46
Yep, use InnoDB instead of MyISAM tables.
//C - person of few
On Fri, Dec 21, 2001 at 12:45:16PM -0800, Shannon Kendrick wrote:
: Whats the drawback of using InnoDB instead of MySAM
: tables?
Tables aren't kept in separate files, disk space preallocated,
little less mature (but no less stable, I've found). For most
people, those aren't drawbacks, just
Description:
Somehow the letter 'O' is not equivalent to the letter 'Ö' (O with
umlaut), in string matching.
How-To-Repeat:
I tried the following query in MySQL:
SELECT 'e'='ë', 'o'='ö';
(ie, select 'e' = e-with-umlaut, 'o' = o-with-umlaut)
Try setting the column to binary, that what worked for
me.
Shannon
--- awk [EMAIL PROTECTED] wrote:
Description:
Somehow the letter 'O' is not equivalent to the
letter 'Ö' (O with
umlaut), in string matching.
How-To-Repeat:
I tried the following query in MySQL:
So sprach »Shannon Kendrick« am 2001-12-21 um 14:24:31 -0800 :
Try setting the column to binary, that what worked for
me.
Uhm, isn't that another bug in this case? I'm too lazy to check the
manual right now, but I think it says that the only difference between a
BINARY VARCHAR and a VARCHAR
Description:
It is possible to create an InnoDB table that has a composite primary key
longer than 500 characters. Trying to delete from this table
specifying all fields of the PK causes mysqld to crash.
How-To-Repeat:
mysql create table chump (
-
Description:
Whenever mysqld starts (seems ok) and on every connection it stops
and I'm getting the following message:
mysqld got signal 11;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked agaist is corrupt, improperly
I've got a Alter table DROP INDEX that's been running for over 48
hours now.
I'm hoping to load a bunch of tables in a new database with 22 million
records, and then
create the indexes afterwards, but if this creation takes days, I really
want to know if it
is working or not, and how far it
In the last episode (Dec 22), Steve Rapaport said:
I've got a Alter table DROP INDEX that's been running for over 48
hours now. I'm hoping to load a bunch of tables in a new database
with 22 million records, and then create the indexes afterwards, but
if this creation takes days, I really
I'm still in the learning mode with mySQL.
I have two tables (frequencies and agencies), both contain a column called uid. I
wish
to join these two tables. When I run this...
USE radio;
SELECT f.freq1, f.ctcss1, f.callsign, a.agency
FROMfrequencies as f
JOINagencies as a ON f.uid =
Are the other servers all using the same kernel version (2.4.4)?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
m] On Behalf Of Arndt Jenssen
Sent: Wednesday, December 12, 2001 2:27 PM
To: [EMAIL PROTECTED]
Subject: High load problem with 3.23.45
Maybe
- Original Message -
From: John Mayson [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Saturday, December 22, 2001 10:11 AM
Subject: Help with join
I'm still in the learning mode with mySQL.
I have two tables (frequencies and agencies), both contain a column called
uid. I
Hi.
Is it possible to use function such as year() in index key (like use subpart
for string field that it work)
I try this
ALTER TABLE XXX ADD INDEX YYY (Year(DoBirth)); --- error syntax error
ALTER TABLE XXX ADD INDEX YYY (DoBirth(4)); --- error used key part isn't
string
Thanks.
Kittiphum
46 matches
Mail list logo