At 09:41 AM 6/7/2001 +0800, Rolf Hopkins wrote:
>I don't know whether slackware has the RPM software but if it does, use it.
>You won't have these problems then. Otherwise I can only suggest you try
>one of the other binaries instead.
i'm also a mysql admin rookie. i couldn't get the rpm file t
On Wed, Jun 06, 2001 at 03:04:23PM -0700, Van wrote:
>
> I've dealt with jails and question the wisdom of using them.
>
> There are better ways to do this, and, your application will suffer
> tremendous portability issues which will probably make it useless
> for most people.
>
> If you're the
hi gang!
after much hassle, i seem to have successfully installed mysql 3.23.38. i
now have another problem. the mysql daemon is aborting abnormally upon
startup. i typed in the following from bash:
cd /usr/local/mysql
./bin/safe_mysqld
i got the following output:
Starting mysqld daemon wi
Greetings:
In Main, I have:
MYSQL *conn;/* Pointer to connection handle */
Then, I do:
if ((conn = do_connect (BTIME_HOST, USER, BTIME_PW, BTIME_DB, 0, NULL, 0)) !=
NULL)
{
/* Validate the structure of the btime database */
check_btime_structur
On Wed, Jun 06, 2001 at 01:01:47PM +0200, Alessandro Coppelli wrote:
>
> Hi to all. I would write a C programm for write a lot of variables
> in MySQL database. There are examples ?
>
> I try to write a cgi with Boutell library and then write the form
> variable in a database
The MYSQL C API is
On Wed, Jun 06, 2001 at 07:02:52PM -0700, Tyrone Mills wrote:
> SQL, QUERY
>
> I posted a little while back with a problem on several tables where
> the autoincrement column reverted to zero for no apparent
> reason. Now I know the reason, I just don't understand it, or know
> what to do differen
Should be able to do it using myODBC. But why such an old version?
- Original Message -
From: "Hillier" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 8:53
Subject: VB3 and mysql
To whom it may affect
Jonas Norrman pass this question on to you
Is VB3 c
>Gerald Clark wrote:
> >
> > You need to read up on what NULL means.
> > There is nothing that = NULL.
> >
> > try:
> > WHERE last_visit IS NULL
>
>I _do_ understand what NULL means. Watch this: (with Postgres):
>
>mark=> insert into t (c2) values (NULL);
>INSERT 2419008 1
>mark=> select * f
describe is a reserved word, use another name for the column.
http://www.mysql.com/doc/R/e/Reserved_words.html
> can someone tell me what I'm doing wrong here?I keep getting the error
> "You have an error in your SQL syntax near 'describe text, fulltext text,
> section VARCHAR (32) DEFAULT '
At 9:13 AM +0800 6/7/01, Metal wrote:
>?Hello!
>I want to delete some data from my MySQL database automatically with a
>given condition.Can MySQL do it?Please show me how to do it.
>Thanx a lot!
If you're asking whether MySQL has triggers, the answer is no.
If you're asking whether you can set up
Hello,
I notice that there are two places where a database can be specified
for the mysql client: (i) at the end of the line and (ii) after the
-D flag. Are there any particular reasons for this design decision?
I also notice that the -D flag is not supported by mysql 3.22.32
which produces a se
Andy,
Did you install to a drive other then C:\?
If you, you'll have to edit the configuration files to reflect that path.
my.cnf is/should be in the root directory, and you might need to edit it
with the path to your installation.
Also, check out http://www.mysql.com/doc/O/p/Option_files.html
At 5:52 PM -0400 6/6/01, Matt \"TrollBoy\" Wiseman wrote:
>can someone tell me what I'm doing wrong here?I keep getting the error
>"You have an error in your SQL syntax near 'describe text, fulltext text,
>section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6" and I don't
>understand why:
SQL, QUERY
I posted a little while back with a problem on several tables where the
autoincrement column reverted to zero for no apparent reason. Now I know the
reason, I just don't understand it, or know what to do differently.
I find myself in the all too common situation where I can developing
On Wed, Jun 06, 2001 at 11:07:03AM +0200, Rafal Jank wrote:
> Hi,
>
> Is it possible to make MySQL create another bin log when current one
> grows to the specified size?
Yes. The section of the MySQL Manual devoted to Replication explains
just which command to use.
Jeremy
--
Jeremy D. Zawodny,
I don't know whether slackware has the RPM software but if it does, use it.
You won't have these problems then. Otherwise I can only suggest you try
one of the other binaries instead.
- Original Message -
From: "Patrick Malone" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday,
describe is a reserved word and so is fulltext, I think.
- Original Message -
From: "Matt "TrollBoy" Wiseman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 5:52
Subject: Table Creation woes
> can someone tell me what I'm doing wrong here?I keep getting th
And what command did you use to create the user?
- Original Message -
From: "Peter I. Hansen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 07, 2001 5:32
Subject: permissions
> Hi
>
> I'm currently adding users to a MySQL server on a LAN (www.xxx.yy), and
> I want th
At 17:07 06/06/2001 -0400, [EMAIL PROTECTED] wrote:
Hi,
Did you tried to run /mysql/bin/winmysqladmin.exe to correct the
problem ?
Regards,
Miguel
>Listers,
>
>Apologies in advance for the cross-post.
>
>I've run into a problem starting MySQL on a Windows NT 4.0 workstation
>machine.
>Instal
I am pretty sure that Oracle Migration Workbench is an Oracle product, am I
correct? In that case you'll probably have to seek out the Oracle
community.
Hehehe. good luck.
Only one thing though. I wouldn't think you'd be able to migrate the mysql
database as that is the security database
Hi,
Your problem is a common mistake made by those who don't read the manual.
http://www.mysql.com/doc/R/e/Reserved_words.html
as described in the above web-page, "describe" is a reserved word.
Regards,
Jorge
MySQL Development Team
For technical support contracts, go to https://order.mysql.co
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 1:57 PM
To: Marcus Ouimet
Subject: Re: Subtraction of part of a field
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass th
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 1:57 PM
To: Marcus Ouimet
Subject: Re: Subtraction of part of a field
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass th
Hello!
I want to delete some data from my MySQL database automatically with a
given condition.Can MySQL do it?Please show me how to do it.
Thanx a lot!
As far as I am aware, mysqlgui is supposed to do exactly that.
- Original Message -
From: "Muhammad Asif" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 23:11
Subject: MySQL tool
> Is there any tool available for managing graphically databases,tables as
> wel
To whom it may affect
Jonas Norrman pass this question on to you
Is VB3 compatiable for mysql
* Visual Basic
Thanks Brett Hillier
At 11:32 PM +0200 6/6/01, Peter I. Hansen wrote:
>Hi
>
>I'm currently adding users to a MySQL server on a LAN (www.xxx.yy), and
>I want the structure to be like this :
>
>1) user X can connect from '%.xxx.yy' and from 'localhost'.
>2) user X can only connect to database X.
>
>I can only make one o
On Wed, 6 Jun 2001, Ian Ford wrote:
> Name your config file config.inc and if any of the below situations
> happen your password and username will not show up in plain text for the
> casual browser.
> (EXAMPLE:
>
> CONFIG.INC
> $DBname = 'test';
> $DBuser
On Wed, 6 Jun 2001, Dibo Chen wrote:
> use 'mysql -h server_machine -u user_name -p ' to connect/query your
> MySQL server. You don't need telnet.
My apologies for introducing some confusion here. You can use telnet to test
whether mysqld accepts incoming connections from the host on which
At 8:29 AM -0700 6/6/01, mysql list wrote:
>I lost track of the tutorial where I saw the command
>safe_mysqld --log &
>What is the & for?
The & tells Linux/BSD/Unix/etc. to run the application (safe_mysqld) and then return
you to the command line. Without the & you'll be unable to enter another
Hi, I'm Nelson,
and I'm using MySQL on a site, but because of availabilty reasons, I'm
thinking of creating a linux cluster, with Mosix and Global File System
(GFS).
The question is: if I put several mysql instances, working on the the same
database (shared to all by a network storage device) wi
OTOH, if you use mod_perl, *all* scripts are cached. That way you can have
a single script per function, which makes each smaller and simpler to debug.
Paul Wilson
iiNet Ltd
> Cindy, read my reply to this. You are mistaken. There is actually a way
> to make a single script do all kinds of d
Name your config file config.inc and if any of the below situations
happen your password and username will not show up in plain text for the
casual browser.
(EXAMPLE:
CONFIG.INC
INDEX.PHP
END EXAMPLE)
You can place the config.inc any where you want. My preferen
Only change the ownership/permissions for "var" (or whatever the 'parent'
directory of the 'mysql' and your own 'data' directories is named). I
usually have 'var' (and it's subdirectories) owned as "mysql.mysql" and the
permissions as "rwxrws---" and the rest of the MySQL are as 'root.root' and
> From: Johannes Pretorius <[EMAIL PROTECTED]>
> Date: Wed, 06 Jun 2001 16:49:45 +0200
> To: "Chris L. Gray" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> Subject: Re: Importing spreadsheet data into MySQL
>
> Hi there
>
> Yes you can do this by going into Access and op[ening the XLS fi
dariofg wrote:
>
> Hello,
>
> I'm trying to run mysql in a chroot jail, but the server
> errors out. I've modified safe_mysqld so it would call
> MySQL with the following command:
>
> nice --5 nohup /usr/local/mysql/libexec/mysqld --
> basedir=/ --datadir=/var --user=mysql --pid-
> file=/var/h
Can you can connect to MySQL with PHPMyAdmin or DBTools? What application
are you trying to use when you get the failure-to-connect message? Is the
server physically located in your place, or out on the net?
If you don't have administrative access (telnet, PHPAdmin, MySQLFront,
etc.), you have no
can someone tell me what I'm doing wrong here?I keep getting the error
"You have an error in your SQL syntax near 'describe text, fulltext text,
section VARCHAR (32) DEFAULT '0', type VARCHAR' at line 6" and I don't
understand why:
CREATE TABLE article(
id INT (4) DEFAULT '0' NOT NULL AUTO_IN
When you 'copied' the data directory (and/or contents), did you make sure
that the directory and file 'ownerships' and 'permissions' remained the same
? Did you check the 'ownership' and 'permissions' on the new MySQL 'parent'
directory ?
- Original Message -
From: "Mike Jimenez" <[EMAI
On Wed, Jun 06, 2001 at 10:01:17AM -0700, sanborn wrote:
>
> Thanks for your many answers. (mysql port default = 3306) . I
> can't seem to telnet to port 3306 however, I get a message saying
> '... not allowed to connect to this mysql server'. I am telneting
> from a windows machine if this mak
At 10:35 AM -0700 6/6/01, Kenneth Kopelson wrote:
>Actually you are only exposed if you have not set up Apache to run
>with virtual hosts. It is not difficult to configure Apache so that
>a person can only see the scripts that are in his/her directory, and
>is prevented from seeing or modifying t
Hi
I'm currently adding users to a MySQL server on a LAN (www.xxx.yy), and
I want the structure to be like this :
1) user X can connect from '%.xxx.yy' and from 'localhost'.
2) user X can only connect to database X.
I can only make one out of two possibillities in 1) work at a time.
Can you he
hehe
"-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)"
Mazur wrote:
>
> This has to have been asked before, but I can't find it in the
>
So sprach Zak Greant am Wed, Jun 06, 2001 at 01:07:43AM -0600:
> Now, while you don't need to escape the HTML entities before you insert your
> data into the database, you will still need to add slashes to the data.
While this is true, htmlentites will also take care of "nasty" characters
like "
So sprach PROVVISORIO am Wed, Jun 06, 2001 at 09:21:25AM +0200:
> MySQL based applications (and if You're thinking of web applications, go for Linux
>Red Hat 7.1
> + MySQL 3.23.38 + Apache 1.3.19 + PHP4pl5).
BTW: Mandrake 8.0 also offers these. Other than that I really like Mandrake
a lot, I'd
Listers,
Apologies in advance for the cross-post.
I've run into a problem starting MySQL on a Windows NT 4.0 workstation machine.
Installation appears to have gone fine, but I cannot start MySQL as an automatic
service. MySQL is listed in the Services panel, but it's currently inactive.
When I
So sprach Jeffrey L. Fitzgerald am Wed, Jun 06, 2001 at 12:08:18AM -0400:
> Currently the text coming back from the database is all runs together in
> the web browser...
Try nl2br -> php.net/nl2br
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (engli
I have just instaled mysql-3.23.38 in Solaris 8 using gcc from the software
companion disk of solaris.
For compiling there was an error with /opt/sfw/include/curses.h
For resolving it I renamed :
curses.h -> curses.h.orig
and made a link :
curses.h -> /usr/ucbinclude/curses.h
then returned all t
I have a related question. I am looking for a pretty robust SQL parser which
is also
"transparent" in the sense that one can go into it and modify the query
processing parts (i.e. "actions")?
Does MySQL source distribution include the lex/yacc files specifying the SQL
grammar,
and also are there
Hello,
when trying to compile mysql-3.23.37 on solaris 8, using either just
./configure or
CC=gcc CXX=gcc CXXFLAGS=-O3
./configure --prefix=/usr/local/mysql --with-low-memory --with-extra-charset
s=complex
I get the message:
checking return type of sprintf... configure: error: can not run test
As he said No Worry Be Happy A small table I just did was 78meg 90,000+ rows, 26
fields and imported it from a DBF file and had it running in no time..Love MySQL!!!
-Original Message-
FROM: Kenneth Kopelson
TO: Johnny Withers, Mike Mike, [EMAIL PROTECTED]
DATE: Wed 6/6/01 12:51
SUBJECT:
I had the same problem, though I did not know the cause. The
work-around I used was to use "127.0.0.1:3306" as the hostname for
connecting in the script.
Harry
-Original Message-
From: Keith Attfield [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 11:39 AM
To: [EMA
If you are going to be processing Excel files regularly and don't
want to manually export each one into CSV, try the perl method.
The module is called Spreadsheet::ParseExcel, I needed to
manually install IO::Scalar first to get it to work though.
-Original Message-
From: Artem Koutchine
Mark Stosberg <[EMAIL PROTECTED]> writes:
> Tonu, thanks for the explanation. I still prefer the way Postgres
> handles it:
>
> Mark=> select * from t where c2 = null;
> c1 | c2
> ---+
> 1 |
> (1 row)
Postgres is incorrect in doing this. At least, it's way non-standard.
NULL is *NOT* a v
Hi,
I am Rajani working as a Java Programmer. I was trying to migrate
from mysql to oracle and getting some kind of problems. I want to get some
kind of help from you and i really appreciate it. Here is my explanation
what i am exactly doing :-)
I downloaded Oracle Migration Wor
mysql list wrote:
> I lost track of the tutorial where I saw the command
> safe_mysqld --log &
> What is the & for?
Run in background.
>
> __
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail - only $35
> a year! http://pe
Well, it is not a telnet port, so why are you telnetting to it?
sanborn wrote:
> Thanks for your many answers. (mysql port default = 3306) . I can't seem
> to telnet to port 3306 however, I get a message saying '... not allowed to
> connect to this mysql server'. I am telneting from a windows
Here it goes. This is a small schema of the two tables.
Table Employees
i_recid = auto increment UNIQUE KEY
First Name
Last Name
ETC.
Table Contracts
sales_rep = e.i_recid
Contract Date = date of contract
Office = office
So here is what i am trying to do.
Run a
Hi,
I have a client who requires a composite table. A table containing data from
several different tables. The following query works in some databases but I
can't seem to get it to work in MySQL. Is there some other way to accomplish
this?
update tableA set (mycolumn) = (select somecolumn from t
If you really want to connect from the windows client computer then you
must execute the grant statement on the server but this may expose you
to security risks. In this case it would be best to have both computers
behind a firewall.
Neil
On Wed, 6 Jun 2001, sanborn wrote:
> Thanks for your ma
On Tue, 5 Jun 2001, Don Read wrote:
> Better yet, put the file outside the $DOCUMENT_ROOT, in case your server is
> poorly configured.
>
> include("$DOCUMENT_ROOT/../config.php");
This is a very good idea. One day if the system administrator decides to
back up all the user data and upgrade the
use 'mysql -h server_machine -u user_name -p ' to connect/query your
MySQL server. You don't need telnet.
sanborn wrote:
>
> Thanks for your many answers. (mysql port default = 3306) . I can't seem
> to telnet to port 3306 however, I get a message saying '... not allowed to
> connect to t
mysql list wrote:
>
> I lost track of the tutorial where I saw the command
> safe_mysqld --log &
The ampersand sends the process into the background.
Pete
--
http://www.elbnet.com
ELB Internet Services, Inc.
Web Design, Computer Consulting, Internet Hosting
---
Kenneth Kopelson wrote:
>
> Look into the Linux "logrotate" daemon. It allows you to configure what
> happens with logs.
That would work if the problem I'm looking to solve was predictable -
i.e. I have a busy site and I run logrotate three times a day to make
sure the logs haven't gotten too
Thanks, but I already have a program good enough called phpmyadmin and I need to use
another program called dbtools. dbtools can connect to the mysql server and convert
ms access files to pipe delimited text files. I just need to grant a user (myself)
permission somehow to access the server.
>Description:
The self tests #rpl15 & #rpl16 consistantly fail to pass.
>How-To-Repeat:
Package built with Sun Workshop compiler v5.0.
cc: WorkShop Compilers 5.0 98/12/15 C 5.0
>Fix:
First problem is that I can't tell WHY it is failing or even
WHAT
Hi there
Yes you can do this by going into Access and op[ening the XLS file from
there then importing it into a table.
This meaning you have a database from where you can move it over to mySQL's
table via ODBC connection or how
you like moving it from DB to DB.
I hope this helps
I believe SHOW CREATE TABLE was added in 3.23.20...
http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html
http://www.mysql.com/doc/N/e/News-3.23.20.html
On Wed, 6 Jun 2001, Rob Agar wrote:
> hi!
>
> Does SHOW CREATE TABLE x actually work? When I try it I just get error
> 1064 (you have an erro
Well today just isn't my day. My mail forwarding was broken till just now.
If you responded to this question earlier, could you please send the
response to [EMAIL PROTECTED] again?
Thank you,
patrick
- Original Message -
From: Patrick Malone <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
Hi,
Check out PHP4Hosting at :
http://www.php4hosting.com
They give what you want for about $10 including root access to Mysql.
Regards,
David Stubbings
-
Before posting, please check:
http://www.mysql.com/manual.php
Hi David,
I recommend you AletiaHosting.com as they provide full service at a lower
cost...
If you wnat a cheaper service you may try Whizhost.com but they are known to
have some problems here and there.
I have two sites: webfroggie.com and desportoradical.com. The first at
whizhost and the seco
This has to have been asked before, but I can't find it in the
database archives...
Is there a web browser based version of this mailing list anywhere?
Thanks,
Rob
-
Before posting, please check:
http://www.mysql.com/manual
Look into the Linux "logrotate" daemon. It allows you to configure what
happens with logs.
At 06:44 AM 6/6/01 -0400, Peter Billson wrote:
>I'm running mySQL on Linux and was wondering is there a way to limit the
>maximum log file size?
>
> From time to time I have written a bad script that w
Cindy, read my reply to this. You are mistaken. There is actually a way
to make a single script do all kinds of different operations. I have
single scripts that show a list of records, add a new record, update a
record, and delete a record, all in the same script. This is more
efficient to
I believe "show ceate table" was added in mysql 3.23 and subsequently 3.22
will not have it.
thanks,
-- Andrew
- Original Message -
From: "Rob Agar" <[EMAIL PROTECTED]>
To: "Mailinglist MySQL COM" <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 11:48 AM
Subject: does show create tabl
that's a unix shell command that basicly puts the process in the background.
if you type that command at your console you'll notice you get a prompt
right away.
This allows safe_mysqld to run in the background (somewhat like a daemon)
thanks,
-- Andrew
- Original Message -
From: "mysq
You need to have your script operate in different modes. You do this by
passing an argument when you call your script to tell the script what it is
supposed to do. So in this case, if the script is called with out any
arguments, it will display the form, as follows:
http://www.sample.com/sam
I'm rather new to Mysql.
Here is the deal. I'm currently running mysql-3.23.33 from
mysql-3.23.33.tar.gz. Now after reading through documentation. I now know
that I should have used the RPM Version because I'm running Redhat Linux
6.2. So I then downloaded the new version MySQL-3.23.38-1.i386.rpm
Hands down, your best bet is either Linux versions. You will get the best
stability, speed, and cost effectiveness by using these databases. Stay
away from Windows for this kind of thing. I have developed software for
the Windows platform since it first came out, and have been a software
en
I would suggest you obtain a book on the subject, or visit "mysql.com" and
read the documents under "documentation." You are asking questions that
have very large answers. To get you started, MySQL is accessed over the
web by using a scripting language like PHP or Perl.
-Ken
At 07:35 PM 6/5
I need some help upgrading to PHP 4.0 (version 4.0.5) on my Linux web
server running Apache containing a PHP module configured with MySQL.
I am trying to install PHP from the source tar downloaded from
www.php.net. I am following the installation instructions that say that I
can get away wit
Actually you are only exposed if you have not set up Apache to run with
virtual hosts. It is not difficult to configure Apache so that a person
can only see the scripts that are in his/her directory, and is prevented
from seeing or modifying the scripts in other peoples directories. Also,
it
Jeremy Zawodny wrote:
>
> On Fri, Jun 01, 2001 at 12:28:17PM +0400, Ilya Martynov wrote:
> >
> > JZ> On Fri, Jun 01, 2001 at 01:45:24AM -0400, David Freeman wrote:
> > >>
> >
> > JZ> Assuming you'll use Apache 2.x one day, I'd lean away from FreeBSD
> > JZ> until the threading issues are resolved
Apple has tested MySQL on MAC OS X to the best of my knowledge. Given that
MAC OS X is essentially FreeBSD Unix with a pretty wrapping, it makes sense
that MySQL would work easily. If someone said MySQL worked on MAC OS 9, or
older, I would be more cautious.
At 02:42 PM 6/5/01 -0800, Angela
This is probably a silly question, but I'm a new administrator and could use
some help.
I'm running a Slackware Linux 2.2.16 and am having difficulty installing
MySQL 3.23.38. I have downloaded the following rpm files from www.mysql.com:
MySQL-3.23.38-1.i386.rpm
MySQL-devel-3.23.38-1.i386.r
Hi,
I am receiving errors when setting
max_connections=300
basically anything over 256 ends up giving the error :
Can't create a new thread (errno 11). If you are not out of available
memory, you can consult the manual for a possible OS-dependent bug
after 256 connections are open.
There is
Using the MySQL++ library is their any call to
1) Get a list of the databases on the Server
2) List tables in a database given a database name.
The best I could find was
show databases
show tables;
or
show tables from ;
Does anyone have any examples of how to implement these calls in Visual
C+
Sure, that is easy. Just add a column to your room assignment table called
something like "RELEASE_TIME", and put into that column the time you want
the room to be released. Then, whenever you want to release rooms, execute
something like "DELETE FROM ROOM_ASSIGN WHERE RELEASE_TIME > NOW()"
Thanks for your many answers. (mysql port default = 3306) . I can't seem
to telnet to port 3306 however, I get a message saying '... not allowed to
connect to this mysql server'. I am telneting from a windows machine if
this makes a difference.
Gene Sanborn
If I'm not mistaken, MySQL can handle millions or even billions of rows,
and there is no real limit to the number that reside in a single table. So
Mike Mike relax, you are using a serious database here, not a little toy :)
-Ken
At 01:20 PM 6/5/01 -0500, Johnny Withers wrote:
>At boot time y
MySqlfront (www.mysqlfront.de)
Jay
At 08:11 PM 6/6/2001 +0500, you wrote:
>Is there any tool available for managing graphically databases,tables as
>well as
>user and their rights for MySQL
>
>
>
>
>
>
>
>-
>Before posting,
Hi,
THe maximum number of table joins I ned is not more
than three.Most of the search criteria is based on
Unique or Primary keys and hence I did not opt for
indexing.I am using the default myISAM table types of
mysql and mysql C_API.
Previously someone suggested using C_API functions
over joins w
I've had good success with DB Tools: http://dbtools.vila.bol.com.br
- Original Message -
From: "Muhammad Asif" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 06, 2001 8:11 AM
Subject: MySQL tool
> Is there any tool available for managing graphically databases,tables
There are no duplicates in your results
Distinct is on the whole record not on the individual Items
for example:
| Xerox N-2125 | Xerox DC255 |
is not the same as
| Xerox N40| Xerox DC255 |
because the first field is different
and
| Xerox N-2125 | Xerox DC255 |
is not the same as
| Xerox
I am trying to install MYSQL 3.23.38 on an SGI machine running IRIX 6.5
I can gunzip the tar.gz file and tar it aswell, however then when I run the
scripts/mysql_install_db it fails saying ' ./bin/mysqld: Program not supported by
architecture Installation of grant tables failed!
I therefore am
It is actually a little tricky. You need to build the table in mysql yourself, then
use some utility to import it. I would use perl. The problem with Excel is that when
it exports csv, it does not quote empty fields (I think), So, you can't use
Text::ParseWords (AFAIK). Here is a regexp which w
Hello,
I'm trying to run mysql in a chroot jail, but the server
errors out. I've modified safe_mysqld so it would call
MySQL with the following command:
nice --5 nohup /usr/local/mysql/libexec/mysqld --
basedir=/ --datadir=/var --user=mysql --pid-
file=/var/hayek.pid --skip-locking --
chroot=/u
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [Compiling in 64-bit Solaris environment]
>Description:
checking return type of sprintf... configure: error: can not run
test program while cross compiling
>How-To-Repeat:
Compile any version of mysql using any version of gcc o
hi!
Does SHOW CREATE TABLE x actually work? When I try it I just get error
1064 (you have an error in your sql syntax near 'CREATE TABLE x')
(version 3.22.32 on linux)
ta,
Rob Agar
-
Before posting, please check:
http://
On Wed, 6 Jun 2001, Chris L. Gray wrote:
> Is it possible to import spreadsheet data (Excel) into MySQL? I have
> data on about 2,500 retail locations that I must place into a
> database on the web and I do not want to type them by hand if I can
> avoid it.
One way:
Save as CSV file.
Parse CSV f
1 - 100 of 164 matches
Mail list logo
