Hi
I'm designing 2 tables, where tabProds has the foreign key of tabUsers.
So when I want to join them I use..
WHERE tabProds.usr_ID = tabUsers.usr_ID
Ok
But the thing is that sometimes will not be possible to specify a user when
you insert a Product(becaouse we don't know at that time)...
And
Ben,
This really belongs on the main list, so I'm CCing that instead of
internals. How carefully have you read section 4.6 of the manual?
http://www.mysql.com/doc/L/o/Localisation.html
You shouldn't have to make a big5.conf. Big5 is supported in the
standard distribution for quite some time, an
Can anyone tell me how to get an RPM that provides the
libmysqlclient.so.10? I am trying to install the
php-mysql-4.1.2-7.i386.rpm and it says that this is a requirement. It
comes in an older version of the mysql database rpm but I have 3.23.51
installed and apparently that one does not come
I have a system that has been in production for more than a year and
fairly reliable.
I have a Penguin Systems Relion 120 running Redhat Linux 2.2.14 and
MySQL 3.23.48
A few weeks ago it started crashing occasionally. About a week ago it
started crashing a lot. Some times it gets a core dump
Im getting in trouble trying to restore a .sql dump generated with
mysqldump for a database with lots of foreign keys because of the
order of tables in the .sql. the first table already declares a
FOREIGN KEY referencing a table not yet created, halting with a
'cant create blahblahblah'.
(ERROR 1
Hi Benjamin, Vivian,
On Wed, 2002-07-24 at 05:23, Benjamin Pflugmann wrote:
> On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
> > I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
> > All char fields are mixed with upper case letters, numbers(0-9) and
> >
Try round(value*4,0)/4
Worked on the samples I tried
> -Original Message-
> From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 23, 2002 1:47 PM
> To: [EMAIL PROTECTED]
> Subject: rounding?!
>
> Ok here's the problem. Trying to write a select statement to be able
to
>
I absolutely agree with Benjamin.
It would be bad mojo for the engine OR the client to silently ignore any
error. While it may be trivial for the developers to code around your type,
they can't code around all of ours. I constantly type form for from but I do
not expect the client or the engine t
Check the manual at www.mysql.com. Use your first query to create a
temporary table. Then use your temporary table as a source for additional
queries. The tem table will be destroyed when your session is terminated.
(Handy if you are piping in several SQL statements from the command line.
For f
I need help with MySQL.
I just moved my servers and have new DNS names and IP addresses. I need to
update the databases to reflect the changes. I used PhpAdmin to make some
of the changes, but I am still getting "Internal Server Error"'s. Any help
in directing me for help would be appreciated.
Dear list,
Ive been trying to install mysql 4.0.2. alpha.
The configuration is going well.
That also counts for the make command.
But when I run the make test command Im getting the following error:
ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not created
in 30 s
Oops, sorry, few mistakes here
Mike Blazer wrote:
>
> Hello guys,
> I'm runing mysql 4.0.0 under apache and mod_perl on solaris 2.28 - we
> are in a kinda testing/adjusting period. So, yesterday I've wrote an
> utility on top of
> `ps -o vsz,rss -e` to monitor the memory usage by my processes an
Hi.
First, for some reason, I got your email three times (both, personally
and to the list - once to both would be okay).
On Tue 2002-07-23 at 12:30:38 -0700, [EMAIL PROTECTED] wrote:
> Understand.
> But, how to "use IP addresses instead of hostnames"?
The only context where you use hostnames i
Hello guys,
I'm runing mysql 4.0.0 under apache and mod_perl on solaris 2.28 - we
are in a kinda testing/adjusting period. So, yesterday I've wrote an
utility on top of
`ps -o vsz,rss -e` to monitor the memory usage by my processes and also
added mysqld to the list.
So, here's what I saw
virtual m
> mysql> show databases;
> +-+
> | Database|
> +-+
> | CarbonUFSVolumeInfo |
> | mnta|
> | mntb|
> | vi.recover |
> +-+
> 4 rows in set (0.04 sec)
Umm, those look very much like files
In the last episode (Jul 23), Greg Westin said:
> My MySQL databases appear to have been overwritten somehow, and I am
> very distressed about this. Please tell me that there is a way to
> recover this data.
>
> I am using Mac OS X, and recently upgraded to PHP 4.2. I have been
> accessing MySQ
Dear list,
I've been trying to install mysql 4.0.2. alpha.
The configuration is going well.
That also count's for the "make" command.
But when I run the "make test" command I'm getting the following error:
ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not
created in 30 second
In the last episode (Jul 23), Greg D. said:
>I was wondering if there was anyway for me to speed up my
> update query. I wanted to index the field that i was searching for.,
> but i heard that indexing slows down updates or that some information
> might not work...is that true? thanks for
Hey, thanks *so* much for checking into this.
Your message did help. In case you're curious. First, I had the admin
create a 777 dump directory from root. Still couldn't write out. Then,
though, I just tried going to /tmp as you had done, and that was fine.
/tmp -- I feel like an idiot, but a
Hi,
In MSAccess, I am able to use a query as a (partial) source for another query.
«Select Names, Department from qrySelectedEmployees, tblDepartment
where qrySelectedEmployees.EmplId = tblDepartment.EmplId»
Is this possible with MySQL? If so, how is it implemented?
Thanks for your help.
Alai
Understand.
But, how to "use IP addresses instead of hostnames"?
--- Benjamin Pflugmann <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> On Tue 2002-07-23 at 08:21:43 -0700,
> [EMAIL PROTECTED] wrote:
> > SCO UNIX 5.0.6, run ./script/mysql_install_db
> > Get the warning message as follow.
> > Please advise
Understand.
But, how to "use IP addresses instead of hostnames"?
--- Benjamin Pflugmann <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> On Tue 2002-07-23 at 08:21:43 -0700,
> [EMAIL PROTECTED] wrote:
> > SCO UNIX 5.0.6, run ./script/mysql_install_db
> > Get the warning message as follow.
> > Please advise
Understand.
But, how to "use IP addresses instead of hostnames"?
--- Benjamin Pflugmann <[EMAIL PROTECTED]>
wrote:
> Hi.
>
> On Tue 2002-07-23 at 08:21:43 -0700,
> [EMAIL PROTECTED] wrote:
> > SCO UNIX 5.0.6, run ./script/mysql_install_db
> > Get the warning message as follow.
> > Please advise
Hi.
On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
> I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
> All char fields are mixed with upper case letters, numbers(0-9) and
> sign(like $).
> Because there is no low case char, I don't have to put -f optio
On Tue, 23 Jul 2002 [EMAIL PROTECTED] wrote:
> sql,query
>
> You have written the following:
>
> You need to make sure you have all the Caldera/SCO OS patches installed.
>
> http://www.caldera.com and look in the OS support.
>
> Good Luck,
>
> --
> Boyd Gerber <[EMAIL PROTECTED]>
> ZENEZ 1042 Fort
Hi.
On Fri 2002-07-19 at 11:13:26 -0500, [EMAIL PROTECTED] wrote:
> Why is it that when I submit a reply or message to the mysql mailing list
> that my e-mail sometimes does not show up for hours.
> Seems to me that this makes rapid response and give-&-take nearly
> impossible. I have asked our n
Alain Williams wrote:
>On Tue, Jul 23, 2002 at 11:59:43AM -0400, denonymous wrote:
>
>>From: "Gerald Clark" <[EMAIL PROTECTED]>
>>
>>>Why do think this should not be an error?
>>>If you were writing a script, would you not want to know you had made
>>>the error?
>>>Just how many , or how severe
Hi.
On Tue 2002-07-23 at 17:09:05 +0100, [EMAIL PROTECTED] wrote:
> On Tue, Jul 23, 2002 at 11:59:43AM -0400, denonymous wrote:
[...]
> > The ability to run more than one query on one line is a feature, not a bug.
> > An empty semicolon is a badly-formed query. It's perfectly logical for the
> >
I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
All char fields are mixed with upper case letters, numbers(0-9) and
sign(like $).
Because there is no low case char, I don't have to put -f option for unix sort.
Thanks.
At 08:23 PM 7/23/2002 +0200, Benjamin Pflugmann
Hi.
On Tue 2002-07-09 at 10:49:51 +0200, [EMAIL PROTECTED] wrote:
> Hi all again,
>
> I've been experimenting and would like to know if there is a known bug in
> the std function when used with a group by clause?
> I'd like to know if others have found this problem or is it just me:
>
> I have
Hi.
On Mon 2002-07-08 at 22:54:09 -0700, [EMAIL PROTECTED] wrote:
> I'm trying to get the name of a booth or tradeshow depending on the
> customer_link_type (which is an ENUM) combined with the
> customer_link_table_id which tells me the index/id of the correct table
> to look in. I've tried this
Ok here's the problem. Trying to write a select statement to be able to
round a set of numbers to the nearest quarter of an inch. Here is what I
have so far:
*-*
SELECT
CONCAT(ROUND(inside_length + (wall_thickness * 2), 0),'\'
Hi.
On Mon 2002-07-08 at 17:49:03 -0700, [EMAIL PROTECTED] wrote:
> Hello,
>
> I have _a lot_ of http log data to throw into a mysql db (currently over 1.5
> billion rows). New data is coming in all the time, so I don't want to lock
> myself into one set of big tables that are over 100 gigs eac
Hi Victoria,
Do you know when the 4.0.2a-MAX would be available for download then?
Thank you.
Regards,
Michael
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 4:26 AM
To: [EMAIL PROTECTED]
Subject: Re: Problem downloading MySQL4.0
I have several mysql servers installed, all without TZ variable, one of
them, insists in set the "select now()" to 4 hours ahead of my internal
clock, first I touch that I should set TZ to my time time zone in
/etc/init.d/mysql, but when I do that, the "select now()" advances 4
more hours.
B
At 15:09 +0200 7/23/02, Ilyas Keser wrote:
>Hi...
>
>What is the best way in MySql to store a session_id in hex format.
>Can Integer also store hex values like:
>E4FA762685A23E002D86483AACE9BD7B
The largest integer type is BIGINT, which is 8 bytes (16 hex digits max).
Your value looks like it's
Hi.
On Tue 2002-07-23 at 16:19:43 +0100, [EMAIL PROTECTED] wrote:
> Hi.
>
> Thought I'd try sending this again as no takers for my earlier post!
>
> Has anyone got any good ideas or examples about doing Version Control on
> a MySQL table? I'd like all changes to fields to be recoverable back t
Can anyone suggest a good data modeling tool that can be used for:
a) Reverse enginering: dump file => data model
b) Create a new data model
c) Generate the ddl from the data model
d) The tool should handle the latest features of MySQL 3.23.52
Any comments about the tool called dezign. Is it any
Hi.
On Thu 2002-07-11 at 09:53:05 -0400, [EMAIL PROTECTED] wrote:
> Bhavin,
>
> I am using distinct all 15 fields and order by all 15 fields, but there is
> different order on 15 fields for distinct and order by.
Are all fields of binary types? If not, DISTINCT equals "sort -uf", not
"sort -u"
Philip Molter <[EMAIL PROTECTED]> writes:
> On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
> : The mysqld.log file says:
> :
> : 020717 13:05:05 mysqld started
> : 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
> : './mysql/host.frm' (errno: 13)
> : 020717 13:05:05
Hi.
Your example looks incomplete. What do you do with the records
afterwards, which also allows "site" to be removed in a way that you
suggest it does not need a code (logic) change?
The general answer is that most interfaces have a way to access the
columns by name. I do not know dbi good enou
At first I want to thank you for a fast answer,
On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
> On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
> > >Description:
> >
> > ERROR 2013: Lost connection to MySQL server during query.
> > Note:
> > The same results with ofic
I am having a or problem
reproducible by script below
(or by sql or by query if
mail filter likes those words
better:) ).
Briefly:
4 tables joined to each other:
/-ar
a
\-b-br
I would expect to get totals based on
the root record in a:
a_idq_a q_arq_b q_br
1 1 4
[snip]
I quite agree that to have more than one command on a line is a nice thing.
What I am saying is that barfing on an empty command is not the right thing
to do.
I remember, many years ago, I wrote some coding standards where I said:
Every program/function should do nothing correctly
Hi!
On Jul 23, Artem V. Ryabov wrote:
> Hello mysql,
>
> see this 2 queries:
> why they not equal?
> why first skip many records?
>
> mysql> select left(ftText,20) from Txt_index where match(ftText)
>against('+(wщd200206*) +wщ12p' in boolean mode);
> 3 rows in set (0.36 sec)
>
> mysql> select
Hi.
On Wed 2002-07-10 at 11:56:14 -0700, [EMAIL PROTECTED] wrote:
> Does anyone know of an Apache Module for auth-ing against a MySQL
> database? MySQL lists one on its website and its no longer
> supported by the developers. I found Apache lists one that is
> also not supported anymore.
>
> m
Hi.
On Tue 2002-07-23 at 08:35:29 -0700, [EMAIL PROTECTED] wrote:
> Hello,
>
>I was wondering if there was anyway for me to speed up my
> update query. I wanted to index the field that i was searching
> for., but i heard that indexing slows down updates or that some
> information might
My MySQL databases appear to have been overwritten somehow, and I am
very distressed about this. Please tell me that there is a way to
recover this data.
I am using Mac OS X, and recently upgraded to PHP 4.2. I have been
accessing MySQL from PHP and phpMyAdmin for a while, occasionally using
Hi.
On Tue 2002-07-23 at 08:21:43 -0700, [EMAIL PROTECTED] wrote:
> SCO UNIX 5.0.6, run ./script/mysql_install_db
> Get the warning message as follow.
> Please advise what I should do. Thanks.
Well, the warning message you cited already explains that. If you have
additional question, please elab
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
> >Description:
>
> ERROR 2013: Lost connection to MySQL server during query.
>
> >How-To-Repeat:
>
> select distinct s.supplier_id, s.who_pay, r.name as rname, s.name,
> s.nick, s.address, s.contact_person,
There didn't seem to be any responses to this question last time I posted.
So I'll try again. Does anyone know where to locate mysqlimport logs, if
there are any?
TIA
James
-Original Message-
From: James Ching [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 4:54 PM
To: [EMAIL
Hello,
I'm working on a purge utility to purge 3 tables: call_record,
modem_call_rec and makrup. Those 3 tables are related with foreign key
recid, so I used the following sql to purge data that is older than 30 days:
delete call_record, modem_call_rec, markup from call_record,
modem_call_rec
Hi.
IMHO, the self-join is the correct solution for the given table layout
(which looks reasonable to me).
Greetings,
Benjamin.
On Wed 2002-07-17 at 09:26:48 +0530, [EMAIL PROTECTED] wrote:
[...]
> > Select companyid, count(*) from CompanyServices where
> > serviceid = 1 or serviceid
Hi,
I looked at the Date example that comes with the mm.mysql driver, but I
still can't get this to work.
When I run the code below, I have no errors, but I only end up with nulls
in my table.
This is getting weird..
Thanks,
Eric
==
import java.sql.*;
import java.u
Hi.
On Wed 2002-07-17 at 14:16:39 +1200, [EMAIL PROTECTED] wrote:
>
> I was wondering what advantages one has over
> the other.
>
> I think the "old way" is easier but is it good enough?
I have no clue what you are talking about and I am sure I am not the
only one. Mind giving an example?
Gre
Hi.
On Fri 2002-07-19 at 11:15:00 -0400, [EMAIL PROTECTED] wrote:
> I have a table of members that includes a status flag and a history
> table of activities that includes a date. What I need is all members
> with a particular status and their activites (which may be none) for
> some date range.
Hi.
On Fri 2002-07-19 at 22:54:10 +0200, [EMAIL PROTECTED] wrote:
> Warning: Host 'netsonic.megalan.co.za' is blocked because of many connection
> errors. Unblock with 'mysqladmin flush-hosts' in
> /usr/local/www/v-webs/m/meg001/www.megalan.co.za/include/globalmegalan.inc
> on line 20
>
> Lo all
this message is about a user defined function i wrote, which
is not working well. i don't know if this is the right list,
if not, i apologize, could someone point me to the correct one?
i have written a user defined function which translates an HTML
entity representation of a letter with a diacri
After a hard day of work I think I managed to isolate the problem which
looks a lot like a bug:
server: mysql-3.23.51
compiled with: CFLAGS="-fomit-frame-pointer -O3 -fPIC" ./configure
--prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql
--with-debug
os: HP-UX 11.00
I have a small j
On Tue, Jul 23, 2002 at 11:59:43AM -0400, denonymous wrote:
> From: "Gerald Clark" <[EMAIL PROTECTED]>
>
> > Why do think this should not be an error?
> > If you were writing a script, would you not want to know you had made
> > the error?
> > Just how many , or how severe should errors be befor
From: "Gerald Clark" <[EMAIL PROTECTED]>
> Why do think this should not be an error?
> If you were writing a script, would you not want to know you had made
> the error?
> Just how many , or how severe should errors be before you are notified?
The ability to run more than one query on one line
>Description:
ERROR 2013: Lost connection to MySQL server during query.
>How-To-Repeat:
select distinct s.supplier_id, s.who_pay, r.name as rname, s.name,
s.nick, s.address, s.contact_person, s.email, s.fax,
s.comment
from su
Hello,
I was wondering if there was anyway for me to speed up my update query.
I wanted to index the field that i was searching for., but i heard that
indexing slows down updates or that some information might not work...is that
true? thanks for any help.
my update statement:
UPDATE
SCO UNIX 5.0.6, run ./script/mysql_install_db
Get the warning message as follow.
Please advise what I should do. Thanks.
WARNING: The host 'ed.airtiger.com' could not be
looked up with resolveip.
This probably means that your libc libraries are not
100 % compatible
with this binary MySQL version.
Hi.
Thought I'd try sending this again as no takers for my earlier post!
Has anyone got any good ideas or examples about doing Version Control on
a MySQL table? I'd like all changes to fields to be recoverable back to
any date-time in the past, without changing the current state of the
databa
hola!!
I need re-compiling mysql 3.23.37 in linux, how can I do this.
In the maestrosdelweb link said how is the compilation, the problem is that
these commands (./config and make) are not available from my install
folders. I have not a directory where I can found.
I have in:
/var/lib/mysql/ -
In the last episode (Jul 23), Jan Peuker said:
> Dan Nelson wrote:
> > So what you really want is
> >
> > CREATE TEMPORARY TABLE tmp
> > SELECT code FROM mytable WHERE zip < 12345 ORDER BY zip DESC LIMIT 5;
> > INSERT INTO tmp
> > SELECT code FROM mytable WHERE zip = 12345;
> > INSERT INTO tmp
>
Hello mysql,
see this 2 queries:
why they not equal?
why first skip many records?
mysql> select left(ftText,20) from Txt_index where match(ftText)
against('+(wÝd200206*) +wÝ12p' in boolean mode);
+--+
| left(ftText,20) |
+--+
| wÝd20020601 wÝ12p
Pada 23 Jul 2002 15:40:17 +0200
Andrea Carpani <[EMAIL PROTECTED]> menulis :
> error: 'Can't create a new thread (errno 11). If you are not out of
> available memory, you can consult the manual for a possible OS-dependent
> bug'
well, if this the case
try to run : mysqladmin -p processlist
Are there any ways to remotely connect to MySQL besides TCP/IP? Also,
what are the 'bad' implications for allowing to connect to MySQL via TCP
remotely?
Thanks for your advice in advance.
-
Before posting, please check:
h
Why do think this should not be an error?
If you were writing a script, would you not want to know you had made
the error?
Just how many , or how severe should errors be before you are notified?
Alain Williams wrote:
>Hi,
>
>I thought that I would report a very minor bug that I have just found
On Tue, 2002-07-23 at 12:28, Dicky Wahyu Purnomo wrote:
> I think the proper word for your case is "mysql busy" not "hang".
> you should check from your system (OS) side the cpu usage of mysql
> where the query is running
When the problem arises both cpu's (client and server) are 2% busy and
th
On Tue, 2002-07-23 at 15:27, Gerald Clark wrote:
> 20 simultaneous cartesian products on large tables would be expected to make
> any sql server busy, not to mention use a lot of temporary disk space.
> Are you sure you are not running out of disk space?
No, there's enough disk space and memory
20 simultaneous cartesian products on large tables would be expected to make
any sql server busy, not to mention use a lot of temporary disk space.
Are you sure you are not running out of disk space?
Andrea Carpani wrote:
>Here's my problem:
>
>I've just installed mysql version 3.23.51 (before
Hi...
What is the best way in MySql to store a session_id in hex format.
Can Integer also store hex values like:
E4FA762685A23E002D86483AACE9BD7B
Thanks
Ilyas
-
Before posting, please check:
http://www.mysql.com/manual.php
On Tue, Jul 23, 2002 at 07:38:42AM -0500, Jay Blanchard wrote:
> [snip]
> If I do something like:
> select * from foo where bar=123;;
> I get the result of the select followed by:
> ERROR:
> No query specified
> This is because I have ';;' at the end of the line and it is complai
Cindy wrote:
>I seem to be destined to become an expert on restarting mysql and
>dealing with passwords despite myself :-). This time I'm working on a
>slight variation: restarting mysql on a machine that we haven't been
>using for some 18 months and that I myself have never used.
>
>Mysql app
What instances can cause a Table to crash?
Is this caused by a bug in itself, a power failure, or something else?
Richard
>> William_dw,
>> Tuesday, July 23, 2002, 10:34:16 AM, you wrote:
>> WS> I'm hoping someone can give me a pointer as to what's going wrong
>> that's
>> WS> crashi
[snip]
If I do something like:
select * from foo where bar=123;;
I get the result of the select followed by:
ERROR:
No query specified
This is because I have ';;' at the end of the line and it is complaining
about the empty command.
OK, I should not have typed it, but I do
Dear MySQL fellows,
I'm having a problem with a program running 24/7 dumping core almost every
morning. The program has a few memory leaks, and the odd behavior could be
related to this. The program is connected to the database at all times. It
never reconnects.
Database server is running on Red
First of all, changing action to INT(2) vs INT(11) takes the same space
{# inside ()'s is for display purposes not storage} on disk {I think
it's 4 bytes, but would have to look it up}. TINYINT or maybe even ENUM
{my preference} would only take 1 byte and would serve your purpose.
You could make
Steve,
Tuesday, July 23, 2002, 7:36:39 AM, you wrote:
S> Can anyone tell me how do achieve the following in MySQL:
S> Update oitems
S> SET Pstatus = SELECT product.Pstatus from products
S> WHERE oitems.Pstatus not like "%Printed%"
S>AND oitems.ProdCode=products.Code
S> i.e.
Edward,
Monday, July 22, 2002, 4:46:07 PM, you wrote:
>> >After issuing an incorrect GRANT command Mysqld crashed, but
>> >restarted itself. On the next boot-up of the machine, Mysqld
>> >crashes on startup with an added message about unable to find
>> >user.MYD Copying user.MYD f
Tam,
Tuesday, July 23, 2002, 12:39:33 AM, you wrote:
T> I have difficulties obtaining the MySQL4.0.2a. It seems that numerous
T> downloads
T> links point to the files stated as 4.0.2 zip file but during the setup , it
T> was 4.0.1a
T> instead. Where can I obtain the 4.0.2a ? Many thanks.
The
William_dw,
Tuesday, July 23, 2002, 10:34:16 AM, you wrote:
WS> I'm hoping someone can give me a pointer as to what's going wrong that's
WS> crashing our MySQL server, I've included a snippet of the log (for the last
WS> time it restarted and then the errors after that).
WS> I've been trying to
Hi there is there a simple tutorial on using Mysql-Front with M$ Access
as i have a number of issues relating to operational M$ Access 2000 DB
that i want to migrate to Mysql Back-end and preferable utilise
MySql-Front .
I assume that i use Access Export Feature to migrate tables content to a
> The Database is called wald_data and the fields are:-
> f_name varchar(30) not null,
> t_name varchar(120) not null,
> sub_p varchar(120) not null,
> sub_g varchar(120) not null,
> datevarchar(30) not null
Hi,
I thought that I would report a very minor bug that I have just found in the mysql
command.
(Ver 11.13 Distrib 3.23.36)
If I do something like:
select * from foo where bar=123;;
I get the result of the select followed by:
ERROR:
No query specified
This is because I
Pada Fri, 19 Jul 2002 14:51:00 -0400
"Luis Manuel Cova" <[EMAIL PROTECTED]> menulis :
> Hi..
>
> I'm working on a proyect to implement a SQL server with PHP to allow acces
> to a MySQL server on the web.
> The Master server (the server everybody work with) is a Windows 2000 CENTURA
> SQL server.
On Tuesday 23 Jul 02, David Starks-Browning writes:
> On Wednesday 17 Jul 02, Chris Tjon writes:
> > I recently download mysql-3.23.51 and compiled it on a solaris 9 (sparc)
> > system using gcc-3.1. I ran into a couple of minor compile errors which
> > were easily fixed by a couple of type cas
Pada Tue, 23 Jul 2002 00:43:51 -0400 (EDT)
Yuri <[EMAIL PROTECTED]> menulis :
> I am acessing MySQL 3.23.51 running
> on FreeBSD 4.6-i386.
>
> Variable interactive_timeout=28800.
> But without activity server disconnects
> in 10 minutes. In both cases of just
> mysql client and myODBC from Windo
Pada Mon, 22 Jul 2002 12:00:14 -0700
Cindy <[EMAIL PROTECTED]> menulis :
> b) BUT if previously set, this does not work. If you don't remember
> the password, then you need to stop the mysql server (if
> applicable), and (re)start it using safe_mysqld --skip-grant-tables
> & [and then pr
Pada Tue, 23 Jul 2002 09:19:27 +0800
"lorenzo.kh" <[EMAIL PROTECTED]> menulis :
> Hi,
> Assuming that there are 2 users for MYSQL.
> First user issues 'lock tables customer_table write';
> Second user wish to view the customer info using the command 'select * from
> customer_table';
> This select
Pada Tue, 23 Jul 2002 03:20:54 +0200
"Richard Pijnenburg" <[EMAIL PROTECTED]> menulis :
> Dear list,
>
> I've been trying to install mysql 4.0.2. alpha.
>
> The configuration is going well.
> That also count's for the "make" command.
> But when I run the "make test" command I'm getting the foll
On Wednesday 17 Jul 02, Chris Tjon writes:
> I recently download mysql-3.23.51 and compiled it on a solaris 9 (sparc)
> system using gcc-3.1. I ran into a couple of minor compile errors which
> were easily fixed by a couple of type casts.. so far, it seems like the
> casts are fine here ar
On Tuesday, 23. July 2002 09:34, William_dw -- Sqlcoders wrote:
> Hi!,
> I'm hoping someone can give me a pointer as to what's going wrong that's
> crashing our MySQL server, I've included a snippet of the log (for the last
> time it restarted and then the errors after that).
>
> 020722 8:55:45
Pada 23 Jul 2002 12:11:18 +0200
Andrea Carpani <[EMAIL PROTECTED]> menulis :
> "select * FROM $table1 s,$table2 t"
>
> where the two tables are choosen randomly (some of the tables are quite
> big), then repeats this with another (not cached) connection. The script
> runs on another machine. If
Here's my problem:
I've just installed mysql version 3.23.51 (before this one I tried
3.23.49) compiled from scratch with:
CFLAGS="-fomit-frame-pointer -O3 -fPIC" ./configure --prefix=/opt/mysql
--disable-shared --with-mysqld-user=mysql --with-debug
It compiles and runs fine, but fails as soon
First off, this post is going to be long :)
I have designed a database that tracks member earnings on the site. Currently, the
site has been operating for two weeks, has 10,000 members, and the earnings table
already has 750,000 rows. I ran a query to see how many rows were being added each
First off, this post is going to be long :)
I have designed a database that tracks member earnings on the site. Currently, the
site has been operating for two weeks, has 10,000 members, and the earnings table
already has 750,000 rows. I ran a query to see how many rows were being added each
1 - 100 of 102 matches
Mail list logo
