try this:
SELECT PG1.*
FROM project_group_list AS PG1 LEFT JOIN project_group_list AS PG2
ON PG1.ref_project_group_id = PG2.project_group_id
WHERE
(PG1.root_project_group_id=10 AND PG1.inherit=1 AND PG2.inherit=1)
OR (PG1.project_group_id=10)
OR (PG1.ref_project_gro
A table T contains two fields: T.ID, T.Data.
I want to set its T.Data to one of three values: NULL, 0, 1 according to its T.ID.
This is what I have done:
1. Set all Data to be NULL:
UPDATE T SET Data = NULL;
2. Create a temporary table Temp to store some selected T.ID. Then update the Data of
I'm assuming you're IDs are getting bigger, so how about ordering them in
descending order?
SELECT ID, title, article FROM news ORDER BY ID DESC LIMIT 2
Also, if you're starting from 0, you don't need to include that in the LIMIT
clause.
--jeff
- Original Message -
From: "Todd W" <[EMAI
At 22:07 -0600 3/14/03, Todd W wrote:
I am having troubles with queries, selecting only the newest records.
Select ID,title,article From news ORDER BY ID LIMIT 0,2
I tried this but it always shows the first two records and I want to select
the last two records(newest ones added). Can someone hel
At 16:04 +0200 3/7/03, Tonu Samuel wrote:
On Thu, 2003-03-06 at 17:52, tommy liu wrote:
anyways, yes I did run
# ./configure --with-vio --with-openssl --prefix=/usr/local/mysql
and also tried the max version
I also ran mysql_fix_privilege_tables.sh (one along 3.23.46 source)because
we have My
I am having troubles with queries, selecting only the newest records.
Select ID,title,article From news ORDER BY ID LIMIT 0,2
I tried this but it always shows the first two records and I want to select
the last two records(newest ones added). Can someone help out?
Thanks
-
At 20:05 -0500 3/6/03, Beau Hartshorne wrote:
I've been working for some time with php and mysql. I've always been
curious, and am finally starting to play with C. I downloaded Paul
DuBois' sample "Chapter 6: The MySQL C API".
I am running Mac OS X 10.2.4. I am running mysql version 3.23.54-max. I
I've seen this problem listed before in newsgroup postings, but I haven't
been able to find any concrete answers.
On a Solaris 8x86 environment, using the Sun Freeware releases of gcc and
gmake, a MySQL build fails during sql_lex.cc
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/opt/mysql\""
-DDATAD
foreign key constraint problem:
---
create table stud(rno integer not null,
name char(10),
primary key(rno));
create table mark(rno integer not null references
stud,
mark integer);
mysql> insert into stud values(1,'a');
Query OK, 1 row affected (0.22 sec)
mysql> inse
Sorry, here's the link:
http://www.emicnetworks.com/products/products_eac_mysql.html
And the link to the MySQL newsletter issue:
http://www.mysql.com/newsletter/2003-02/a000125.html
Brian McCain
- Original Message -
From: "Bruce Feist" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL P
This product was mentioned recently in the MySQL newsletter and in a MySQL
press release. From the company's description of it:
"EAC uses clustering technology with a unique group communication
replication technology, which provides the consistency of synchronous
replication at the speed of asynch
Gelu Gogancea wrote:
It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have
implemented facilities for this.
Distributed database can be achieved,like example, using DISTRIBUTED
OBJECTS(let's say CORBA).In my understanding that means that MySQL already
can be used like distribute
Ok, I have posted some things like this yesterday, but I have some new
things to add...
Yesterday I made a posting about having issues connecting my coldfusion to
mySQL. Well I am pretty sure I have narrowed it down to mySQL being the
issue...
(NOTE - mySQL and CF are on the same server)
The rea
Yakari,
- Original Message -
From: "Yukari Iwatani" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, March 14, 2003 3:36 PM
Subject: Hard, unrecoverable InnoDB crash with MySQL 4.0.11
> Hi:
>
> I'm running MySQL 4.0.11 (MySQL.com binary RPMs) on Red Hat Linux 7.3, all
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: comment with "foreign key" text causes innodb CREATE TABLE
failure
Description:
If an innodb table is created with a comment with the words "foreign
key", the table creation fails.
The syntax used to work with MySQL-4.0.4-beta-win and
Hi,
I think you have at least two ways:
1.To put the corect path to the sock file, in my.cnf configuration file.
2.To find where MySQL daemon create this file and add the argument -S to
the mysql client application.
Regards,
Gelu
_
G.NET SOFTWA
At 14:40 -0600 3/14/03, DANIEL GADDIS wrote:
I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...
++-+--+
| DAY| USERID | LIS_QUANTITY |
++-+--+
| 2003-01-02 | H0850A1 | 539 |
| 2003-01-02
Jeremy Zawodny wrote:
On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote:
This may help - I just got this from a friend.
http://jeremy.zawodny.com/blog/archives/000203.html
Ugh.
I *really* need to update that. It has become a popular reference.
But I have some new information to a
Hi,
Maybe it's funny...but this is MySQL date/time format which is used in log
files.On my MySQL servers date/time are formated in the same way.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
i correct my example :
select USERID,IF(DAY='2003-01-02',SUM(LIS_QUANTITY),0) as
2003-01-02,IF(DAY='2003-01-03',SUM(LIS_QUANTITY),0) as
2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where
> YOUR_CONDITIONS GROUP BY DAY;
Regards,
Gelu
__
In the last episode (Mar 14), Murad Nayal said:
> how can I force mysql interactive client (actually the client library as
> well) to use a TCP port on the local host
>
> if I do:
>
> mysql -h localhost -u user -p --port=2000
>
> I get:
>
> ERROR 2002: Can't connect to local MySQL server throu
Add quotes to you date.
SELECT time_period_id FROM time_periods
WHERE '2003-03-14' BETWEEN time_period_start AND time_period_end;
Worked for me.
Roger
-Original Message-
From: Cory Hicks [mailto:[EMAIL PROTECTED]
Sent: Friday, March 14, 2003 3:05 PM
To: [EMAIL PROTECTED]
Subject: Findin
this article on cross tabulations should help you ...
http://www.mysql.com/articles/wizard/index.html
- hcir
(mysql sql query)
On Friday, Mar 14, 2003, at 11:40 America/Anchorage, DANIEL GADDIS
wrote:
I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...
+--
mysql -h 127.0.0.1 -u user -p --port=2000
Murad Nayal wrote:
Hello,
how can I force mysql interactive client (actually the client library as
well) to use a TCP port on the local host
if I do:
mysql -h localhost -u user -p --port=2000
I get:
ERROR 2002: Can't connect to local MySQL server t
Hi,
You can try to use IF(),CASE() function in the SQL statement.
Eg.
select USERID,IF(DAY='2003-01-02',COUNT(*),0) as
2003-01-02,IF(DAY='2003-01-03',COUNT(*),0) as
2003-01-03...how_many_days_you_wishfrom YOUR_TABLES where
YOUR_CONDITIONS GROUP BY DAY;
Regards,
Gelu
___
On Friday 14 March 2003 12:34, Jeremy Zawodny wrote:
> On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote:
> > This may help - I just got this from a friend.
> >
> > http://jeremy.zawodny.com/blog/archives/000203.html
>
> Ugh.
>
> I *really* need to update that. It has become a popular refe
Hello,
MySQL database connecting to:
3.22.32
when I select * from a table (with no primary key), the results are
displayed. I attempt to use the GRID to update a field of a record.
When I try to change it, I get the following error:
ERROR 1064: You have an error in your SQL syntax near 'LIMIT 1
Hi list,
few days ago, I have installed a 2nd CPU in my ProLiant380. I recompiled a
new kernel (2.4.17) for Debian 3.0. On the machine there is mySQL 3.23.52-2
installed (deb). Every thing works fine, just the logging of mySQL looks a
little funny to me, especially the time:
030314 19:31:1897
Hi,
- Original Message -
From: "Brian Johnson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 7:14 PM
Subject: Re: Looking for a bona fide distributed database that is open
source
> My experience may be limited but I don't know of any database that w
Hello,
how can I force mysql interactive client (actually the client library as
well) to use a TCP port on the local host
if I do:
mysql -h localhost -u user -p --port=2000
I get:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock'
what might be a problem is: i
I'm running MySql 4.0.10-gamma-max-nt-log
I have 1 table like the one below...
++-+--+
| DAY| USERID | LIS_QUANTITY |
++-+--+
| 2003-01-02 | H0850A1 | 539 |
| 2003-01-02 | LBBSWJR |7 |
| 2003-01-02 | O0
Cory,
> time_period_id int(11) NOT NULL auto_increment,
> time_period_start date NOT NULL default '-00-00',
> time_period_end date NOT NULL default '-00-00',
> PRIMARY KEY (time_period_id)
> I am trying to get the ID that relates to a date falling between the
> range of time_period_start
Hi,
IMHO:
The distributed database is a concept which is can not be assign to the SQL
engine standards(AFAIK).Stored procedures,triggers are described in the SQL
92 or SQL 99 standards.
It's quite right, some SQL DataBase engines(like Oracle,DB2,msSQL) have
implemented facilities for this.
Distrib
Quotes missing around dates.
WHERE "2003-03-14" ...
Ignatius
- Original Message -
From: "Cory Hicks" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 9:05 PM
Subject: Finding an ID between two dates
> Hey folks!
>
> I a
Hi,
I've hit a problem on AIX 4.3 with mysql client include files. My app needs
to include which includes . The problem is that I also
need to access mysql. It turns out that the mysql include directory also has
a dbug.h which get pulled in instead of the systems file.
The fix is simple, renam
Duh! I need '' around my datesorry for the traffic.
sql, query
Duh!
--
Cory Hicks
Texas Research International, Inc.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
ht
Hey folks!
I am stumpedbeen reading the online manual, google groups, to no
avail.
I have a very simple table:
time_period_id int(11) NOT NULL auto_increment,
time_period_start date NOT NULL default '-00-00',
time_period_end date NOT NULL default '-00-00',
PRIMARY KEY (time_period_i
Smurf wrote:
>
> >Description:
> "select distinct FOO from BAR" reports multiple NULL rows
> >How-To-Repeat:
> Unknown. It's a large table (1 entries or so). The problem
> didn't show with a simple test table.
>
> The table:
>
> -- MySQL dump 10.0
> --
> -- Ho
There are a few tools you can use to remotely administer MySQL graphically,
if that's what you're looking for. You might be interested in MySQL Control
Center http://www.mysql.com/products/mysqlcc/index.html although I'm not
entirely certain about it's support for secure data transmission.
Brian M
Matthias Trevarthan wrote:
>
> Howdy list,
>
> I run MySQL 3.23.54 with FreeBSD 4.6-RELEASE.
>
> We recently had a BBS get hammered by a lot of
> concentrated traffic.
>
> I currently run a 'mysql-optimize.sh' script from
> cron on Wednesday and Sunday that executes:
>
> ${bindir}/myisamchk -i
If this is really exactly what your code looks like, you've got an
extraneous comma after the Cwww line. But when you're tracking down a bug
like this, you may find it helpful to output the exact query that is being
executed, because often the problem will lie in the variable you're
inserting.
Bri
At 17:41 + 3/14/03, Andrew wrote:
yes you are right an I am very stupid for not doing this: It is
very important
for debugging as I now have this error :):)
Warning: mysql_query(): supplied argument is not a valid MySQL-Link
resource in
c:\program files\apache
group\apache\htdocs\punterspow
On 3/14/03 9:31 AM, "Paul DuBois" <[EMAIL PROTECTED]> wrote:
> At 8:04 -0800 3/14/03, Thomas Knight wrote:
>> How do I change Mysql default database location?
>
> Please explain what you mean by that?
Maybe you need to look at the commandline options or the my.cnf files. You
can specify the data
Mike,
I'm curious, is the value specified for the DRIVER argument the name of the
ODBC driver? If so, is this a general trick that can be applied to ADO for use
with other ODBC drivers, i.e. PostgreSQL?
Thanks,
--
Barry C. Hawkins
Systems Consultant
All Things Computed
[EMAIL PROTECTED]
40
Hi,
How would I go about setting up remote administration of MySQL. MySQL is
running on Windows 2000 and I will be connecting from Windows XP. I saw
something in the MySQL docs about using an SSH client like Secure CRT, but
it loses me at the linking OBDC.
Any help on this or another similar way
At 18:49 + 3/14/03, Andrew wrote:
I have an idea why this is but not 100% there is a diffeence in order between
query and Table the ItemID comes after the Ctelephone column in the DB. So
presumably this is the problem, but I realy haven't the foggiest why.
mysql("$DBName","UPDATE items
SET Ite
I have an idea why this is but not 100% there is a diffeence in order between
query and Table the ItemID comes after the Ctelephone column in the DB. So
presumably this is the problem, but I realy haven't the foggiest why.
mysql("$DBName","UPDATE items
SET ItemSKU='$ItemSKU',
ItemName='$ItemName'
>Description:
A constraint violation doesn't show which constraint was violated,
which is bad for fixing bugs.
>How-To-Repeat:
create table a(b int, index(b)) type=innodb;
create table c(d int, index(d)) type=innodb;
alter table c add constraint foo foreign k
Roger,
Thanks for the reply. That certainly doesn't give any errors but
'NATURAL JOIN' also unfortunately doesn't work.
If I just take the first section;
SELECT P.prodID, P.prodName FROM categories C NATURAL JOIN products P;
I get an empty set. However;
SELECT P.prodID, P.prodName FROM categori
At 8:04 -0800 3/14/03, Thomas Knight wrote:
How do I change Mysql default database location?
Please explain what you mean by that?
Tom Knight
Email: [EMAIL PROTECTED]
--
Paul DuBois, [EMAIL PROTECTED]
http://www.kitebird.com/
sql, query
-
At 10:49 +0100 3/14/03, Brandl, Thomas wrote:
> Hey everybody,
I want to replicate several tables from one database to all other
databases on the same machine, so to say a table-level-replication
Simply said, imagine this scenario:
A MySQL server with about 10 databases: A and 1 to 9.
Databas
>Description:
"select distinct FOO from BAR" reports multiple NULL rows
>How-To-Repeat:
Unknown. It's a large table (1 entries or so). The problem
didn't show with a simple test table.
The table:
-- MySQL dump 10.0
--
-- Host: localhostDatabase: pop
---
At 19:58 +0300 3/14/03, [EMAIL PROTECTED] wrote:
I have strange problem with LOAD DATA INFILE
$file="base.txt";
$conn=mysql_connect('localhost', 'user', 'paswd');
mysql_select_db('realestate', $conn);
$query="LOAD DATA INFILE '".$file."' REPLACE INTO TABLE
table_name FIELDS TERMINATED BY '\t' LINE
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March 2003 16:48
To: [EMAIL PROTECTED]
Cc: Kyle Lange
Subject: Re: How to implement this query - can you help pls?
* Kyle Lange
> Try as I might, I can't seem to work out the SQL for this query. Can
> yo
Hello Andrew,
Friday, March 14, 2003, 7:41:56 PM, you wrote:
A> yes you are right an I am very stupid for not doing this: It is very important
A> for debugging as I now have this error :):)
A> Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
A> c:\program files\ap
yes you are right an I am very stupid for not doing this: It is very important
for debugging as I now have this error :):)
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in
c:\program files\apache
group\apache\htdocs\punterspower\admin\updatecompanyresponse.php on li
On Fri, Mar 14, 2003 at 12:03:14PM -0800, Joe Stump wrote:
> This may help - I just got this from a friend.
>
> http://jeremy.zawodny.com/blog/archives/000203.html
Ugh.
I *really* need to update that. It has become a popular reference.
But I have some new information to add.
The short version.
At 8:02 -0800 3/14/03, Karam Chand wrote:
Hello
If you are on Win platform then there is a tool called
SQLyog at http://www.webyog.com/sqlyog which has a
very powerful Database Synchronization facility.
If I am not wrong then you can find a tutorial on
Synchronizatin with SQLyog at
http://www.phpb
Hello Andrew,
Friday, March 14, 2003, 6:18:15 PM, you wrote:
A> Can anyone tell me why this is not updating records for this table?
A> mysql_connect("$DBHost","$DBUser","$DBPass");
A> mysql("$DBName","UPDATE items
A> SET ItemSKU='$ItemSKU',
A> ItemName='$ItemName',
A> ItemDescription='$ItemDesc
At 16:18 + 3/14/03, Andrew wrote:
Can anyone tell me why this is not updating records for this table?
mysql_connect("$DBHost","$DBUser","$DBPass");
mysql("$DBName","UPDATE items
SET ItemSKU='$ItemSKU',
ItemName='$ItemName',
ItemDescription='$ItemDescription',
PostCode='$PostCode',
Category='$C
My experience may be limited but I don't know of any database that will allow a
single query to access mutiple database servers
In fact, only a few seem to be able to even access mutiple databases on the same server
Frankly, I am still looking for a db that provides n way replication (this may so
Hi,
Given a simple tree structure represented in a table shown below:
group_id: int
parent_group_id: int
description: varchar
I am trying to select all rows from a table where the group_id does not
appear elsewhere as a parent_group_id, hence selecting only the leaf nodes.
I have wrestled with t
* Kyle Lange
> Try as I might, I can't seem to work out the SQL for this query. Can you
> help please?
I'll try.
> I need to retrieve a list of products within a certain category with
> their relevant prices obtained from a specific (date-based) *valid*
> pricelist relevant to a particular person
I have strange problem with LOAD DATA INFILE
$file="base.txt";
$conn=mysql_connect('localhost', 'user', 'paswd');
mysql_select_db('realestate', $conn);
$query="LOAD DATA INFILE '".$file."' REPLACE INTO TABLE
table_name FIELDS TERMINATED BY '\t' LINES TERMINATED
BY '\r\n'";
mysql_query($query,
Hi,
I'm having some serious performance issues that are stemming from MySQL
writing data to tables. MySQL seems to cache writes, then write the
block all at once. The major issue I'm having with this is that it when
it does this it stops processing other requests until it's finished. I
have listed
This may help - I just got this from a friend.
http://jeremy.zawodny.com/blog/archives/000203.html
--Joe
--
Joe Stump <[EMAIL PROTECTED]>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."
-Original Message-
From: Matthias Trevarthan [mailto:[EMAIL PROTE
At 9:55 -0500 3/14/03, Bruce Feist wrote:
Gelu Gogancea wrote:
To anyone that *didn't see the forest because of the trees*.
You already find it.
Is MySQL really distributed, or just client-server? I've seen no
indication of distributed capabilities; I'm new to MySQL, so maybe I
just haven't r
On the contrary, I use MyODBC and NEVER use a DSN, hate the things.
Here is the connection string I use:
DRIVER={MySQL ODBC 3.51
Driver};SERVER=123.456.789.100;DATABASE=mysqldatabase;UID=sampleuser;PWD=123
45; OPTION=16427
It works great, sometimes I add 2048 to the options value to use the
com
At 10:13 -0500 3/14/03, Keith C. Ivey wrote:
On 14 Mar 2003, at 0:28, felix t wrote:
I would like to ask for some ideas on how to build
such a dictionary given that I can not use more than
one set of characters in mysql server. ( the russian
words need on set of characters , the french ones
a
Hi,
I'm trying to do a SELECT which then counts records in two separate
tables, eg:
SELECT a_id, count(b_id) FROM a LEFT JOIN b USING(a_id)
merged with
SELECT a_id, count(c_id) FROM a LEFT JOIN c USING(a_id)
So you would end up with
a_id, count(b_id), count(c_id)
Showing the number of records l
Can anyone tell me why this is not updating records for this table?
mysql_connect("$DBHost","$DBUser","$DBPass");
mysql("$DBName","UPDATE items
SET ItemSKU='$ItemSKU',
ItemName='$ItemName',
ItemDescription='$ItemDescription',
PostCode='$PostCode',
Category='$Category',
CityID='$CityID'
CTelephone
How do I change Mysql default database location?
Tom Knight
Email: [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hello
If you are on Win platform then there is a tool called
SQLyog at http://www.webyog.com/sqlyog which has a
very powerful Database Synchronization facility.
If I am not wrong then you can find a tutorial on
Synchronizatin with SQLyog at
http://www.phpbuilder.com
Karam
--- Florent Martineau
Thanks a lot Walt,
do you happen to have any code examples/fragments handy you can share?
thanks again
walt wrote:
>
> Murad Nayal wrote:
>
> > Hello,
> >
> > I wonder if anyone has encountered this problem before and has any
> > ideas. I need to run programs on a linux cluster that make cl
> So, my questions are these:
> ---
>
> Can any experienced MySQL-FreeBSD admins out there
> give me some pointers for identifying bottlenecks?
I have been running MySQl-FreeBSD for over a year now and we are now doing
about 140-150,000 page views a day all dynamic from t
Quoting "Tamayo, Nelson" <[EMAIL PROTECTED]>:
> I am trying to connect to MySQL without using a DSN entry, this is my
> connection string
>
> DRIVER={MySQL ODBC 3.51
> Driver};SRVR=159.113.44.49;DB=csapps;UID=user;PWD=password
>
> The error I get is
>
> "Invalid connection string attribute"
>
In addition I would suggest to verify that your text file does not end with
a CR or LF character. This happens very often on Windows systems when for
instance saving an Excel sheet as a text file.
If you do not remove this last character(s), you risk inserting a blank row
in the DB.
Ignatius
Murad Nayal wrote:
> Hello,
>
> I wonder if anyone has encountered this problem before and has any
> ideas. I need to run programs on a linux cluster that make client
> connections to an mysql database on a different server. this linux
> cluster is set up where only the main node has an internet c
No, it is not distributed.
Bruce Feist wrote:
Gelu Gogancea wrote:
To anyone that *didn't see the forest because of the trees*.
You already find it.
Is MySQL really distributed, or just client-server? I've seen no
indication of distributed capabilities; I'm new to MySQL, so maybe I
just hav
Kyle Lange wrote:
I need to retrieve a list of products within a certain category with
their relevant prices obtained from a specific (date-based) *valid*
pricelist relevant to a particular person.
TABLE: persons - perID
TABLE: priceList - listID, validFrom, validTo
TABLE: intPerPriceList - perI
On 14 Mar 2003, at 0:28, felix t wrote:
> I would like to ask for some ideas on how to build
> such a dictionary given that I can not use more than
> one set of characters in mysql server. ( the russian
> words need on set of characters , the french ones
> another ).
Presumably you're using Unico
Hi,
I'm searching for a mysql diff tool to update my database when changing
structure and so.
Does anybody outthere knowing such a tool ?
Thanks
- Florent
-
Before posting, please check:
http://www.mysql.com/manual.php (
You are mixing table and global grants together here.
Use separate grant commands. I am too lazy to look
it up right now, but FILE is global. I am not sure about
CREATE and DROP.
Aso, I believe that should be 'id'@'127.0.0.1'
not localhost.
localhost always connects to the pipe.
SSH connects to a
Howdy list,
I run MySQL 3.23.54 with FreeBSD 4.6-RELEASE.
We recently had a BBS get hammered by a lot of
concentrated traffic.
I currently run a 'mysql-optimize.sh' script from
cron on Wednesday and Sunday that executes:
${bindir}/myisamchk -i -r --check --sort-index --analyze ${datadir}/*/*.MY
Sorry people. I switched the receipt off originally, but the filter on
the server sent it back and I just replied forgetting the receipt 2nd
time round.
Apologies.
Kyle
-Original Message-
From: Kyle Lange [mailto:[EMAIL PROTECTED]
Sent: Friday, 14 March 2003 15:46
To: [EMAIL PROTECTED]
At 11:50 +0200 3/14/03, Sebastian Stan wrote:
i have 2 DBFs and i'm doing the same thing on both of them : (i'm
transforming the DBFs in TXTs)
(in foxpro) " copy to .txt delimited with '^' with character '#' "
When :
LOAD DATA LOCAL INFILE '.TXT' into table fields
terminated by '#' OPTIONALL
Gelu Gogancea wrote:
To anyone that *didn't see the forest because of the trees*.
You already find it.
Is MySQL really distributed, or just client-server? I've seen no
indication of distributed capabilities; I'm new to MySQL, so maybe I
just haven't read enough. But a distributed DBMS should
Please read the warning.
It attempting a LOCAL connection.
Please enter the host ( server) you wish to connect to.
Jon Miller wrote:
I'm having a problem connecting to MySQL database using phpMyAdmin from
a remote location. I've had a look at the manual but I'm not too clear
on what has to be don
Hi,
Try as I might, I can't seem to work out the SQL for this query. Can you
help please?
I need to retrieve a list of products within a certain category with
their relevant prices obtained from a specific (date-based) *valid*
pricelist relevant to a particular person.
TABLE: persons - perID
T
Vlad Shalnev wrote:
Hi, All
Can two mysql servers work on the same database directory ? It it possible in
read only mode or in read and write mode ?
With best regards
Yes, if you don't disable file locking.
Why would you do this though?
Each server will have to lock the files, blocking t
You can try UTF-8.
- Cs.
I guess you'd have to use MySQL 4.1 to assign different character sets
to different columns. Should be straight-forward at time of table creation.
David
***
Hello,
I'm interested in building a translation dictionary:
russian -
Hello,
I wonder if anyone has encountered this problem before and has any
ideas. I need to run programs on a linux cluster that make client
connections to an mysql database on a different server. this linux
cluster is set up where only the main node has an internet connection.
so the problem is
NOT NULL does not mean you can not leave the field empty.
It means the field can not contain the value NULL
All the empty fields get the default values you declared.
If you did not declare a default value, standard default values
for each data type are used.
Steve Holt wrote:
I am linking an MS Ac
I guess you'd have to use MySQL 4.1 to assign different character sets
to different columns. Should be straight-forward at time of table creation.
David
***
Hello,
I'm interested in building a translation dictionary:
russian - french. My database wou
I am trying to connect to MySQL without using a DSN entry, this is my
connection string
DRIVER={MySQL ODBC 3.51
Driver};SRVR=159.113.44.49;DB=csapps;UID=user;PWD=password
The error I get is
"Invalid connection string attribute"
Any ideas?
Nelson Tamayo
Claims Automation
(800) 237-7767 x3520
The way i do it, i don't put the AddType application/x-httpd-php .php in the
httpd.conf as a global entry, since i host sites in VirtualHosts, I only
place the AddType application/x-httpd-php .php directive in their respective
VirtualHost entry for those sites who needs or pays for php based hostin
Hi:
I'm running MySQL 4.0.11 (MySQL.com binary RPMs) on Red Hat Linux 7.3, all
errata applied (kernel 2.4.18-26.7.xsmp).
This morning, our server died hard, with the following error:
030314 2:44:13 InnoDB: Assertion failure in thread 7938074 in file
btr0btr.c line 298
When the server then tri
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gustavo Cebrian wrote:
We are trying to set a TimeStamp in mysql from Java.
We use the set TimeStamp funcion in PreparedStatement, but the date is not logged
properly in the database. ( We are using a DateTime in the database ).
In other words, does JD
I'm having a problem connecting to MySQL database using phpMyAdmin from
a remote location. I've had a look at the manual but I'm not too clear
on what has to be done. I see that the connection is through a socket.
Can I change this to connect using an ip connection? Reason I ask is
because the M
Please help! I tried to do simple search using the longtext field using the
the MATCH and AGAINST query but to no success. The funny thing is, I can do
it in the earlier MySQL version. I have updated the latest MySQL and PHP
using the up2date (RH8.0) without any intervention being done.
Previous v
1 - 100 of 109 matches
Mail list logo
