maybe the follow is helpful for you
"
> Nothing works correctly on Windows ME. Throw it away and move forward or
> back. I have never seen a stable ME installation
Yes, it's true. Go back to Windows98SE or forward to Windows2000. I'm using
Win98SE and I', happy :-)
"
-Original Message-
F
On Fri, Feb 28, 2003 at 05:19:15PM +1100, Justin French wrote:
> Hi all,
>
> On my LAN server (FreeBSD, MySQL 3.32) the following query works fine, and
> seems to return 2 random rows from the table:
>
> SELECT * FROM disc ORDER BY RAND() LIMIT 2
>
> However, when I upload the scripts to the liv
Can anyone plz help.
Is database connectivity between Mysql (Linux) and Visual C++ posible, which
has to be achived from a remote server.
How can I achive this functionality.
TIA
-
Before posting, please check:
http://ww
DISTINCT works on the result set and across the entire select list. It will
suppress duplicate result *rows*.
This is an interesting problem when using MySQL due to the lack of support
for nested SELECTs. In other database systems, I'd use a correlated
subquery in the where clause, but with MySQ
Hi all,
On my LAN server (FreeBSD, MySQL 3.32) the following query works fine, and
seems to return 2 random rows from the table:
SELECT * FROM disc ORDER BY RAND() LIMIT 2
However, when I upload the scripts to the live server (Linux, MySQL 3.32),
the results are VERY un-random -- only very occas
The only reason I could see for this would be if you have duplicates (across
date num1 num2 time) in both tables, or quadruplicates in one.
You join looks correct, so take a closer look at your data. Try running the
following queries:
SELECT A.date, num1, num2, A.time, Count(*)
FROM A
GROUP BY A
Mark wrote:
Hi,
Something bad happened the other day, a query hosed all the data in
my table, but luckily I had an original dump of the table from 4
months ago and binlogs from then on. I had to load the original table
into a separate db and then grep through the binlogs for queries to
update
Hi,
Something bad happened the other day, a query hosed all the data in
my table, but luckily I had an original dump of the table from 4
months ago and binlogs from then on. I had to load the original table
into a separate db and then grep through the binlogs for queries to
update it with, stopping
All,
I have two tables like the following
table A
date num1 num2 time
table B
date num1 num2 time
When I run a query like the following
select * from A as a inner join B as b
on a.num1 = b.num1 and a.date=b.date and a.num2=b.num2
and a.time=b.time
I am getting the results repeated 4 times, co
hi there i was wondering if there was a must get mysql book or paper
covering query optimisation ?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
At 19:08 -0500 2/27/03, [EMAIL PROTECTED] wrote:
After wrestling to get everything set up with 4.1, it looks like it
still does not give the VITAL information of what problems were
encountered in data loads (on 4.1 2/25/03) -
mysql> load data infile
'/Users/jason/Desktop/Hoodata/National1-subse
Hello Gary,
The MySQL server uses the "myisam" libraries to access MyISAM tables at the
lower level. It works similarly to and just as quickly as C-ISAM, though the
API is fairly different (IMHO).
A myisam user manual is available, but is not complete (I know, since I
wrote it).
You could use that
Frank,
> Before you go any further, I would attempt to answer one question.
> Are you trying to determine which Author had the highest royalties or are
> you trying to determine which Author has the highest royalties in each
> program(I am assuming an author can work on multiple programs)? This wi
Sheryl,
See my comments below...
(1) What is the rule that SELECT DISTINCT uses when deciding which of
multiple instances to return? Does it return the first one?
How it selects the distinct items is outside my area of knowledge.
I would not assume it is the first one or the last one, or anywhere
Hello,
I think this is fairly on-topic, but does anyone know of or use a [free]
invoice program that uses MySQL? I need to setup something for my Dad that
is quick and easy to use. Doesn't need to have all that much, just simple
things, as I would probably modify it down to what it needs to be.
T
After wrestling to get everything set up with 4.1, it looks like it still does not
give the VITAL information of what problems were encountered in data loads (on 4.1
2/25/03) -
mysql> load data infile '/Users/jason/Desktop/Hoodata/National1-subset.tab' into
table tri;
Query OK, 91515 rows affe
ahh ok cool , i am installing 4.0.11 now so one is going to a directory
called mysqlmaster and another mysqlslave and slave on 3307 cool thanks and
each sock file goes to their own var dir
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, February 28, 2003 9:53 A
From: [EMAIL PROTECTED]
To: "tegun bahq" <[EMAIL PROTECTED]>
Subject: Re: QUESTION. Date: Fri, 28 Feb 2003 00:33:06 +0100
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in y
At 22:05 27/02/2003 +, Ahmed Shams wrote:
I am having problems using MYSQL on Windows ME operating system. It
installs fine with no problems, but at the point where I try to connect to
mysqld i get the error of bad command or file name at the dos propmt.
therefore when I try to create a dat
Oh, and just as a sidenote all the queries have indexes that match the order
by and where conditions (they're the same indexes as the original database).
-Gary Hertel
- Original Message -
From: "Gary Hertel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 2:5
I'm in the process of writing a report writer for mysql which is necessary
for the migration from the current database of my company's product to mysql
(due to the amount of reports dependent on the current database report
writer).
Anyways, I'm running into a little bit of a performance issue as t
At 9:42 +1100 2/28/03, Dan Rossi wrote:
hi there , is it possible to have both slave and master on the same machine
Sure.
? how do i go about setting that up for testing purposes ? sql
Same way you'd set up multiple servers even they weren't being used
for replication: Give them different data di
At 16:37 -0600 2/27/03, Aman Raheja wrote:
Hi All
Suppose I have a table in mysql with a column name ID int(5) primary key
auto_increment
The (5) is irrelevant. That is the display width, which has nothing
to do with the range of the underlying column type.
1> What happens when the upperr limit of
On Thu, Feb 27, 2003 at 04:37:16PM -0600, Aman Raheja wrote:
> Hi All
> Suppose I have a table in mysql with a column name ID int(5) primary key
> auto_increment
> 1> What happens when the upperr limit of the integer is reached?
Error.
I don't know the specific error, because I've never tried it.
hi there , is it possible to have both slave and master on the same machine
? how do i go about setting that up for testing purposes ? sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
Hi All
Suppose I have a table in mysql with a column name ID int(5) primary key
auto_increment
1> What happens when the upperr limit of the integer is reached?
2> What are those limits?
I am not a hardcore database person, though do some database stuff for a
company, so accept the novice question :
Jeremy
select id from global where uniqueref = '2'".
In this case uniqueref = 2 relates to uk civil birth, deaths and
marriage records
Please see info as requested.
Field,Type,Null,Key,Default,Extra
ID,int(11),,PRI,NULL,auto_increment
UNIQUEREF,double,YES,,NULL,
JGSGBCERTNO,varchar(255),YES,
I would have thought that in a well designed 3rd normal form database there
would not be much worth grtouping in the rows. Even 1st normal form tries to
ensure there is nothing to group in the rows.
This isn't an early April Fool thing is it?
John Bonnett
-Original Message-
From: DiAnNe
I am having problems using MYSQL on Windows ME operating system. It installs
fine with no problems, but at the point where I try to connect to mysqld i
get the error of bad command or file name at the dos propmt. therefore when
I try to create a database I keep getting "Error-2003: Can't connect
William, Egor, thanks for your attention on this.
William is correct, on debian the standard place for my.cnf is
in /etc/mysql, and we aren't having problems not reading my.cnf
(it worked perfectly well to change the param there for the master).
In desperation, I figured I'd just redo the slave
On Thu, Feb 27, 2003 at 09:27:41AM -0500, Brent Baisley wrote:
> Maybe you should rethink your whole database structure. In your
> simplified example, you really only have two pieces of data, the text
> and a qualifier (a, b, c, d, e, ...). So instead of separating your
> "text" into different c
Hi
Im fairly new but thought I was doing ok.
I have a single table with 123 columns and currently it holds 49,000
records
My ISP is running MySql v: 3.23.38
I use MySql Front to access the table
The following query took 32 seconds to retrieve 941 records the primary
key is the ID field and e
I am posting this again, in hope that I will get a response.
I tried doing the following (see VB code below. I got this code from another
site):
I get the same error message as if I was calling the DLL I created in C
which calls mysql_server_init.
Is it impossible to call this function from VB
> (select Computer.CompID, Computer.Location, Computer.User from Computer
> where Computer.OS like "Microsoft*")
> except all
> (select Software.CompID from Software
> where Software.Name = "Excel");
I think your trying to do what mySQL considers a sub-select and mySQL can't
handle those yet(AFAIK
> On Thursday 27 February 2003 05:41, Liz Derr wrote:
>
>> I'm using MySQL 3.23.49-log on Debian Linux 2.4.18-bf2.4.
>> I am using replication over ssh tunnels, and one of the slaves is
>> apparently in need of performance tuning.
>>
>> After reviewing the status and variable settings (detailed bel
Thank you ... I'm usually pretty good at researching stuff (comes from my
prior life as a CPA trying to find IRS tax regulations) but when you don't
know the right terminology, all the searching in the world won't turn up a
spider if you're using amphibian instead of arachnid!
Renee :)
-Origi
At 0:32 +0700 2/28/03, Somsak RAKTHAI wrote:
Dear sir,
I used mysql-4.0.10-gamma on RedHat-8.0.
My system have memory 1G therefore I used "my.cnf"
from "support-files/my-huge.cnf".
But I can"t start MySQL. It has error messages below.
030227 10:15:21 mysqld started
/usr/local/mysql/libexe
I'm working on learning mySQL, and SQL in general. I have a database book from
college (just last year, so it's not an old one) and was looking for a way to do a
difference between two groups. In my book, it says to use the EXCEPT operation,
but either I did it wrong or it doesn't exist. Here
The technique you are looking for is usually referred to as "recordset
paging". A Google search for PHP Recordset Paging brought back a slew of
hits. Find one that appeals to you/explains what it does so you can use it.
HTH,
Tore.
- Original Message -
From: "Stitchin'" <[EMAIL PROTECTE
Hi, I downloaded the rpm file for this and installed using rpm -i MySQL-3.23.55-1.rpm.
It went fine and said I should run mysqladmin to set root password but all I got was
'command not found'.
I then tried to uninstall it, without much luck:
[EMAIL PROTECTED] Downloads]# rpm -e MySQL-3.23.55-1
On 27-Feb-2003 Sheryl Canter wrote:
>
> SELECT *
> FROM programs p, authors a, royalties r
> WHERE p.ProgramID = r.ProgramID AND a.AuthorID = r.AuthorID
>
> I could change this to SELECT DISTINCT * ..., but then which author would I
> get? If it's always the first encountered row, then could
Dear sir,
I used mysql-4.0.10-gamma on RedHat-8.0.
My system have memory 1G therefore I used "my.cnf"
from "support-files/my-huge.cnf".
But I can"t start MySQL. It has error messages below.
030227 10:15:21 mysqld started
/usr/local/mysql/libexec/mysqld: ERROR: unknown option '--log-bin
Hey Joseph and people
Thank you very much for the advice. A stupid little mistake here :)
Yes, I have a smallint key field :)
Thanks a lot and regards from Brazil
**
Em 27/2/2003 Joseph Bueno escreveu:
>Have you by any chance defined an unique ind
On Thursday 27 February 2003 05:41, Liz Derr wrote:
> I'm using MySQL 3.23.49-log on Debian Linux 2.4.18-bf2.4.
> I am using replication over ssh tunnels, and one of the slaves is
> apparently in need of performance tuning.
>
> After reviewing the status and variable settings (detailed below) and
On Thursday 27 February 2003 11:05, gregory lefebvre wrote:
> My tables are MyIsam type. I put some contraints for compatibility.
> When I enter a "desc table ;" I cannot see which contraints belong to
> this table.
> What is the SQL command line to do this ?
MyISAM doesn't support foreign key co
On Wednesday 26 February 2003 18:49, Juan wrote:
> Does the last binary version available of MySQL
> (4.0xx) support UNICODE?
Unicode will be available since 4.1. There is no binaries for 4.1 yet.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is spons
On Thursday 27 February 2003 06:54, geeta varu wrote:
> i would like to use rowid in my query does
> mySQL support this ..if s how do i give in query
> please help...
>From the MySQL manual:
"If the PRIMARY or UNIQUE key consists of only one column and this is of type
integer, you can al
On Thursday 27 February 2003 17:04, Somsak RAKTHAI wrote:
>I used mysql-4.0.10-gamma on RedHat-8.0.
> I used "my.cnf" from "support-files/my-large.cnf".
>
>When I backup all DataBases I used command below.
> mysqldump --all-databases > all_databases.sql
>
>I want to know what comm
On Thursday 27 February 2003 13:45, Hugo Wetterberg wrote:
> Does anyone know how to use text fields (BLOB) in the full text search?
You can create a fulltext index only on the VARCHAR and TEXT columns, but not
on the BLOB.
How to use fulltext index with TEXT columns look at:
http:/
We have used procmail and PHP combination to achieve this for our
department mail management and associated workflow.
Sendmail invokes procmail which delivers the mail to the normal inbox
and invokes a PHP script thru LYNX
The PHP script opens an IMAP connection to the inbox, reads the mail and
p
Paulino,
do you have any auto_increment index of type SMALLINT ???
.. and what's in the error.log ?
Thomas Spahni
(sql, query)
On Thu, 27 Feb 2003, Paulino Michelazzo wrote:
> People
>
> I have a txt file with 250.000 lines but, I'm import only 32767 lines.
> The database don't say anything (er
Dyego,
- Original Message -
From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 10:42 PM
Subject: The MySQL and InnoDB FK´s
> Hi,
>
>I would like to know if is there a way to delete constraints
>witho
Jesse
But then something else must be terribly wrong. As long as you are pulling
ten thousands of hits from the server, it may be slow. But when you reduce
the number of results with (let's say) 'LIMIT 100' I expect typical serch
times of 0.02 sec. That's what I see on a comparable machine holding
mysql
Dear Sir/Madam:
We would like to introduce the our new product for you, If you do not want to receive
such kind of information, I'm sorry, Please delete it, thank you!
Yueqing heavy transmission shaft factory,specially produce universal transmission shaft
We products:
WSD Type,WS type,wss
Have you by any chance defined an unique index on a SMALLINT field ?
In this case have a look at:
http://www.mysql.com/doc/en/Numeric_types.html
Regards
Joseph Bueno
Paulino Michelazzo wrote:
People
I have a txt file with 250.000 lines but, I'm import only 32767 lines.
The database don't say anyth
Hi Frank,
I had two main questions:
(1) What is the rule that SELECT DISTINCT uses when deciding which of
multiple instances to return? Does it return the first one?
(2) Is there a way to write a SELECT statement to return the record for the
author with the highest royalty percent (a different f
I've had great success with my first PHP/mySql project. It's a catalog to
showcase my embroidery designs. My embroidery database is working, the php
code I embedded in my FrontPage2002 pages is working great, I can click on
my admin button and upload info into the database.
Because of the pictur
People
I have a txt file with 250.000 lines but, I'm import only 32767 lines.
The database don't say anything (errors)
I'm using MySQL 3.23.53 in the Linux Slackware 8 system
Anyone can help me to solve this?
Regards
Paulino Michelazzo
[EMAIL PROTECTED]
IC
Are you using Windows? If so, this root/mysql user talk will be
meaningless. You can still make the directory secure and only touchable
by the user that mysql is running as. Is this what you need?
> -Original Message-
> From: Dyego Souza do Carmo [mailto:[EMAIL PROTECTED]
> Sent: Wed
> I'm looking for a webbased interface that will allow me to managae mysql
> databases. However, phpmyadmin has been ruled out due to the fact it
> requires the username and password to be stored in the config file
No it doesn't.
> and that it doesn't have any security to protect the average joe
On Thu, Feb 27, 2003 at 04:45:37PM +0100, Thomas Spahni wrote:
> Jesse,
>
> this is slow because you are SEARCH'ing for 'COUNT(*)' on a word occurring
> many many times.
>
> SELECT * FROM q WHERE MATCH(qt) AGAINST ('computer') LIMIT 100;
>
> should be fast. Make sure to use a key_buffer_size as
Sheryl,
Sorry I don't time to fully address your question but I will try to give
you some feedback.
The DISTINCT functionality will give you exact that, every distinct
instance of the columns you SELECTED.
SELECT DISTINCT a.Author FROM author a
Will give you each and every author but only once.
I'm looking for a webbased interface that will allow me to managae mysql
databases. However, phpmyadmin has been ruled out due to the fact it
requires the username and password to be stored in the config file and
that it doesn't have any security to protect the average joe from
stumbling across it.
Version: MySQL 4.0.11-gamma-nt
OS: Windows NT4 Server
I have a test table like this:
CREATE TABLE test (
created date NOT NULL default '-00-00',
duration smallint(5) unsigned NOT NULL default '0'
) TYPE=MyISAM;
INSERT INTO test VALUES("2003-01-01", "365");
INSERT INTO test VALUES("2003-0
>Description:
I've tried several times to get mysql to install on my linux box, to
no avail. Everytime, the mysql_install_db script hangs when it tries
to run mysqld. Running mysqld by hand hangs the same way as well. I've
seen over a dozen reports of this on the mysql mailing list in the last
y
gerald_clark wrote:
> You may not have enough rows to make it worthwhile to use an index.
That may be true for the example query I posted that uses the Unit Test
data, which is not much.
A user of phpOpenTracker reports the same EXPLAIN result for the query
performed on tabled with 1.000.
Jesse,
this is slow because you are SEARCH'ing for 'COUNT(*)' on a word occurring
many many times.
SELECT * FROM q WHERE MATCH(qt) AGAINST ('computer') LIMIT 100;
should be fast. Make sure to use a key_buffer_size as big as you can
afford, possibly keeping the whole index in memory.
Thomas Spah
At 22:04 +0700 2/27/03, Somsak RAKTHAI wrote:
Dear sir,
I used mysql-4.0.10-gamma on RedHat-8.0.
I used "my.cnf" from "support-files/my-large.cnf".
When I backup all DataBases I used command below.
mysqldump --all-databases > all_databases.sql
I want to know what command to restore Da
Very easy... just copy paste the content of your file
(from mysqldump) into your mysql-client command line.
That's all.
--- Somsak RAKTHAI <[EMAIL PROTECTED]>
wrote:
> Dear sir,
>I used mysql-4.0.10-gamma on RedHat-8.0.
> I used "my.cnf" from "support-files/my-large.cnf".
>
>When I backu
These are very subjective questions and I know there is no hard answer,
I'm just seeking opinions from the community to get an idea to see if
these are worth testing.
1. Dedicated DB server vs clustered DB/WWW servers.
setup a:
2 servers running both WWW and DB. Each server queries it's local
Didn't receive answer to message below. Could someone please take a look?
TIA.
- Sheryl
- Original Message -
From: "Sheryl Canter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 11:49 AM
Subject: SELECT DISTINCT question
I need help with a query. I
Dear sir,
I used mysql-4.0.10-gamma on RedHat-8.0.
I used "my.cnf" from "support-files/my-large.cnf".
When I backup all DataBases I used command below.
mysqldump --all-databases > all_databases.sql
I want to know what command to restore Database ?
thank you very much.
Maybe this could help?
Try changing the name of the index on the second table you 've created
Thanks for the idea, but I think I've discovered the problem. Perhaps I
chose my search phrase a little TOO well. It seems the problem occurs
because of the 50% restriction for fulltext searching. Fr
MySQL supports _rowid. _rowid is defined as a synonym for the primary key if the
primary key consists of one column and is an integer.
Hope this helps,
John Griffin
-Original Message-
From: geeta varu [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 26, 2003 11:54 PM
To: [EMAIL PROTE
You may not have enough rows to make it worthwhile to use an index.
Sebastian Bergmann wrote:
For this query
mysql> EXPLAIN
-> SELECT COUNT(accesslog.document_id) AS item_count,
-> data_table.stringAS item
->
->FROM pot_accesslog accesslog
I'm having a problem with FULLTEXT searches going much more slowly
than I expect, and need. It seems that this is perfectly straightforward
so I can't see why it's taking so long; other people on this list have
been reporting almost instantaneous results from FULLTEXT searches.
I'm using MySQL 4.
Hi,
I'm a belgian student in engineering and I'm now in my last year. I have a course about strategy where we have to analyse an industry and a particular company inside that industry.
I think MySQL would be a good choice because I am very interested in free and open source software and it
Hello Duncan,
Thursday, February 27, 2003, 4:00:31 PM, you wrote:
SD> I having some strange things occur with doing fulltext searches. I'm not
SD> exactly sure how to tackle this problem, so I figured I would send it out
SD> and see if anyone has any ideas or has seen this before.
SD> Backgroun
Maybe you should rethink your whole database structure. In your
simplified example, you really only have two pieces of data, the text
and a qualifier (a, b, c, d, e, ...). So instead of separating your
"text" into different columns, keep all your text in one column and add
another column that a
What versions of MySQL are on each machine ?
Jerry
- Original Message -
From: "Floyd Wellershaus" <[EMAIL PROTECTED]>
To: "Mysqllist (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 1:55 PM
Subject: mysql replication across platforms
> Hello,
> I am unsuccessfully trying
I am receiving a "Segmentation Fault" error when closing the connection to a
database. Using MySQL 4.0.10-0 on Redhat linux 7.3
static void closeDatabase( DBMS_STATE_INFO *dbmsInfo )
{
mysql_close( dbmsInfo->connection );
dbmsInfo->connection = NULL;
}
Th
I having some strange things occur with doing fulltext searches. I'm not
exactly sure how to tackle this problem, so I figured I would send it out
and see if anyone has any ideas or has seen this before.
Background:
I have been investigating the use of MySQL to do fulltext searches on
emails. Th
Hello,
I am unsuccessfully trying to start mysql replication between an Sun Solaris
server and a RedHat Linux server.
Can this be done ?
What about the fact that the binary files for the logs that need to be
transferred over upon replication startup are from different OS's.
Does anyone have any ex
I'm attempting to install MySQL 3.23.55 from source on a Red Hat Linux 7.3
machine. I have recently built and installed GCC 3.2.2 and GNU make 3.80
successfully. Following the steps given on mysql.com for a source
installation, I can go through the install up to and including
"./configure --prefi
At 20:43 -0600 2/26/03, Paul DuBois wrote:
At 21:32 -0500 2/26/03, Jianping Zhu wrote:
I have a guest book which have three fields.
user name
email
comments
I want to mysql to store the information, but commnet maybe very long, is
there a better way to handle it instead of set a varchar(2000) or mo
- Original Message -
From: "Hugo Wetterberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 27, 2003 1:45 PM
Subject: Text fields & Full text search
> Does anyone know how to use text fields (BLOB) in the full text search?
> Hugo
You may create a fulltext indexes
Hello,
I am using mysql 4.0.11 and MyODBC 3.51.05 and
Crystal 9 cannot see the tables of a database.
Any ideas?
thanks, Rafa.
__
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/brows
Hi,
Try the following:
SELECT p.name, SUM( t.minutes )
FROM t_project p
LEFT JOIN t_subproject sp ON (p.id = sp.project_id)
LEFT JOIN t_time t ON (sp.id = t.subproject_id)
GROUP BY p.id;
(i prefer grouping by id than by name).
I didn't understand why your query didn't result, don't know the
Does anyone know how to use text fields (BLOB) in the full text search?
Hugo
PS.
sql,query,queries,smallint
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Wed, 26 Feb 2003, Alexandre Vaniachine wrote:
> Perl scripts
> mysql_convert_table_format
> mysql_explain_log
> mysql_find_rows
> mysql_fix_extensions
> mysql_fix_privilege_tables
> mysql_setpermission
>
> > No, the last inserted id is just 1051 or something like that.
> > Must be something else.
> > Dunno where '2147483647' comes from.
> >
> > Is there a way to reset the auto_increment value or something?
> >
> First, check out with myisamchk if the table isn't crashed.
> Then you can use SET INS
Description:
Hello Alexander,
You wrote:
>From EXPLAIN result output you can do only opposite conclusion: With InnoDB MySQL
>chooses
>to use Index TipoFeVCod for which it expects to match 9417 rows. This is about twice
>less
>rows than expected with PRIMARY key in second explain
Hi all,
I've got following question:
I've got three tables:
TABLE t_project (id, name,dossier_id, PRIMARY KEY(id))
TABLE t_subproject (id, name,project_id, PRIMARY KEY(id))
TABLE t_time (id, minutes, subproject_id,PRIMARY KEY(id))
Now I want to dp a SELECT which has following effect:
Projec
Dnia Thu, 27 Feb 2003 11:22:57 +0100
"Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> zeznał/a co następuje:
> Hello
>
> Have anyone got this error before:
> ERROR 1062: Duplicate entry '2147483647' for key 1
>
> I get it when I do a simple insert query. The primary key is an
> auto_increment f
Hello
Have anyone got this error before:
ERROR 1062: Duplicate entry '2147483647' for key 1
I get it when I do a simple insert query. The primary key is an
auto_increment field and are not specified in the insert.
Thanks,
Jonas
-
hello i will explain , in my design , i usually join tables with id's
table 1
catID - primary unique
category
table 2
productID - primary unique
product_name
catID
what is the best way to select
i usually do
select t2.product_name, t1.category, t1.catID from table2 t2 LEFT JOIN
table1 t1 ON t2
Hi!
On Feb 27, Sebastian Stan wrote:
> OK. but what about this :
> (AND i don't have a fulltext field !)
>
> Here's my table:
>
> (lac CHAR (3),
> ano CHAR (7),
> bno CHAR (18),
> cty CHAR (4),
> dat CHAR (8),
> tim CHAR (6),
> dur CHAR (8),
> ccu CH
Dear Joshua,
the server has been running for 77 days straight. I checked the boot log and
saw that it had found errors caused by a hard down on the same partition
that has problems now. fsck being done at booting reported that it corrected
the errors. Now, however, fsck still reports errors on thi
Hye the list,
My tables are MyIsam type. I put some contraints for compatibility.
When I enter a "desc table ;" I cannot see which contraints belong to
this table.
What is the SQL command line to do this ?
Thanks a lot.
Greg
---
Check it out at:
http://www.mysql.com/doc/en/Table_types.html
---
Rob
**
Rob Cherry
mailto:[EMAIL PROTECTED]
+27 21 447 7440
Jam Warehouse RSA
Smart Business Innovation
http://www.jamwarehouse.com
**
-Original Message-
From: [EMAIL PROTEC
1 - 100 of 102 matches
Mail list logo
