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
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
- 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
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
>
>
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
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
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
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
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
>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)
>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 (
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
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
>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)
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
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
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
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
--
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.
>
>
> 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
--
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?
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
* 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,
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
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
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
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
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
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
> 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
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')"
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
>
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
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
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
> 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
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
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
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
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
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
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
> ./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
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
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
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
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
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
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
50 matches
Mail list logo
