On 26-Feb-2003 M Wells wrote:
Hi All,
I'm having problems creating a query to return a recordset from the
following situation:
I have two tables, one which contains member details, and the other
which contains details re: the groups to which the member belongs.
When a member logs into
Looks like we've mixed up two threads into one ;-)
As I understood from various forums and maillists, versions 4.x are
still in development state. The newest production version is 3.23.55,
am I right? Do you recommend this version for testing?
Regards,
Kirill
Egor Egorov wrote:
On Tuesday
i have made a simulation for horizontal aggregation in C++ but had a hard time
converting it to MySQL codes for me to create a function for MySQL?
how can i convert my C++ code inorder for it to be accepted and run in MySQL? thanks
_
how can i convert my C++ codes to become a new function for MySQL?
i am to embed a new feature for MySQL but i dont know if my code will work for mysql.
i have read that embedding would mean creating a new function for mysql.
MySQL is also written in C or C++ right? how can i convert my codes
I have downloaded phpmyadmin, and installed, well not really, I placed
it under /var/www/html, and decompressed therr, it generated its own
directory, and so, well I am getting an error msg:
cannot load MySQL extension,
please check PHP Configuration.
when I check the docs I get this solution
Why is the standard-receiver of a reply to the list, the original poster, not the list
itself?
- Original Message -
From: Bernhard Döbler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 9:58 AM
Subject: Re: Simple C API question
Hi Travis,
so far I see, you
On Wed, Feb 26, 2003 at 12:32:57AM -0800, DiAnNe iRiS aLeRta wrote:
i have made a simulation for horizontal aggregation in C++ but had a
hard time converting it to MySQL codes for me to create a function for
MySQL?
how can i convert my C++ code inorder for it to be accepted and run in
Yes , I had use this query statement in my MySQL server,
But I have a query about it.
Why are you use WHERE a.groupname=b.groupname AND members.id=b.memberid AND
a.memberid=1?
Can you give me a explain or give me a advise!
Thanks in advantage for help!
-Original Message-
From: Don
Has a quick overview of installation :
http://www.php.net/manual/en/ref.mysql.php
A whole load more tutorials :
http://www.domaincarecenter.com/php_programming_tutorials.htm
Jerry
- Original Message -
From: agc [EMAIL PROTECTED]
To: KH Chiu [EMAIL PROTECTED]
Cc: Jon Miller [EMAIL
Hi all,
Today I ran into a weird problem.
Normally, for each database there is one directory on the hard drive.
For every table, there are three files (.frm, .MYD, and .MYI). Now I want to
access the db and everything goes well. Trying to access certain tables
results in this error:
Error 1017 -
Have you done anything to the files by hand ?
I used to get this when I moved tables about and effected the permissions or
case of the extensions.
Jerry
- Original Message -
From: Daniel Geske [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 9:13 AM
Subject:
No, I didn't do anything at all. The server ran since months without any
problems, and then suddenly this..
I just found something that may be related:
A program started writing errors to a log file saying it couldn't insert
into one of the tables that is now missing and the log file grew up to 2
On 26-Feb-2003 [EMAIL PROTECTED] wrote:
Yes , I had use this query statement in my MySQL server,
But I have a query about it.
Why are you use WHERE a.groupname=b.groupname AND members.id=b.memberid
AND a.memberid=1?
Can you give me a explain or give me a advise!
Sure.
mysql SELECT
Are you using a RedHat system. In RedHat system does not install php mysql
support by default.
You may install php-mysql rpm from redhat distribution disks.
Regards,
--
Yours,
KH Chiu
CA Computer Consultants Ltd.
Tel: 3104 2070 Fax: 3010 0896
Email: [EMAIL PROTECTED]
Website:
Hi
Thanks for the effort! Solved it.
Cheers.
--
On Wed, 26 Feb 2003 08:28:04
mysql wrote:
Hi
you can use:
mysql -e select * from baa into outfile \/home/godson/run.sh\; test -u username
-ppassword
to do that. else I think
mysql -e select * from baa; test -u username -ppassword
Hi all,
I had a problem with mySQL 3.23.55 running on Solaris and on Linux (this problem
doesn't occur in NT). When I'm creating the tables in the database, the next error is
always provoked:
ERROR 1005 at line 54: Can't create table './mideye/profiles.frm' (errno: 150)
I'm using InnoDB
did you compile phpmyadmin from source if so then there should be a couple
of switches that you can add to pick up the mysql libraries check under the
installed directory and do a ./configure --help and have a look at the
options as for the php-mysql library here is the tarball try and compile it
when i'm trying run a query which is having some
27k records always i get error
OutOfMemoryError...
any reasons..
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
hi i was wondering which statement is quicker getting results when joining
tables ? i presume something like FROM foo f LEFT JOIN bar b ON f.id=b.id is
quiker than WHERE f.id=b.id ?
SQL !! (ignore this)
-
Before posting,
Hi,
If I have a table with serveral keys on fields and when I do an insert I get
Duplicate entry 'blah' for key 3
Is there any way I can get the name of the key which failed? The number (3 in
this case) seems totally pointless, even if you do a
SHOW INDEX FROM mytable;
there is no number which
Hi all,
I have a question about a mysql server under Debian GNU/Linux.
debian version: woody
mysql version: 3.23.49-8.2
libc6 version: 2.2.5-11.2
kernel: 2.4.20
CPU: bi-P3-1266 (Compaq Server proliant)
Memory: 2 Go
I have often the error message Can't create a new thread (errno 11). If
you are
This mail is a repost using words like:
sql,query,queries,smallint
I have written the following:
Hi,
I experience it on some list!
The problem is, someone posts a questions I cannot answer but I'm =
interested in a solution. I never get it because the questioner gets the =
answers
Then I recompiled the libc6 package with these changes (debian use softs
with shared libraries):
in linuxthreads/internals.h:
#define STACK_SIZE (2 * 128 * 1024)
in linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h:
#define PTHREAD_THREADS_MAX 4096
in /etc/sysctl.conf:
I just received an answer to a question that I was about to post by reading
a reply to someone else's question. So in this case, replying to all has
*reduced* traffic. I don't have to post my question.
- Original Message -
From: Bernhard Döbler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Dnia 03-02-26 08:29, Uz.ytkownik Veysel Harun Sahin napisa?:
Try zeos lib at http://zeoslib.sourceforge.net/
[EMAIL PROTECTED] wrote:
Hi
I am currently trying to use mysql 3.23 for a database project and
connect
to it using a Delphi 6 front end. Can anyone tell me how the connect to a
MySQL
Hello:
I'm not able to successfully complete make on mysql, I think I'm using mysql
version 3.23. I'm using gnu's complier and make, I'm not using the Compaq C++
compilier. Thank you very much.
Tru64 v5.1a
CC=GCC
CXX=GCC
gcc version 2.97
GNU Make version 3.79.1
my_error.c: In function
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
geeta varu wrote:
when i'm trying run a query which is having some
27k records always i get error
OutOfMemoryError...
any reasons..
What client are you using? JDBC? If so, you need to give more memory to
your JVM with the '-xMX' flag, because the
Hi!
I am trying to create a DLL that will hide embedded mySQL functions for use
with VB. I am using mysqlserver.lib. I am able to compile and execute the
following code. This has to be done in C because VB is too slow :-(
If mysql_server_init function is run in the DLL from Visual Basic. I get
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.11, a new version of the popular Open Source Database, has been
released. It is now available in source and binary form for a number of
platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
Note that
Hi!
I am new to this list and to the magical world of mysql so please
accept some, maybe, stupid questions from an amateur.
I am trying to install the Bundle::DBD::mysql module on my machine
(Mandrake Linux). I get an error message stating that it can't find
mysql.h and errmsg.h and they are
snip
This is a new beta development release, adding new features and fixing
recently discovered bugs.
/snip
Has the release gone backward to beta?
Duncan
---
Duncan Salada
Titan Systems Corporation
301-925-3222 x375
-Original Message-
From:
Tore,
Thanks very much for taking the time to respond! I'm not insulted by
basic. Some things I knew, but my questions were basic.
1: There is no difference: KEY is a synonym for INDEX.
So these two statements are equivalent:
KEY [index_name] (index_col_name,...)
INDEX [index_name]
Hi,
How come there is not a source download for 4.0.11??? The source
download is still 4.0.10! Did some one miss the source tar ball?
Thanks,
Ken
- Original Message -
From: Lenz Grimmer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday,
Clive,
I'm not sure offhand if Delphi 6 supports MySQL through the DB Express
drivers (Kylix 3 does). If so, you can go that route. Otherwise:
You can get libaries such as the one from Core Lab:
http://crlab.com/mydac/
or you can use ODBC drivers which you can find here:
David,
http://www.innodb.com/ibman.html#InnoDB_foreign_keys:
Starting from 4.0.5 the InnoDB parser is aware of possible option
lower_case_table_names you give in my.cnf.
Upgrade to 4.0.11!
Heikki
Innobase Oy
sql query
...
Subject: Can't create FOREIGN KEY restraints on InnoDb
On Tue, 25 Feb 2003 [EMAIL PROTECTED] wrote:
I wanted to created a searh engine for our site with indexed content of
the pages being stored in MYSQL full text index. I wanted to know how
fulltext index scales if I have about 200,000 pages indexed. Is it wise
to use MYSQL for this or go with
I've never seen opening a table twice and then doing a join back with
itself. Am I wording this correctly? Is that how to describe what you're
doing?
Thanks for posting this to the full list.
- Sheryl
- Original Message -
From: Don Read [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Salada, Duncan wrote:
snip
This is a new beta development release, adding new features and fixing
recently discovered bugs.
/snip
Has the release gone backward to beta?
Duncan
No, the release has a 'typo'. The release is 4.0.11 GAMMA.
-Mark
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ken Menzel wrote:
Hi,
How come there is not a source download for 4.0.11??? The source
download is still 4.0.10! Did some one miss the source tar ball?
Thanks,
Ken
The source release will be 4.0.11a, with patches for compilation on
HP/UX (as it
4: The index name allows you to for instance delete an index, specify it in
a hint, etc. But for the most part, a developer won't care what the name of
an index is.
5: AFAIK, the InnoDB tables support some of the more professional RDBMS
features, such as Transactions and Foreign Keys. I do not
I have just installed MySQL 4.0 (from Marc Liyanage at www.entropy.ch) on my
Mac. The mysql process is running. However, when ever I try mysql or
mysql 'options' I receive this error:
dyld: mysql Undefined symbols:
mysql undefined reference to _BC expected to be defined in
It is usually called a self-join, and it is a very useful technique. You
have to do this when you need to obtain or access two separate subsets from
a single table and somehow use those in a join. In this case, you want the
groupids a specific member belongs to (set one) as well as all members
I'm actually doing the same thing. I settled on using TEXT, which allows
you to store a little over 65,000 bytes. Any resume longer than 65,000
characters really needs to be made shorter since that works out to
probably about 20 pages.
As an aside, I don't know which version of MySQL you are
Do MySQL 3.23 bynary distribution of Windows XP
support EUC_JP character set?
I have tried to change it with the
--default-character-set but it don´t work. (It works
ok with SJIS or UJIS).
How I configure MySQL to work with EUC_JP (the same
charset as PHP)?
Thanks.
Does the last binary version available of MySQL
(4.0xx) support UNICODE?
Thanks.
___
Yahoo! Móviles
Personaliza tu móvil con tu logo y melodía favorito
en http://moviles.yahoo.es
I need help with a query. I have a 'royalties' table that looks like this:
AuthorIDProgramIDRoyalty
--
Author1 Program1 0.15
Author2 Program1 0.10
Author3 Program2 0.25
Author4 Program3 0.05
Author5 Program3
I understand now about index names, thanks.
I just found out that my host doesn't support InnoDB tables, so it's a
non-issue. I can't use them. I'll have to implement all the rules and checks
manually.
Thanks much for your help.
- Sheryl
- Original Message -
From: Tore Bostrup
The only two considerations I can think of to choose one type of TEXT column
over another would be:
1: The added storage required by a LONGTEXT over a TINYTEXT is only 3 bytes
per row. Compared to the anticipated average size of the data, this would
be neglibible.
2: If you want to impose
On Wednesday 26 February 2003 12:36, David Martin-Roche (ECE) wrote:
I had a problem with mySQL 3.23.55 running on Solaris and on Linux (this
problem doesn't occur in NT). When I'm creating the tables in the database,
the next error is always provoked:
ERROR 1005 at line 54: Can't create
On Wednesday 26 February 2003 02:40, Robert Mark Bram wrote:
mysqlLOAD DATA LOCAL
-INFILE
/Rob/architecturalScreens/prototype/v1/database/insertPart.dat
-INTO TABLE part;
Query OK, 496 rows affected (0.08 sec)
Records: 496 Deleted: 0 Skipped: 0 Warnings: 1494
I am
On Wednesday 26 February 2003 13:01, geeta varu wrote:
when i'm trying run a query which is having some
27k records always i get error
OutOfMemoryError...
any reasons..
Look at the following chapter of the manual:
http://www.mysql.com/doc/en/Out_of_memory.html
--
For technical
On Wednesday 26 February 2003 07:05, Paul Larue wrote:
Hi All, I'm quite a novice with Mysql and more than a newbee with Linux but
I managed to install Red Hat on an x86 and installed MySQl too. Now I need
to have InnoDB support. I installed MySQl on my notebook too (winxp) and
edited my.cnf
On Tuesday 25 February 2003 18:06, Nicolás Morales wrote:
I'm just starting to use MySQL for Linux. I installed it yesterday and
it worked, but after restarting the computer it doesn't work anymore.
When I type mysql at the linux prompt it says:ERROR 2002: Can't connect
to local MySQL server
On Wednesday 26 February 2003 10:19, Kirill Peskov (WEB-EU) wrote:
Looks like we've mixed up two threads into one ;-)
As I understood from various forums and maillists, versions 4.x are
still in development state.
Yup, 4.0.X is gamma.
The newest production version is 3.23.55,
am I
I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem...
My users is hacking the database because the MySQL system tables are
stored in .MYD format and to hack database is simple , only rename
the database and copy the blank database... restart MySQL and the
permissions is FULL FOR ALL
Thanks for the help everyone, I'm gonna try the longtext approach and see
how that works for me.
-Original Message-
From: Tore Bostrup [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Wed, 26 Feb 2003 12:06:34 -0500
Subject: Re: Column Type help
The only two considerations I can think of
I am new to MySQL ( Converting from MS SQL )
Any how I currently have a productions server running Mac OS 10.2.4
MySQL 3.23 and the latest version of PHP.
I was wondering when to start working with the 4.xx version of MySQL?
When should I start developing for it when should I upgrade the
Description:
While trying to install the binary mysql-3.23.xx-dec-osf5.1-alphaev67.tar, I
keep getting bad system calls while running scripts/mysql_install_db. References are
made to check the log file in ./data, but there is no such log file. Is it stored
somewhere else?
I'm using MySQL-PRO 4.0.11 and I have a error on
SELEC/DROP/ALTER/INSERT one specific table:
Version: '4.0.11-gamma-debug-log' socket: '/tmp/mysql.sock' port: 3306
InnoDB: Error: table ./webescriba/webtest has no primary key in InnoDB
InnoDB: data dictionary, but has one in MySQL!
InnoDB: If
I need to install a mysql client only on a solaris2.8 machine, the mysql
server is on another machine.
I could not make the compile work using the source download. I got an
error in make.
Can someone point me to a binary client download somewhere? Or give me
a hint of the following compile
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 26 Feb 2003, Salada, Duncan wrote:
snip
This is a new beta development release, adding new features and fixing
recently discovered bugs.
/snip
Has the release gone backward to beta?
As Mark has already stated, this is a typo - it
problably a silly question but if I am updating a table in a MySQL DB with a
table structure like this:
TABLE xxx
ItemSKU
ItemName
ItemDescription
PostCode
Category
CityID
CTelephone
ItemID
Cfax
Cemail
Caddress
CTown
Cwww
PRIMARY KEY (ItemID)
and the update query is
!
A120
HTMLASPJS
.ACCESS
B
HTML+ASP+CGI/PHP()
MYSQLACCESS
150M
200/
C ASPCGIPHP
MYSQLACCESS
200M
320/
QQEMAIL
D200
ASPCGIPHPACCESSMYSQL
300M
380/
QQEMAIL
(/) (/)
.COM 7560
.COM.CN 260 220
.CC 300 260
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dyego Souza do Carmo wrote:
I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem...
My users is hacking the database because the MySQL system tables are
stored in .MYD format and to hack database is simple , only rename
the database and copy the
Hi,
The problem is not with MySQL. The problem is with the users having access to the
database files. Lock up the directory that the files are stored in so that only user
MySQL and the administrator (root) can access them. Also, revoke the privileges of any
user, other than MySQL and the
Dyego Souza do Carmo wrote:
Tanks
Tanks very much
uh, we have war already??
(sorry couldn't resist)
--
Manuel Kiessling
sql,query,innodb,mysql
-
Before posting, please check:
http://www.mysql.com/manual.php
Dyego,
did you compile MySQL yourself and are using a debug version of mysqld?
The assertion is a DBUG_ASSERT which is only present in the debug version.
It fails because an earlier version of MySQL internally assigned a UNIQUE
key as the primary key of the table, but InnoDB was not aware of it.
If the databases are owned by mysql.mysql, how can this happen?
You don't allow users to become the mysql user, do you?
Dyego Souza do Carmo wrote:
I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem...
My users is hacking the database because the MySQL system tables are
stored in .MYD
Description:
Hello,
I am working with mysql/InnoDb 4.0.11 under Windows 2000.
I have the following table:
CREATE TABLE `giros` (
`Doc` varchar(10) NOT NULL default '',
`Tipo` char(1) NOT NULL default '',
`NRe` varchar(5) NOT NULL default '',
`FoP` char(2)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 26 Feb 2003, Mark Matthews wrote:
Ken Menzel wrote:
How come there is not a source download for 4.0.11??? The source
download is still 4.0.10! Did some one miss the source tar ball?
The source release will be 4.0.11a, with
Hi everybody
I sent a couple of mail recently, asking some help for some strange
behaviour with select and updates.
I hope many of you have read it...the problem was that making a
SELECT something FROM table WHERE 'Where_Clause'
gave some results, 0.
the query:
UPDATE table SET something
Respondendo,
quarta-feira, 26 de fevereiro de 2003, 14:46:45, Mensagem Original:
JT Why does a user on your system have access to rename the database? Your
JT database files should be readable only by the user that your database is
JT running as.
I work with notary officers on brazil ... and my
Hello, list,
I am trying to find a means to create a column that self-populates with
unique random 32bit integers in MySQL.
Do I need to do this in code, or is there a column spec/extra that I can
use to populate a column with random numbers on an insert? Ideally, the
database itself would
MM You should use the filesystem security your operating system provides to
MM prevent common users from copying the database files. The directory that
MM the database files resides in only needs to allow access by the user
MM that the MySQL server is running as. If you do this, only users who
Does anyone know where I can read more on how to redirect incoming email
(via Sendmail) into MySQL for a given email address?
I understand that I can use [EMAIL PROTECTED] | /path/mysql ... in the
/etc/aliases file to do this, but I would like to see if anyone has had
success with this. I also
I your customers have root access to their machine, then there is no
security, nor can there be.
Dyego Souza do Carmo wrote:
MM You should use the filesystem security your operating system provides to
MM prevent common users from copying the database files. The directory that
MM the database
First, which MYSQL, the program or the company.
Assuming you mean a mysql database I think you will need to run it through
a program which will parse it and load it into the database tables.
Does anyone know where I can read more on how to redirect incoming email
(via Sendmail) into MySQL for a
I have a need to find out how long each of the queries executed
against a mysql server are taking.
I found this post, which indicates that this information can be found
in the general query log:
http://www.phpbuilder.com/mail/php-general/2002122/0876.php
The manual note about it says the binary
Hi,
I'd like to know when the final MySQL 4.1 is expected to be released.
I know it's in alpha state now, so I guess it's not recomendable for
production yet..
What about 4.0?
Can it be already used for production?
Another thing..
I'm about to make a kind of yahoogroups in PHP. It's for a
http://james.apache.org
-Original Message-
From: Jeff Neuffer Jr. [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 11:20 AM
To: [EMAIL PROTECTED]
Subject: Using MySQL to store email
Does anyone know where I can read more on how to redirect incoming email
(via Sendmail)
Hi,
You have a terrible problem. If your competitors can copy your database it is the
fault of your ISP. The ISP should not give them access to your files. This is
possible. If your ISP will not do this get another ISP in another country that will do
this.
If your competitors are users of
Probably a simple query but, I need to find select a field with data that
exists in one table but does not exist in a field in another table.
example:
table1.name table2.name
---
bob john
susan
Hi.
On Wed 2003-02-26 at 18:36:07 +0100, [EMAIL PROTECTED] wrote:
[...]
As Mark has already stated, this is a typo - it should have read GAMMA
instead. Sorry for the confusion.
Would you mind to elaborate a bit on the current state of the 4.0
cycle? Since Monty suggested in the 4.0.8 release
I have a MySQL database I will be launching soon which has a search engine
database accesable over DBI/mod_perl/Apace. It has about 2M records, and is
a 4GB table with 1GB index.
Every day I insert 76k records all at once and delete about another 76k.
While these inserts are happening, the select
You could try changing the priority of your inserts using INSERT LOW PRIORITY
See: http://www.mysql.com/doc/en/INSERT.html
This will give the selects priority over the inserts, as the table becomes
free, the insert will happen.
Also, look at this:
http://www.mysql.com/doc/en/Insert_speed.html
On 26-Feb-2003 Andrew Maynes wrote:
problably a silly question but if I am updating a table in a MySQL DB with a
table structure like this:
TABLE xxx
ItemSKU
ItemName
ItemDescription
PostCode
Category
CityID
CTelephone
ItemID
Cfax
Cemail
Caddress
CTown
On 26-Feb-2003 John Hoskins wrote:
Probably a simple query but, I need to find select a field with data that
exists in one table but does not exist in a field in another table.
example:
table1.name table2.name
---
bob
I've been researching the possibilities of upgrading from MySQL 3.23 to 4.0
and have read opinions supporting why I should stay with what I have,
upgrade, or move to another DB altogether. I thought it would be in my
best interests to ask this list the same question.
I'm not interested in
Hi,
I would like to know if is there a way to delete constraints
without dropping and recreating a table. If there isn't, I would
like to know when do you plan to implement this important feature.
Thanks in advance,
sql,query
Daniel -
This might be a long shot, but since I've actually run into this problem
before, here goes:
Check your partitions. I had a server on which this very thing happened, and
it turned out there were overlapping partitions. This was all fine and dandy
until data was written to those
I am trying to find a means to create a column that self-populates with
unique random 32bit integers in MySQL.
Do I need to do this in code, or is there a column spec/extra that I can
use to populate a column with random numbers on an insert? Ideally, the
database itself would manage this
Or is there another product that can manage a MySQL database from either
a Windows or Linux laptop/desktop.
I'm sure there are many products that do this. My favorite is mysqltool.
We switched from phpmyadmin to mysqltool a couple years ago when mysqltool
offered features not available in
Does anyone know where I can read more on how to redirect incoming
email (via Sendmail) into MySQL for a given email address?
I understand that I can use [EMAIL PROTECTED] | /path/mysql ... in the
/etc/aliases file to do this, but I would like to see if anyone has
had success with this. I
Are you also going to install MySQL on the laptop? PHPMyAdmin runs over the
web, so you just need to be able to pull up the PHPMyAdmin website on the
laptop in order to use it. There shouldn't be any installation required.
If you want to use a GUI to connect to the remote MySQL server, then use
Since mysql_setpermission doesn't work on 4.2 | I have written a
program to replace It.
I think with some modifications to the admin section or linux stile
paths it could be easily adapted to any opperating system.
I started creating menu-mysql in 1997 when I first started using MySQL.
Not all
I'm trying to setup binary logging to eventually get replication
between two servers. However, any updates that I do to the
database are never written to the binary log.
I'd appreciate any pointers to what I may have misconfigured. Here
are some details about what I've tried so far:
Version:
Hi all,
It seems that MS Access can't find out how to convert the mysql Time Type
in a table.
Lets say i got 3 colums in a table like this:
create table test (id int(4)auto_increment,dato date,tid time, primary key
(id));
insert into test values ('',curdate(),curtime());
insert into test
I assume the RAND() function can be used in in an insert:
INSERT INTO target (MyRandVal, OtherColumns)
VALUES (RAND() * (MaxVal - MinVal) + MinVal, OtherData)
OR
INSERT INTO target (MyRandVal, OtherColumns)
SELECT RAND() * (MaxVal - MinVal) + MinVal, OtherData
FROM ...
HTH,
Tore.
Hello,
[EMAIL PROTECTED] wrote:
Description:
Hello,
I am working with mysql/InnoDb 4.0.11 under Windows 2000.
I have the following table:
cut
Time: 0.20 secs.
Explain:
table type possible_keys keykey_len ref rows Extra
GIROS range
Description:
Got undefined symbol 'errno' in libmysql
How-To-Repeat:
Fix:
diff -r -d -u mysql-4.1.old/include/mysys_err.h mysql-4.1/include/mysys_err.h
--- mysql-4.1.old/include/mysys_err.h 2003-02-25 19:01:11.0 -0500
+++ mysql-4.1/include/mysys_err.h 2003-02-25
1 - 100 of 123 matches
Mail list logo