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,
Heikk
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
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 sim
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, grupper
> ./mysql -uuser -ppassword database
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 and a I want a script to be able to
> tell Mysql to read this ANSI SQL file every few days because it
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 scr
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
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> creat
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 r
> 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
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', 'val
On 21 Dec 2001, at 15:57, Carsten H. Pedersen wrote:
> SELECT DISTINCT enum_col FROM tablename WHERE enum_col<256;
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 W
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
>
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')"
> 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 "enu
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
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)
1
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
t2.lan
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
chara
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,
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 tab
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.
>
>
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 PROTECT
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 - p
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 - p
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 diff
>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 MyS
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:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:angelos Vasdaris
>Organization:
>MySQL support: [none]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.46-max (Source distribution)
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 h
I downloaded and installed the latest MyODBC drivers for Win2000 and got
everything installed and configured. My question is this, when I run an
append query, Access pops-up a message box saying something like:
You are about to append 737 records, are you sure you wish to continue?
Regardless
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 reall
Thanks, that works! (By the way, my current index has another day and
a half to go!)
steve
Dan Nelson wrote:
>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
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
>
>
- 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
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
If I type something at the MySQL prompt and it's taking too long to run,
how do I abort it? I'm using a Windows telnet app to telnet to a Linux
machine, and running MySQL from the command line. But if I type "ctrl-c"
(which I'm in the habit of doing, to kill slow UNIX and DOS programs), that
50 matches
Mail list logo
