Hi,
Jeremy Zawodny wrote:
>
> On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote:
> > Benjamin,
> > can you also grow MyISAM tables to such sizes?
>
> You can.
that implies that MySQL itself (and all its tools) is able to handle
files bigger than 2 GB?
Is that the case with MyS
Yes, all programs which don't have built in limits can go smoewhere in the
range of I think 8 TB but I have only tested it to 50 GB with MySQL. As
for Solaris this is also true.
Benjamin Arai
[EMAIL PROTECTED]
On Mon, 14 Jan 2002, Dr. Frank Ullrich wrote:
> Hi,
>
> Jeremy Zawodny wrote:
> >
>
On Mon, Jan 14, 2002 at 09:55:16AM +0100, Dr. Frank Ullrich wrote:
> Hi,
>
> Jeremy Zawodny wrote:
> >
> > On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote:
> > > Benjamin,
> > > can you also grow MyISAM tables to such sizes?
> >
> > You can.
>
> that implies that MySQL itself
> On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote:
> > Benjamin,
> > can you also grow MyISAM tables to such sizes?
>
> You can.
I understand that the RAID option can help break the 2GB/4GB barrier, esp.
on Linux machines.
But how do you surpass the Max_data_length restriction
Hello there!
I've site with 1000 hits per day. Scripts are written
in Perl and use MySQL database. MySQL server works
good, but sometimes suddenly crashes. Error log says:
Number of processes running now: 0
020113 02:50:41 mysqld restarted
020113 2:50:42 Can't start server: Bind on TCP/IP
port
You don't understand. You need to use a operating system which has a
filesystem which lifts the 2 GB limit. By default from every Linux
distrobtion I have used, if the OS has lifted the limit then they usually
fix all the programs to uses the new file size capabilities.
Raid doesn't help at all
hey all,
using mysql ver 3.23.36
got stuck with something, here's a simplified example of it:
+---+---+
| a | b |
+---+---+
| 1 | 1 |
| 1 | 2 |
| 2 | 2 |
| 3 | 1 |
+---+---+
I would like to retrieve the set of all a where b !=2
so in the above example, only 3 would be returned...
but a simple
Hi,
Sorry for being unclear :) I was talking about the --with-raid compilation
option in MySQL that lets you create tables with the RAID_TYPE RAID_CHUNKS
RAID_CHUNKSIZE options, allowing tables to span across multiple data files,
each file having a size below the OS limit. Thanks for the
Oh, I don't know how well that would work. But I do know you will still
run into limitations of 2 GB, so if you had 2 drives raided then you now
have a 4 GB limit which doesn't help to much. I would think the best
solution would be to re-compile your kernel to include large file support
and tweak
It seems like you have hit a file size limit.
Soalris has a 2 Gig ( or is it 4Gig) file size limit which is
restricting your database.
You could get past this by breaking up your data into different
segments, eg. group the data by month and store it in monthly tables,
reducing the size of the dat
* Michael Ayres
> +---+---+
> | a | b |
> +---+---+
> | 1 | 1 |
> | 1 | 2 |
> | 2 | 2 |
> | 3 | 1 |
> +---+---+
>
> I would like to retrieve the set of all a where b !=2
> so in the above example, only 3 would be returned...
Use a LEFT JOIN:
SELECT t1.*
FROM t1
LEFT JOIN t1 AS t2 ON
When is MySQL 3.23.48 and myODBC 2.50.39 going to be released?
Will there be any beta or pre-releases of these?
I've been looking here for an [ANN:] email :) But I didn't find any...
The website doesn't either tell much more.
Does anyone have an ETA?
Regards,
___
The short:
Is it possible to do replication from server a and server b to server
c.
ie. have two data collection points (a and b) both replicating data to
server c where queries and reports are created.
The Long:
we have 2 mailservers and a database server, all running mysql 4.01.
The mail serve
Jeremy,
I have version 3.23.41 installed on Win2K. The installation program may have been
corrected since (I hope so!), but when I installed it it did the following:
- It created my_cnf in C:\ even though I told the installation program I wanted to
install on F: and the system drive is R: (*no
> > I'm writing an adminstrative program for a hotel located in
> > Sweden. This program uses an mysql database as backend(the
> > implementation is not in use yet, but my intention is to use mysql).
> >
> > To be really sure about this: Do the hotel _have_ to get an MySql
> > database License or
>Description:
Run SELECT WEEK(SUBDATE("2002-01-07 03:30:00", INTERVAL 7 DAY), 1) and it
wrongly returns 53.
>How-To-Repeat:
SELECT WEEK(SUBDATE("2002-01-07 03:30:00", INTERVAL 7 DAY), 1);
>Fix:
Correct result returned by querying the thursday of that week instead, ie.
Hi all,
Do anyone know how can I rotate the error log of mysql?? I just know
that flush logs can do but I am also doing replication in that mysql
server. I hope to rotate the error log but not affect the binlog If
anyone know about that. Please give me some advice.
Many thanks.
Kaming.
I have attempted to find the following error:
Warning: MySQL: Unable to save result set in
/home/autoindx/theautoindex-www/currentx.php on line 261
in the archives without success although I am absolutely sure it it is
there somewhere.
Could you please direct me to the source for the solution t
Richard Ward wrote:
> The short:
>
> Is it possible to do replication from server a and server b to server
> c.
> ie. have two data collection points (a and b) both replicating data to
> server c where queries and reports are created.
>
> The Long:
> we have 2 mailservers and a database server,
Markus Fischer writes:
> [Please CC me, I'm not subscribed]
>
> Does someone know if there's a native C# implementation
> available OR a wrapper around libmysqlclient for C#?
>
> thx,
> Markus
As far as I know, no not yet.
But we are preparing our strategy on how to tac
Frans Englich writes:
> I'm writing an adminstrative program for a hotel located in Sweden. This program
>uses an mysql database as backend(the implementation is not in use yet, but my
>intention is to use mysql).
>
> To be really sure about this:
> Do the hotel _have_ to get an MySql databas
On Mon, Jan 14, 2002 at 03:03:11PM +0200, Sinisa Milivojevic wrote :
> Markus Fischer writes:
> > Does someone know if there's a native C# implementation
> > available OR a wrapper around libmysqlclient for C#?
>
> As far as I know, no not yet.
Ok, thx.
> But we are preparing our st
Monday, January 14, 2002, 3:11:00 PM, you wrote:
> Frans Englich writes:
>> I'm writing an adminstrative program for a hotel located in Sweden. This program
>uses an mysql database as backend(the implementation is not in use yet, but my
>intention is to use mysql).
>>
>> To be really sure ab
Hallo,
i am looking for a reliability mechanism for mysql server.
The problem is to find a way to assure that if the
Data base machine go down, i assure however
the services to the clients.
Until now i found the COMPAQ solution LifeeKeeper
for Linux Proliant clusters.
does anybody knows if ther
i was under the impression that unless the application will 'only' run under
mysql
(ie uses a mysql specific feature), its perfectly legitimate to use it
without a licence.
For Example, if your application uses odbc to communicate with the
database, and
standard sql to perform database queries, t
Jeremy Zawodny writes:
> According to what I read in the manual, I'm lead to believe that MySQL
> on Windows can read from either C:\my.cnf or systemdir\my.ini. Which
> will it read first?
>
> The manual also seems to say that you can only use one. So if you
> create both, which will it prefer?
I agree with Sean.
-Message d'origine-
De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Envoyé : Monday 14 January 2002 2:25 PM
À : [EMAIL PROTECTED]
Objet : RE: Licensing
i was under the impression that unless the application will 'only' run under
mysql
(ie uses a mysql specific featu
Markus Fischer writes:
>
> Hmm .. could you be a bit more elaborative (sp?) please what
> you mean with this? thank you
>
> - Markus
That meant that we are in the planning process ...
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevi
Pål Sollie writes:
>
> Monday, January 14, 2002, 3:11:00 PM, you wrote:
> > require a licence. Otherwise, you do ...
>
> Even if he uses an unmodified version of MySQL?
>
> --
> Pål Sollie - [EMAIL PROTECTED]
>
Yes.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr
database,sql,query,tabl
Hi all
I have a two way replication environment working 100% at the moment. I want
to now introduct a third server into the equation, and I want to know .
Currently -
Server "A" replicates from Server "B"
Server "B" replicates from Server "A"
Is it
Benjamin Arai <[EMAIL PROTECTED]> writes:
> Oh, I don't know how well that would work. But I do know you will still
> run into limitations of 2 GB, so if you had 2 drives raided then you now
> have a 4 GB limit which doesn't help to much. I would think the best
> solution would be to re-compile
I just set up MySql on my Win2000 server and everything seems to be okay. I
can connect to the server with no problems using the command line and
various utilities like DBTools. However, when I try to connect to the
server from a different computer, I get the error "Access denied for user:
[EMAI
Because TEXT does not take a size.
Matthew Darcy wrote:
>I figured out the problem in the book, I have no idea why my mail has not
>come through.
>
>I am stuck on why this is not working though
>
>ALTER TABLE account_details ADD account_name TEXT(30) NOT NULL
>
>-Original Message-
>From
Hello,
Your query could use text or varchar(30) or char(30) but not text(30).
John L
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 3:08 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: alter table example.
Because TEXT does
On Mon, Jan 14, 2002 at 11:56:39AM +0200, Richard Ward wrote:
> The short:
>
> Is it possible to do replication from server a and server b to
> server c. ie. have two data collection points (a and b) both
> replicating data to server c where queries and reports are created.
A slave can only hav
Hi,
is it right, that the max. size of a table is 4 GB on WindowsOS ?
I am using MySql from a Java - Program for a Log-Database and I get
the Message: The table 'LOG4_FFE' is full.
Is there another way to get around the Problem as using then to use
the MERGE - utility?
I am using My Sql 4.0.0
Hi list members,
How to get the unique row id for a row in a table ?
Thanks.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED]
Techn
Hi,
Red Hat 7.2, MySQL 3.23.47-1
I'd like to set up the character set on one of our table.
I've found an example of the SET command in the
mysql documentation, but I'm afraid I can't use it;
SET [OPTION] SQL_VALUE_OPTION= value, ...
set character set=hungarian on table;
ERROR 1115: Unknown cha
If the value was set with AUTO_INCREMENT, then immediately after inserting
the row, do:
SELECT last_insert_id() AS myvalue;
-Original Message-
From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 10:03 AM
To: [EMAIL PROTECTED]
Subject: ROW ID
Hi list me
Read this,
1.4.3.1 Using the MySQL Server Under a Commercial License
"You need a commercial license:
When you distribute a non-GPL application that ONLY works with the MySQL
server and ship it with the MySQL server. This type of solution is actually
considered to be linkin
For production product planning purposes, can someone tell me when MySQL
4.0
will be labelled beta?
Thanks.
--
Becky McElroy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
All,
I'm new to this list and this is my first post. I hope all of you are well.
I just upgraded my laptop to Red Hat Linux 7.2. When I do an rpm -q mysql it
tells me I have mysql v mysql-3.23.41-1 installed. The server is not running
however and I have never used mysql on this system befor
hi!
i have to transfer weekly about 600k records from dbf file to remote
mysql server.
anyone have an idea where to find some libraries to access dbase in
delphi/kylix ?
the standard bde engine is very slow on lorge dbf tables
thanks
blestan
--
What I mean is to get the internal id of every existing row in a table.
Thanks.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED]
Tec
Tim Bogart <[EMAIL PROTECTED]> writes:
> All,
>
> I'm new to this list and this is my first post. I hope all of you are well.
>
> I just upgraded my laptop to Red Hat Linux 7.2. When I do an rpm -q mysql it
> tells me I have mysql v mysql-3.23.41-1 installed. The server is not running
> ho
At 11:10 + 1/14/02, trevor hemsley wrote:
> >Description:
> Run SELECT WEEK(SUBDATE("2002-01-07 03:30:00", INTERVAL 7
>DAY), 1) and it wrongly returns 53.
Why is that incorrect? The date you have specified occurs on Dec. 31 of the
previous year?
> >How-To-Repeat:
> SELECT WEE
>Description:
CREATE TABLE creates ZEROFILL fields
even if they are not specified as such.
>How-To-Repeat:
CREATE TABLE article (
id int(11) NOT NULL auto_increment,
up int(11) NOT NULL default '0',
topic int(11) NOT NULL default '0',
title varchar(255) NOT NULL default '
I had a similar problem (huge-ish legacy DBF tables that need to be
transferred daily). I use a program called cdbflite to create text files
from the DBF tables (you can pass a SQL string to the program if you only
want a subset of the data), and then bulk load into MySQL. Even with the
extra st
You need to specify an 'id' column when creating the table; there is no
'hidden' one.
---
Peter Dunham
www.affiliatewindow.com
the future of web marketing
---
-Original Message-
From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
Sent:
On Saturday 12 January 2002 20:53, Jeremy Zawodny wrote:
> On Fri, Jan 11, 2002 at 08:08:51AM -0800, Kyle Hayes wrote:
> > We write our own replication system using our own checkpointing and
> > code. We start with the update logs (we're not happy about the
> > future removal of the update logs b
At 16:58 14/01/2002 +0100, Peter Arnold wrote:
Hi!
>Hi,
>
>is it right, that the max. size of a table is 4 GB on WindowsOS ?
>I am using MySql from a Java - Program for a Log-Database and I get
>the Message: The table 'LOG4_FFE' is full.
For this issue there are two options:
1- Use an OS of the
Thanks Peter,
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
Email addresses:
Operations: [EMAIL PROTECTED]
Consulting: [EMAIL PROTECTED]
Technical: [EMAIL PROTECTED]
Web related: [EMAIL PROTECTED]
General:
I have added some extra fields to the mysql.user table, namely:
full_name VARCHAR(255)
job VARCHAR(255)
location VARCHAR(255)
phone VARCHAR(255)
reminder VARCHAR(255) NOT NULL
ip_addr VARCHAR(255) NOT NULL
I want to store these values for each person that creates a new account on my database.
Th
Hamlin Nicholas-qa568 writes:
> I have added some extra fields to the mysql.user table, namely:
> full_name VARCHAR(255)
> job VARCHAR(255)
> location VARCHAR(255)
> phone VARCHAR(255)
> reminder VARCHAR(255) NOT NULL
> ip_addr VARCHAR(255) NOT NULL
>
> I want to store these values for each perso
Hi,
I have a question about setting up the innodb part of mysql server.
I run mysql version 8.21, distribution 3.23.40 for pc-linux-gnu on i686
(installed the binary distribution).
I tried to turn on innodb, so I stopped the server, copied my-medium.cnf
under /etc/my.cnf, uncomment the lines c
Sinisa Milivojevic writes:
>
>ALTERing will completely break security and permission systems and
>will even prevent MySQL from proper functioning.
>
Can you give me an example? I'm having no problems with security even after adding
these columns. Users only have access to the dbs and tables th
On Monday, January 14, 2002, at 01:17 PM, Gurhan Ozen wrote:
> Hi All,
> I am currently looking for a reliable web host to host my personal
> website.
> I know there are millions of web hosting companies that have PHP and
> MYSQL
> support but I just can't trust any of the fully-assured and
Hi,
i'm looking for people that can write mysql articles for free.
in exchange every article that they write will have information and link url
to their site.
All articles will be placed on http://www.cgi-network.net
__
Valery Vlasyuk
http://www.cgi-network.net
- Ori
Hi All,
I am currently looking for a reliable web host to host my personal website.
I know there are millions of web hosting companies that have PHP and MYSQL
support but I just can't trust any of the fully-assured and confident
webhosting ads anymore. I would like to get a service from a compa
Try www.aletiahosting.com $9.95 a month
-- Original Message --
From: Gurhan Ozen <[EMAIL PROTECTED]>
Date: Mon, 14 Jan 2002 13:17:59 -0500
Hi All,
I am currently looking for a reliable web host to host my personal website.
I know there are millions of
I use http://www.nomonthly fees.com
Initial buy-in is $200. However, that includes domain name registration,
500 megs of disks pace, 5 giga-bytes of band-width per month.
Complete PHP and MYSQL support. Bunch of other stuff too, like 1000 POP3
email boxes, PGP, shopping carts, etc.
After first
I use FGDesigner.com. They have proven to be quite reliable and have a wide
range of plans available based on what you would need. You can check out
the website. My husband and I have been hosting our site through them for a
couple of years and never had any problems. I also know that they hav
Ive got numerous accounts with www.palmversa.com and I
have to say they are very reliable and extremely
cheap.
Hope this helps
Shannon
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > For additional commands, e-mail:
> [EMAIL
Starting @ $20.00/month http://www.ocsny.com
>
>-- Original Message --
>From: Gurhan Ozen <[EMAIL PROTECTED]>
>Date: Mon, 14 Jan 2002 13:17:59 -0500
>
> Hi All,
> I am currently looking for a reliable web host to host my personal website.
>I know there
In my previous email, I mentioned that http://www.nomonthlyfees.com provided
500 megs of disk space per account. I host several a domains by redirecting
domains (5) to sub-directories within that 500. I don't have a 500-meg
account for each domain. After the first year, the 500-megs cost $70/ye
Go to www.webhostingtalk.com
this is forum about hosting services.
_
Valery Vlasyuk
http://www.cgi-network.net
- Original Message -
From: "Shannon Kendrick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 14, 2002 8
Check out Just Lightning: http://www.justlightening.net
>On Mon, 14 Jan 2002 13:55:00 -0500, NDPTAL85 <[EMAIL PROTECTED]> wrote:
>>On Monday, January 14, 2002, at 01:17 PM, Gurhan Ozen wrote:
>>
>>> Hi All,
>>> I am currently looking for a reliable web host to host my personal
>>> websit
Hi,
i'm looking for people that can write mysql articles for free.
in exchange every article that they write will have information and link url
to their site.
All articles will be placed on http://www.cgi-network.net
__
Valery Vlasyuk
http://www.cgi-network.net
--
I've recently converted from using MyISAM to InnoDB tables, and am
pleased with InnoDB so far. However, the inability to use 'ALTER TABLE'
with InnoDB tables is very problematic, as our software is still under
heavy development and our database schema changes frequently. I'm
working on a way to au
On Mon, 14 Jan 2002, Benjamin Arai wrote:
> Raids don't really help Table performance because in almost all cases the
> bottlneck is caused by the drives access time. raiding drives doesn't
> increase the access time therefore, you are most likely not going to see
> and poerformance increases usi
I am also in the process of altering tables from MyISAM to INNODB. I
have one big problem - a very large table (> 5 million rows) with 5
indices/indexes on it, including a couple that are UNIQUE but with NULL
values allowed. Creating the last of these indices is taking an absurd
amount of time
Solaris 8
Gcc 3.0.3
I cannot get mysql to compile without math_iso.h yet I cannot find
math_iso.h anywhere, does anyone know where this file is located, also, does
anyone know which Solaris Package contains libm.a it's missing also.
-Mark
---
in specific reference to linux, you are speaking of the 2.4 kernel, glibc
2.2, and ext{2,3} filesystem? is it the case that large files are correctly
addressed (ie, seamlessly) on such systems? this is the impression i have
got from the limited research i've done.
looking for a generalized soluti
hi mark,
math_iso.h is c header file located in /usr/include/iso, part of
SUMWlibm package.
this is output of pkgchk from solaris 8 machine (german locale):
# pkgchk -l -p /usr/include/iso/math_iso.h
Pfadname: /usr/include/iso/math_iso.h
Typ: reguläre Datei
Erwarteter Modus: 0644
Erwarteter Eig
Thus spake John Kemp on Mon, Jan 14, 2002 at 02:37:07PM -0500:
> 2) Then I tried mysqldumping the table structure, and changing MyISAM ->
> INNODB, dropped the table, and ran the mysqldump output back into the
> database. The INSERTS ran horribly slowly - something like 50,000
> inserts in 4 ho
* Hamlin Nicholas-qa568
> I have added some extra fields to the mysql.user table, namely:
> full_name VARCHAR(255)
> job VARCHAR(255)
> location VARCHAR(255)
> phone VARCHAR(255)
> reminder VARCHAR(255) NOT NULL
> ip_addr VARCHAR(255) NOT NULL
>
> I want to store these values for each person that
I have problems with searches where I try search in 2 or more tables with a
query only. But the data came more that one time. I dont speak english very
well... if somebody understand portuguese, please reply for me...
sql => SELECT * FROM tutoriais,scripts WHERE tutoriais.nome LIKE '%mysql%'
OR tu
OK, I sent in something I hope will be useful.
# PROBLEM SUMMARY ###
Two problems seen with multi-table delete:
1) After a multi-table delete, first query of the second table
referenced in
the delete results in ERROR 1032. Subsequent queries are fine. Happens
with
BDB and InnoDB.
Perhaps, add the DISTINCT modifier:
SELECT distinct * FROM tutoriais,scripts WHERE tutoriais.nome LIKE '%mysql%'
OR tutoriais.descricao LIKE '%mysql%' AND scripts.nome LIKE '%mysql'
-Original Message-
From: Davis Zanetti Cabral [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 31, 2001
Hello,
We had a development box running Red Hat 6.1 on it. Over the Christmas weekend
someone hacked into this system, installed bitchx on it, and filled up the disk
among other things. One of the consequences of the attack was that MySQL
stopped functioning. MySQL appears to start correctl
Hi all:
Consider a hierarchy of users. All users have certain
properties (they all have a name and date-of-birth).
Additionally, based on their type, users have more
properties. So a graduate user may have information
regarding the year and school of graduation, a
professor user may have informa
Hi,
> -Original Message-
> From: Bob Dixon [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 14, 2002 12:08 PM
> To: '[EMAIL PROTECTED]'
> Subject: RogueWave Dbtools++ 4.0.1 and myodbc (conclusions)
>
>
> Sorry: sent previous message prematurely:
>
> to recap:
> I am evaluating MySQL
This doesn't make sense to me. And reading the manual doesn't really
clear up why it doesn't work:
---snip---
mysql> show grants for yahoo;
+--
My question is two-fold, first regarding error handing of table size
limitations, and secondly performance and other implications of raid
striping.
I'm building a system with an integrated MySQL database and there is a
potential for filling up tables to the maximum file size for the OS I'm
using
At 13:05 -0800 1/14/02, Jeremy Zawodny wrote:
>This doesn't make sense to me. And reading the manual doesn't really
>clear up why it doesn't work:
>
>---snip---
>
>mysql> show grants for yahoo;
>+-
Hello,
I have a query running on *one* table (not a join), in the explain syntax,
I find out that it will be using "range" for the type, which I
understand isn't as good as "ref". How big of a problem is it for a
non-join query.
Here's a sample query:
select title, author, book_id from books w
On Mon, Jan 14, 2002 at 03:35:00PM -0600, Paul DuBois wrote:
> >
> >Hopefully I'm just missing something really obvious...
>
> I suspect it's just a hard thing to implement:
>
> If someone creates a new database after you revoke the UPDATE privilege,
> should the user be able to update that data
You don't really have to do the two searches and if-then-else. You can use
joins to first get all grads, then a join to get all profs.
SELECT user.*,graduser.* FROM graduser LEFT JOIN user USING(userid);
SELECT user.*,profuser.* FROM profuser LEFT JOIN user USING(userid);
These assume USERIDs a
You don't really have to do the two searches and if-then-else. You can use
joins to first get all grads, then a join to get all profs.
SELECT user.*,graduser.* FROM graduser LEFT JOIN user USING(userid);
SELECT user.*,profuser.* FROM profuser LEFT JOIN user USING(userid);
These assume USERIDs a
CORRECTION:
SELECT user.*,graduser.* FROM graduser RIGHT JOIN user USING(userid);
SELECT user.*,profuser.* FROM profuser RIGHT JOIN user USING(userid);
-Original Message-
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 3:52 PM
To: '[EMAIL PROTECTED]'
Subject:
hi!
everyone who is interested to use a my new delphi
components can find them at
www.sourceforge.net/projects/simple-mysql
or
www.delphipages.com
they are free, easy to use, stable and very fast -
it's a OOP warp around the C API
demo source included, aslo a mini help
regards, blestan tabak
You need something to limit the join. In theory a join with no limit will
generate the cartesian product (all possible permutations of all the rows)
of all joined tables. I've tried to demonstrate this below.
In general the use of DISTINCT is slow and should be avoided if possible.
Hope this hel
I've installed mysql-gui, but I get the following error message when trying
to connect, after entering my password: Can't connect to local MySQL server
through socket '' (2)
>From the command line #mysql -p connects after entering the password.
Have I something else to configure?
Thanks.
Mervyn
Hello, I am new to this list and MySQL. I am very excited about this
open source community. I can definitely see MySQL becoming to database
servers, what Apache has become to web servers.
I am currently developing a mission critical manufacturing web
application in Java and I am leaning towards
As I recall when I set this up on my machine, you have to identify your
machine in the host table (identify it as a permitted host), the db
table (let mysql know to what db's, as what user, with what permissions
you're allowed to connect), and I believe the user table to the mysql
db. With these
We do this as well.
http://www.nk.ca .
My question: Is anyone tracking MYSQL-php supported Hosting sites?
On Mon, Jan 14, 2002 at 12:57:58PM -0600, Mike(mickalo)Blezien wrote:
>
> Check out Just Lightning: http://www.justlightening.net
>
> >On Mon, 14 Jan 2002 13:55:00 -0500, NDPTAL85 <[EMA
mysql> lock table White write;
ERROR 1036: Table 'White' is read only
How do we make it read-write?
--
Steve Rapaport
still at large
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://
On Sat, Jan 12, 2002 at 09:10:01PM -0800, Jeremy Zawodny wrote:
> On Sat, Jan 12, 2002 at 11:42:57PM +0100, Carsten Gehling wrote:
>
> > Then maybe you can tell me how I should tune the server? You know
> > make it use more memory, and thereby performing better? It's
> > probably a FAQ, if so jus
James Montebello wrote:
> File permissions?
Nope, tried that.
>
>>mysql> lock table White write;
>>ERROR 1036: Table 'White' is read only
>>
>>
>>How do we make it read-write?
--
Steve Rapaport
still at large
-
Befor
I can run MYsql
I can run PHP
but i get a server overloaded when I try to acces mysql with PHP
using win 98 se with xitami/apache
tried php406 and 404 and tried different Mysql
-
Before posting, please check:
http://www.my
1 - 100 of 110 matches
Mail list logo
