>From a SSH I run a query and get the following:
ERROR 1030: Got error 134 from table handler
>From a browser, when I run the same query I get:
Warning: MySQL: Unable to save result set in [my php file here] on line 7
Warning: Supplied argument is not a valid MySQL result resource in [my php
f
hello
we are running web application using apache as web server and mysql as
databse. after running server for 6- 8 hr it will give the following
error
java.sql.SQLException: Lost connection to server during query the error is
here
if we restart apache server it will works
i want to know wh
Hai,
I am using longblob for my datatype. Maybe just forget about the big
file size. But how about the small file size? As the smallest file i can
save is 17KB. Through the MYSQL-front, i able to view my picture and confirm
that the picture already been save. Just yet don't know y even the sm
- Original Message -
From: "Jenny" <[EMAIL PROTECTED]>
Sent: Tuesday, January 15, 2002 5:14 AM
> Finally i able to retrive image from MYSQL database via VB6.0.
However, i can only retrieve image where the size is greate than 17kb and
less then 32KB.
>
> I have try to increate my
Hai, All,
Finally i able to retrive image from MYSQL database via VB6.0. However, i can only
retrieve image where the size is greate than 17kb and less then 32KB.
I have try to increate my max_packet_size to 128KB, but i still retrive null
value. Another thing i feel queries is, you th
You have to set-up the "user" table in "mysql" db to allow connection from
localhost. Example dump:
mysql> select * from user;
++-+--+-+-+-
+-+-+---+-+-
--+
PLEASE help me somebody! I've been trying to set up MySQL for quite some
time now but for some reason I keep getting the following error:
ERROR 1130: Host 'localhost' is not allowed to connect to this MySQL server
Is this an error due to a misconfiguration of MySQL? If so, could someone
please h
This works with ONE MORE STEP:
shut down and restart the mysqld server.
Otherwise nothing happens!
Thanks all.
steve
Michael Migal wrote:
> Make sure that the files for that table not only have correct permissions,
> but also have correct owner and group. (mysql:mysql)
> I had the same write
On the front screen of the mysql site the mysql-Max 3.23.47 is listed as
stable.
However on the download page it is said to be considered a beta yet?
The reason that I am asking this question, is that the Borland Delphi
Developers will not release a new version that supports the record locki
Make sure that the files for that table not only have correct permissions,
but also have correct owner and group. (mysql:mysql)
I had the same write only problem and fixed it by doing it.
mike
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 20
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
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
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
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://
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
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
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
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
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
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
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:
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
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
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
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;
>+-
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
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;
+--
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
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
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
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
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.
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
* 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
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
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
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
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
---
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
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'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
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
--
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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:
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
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
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:
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
>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 '
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
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
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
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
--
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
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
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
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
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
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,
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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,
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
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.
>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.
> > 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
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
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
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,
___
* 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
1 - 100 of 110 matches
Mail list logo
