Jon,
- Original Message -
From: Jon Frisby [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 07, 2002 9:39 PM
Subject: Replication and temp tables...
Using 4.0.2 for both server and client, replicating the following query
seems to have caused a crash on the
Jon,
- Original Message -
From: Jon Frisby [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, November 07, 2002 9:39 PM
Subject: Replication and temp tables...
Using 4.0.2 for both server and client, replicating the following query
seems to have caused a crash on the
Hello All...
How to remove MySQL installed using tar.gz?
Thanks.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread,
If you have compiled the files from the source then a 'make uninstall'
should work.
Hope this helps
Tim
-Original Message-
From: Fajar Priyanto [mailto:fajarpri;arinet.org]
Sent: 08 November 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: How to manually remove mysql
Hello All...
How to
Hi,
I downloaded mysql and i try to install it now (on slackware)
It's unpacked, i did everything as root.
But ./configure ends with mysql ended and ./bin/mysqld ends also because
it can't write to a file (or more).
Now i understand when programs need to write to files etc that permissions
must
Hi there,
I have two tables wich I need to join together. I use INNER JOIN but there
is one problem.
I have a master table, where is a column where I have a WHERE clause, wich I
use as criterion for SELECT.
The second table has some details for rows, wich fulfil the WHERE clause.
I have an ID for
Hmm, thanks all..
But, before I remove the mysql installation, I want to restart it first so
that it reads my.cnf file, and see if it corrects the problem.
How do I restart the mysql from command prompt?
I'm using RH6.2 without XWindows.
Thanks.
David,
Wednesday, November 06, 2002, 10:00:45 PM, you wrote:
DAF - Original Message -
DAF From: Victoria Reznichenko [EMAIL PROTECTED]
DAF To: [EMAIL PROTECTED]
DAF Sent: Wednesday, November 06, 2002 11:47 AM
DAF Subject: re: Problem creating InnoDB tables.
David,
Tuesday, November
Kevin,
Tuesday, November 05, 2002, 12:55:41 PM, you wrote:
KD I've shrunk the dataset down as far as I can to continue to reproduce this
KD issue, but the .gz file is still 1.3MB
KD Running this on 4.0.3 produces the correct results. 4.0.4 doesn't.
KD fetch http://www.dragondata.com/ditsy.gz
Fajar Priyanto wrote:
Hmm, thanks all..
But, before I remove the mysql installation, I want to restart it first so
that it reads my.cnf file, and see if it corrects the problem.
How do I restart the mysql from command prompt?
I'm using RH6.2 without XWindows.
/etc/init.d/mysqld restart
Max
Hi. I hope this is the right place to discuss this, now that the drivers are
part of the official MySQL stuff. If not, please let me know where I should
post this. Thanks.
I've been using the 2.0.14 version of the drivers, and just recently
switched to using the pooled connections supplied by
I executed the following statement:
UPDATE Table1
SET date_adm=date_adm+2
where date_adm='2002-10-30';
the result was...-00-00
I´m working with Mysql-max-nt 3.23.39.
What´s wrong?
best regards,
Sil
-
Before posting,
Hi, Rick,
Hi. I hope this is the right place to discuss this, now that the drivers
are
part of the official MySQL stuff. If not, please let me know where I
should
post this. Thanks.
The Java list - [EMAIL PROTECTED] - would probaby be more appropriate
than the general list, but otherwise
I am new to MySQL and I am attempting a new project to help me learn.
I the past I have used a Boolean data type for True/False, Yes/No type data.
What data type should be used to achieve the storage of this type of data in
MySQL?
I have bought the reference manual (a good buy IMHO) but so far
Putte,
Friday, November 08, 2002, 11:09:11 AM, you wrote:
PK I have two tables wich I need to join together. I use INNER JOIN but there
PK is one problem.
PK I have a master table, where is a column where I have a WHERE clause, wich I
PK use as criterion for SELECT.
PK The second table has some
Adam,
Friday, November 08, 2002, 5:06:47 AM, you wrote:
AY Ok, I tried using the QUOTE() function exactly how they have it on the string page
in the online manual. Needless to say, this has not worked at all...I get an sql
syntax error every time. If
AY anyone else has had this problem or
mazin,
Friday, November 08, 2002, 5:50:55 PM, you wrote:
m I have been facing this problem since from many months.
m The problem is that when i try to connect mysql from the remote place using
m mysqld -h 192.168.1.1 -u temp -p
m it ends up with the error ERROR 2013: Lost connection to MySQL
Fajar,
Friday, November 08, 2002, 11:37:44 AM, you wrote:
FP But, before I remove the mysql installation, I want to restart it first so
FP that it reads my.cnf file, and see if it corrects the problem.
FP How do I restart the mysql from command prompt?
FP I'm using RH6.2 without XWindows.
Philippe,
Friday, November 08, 2002, 10:51:14 AM, you wrote:
PD I downloaded mysql and i try to install it now (on slackware)
PD It's unpacked, i did everything as root.
PD But ./configure ends with mysql ended and ./bin/mysqld ends also because
PD it can't write to a file (or more).
PD Now i
Yves,
Friday, November 08, 2002, 5:31:28 AM, you wrote:
YA Hope this makes sense, I am totally new with using MySQL.
YA How would I create a unique ID number for a table, for, say, a field named
YA UserID for example?
Take a look at AUTO_INCREMENT column:
You could use an integer (0 or 1) or an enum with the values 'y' or 'n'
-Original Message-
From: Tony Roberts [mailto:troberts;momuk.com]
Sent: Friday, November 08, 2002 4:26 AM
To: [EMAIL PROTECTED]
Subject: True/False
I am new to MySQL and I am attempting a new project to help me
Use the data type BOOL which takes a 1 or 0 character or use CHAR and then
you can use Y or N for Yes/No.
Regards,
'Gbamila
- Original Message -
From: Tony Roberts [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 08, 2002 12:26 PM
Subject: True/False
I am new to MySQL and
Hi,
You can try the following.
Store the result of your query into a temporary table, say tp, with two
columns tc (ticketID) and pname (pipelineName).
Run the following query :
select concat(select @c:='';,select tc,
(@c:=concat_ws(,,@c,pname)) as x, length(@c) from tp where tc=,
tc, order by
hi,
i am trying to move one of the databases we have in access
to mysql and i have come accross a query that mysql doesnt like:
SELECT Managers.Manager, Agents.Agent, Modules.Module, Messages.MLevel,
Messages.Title, MessageInstance.Name, MessageInstance.Info, PolicyRuns.JobNo,
Policies.Policy
I have 3 identical tables with approx 150,000 row each. These tables
have currently no indexes. If I do a specific query on each table it
takes approx 3 seconds per table. Doing the same query on the MERGE
tables takes approx 8.5 seconds.
I then created an index on the tables (identical index on
Is there a tool for doing a quick port from MS Access
to MySQL?
Or must you manually create all the tables sql
statements in MySQL and then export the MS Access data
to a comma delimited file... then import it into
MySQL?
Thanks for any help - tmb
myodbc works fairly OK for me.
On Fri, 2002-11-08 at 14:17, tmb wrote:
Is there a tool for doing a quick port from MS Access
to MySQL?
Or must you manually create all the tables sql
statements in MySQL and then export the MS Access data
to a comma delimited file... then import it into
Hi,
Use DBTools DBManager. It import/converts from MSAccess, DBF (Dbase,
CLipper, FoxPro), Paradox, ODBC e MSExcel into MySQL with just a few
clicks.
Of course it only works in Windows.
http://www.dbtools.com.br
[]s
Crercio O. Silva
- Original Message -
From: tmb [EMAIL PROTECTED]
To:
Use enum.
Rgds
Insane
SQLyog - The Definitive Win32 GUI for MySQL
http://www.sqlyog.com
- Original Message -
From: Tony Roberts [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 08, 2002 4:56 PM
Subject: True/False
I am new to MySQL and I am attempting a new project to
According to http://www.mysql.com/doc/en/Column_types.html
BIT BOOL -- These are synonyms for TINYINT(1).
DÆVID.
-Original Message-
From: Oluwagbamila Oyekanmi
Use the data type BOOL which takes a 1 or 0 character or use
CHAR and then you can use Y or N for Yes/No.
Or how
20021030 + 2 = 20021032
That is not a valid date.
You can't use regular math functions on dates.
Check out the date and time functions in the manual.
Silmara wrote:
I executed the following statement:
UPDATE Table1
SET date_adm=date_adm+2
where date_adm='2002-10-30';
the result
Yep, ODBC works great.
Make a connection from Access to MySQL and mirror the access db into MySQL.
STIBS
myodbc works fairly OK for me.
On Fri, 2002-11-08 at 14:17, tmb wrote:
Is there a tool for doing a quick port from MS Access
to MySQL?
Or must you manually create all the tables
i am using perl dbi with dbd::mysql. i know that using the dbi function,
$dbh-tables (), will list all the tables in a database. is there a function
that will show all the databases on a server?
thanks,
shon
-
Before posting,
i need to create a user (besides root) that can show databases, show tables
from every database, lock all tables, and flush all tables. what permissions
should i grant to this user?
thanks,
shon
[don't bounce me as spam]
mysql
sql
query
eureka! i found it!
@dbs = $dbh-func('_ListDBs');
-Original Message-
From: Shon Stephens [mailto:sstephens;corp.goamerica.net]
Sent: Friday, November 08, 2002 9:45 AM
To: '[EMAIL PROTECTED]'
Subject: perl dbi and mysql question
i am using perl dbi with dbd::mysql. i know that using the
No clue of dbi/dbd but the query SHOW DATABASES does what it tells.
STIBS
- Original Message -
From: Shon Stephens [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 08, 2002 3:44 PM
Subject: perl dbi and mysql question
i am using perl dbi with dbd::mysql. i know that
Is the implementation of this different than the docs say? According to
the manual, I didn't think this would work:
* The target table of the INSERT statement cannot appear in the FROM
clause of the SELECT part of the query because it's forbidden in ANSI
SQL to SELECT from the same table into
Of course, you could have also used:
$stmt = $db-prepare(show databases);
Peter
^_^
-Original Message-
From: Shon Stephens [mailto:sstephens;corp.goamerica.net]
Sent: Friday, November 08, 2002 9:50 AM
To: Shon Stephens; '[EMAIL PROTECTED]'
Subject: RE: perl dbi and mysql question
yeah, but i was looking for a function. mostly just to see if a matching
function to dbh-tables() existed.
-Original Message-
From: Grigor, Peter [mailto:pgrigor;aseedge.com]
Sent: Friday, November 08, 2002 10:07 AM
To: 'Shon Stephens'; '[EMAIL PROTECTED]'
Subject: RE: perl dbi and mysql
This style of insert does not work in MySQL. The two table names must
be different.
-Original Message-
From: Alan McDonald [mailto:alan;meta.com.au]
Sent: Thursday, November 07, 2002 9:56 PM
To: Doug Coning; [EMAIL PROTECTED]
Subject: RE: Copy Records in a table...
insert into
is there a way to have mysql skip columns from the data file when loading the
data?
i am getting a text delimited data file from an outside source that is
updated daily. however the data is defined as having 10 blank fields in it,
and in the first 9000 records 7 more fields are just not used,
grant all ?
-Original Message-
From: Shon Stephens [mailto:sstephens;corp.goamerica.net]
Sent: Saturday, November 09, 2002 1:46 AM
To: '[EMAIL PROTECTED]'
Subject: mysql permissions
i need to create a user (besides root) that can show databases, show tables
from every database, lock all
I'm currently trying to figure out a solution for the following situation:
A small event-management company will expand to a site in another town.
The existing office runs a homemade MS-Access DB application that I want
to migrate to a more viable database server like MySQL.
The two sites will
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on
Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3.
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: Warning: MySQL Connection Failed: Access denied for
user: 'root@jws-portald' (Using
Shon,
Friday, November 08, 2002, 4:46:19 PM, you wrote:
SS i need to create a user (besides root) that can show databases,
Use Show_db_priv after 4.0.2, before 4.0.2 user can see all databases
if mysqld is running without --skip-show-database option.
SS show tables
SS from every database,
User
Silmara,
Thursday, November 07, 2002, 10:05:37 PM, you wrote:
S I executed the following statement:
S UPDATE Table1
S SET date_adm=date_adm+2
S where date_adm='2002-10-30';
S the result was...-00-00
S I´m working with Mysql-max-nt 3.23.39.
S What´s wrong?
Use DATE and TIME functions,
Jalene,
Friday, November 08, 2002, 1:29:53 AM, you wrote:
JJ I have a Redhat linux box which has MySQL 3.23.52 loaded on it. I have
JJ mysql front loaded on a windows xp box which I am trying to use to
JJ connect to the mysql server. The error I am getting when trying to make
JJ a connection
mysqladmin -u root password setpassword ? and dont use root for normal
access
-Original Message-
From: [EMAIL PROTECTED] [mailto:CZachary;wiley.com]
Sent: Saturday, November 09, 2002 2:51 AM
To: [EMAIL PROTECTED]
Subject: Error connecting to Mysql via Apache/PHP - Access Denied
(Newbie)
thank you victoria!
-Original Message-
From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net]
Sent: Friday, November 08, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: re: mysql permissions
Shon,
Friday, November 08, 2002, 4:46:19 PM, you wrote:
SS i need to create a user
Hammons Randy G SSgt 612 ACOMS/SCXX wrote:
Unfortunately this goes well beyond the scope of my original question.
Although the inputs that you all have provided thus far have been a very
good read, I still don't grasp the concept of defining a relationship. Is
it simply referring to a primary
i used this mysql_fix_privilege_tables hoping it would migrate about 100
user database privileges, but it doesnt seem to have done the job what else
do i need to do ? as i said before i dont particularly want to have to reset
and regrant everyones passwords.
-Original Message-
From: Dan
I've got to do a fresh install of mysql on a webserver (a new server, so it
isn't overwriting anything). Does anyone have any info as whether I should
use just MySQL or MySQL-MAX? What is the difference?
Thanks! :)
-Mike
-
never mind it worked now , had to restart the server heh
-Original Message-
From: Dan Rossi [mailto:daniel;electroteque.org]
Sent: Saturday, November 09, 2002 3:25 AM
To: Dan Rossi; [EMAIL PROTECTED]
Subject: RE: privileges when moving from mysql 3.23 to 4.0
i used this
whenever i try to execute a C file which uses the mysql_connect method
i get the following error.
undefined reference to mysql_connect
Please note that I have tried the following options.
gcc -lmysqlclient file.c
gcc -L /usr/lib/mysql -lmysqlclient file.c
gcc -L /usr/lib/mysql -I
On Thu, 7 Nov 2002, Chris Raymer wrote:
Yes, that is what I meant. Thank you for the clarification and response.
Any ideas on maximizing *server* performance besides the usual db-specific
optimizations like indexing? If not too much trouble, could you give me a
brief explanation why I would
I tried this. The error I received is: error: 'Access denied for user:
'root@localhost' (Using password: NO)'
Is there another option?
|-+
| | Dan Rossi |
| | daniel@electrote|
| | que.org
At 22:04 +0530 11/8/02, Rahul Amaram-RollNo.286 wrote:
whenever i try to execute a C file which uses the mysql_connect method
i get the following error.
mysql_connect() is obsolete. Use mysql_real_connect() instead.
undefined reference to mysql_connect
Please note that I have tried
At 9:39 -0600 11/8/02, Ray wrote:
is there a way to have mysql skip columns from the data file when loading the
data?
No. You'll be better off preprocessing the file first (or use your
temp file approach; that'll work, too).
i am getting a text delimited data file from an outside source
Hi,
Take a look in mysql.h.
#ifdef USE_OLD_FUNCTIONS
MYSQL * STDCALL mysql_connect(MYSQL *mysql, const char *host,
const char *user, const char *passwd);
int STDCALL mysql_create_db(MYSQL *mysql, const char *DB);
int STDCALL mysql_drop_db(MYSQL *mysql, const char *DB);
#define
mysql_connect() is deprecated function. Try using mysql_real_connect().
I've used and haven't experience any problems with it.
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql
_real_connect
Sean
-Original Message-
From: Rahul Amaram-RollNo.286
Hello All:
If I am adding a row to a table that has an auto-increment field,
is there a way to query MySQL for the value of that field, once the
new row is added?
TIA
--
Tim Johnson [EMAIL PROTECTED]
http://www.alaska-internet-solutions.com
http://www.johnsons-web.com
I think that the mysql function LAST_INSERT_ID() is what you need.
Tim Johnson wrote:
Hello All:
If I am adding a row to a table that has an auto-increment field,
is there a way to query MySQL for the value of that field, once the
new row is added?
TIA
--
Hi,
select last_insert_id();
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Tim Johnson [EMAIL PROTECTED]
To:
Hi ,
Is there a easy way to back up the mysql data base via scheduler
thanks
Stanley
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
On Fri, 2002-11-08 at 16:51, [EMAIL PROTECTED] wrote:
I am trying to connect to my Mysql DB via Apache and PHP, but I get the
following error: Warning: MySQL Connection Failed: Access denied for
user: 'root@jws-portald' (Using password: YES) in helloSql.php on line 3
Could not connect
Can
Several things.
Don't use root to connect remotely.
Run mysqld as a userid on the server not root.
You may need to grant on mysql database for more than localhost.
Such as
(Note this grants all privileges to all databases. See mysql docs
for restricted access)
GRANT * ON *.* TO 'userid'
I just installed the most recent version of MySQL with an RPM (through
webmin interface), but it doesn't seem to have installed a
mysqladmin.anyone know why? :)
Thanks!
-Mike
-
Before posting, please check:
Mysqladmin is seperate rpm
~K Black
-Original Message-
From: SpyProductions Support Team [mailto:support;spyproductions.com]
Sent: Friday, November 08, 2002 11:13 AM
To: [EMAIL PROTECTED]
Subject: MysQL Installation
I just installed the most recent version of MySQL with an RPM
On Fri, 2002-11-08 at 14:12, SpyProductions Support Team wrote:
I just installed the most recent version of MySQL with an RPM (through
webmin interface), but it doesn't seem to have installed a
mysqladmin.anyone know why? :)
Thanks!
-Mike
Probably you just installed the server
Hi,
Does version 2.23.52 supports the use of nested select?
I want to write a query based on a group where I do a count of something for
each group. In SQL Server 7 it would look something like this,
select
a.department
,(select count(*) from empdb where gender='m' and department=a.department)
Thanks to all for the responses. Especially to those who pointed
my to documentation.
Regards
-tim-
* Cliff [EMAIL PROTECTED] [021108 08:32]:
You can use the function : mysql_insert_id() to get the value you've just added.
Please see http://www.mysql.com/doc/en/mysql_insert_id.html for more
I have mysql installed and working on Solaris 9 using the binaries from the
mysql site. I have an NFS server running under Debian GNU/Linux 3.0. I am
able to mount NFS mounts on the Solaris box from the Linux box without any
problems. I'm able to read/write without incident.
Now here comes the
This is a test to the sql list. I sent a message concerning MySQL+NFS
problems and it didn't go through.
--Joe
--
Joe Stump
Affordable Computers, Inc.
800-864-2345 x113
-
Before posting, please check:
Hi :
I have a server with SCO Unixware 7.1.0 , I like install a Mysql Version
that includes Replication with other Mysql servers... Which version
could i install for this ???
Tomás García
-
Before posting, please check:
Well hells bells!
Would that be the 'Client programs (i386) (2.3M)' mentioned on the download
page? :)
Thanks,
Mike
-Original Message-
From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com]
Sent: Friday, November 08, 2002 2:17 PM
To: '[EMAIL PROTECTED]'; [EMAIL
Hi, Can anybody give me a simple example of using
PHP's mysql_query to perform mulitple mysql queries. I
am using MySQl 3.23, trying to use create temporary
table and insert ... select to overcome the lack of
union operation in that verion of MySQL.
Thanks!Qunfeng Dong
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 06 November 2002 20:48, Jeremy Zawodny wrote:
Actually, you should work with the current mysql maintainer for
Debian. I'm sure he'd be thrilled to have official help from MySQL
AB.
Of course I would not mind helping and assisting
At 11:25 -0800 11/8/02, [EMAIL PROTECTED] wrote:
Hi,
Does version 2.23.52 supports the use of nested select?
There is no such version. I assume you mean 3.23.52? Queries
such as you show below are not supported until 4.1.
I want to write a query based on a group where I do a count of
At 13:30 -0800 11/8/02, Qunfeng Dong wrote:
Hi, Can anybody give me a simple example of using
PHP's mysql_query to perform mulitple mysql queries. I
If you mean an example of a single call to mysql_query() that
performs multiple queries, no one will be able to show you
an example. It doesn't
Hi,
I have a mysql installed ona RedHat 7.3 machine. The problem is that I am
getting the error 127 many times. Each time I repair the table and after
some time (1-2 hours) it happens again. Any comments?
I am using the RPM shipped with Redhat 7.3.
Bellow are the logs:
Thanks in advance,
Hamid
Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the
server package, but MySql.com has it in the client's:
$ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin
/usr/bin/mysqladmin
/usr/share/man/man1/mysqladmin.1.gz
sql, query
~Kelly W. Black
PS IN the future check out
Hrm, upon further digging it seems that this may be the offending query:
# at 416149583
#021107 16:50:31 server id 1 log_pos 416149583 Intvar
SET INSERT_ID=6437606;
# at 416149611
#021107 16:50:31 server id 1 log_pos 416149583 Query thread_id=19890708
exec_time=0 error_code=0
SET
MySQLfront does it all
-Original Message-
From: tmb [mailto:topmailbox;yahoo.com]
Sent: Friday, 8 November 2002 23:18
To: [EMAIL PROTECTED]
Subject: How to port MS Access to MySQL ??
Is there a tool for doing a quick port from MS Access
to MySQL?
Or must you manually create
maybe it doesn't then in MySQL - it does elsewhere
Alan
-Original Message-
From: David Felio [mailto:david;ark.org]
Sent: Saturday, 9 November 2002 1:59
To: MySQL List
Subject: Re: Copy Records in a table...
Is the implementation of this different than the docs say? According
I know this is OT a bit, but now I need to either re-compile PHP to get
mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I
need to do this at all?
Even at rpmfind.net is seems hard to distinguish what it is I need. Is
there anyway to get a 'complete' PHP rpm somewhere?
Jon,
- Original Message -
From: Jon Frisby [EMAIL PROTECTED]
To: 'Heikki Tuuri' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 12:17 AM
Subject: RE: Replication and temp tables...
Hrm, upon further digging it seems that this may be the offending query:
# at
Alan,
1 - what is MySQLfront?
2 - where can I get it?
3 - does it run under Linux?
4 - is it open source /or free?
5 - or does it come with MySQL ??
thanks - tmb
--- Alan McDonald [EMAIL PROTECTED] wrote:
MySQLfront does it all
-Original Message-
From: tmb
Petre,
Where do I get MyOdbc ??
Does it run on linux?
thanks - tmb
--- Petre Agenbag [EMAIL PROTECTED] wrote:
myodbc works fairly OK for me.
On Fri, 2002-11-08 at 14:17, tmb wrote:
Is there a tool for doing a quick port from MS
Access
to MySQL?
Or must you manually create all the
In MS Access you define relationships between Key ID
fields by dragging a line on the screen from the
parent table to the child table.
So, if you are enforcing referential integrity you
can not delete data that is referred to by another
table or mess up the basic db structure... (think I
have
Try http://mysqlfront.sstienemann.de/ and wait a few seconds for the
download to start. MySQLFront has been discontinued by the author a couple
months back. See if you can get a copy before it gets pulled off the net.
It is very very good. :) It is free.
Mike.
At 04:59 PM 11/8/2002, you
-Mike
I know this is OT a bit, but now I need to either re-compile PHP to get
mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I
need to do this at all?
Not sure where PHP came into the picture here.
Let's not confuse phpMyAdmin with MySqladmin. Different animals all
tmb wrote:
In MS Access you define relationships between Key ID
fields by dragging a line on the screen from the
parent table to the child table.
Read up on referential integrity and InnoDB tables in the online docs at
http://www.mysql.com/doc/en
--
Michael T. Babcock
C.T.O., FibreSpeed
This may be a (hmmmpf) dumb question or maybe the docs say,
but I cannot find it.
When posting this list regarding sql, query, and other info :) does the
list server modify the posts to a maximum width? (For all using terminals
to browse?)
If so what is the line width? (80 characters?)
I
May be this was reported already.
I have windows 2000 using mysql version 4.0.3-beta-nt
When I ran a query like
select distinct a.* from tasks a, gnrlasoc b;
mysqld-nt.exe crashes.
I know this query makes no sense but it should not crush server
Eugene Bendersky
Hi there,
can anyone suggest how this query could have relevancy ordering put into it?
SELECT DISTINCT images.* FROM images
LEFT JOIN imagekeyword ON images.imageid=imagekeyword.imageid
LEFT JOIN imageformat ON images.imageid=imageformat.imageid
LEFT JOIN imagelocation ON
Hi!,
I hope someone a little more knowledgeable in mySQL can help me with this...
We just got a new box setup (standard mySQL install) called BoxA,
every time we try to connect to mySQL from a remote location(BoxB) we get
the Lost connection to MySQL server during query message.
The command
Description:
MySQL crashes when a remote computer attempts to make a standard
connection. Making a local connection does not cause this problem,
connecting to other systems does not cause this problem, but a connection
from a remote computer to mySQL immediately crashes mySQL.
The
VER: mysql-3.23.53-win.zip
Description:
If I launch MySQL 3.23.38, everything is fine. If I open tables,
creat db,
add records whatever, no problem. When I close MySQL my hard
drive is ? alot and I can do nothing except a hard reboot.
I have tried quitting immediatly after
Hi,
I'm being forced to use MS Outlook/MS Exchange to to all my email at work and
I cant seem to send mail to the mysql list. The list managert doesn't allow
attachments but for some reason Exchange or Outlook seem to insist on send
out the email as plain text AND html as MIME attachments.
Has
On Fri, Nov 08, 2002 at 10:25:01PM -0500,
[EMAIL PROTECTED] [EMAIL PROTECTED] is thought to have said:
Description:
MySQL crashes when a remote computer attempts to make a standard
connection. Making a local connection does not cause this problem,
connecting to other systems does not
1 - 100 of 105 matches
Mail list logo