>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:User &
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
It would be nice to have an option for mysqldump to put the building of
indexes after the insert statements to speed up loading.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.my
Hi,
I also did experience the same problem converting a 2 million + row table
from MYISAM to INNODB. It took 3 days! I had highlighted the problem to
Heikki. (thanks Heikki for the response previously :)).
In my case, there was no UNIQUE KEY for the table, but just an index on
There are many different things that could cause this error. Did you check
the mysql error log for helpful information?
Most likely the problem is not with Apache, its either mysql or your
application. One source of that error message is mysql crashing and
burning... I have seen it a few times on
>Description:
This problem is being experienced on both MySQL 4.0.0 and 4.0.1.
Currently the system's timezone is set to PST, and MySQL's timezone variable
is PST (no problem there)
However if I do a NOW() on the system, the returned result is 8 hours earlier
that the cur
I'm sorry if I'm bothering people, some times I get the
feeling that I am, so please let me know if I'm out of line.
So now I've figured out that I need to use the
skip-show-database option which I have added to the my.cnf
file under [mysqld]. When I do this now and log in using
MySQLGUI as a
I'm fairly certain this is a bug. It's on 3.23.46-max and the changelog for
.47 doesn't mention it.
I have 2 servers using replication. Server1 is used by client machines and
all updates are to it. Server2 stays in perfect sync with it and logs all
updates to it's own binary log. I then use mysql
Hi,
> I've granted a user ALL PRIVILEGES on a particular database
> and when they log in using MySQLGUI they can see all the
> databases on the server. Even though they can't do anything
> with them, I would prefer if they didn't see them at all.
> Any ideas?
Check out: http://www.mysql.com/
I posted about this before and got nothing back so I guess I
should take it a step at a time.
I've granted a user ALL PRIVILEGES on a particular database
and when they log in using MySQLGUI they can see all the
databases on the server. Even though they can't do anything
with them, I would pre
Dominique,
At 05:45 AM 1/15/2002 -0800, Steve Edberg wrote:
>See doc sections:
>
> http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html
>and
> http://www.mysql.com/doc/C/R/CREATE_TABLE.html
>
> From the CREATE TABLE docs:
>
> "The FOREIGN KEY, CHECK, and REFERENCES cla
Has anyone received the following [Exhibit 1] when building mysql 3.23.47 on
Solaris 8? I am following
the directions from the source installation web page on mysql.com.
Thanks for any info,
Ryan
[Exhibit 1]
gcc -DUNDEF_THREADS_HACK -I./../include -I../inc
lude -
Hi!
> "Rich" == Rich Foreman <[EMAIL PROTECTED]> writes:
Rich> Hi,
Rich> I have two servers (one remotely hosted, and one locally) that I would like
Rich> to have the same database on for backup purposes.
Rich> I would like the two databases to synchronize automatically and all the time.
Ben Curran wrote:
> If one has created a table, with a key using auto_increment, how does one
> Insert data into it?
Data is automatically inserted for you ;-)
> If my table consists of (inID (primary key, auto incremented), employeeID
> (foreign key) time, date).
> if I use
> $dbh->do("IN
Sorry if this is a newbie question, I've been through the manual, still
can't figure it out.
If one has created a table, with a key using auto_increment, how does one
Insert data into it?
If my table consists of (inID (primary key, auto incremented), employeeID
(foreign key) time, date).
if I u
I'm using the:
LOAD DATA LOCAL INFILE "/home/filename.txt" INTO TABLE list;
which works just fine. Only problem is the date column
which is formatted as such "4/11/1970" comes out as "-
00-
00"
The date field is setup as Field: "s_date", Type: "date",
Null, "YES", Key: BLANK, Default: "Nul
The file in the /etc/rc.d/init.d is likely called S95mysql, and you CAN add
that parameter to that file. You'll need to edit the file, and add something
like this:
/opt/mysql/bin/mysqld \
--basedir=opt/mysql \
...
--skip-grant-tables \
...
>> /var/log/mysql/mysql.err 2>&1
The ...'s above are oth
In the last episode (Jan 15), Rich Foreman said:
> I have two servers (one remotely hosted, and one locally) that I
> would like to have the same database on for backup purposes. I would
> like the two databases to synchronize automatically and all the time.
>
> Is there currently any way to do t
Hi,
I have two servers (one remotely hosted, and one locally) that I would like
to have the same database on for backup purposes.
I would like the two databases to synchronize automatically and all the time.
Is there currently any way to do this?
Remote server: FreeBSD running MySQL 3.23.40
L
I'm trying to change the root password for mysql. This is the first time
I've tried to change the password and I can't get it to work. Below is the
error message I get:
[root@localhost bin]# ./mysqladmin -u root -p password 'new-password'
Enter password:
./mysqladmin: connect to server at 'loca
Hi , I would need help with the syntax for this:
I have Table1 and Table2. Table2 consists only of records that also exist in
Table1 (duplicates), and I wish to delete all the records in Table1 that are
matched in Table2, while keeping the rest of the records in Table1 intact.
Can anyone help?
T
"Jay Paulson" <[EMAIL PROTECTED]> writes:
> I'm running RedHat 7.1 and I'm trying to run mysql. I've gone and run the
> mysql_install_db
Not good. If you had just started the script, it would have been done
automatically - as it is, you created a set of files you can't access
(root owns them,
It should be PrintError (capital 'E').
ie.
---
$dbh = DBI->connect($dsn, $user, $pwd,{PrintError =>
0, RaiseError => 1});
Nicholas
-Original Message-
From: Investor [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 2:43 PM
To: [EMAIL PROTECTED]
Subject: Error with code utilizin
I'm running RedHat 7.1 and I'm trying to run mysql. I've gone and run the
mysql_install_db then I try to run the mysqladmin -u root -p password
'new-password' and I get the following error:
error: 'Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)'
Check that m
On Tue, Jan 15, 2002 at 01:11:34PM -0800, James Montebello wrote:
>
> If the client closes the connection grace fully (using the MySQL
> handshaking to close the connection), then it will be cleaned up.
Yep.
> If the client severed the connection w/o performing the close
> handshake (say, if it
On Tue, Jan 15, 2002 at 02:59:05PM -0600, Greer, Darren (MED) wrote:
>
> If say, that client closes the connection at some point in the
> future...that will clean up then?
Then the entry will vanish from the list.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (4
If the client closes the connection grace fully (using the MySQL
handshaking to close the connection), then it will be cleaned up. If the
client severed the connection w/o performing the close handshake (say,
if it closed the socket, or simply exited, which also closes the socket),
then it won't
If say, that client closes the connection at some point in the
future...that will clean up then? Or has the connection been severed?
-Original Message-
From: James Montebello [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:59 PM
To: Greer, Darren (MED)
Cc: '[EMAIL PROTECTED
Is there an equivalent table to Oracle's ALLTABLES?
Thanks,
Bret
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
Hello
I'm getting this error when trying to issue a "grant" command:
Can't find any matching row in the user table
What does this mean? Thist just started popping up the other day. The
command I'm executing is:
grant all on dn1024.* to 'dn1024' identified by 'hispassword';
Any help is appre
Cool. Thanks, John.
--Walt
-Original Message-
From: John Kemp [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 1:06 PM
To: Weaver, Walt
Cc: [EMAIL PROTECTED]
Subject: Re: innoDB confusion
Walt,
It'll go to the database_machine_name.err file on that machine.
John
Weaver, Wa
Walt,
It'll go to the database_machine_name.err file on that machine.
John
Weaver, Walt wrote:
> Heikki,
>
> I must be missing something really simple here, but I can't get the InnoDB
> Monitor to work. I created the innodb_monitor table with "create table
> innodb_monitor(a int) type=innodb;
This is caused by a connection that's still held open by a client, or
(more commonly) by a connection that wasn't closed gracefully by the
client. One of the oddities of TCP is that one end of the connection
won't "know" that the other end has dropped the connection until it
tries to write somet
Heikki,
I must be missing something really simple here, but I can't get the InnoDB
Monitor to work. I created the innodb_monitor table with "create table
innodb_monitor(a int) type=innodb;"
What do I do next? The manual says mysqld will print the output to stdout. I
guess I'm confused as to how
Hello again all. Thanks for the help on the query time issue, I have
begun a transition.
I have another question. I have some queries which are apparently going
into a "Sleep" mode in my database. Can anyone point me in the right
direction on this for more information?
Thanks,
Darren
+---
This is a bit strange, but I was writing code
and adding some select statements that seemed to be
working fine until about the 5 th one, ...
then i get errors :
I am a bit of a newbie at mysql & dbi.
any help much appreciated
Error:
Cant set DBI::db-HASH(0x1b73b70->{Printerror}:
unrecong
Thanks again,
It is becoming relatively clear now. Sounds like for the most part,
once InnoDB is set up, everything is handled like a 'normal' MyISAM
table with InnoDB simply adding the transactional support. Does Michael
Kofler's book discuss a lot of these types of things? The InnoDB
mate
Hi there. I'm trying a binary install of MySQL for OS X. Can anybody help
me? The directories are messed up, so it doesn't know where to look for it.
Where should I have the master folder for MySQL?
Cheers.
@@@ Rich Fortnum / Viaduct Productions / Toronto (EST)
@@@ Web Design / Databases /
Aaron,
"Rutledge, Aaron" wrote in message ...
>
>Woah...
>
>Heikki Tuuri wrote:
>"With some work, yes. innodb_table_monitor prints the internal schema of
>InnoDB. There are fewer column types inside InnoDB than in MySQL. For
>example, a DATE column will appear as an integer."
>
>Now I am confused
> Then I tried to set a password for the MYSQL root user and I get the
> following error.
>
> ./bin/mysqladmin -u root -p password 'christ1'
> Enter password: ***
>
> ./bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password:
Woah...
Heikki Tuuri wrote:
"With some work, yes. innodb_table_monitor prints the internal schema of
InnoDB. There are fewer column types inside InnoDB than in MySQL. For
example, a DATE column will appear as an integer."
Now I am confused again. Do you only have access to column types
specifi
The added complexity frightens me a little. It seems a little
black-boxish to me right now. I am sure it is only a matter of getting
use to and working with the architecture. The idea of a separate
table-handler in the RDBMS seems very foreign when you come from the
Oracle world. However, I ca
Hello all,
Is there a roadmap for MySQL releases, and in particular when it the eta for
4.1?
Kind regards
Emmanuel
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi!
-Original Message-
From: Philip Molter <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, January 15, 2002 8:24 PM
Subject: Re: innoDB confusion
>On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote:
>: Hi!
>:
>:
Hi,
> -Original Message-
> From: Frankie Cooke [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 9:48 AM
> To: [EMAIL PROTECTED]
> Subject: My ODBC Error
>
>
> Hello All
>
> I can currently connect to a Mysql database on my local machine, a windows
> o/s. However, when I t
On Tue, Jan 15, 2002 at 08:17:53PM +0200, Heikki Tuuri wrote:
: Hi!
:
: "Weaver, Walt" wrote in message ...
: >Do a "show table status" at the mysql prompt. Under "type" you should see
: >InnoDB.
:
: Yes, and in really problematic situations, where you have lost your .frm
: files, for example, y
Hi,
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 7:51 AM
> To: [EMAIL PROTECTED]
> Subject: MySQL -> Win SQL2k DTS -> MySQL
>
>
> Hello,
>
> Has anyone successfully implemented using a Microsoft SQL 2000 DTS
> package to
Hi,
>
> Hallo,
>
> Im writing an Visual Basic 6 application, using MDAC 2.1 and MySql ODBC
> 2.50.38.
>
> In some part of this application I like to know the processes that are
> running on MySql. I'm using "SHOW PROCESSLIST" expecting a recordset back
> like in "SHOW STATUS". I'm getting an
Hi!
"Weaver, Walt" wrote in message ...
>Do a "show table status" at the mysql prompt. Under "type" you should see
>InnoDB.
Yes, and in really problematic situations, where you have lost your .frm
files, for example, you can use innodb_table_monitor as explained in the
InnoDB online manual.
Bes
Pierre,
I tested this with versions 3.23.46 and .48 on Linux and they worked ok:
mysql> CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL,
PRIMARY
-> KEY(COD)) TYPE=INNODB;
Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIM
To see stats on a table from mysql itself:
show table status from database-name like 'table-name' ;
You'll see stats about the number of rows, and the amount of free space
(for an Innodb table) also what table type is used for that table.
John
Rutledge, Aaron wrote:
> One final question, and
Do a "show table status" at the mysql prompt. Under "type" you should see
InnoDB.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Rutledge, Aaron [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 15, 2002 10:57 AM
To: Mysql List (E-mail)
Subject: RE: innoDB confusion
One fina
I installed the binary of mysql 3.23.39 with the following steps and it
started fine
ln -s mysql-VERSION-OS mysql
cd mysql
scripts/mysql_install_db
chown -R root /usr/local/mysql
chown -R mysql /usr/local/mysql/data
chgrp -R mysql /usr/local/mysql
chown -R root /usr/local/mysql/bin
bin/s
It's not my perl code, that error comes from webmin when I try to run that
query. It's okay though, I have solved the problem, I'm just saving the date
and the time separately now and it all works great. Thank you for the help
(C:
>From: "Daniel Rosher" <[EMAIL PROTECTED]>
>Reply-To: <[EMAIL P
One final question, and I am done. You have helped me
tremendously--thank you. Wow, I really didn't expect the developer of
the software to answer my questions--this is terrific.
Is there way to verify that the tables I create are in the InnoDB
tablespace? I am assuming that if I set 'defaul
Hello All
I can currently connect to a Mysql database on my local machine, a windows
o/s. However, when I try and do this on unix - get the error:
Vbscript Runtime error 'ASP 0185 : -2147467259'
Data source name not found or no default driver specified
include/dbconnectcrop.asp,line 11
Line
Hi,
I am trying two create two innodb tables:
1.
CREATE TABLE FIRST (NAME VARCHAR(15), COD VARCHAR(10) NOT NULL, PRIMARY
KEY(COD)) TYPE=INNODB;
2.
CREATE TABLE SECOND (ID INT NOT NULL, F_COD VARCHAR(10), PRIMARY
KEY(ID), INDEX PAR_IND(F_COD), FOREIGN KEY(F_COD) REFERENCES FIRST(COD))
TYPE=INNOD
Has anyone had a chance to try out the new MySQL Studio product
(http://www.mysqlstudio.com/feature.php3)? There doesn't appear to be any
kind of demo, ad while it is only $70, I figured I'd check with all of you
before trying it.
What I would really like is something akin to ER Studio and other
Aaron,
-Original Message-
From: Rutledge, Aaron <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Date: Tuesday, January 15, 2002 7:13 PM
Subject: RE: innoDB confusion
>Thank You Heikki,
> That information helps a lot. A couple quick questions if you dont
>mind:
>
>In regards
Ronnie, I'm copying this to the list so it ends up in the archive for
anyone to use in future.
In answer to your question about the floating IP for the master, I'm
using heartbeat, more at http://www.samag.com/documents/s=1146/sam0109c/0109c.htm
My semi-scripts and explanations are at the bottom
Getting more problems again?
- Forwarded message from ORBZ Spam Report Reply <[EMAIL PROTECTED]> -
Return-Path: <[EMAIL PROTECTED]>
Received: from orbz.org ([EMAIL PROTECTED] [205.231.149.25])
by doctor.nl2k.ab.ca (8.12.2/8.12.2) with SMTP id g0FGCG2O011901
for <[EMAIL PR
Heikki,
I didn't config the log that big, but the buffer pool is using 1GB of
memory, and yes, the UNIQUE index is definitely causing a lot of disk I/O!
I will be very happy to see your change, and thanks for (as usual) being
so quick to make changes to an already very welcome addition to MySQ
Hello,
Has anyone successfully implemented using a Microsoft SQL 2000 DTS package to copy
data from one mysql database into another mysql database? I am getting some errors
pertaining to 'cannot insert blob fields'. -which they are not blob fields. I've tried
this on text, char, varchar, tinyt
Hi Bryan,
Start with this:
% mysqldump --help
From: Bryan McCloskey <[EMAIL PROTECTED]>
> ...make a copy of my database
% mysqldump --opt database_one > copy.sql
> ...data itself is not important...
> ...better if I could _not_ copy the thousands of rows...
% mysqldump --opt -d data
Maybe it has something to do with the MySql version and OS i'm using:
I'm running 3.23.42-max-nt on a Win2000 system, using BDB tables.
Nuno A. S. Gonçalves
[EMAIL PROTECTED]
- Original Message -
From: "Javier Armendáriz" <[EMAIL PROTECTED]>
To: "Mailing list MySql" <[EMAIL PROTECTED]
I am attempting to make a copy of my database, so that I will have one copy
that my scripts in development can tinker with, while the functional version
remains safe and unchanged. However, I am having difficulty figuring out how
to do this. All that is important is that I create a copy of the
I really don´t undarstand
My Linux is working fine in a situation like yours. I´ve simulated your
situation
mysql> use db2;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select * from ta
Nuno Gonçalves writes:
>
>
> - Original Message -
> From: "Gerald Clark" <[EMAIL PROTECTED]>
> To: "Nuno Gonçalves" <[EMAIL PROTECTED]>
> Cc: "Mailing list MySql" <[EMAIL PROTECTED]>
> Sent: Tuesday, January 15, 2002 2:35 PM
> Subject: Re: MySQL can't tell the difference between two data
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Nuno Gonçalves" <[EMAIL PROTECTED]>
Cc: "Mailing list MySql" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 2:35 PM
Subject: Re: MySQL can't tell the difference between two databases???
> Is db2 a symlink to db1?
Is db2 a symlink to db1?
Nuno Gonçalves wrote:
>Hi!
>
>I've got two mysql databases that have exactly the same structure (same
>tables using BDB, columns, etc.) and different data.
>
>When I try to do a select on a table from database A, I get the right
>results, but when I try the same select o
Looks like someone entered a negative number for EventId, or it just
reached its maximum value.
Check its maximum and minimum values.
Change it to an unsigned int.
Xavier NOPRE wrote:
>Hi,
>
>I try to insert a new record in a table. The key is an automatic ID.
>The insert is refused due to du
It sounds like two problems to me.
1. Check/repair your tables;
2. Check your return codes in your PHP script, and take appropiate action.
Randall Stone Tayler wrote:
>>From a SSH I run a query and get the following:
>
>ERROR 1030: Got error 134 from table handler
>
>>From a browser, when I ru
Hi,
What Application Server do you use?
I think JDBC connection has been disconnected from MySQL
because that connection has not used for a long time.
This error depends on Application Server.
shashidhara n wrote:
>
> hello
>
> we are running web application using apache as web server
Ross Davis writes:
> On the front screen of the mysql site the mysql-Max 3.23.47 is listed as
> stable.
>
> However on the download page it is said to be considered a beta yet?
>
> The reason that I am asking this question, is that the Borland Delphi
> Developers will not release a new versi
See doc sections:
http://www.mysql.com/doc/A/N/ANSI_diff_Foreign_Keys.html
and
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
From the CREATE TABLE docs:
"The FOREIGN KEY, CHECK, and REFERENCES clauses don't
actually do anything. The syntax for them is provided only fo
- Original Message -
From: "Javier Armendáriz" <[EMAIL PROTECTED]>
To: "Mailing list MySql" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 12:49 PM
Subject: RE: MySQL can't tell the difference between two databases???
> What happens if you try select * from db1.products and select
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
I want to store long binary data in mysql
I set max_allowed_packet size to 50M, but I can`t stor data
mysql error code is ' 020114 17:34:30 Aborted connection 2 to db:
'lake' user: 'lake' host: `alia' (Got an error reading communication
packets)'
and jdbc error code is ' java.sql.SQLException:
Hi!
All you have to do is follow instructions from the README document.
Enter Options dialogue, fill up all entries carefully and click on
Save.
In "SQL init command " set a location of the socket file, if both
client and server are running on the same Unix machine.
In any case, just follow in
Aaron,
please look at http://www.innodb.com/features.html,
http://www.innodb.com/division.html, and http://www.innodb.com/ibman.html
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and la
John,
did you configure innodb_buffer_pool_size and InnoDB log files big? Look at
the online manual on the recommended sizes.
If the table is very big, then UNIQUE secondary keys will cause a lot of
disk i/o, because a disk read is required to check the constraint for each
row, and the insert bu
What happens if you try select * from db1.products and select * from
db2.products;???
Doing that does the same?
> -Mensaje original-
> De: Nuno Gonçalves [mailto:[EMAIL PROTECTED]]
> Enviado el: martes, 15 de enero de 2002 13:24
> Para: Mailing list MySql
> Asunto: Re: MySQL can't tell
Ross,
"Ross Davis" wrote in message ...
>On the front screen of the mysql site the mysql-Max 3.23.47 is listed as
>stable.
>
>However on the download page it is said to be considered a beta yet?
the download page is lagging behind. The MySQL manual describes it as gamma,
which is also the offici
It's something like this:
mysql> use db1
mysql> select * from products;
++-+-+--+--+
| Id | Ref | Version | Type | Name |
++-+-+--+--+
| 1 | XXX | 1 |1 | XXX |
++-+-+--+--+
1 row in set (0.27 sec)
mysql> use db2
Thank you for your report.
We shall take a look at it.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www
On Tue, 15 Jan 2002, Nuno Gonçalves wrote:
> The only way I seem to be able to access the data on database B is to
> remove the other database from MySQL. >From my tests it seems that MySQL
> only uses the table name to access the data (not using also the database
> name).
The sql queries you ar
Hi!
I've got two mysql databases that have exactly the same structure (same
tables using BDB, columns, etc.) and different data.
When I try to do a select on a table from database A, I get the right
results, but when I try the same select on the same table from database B, I
get the results fro
- Original Message -
From: "Peter Dunham" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 12:03 PM
Subject: MATCH vs LIKE
> I am trying to speed up keyword searches using MATCH AGAINST instead of
> like, but am getting unexpected results.
>
> I had ass
I am trying to speed up keyword searches using MATCH AGAINST instead of
like, but am getting unexpected results.
I had assumed that using 'WHERE MATCH fulltext(column.name) AGAINST
'searchterm' would produce the same results as 'WHERE column.name LIKE
'%searchterm%' but it doesn't seem to.
Ac
Hi the list,
I try to create tables with integrity constraint but it seems no running.
I've got the next script :
create table USERS
(
USER_CODE INT(8) not null,
USER_NAME VARCHAR(30)not null,
primary key (USER_CODE)
)
;
cre
Hi,
I try to insert a new record in a table. The key is an automatic ID.
The insert is refused due to duplicate key, but the key does not
exist. Why ? Is it a bug ?
Any idea ? Some help ?
Thanks
Xavier
Details:
The colums of the table:
++--+--+-+-
FYI
-christian-
On Mon, Jan 14, 2002 at 11:54:42PM +0100, Artur R.Czechowski wrote:
> Package: mysql-client
> Version: 3.23.46-2
> Severity: minor
>
> mysqldump: invalid option -- Q
> long GNU option --quota-names used instead works
> Please fix documentation or client :)
>
> Sincerelly
>
Hallo,
Im writing an Visual Basic 6 application, using MDAC 2.1 and MySql ODBC
2.50.38.
In some part of this application I like to know the processes that are
running on MySql. I'm using "SHOW PROCESSLIST" expecting a recordset back
like in "SHOW STATUS". I'm getting an runtime-error -2147467259
Hi,
I recently download and install a compiled version of MyCC for Windows into
my PC. The installation is successful and the outlook is quite user
friendly. I register a server created by MySQL and when I want to browse for
the tables inside a database, I get an window error showing the message:
93 matches
Mail list logo
