Heikki Tuuri wrote:
>Kannan,
>
>please upgrade to 3.23.49a or 4.0.1.
>
>101 used to mean lock wait timeout. It has been replaced by a
>clear-English error code.
>
>Best regards,
>
>Heikki Tuuri
>Innobase Oy
>---
>Order technical MySQL/InnoDB support at https://order.mysql.com/
>See http://www
hii all,
I want to knowledge about blob.
how can write or read image(jpeg,gif or tiff) to/from MYSQL database by
using Visual C++. MySQL++ seems too confused.
Can any body say me more basic and understandable way to do this..
Thanks...
Ibrahim Kivanc Cihan
Anadolu University - Turke
Hello Matt,
> I've got an SQL question. I have a database that contains Reviews of
some
> of a clients publications. The client is interested in generating some
> summary reports and I simply can't wrap my head around a single SQL
query
> (if that's possible) that will generate the information I'
Hello,
I have a Sun Os 5.8 with gcc version 2.95.3.
When i try to compile mysql with the following command:
CC=gcc CFLAGS="-O6" CXX=gcc
CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql
I have this result:
[skip]
checking for inline... inline
I also interestig in this topic...I wanna know how to save a blob object , for
example, an image, to the mysql database, while I use EJB. Another words, I have a
object , which has a blob column, I wanna to save and retrive this object from mysql
database via CMP or BMP...how to make that?
Tha
Dear friends,
I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my
/usr/local directory and uncompressed it.
Now I can get the target directory but I don't know how to start the server.
I tried:
./bin/safe_mysqld --user=root &
but it doesn't work for me.
Any help is
On Wed, Apr 03, 2002 at 05:18:30PM +0800, Hammer wrote:
>
> Dear friends,
>
> I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my
> /usr/local directory and uncompressed it.
>
> Now I can get the target directory but I don't know how to start the server.
>
> I tried:
>
Hello
I am trying to configure mysql on solaris 2.6
when I run the configure command I use
./conigure --with-prefix=/usr/local/mysql --with-exec-prefix=/usr/local/mysql
--enable-thread-safe-client --with-mysql-user=mysqldba
configure reports back the following error
configure: error: No size
usr/local/mysql/bin/safe_mysqld --user = mysql &
or ./safe_mysqld --user = mysql &
Have a look at /mysql/bin/var/hostname.err.log
Hope this helps
Simon
-Original Message-
From: Hammer [mailto:[EMAIL PROTECTED]]
Sent: 03 April 2002 10:19
To: [EMAIL PROTECTED]
Subject: How to start the My
Check out http://www.mysql.com/doc/I/n/Installing.html.
BTW, are you downloading the binary distribution or source distribution?
Hammer wrote:
>
> Dear friends,
>
> I'm running RedHat Linux, I just downloaded the ~.tar.gz mysql file in my
> /usr/local directory and uncompressed it.
>
> Now I c
Hi,
See linuxconf, mysql is installed as a service which can be started
manually or automatic via linuxconf.
JvD
>>> [EMAIL PROTECTED] 3-4-02 11:25:19 >>>
On Wed, Apr 03, 2002 at 05:18:30PM +0800, Hammer wrote:
>
> Dear friends,
>
> I'm running RedHat Linux, I just downloaded the ~.tar.gz mys
Have you got your LD_LIBRARY_PATH set correctly?
Andrea Soracchi wrote:
>
> Hello,
>
> I have a Sun Os 5.8 with gcc version 2.95.3.
>
> When i try to compile mysql with the following command:
>
> CC=gcc CFLAGS="-O6" CXX=gcc
> CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti"
> ./c
you need to set LD_LIBRARY_PATH.
MySql Dba wrote:
>
> Hello
>
> I am trying to configure mysql on solaris 2.6
>
> when I run the configure command I use
>
> ./conigure --with-prefix=/usr/local/mysql --with-exec-prefix=/usr/local/mysql
>--enable-thread-safe-client --with-mysql-user=mysqldba
>
Hi,
My department is migrating our application from MySQL-3.22.x to 3.23.49.
I am
interested in the new replication function and I have question about
using this replication facility.
Let say I have Database_A at Site A and Database_B at Site B. I wish to
replicate both Database_A and Database_B
On Wed, 03 Apr 2002 18:53:00 +0800
Adrian Hoe <[EMAIL PROTECTED]> wrote:
> Hi,
>
> My department is migrating our application from MySQL-3.22.x to 3.23.49.
> I am
> interested in the new replication function and I have question about
> using this replication facility.
>
> Let say I have Databas
My DB has many update queries and a few select queries.
Sometimes select queries take very long time so update can't
proceed. I can kill the select query manually. But I can't check
the status all the time.
Are there any ways to kill slow query automatically? If you know,
please let me know. An
> -Original Message-
> From: pwxgao [mailto:[EMAIL PROTECTED]]
> Subject: PERL/SQL, again? - Re: Procedures
>
>
I have been using languages like Smalltalk, Perl and Java for
about xx years. I am a huge fan of putting one in the DB for
embedded server procedures.
I also beleive the bes
On Wed, 3 Apr 2002 19:28:13 +0900
°í¼ø¹Î <[EMAIL PROTECTED]> wrote:
> My DB has many update queries and a few select queries.
> Sometimes select queries take very long time so update can't
> proceed. I can kill the select query manually. But I can't check
> the status all the time.
>
> Are the
Dicky Wahyu Purnomo wrote:
>
> On Wed, 03 Apr 2002 18:53:00 +0800
> Adrian Hoe <[EMAIL PROTECTED]> wrote:
>
> > Hi,
> >
> > My department is migrating our application from MySQL-3.22.x to 3.23.49.
> > I am
> > interested in the new replication function and I have question about
> > using this re
On Wed, 03 Apr 2002 19:19:36 +0800
Adrian Hoe <[EMAIL PROTECTED]> wrote:
> Dicky Wahyu Purnomo wrote:
> We are planning to migrate (to be precise).
>
> Where can I find the documentation on setting up replication? I could
> not find any or I may have overlook.
well you can find on MySQL Docum
Hi,
When I try to install the Msql-Mysql module it throws up a list of
questions.One of them is :
Where is your MySQL installed? Please tell me the directory that
contains the subdir 'include'. [/usr/local]
I had installed MYSQL 3.23.49a using the rpm technique.I checked out in my
/usr/local a
> From: David McInnis <[EMAIL PROTECTED]>
>> Could you share your script for doing the date thing with the rest of
>> us? That sounds useful.
Isn't there a perl script around for backuping?
Something like:
mysqldump DB --add-drop-table --opt \
|gzip > DBdump.`date +%Y-%m-%d`.gz
shoul
>Description:
3 "select" with little difference (2 with strange result, and last correct)
==
select
Schedule.PTRScheme as Scheme_ID,
Subject.TID as Subject_TID,
Scheme.PTRSubject as Subject_ID,
if(count(distinct Le
> Will you never put your files on the net? If so, what will
> you expect to
> find at the remote server? Your character set?
I am building an application for my company's intranet. I control the server
completely. I want to fix the problem, not work around it. Besides, if this
character map is
Hi all,
I want to get the difference between 2 tables.
table_1:
column_1
A
B
C
D
table_2:
column_2
B
C
What is the sql select syntax to get as result A,D or B,C?
Thanx for your help.
Regards,
Bernd
-
Before post
You can try something like this:
DateDir=Directory where you want your backups saved
print $output->printheader;
my ( $sec, $min, $hour, $mday, $mon, $year, $wday, $yday, $isdst )=
localtime(time);
$year = $year + 1900;
$mon++;
mysql> select table1.* from table1
LEFT JOIN table2 ON table1.column_1=table2.column_2
where table2.column_2 is NULL;
try this to select row of table 2 not in table 1, i think.
> Hi all,
>
> I want to get the difference between 2 tables.
>
> table_1:
> column_1
> A
> B
Hi David,
On Wed, Apr 03, 2002 at 02:10:03PM +0200, David yahoo wrote:
> mysql> select table1.* from table1
>LEFT JOIN table2 ON table1.column_1=table2.column_2
>where table2.column_2 is NULL;
>
> try this to select row of table 2 not in table 1, i think.
Yes, it's worki
I have :
mysql> select version();
+---+
| version() |
+---+
| 4.0.2-alpha-debug |
+---+
1 row in set (0.00 sec)
But an error too :
mysql> delete
-> from
-> externallink as link,
-> topic as topic,
-> topiclink as joiner
I search mySQL-MAX on the mySQL web site and just found mySQL binaries (not
mySQL-MAX binaries). Is InnoDB table handler compatible with HPUX (10.20 or
higher) ?
Friendly.
-
Before posting, please check:
http://www.mysql.com/
>Description:
When using a replication between two MySQL servers (v3.23.48) on FreeBSD the
ALTER TABLE command is not replicated. It is present in the bin-log, but the slave
seems to ignore it. This seems to be fixed in MySQL version v4.0.1
>How-To-Repeat:
Set-up a replication
Hi,
There is no way to kill slow queries autmatically unless you were to
write a script (maybe in perl or php?) to do this job. I have a
similar problem and am thinking of replicating the database just to
avoid this problem. I would then direct certain type of queries to
the replicated server
My best code is this:
SELECT SUM(invoice_amount), state, statement_date
FROM invoice
GROUP BY state, statement_date
The results are have followed:
+-+---++
| SUM(invoice_amount) | state | statement_date |
+-+--
From: "Danis Stéphane (NHQ-AC)" <[EMAIL PROTECTED]>
> My best code is this:
>
> SELECT SUM(invoice_amount), state, statement_date
> FROM invoice
> GROUP BY state, statement_date
>
>
> The results are have followed:
> The main problem is the layout and the order of the results set. I will
have
I don't know about making 100 tables for 100 users, that doesn't sound
like a good idea to me. Not that it won't work, it will work, but if you
ever have to change the structure of your database due to a program
change
on the client end, you have to change 100 tables.
I wrote something that goes
Hi,
would anyone please explain me what are these error messages?
020327 12:29:26 mysqld started
020327 12:29:26 Warning: listen() on TCP/IP failed with error 98
/usr/local/mysql/bin/mysqld: ready for connections
/usr/local/mysql/bin/mysqld: ready for connections
020327 12:29:26 Error in ac
Howdy All -
I am using MySQL 3.23.46-Max under Red Hat 7.2
I am trying to use DECIMAL type columns to work with huge numeric (monetary)
values.
I figured out how to get large numbers into DECIMAL types by passing them as
strings:
mysql> insert into khtest set k1=1,t1="123456789012345678.10";
Hi all,
I make a new delete query (mysql 4.02)
delete t1,t2 from t1,t2
i t takes a long it displays 100931 rows affected.
i count all the rows into t1 it give the same result before the delete.
I make a du -h of the database dir it give the same results ?.
So i have some doubt (it seems to
Stéphane,
Answers:
There are nine different states (and there are 12 months).
*
The main problem is the layout and the order of the results set. I will
have
9 state (provinces) and I would prefer the month to be the columns. The
ideal results would look like this, Please note I have only incl
Lee,
Tuesday, April 02, 2002, 8:54:44 PM, you wrote:
LPR> I just installed MySQL 3.23.49 on NT and executed the following
LPR> commands:
LPR> UPDATE USER SET password=password("test1") WHERE host="localhost";
LPR> UPDATE USER SET password=password("test1") WHERE host="%";
LPR> Now, after do
David,
Wednesday, April 03, 2002, 3:30:52 PM, you wrote:
Dy> I have :
Dy> mysql> select version();
Dy> +---+
Dy> | version() |
Dy> +---+
Dy> | 4.0.2-alpha-debug |
Dy> +---+
Dy> 1 row in set (0.00 sec)
Dy> But an error too :
Dy> mysql> del
João,
Monday, April 01, 2002, 9:12:04 PM, you wrote:
JPV> Hello everybody,
JPV> I am running mysql-3.23.41 on FreeBSD 4.5, and everytime I use myisamchk I
JPV> get the following error:
JPV> [root@ws1 root]# myisamchk -r /opt/db/mysql/netcard/d_usuario.*
JPV> myisamchk: error: '/opt/db/mysql/ne
Murali,
Wednesday, April 03, 2002, 1:55:57 PM, you wrote:
MP> When I try to install the Msql-Mysql module it throws up a list of
MP> questions.One of them is :
MP> Where is your MySQL installed? Please tell me the directory that
MP> contains the subdir 'include'. [/usr/local]
It looks like in
Bernd,
Wednesday, April 03, 2002, 2:42:33 PM, you wrote:
BM> I want to get the difference between 2 tables.
BM> table_1:
BM> column_1
BM> A
BM> B
BM> C
BM> D
BM> table_2:
BM> column_2
BM> B
BM> C
BM> What is the sql select syntax to get as result A,D or B,C?
Look at JOIN clause:
Jane,
Wednesday, April 03, 2002, 12:27:33 AM, you wrote:
JT> We have encountered the problem to install Mysql-3.23.49 version on Linux
JT> Redhat 7.1.
JT> 1. Run rpm with Mysql-3.23.49a-1.i386.rpm, the installation failed.
JT> 2. Gunzip mysql-3.23.49.tar.gz, we got the error: invalid compresse
JOUANNET,
Wednesday, April 03, 2002, 3:32:25 PM, you wrote:
Jeoen> I search mySQL-MAX on the mySQL web site and just found mySQL binaries (not
Jeoen> mySQL-MAX binaries). Is InnoDB table handler compatible with HPUX (10.20 or
Jeoen> higher) ?
You can compile it from the source according to the i
I am running Windows XP with MySQL running as a service. When I want to
run MySQL with the option for logging (--log -bin), I have to start the
service MANUALLY and type the --log -bin in the parameters box each time I
restart the server. Is there an easier way to do this?
Thx,
Craig
Actually, I like this proposal of being able to plug in any language into
MySQL. I also want to make a note that Greg Cope has a very good point.
I believe it to be good to be able to plug in any language, but the mySQL
community may want to make a standard recomendation of a certain language.
A
On Wed, Apr 03, 2002 at 06:10:02PM +0300, Egor Egorov wrote:
: Murali,
: Wednesday, April 03, 2002, 1:55:57 PM, you wrote:
You know, I don't meant to be a bother, but can you folks at Ensita
reply to the list using standard reply conventions? All of your
replies have
Jane,
Probably u downloaded the file on your windows box and ftp'ed it using
"ascii" mode instead of binary as Egor has suggested.
-Prakash.
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 8:40 PM
To: [EMAIL PROTECTED]
Subject: M
Stephane,
Wednesday, April 03, 2002, 11:13:51 AM, you wrote:
SP> How can I connect to a distant MySQL Server -using tcp/ip- securely ?
You can set up SSL-encrypted connection between boxes.
You can find more info about SSL at:
http://www.mysql.com/doc/G/e/General_security.html
http
Valerie,
Tuesday, April 02, 2002, 9:13:50 PM, you wrote:
VB> I have a mysql table, which gives the error read-only when I use LOAD DATA
VB> INFILE command. How do I change this, I read the online manaul with no
VB> success.
It means that user mysql has no permissions to write in those files.
Hi, pwxgao
I will suggest to use JBuilder6 EnterpriseEdition and
Borland Enterprise Server. You will be able to build EJB(CMP2.0),
which can persistent blob column, very easily without coding. :-)
pwxgao wrote:
>
> I also interestig in this topic...I wanna know how to save a blob object ,
>
Ibrahim,
Wednesday, April 03, 2002, 11:30:28 AM, you wrote:
IKC> I want to knowledge about blob.
IKC> how can write or read image(jpeg,gif or tiff) to/from MYSQL database by
IKC> using Visual C++. MySQL++ seems too confused.
:) In the manual you can find examples of loading/reading binary d
I seem to be having issues with the way MySQL names
the table files under Unix and WinXP. I'm not sure if it's a
mysql issue or a windows issue.
Normally, when I create tables in MySQL, I like to capitalize the
first letter. Under unix, it all works fine and dandy. But under
WinXP, the table n
I didn't have time to try out your hints/techniques described in your
earlier post, but after playing around a bit with the web frontend I decided
that it would be more user intuitive to used the month as column and the
state as row... The reason being my change of heart is I also have a similar
r
Russell E Glaue wrote:
>Actually, I like this proposal of being able to plug in any language into
>MySQL. I also want to make a note that Greg Cope has a very good point.
>And going from what Greg mentioned in an earlier e-mail in this thread,
>the embedded language of choice really needs to b
Hi, how do I do the following:
I have a table I have added a new field to, I want to take field X and copy
it to the new field for each record. What should this query look like?
Thanks,
Chuck
-
Before posting, please check:
How can I connect to a distant MySQL Server -using tcp/ip- securely ?
Thanks
Stéphane
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
T
MySQL version 3.23.32
(please don't ask me to upgrade to the newest version of mysql as an answer)
Everytime the replication server gets reset, the slave properties gets all
messed up
I am assuming the master.info gets trashed
Is this a known issue for this version?
Anyways, I can use the CHAN
Hi All,
I am trying to install DBD for mysql on linux machinein the process
when i did
"make test" i am getting the below error messages...
Could any one kindly help me in getting out of this??
Please refer the procedure to install Perl DBD module from source thru the
below link...
ht
UPDATE mytable SET field1=field2;
-Original Message-
From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:10 AM
To: [EMAIL PROTECTED]
Subject: copying field x to field y for each record in table
Hi, how do I do the following:
I have a table I have added a
Hi!
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, April 03, 2002 9:00 AM
Subject: Re: Replication and transaction questions
> On Tue, Apr 02, 2002 at 11:49:10AM +0200, Nico Sabbi wrote:
...
> > 2) why are creations o
At 10:10 -0600 4/3/02, Chuck Barnett wrote:
>Hi, how do I do the following:
>
>I have a table I have added a new field to, I want to take field X and copy
>it to the new field for each record. What should this query look like?
>
>Thanks,
>Chuck
UPDATE tbl_name SET y = x;
---
Humph. Undocumented CHANGE MASTER TO MASTER_CONNECT_RETRY=60;
Still asking the other question if there is a fix for the problem or not...
-Original Message-
From: Luc Foisy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:37 AM
To: MYSQL-List (E-mail)
Subject: Replication I
Am Mittwoch, 3. April 2002 18:10 schrieb Chuck Barnett:
> Hi, how do I do the following:
>
> I have a table I have added a new field to, I want to take field X and copy
> it to the new field for each record. What should this query look like?
>
UPDATE yourtable set newfield=x
Regards
Georg
---
Chuck,
Wednesday, April 03, 2002, 7:10:16 PM, you wrote:
CB> Hi, how do I do the following:
CB> I have a table I have added a new field to, I want to take field X and copy
CB> it to the new field for each record. What should this query look like?
UPDATE table_name SET y=x;
CB> Thanks,
CB> Chu
update table
set newfield = oldfield
- Original Message -
From: "Chuck Barnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 6:10 PM
Subject: copying field x to field y for each record in table
> Hi, how do I do the following:
>
> I have a table I have a
i am running a basic install of mysql version 3.23.49-log and i have a
pretty simple query that is not fast enough for my needs. any thoughts on
optimization would help.
the table description is below:
mysql> desc RADPOOL;
++--+--+-+-++
| Fie
One thing to consider with Perl is that perl 5 and perl 6 are totally
different beasts.
Perl 6 is built on top of parrot, a general purpose register based virtual
machine which is optimized to execute perl and similar languages. There are
already a small test language running on top of parrot
its a permission issue.. do
>grant ALL on *.* to root@localhost ..
-Original Message-
From: Pramod Chowdavarapu [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 11:54 AM
To: [EMAIL PROTECTED]
Subject: Problem while installing DBD for mysql on linux.
Hi All,
I am tryi
Note also that by doing this, your database will be denormalised. This may
not be a big deal, however.
On Wednesday 03 April 2002 9:55 am, you wrote:
> UPDATE mytable SET field1=field2;
>
>
> -Original Message-
> From: Chuck Barnett [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03
That assumes you believe the myth that Java is really the language of choice
in the back rooms of large enterprise IT shops. It isn't. In the financial
industry perl is ubiquitous. Upper management will tell you Java is god, but
if you actually look at the deployed systems that are out there do
> -Original Message-
> From: Russell E Glaue [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 03, 2002 7:15 AM
...
> Does anyone on this list have a suggestion as what might be the best
> language to embed into MySQL? Be sure to consider memory efficiency,
> threadding, speed of th
MySQL Manual | 4.1.2 my.cnf Option Files MySQL Manual [2621454]
MySQL Manual Search: Up Previous Next Chapters Sections Functions Concepts
4.1.2 my.cnf Option Files MySQL can, since Version 3.22, read default
startup options for the server and for clients from option files. MySQL
reads default o.
I am an avid PERL programmer, I also know java. I cannot completely agree
with either of you.
However, this debated subject is best discussed in another community.
The focus here is what has the necessary abilities/functionality to cause
SQL to become a 4th level language in MySQL.
High level fe
Hi,
When I do a make test for msql-Mysql-modules-1.22.19,two of the tests are
failing.They are
akmisc.t and mysql.t
It also says :
make[1]:*** [test_dynamic] Error 29
make: *** [test] Error 2
Can anyone pls help me with this.I have been trying for hours to fix
this.
Thanks
Prakash.
Hello everybody,
I have a problem inserting a text from anywhere (application,console,
doesn't matter) into a [char][varchar][text] field type. If I try to
insert eg: 'hello_there.txt' in a field ot type I enlisted above ,when I
read that field i get 'hello\_there.txt' and that is a big problem t
Hi,
I am trying to store a .gz file in a BLOB field in a mysql database. I have
tried two commands :
1. Insert into mytable values('1', 'file1.gz');
2 Insert into mytable values('1,','\'file1.gz\'');
These two commands just store the name of the file in the BLOB field instead of
the content of
I've been reading the docs but I just want to verify. It seems like the
latest version of MySQL support transactions and referential integrity. Is
this correct? Does MySQL now also support stored procedures?
Thanks,
Kevin
-
Bef
>Description:
Users enter data from a php based web site and receive no errors
or warnings of any kind that something is amiss, but the data isn't
entered into the tables. When I go to the mysql command line and run
commands i get a table handler error.
>How-To-Repeat:
this happen
Alright, I've got a little bit of a problem with this query.
This is what the current query looks like ( I know I'm doing it wrong, I
just don't know how to fix it.. I'm not that familiar with the LEFT
JOIN/subquery stuff.. )
select cluster.cid, cluster.isp, cluster.country_id-20 as
Country_
Hello everyone, I have the following line in my create table code:
SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES
SCAN_PARAMETER(SCAN_PARAM_ID)
I need to make it so that scan_param_id references to two differences tables? Will
this work?
SCAN_PARAM_ID MEDIUMINT(20) NOT NULL REFERENCES
SC
sql,query
I have two tables which are exactly alike. What I want to do is copy an
entire column(DESCRIPTION)from one table(ebooks2) and put that information
into the other table's(ebooks) description column where the ID(BOOK) matches
up. Is there a way to go about doing this?
Thanks,
A.J. Per
On Wed, Apr 03, 2002 at 01:58:55PM -0500, Kevin D wrote:
> I've been reading the docs but I just want to verify. It seems like
> the latest version of MySQL support transactions and referential
> integrity. Is this correct? Does MySQL now also support stored
> procedures?
BDB and InnoDB tables b
if your app is PHP, then use stripslashes() on field
-Original Message-
From: Pal Lucian [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:58 AM
To: [EMAIL PROTECTED]
Subject: underline char in a [char][varchar][text] field ?
Hello everybody,
I have a problem inserting a t
no stored procedures yet. maybe vers 4.1
-Original Message-
From: Kevin D [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 12:59 PM
To: [EMAIL PROTECTED]
Subject: transactions, referntial integrity
I've been reading the docs but I just want to verify. It seems like the
latest
Hello again,
is there any way to make mysqldump dump every insert as a single insert
instead of making INSERT INTO ... VALUES (...), (),(...) and so on ?
I read the manual and there is sth about -e wich as I understood means
multiple inserts in single line, but I did'n use this switch.
look at the manual, section :
6.4.9 LOAD DATA INFILE Syntax
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt'
[REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]
]
[LIN
Hello all,
Does anyone know if MySQL can do subqueries?
I am trying to provide a SELECT subquery to an IN clause and I am getting
errors. Is this possible?
-Leo
-
Before posting, please check:
http://www.mysql.com/manual.p
Thank you much - I somewhat understand the query that you posted now.
The problem that I'm dealing with NOW however is that it will only
display results if there is a second level referree. I need to get
results despite whether there are six levels or referrals, or only one.
I added a third
On Wednesday 03 April 2002 12:35 pm, Leo Przybylski wrote:
> Hello all,
>
> Does anyone know if MySQL can do subqueries?
Not the current version, no.
>
> I am trying to provide a SELECT subquery to an IN clause and I am getting
> errors. Is this possible?
Read the manual and follow the example
It can't, try using JOIN.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Leo Przybylski" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 1:35 PM
Subject: Subqueries
> Hello all,
>
> Does anyone kno
Sorry if this is an obvious question. I swear I RTFMed first.
Is there any compile-time option to redefine MySQL's data area (normally
mysql-path/var with compiled versions)? I've seen many possible ways of
doing it at run-time, but really I'd prefer this to be compiled in so I
don't have to worr
Hello all,
Please pardon my "newbie-ness" I've been looking at somehow migrating from a
flatfile user system (/etc/passwd, etc) to a MySQL backend for authentication for all
my processes... qpopper, postfix, and apache/frontage (ick)
I can't seem to find anything that would enable me
Yes, --localstatedir. See
http://www.mysql.com/doc/c/o/configure_options.html
Michael
On Wed, 3 Apr 2002, John Klein wrote:
> Sorry if this is an obvious question. I swear I RTFMed first.
>
> Is there any compile-time option to redefine MySQL's data area (normally
> mysql-path/var with com
Steve
Have you tried using compound index:
INDEX( POOL, STATE )
Just a thought.
David
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 03, 2002 10:13 AM
To: [EMAIL PROTECTED]
Subject: select query optimization
i am running a basic install of m
Does MySQL have the capability for the user to specify their own
delimiters for the command:
INSERT into (database) values ("value1, value2,...,valuen");
The values that I am inserting contain both "" and '' and I am receiving
a syntax error.
-
On Wednesday 03 April 2002 2:02 pm, Lori Thompson wrote:
> Does MySQL have the capability for the user to specify their own
> delimiters for the command:
>
> INSERT into (database) values ("value1, value2,...,valuen");
>
> The values that I am inserting contain both "" and '' and I am receiving
I have read the MySQL manual on column types and I
can't find anywhere which is smaller, ENUM, SET, or
TINYINT?
Could somebody let me know which of those three is the
smaller data type?
Thanks,
Steve
Stephen R. Simons
Software Development
The Academy of the New Church
STAIRS Project - www.th
1 - 100 of 143 matches
Mail list logo
