Hello, mysql,
1 master and 1 slave replicated successfully.
After I change the master IP address.
So the slave can not replicate the master data.
Then I type change master to 'new ip'.
Show slave status show that an error log found.
How can I slove this?
Log:
mysql show slave status\G
1) make sure mysql is running [and as user mysql] do a ps -aux to see.
2) make sure that the mysql folder and files are owned by mysql (ls -l)
On Sun, 2003-07-27 at 10:38, D. K. wrote:
Hi;
I have installed suse 8.2 a short while ago and at my first attempt to connect mysql
(via shell and a
Hello all,
I am working on a book on MySQL, and I need some assistance with deciding
where some concepts should be dealt with.
1. I have dealt (briefly) with primary keys and indexes in a chapter called
MySQL DML. I have not discussed foreign keys in this chapter.
2. I would like to discuss
Greetings
I have a table and I want to make a copy of it in the
same database. I only keep the structure and indexes
and not the data.
I issue a command -
create table `aimdb`.`mtv20030105spots_copy` ( primary
key ( AdInstanceID ) ,FULLTEXT KEY `KeyNumber` (
`KeyNumber` ), FULLTEXT KEY
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,
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. The hospital runs a Windows network and I have
MYsql running on a linux box connected to the network. I need to import the Access
.mdb data and structure from
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:57H M Kunzmann :
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
Hi,
I want to install phpMyAdmin on my windows 2000 box. Whare can I find the PhpMyAdmin
software to download.
Thanks
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
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
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
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
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:07jackiesu :
Thank you very much for your help, but I don't run on a
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!
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 when
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,
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:
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 and
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
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
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 choice.
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
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
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\binmysql -u administrator -h localhost -p
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your
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
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
Hi,
in some strange way the version number did not propagate into the
manual for version 4.0.14. It starts like this:
quote
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
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
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
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,
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
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 a website
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
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
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
-Original
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
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
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 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
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!
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:
quote
This is the Reference Manual for the `MySQL Database System'. This
version refers to the {No value for `mysqlversion'} version
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 long time and
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
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!
On Jul
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
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
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
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
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
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
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 AM
[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:
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
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
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
sweatshops
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
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
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
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,
Venelin
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=getsearch=0x8B686E08
There's no place like 127.0.0.1
--
MySQL General Mailing List
For list archives:
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
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
Greetings
Having a table with the following structure -
+-+---+---+--+-+-+--
--+
| Field | Type | Collation | Null |
Key | Default | Extra
|
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
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
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
SELECT
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
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
(Jobs). I'm
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
[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 do
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 ActiveJob1 OR ActiveJob IS NULL
GROUP BY j.job_id
I'm
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
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]
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
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
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
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
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
[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 exercise
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 table
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 - How
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
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 chars
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:
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 able to
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
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
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
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;
++--+--+-+-+---+
|
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. 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:
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?
---BeginMessage---
I cannot seem to find this in the MYSQL Reference. Are
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
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 -
1,[EMAIL
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,
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
it.
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
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));
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 on
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 on 6.2
1 - 100 of 102 matches
Mail list logo