i got 0.96 on a dual XEON 2G 1G ram , its a dell box
> On Tue, Jul 29, 2003 at 01:41:00AM -0400, Asif Iqbal wrote:
>> Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any
>> suggestion on how to improve it ?
>
> Get a faster CPU.
> --
> Jeremy D. Zawodny | Perl, Web, MySQL, Linux
Now I am running these processes for my mysql serever
/bin/sh /usr/local/mysql/bin/safe_mysqld --datadir=/usr/local/mysql/data
--pid-file=/usr/local/mysql/data/webrt.pid
/usr/local/mysql-standard-4.0.13-sun-solaris2.8-sparc/bin/mysqld
--defaults-extra-file=/usr/local/mysql-standard-4.0.13-sun-sol
When installing the mysql4 binary it works fine. When
installing the mysql max4 binary I get the following
message when I try to run mysqld_safe. I am running
linux redhat 9.1. Would anyone know why this is
happening?
030728 23:54:57 mysqld started
030728 23:54:58 bdb:
/usr/local/mysql/data
In the last episode (Jul 29), Asif Iqbal said:
> Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any
> suggestion on how to improve it ?
Run it 4 times simultaneously in separate windows. You got 4 CPUs, use
them :) All that "benchmark" query does is tell you how fast one cpu
is.
-
On Tue, Jul 29, 2003 at 01:41:00AM -0400, Asif Iqbal wrote:
> Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on
> how to improve it ?
Get a faster CPU.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.c
i am unable to install mysql 4.0 on my Rh. 6.2 box.
>i have glib 1.2.6. When try to install the mysql it
>gives the message "Mysql-server-version no.cannot be
>installed"
>
>May i know what are the minimum requirment for
>installtion of mysql 4.0 on 6.2.
>
>Is it possible to install the mysql 4.0 o
Dear All ,
I am facing problem in installing the mysql 4.0.13 on my
linux 6.2 machine . I have pentium III server. When i give the command
rpm -ivt MySQL-server-4.0.13-0.i386.rpm it give the message " Only one
major mode may be specified "
I tried lot to install the mysql ver 4 o
Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on
how to improve it ?
On Wed, 23 Jul 2003, John May wrote:
> Xserve 1ghz - 1.08 sec
>
> G3 333mhz - 2.78 sec
>
> - John
>
>
> >On my p4 2gig
> >
> >mysql> SELECT BENCHMARK(100,ENCODE("hello","goodbye"));
> >+
On Wed, Jul 23, 2003 at 04:47:35PM -0400, Joe Gainey wrote:
>
> Currently we have a web based application that is mostly reads (4:1
> r/w). It is using a single MySQL database server. Is there any way to
> have two database servers in a master/master configuration such that
> writes to
Thanks
- Original Message -
From: "Adam Nelson" <[EMAIL PROTECTED]>
To: "'Andy Jackman'" <[EMAIL PROTECTED]>; "'MySQL'"
<[EMAIL PROTECTED]>
Sent: Tuesday, July 29, 2003 12:26 AM
Subject: RE: dbase calculations
> I believe views in Oracle (SQL Server? Sybase?) can do this if you need
> i
Does anyone know the best schema to achieve a multi-level category system?
I need a person to be able to add categories on the fly, but then
also specify sub categories and even possibly sub-categories of
sub-cats. I have found two possible ways inside one table with using
parentID, groupID, et
Great.
That does it. Thanks. Thanks. Thanks.
Karam
--- Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Jul 28), Karam Chand said:
> > Greetings
> >
> > Is there any query to know the maximum string
> length
> > of data in every column of the table?
> >
> > For eg, if I have data -
Hi Karam,
I would suggest to CREATE A TEMP TABLE with SELECT DISTINCT ... query in
your table, then do TRUNCATE TABLE to your existing table..
You can just add indexes before you insert back the records from the TEMP
TABLE...
--
Richard Bornay
ST Assembly Test Services
Test Product Engineer
I suspect that this is some kind of issue with privileges. However, the account I am
using has been given 'ALL' privileges to the database I am trying to insert to. Am I
save to assume that ALL includes insert privileges?
--- Begin Message ---
I cannot seem to find this in the MYSQL Reference. A
Hi. Can anyone stop this guy and this message? I'm getting a ton of them. I
might just direct his email to my delete bin.
Thanks,
Trina
-Original Message-
x-sender: Info [mailto:[EMAIL PROTECTED]
From: Info [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 24, 2003 10:01 PM
x-receiver: [EM
Thanks Ken,
I've found it. Great.
Regards,
Venelin
Ken Menzel wrote:
Hi Venelin,
If you have the source code go into the ./Docs directory of the
source tree and read the Makefile on how to build the format you want
(PDF, HTML etc) if that is the machine you built on there may
already be the
Hi,
I'm working on a PHP based website that loads custom pricing for users where they
logon.
I'm trying to write a query to find the custom price of an item.
Here is the table with all the prices in it.
mysql> DESCRIBE item_price;
++--+--+-+-+---+
|
I have two tables as below:
CREATE TABLE domain_types (
type_id INT(4) NOT NULL AUTO_INCREMENT,
name VARCHAR(10) UNIQUE NOT NULL,
description VARCHAR(75),
PRIMARY KEY(type_id)
) TYPE=INNODB COMMENT="Types of domains we store";
CREATE TABLE domains (
domain_id INT(6) NOT NULL AUTO_INCREM
I have managed to successfully run the following MySQL statement directly on the
server hoasting MySQL:
insert tblMealCounts set ProgramCode = '140', yymmdd = '030725', MealCode = '2',
MealCount = '11';
And, I can view the table afterwards and see the record ok. when I run it from an
applica
Richard Bolen wrote:
This works! I was then wondering how to get the total number of all
jobs that this condition is true for?
Just include count(distinct j.jobid) in the SELECT list.
Bruce
select j.*
FROM Jobs j LEFT JOIN Submissions s ON j.jobid = s.jobid GROUP BY /*
all selected columns
Hi all,
Is there a 'sleep' command in mysql? I'm trying to take a backup of MySQL instance
from a ksh script, and I want to lock all the tables before I take a back of all
datafiles. So, once I issue the lock tables command and exit the session to take
backup of the OS files, the session (and t
Hi!
On Jul 28, Niels Larsen wrote:
> Greetings,
>
> Do anyone know where to find a description of how fulltext indexing
> and query speeds depend on data volume? I have 30-40 gb of text
> distributed across 30-40 million entries, a medium size database I
> suppose. But I have not even been abl
This works! I was then wondering how to get the total number of all
jobs that this condition is true for?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 5:26 PM
To: Bruce Feist
Cc: Richard Bolen; [EMAIL PROTECTED]
Subject: Re: Re: Selec
Hi!
On Jul 28, Primaria Falticeni wrote:
> Hello,
>
> Simply I made a table with romanian characters "aAsStT". I tried to
> sort it, in fact to order it in a query.
>
> How can I do this? Please give me an example at how can I change the
> latin2.conf in a romanian one to fairly sort the
Karam,
If you look closely you'll see that it is not using the index in either of
your examples. Each query claims to scan all 33914 rows in the table, which
seems like the correct behavior. MySQL does not have an index built on the
substrings, so it has to generate each substring before
Eddy,
thank you for the bug report. I have now fixed it to 4.0.15 so that you can
set
innodb_fast_shutdown=0
Regards,
Heikki
- Original Message -
From: "Eddy Muljono" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Monday, July 28, 2003 5:26 AM
Subject: Re: MySQL 4.013 -
I believe views in Oracle (SQL Server? Sybase?) can do this if you need
it.
> -Original Message-
> From: Andy Jackman [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 12:36 PM
> To: MySQL
> Subject: Re: dbase calculations
>
>
> Kalle,
> The usual way to do this is to create the t
[snip]
> Rich's solution, which I edited out, was a good one. But, if you really
> want to do it with a single JOIN, try this:
>
> select j.*
> FROM Jobs j LEFT JOIN Submissions s ON j.jobid = s.jobid
> GROUP BY /* all selected columns */
> HAVING min(abs(s.status - 1)) > 0
>
> I leave it as an
Hi there,
If you go to the MySQL manual (chapter 4.3.1) you'll see that GRANT ALL...
does not include the granting of privileges to others. So you must use
something like:
GRANT ALL [...] WITH GRANT OPTION;
The manual has also downloadable versions.
Lian Sebe, M.Sc.
Freelance Analyst-Programmer
Try this:
Delete your_table t
Where t.version > min(t.version)
Group by t.email
Lin
-Original Message-
From: Karam Chand [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 11:27 AM
To: Jeff McKeon; [EMAIL PROTECTED]
Subject: RE: Deleting duplicating recor
Lin,
thanks for your input.
Indeed I forgot to mention there is a many-to-many relation between users
and groups.
I'm inclined though to use Solution 3. My main concern with 2 and 3 was not
to exceed the column allocated space for the concatenated string, when it
grows with the number of users in
I have recently set up mySQL on a Mandrake release of Linux (Version 7 of
Mandrake, I believe), using the binary 4.0.13 standard release.
The set up and start up all were normal, as far as I could tell, with no
warnings or error messages.
In nearly all respects, the database appears to be running
Jeremiah,
please send me a dump of the whole table structure in that database. No need
to send the actual data. Just CREATE TABLEs.
Also send me an UNEDITED capture of a mysql session where an insert fails in
that that error, and which shows that the table really exists in the
database. Below it
My posts have been blocked. Testing simple email.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi there,
I tested your setup and wors fine for me. I issued this commands as mysql's
root:
grant usage on *.* to [EMAIL PROTECTED] identified by 'nelu';
grant select,insert,update,create,drop on test.* to nelu@'%';
Then I logged in as nelu with:
mysql -u nelu -p test
create table test1 (id in
I was wondering if you were going to come back with that. Your going to
need to using grouping then. Something like this should do it:
SELECT *,SUM(s.status) AS ActiveJob FROM Jobs AS j LEFT JOIN
Submissions AS
s ON j.job_id=s.job_id
WHERE ActiveJob<1 OR ActiveJob IS NULL
GROUP BY j.job_id
I'm
[EMAIL PROTECTED] wrote:
From: "Richard Bolen" <[EMAIL PROTECTED]>
Date: 2003/07/28 Mon PM 01:37:27 CDT
I'm trying to write a select query that involves 2 tables. One table
(Submissions) has a one to many relationship with the other table
(Jobs). I'm trying to find all the records in Jobs that d
Greetings,
Do anyone know where to find a description of how fulltext indexing
and query speeds depend on data volume? I have 30-40 gb of text
distributed across 30-40 million entries, a medium size database I
suppose. But I have not even been able to test a query yet, because
indexing is on it
>
> From: "Richard Bolen" <[EMAIL PROTECTED]>
> Date: 2003/07/28 Mon PM 01:37:27 CDT
> To: <[EMAIL PROTECTED]>
> Subject: Select with join query question
>
> I'm trying to write a select query that involves 2 tables. One table
> (Submissions) has a one to many relationship with the other table
I think this gets me all the Jobs that have no submissions but I'm
really looking for any job that doesn't have a submission with a status
of 1. That means I need Jobs that don't have submissions plus jobs with
submissions with exclusively non-1 statuses.
The problem is when a job has more than
In the last episode (Jul 28), Karam Chand said:
> Greetings
>
> Is there any query to know the maximum string length
> of data in every column of the table?
>
> For eg, if I have data -
>
> 1,[EMAIL PROTECTED],2000-12-12
> 20,[EMAIL PROTECTED],NULL
> ...
>
> It will return me
>
> 2,15,10
SEL
Greetings
Is there any query to know the maximum string length
of data in every column of the table?
For eg, if I have data -
1,[EMAIL PROTECTED],2000-12-12
20,[EMAIL PROTECTED],NULL
...
It will return me
2,15,10
I hope I make myself clear.
Thanks in advance.
Karam
__
Jeremiah,
you are inserting in the database 'tamiyausa' to the table
'product_access_level'.
> But the parent table mydb/product does not currently exist!
It complains there is no table 'product' in database 'mydb'.
Can you do
mysql> use tamiyausa
mysql> SHOW CREATE TABLE product_access_level
Greetings
Having a table with the following structure -
+-+---+---+--+-+-+--
--+
| Field | Type | Collation | Null |
Key | Default | Extra
|
+-+---+---+--+-+---
Something like this should work. You want to do a left join on Jobs so
you don't filter out those without submission matches. The resulting
left join will have a value of NULL for any fields joined from
Submissions that don't have a match in Jobs. Just include at least on
field from Submissions
Nobody has any ideas on this one?
Jeff
-Original Message-
From: Jeff McKeon
Sent: Friday, July 25, 2003 3:23 PM
To: [EMAIL PROTECTED]
Subject: rights to create table, select, then drop table..
I have a need to get data from the db that requires me to
1) do a select and create a new t
How do I debug my live mysql query on a specific database to find the query
time, memory usage, etc. ?
Thanks
--
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
There a bit of discussion like this in the user comments of the manual:
http://www.mysql.com/doc/en/example-Maximum-row.html
- Andy
Venelin Arnaoudov wrote:
>
> I would copy all the records (_email_, max(version)) to a new table,
> drop the old one and then rename the new one
>
> Regards,
> Ven
Hello,
Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to
sort
it, in fact to order it in a query.
I settled the default_charset to some charsets:
latin1(default)(latin2 win1250(central european))
ÎteIbur
Ibur Îte
Ito
I'm trying to write a select query that involves 2 tables. One table
(Submissions) has a one to many relationship with the other table
(Jobs). I'm trying to find all the records in Jobs that do NOT have a
corresponding record in Submissions with a status of 1.
The problem I'm having is that when
Lian,
Between your design solutions (1) and (3), you need to decide, from the logical
business requirement, whether the nature of the relationship between user and
group is one-to-many (a group may have many users, and each user may belong to
exactly one group) or many-to-many (a group may have ma
Well, the bad news is that I did not get any positive responses (that I
can recall) from the list. But I did a little digging. suppossedly in
the latest release you can do A->B->C->D->A. Something to do with the
server name encoded in the blog. I'm not much of a dba but in todays ID
sweatsh
I just upgraded to MySQL 4.0.14-standard for RedHat Linux and am using the
pre-compiled binaries.
I have a database with INNODB tables.
When I insert a row into one of the child tables, I get the following MySQL
error:
INSERT INTO product_access_level (product_id,access_level_id) VALUES
('10201'
At 16:20 +0100 28-07-2003, Tom Gazzini wrote:
I need to have a table that supports FULLTEXT searches. This implies
that this table should be a MyISAM table.
However, I also require that this table act as a parent for child tables
in order to support referential integrity. If I create the child tabl
[snip]
SELECT id FROM sales WHERE SUM( totalsales) <= '2' GROUP BY id;
[/snip]
SELECT id, SUM(totalsales) AS TotalSales
FROM sales
GROUP BY id
HAVING TotalSales <= '2'
HTH!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Easy:
SELECT id FROM sales
GROUP BY id
HAVING SUM( totalsales) <= 2 ;
That will perform the grouping, by ID, then filter and display only
calculated rows with a sum less than 2.
> -Original Message-
> From: Yoed Anis [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 10:22
Hello,
What would be the proper way of generating a query like the following;
SELECT id FROM sales WHERE SUM( totalsales) <= '2' GROUP BY id;
Assuming the table looks like this;
Sales:
Id| totalsales| monthyear
1 | 100 | 2003-09
1 | 1 | 2003-08
1 | 2000| 2003-07
2 | 3
Andy Jackman said:
> Hi,
> I want to get any one of a number of rows that matches some criteria and
> update it so that it is marked as 'mine'. How can I do this safely?
>
> Given something like this table:
>
> create table tbl_new (
> t_value varchar(16) primary key not null,
> dt_used
Great.
So in that case I need to create a new table with
similar structure with a additional UNIQUE index on
email.
Karam
--- Venelin Arnaoudov <[EMAIL PROTECTED]> wrote:
> I would copy all the records (_email_, max(version))
> to a new table,
> drop the old one and then rename the new one
>
>
Hi,
I want to get any one of a number of rows that matches some criteria and
update it so that it is marked as 'mine'. How can I do this safely?
Given something like this table:
create table tbl_new (
t_value varchar(16) primary key not null,
dt_used datetime,
l_pid int(9
Hi,
i've been trying to run mysqld (safe_mysqld and mysqld_safe) with -W and --
warnings and --log-warnings however, no matter how i try, mysql does NOT write
information about Aborted Connects in .err file.
Have tried that on Linux and Unix, on 4th (4.0) version and 3rd version, it
just don't w
Kalle,
The usual way to do this is to create the table with the 2 real fields
and then use a query to 'create' the sum field at run time. For example
assume you have this table:
create table my_table (
field_1 int(9),
field_2 int(9)
);
then you can write this query:
SELECT fiel
Not to be too picky, but the version I downloaded didn't have a table of contents in
the .pdf file.
The older version did. It was very handy for quickly narrowing down a topic and
getting close to what you were interested in...
>>> Sergei Golubchik <[EMAIL PROTECTED]> 07/28/03 10:55AM >>>
Hi!
> I need to have a table that supports FULLTEXT searches. This
> implies that this table should be a MyISAM table.
>
> However, I also require that this table act as a parent for
> child tables in order to support referential integrity. If I
> create the child tables as INNODB tables, will ref
H M Kunzmann wrote:
>
> I use mysqldump to dump my databases to file.
> I then write these files to tape.
>
> I was doing a test restore to a test server this weekend and found that
> for my largest database, I cannot restore from this file.
>
> I use mysql < backup.script
>
> It runs for a lon
Hi!
On Jul 28, Thomas Spahni wrote:
> Hi,
>
> in some strange way the version number did not propagate into the
> manual for version 4.0.14. It starts like this:
>
>
> This is the Reference Manual for the `MySQL Database System'. This
> version refers to the {No value for `mysqlversion'} versi
hi,
I have this table:
CREATE TABLE `category_tree` (
`category_tree_id` BIGINT NOT NULL AUTO_INCREMENT,
`parent_id`BIGINT,
`mandant_id` SMALLINT NOT NULL,
`partner_id` SMALLINT NOT NULL,
`class_id` VARCHAR ( 32) NOT NULL,
`position`
Hi all,
I have install Mysql on a redhat 8 server. Works perfectly locally but
when trying to access remotely with the Mysql Control Center(on Win2k),
client freezes and so Mysqld. Must do a killall mysqld to release the
client.
Any ideas?
Francois
--
MySQL General Mailing List
For list ar
I would copy all the records (_email_, max(version)) to a new table,
drop the old one and then rename the new one
Regards,
Venelin
Karam Chand wrote:
Well that is OK if I have only one email.
What if if I have thousands of users duplicated...
Do I need to write SQL query 1000 times
Karam
Hi, Joe,
I have exactly the same scenario. Did you get any valuable response you
could share with me? I haven't seen any on the list.
In fact, my case is slightly more complicated; I have "N" computers, all
having their local databases, and have an additional computer, which I
call the "central"
Do it in MySQL if you can. "Use the force" ;-)
Besides MIN() and MAX() there are also statistical functions implemented as:
AVG(), STDDEV() etc.
See the manual for all functions.
Lian Sebe, M.Sc.
Freelance Analyst-Programmer
www.programEz.net
> -Original Message-
> From: Taylor Lewick [
Well that is OK if I have only one email.
What if if I have thousands of users duplicated...
Do I need to write SQL query 1000 times
Karam
--- Jeff McKeon <[EMAIL PROTECTED]> wrote:
> How bout
>
> Delete from tablename where email like
> [EMAIL PROTECTED] && ID <> 1
>
> Jeff
> > -O
Hello,
Simply I made a table with romanian characters "aAîÎâÂsStT". I tried to sort
it, in fact to order it in a query.
I settled the default_charset to some charsets:
latin1(default)(latin2(iso-8859-2 I think) the same like
win1250(central european))
SteSbur
Sbur
I need to have a table that supports FULLTEXT searches. This implies
that this table should be a MyISAM table.
However, I also require that this table act as a parent for child tables
in order to support referential integrity. If I create the child tables
as INNODB tables, will referential integr
How bout
Delete from tablename where email like [EMAIL PROTECTED] && ID <> 1
Jeff
> -Original Message-
> From: Karam Chand [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 10:33 AM
> To: [EMAIL PROTECTED]
> Subject: Deleting duplicating records
>
>
> Greetings
>
> I manage
Question for everyone, I have a database with about 30-60 days worth of information.
Much of it numerical.
Can and should I use SQL to run quereis that will return me the high/low and average
for the time frame, as well as standard deviation,
or should I just get all of the info into an array vi
I use mysqldump to dump my databases to file.
I then write these files to tape.
I was doing a test restore to a test server this weekend and found that
for my largest database, I cannot restore from this file.
I use mysql < backup.script
It runs for a long time and creates most of the tables, bu
Greetings
I manage a website wherein i keep track of the people
email who have downloaded my software and the version
number.
the structure is like -
id int auto_increment primary key,
email char,
version
now the same person can download different version
therfore my table has data like this -
Hi everyone,
Just wanted your expert opinion on the following:
I'm implementing an authorization system with user/group permissions stored
in a database. I have a Users table and a Group table, identical in
structure:
mysql> desc users;
mysql> desc groups;
+---+-+
| Field | Type
Hi,
in some strange way the version number did not propagate into the
manual for version 4.0.14. It starts like this:
This is the Reference Manual for the `MySQL Database System'. This
version refers to the {No value for `mysqlversion'} version of `MySQL
Server' but it is also applicable for ..
The manual page for MERGE tables states the code is in gamma since 3.23.25.
But it also says you can only SELECT, DELETE, and UPDATE, which isn't true
since version 4.0.something.
Can anyone verify if the MERGE tables is still in gamma? We occassionally
have diskspace issues on our system, and I
Schemas and user defined partitions are not utilized in MySQL as they are in
Oracle. If you are attempting to design your architecture according to
schemas you could visualize each database as an user defined schema.
CREATE DATABASE company_00;
-Original Message-
From: Morten Gulbrandsen
Hi programmers,
I try to investigate some of the basics behind schemas and cataloges,
Which is part of SQL2 Language
this is the error message I get:
C:\mysql\bin>mysql -u administrator -h localhost -p
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your
Use atoi();
Andy Jackman wrote:
Hi,
I'm new to mySql. I've got a table with an integer field defined like
this:
l_start_wait int(9) not null
I inserted a value into the table using mysql command line client with:
Insert into tbl_wait_list values(12345678);
When I use mysql_fetch_row() to re
Mysqld is the server, and can be started automatically.
Mysql is a client program. It makes no sense to start it automatically.
-{ Rene Brehmer }- wrote:
Hi gang
Not sure if this is more for the RedHat list than here, but let's try...
I've put MySQL on a RedHat by using the RPM ... haven't yet f
That's a fairly simple query you are running and should run pretty
quicker, obviously."ps auwx" isn't going to tell you enough about what
is going on to troubleshoot effectively. The cause of a slowdown on a
system is always either: CPU, Memory, I/O, or Network. "top" might be a
better choi
Hello
I'm rather new when it comes to databases and I was hoping that someone
could help me out! I was just wondering is it possible to make a field in
MySQL dbase wich is a total of two other fields.
ie.
field_XX is a sum of field_1 and field2
Thanks
-Kalle
--
MySQL General Mailing List
F
Something you may want to try. Look in this file C:\WINNT\system32\drivers\etc\hosts
and make sure this entry is in there
127.0.0.1 localhost
Also make sure a ";" or "#" is not in front of the line. If the line does not exist
at all then create it.
Hope that helps,
Bill
-Original
Thx for the answer, found it myself too:
Am Montag, 28. Juli 2003 14:22 schrieben Sie:
> Build the file and put it in your C:\>.. You are not given a my.cnf
> file if you build from source, if you had used the binary file, it came
> with about 4 of the files and you just pick one and modify it an
I saw a macro for access that will produce a script that will recreate
your tables and the data in them. But it only worked in older versions
of access.
Sorry I can't be more help.
bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Hi,
I was wondering whether someone knew of the options available for
getting customer details from a MySQL db into Outlook?
Also whether it was possible to sync Outlook, so it reads it's
Address book straight from the MySQL db?
Any suggestions would be greatly appreciated,
Many thanks,
Adam
Hi!
On Jul 28, Daniel Kasak wrote:
> http://www.mysql.com/doc/en/News-5.0.x.html
>
> The change log says it's "no longer supported". Does that mean that it
> will be there, but there are no guarantees that it's accurate, or that
> it's being removed completely?
>
> The update log is very handy
Hello List,
this is my first posting here so plz do not flame me too much if my question
marks me as a total noob.
My problem is, i play around a bit with mysql (4.0.13) and want to test the
Replication. The Documentation at http://www.mysql.com says i have to do the
following:
Stop databases
Hi Jackie,
I am sorry haven't searched for any documents myself, but I can imagine that
Google will list them up when you search for " OpenOffice MySQL Windows
Setup".
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 28日 月曜日 17:07、jackiesu さんは書きました:
> Thank you very much for your help, but I
Robert Morgan wrote:
Hi, I'm doing a project for a local hospital, they want to migrate
their access databases to mysql on a Linux box.
Depends how big the whole thing is as well as how good the current
design is. Since it is running in a hospital I hope the Access approach
was propperly done a
Hi,
I set up a two-way replication server, it works very well, but after
some hours (24-48) the replication stopps, the log-error only says:
030725 14:03:53 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:3306', replication started in log 'FIRST' at position 4
030726 9:36:40 Slave I/
Hi,
> I want to install phpMyAdmin on my windows 2000 box. Whare can I find the
> PhpMyAdmin software to download.
http://www.phpmyadmin.net/
Google would have found that for you in seconds, it's the first result for
a search for "phpmyadmin".
With all due respect, you really should try a li
there is an app called sqlyog it imports access directly into mysql
-Original Message-
From: SpamBox [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 7:13 AM
To: Robert Morgan; mysqllist
Subject: Re: importing Access databases
Robert Morgan wrote:
>Hi, I'm doing a project for a loc
Hi,
I want to install phpMyAdmin on my windows 2000 box. Whare can I find the PhpMyAdmin
software to download.
Thanks
Hi Herbert,
the -f/--force option lets you continue with the next command
Thats my $0.0.2.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 28日 月曜日 17:57、H M Kunzmann さんは書きました:
> I use mysqldump to dump my databases to file.
> I then write these files to tape.
>
> I was doing a test restore t
1 - 100 of 103 matches
Mail list logo