Paul,
I checked for InnoDb and this have to work with MyIsam also.
But also decide your size. If your size exceeds the limit, it get truncated
and u never come to know during insert. so you can go for mediumblob if it
exceeds the blob size. Check for the size restrictions in the manual.
Hello,
I have started mysql server keeping binary logs and once in a while I
execute reset master.
Irregularly mysqld crashes and in the error logs I read the lines
bellow:
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
The combination of Access front end with MySQL or PostgreSQL works
great. However there is a disadvantage in using Microsoft Office
applications. If you use Visual Basic code to program the behaviour of
your front end (You probably will). The front end will run great until
the next major update
Hope this helps u
CREATE TABLE photo( name VARCHAR(50) NOT NULL, pic MEDIUMBLOB, picname
varchar(50),
INDEX(name),
FOREIGN KEY(name)
REFERENCES person(name) ON DELETE CASCADE
) TYPE = INNODB ;
INSERT INTO photo(name , pic, picname) values( 'raman',
hi List,
I am trying to do a master-slave replication on mysql-3.23.42. My master is
sitting on a FreeBSD machine and the slave is running in a Red Hat Linux 7.1
machine.
From the log, the master-slave connection is okay, but the slave seems
unable to read the binary content from master. My
Do anyone has a idea how to Insert (create SQLQuery) from onetable to an
other table as
decripted under:
Here is the orginal Table:
Table1:
Ref | Timestamp | ActionDate
---+-+
001 | DEP + 2002/01/02
Juha,
select dep.Ref, dep.ActionDate as Departure, arr.ActionDate as Arrival,
dlv.ActionDate as Delivery
from
Table1 dep left join Table1 arr on (dep.Ref = arr.Ref and arr.Timestamp =
'ARR')
left join Table1 dlv on (dep.Ref = dlv.Ref and
dlv.Timestamp = 'DLV')
where
I have tried this but some queries that run on Access failed to run on
MySQL. I had this problem with INNER JOIN
Thanks
Emery
- Original Message -
From: Gerben Gieling [EMAIL PROTECTED]
To: Michael T. Babcock [EMAIL PROTECTED]; David Lloyd
[EMAIL PROTECTED]
Cc: Adam Parker [EMAIL
Iod,
- Original Message -
From: iod iod [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 8:14 AM
Subject: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using
We have been using InnoDB with MySQL (MySQL-Max-3.23.52-1) for transaction
I have installed the php-mysql package and can now connect to the database.
There is however another error which I do not undertand.
Warning: No MySQL-Link resource supplied in
/usr/local/www/vantweststamps/databaselogin.php on line 15
Connected successfully
,Line 15 is
mysql_close();
If I
Dyego,
the user should submit a repeatable test case if he suspects that a
transaction only partially went to the database. Has he checked that the
return value from his SQL statements was ok, and none was rolled back?
About the reliability problems he had with Windows 2000: he could try
Hi!
It sounds like a simple UNION ALL thing, but I think I don'tunderstand well
what your problem is. Can you give an example?
Daniel
At 12:59 2002.09.26. +0800, you wrote:
Dear all
i had two tables, tableA Table B.
I want to create a permanent table call Table C which the first two field
Hello all,
This discussion appeared recently:
| Can I use MySQL to store pictures as part of a record?
| Should I just try to store the name of the picture?
Yep but it depends on the size of the pictures.
Let me describe a scenario we have here in genomics research, which is
extremely
Description:
MySQL kills itself several times a day due to the following assertion
failure :
InnoDB: Assertion failure in thread xxx in file ha_innodb.cc line 2014
How-To-Repeat:
-
Fix:
-
Submitter-Id: submitter ID
Originator:Jedi/Sector One
Organization: 42 Networks
MySQL support:
Oops: sorry if this message appears twice but my connection broke down just
when I clicked 'send'.
Hello,
I am currently writing a search query in PHP to:
1. search in MySQL database (not in one table but in all the tables of the
whole database),
2. search when more than one searchterm is
Hi,
According to InnoDB's page, the largest innodb database is currently a
bit over 1TB. This is in Mytrix's database (Mytrix provide site
tracking services for your website, see www.mytrix.com).
With a default page size of 16KB, you get a theoretical maximum database
size of about 60 TB. You
Pascale Lunal wrote:
Oops: sorry if this message appears twice but my connection broke down
just when I clicked 'send'.
Hello,
I am currently writing a search query in PHP to:
1. search in MySQL database (not in one table but in all the tables of
the whole database),
2. search
I thought you might be interested in a bug that I traced to my having used
the wrong case for the table name. This had me baffled for a while because
the behaviour was not consistent, sometimes the error was duplicate key,
other times wrong column count
CORRECT BEHAVIOR
When I am trying to install mysql-shared-4.0.3 on a redhat 6.2 system with kernel
2.2.19, i get following dependenci problem I need glibc 2.2, i need the mysql-shared
in ordre to get the php-mysql modul to work.
How can i fix this problem?
/Klaus
Dear Joseph,
Thank you for your quick reply. The MERGE function may do the trick but then
I would have to type the name of the 50 tables ! The idea was to avoid
having to type evey single table. Also, what will happen if new tables are
created ? I'll have to re-merge them all ?
P.L.
From:
Hi Phobe,
As the MyIsam tablehandler stored the tables as files on the file system the OS
specific case sensitivety for file names comes into place here.
On a Unix system you have to use the correct cases for the table names, on a Win*
System the cases of the table names does not matter.
The
In also belive that MySQL is very good in a single environ ment. You can try
out some very good GUI front end clients like MySQL-Front and SQLyog. Since
MySQL-Front has been discontinued, SQLyog is a very good option.
Insane
- Original Message -
From: Gerben Gieling [EMAIL PROTECTED]
To:
msg Mittwoch, 25. September 2002 21:07 by Pete Harlan:
If not, i know that ext3 can have ten of thousands files in a directory.
But commande like 'ls' will become slower and slower ...
Is this also slowing mysql ?
I believe it would have to. There is a patch somewhere (I don't know
if
ok guys
i ve actually done it fo myslf ... :'(
mysql s all screwedup ...
i reinstalled it last night and myadmin too ... now ...
ive created two users and databases n ...
wolla
i cnt even login ... :'(
i feel like banging my head against da walls
vat in earth is with this
Hi,
This is my first mail to mysql list, so sorry if it is a well known (answered)
question. I read lot of articles, lists before and I can not decide what
about the stability of mysql when I use tables with large numers of records
and many sessions?
Are there any experiences with it? (Our
Hello,
I'm new to MySQL. I've been able to query the database via PHP and display
it within a html page. I would like to out put the results to a flat file
tab delimited instead of onto a new page.
Thanks for any help.
DBA / Unix Administrator
Patrick Fowler
Wynit, Inc.
6847 Ellicott Drive
I load a table whit the query:
LOAD DATA INFILE 'a.txt' INTO TABLE table FIELDS TERMINATED BY '\t' LINES
TERMINATED BY '\n';
the file:
211ppp222
222ooo333uuuo
and more
the problem is, the last field in the table is '|' or 'uuuo|'
the final
On Thu, 26 Sep 2002, Bence Szabo wrote:
Are there any experiences with it? (Our planned system about 5M records
and intensive web based queryes, I don't know exactly estimated how many
concurrent sessions)
Bence,
that's where MySQL shines. But beware of the file size limit inherent to
your
Please help me mysqldump:
ON:
mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1 database.gz
I have an error :
mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm'
(errno: 24) when using LOCK TABLES
Thanks very much.
[EMAIL PROTECTED] wrote:
When I am trying to install mysql-shared-4.0.3 on a redhat
6.2 system with kernel 2.2.19, i get following dependenci
problem I need glibc 2.2, i need the mysql-shared in ordre
to
get the php-mysql modul to work.
How can i fix this problem?
I
Hi!
Could you send me the file /mysql/sql/ha_innodb.cc so that I could check
what assertion fails in your snapshot of the source tree?
Thank you,
Heikki
Innobase Oy
- Original Message -
From: [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 12:37
Is it possible to run the new MySQL 4.0.3 on a system that uses glibc-2.1.3,
especially the MySQL-shared?
/Klaus
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
CP,
Thursday, September 26, 2002, 11:00:10 AM, you wrote:
C I am trying to do a master-slave replication on mysql-3.23.42. My master is
C sitting on a FreeBSD machine and the slave is running in a Red Hat Linux 7.1
C machine.
C From the log, the master-slave connection is okay, but the slave
Clayburn,
Thursday, September 26, 2002, 3:58:13 AM, you wrote:
CWJI I create a table with a VarChar field set to not null. When I do an
CWJI insert into this table with no value for this field it goes through
CWJI without a problem. I realize MySQL inserts a empty string into the
CWJI field.
Sridhar,
Wednesday, September 25, 2002, 6:11:30 PM, you wrote:
SP Currently i get around this issue by analyzing the BDB tables, but this
SP seems to be a temporary solution. The issue is intermittent, keeps
SP surfacing
SP again after a certain no of days. Did not find any related bugs with
weng,
Thursday, September 26, 2002, 3:05:25 AM, you wrote:
wc i've installed ver 3.23.47 sa win2k pero di ko sya
wc mstart as service..
wc if i type this==mysqladmin create database01
wc ERROR==mysqladmin: connect to server at 'localhost'
wc failed
wc error: 'Can't connect to MYSQL server on
Mann,
Wednesday, September 25, 2002, 10:29:55 PM, you wrote:
MJ Hello all, I am brand new to MySql and I wanted to know if you could
MJ recommend any books that are a good start on learning the mechanics of
MJ MySql. Thanks!
Paul DuBois's book MySQL :) It's really a good book.
Searchable
toby,
Thursday, September 26, 2002, 2:53:08 PM, you wrote:
t i ve actually done it fo myslf ... :'(
t mysql s all screwedup ...
t i reinstalled it last night and myadmin too ... now ...
t ive created two users and databases n ...
t wolla
t i cnt even login ... :'(
Start MySQL server
tl,
Thursday, September 26, 2002, 3:44:30 PM, you wrote:
t Please help me mysqldump:
t ON:
t mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1 database.gz
t I have an error :
t mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm'
(errno: 24) when using
Daya,
Thursday, September 26, 2002, 7:53:46 AM, you wrote:
DKD can anyone tell me how can i set the default datetime as current datetime in
DKD the mysql. so that every time i insert a record in the table current
DKD datetime automaticall inserted.
DKD Thanks in advance.
Take a look at
Patrick,
Thursday, September 26, 2002, 3:38:24 PM, you wrote:
PF I'm new to MySQL. I've been able to query the database via PHP and display
PF it within a html page. I would like to out put the results to a flat file
PF tab delimited instead of onto a new page.
Use SELECT INTO OUTFILE:
antispam,
Wednesday, September 25, 2002, 7:04:03 PM, you wrote:
afn Hi Victoria..
Hi!
First of all answer to the mailing list, not to me.
afn thanks.. for the mail.. i feel confident now.. i dont have log or backup..
could you please
afn tell me how to turn on logs ??
Check the following
Hi,
can anyone tell me how can i set the default datetime as current
datetime in the mysql. so that every time i insert a record in the table
current datetime automaticall inserted.
Thanks in advance.
From MySQL manual section 6.5.3:
Default values must be constants. This means, for
Pascale Lunal wrote:
Dear Joseph,
Thank you for your quick reply. The MERGE function may do the trick but
then I would have to type the name of the 50 tables ! The idea was to
avoid having to type evey single table. Also, what will happen if new
tables are created ? I'll have to
Hi,
Er, I don't want to be rude, but those dots drive me crazy.
Could you include more details? What version of MySQL running now? Running as
a service r from the command line? You can't even log in? What does MySQL
client say? I suggest using the command line client for early troubleshooting,
Hi again,
Sorry, you _did_ mention your MySQL version... wrote the reply in quite a
hurry. Why aren't you using the latest version (3.23.52)?
Iikka
On Thu, 26 Sep 2002, toby - wrote:
ok guys
i ve actually done it fo myslf ... :'(
mysql s all screwedup ...
i reinstalled it last night
Hi,
I am trying to install pam_mysql but seem to have a dependency problem.
This is the output from make:
lawrence:/usr/local/pam_mysql # make
mkdir -p ./dynamic
gcc -O2 -Dlinux -DLINUX_PAM -ansi -D_POSIX_SOURCE -Wall -Wwrite-strings
-Wpointer-arith -Wcast-qual -Wcast-align -Wtraditional
u think that d make much of a difference
:( ...
i cant work with the thing any more yaar
rather cant make it work .
the thing that i waz actually playin with last week ... :S
and i jst cannot recall how i handled it last time i installed it on n all
...
though i had my myadmin's config
CREATE TABLE TableC SELECT tableA.field1,table1.field2,tableB.field1
FROM tableA,tableB WHERE joinCondition
That should do it, if I got the syntax correct. You do want to use the
create/select combo though.
On Thursday, September 26, 2002, at 12:59 AM, Jack wrote:
Dear all
i had two
Vaso,
Thursday, September 26, 2002, 9:54:06 AM, you wrote:
VK I have started mysql server keeping binary logs and once in a while I
VK execute reset master.
VK Irregularly mysqld crashes and in the error logs I read the lines
VK bellow:
VK mysqld got signal 11;
VK This could be because you hit
Did you check Egor's last message to you on the list? After starting mysqld
with --skip-grant-tables you should be able to connect with this:
mysql -u root
on the server, otherwise use mysql -u root -h your.server.ip.address
It won't be of much help if you can't get 'root' working. Please try to
William,
Wednesday, September 25, 2002, 11:26:20 AM, you wrote:
WM Can someone tell me if I can load only one column of data from a tab
WM delimited text file into MySQL 4.0?
If this column is first in the text file, yes. But you get warnings.
WM If so, then can I assume that I can
WM load
From: Iikka Meriläinen [EMAIL PROTECTED]
To: toby - [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: mysql all messedup ... :'( .
Date: Thu, 26 Sep 2002 17:26:10 +0300 (EEST)
Did you check Egor's last message to you on the list? After starting mysqld
with --skip-grant-tables you
Hi,
I am connecting to a mysql server on a remote machine, and opened up port
3306 for this purpose. But, I am concerned about sending a clear text
password, via the mysql_pconnect() call. My question is, what is the
procedure for connecting to a remote server with an encrypted password? Or,
I would highly recommend a simple design:
1) Create a large filesystem on your drive(s) using ReiserFS (because of fast file
finding capabilities).
2) Create a table that has one entry per image with an auto_increment primary key.
3) Insert a new record every time you 'store' an image, grab the
I've read a bit about using LAST_INSERT_ID(expr)
to set the next auto_increment value.
my question is, if i have 2 tables, like follows
CREATE TABLE A (
id int not null auto_increment primary key,
...
)type=MyISAM;
CREATE TABLE B (
id int not null auto_increment primary key,
...
)type=MyISAM;
On Thu, Sep 26, 2002 at 10:31:06AM +0100, Andrew Bryant wrote:
We have 125 million smallish images (each one is tens of KB, produced by
gene sequencing machines). Currently we store these in tarfiles and
index the images (the offset in the tar file) using an Oracle
database. Each tarfile is
PROVOCATIVE RANT
MySQL doesn't provide native support for transactions but is dependent on
the Berkeley or InnoDB table types.
Does MySQL really provide TRUE row level locking? That's the claim but is it
valid? The InnoDB web site seems to be more accurate by explaining that
locking is a
I am connecting to a mysql server on a remote machine, and opened up
port
3306 for this purpose. But, I am concerned about sending a clear text
password, via the mysql_pconnect() call. My question is, what is the
procedure for connecting to a remote server with an encrypted
password?
Or,
Maybe you could somehow setup your SSH tunnel before-hand
(at server start up or something) and use that instead.
Adam Voigt
[EMAIL PROTECTED]
On Thu, 2002-09-26 at 12:40, John Holmes wrote:
I am connecting to a mysql server on a remote machine, and opened up
port
3306 for this purpose.
Hi,
I have mysql-3.23.32-1.7 machine, and the problem I have is that is that
all users are able to see all databases in mysql
How can I restrict
each user to only view the database he's been assigned permission for?
Thanks in advance!
Saleem
On Wed, Sep 25, 2002 at 08:49:43PM +0300, Iikka Meril?inen wrote:
Hello,
If the number of files is your concern, have you considered using InnoDB? It
spans tables across any number of data files you want. The performance is
great, too.
The .frm files are still there, though, one per file.
Hi,
My host is running 3.22.5 on a redhat. Im trying to log in and use the
LOAD command but I cant get past 'ERROR 2002: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2).'
I connecting remotely with putty and sshing in on port 22. at command
prompt I was told by host to
On Wed, Sep 25, 2002 at 09:43:13PM +0300, Heikki Tuuri wrote:
Jocelyn,
below the latest patch which puts the code as it was in 4.0.3. Some LIKE
'abc%' ... DESC queries may return wrong results, but this is the best we
can get to 4.0.4.
I have to ask Monty about the use of
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
I am sure I am going to feel ignorant when I get the answer to this question
because it will be something simple that I have overlooked, but here goes
anyhow.
I am using MySQL Version 3.23.51-max.
I am developing an N-tier application using Java on the server side
accessing MySQL through JDBC.
Hello,
Start your mysqld with --safe-show-database parameter (or edit your my.cnf,
respectively).
Regards,
Iikka
On Thu, 26 Sep 2002, Saleem wrote:
Hi,
I have mysql-3.23.32-1.7 machine, and the problem I have is that is that
all users are able to see all databases in mysql
How can I
You can try stunnel for forcing the connection through ssl. Works with
most tcp applications transparently.
On Thursday, September 26, 2002, at 12:40 PM, John Holmes wrote:
I am connecting to a mysql server on a remote machine, and opened up
port
3306 for this purpose. But, I am
Greetings...
I believe MySQL is stable and fast enuf for your puprpose. And its pretty
easy to start up.
Insane
- Original Message -
From: Bence Szabo [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 7:52 PM
Subject: what about the stability?
Hi,
This is my
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tried the same on mysql,
Heikki, Jeremy,
FYI, I've just tested latest pull (including Monty's patch) without Heikki
1.1318 changeset (Remove the flag HA_NOT_READ_PREFIX_LAST because ORDER BY
orders wrong then;) and now it works perfectly fine :
mysql SELECT LOWER(pseudo),date,numreponse FROM threadhardwarefr12 WHERE
BTW, I assume Monty's change means that MyISAM tables are able to not use
filesorting on
WHERE key_name1='constant' ORDER BY key_name DESC
type queries whereas InnoDB tables are not able to do so ?
e.g. :
mysql ALTER TABLE threadhardwarefr13 type=innodb;
mysql EXPLAIN SELECT
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tried the same on mysql,
Jocelyn,
- Original Message -
From: Jocelyn Fournier [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 9:53 PM
Subject: Re: InnoDB:
Yes, I've also tested the LIKE 'abc%' but forgot to include it in my mail :)
CREATE TABLE `threadhardwarefr12` (
`numeropost` mediumint(8) unsigned NOT NULL default '0',
`numreponse` int(10) unsigned NOT NULL default '0',
`pseudo` varchar(35) NOT NULL default '',
`date` datetime NOT NULL
Hi Bence,
We are running mysql with over 1,000 tables - plenty of them have 10 Million
to 40 Milion records (Geographic data) - about 500 concurrent sessions doing
about 800 to 1000 queries total per second at peak.
We haven't had any problems in the last 2.5 years. (our system is read heavy
Hi,
Well, why not trying... concat() :)
SELECT concat(numer,',',text) FROM Table;
http://www.mysql.com/doc/en/String_functions.html
Regards,
Jocelyn Fournier
- Original Message -
From: MySQL [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 8:46 PM
Subject:
Hi,
You need to use :
Select concat(numer,',',test) from table;
See: http://www.mysql.com/doc/en/String_functions.html for more.
Cheers,
Andrew
-Original Message-
From: MySQL [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 26 September 2002 19:47
To: [EMAIL PROTECTED]
Subject: Mysql
:I want to make a sql query in mysql, with a concat (||) known i Oracle
:world.
:
:Like this.
:
:select numer ||','|| text from Table:
Instead, try the following:
SELECT CONCAT(number, ',', text) FROM Table;
-
Hi Frank,
You can use the concat() function:
select concat(numer, ',', text) from Table.
The online docs for MySQL contain a great reference for functions:
http://www.mysql.com/doc/en/Functions.html
--jeff
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql,
My host is running 3.22.5 on a redhat. Im trying to log in and use the
LOAD command but I cant get past 'ERROR 2002: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2).'
I connecting remotely with putty and sshing in on port 22. at command
prompt I was told by host to
Concat and Concat_WS from the mysql web site
CONCAT(str1,str2,...)
Returns the string that results from concatenating the arguments.
Returns NULL if any argument is NULL. May have more than 2 arguments. A
numeric argument is converted to the equivalent string form:
mysql SELECT CONCAT('My',
I am new to mySQL (and this list), and trying to implement it into our
application.
I am having trouble with the search syntax.
My regular SQL, I was using (from MS SQL 2000)
WHERE title LIKE '%#form.search#%'
OR content LIKE '%#form.search#%'
This doesn't seem to work in mySQL.
I have
From: MySQL [EMAIL PROTECTED]
select numer ||','|| text from Table:
SELECT CONCAT(numer, '||', text) FROM Table;
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
-
Before posting, please check:
Here's an update on this issue: The problem is when copy/pasting
Japanese characters into MySQL, certain characters are being corrupted.
I've ruled out Word as the problem.
I've ruled out my content tool as the problem.
I've ruled out the ASP display page as the problem.
I've configured my
I installed the MySQL-3.23.52-1.i386.rpm packet on my RedHat 7.3 server
machine.
Installation went OK, then it told me to change my root password by typeing:
/usr/bin/mysqladmin -u root password newpasswd
But i cant find mysqladmin at /bin/ directory! I cant find it no where.
Is is loacted
There are common one-way encryption, like md5, this is commonly what I do, I
encrypt with md5 when I insert the password into my database on the DB
server, and then I encrypt with PHP on the Web server side, so therefore, I
am only ever sending my md5 encrypted password over the wire. Since it
You almost answered your own question. In mysql you use the concat()
command:
select concat(number,',',text) from Table
On Thursday, September 26, 2002, at 03:17 PM, MySQL wrote:
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
Please read following text only with koi8-r codepage!
---cut---
mysql DROP TABLE IF EXISTS COUNTRIES;
Query OK, 0 rows affected (0.02 sec)
mysql CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
- PRIMARY KEY (Name) );
Query OK, 0 rows affected (0.00 sec)
mysql INSERT INTO
Hi!
- Original Message -
From: Orr, Steve [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 9:56 PM
Subject: RE: MyISAM or InnoDB
PROVOCATIVE RANT
MySQL doesn't provide native support for transactions but is dependent
on
the Berkeley or InnoDB
Hi Frank-
I'm new to the MySQL world, and I am also a DBA with an Oracle background.
This was a surprise to me as well. However, the only solution that I know
of is to encapsulate your SELECT elements in a Concat() function. So, your
SQL statement would be:
select concat(numer, text)
from
At 20:46 26/09/2002 +0200, MySQL wrote:
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
You need to specify the keyword CONCAT and enclose it in brackets,
like this:
I need to copy a database and all its tables and contents to a backup
server. The server
they live on is on an ISP, the server I want to back the up on is in my
office in another town.
I can access the ISP's server via phpMyAdmin and dump the data to a .sql
file, but then
what do I do to
Hello Victoria,
I have installed mysql 3.23.49 for Sorlaris and I have installed it
from the source distribution.
Do you have any idea about my problem?
Thanks :-)
Victoria Reznichenko wrote:
Vaso,
Thursday, September 26, 2002, 9:54:06 AM, you wrote:
VK I have started mysql server keeping
On Thursday 26 September 2002 12:35 pm, Andrew Braithwaite scribbled something
about:
Hi Bence,
We are running mysql with over 1,000 tables - plenty of them have 10
Million to 40 Milion records (Geographic data) - about 500 concurrent
sessions doing about 800 to 1000 queries total per
Bug Report:
Version: 3.23.51-max
OS: Windows ME
Problem:
Synopsis: Does not use index when ordering records on datetime field in
the descending order, even though though this field is NOT NULL.
I created the following table:
CREATE TABLE Threads (threadID int NOT NULL PRIMARY KEY,
Robert Fox wrote:
Hi Frank-
I'm new to the MySQL world, and I am also a DBA with an Oracle background.
This was a surprise to me as well. However, the only solution that I know
of is to encapsulate your SELECT elements in a Concat() function. So, your
SQL statement would be:
select
Hi Andrew and Richard,
The password and connection info is scrambled up. You can look, If
you want to check it out for your self look in the source code of
./mysql-3.23.XX/libmysql search for the following functions.
especially in 'mysql_real_connect' function. It is not the best
method, but
Hello all,
How do I stop a query once it has started without quitting the MySQL client?
I have a MySQL daemon and client (v3.23.36) running on a RedHat Linux 7.1
box. I ran a query that joined two large tables (300K rows each) on
columns that I had forgot to index. When I pressed Ctrl-C,
Hi everyone,
I'm using the select query shown below to extract some data from mysql.
Everything works fine until I try to retrieve anyone with a double
nationality, i.e. Swiss/Italian.
Do I have to escape the / somehow? (If I have to, how?)
Any comments or hints on where to look up that
1 - 100 of 118 matches
Mail list logo