I have a project where I may need to connect an MS ACCESS db and MySQL. I
have read some pretty good documentation and know that is possible to take
an existing Access db and export it to MYSQL. I have a few questions and
wondered if someone might offer some insight.
1. Where must the Access db
I have MySql database containing a table mad by several fields among wich :
Field1 (varchar) , Field 2 (timestamp) .
I want to do :
select count(*) , field1 , group by field1 .
That's ok , but i'd like to get results like :
2002-01-01 3
2002-01-02 4
.
How can i do that considering the timest
Hi,
(please reply to the mailing list, no to me directly.)
On Thu, 2002-03-21 at 19:17, Leecher wrote:
> Thanks,
> Yes, I logged in as Administrator.
>
> Just a question, why would running it as a service do any good, if I can't
> even manually start the daemon? The daemon insists that all port
I've set backlog of mysql to 100. And now I need to increase it.
But I don't know how many backlog my OS can support.
Where can I get that information and how can improve it.
Although I use Red Hat 7.2, other OS's informations are also Okay.
Any replys would be welcome.
---
Hey-
I ran into the same problem you did. After some searching on the web, this
is what I came up with:
First save the text file in the directory corresponding to the database you
are currently using (menagerie). So the file will be be
"c:\mysql\data\menagerie\pet.txt"
I then typed:
mysql>
The following will do the trick:
select * from book_hold
group by tcc_cn
having updated=min(updated) and max(status='NOTIFIED')=0;
We use the fact that (status='NOTIFIED') will be 0 when false and 1 when
true,
so this gives a way to select rows for which another row with the same
tcc
If I understand correctly, you can achieve your goal in either of 2 ways.
The first, is to copy sql.exe to one of your path directories (i.e. Windows
or Windows\System) or include "MySQL\bin" in your DOS path statement. This
will allow you to run mysql from a DOS prompt.
The second method is to
I'm planning to use MySQL on a PHP webserver and I like to know how the
minimum memory required for each web connection. Is there any way to
estimate this? Or test for this on my development machine? TIA
Brent
_
Do You Yahoo!?
Get yo
Loretta wrote:
> Hi. I am the only user of MySQL in a Win98 environment. I am developing an
> ASP front end to access the database to add, update and delete records in
> the database for a Church. I am having problems with the connection to the
> database. I am able to connect to the database
Hi. I am the only user of MySQL in a Win98 environment. I am developing an
ASP front end to access the database to add, update and delete records in
the database for a Church. I am having problems with the connection to the
database. I am able to connect to the database and print out the field
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Sorry if this post appears more than once... having some probs
;)! -
Hello,
Tried compiling mySQL on a Soloris 8 SPARC machine but get the
following make error:
c++ -O3 -DDBUG_OFF -O3 -felide-constructor
*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hello,
Tried compiling mySQL on a Soloris 8 SPARC machine but get the
following make error:
c++ -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -mcpu=
v8 -Wa,-xarch=v8plusa -fno-implicit-template
I am trying to compile a file on windows and build a DLL, this has worked before using
MSVC5.0 but now I'm using cygwin/mingw environment.
Does anyone know the problem/solution?
I have also tried building with mysqlclient.lib but get different error messages.
I have checked various newsgroups
Guy Davis wrote:
>
> Just wondering if any Linux users of MySQL out there had written a
> logrotate configuration file for dealing with MySQL binary logs on a
> replication Master.
>
> I want to rotate these logs (6.5 GB now) as some are over a month old.
> However, I don't want to confuse any o
mysql
Hi Colin,
I wish I can be able to live chat with you, but because of my hearing impaired...it
would not be possible..But what is the real problem? A few days ago I got assistance
from others on my Mysql problem. It has been fixed and everything works fine.
But I am still having reply
I think these articles might help you solve your problem. They don't address
javascript, but do show how to get
information to and from mysql using php and forms.
http://www.webmasterbase.com/article/627
http://phpbuilder.com/columns/laflamme20001016.php3
Regards,
Doug
On Thu, 21 Mar 2002
Does anyone have any documentation about a problem where the cpu gets pinned
in the high 90% after running for a while.
While it was in this state I tried mysqladmin processlist and saw 7 threads
all in sleep (persistent dbi connection). There was minimal load on this as
people weren't really con
can't you filter the output with sed?
s.m.
Am Donnerstag, 21. März 2002 21:11 schrieben Sie:
> Is there a way to tell MySQL to put a blank space instead of \N in the
> tab-delimited files when it does a dump? I'm working on a MySQL to SQL
> Server migration and having problems with the output fi
Hi,
On Thu, 2002-03-21 at 16:58, [EMAIL PROTECTED] wrote:
> I am using the MySQL server version 3.23.44 running on Windows 98 machine, I
> just found out that as you view the task manage...mysqld is not alone...I
> mean, about 6 of them...I am confuse whos running...so, all I want to know
> is...
On Fri, Mar 22, 2002 at 01:26:42AM +0200, Michael Widenius wrote:
>
> Hi!
>
> > "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
>
> Jeremy> On Tue, Mar 19, 2002 at 04:02:46PM -0800, Jeremy Zawodny wrote:
> Jeremy> [snip]
>
> >> Here's the relevant entry from the error log, repeated
At 12:11 -0800 3/21/02, David M. Peak wrote:
>Is there a way to tell MySQL to put a blank space instead of \N in the
>tab-delimited files when it does a dump?
Nope. You'll have to postprocess the files somehow.
> I'm working on a MySQL to SQL
>Server migration and having problems with the out
At 15:21 -0800 3/21/02, Nick Arnett wrote:
>I have something odd happening with a bulk insert file and haven't been able
>to find anything in docs or archives that gives me a clue what's going on.
>I'm creating a bulk insert file programmatically with Python. Everything
>seems to work fine, excep
> -Original Message-
> From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:03 PM
[snip]
> It looks like you have the CRLF problem... Python on win platform outputs
> CRLF for '\n', because that is normally the wanted line ending on windows
> systems... ope
Hi , im fairly up to speed with Mysql as i currently program in
Postgresql on my linux box and Ms Access on my Win 98 box.
Nevertheless i am currently working with Mysql and i have downloaded
gone thru examples and read the doc's. I have somehow made a mistake
regarding MySql administration. I
Hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> On Tue, Mar 19, 2002 at 04:02:46PM -0800, Jeremy Zawodny wrote:
Jeremy> [snip]
>> Here's the relevant entry from the error log, repeated over and over:
>>
>> 020319 15:57:33 /home/mysql-4-bk/libexec/mysqld: Out of memor
* Nick Arnett
> I have something odd happening with a bulk insert file and
> haven't been able
> to find anything in docs or archives that gives me a clue what's going on.
> I'm creating a bulk insert file programmatically with Python. Everything
> seems to work fine, except that in the last fiel
Egor:
Thanks for the hint. I browsed the manual for readline(3) and for
/etc/inputrc, but found nothing wrong with it. I can enter umlauts in all
other programs and from the bash command-line - only in mysql they don't
work. Where else might I look for the source of the problem?
s.m.
Am Don
As to your second question, I'd /highly/ recommend
http://phpwizard.net/projects/phpMyAdmin/. I use it to manage all the
databases where I work, and have had very few problems with it.
Matthew Walker
Ecommerce Project Manager
Mountain Top Herbs
-Original Message-
From: Kory Wheatley [ma
I need to install mod_auth_mysql now, but got error ,
wondering if you could help me out.
after i install mod_auth_mysql, then i try to config
the apache.
./configure --prefix=/usr/local/etc/httpd
--sysconfdir=/www/conf \
--activate-module=src/modules/php4/libphp4.a --enabl
e-module=status \
--a
I need to install mod_auth_mysql now, but got error ,
wondering if you could help me out.
after i install mod_auth_mysql, then i try to config
the apache.
./configure --prefix=/usr/local/etc/httpd
--sysconfdir=/www/conf \
--activate-module=src/modules/php4/libphp4.a --enabl
e-module=status \
--a
I have something odd happening with a bulk insert file and haven't been able
to find anything in docs or archives that gives me a clue what's going on.
I'm creating a bulk insert file programmatically with Python. Everything
seems to work fine, except that in the last field of each record, a retu
I have two questions. (If you would be so kind to respond I would
appreciate it)
1. What is the best way, or correct way to backup the MYSQL databases. I
thought shutting the server then perform the backup, so that there are
no connections to the databases?
2. What's the best command graphic i
Hello,
I am painfully new to mySQL (I'm working on my first database), so my
apologies if I ask something stupid.
I am using phpMyAdmin 2.2.0 to connect to MySQL 3.23.36
I have a database named "aro" with a table "specialdays"
I have a CSV that I want to import to the 'specialdays'
I wen
alan,
Given the large amount of postings you've made to this list, I suggest
that you may be bettered helped via live chat.
You can do so by using the mysqldeveloper.com Live Chat system:
http://www.mysqldeveloper.com/chat/
which connects you to the #mysql support channel on the EFnet IRC
netw
* Fletcher Sandbeck
> Actually, easy thing to do through the APIs or most third-party
> languages that let you access MySQL. I'm looking for a way to
> do it using raw MySQL statements.
>
> I think I found my answer in the list archives. It's not
> possible without using multiple SQL statements.
>Description:
Take two tables (call them a and b), which have identical structures. Table a
has no rows, table b has some (say 10) rows. If you do this:
select * from a union select * from b limit 0,5
It works as expected. Now do this:
select * from a union select * from b limit 5,5
Now y
Try a C:\my.cnf with just the following:
[mysqld]
datadir = C:/mysql/
tmpdir = C:/temp/
-Original Message-
From: Gregory Junker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 2:25 PM
To: Simon Tienery; [EMAIL PROTECTED]
Subject: RE: Error 1067: the process terminated unexpect
I've got a mysql table and I need to perform
a complex query on it, but I'm not sure how
to formulate it.
This is what I need to do:
select id,tcc_cn,entered,updated,enteredby,num_bump,
status FROM book_hold WHERE
1) There are no books with the tcc_cn that already
have a status of 'NOTIFIED'.
2
mysql
kathy,
What would happen if you type in
mysql -u root -p
then type in
use mysql
have you tried running the server in standalone from the command prompt,
to get some more output from the startup sequence?
> -Original Message-
> From: Simon Tienery [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:40 PM
> To: [EMAIL PROTECTED]
> Subject: Error 1067: the pro
mysql
Kathy..
Check version of mySQL for me.
Did you said after typing mysql -u root -p, you get in fine?
Then you type mysql? then access denied...
Is this in a sequence?
- Original Message -
From: "Kathy Reyes" <[EMAIL PROTECTED]>
To: "alan4100" <[EMAIL PROTECTED]>; "mysql" <[EMAIL
Gabriel,
MySQL-Max-3.23 is now officially stable both in the opinion of MySQL AB and
Innobase Oy. It is listed as stable both in the MySQL online manual and on
the MySQL AB website front page.
The reason for separate MySQL-3.23 and MySQL-Max-3.23 is commercial: there
are different support and em
On 3/21/02 at 12:51 PM, Allon Bendavid wrote:
> Tough thing to do. Fortunately we thought this through for you in jTalk.
> Keep your eyes peeled for a formal announcement next week.
Actually, easy thing to do through the APIs or most third-party languages that
let you access MySQL. I'm looking
Can anyone help please!
I am unable to start the service on WIN2K since I installed version
MySQL-3.23.38.
I have tried altering the my.cnf and my.ini files and I have tried running
the service as the administrator user.
But I am getting the same error message above each time.
Any suggestions
http://www.cqhost.com/
I have a JSP app hosted there and they are pretty good. They also provide a
MSQL DB
Mark
-Original Message-
From: Ken Anderson <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, March 21, 2002 2:39 PM
Subject: Re: JSP or PHP?
>Klym wro
Apologies for sending what may well be a "duh" problem, but I've
run out of web- and documention-based resources...
System:
I'm running MySQL 3.23.47 on OS X 10.1.2.
Symptoms:
When I try to run safe_mysqld with --skip-networking (or with the
option set in a my.cnf file), everything starts
If the table has a unique key then add the REPLACE keyword.
This will update the columns with new values if the key already exists
and add the row if it doesnt.
--Mark
Michael Kaiser wrote:
> Using the following inserts data from a text file into a particular MySQL
> table:
>
> LOAD DATA LOC
in the postrotate section, you have to add the user and password parameters
to mysqladmin:
mysqladmin -u someuser --password=somepassword flush-logs
s.m.
Am Donnerstag, 21. März 2002 19:23 schrieben Sie:
> Hello there!
>
>
> I have added recently administrative user to mysql database:
Klym wrote:
>
> I have built a MySQL database for a web based survey. I am trying to decide
> between JSP and PHP for my programming interface. The reason I am
> considering Java is because I have some Java experience. What would you
> recommend for someone like me who is starting out?
If you
Tough thing to do. Fortunately we thought this through for you in jTalk.
Keep your eyes peeled for a formal announcement next week.
-Allon
On 3/21/02 11:04 AM, "Fletcher Sandbeck" <[EMAIL PROTECTED]> wrote:
> I am trying to get the full found count from a query while using LIMIT to
> return
>
Hello,
I have compiled mysql-3.23.49 from source distribution on a NetBSD
1.5.2 (sparc) box. Everything compiled fine, no-errors. Installed fine,
no-errors. Starts and Stops fine no-errors. But when I go to run mysql or
mysqladmin I get the following error:
# /usr/local/mysql/bin/mysql
Grant all on mysql.* to 'root'@'localhost' identified by "password";
What version MySQL are you running?
You need 3.23 for GRANT to work.
Kathy Reyes wrote:
>I just gave up, everything that I tried did not work.
>
>I killed mysql and then
>started with safe_mysql --skip-grant-tables
>then I
Using the following inserts data from a text file into a particular MySQL
table:
LOAD DATA LOCAL INFILE "file.txt" INTO TABLE whatever;
Is there any way to do this, but instead of inserting, it's updating?
Michael Kaiser
LivingLegend.net
[EMAIL PROTECTED]
"Many folk like to know beforehand wha
Now I have a different problem. When I type mysql it gives me the message
Access denied for user: 'root@localhost' (Using password: NO)
how do I get it to use the password.
When I type mysql -u root -p
I get in...
- Original Message -
From: "alan4100" <[EMAIL PROTECTED]>
To: "Kathy Re
Is there a way to tell MySQL to put a blank space instead of \N in the
tab-delimited files when it does a dump? I'm working on a MySQL to SQL
Server migration and having problems with the output files. I'm doing this
all in batch fellas so I'm not finding a good search and replace utility.
(perl
/usr/local/bin/mysql -hhostname -uusername -ppassword -e "flush logs;"
Guy Davis wrote:
>Just wondering if any Linux users of MySQL out there had written a
>logrotate configuration file for dealing with MySQL binary logs on a
>replication Master.
>
>I want to rotate these logs (6.5 GB now) as so
I was just perusing the Innobase Oy site and read that they've declared
MySQL/InnoDB 3.23 stable (it actually says they did this in February). I
read somewhere on the MySQL site a while ago stating that InnoDB wasn't
included in the non-Max distribution because it was still considered
beta. I
mysql
Kathy,
I see..
As long as you've got a fat pipe on both ends speed could be ok. But,
then again, you never know. Some backhoe in Nebraska could cut your sweb
server off from your database.
Of course you'll want it to be secure as well. MySQL 4 has support for
SSL. I suppose you could setup an ssh port redire
On Thursday 21 March 2002 11:28 am, Klym wrote:
> Is it possible to have your web server and your MySQL server running at
> different geographic locations? I'm wondering if I can run my own MySQL
> server here at home on Linux and have my web site use PHP to connect to it
> and extract data. Is
What you had looks fine except the date...change what you had to:
AND date >= '2002-03-17'; # date needs quotes around it
Should work.
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 8:49 AM
To: mysql list (choose midget)
Subject:
I issued the chown command as indicated by Andreas
but it doesnt help
I still get the "Table mysql.hosts doesnt exist"
I know that all the tables created by mysql_install_db are infact owned by
mysql
but the server daemon still cant find them
what next?
_
OS: Compaq Tru 64 4.0F
Compiler: GNU GCC 3.0.4 - libstdc++.3.0.4
MySQL 3.23.49
MySQL Protocol 10 - libmysqlclient.so.10.0.0
After upgrading apache/php with the new 3.23.49 libs all of my previously
working 'C' mysql applications have died. This is okay on one hand cause I
am moving them to 'php'
I am trying to get the full found count from a query while using LIMIT to return
just a portion of the found records. I can use two queries in a row to get
first the found count, then the found records, but that takes twice as long as
performing either query by itself.
SELECT COUNT(*) FROM datab
Just wondering if any Linux users of MySQL out there had written a
logrotate configuration file for dealing with MySQL binary logs on a
replication Master.
I want to rotate these logs (6.5 GB now) as some are over a month old.
However, I don't want to confuse any of the replicating slaves. Any
> I'm trying to figure out a query that will tell me the total number of
> people in our house email file that physically opted out in the last
> week. I'm a bit of a mysql newbie as you can tell...
>
> This is the general concept, though it doesn't seem to work:
>
> select count(id) from conta
AND date >= "2002-03-17";
-Original Message-
From: rory oconnor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 10:49 AM
To: mysql "list (choose midget)
Subject: Query syntax help
I'm trying to figure out a query that will tell me the total number of
people in our house email
Hi!
> Hi, can any one suggest where I can get latest
> MySQL rpms for redhat 6.2 with glibc 2.1x...
> the new rpms .49+ are all for glibc 2.2+
I had the same problem. There are four possible
solutions:
a) The obvious but annoying one: upgrade to RH72...
b) The less likely one. Upgrade RH62 to
Is it possible to have your web server and your MySQL server running at
different geographic locations? I'm wondering if I can run my own MySQL
server here at home on Linux and have my web site use PHP to connect to it
and extract data. Is that a bad idea for security and speed?
thanks
--
Hello there!
I have added recently administrative user to mysql database:
#mysqladmin -u root password someposword
since then I'm getting every day such e-mail from logrotate demon:
Subject: errors rotating logs Message: errors occured while rotating /var/lib/mysql/mysql.log
mysqladmin: connec
I just gave up, everything that I tried did not work.
I killed mysql and then
started with safe_mysql --skip-grant-tables
then I was able to connect to mysql without an error.
But when I tried to
Grant all on mysql.* to root@localhost identified by "password";
it gave me the message Unknown C
sascha,
Wednesday, March 20, 2002, 12:52:41 PM, you wrote:
sm> Am Mittwoch, 20. März 2002 11:24 schrieben Sie:
sm> > I just installed mysql fresh out of the box on a fresh SuSE linux 7.1.
sm> > mysql does not let me enter german umlauts, though. I tried to start it
sm> > with "mysql --default-cha
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (1.67) of MySQL
Manager -- A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
What's new in version 1.67
If you are using KDE, there a great gui mysql program called kmysqladmin,
that you can download and install and have running within second, it comes
all versions of Sues and a great guy to work with. I know that on the
website there is a tar ball and a Red Hat version.
Use google.com to find it.
Hi
I recently ran a mysqldump of a bunch of information. When the mysqldump
extracted the dates, it extracted them in South African format (dd/mm/),
I am guessing this was picked up from somewhere, so when I then ran the dump
through mysql to reimport the information all the dates where impor
I'm trying to figure out a query that will tell me the total number of
people in our house email file that physically opted out in the last
week. I'm a bit of a mysql newbie as you can tell...
This is the general concept, though it doesn't seem to work:
select count(id) from contact # my
> I assume that the mysql daemon is looking for one of those
> owned by mysql.
>
> The server will start if I send the --skip-grant-tables option
>
> Who wants to run a database with no grant tables
Find out where your databases are located.
Think /var/db/mysql is the default.
Go there an
In the last episode (Mar 21), Viraj Alankar said:
> sql
>
> I'm confused as to what 'delete quick' does and when to use it. The
> manual states:
>
> If you specify the word QUICK then the table handler will not merge
> index leafs during delete, which may speed up certain kind of
> deletes.
Nor
One more reason to stick to MySql!
For those interested, another article here:
"Oracle Pricing called into question"
http://www.eweek.com/article/0,3658,s=1884&a=24365,00.asp
At 09:42 AM 3/21/2002 -0500, Gurhan Ozen wrote:
>Thought some might be interested in such articles. Seems like Oracle's g
>Description:
using mysql 3.23.41
when attempting to insert a large file (around 17 MB) into a longblob field
i get the following error
ERROR 2006 at line 1: MySQL server has gone away
our mysqld init script contains the following line:
mysql
I tried to d/l winmysql from this website:
http://www.winmysql.com/page4.html
as freeware, but it did not respond. Guess it is busy. Will try again, later.
But would you or others suggest me to put it in a separate folder from MySQL folder
after the d/l?
> I assume that the mysql daemon is looking for one of those
> owned by mysql.
>
> The server will start if I send the --skip-grant-tables option
>
> Who wants to run a database with no grant tables
Find out where your databases are located.
Think /var/db/mysql is the default.
Go there an
mysql
Hello Kathy,
How have you made out with access to mysql?
what about
select Url from table where Ref = 'foo'
Salada, Duncan wrote:
>I am hoping I can get some help with a difficulty I am having with a table
>of mine. I am going to give a lot of background info, so please bear with
>me. First, let me say that I using 3.23.49. Now some info about the
mysql
Thanks, Colin for the reference to winmysql..etc.
By the way, do you also get this email at your personal email address besides mailing
list? It looks like you have to check at this mailing list site, because almost all
personal emails have been bounced back.
I only reply notes to [EM
Actually I hadn' t this kind of problem. But now I can' t display turkish
characters in mysql queries.
Can anyone help me?
Edakom Internet Sorumlusu
Gokce Akkaya
-
Before posting, please check:
http://www.mysql.com/man
Pål,
Wednesday, March 20, 2002, 5:52:58 PM, you wrote:
PW> I have:
PW> mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386)
PW> and wonder about the log file /var/log/mysqld.log
PW> shouldn't that include failed connections??
You can find mysqlds log in the file 'your_hostname.err' or '
mysql
Allon,
Thanks for the clear and simple example regarding keys.
You may notice mysql at the top left corner because without it your letter will bonce
back like others (users). eek!
Okan,
Thursday, March 21, 2002, 4:27:15 PM, you wrote:
OC> I am planning to call a scheduled (lets say 08:00 am every weekday) batch
OC> job at MySql, but I do not want to use operating systems scheduled task nor
OC> crontab. Is there a function that mySql supports like Oracle's jobs?
There is n
Shamit,
Wednesday, March 20, 2002, 7:49:50 PM, you wrote:
SK> Hi, can any one suggest where I can get latest MySQL rpms for redhat 6.2
SK> with glibc 2.1x... the new rpms .49+ are all for glibc 2.2+
If you use glibc 2.1x you should compile by yourself. Note:
compilation by yourself requires att
Stembridge,
Thursday, March 21, 2002, 12:05:31 AM, you wrote:
Seoen> The problem isn't inserting table schema/data - I know how to do that.
Seoen> I'm referring to the process of inserting an actual FILE (txt, .bat, .jpg)
Seoen> via command line. And of pulling it out and giving it a name (te
Suresh,
Thursday, March 21, 2002, 6:48:47 AM, you wrote:
SRS> I am getting following error msg when I try to install
SRS> MySQL using rpm -i My*
SRS> error: MySQL-3.23.49a-1.i386.rpm cannot be installed
SRS> error: failed dependencies:
SRS> data-showtable is needed by
SRS> Msql-Mysql-DBI
Hi!
On Mar 21, Alexander Belyaev wrote:
> Hello,
>
> CREATE TABLE IF NOT EXISTS test (
> id mediumint(6) unsigned NOT NULL DEFAULT '0' ,
> txt text ,
> PRIMARY KEY (id)
> );
>
> #insert. 4 rows
>
> ALTER TABLE test ADD FULLTEXT findind (txt);
>
> select * from test where match(t
The group is not really important, as long as mysql owns the data
directory and its contents.
You can check /etc/group and see if you have a mysql group, or a group
to which mysql is a member.
Rance Hall wrote:
> Folks:
>
> I think you are on the right track with that Gerald..
>
> I deleted al
Ok, I guess Im gonna have to do this again
I have a Slackware 8.0 distro with the apache, php, and mysql install pkgs
off of the cd
I am logged in as root (not su'ed to root) and run the mysql_install_db
script I run it with or without the --user=mysql qualifier
in either case the databases
Try this:
Microsoft VisioModeler 3.1 (FREE) on msdn.microsoft.com/downloads
jvd
>>> "Ricardo Striquer Soares" <[EMAIL PROTECTED]> 21-3-02
13:21:20 >>>
i am looking for a ER Design Freeware tool, i'd like to konw if does
someone here knows about something like that, the tool name and,
if possib
I am hoping I can get some help with a difficulty I am having with a table
of mine. I am going to give a lot of background info, so please bear with
me. First, let me say that I using 3.23.49. Now some info about the table.
It currently has 5687391 rows. There are 3 columns in the table: ID (i
Probably Linux, but it is also pretty spunky on my WinXP machine.
Craig
At 08:30 PM 3/20/2002 -0800, you wrote:
>Is MySQL 3.23/4.01 faster on Linux (RH 7.2) or Windows XP/2000 with the same
>hardware? Thanks.
>
>David
>
>
>-
>B
At 15:12 2002-03-21, Bernhard Doebler wrote:
>- Original Message -
>From: <[EMAIL PROTECTED]>
>To: "Bernhard Doebler" <[EMAIL PROTECTED]>
>Sent: Thursday, March 21, 2002 1:58 PM
>Subject: Re: Re: ER Program
>>
>> Look out for the Czech Program Case Studio.
Looks interesting - but it's
Hi,
I am trying to get the following to work but it returns invalid values.
SQLINTEGER size;
SQLExecDirect (hstmt, "Select 8", SQL_NTS);
SQLBindCol(hstmt,1, SQL_C_ULONG, &size,0,NULL);
I tried various datatypes for size but I always get some invalid values.
Is
the above correct or do I need
1 - 100 of 139 matches
Mail list logo