Jim,
Jim Bailey schrieb:
>
> sql, Query
> Hark ye experts!
>
> Here I stand an expert grunt.
> Trying to understand,
> The syntax of constraint.
>
> I was directed to the constraint doc.
> And found the constraint doc doth suck.
>
> Here's my ploy, renewed, refined.
> Please see if you can he
Hi All,
I am very new with mysql. I have just installed it to Sun OS but there
is a message " ERROR 2002: Can't connect to local MySql server thought
'/tmp/mysql.sock' (2)".
Does anyone have knowledge about problem and help me?
Regards,
**
Hi,
I used DbTools as Crecio O. Silva mentioned in his mail and I managed to
import Paradox tables to MySQL successfully..
There is still a problem with the imported data which are not imported
correctly because of the Greek chars that appear in the string fields.
Could anyone have a clue how we
Is it possible to use phpMyAdmin to add new databases (not tables whole
databases) to my website? I ask because currently my host has provided
me with one database and I don't want to mix database tables when adding
new features (such as shopping carts and bulletin boards)? I am new to
MySQL and P
If i have a single quote (') inside the /* */ comments,
it gives me a syntax error. Why?
Thanks
--
sherzodR
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
On Wed, 21 Aug 2002, Kai Vermehr wrote:
> how can I calculate the difference between two dates in days? I'd like to
> get the days to go between and a job-deadline in the future.
>
> thank)s to MySQL
>
> --
> Kai Vermehr
> eBoy Graphics
> http://www.eboy.com
Using a single MySQL select query to
On Tue, 20 Aug 2002, Matt Heaton wrote:
> Hi, I am running 3.23.49 and had a quick question I hope someone can answer.
> 70% of the time my sql server is doing just fine. I have 4 GIGs of memory,
> and a 1.33 Ghz processor.I am running Redhat 7.3 with a 2.4.19 kernel.
>
> 70% of the time m
You have written the following:
SET [SESSION | GLOBAL] TRANSACTION ISOLATION LEVEL [SERIALIZABLE| ...]
The above statement i take it will prevent transaction 2 from selecting a
value until transaction 1 committs.
Is this correct?
and Question 2, Does this have to be executed before every tra
Dear Friends
I observed the very strange problem with my Mysql , My be this is the feature or I
have not configured it properly
please do tell me the reasons and remedy.
Problem is
I am inserting the fields through VB.
When I insert the record in the table of Mysql . Mysql inserts the record
Hi, I am running 3.23.49 and had a quick question I hope someone can answer.
70% of the time my sql server is doing just fine. I have 4 GIGs of memory,
and a 1.33 Ghz processor.I am running Redhat 7.3 with a 2.4.19 kernel.
70% of the time my server is fine, the other 30% it is 100% max
please help! i have all indices in place and my sql queries are all very
fast etc. UNTIL i do the following:
select
count(id)
,count(distinct username) thecount
from
appviews
group by
id
order by thecount
briefly put, this query tries to get the the overall views f
Filter fodder: query, sql
On Wednesday 21 August 2002 3:03 am, Nathaniel Mallet wrote:
> I haven't read Managing and Using MySQL, but I do own (and read cover to
> cover) MySQL and mSQL. While it's not a bad book, it's definitely not
> for anyone wanting to do anything serious. It's about 460 pag
I haven't read Managing and Using MySQL, but I do own (and read cover to
cover) MySQL and mSQL. While it's not a bad book, it's definitely not
for anyone wanting to do anything serious. It's about 460 pages that
covers *two* databases, plus references for half a dozen APIs, which
means they skim m
j.random.programmer wrote:
> Hi:
>
> Firstly, I'd like to congratulate both MySQL AB and
> Mr. Mathews on making the JDBC driver an officialy
> supported download.
>
> I have a query though. Newer versions of the mm.mysql
> driver (now called connector/j) will be released *not*
> under the LGPL
Maybe you should be a poet, lol
- Original Message -
From: "Jim Bailey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 7:00 AM
Subject: Constraint Hell
> sql, Query
> Hark ye experts!
>
> Here I stand an expert grunt.
> Trying to understand,
> The syntax of co
how can I calculate the difference between two dates in days? I'd like to
get the days to go between and a job-deadline in the future.
thank)s to MySQL
--
Kai Vermehr
eBoy Graphics
http://www.eboy.com
-
Before posting, pleas
You might want to use the full join syntax here to be clear on what is
happening.
select
title as Title,
COALESCE(o.name,'None') as Organization
from m
left join o on o.ID = m.organization
Also, notice COALESCE. Much less messy.
Brian.
- Original Message -
From: "Quinten Steenhuis
Hi,
"SHOW CREATE TABLE " show you all what you need about table requested.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Mess
I would use some sort of scripting language (PHP for
example) to format the date, and have that script
import the data into your table, rather than using
LOAD DATA INFILE.
If you post a sample of how your data file is
formatted, someone will gladly help you out. You might
want to post this to the
On 21 Aug 2002, at 5:01, Joseph Grundy wrote:
> Example I have a table created lets say prices, in table prices
> there are 15 columns named 1 through 15. I want to be able to
> populate one column say 8 with data I exported from a column
> in a different database, using the txt file.
So you h
On Tuesday 20 August 2002 09:02 pm, Froilan Mendoza wrote:
> Walt,
>
> At 01:09 PM 8/20/2002 -0400, walt wrote:
> >on the slave you should run
> >show slave status
>
> on slave:
> mysql> show slave status;
> +-+-+-+---+
>-+---
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
Date: Tue, 20 Aug 2002 21:51:24 +0100
To: "Joseph Grundy" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: insert command
> Joseph,
>
> > I need to know if there is a way to do a simple insert from a
.txt file,
> using insert
- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
Date: Tue, 20 Aug 2002 16:50:39 -0400
To: [EMAIL PROTECTED]
Subject: Re: insert command
> On 21 Aug 2002, at 4:27, Joseph Grundy wrote:
>
> > I need to know if there is a way to do a simple insert from a .txt
> > file, using
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
Date: Tue, 20 Aug 2002 21:51:24 +0100
To: "Joseph Grundy" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
Subject: Re: insert command
> Joseph,
>
> > I need to know if there is a way to do a simple insert from a .txt file,
> using inser
What I need to obtain is the table information. Column names, type,
length, etc. Someone suggested using the EXPLAIN or DESCRIBE commands, but
ColdFusion is not returning it as a valid queryset. Are the result sets of
these commands ODBCable? I am using MyODBC on Linux.
-Original Message-
Serge,
Why didn't you give this information/constraint in the first place? Why now
complain that it is not a "very automated" solution? Why narrow your mind to
assume that the problem is with MySQL?
"Them" are going to be a problem to many of their 'clients' then, because
CCYY-MM-DD is the inter
Serge Paquin wrote:
> This is the only option? That's not a very automated process and I must import this
>data once a day. I also will not be able to get them to reformate their data since
>I'm only one of many many people downloading everyday. Is their no way for load data
>to do this aut
- Original Message -
From: "Keith C. Ivey" <[EMAIL PROTECTED]>
Date: Tue, 20 Aug 2002 16:50:39 -0400
To: [EMAIL PROTECTED]
Subject: Re: insert command
> On 21 Aug 2002, at 4:27, Joseph Grundy wrote:
>
> > I need to know if there is a way to do a simple insert from a .txt
> > file, using
Walt,
At 01:09 PM 8/20/2002 -0400, walt wrote:
>on the slave you should run
>show slave status
on slave:
mysql> show slave status;
+-+-+-+---+-+-+--+---+---
On Tue, Aug 20, 2002 at 04:40:25PM -0400, Serge Paquin wrote:
> This is the only option? That's not a very automated
>process and I must import this data once a day. I also will
>not be able to get them to reformate their data since I'm
>only one of many many people downloading everyday. Is the
Joseph,
> I need to know if there is a way to do a simple insert from a .txt file,
using insert and only populate one column. Its a streamline db and I want to
enter only a few of the columns.
>
> I have exported all data into txt files at this point. I can not find any
mention on mysql's site ot
On Tue, Aug 20, 2002 at 04:03:03PM -0400, Lon Lentz wrote:
>
> I have a web based ad hoc query builder I built for running
> against SQL Server databases. I am trying to port it to mysql. I
> need a way to return table info through a query. Is there a way to
> return syscolumns type info in st
Hi,
Maybe can be useful.MySQL suport and UDF.
But you can solve this problem in the next way:
@a:=0;-initialize variable a
select @a:MAX(YOUR_COLUMN_FROM TABLE) from YOUR_TABLE;
select @a:=@a+1;
insert into YOUR_TABLE SET YOUR_COLUMN_FROM TABLE= @a,bla,bla...;
Regards,
Gelu
This is the only option? That's not a very automated process and I must import this
data once a day. I also will not be able to get them to reformate their data since
I'm only one of many many people downloading everyday. Is their no way for load data
to do this automaticaly?
Serge.
On Tue
Hello Serge,
> I am having troubles with Load Data Infile and cannot figure out the
problem. I have a date field but the format is 'Jan 1 1986' rather than
mysql's default. So when I import I only get '-00-00' rather than the
date. How can I tell MySQL what the format is?
>
> I have read
I need to know if there is a way to do a simple insert from a .txt file, using insert
and only populate one column. Its a streamline db and I want to enter only a few of
the columns.
I have exported all data into txt files at this point. I can not find any mention on
mysql's site other than do
Hello,
I am having troubles with Load Data Infile and cannot figure out the problem.
I have a date field but the format is 'Jan 1 1986' rather than mysql's default. So
when I import I only get '-00-00' rather than the date. How can I tell MySQL what
the format is?
I ha
Hi!
Like the manual states, CREATE TABLE, INSERT etc. database operations are
blocked when 'newraw' is specified. That is a safety measure. You must not
forget 'newraw' to my.cnf, as that will wipe over the partition at the next
startup.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - trans
Quinten Steenhuis wrote:
> Sql, query
>
> > Hi,
> >
> > I have a field that I need to do a join on. Unfortunately, the column is
> > allowed to be null (and it should be). My plan is to return the literal
> > string 'None' if the column is null, and otherwise to return the joined
> > value. How c
I have a web based ad hoc query builder I built for running against SQL
Server databases.
I am trying to port it to mysql. I need a way to return table info through
a query. Is
there a way to return syscolumns type info in standard column and row
format?
__
Lon Lentz
I get the following error when loading the mysql.h header file.
[C++ Error] mysql_com.h(118): E2303 Type name expected
[C++ Error] mysql_com.h(118): E2139 Declaration missing ;
The error is occuring in teh mysql_com.h header file when the my_socket data member in
the structure st_net.
Frank Me
you grab the balance , manipulate it by adding or subtracting an amount then
updating it.
Randy
- Original Message -
From: "Tod Harter" <[EMAIL PROTECTED]>
To: "bin cai" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 3:35 PM
Subject: Re: web application test tool
On Tuesday 20 August 2002 01:26 pm, Randy Johnson wrote:
> I am confused. (innodb table type)
I'm really not so sure about the 'lock in share mode' thing, but to the best
of my knowledge if you do a
SET TRANSACTION_ISOLATION_LEVEL=SERIALIZABLE
and then start a transaction where you read data f
Hi all,
I will appreciate if someone could give me some advice.
I am going to make a 6.5 mill. phone directory database, and after some
previous advice I am able to make a search in a fraction of a second.
However there should only be a single search line, not different fields for
First, Last -
On Tuesday 20 August 2002 01:06 pm, bin cai wrote:
check out www.owasp.org, there are some good links there for various tools,
mostly for correctness and security testing, but it should give you some good
starting points. Check out www.freshmeat.net as well, I am pretty sure some
stuff has sho
It used to do what you are saying. That was very bad. For example, we
stored click data for articles. Whe the articles were archived for speed
reasons, MySQL started filling in the holes. When we got back around to
archiving those rows, we could not do so as the archive table already had
rows
Do you have phpMyAdmin running yet? If so you create new databases with the
click of a button. The first page you see should say Welcome to phpMyAdmin
...ver etc. If you have set phpMyAdmin to run on an existing MySQL install,
the drop down boxes "should" contain your existing databases if configu
Sql, query
> Hi,
>
> I have a field that I need to do a join on. Unfortunately, the column is
> allowed to be null (and it should be). My plan is to return the literal
> string 'None' if the column is null, and otherwise to return the joined
> value. How can I do this, when the inner join that I
Hello.
On Tue 2002-08-20 at 13:18:04 -0500, [EMAIL PROTECTED] wrote:
> Through your MySQL documentation, I wasn't able to find a function that I
> think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field,
> it will still be able to add the next highest value to this column on a
I am new to MySQL and PHP.
Having looked at PHPMyAdmin the GUI I was wondering if it's possible to
create a new database within the system?
If so what are the commands? I ask because I only have one database on my
server and don't want to populate it with different tables, I'd rather have
seperate
I am trying to install MYSQL on Solaris 9 sparc edition. I am using the
following options:
CFLAGS="-O3 -mcpu=v8 -Wa,-xarch=v8plusa" CXX=gcc
CXXFLAGS="-O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-constructors -fno-exceptio
ns -fno-rtti"
./configure --prefix=/usr/local/mysql --localstatedir=/www_data/my
Hi.
On Tue 2002-08-20 at 10:58:53 +0200, [EMAIL PROTECTED] wrote:
>
> As stated in description:
> "A MERGE table is a collection of identical MyISAM tables that can be used as
> one. ", i.e. content of these tables, being merged, is merged also. I need the
> opposite - one physical table being
Through your MySQL documentation, I wasn't able to find a function that I
think could be useful. If you DELETE a row with an INT AUTO_INCREMENT field,
it will still be able to add the next highest value to this column on an
INSERT (ex. If after INSERTing rows, you DELETE a row with a value of five
Is it fixed only in MySQL 4.x, or will it be in the next point
release of 3.x as well?
Cheers,
Rich
> -Original Message-
>Thanks for bug report!
>
>If NULL is present (t_calllog_calls.call_end -
>t_calllog_calls.call_start < 5) the result_type is changed from
>int to char.
>
>It was fi
Oh, but the caveat for this is that the table will be destoyed when the
connection is closed. So, if you need this to hang around, you will just
need to create another table with this data, or just use that join in your
query.
Brian.
- Original Message -
From: <[EMAIL PROTECTED]>
To: ""
That should work just fine.
Brian.
- Original Message -
From: <[EMAIL PROTECTED]>
To: ""Brian Moon"" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 12:51 PM
Subject: Re: MySQL and creating views..
| Thanks Brian. But another question is, I looked up CREATE
Thanks Brian. But another question is, I looked up CREATE TEMPORARY TABLE
What I want to know is can I do the following:
create temporary table (select [distinct] jump.name, jump.address,
bike.city, bike.state, skate.zipcode, skate.car, skate.name, skate.city
from jump, bike inner join sk
I am confused. (innodb table type)
Client 1.
starts transaction
selects balance from table where id=1 for update
update table set balance=100
#At this point from what i have read the balance could be selected by anther
user.
committ
I have read that a select balance from table where id=1 lock
SELECT c.customerID,CONCAT(...) ,COUNT(i.customerID) as Num
FROM customers c,invoice i WHERE c.customerID = i.customerID GROUP BY
c.customerID ORDER BY Num DESC LIMIT 0,10 ;
Sorry, solved my own difficulty.
On Tue, 20 Aug 2002, Quinten Steenhuis wrote:
> Date: Tue, 20 Aug 2002 13:01:17 -0400 (
Froilan Mendoza wrote:
> Hello,
>
> I have two machines that I am trying to use replication on. Here are their
> configurations:
> master (my.cnf)
> log-bin
> serveri-d = 1
>
> slave:
> server-id = 2
> master-host=master.domain.com
> master-user=replicate
> master-password=replicatedb
> lo
Do you need to create a temp table or a heap table? Temp tables support
those columns fine. Heap tables do not.
Brian.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 11:44 AM
Subject: MySQL and creating views..
| I am new to
Hi,
I have completed a web-based application using java
servlet with mysql as the backend database and tomcat
as the server. I try to test my application
performance using a free test tool. i found one called
Microsoft Web Application Stress tool) it is free. but
it's test script is used by AsP.
I have a simple query that I must have framed incorrectly, because MySQL
returns an error:
SELECT c.customerID,CONCAT(...) as Cust FROM customers c,invoice i WHERE
c.customerID = i.customerID ORDER BY COUNT(i.customerID) LIMIT 0,10;
This tells me ERROR : Invalid use of group function
How c
You are displaying your strings in hexadecimal format.
Sergio Barbosa Villas-Boas wrote:
>Hi, all
>
>I need help on this.
>I'm testing mysql.
>I did a very simple table and I'm writing a C++ application to read data
>from it.
>The connection/authentication/query part of the application seems to
in a innodb table type using mysql max
is a begin statement the same as set autocommitt = 0??
Randy
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
I am new to this group. I am part of a small website dev shop and we just started
using MySQL. I was tasked with the following:
Write a perl script(did this part) to open up the MySQL database and create a View (a
temp table) from 3 different tables. I thought no problem I know how to do this I
Hello,
I have two machines that I am trying to use replication on. Here are their
configurations:
master (my.cnf)
log-bin
serveri-d = 1
slave:
server-id = 2
master-host=master.domain.com
master-user=replicate
master-password=replicatedb
log-bin
I followed the steps in the manual but fou
hello
i have just insalled mysql++ API and I am trying to run Example Program
I am gettin error : undefined reference to MysqlConnection::~MysqlConnection(void)
-I am a newbie in C stuff particularly on linux platform,please help me to solve this
problem
I am using Redhat7,2 and gcc version 2.9
Filter fodder: mysql, query
Hi,
I think the O'Reilly books
- Managing and Using MySQL
- MySQL and mSQL
and _very_ good.
and if you want a real tome, then try
- Mastering SQL, by Martin Gruber, pub. by SYBEX
Donna
On Tuesday 20 August 2002 3:40 pm, John Gruber wrote:
> Actually... Jay Greenspan
> is a begin statement the same as set autocommitt = 0??
Nope, I didn't change autocommit.
Yuri.
FOR FILTER: sql, connect
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Heh...ya I knew I fogot to do something. You would think that would be an
install step.
Next task is recompilling the apache httpd as it doesnt like not having
the libmysqlcleint.so.10 file which is now libmysqlcleint.so.11
thx for the tip. =D
-Nick
louie miranda said:
> Add the mysql lib path
in a innodb table type using mysql max
is a begin statement the same as set autocommitt = 0??
Randy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi, all
I need help on this.
I'm testing mysql.
I did a very simple table and I'm writing a C++ application to read data
from it.
The connection/authentication/query part of the application seems to work
fine.
However, the text data I'm getting from the database seems encrypted by some
simple alg
I created 4096M raw InnoDB space
-- all was fine. Right after this
I tried to create some type=InnoDB
table. It fails with the message
"can't create table './db/tbl.frm'
(errno=133)".
After I change newraw to raw in my.cnf
and restart MySQL it works fine.
Not a big problem for me but maybe it
in
Ady,
Tuesday, August 20, 2002, 12:11:03 PM, you wrote:
AW> Hi All, i've sent a letter to [EMAIL PROTECTED] but until now it still no answer.
AW> Actually it's an active email address or not ?
AW> Please give me better suggestion, because i love this MySQL products and i want to
make a partners
Actually... Jay Greenspan's MYSQL Weekend Crash Course is a very quick read
and has NT instructions in it.
It is limited in its functionality, but if you are used to MS SQL Enterprise
Manager, MyCC will be a quick learn for you. The Windows version installs
quickly and work reasonably well.
Joh
* Luc Foisy
> > -Original Message-
> > From: Roger Baklund [mailto:[EMAIL PROTECTED]]
>
> > * Harald Fuchs
> > > In article <[EMAIL PROTECTED]>,
> > > Victoria Reznichenko <[EMAIL PROTECTED]> writes:
> > >
> > > > As you can see txt1 and txt2 contain text file ~ 8M
> > >
> > > > UPDATE tbl
We use a class for all our MySQL stuff that has some error stuff and
commonly used function combinations (like do a query then do a numrows). In
that we create a connection only when the query method is called. So, until
a query is run, no connection is made. If the update server name does not
Ta,
But is it normal to have Temp table bigger than 10meg? And a lot of them?
Here is my latest data from STATUS
Created_tmp_disk_tables 46598
Created_tmp_tables 87839
Uptime 81773
And I have set tmp_table_cache to 10M
I know I could just up the tmp_table_size but I am more concerned about the
hi,
i use delphi, myodbc and mysql(myisam tables)
when i select large query ( approximately 2000 records) then
my program alert "BDE Error $000F"
, it is memory error ok, but i could not its solutions
-
Before posting, please
Hi
Not sure if this is simpler or not but..
install MyODBC, set up a Paradox alias for your MySql database
Using Paradox, copy the paradox tables to the MySql database. This converts
all the field types and copies the data over. I am not sure if it will do
memo fields it may depend
Hello,
Edit your my.cnf and add the following line in the [mysqld] section:
set-variable = max_connections=500
or set it to anything you need.
Regards,
Iikka
**
* Iikka Meriläinen *
* E-mail: [EMAIL PROTECTED] *
* Vaala, Finland
Magnet,
Monday, August 19, 2002, 11:11:38 PM, you wrote:
M> I manage a web server having a lot of http connections, using
M> Apache/PHP/MySQL. When there are too many simultaneous connections (so, many
M> MySQL requests), MySQL stops working efficiently and makes my load average
M> increase a LOT
Randy,
Monday, August 19, 2002, 7:29:43 PM, you wrote:
RJ> Thanks for your reply, is it documented somewhere?
That COMMIT and ROLLBACK release locks? Of course, look at:
http://www.mysql.com/doc/en/InnoDB_transaction_model.html
--
For technical support contracts, goto https://order.my
Mansoor,
Tuesday, August 20, 2002, 4:55:28 PM, you wrote:
MA> We are facing a problem related to mysql connections.
MA> The error saying that:-
MA> TOO MANY CONECTONS OPEN:
MA> Mysql server max_connections variable is currently set to 100,
MA> please tell me how i can change the max_connections
Randy,
Tuesday, August 20, 2002, 8:51:36 AM, you wrote:
RJ> Here is an insert from the innodb reference manual
[skip]
RJ> The solution is to perform the SELECT in a locking mode, LOCK IN SHARE MODE.
RJ> SELECT * FROM PARENT WHERE NAME = 'Jones' LOCK IN SHARE MODE;
[skip]
RJ> This means that
Brian,
Monday, August 19, 2002, 11:48:16 PM, you wrote:
BJ> I have a SQL statement to create a PostgreSQL table that include a line 'id serial'
BJ> This line creates a integer field with a sequence atached to it to create an
autonumber
In MySQL you can use AUTO_INCREMENT:
http://www.mysql.
John,
Tuesday, August 20, 2002, 11:55:55 AM, you wrote:
JW> MySQL is creating about 50% of temp tables on disk and this is with 10Meg of
JW> temp table cache. Is this normal? and sould I up temp table cache further.
Yes it's normal. Since 3.23 MySQL autommatically converts temporary
tables to di
Tod,
thanks for your input,
I cannot find this requirement in my help-file for MySQL 3.23.45. I think, it
appears in MySQL 4
Anyway, in MySQL 4, one can symlink tables, as described in chapter
5.6.1.2 Using Symbolic Links for Tables
Well, well, probably old-fasionated way to acces through DB
> Also, what we have done is used a replicating box as a select only server.
> This requires you to write your code in such a way that only selects get
> sent to the slave. A simple function wrapper in PHP is all we needed.
I've been thinking of this idea too but it's a bit of a problem becau
On Monday 19 August 2002 09:12 pm, Jocelyn Fournier wrote:
except, leave off the 'f.' on 'f.count(*)'. Remember there is only one count
of records, the count of returned rows from the join, there is no need to
qualify that with a table identifier... (and I think it would be a syntax
error if y
Hi Nick,
If you don't mind about the OS, yes there is. DBTools can handle Access,
ODBC, Excel, Paradox, FoxPro, Clipper&DBase. You can get it from
http://www.dbtools.com.br.
[]s
Crercio
- Original Message -
From: "Nick Lazidis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
Isn't that what the MySQL-Replication is for?
Thomas
On Tue, 20 Aug 2002 08:07:24 -0500
"Brian Moon" <[EMAIL PROTECTED]> wrote:
> This is an interesting idea. I would be a happy man if it would actually
> work. My experiences with NFS would lead me to believe that this would not
> help and co
> -Original Message-
> From: Roger Baklund [mailto:[EMAIL PROTECTED]]
> * Harald Fuchs
> > In article <[EMAIL PROTECTED]>,
> > Victoria Reznichenko <[EMAIL PROTECTED]> writes:
> >
> > > As you can see txt1 and txt2 contain text file ~ 8M
> >
> > > UPDATE tbl1 SET total=CONCAT(txt1,txt2)
On Tuesday 20 August 2002 05:52 am, Nick Lazidis wrote:
Its relatively straightforward to do it with a perl script.
Just set up an ODBC data source to the Paradox database and install perl DBI
and the DBD::ODBC and DBD::MySQL drivers. Then you can simply read records
from Paradox via ODBC and
Also, what we have done is used a replicating box as a select only server.
This requires you to write your code in such a way that only selects get
sent to the slave. A simple function wrapper in PHP is all we needed.
Brian.
- Original Message -
From: "Brian Moon" <[EMAIL PROTECTED]>
To
Why can't you just give permissions to each user to that table?
Then you can even grant/deny access to it on a user by user basis...
> -Original Message-
> From: Dmitry Kuznetsov [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 4:43 AM
> To: Benjamin Pflugmann
> Cc: [EMAIL PROT
This is an interesting idea. I would be a happy man if it would actually
work. My experiences with NFS would lead me to believe that this would not
help and could hurt the performance of existing MySQL server even more. My
use has been limited to a file server for our web nodes, so, this is a b
On Tuesday 20 August 2002 06:27 am, Sergei Golubchik wrote:
The key quote from the manual is...
All used tables must be in the same database as the MERGE table itself.
which makes sense. Fundamentally a database is an independent unit of data
storage. You can't share data between two seperate
On Tuesday 20 August 2002 06:39 am, Luis Calero wrote:
NFS locking is ALWAYS problematical. You might have no problems, you might
also be instantly in hell.
Its really hard actually to answer your question. NFS implementations vary
greatly in their quality. In addition it depends on the NICs
1 - 100 of 122 matches
Mail list logo
