Hi!
It is a bug in the FOREIGN KEY syntax parser. It is confused by the column
name
e_foreigncurrency
The bug appears if the string 'foreign' is succeeded by a non-space
character in a CREATE TABLE statement.
Workaround: change the column name to e_currencyforeign, for example.
Fixed in 3.23.
Hi,
I have 2 Tables one with the data (lets call the Table Data) and one with Category
information (let's call it Category). I have a third Table (dat2cat)
with FK_Data and FK_Category that i use to assign up to n categorys to each Dataset in
Data.
I now want to get a list of datasets with ju
Oh sorry,
in my posted version of the Query i forgot a Group by clause. the Query that i have
used is:
select data.name from data, dat2cat where data.pk_data =
dat2cat.fk_data and (dat2cat.fk_category=44 or dat2cat.fk_category = 18)
group by data.name having count(data.name) > 1;
Simon Klaibe
Hi there.
Just recently I have started to investigate a possible future use of
mySql at my company. As part of this investigation I have come across
one seemingly trivial obstacle, but an obstacle very important for me.
What I wonder is if there is no means of renaming a column in a sql
select p
Hi,
after ./configure, make, make install of Version 4.0.1-alpha I executed the
mysql_install_db script to finish the installation of mysql.
The script says I should execute the commands
$/mysql/bin/mysqladmin -u root password 'mypass'
$/mysql/bin/mysqladmin -u root -h admin08-1 password 'mypass'
Hi,
How to update data in table with data from other table in single SQL
command (without using loop)?
Sommai,
--
Please be informed that all e-mail which are addressing to
thaithanakit.co.th will need to be changed to
BTsecurities
Jason,
Friday, February 15, 2002, 9:33:14 PM, you wrote:
JGE> what affects the rows in the host table of database mysql? is it when a
JGE> particular host logs in the server's mysql console? or is it when a user
JGE> browses a web file that launches a script to access a database? or both?
Table
Hi Mikaela,
Just use "SELECT group_id AS g, time AS t FROM tbl_Groups"
Simon
Original Message:
-
From: Mikaela Holmberg [EMAIL PROTECTED]
Date: Fri, 15 Feb 2002 10:19:07 +0100
To: [EMAIL PROTECTED]
Subject: Change column names
Hi there.
Just recently I have started to investig
Soory its not possible.
Here a User Comment from the Commented MySqlDoc (Chapter UPDATE Systax)
--
Comments:
Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from
another table. aka. UPDATE with JOIN.
I noticed many other people were asking the same que
Sorry its not possible.
Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax)
--
Comments:
Michael Holopainen: I was looking for info on how-to UPDATE with data retrived from
another table. aka. UPDATE with JOIN.
I noticed many other people were asking the same qu
HI
> Hi,
> How to update data in table with data from other table in single SQL
> command (without using loop)?
>
> Sommai,
insert into table1 select * from table2
Kittiphum Worachat,MT.
www.hatyailab.com
-
Before posting
Mikaela Holmberg a écrit :
>
> Hi there.
> Just recently I have started to investigate a possible future use of
> mySql at my company. As part of this investigation I have come across
> one seemingly trivial obstacle, but an obstacle very important for me.
> What I wonder is if there is no means
Thanks for all the answers, you all seemed very surprised by the
seemingly easy answer
SELECT old_name as new_name FROM ...
which made me feel rather at ease. I realized the problem wasn't with
mySQL - for it certainly did work as it should. even my way - without
the as. Problem was with darn da
I want to update existing data not insert new data.
sommai
At 16:52 15/2/2002 +0700, Kittiphum Worachat wrote:
>HI
>
>
> > Hi,
> > How to update data in table with data from other table in single SQL
> > command (without using loop)?
> >
> > Sommai,
>
>insert into table1 select * from table2
>
thank you very much. I have to used loop for this solution, did I?
sommai
At 04:53 15/2/2002 -0500, [EMAIL PROTECTED] wrote:
>Sorry its not possible.
>
>Here a User Comment from the commented MySql Doc (Chapter UPDATE Systax)
>
>--
>Comments:
>Michael Holopainen: I was looking for i
System,
Friday, February 15, 2002, 5:38:51 AM, you wrote:
>> jr> i made the mistake of changing my root password manually in the mysql
>> jr> database. after doing so, i 'flushed privileges'.
>>
>> jr> now i'm unable to log on using the root. i've tried to log on using the new
>> jr> password a
Yeah, for me also find error.
--
mysql> create table X1(name varchar(10));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into X1 values(5);
Query OK, 1 row affected (0.01 sec)
mysql> RENAME
I am afraid it's not a bug, rather a syntax error.
please follow the syntax to rename the table:
mysql> alter table X1 rename as X2;
Regards,
~ SubbaReddy .M
- Original Message -
From: "SubbaReddy M" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, Februar
Hi
Currently, I maintain two mysql server, hosted by separate ISPs, and
keep them synchronised using standard MySQL replication.
Server A is master+slave to server B, and likewise server B is master
+slave to server A.
This allows both servers to receive inserts/updates/deletes and
replicate
Hi!
On a site I'm developing I need to conduct boolean searches. I use a
piece of code I found on:
http://www.evolt.org/article/comment/18/15665/http://www.evolt.org/art
icle/comment/18/15665/
and I've got to say it works really well.
The problem is I cannot search for one specific word becaus
Someone in the list posted the following links. I went with the second one
and it worked.
NOBBY
> http://www.convert-in.com/acc2sqlp.htm
> http://ultradev.buzzinet.co.uk/mysql/tutorials/converting_data/index.asp
> http://www.winmysql.com/
>
- Original Message -
From: Fabio Amura <[EMAI
Okay is not a reply for myself :) is only for add a question... :)
I read that mysql 4 will fix this, but mysql 4 is stable? I mean i'm on
production, i'm not selling mysql :) I mean I have a big projet in test
using mysql.. so if it crash it will be very bad for me... someone had test
mysql 4? s
* Egor Egorov
> FL = Fred Lovine
> FL> CREATE TABLE X1 (x smallint);
> FL> insert into X1 values(5);
> FL> RENAME TABLE X1 TO X2;
>
> FL> is producing the following error:
>
> FL> 7 - Error on rename '.\\X1.MY1' to '.\\X2.MYI' (Errcode: 13)
>
> FL> The problem seems to be caused by using upper
Brent,
> >What Rick said is absolutely correct and you probably are obsessing about
> >something that doesn't matter. But I would venture you are using an
> >auto-number field as the primary key when you could easily change it to a
> >function something similar to: set ID = MAX(ID) + 1.
>
> Kei
Once tables are CREATEd, the name is listed in SHOW tables using lower case
characters, regardless of the case
used in the CREATE command.
Using upper case table names in RENAME results in the error.
Workaround: Using lower case equivalent table names works, regardless of the case used
in the C
SubbaReddy M
> I am afraid it's not a bug, rather a syntax error.
> please follow the syntax to rename the table:
>
> mysql> alter table X1 rename as X2;
Why do you say this?
Manual entry:
6.5.5 RENAME TABLE Syntax
RENAME TABLE tbl_name TO new_table_name[, tbl_name2 TO new_table_name2,...]
.
Egor,
Yours/this arrived in my InBox whilst I was addressing the original msg - please see
my other reply/ies.
Error still occurs when running as Administrator on WinNT and root under MySQL
- definitely no access/permission issues.
Lower case works (please see earlier reply).
If I/my NT PC can
Kedryna, Bartosz writes:
> In mysqldump.c there is // in 2 places, older compilers don't like it,
> changing to /* */ fixes the problem.
>
> Bart Kedryna
> Software Engineer
> Online Support
> [EMAIL PROTECTED]
> (215) 386 0100 x1470
> ISI
> 3501 Market Street
> Philadelphia, PA 19104
>
Thank y
Hi,
this has to be a bug. It seems on windows "RENAME TABLE TO " only
works for uppercase table names _after_ an "ALTER TABLE RENAME AS
" _or_ if you first rename the table using lower case letters:
mysql> create table U1 (id int);
Query OK, 0 rows affected (0.04 sec)
mysql> insert into U1 va
Roger,
Friday, February 15, 2002, 1:32:13 PM, you wrote:
RB> * Egor Egorov
>> FL = Fred Lovine
>> FL> CREATE TABLE X1 (x smallint);
>> FL> insert into X1 values(5);
>> FL> RENAME TABLE X1 TO X2;
>>
>> FL> is producing the following error:
>>
>> FL> 7 - Error on rename '.\\X1.MY1' to '.\\X2.MY
* Joao Verde
> The problem is I cannot search for one specific word because, even
> though the word exists on several records, MySQL never returns any
> rows.
>
> The word I can't look for is "portaria". Any other word works just
> fine. I have tried every word I could think of and it works... exc
Hi Brumpton,
>From the webserver, try to connect to port 3306 with telnet
Example:
telnet 10.0.0.2 3306
You should see someting like: 3.23.47♥hAJ3\Y+e☻
This means that the right ports are open on the firewall to connect to
Mysql.
>-Original Message-
>From: Victoria Reznichenko [mail
Hello mysql,
I dropped an entire database but I have the frm, myd and myi files
in a backup.
What are the complete steps to restoring this database?
Thank you for the help.
--
Best regards,
Paul mailto:[EMAIL PROTECTED]
-
Hi,
I've got query like this:
"select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C + TABLE.D) >
0"
A,B,C,D are decimal values.
There are over 1 records where A is greater than 0,
about 1000 where B is greater than 0,
about 500 where C is greater than 0,
and about 300 where D is
* Przemyslaw Popielarski
> I've got query like this:
>
> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
> TABLE.D) > 0"
>
> A,B,C,D are decimal values.
>
> There are over 1 records where A is greater than 0,
> about 1000 where B is greater than 0,
> about 500 where C is
Just copy the backup files into the database dir and the database should be
back.
Lars
At 08:22 AM 2/15/2002 -0500, Paul wrote:
>Hello mysql,
>
> I dropped an entire database but I have the frm, myd and myi files
> in a backup.
>
> What are the complete steps to restoring this database?
>
Hi mysql list members,
We use the following statements to setup users and rigts for a mysql
server which is accessible locally and via internet:
INSERT INTO mysql.user VALUES
('%','xyz00',PASSWORD('...'),
'N','N','N','N','N','N','N','N','N','N','N','N','N','N');
INSERT INTO mysql.db VALUES
('
Friday, February 15, 2002, 2:23:52 AM, Lars Heidieker wrote:
> Just copy the backup files into the database dir and the database should be
> back.
Are you sure that it's not need to CREATE it first ?
> At 08:22 AM 2/15/2002 -0500, Paul wrote:
>>Hello mysql,
>>
>> I dropped an entire database
>> I've got query like this:
>> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
>> TABLE.D) > 0"
>> A,B,C,D are decimal values.
>> The problem is, I think, with NULL columns. Often B,C and D don't
>> have decimal value, but NULL.
>> I thought, that this should be counte
Michael Hoennig <[EMAIL PROTECTED]> wrote:
> Hi mysql list members,
> We use the following statements to setup users and rigts for a mysql
> server which is accessible locally and via internet:
> INSERT INTO mysql.user VALUES
> ('%','xyz00',PASSWORD('...'),
> 'N','N','N','N','N','N','N','N','N
Hi Dimitry,
> > But we can NOT connect locally by host:port:
>
> > local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
> > => ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
> > password: YES)
>
> > On a mysqld which is accessible only locally the both INSERT
> > statem
>Description:
When trying to install MySQLi 3.23.47 and 3.23.48 on FreeBSD 4.5, We get the
following errors
during the mysql_install_db.
/usr/local/bin/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
The RENAME syntax is correct, please see the following documentation:
http://www.mysql.com/doc/R/E/RENAME_TABLE.html
-Original Message-
From: SubbaReddy M [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 5:23 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Suspected
Hi
I see:
local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
hmm.
I always use:
>mysql -u xyz -p -h ... -P 3306
Is the -O option in the right place. Maybe it sould be -P like PORT. Isn't
??
Regards.
I. Piasecki - webmaster www.b-c.pl
- Original Message -
From: "
* IvanLatysh
> >> I've got query like this:
>
> >> "select count(ID) from TABLE where (TABLE.A + TABLE.B + TABLE.C +
> >> TABLE.D) > 0"
>
> >> A,B,C,D are decimal values.
>
> >> The problem is, I think, with NULL columns. Often B,C and D don't
> >> have decimal value, but NULL.
> >> I thoug
Hi Ireneusz,
> Hi
> I see:
> local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
> hmm.
> I always use:
> >mysql -u xyz -p -h ... -P 3306
>
> Is the -O option in the right place. Maybe it sould be -P like PORT.
> Isn't??
sorry, typo in my mail. -P of course.
Alles Gute wü
I think there are a couple of bugs here:
First, per the documentation, 6.1.3 Case Sensitivity in Names
(http://www.mysql.com/doc/N/a/Name_case_sensitivity.html), the Windows
mysqld is starting with -O lower_case_table_names=1 by default, so all
filenames should be converted to lowercase automatic
Hello,
Well, for my project at work, I've done some small benchmarking
of different table types for relatively small sizes (some tens
or hundreds of thousands rows - small enough so that key buffer size
and other memory factors should not limit performance) and lots of
very simple operations. I
Michael Hoennig <[EMAIL PROTECTED]> wrote:
>> > But we can NOT connect locally by host:port:
>>
>> >local-system> mysql -h 66.70.34.150 -O 3307 -u xyz00 -p
>> >=> ERROR 1045: Access denied for user: 'xyz00@localhost' (Using
>> > password: YES)
>>
>> > On a mysqld which is accessible onl
According to the online manual the regex man page contributed by Henry
Spencer is included in the source distribution of MySQL. I'm hesitant to
download
and install a source distribution just to get a man page. Is it found
anywhere else?
thanks,
Joseph Polanik
---
Hello,
I'm encountering a serious program fault at using MySQL Win32 client library
LIBMYSQL.DLL.
I found LIBMYSQL.DLL not thread-safe. When 10 threads are launched to run
the following two blocks of C statements, very quickly a program fault
window pops up to LIBMYSQL.DLL.
block #1 --
Joe,
you can find it here:
http://arglist.com/regex/
Peter
On Fri, 15 Feb 2002, Joe Polanik wrote:
> According to the online manual the regex man page contributed by Henry
> Spencer is included in the source distribution of MySQL. I'm hesitant to
> download
> and install a source distributio
Hi everybody,
This seems to be a definite defect in MySql. While inserting a String into
a MySql attribute defined as VARCHAR or VARCHAR BINARY, etc., if a '\' is
present in the String, it is simply disregarded, and the remaining part of the
String gets inserted. For inserting a '\', we hav
http://www.google.com/search?q=regex+man+page
> -Original Message-
> From: Joe Polanik [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 15 February 2002 3 12
> To: [EMAIL PROTECTED]
> Subject: Regex man page
>
> According to the online manual the regex man page contributed by Henry
> Spencer i
Bryan,
I apologise, did I mistakenly call you Brent earlier!?
> Indeed. I have a relatively large (few dozen) number
> of tables that are accessed via PHP and a web
> interface. The script pulls information from these
> tables to generate pull-down menus. It would be nice
> if these pull-down men
Hello everyone
I've read about replication mechanism in MySQL, but I've still got some
reservations regarding transactions.
In the manual thay say that in case of a transaction, all update
instructions are hold in a cache, and on commit they are written to the
binary transaction log. After the u
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
Hei
I think we have found a bug in mysql replication.
We have some programs that are working against a master DB and that use
temporary tables. The hole system works without problems until we run a
flush master/slave. Then the replication in the slave DB stops working
because of this.
How t
How would you do:
set field='Jim said, "that's crazy."'
you would have to escape the quote somehow. The '\' is the escaper
character.
set field='Jim said, "that\'s crazy."'
That means hat the escape character must also be escaped.
Check the manual for the section on special characters.
Most
On Fri, Feb 15, 2002 at 12:16:01PM +0200, Egor Egorov wrote:
> System,
>
> Friday, February 15, 2002, 5:38:51 AM, you wrote:
>
> >> jr> i made the mistake of changing my root password manually in the mysql
> >> jr> database. after doing so, i 'flushed privileges'.
> >>
> >> jr> now i'm unable t
Hi,
Could you tell me about your TABLE-definition and
version number of your JDBC Driver?
I will check that problem.
"Stancescu, Catalina" wrote:
>
> I have a servlet in which I connect through a mysql driver to the
> database. The servlet has a string that represents the date in the
> f
Hi,
we're using myodbc2.50.36 with W2k and W98 to connect to our mysql-server
(Linux Kernel 2.2.18 - MySQL Version 3.23.38) in the internet. When we send
or receive larger amounts of data (we're using Visual Foxpro 7.0 as
frontend) we get the "aborted connections"-Message in the mysql errorlog
ve
Spoiler: Venu's Suggestion about "Dynamic Cursor" is the answer
On Thu, 2002-02-14 at 20:34, Venu wrote:
> > MyODBC, as compiled today, uses mysql_store_result to get records. This
> > is fine for reasonably sized tables. However, if the table has millions
> > of records, writing the resul
Dear Sir/Madam
I'm fifth year student from Poland. I'm studying at Academy of Minnig and Metalurgy in
Cracow (major Electrical Engineering). At the present I'm writing my master thesis. I
consider how processors with embedded interface TCP/IP can be used in distributed
system data collecting.
Hello all,
I searched the archives and found no similar problems, so here goes...
Using an almost straight out of the manual example, I am unable to
do a fulltext search using "IN BOOLEAN MODE"
using the following SQL statement:
SELECT * FROM parts
WHERE MATCH (description)
AGAINST ("+brake +p
Hello,
I have a problem with mysqld (3.32.46 under Red Hat Linux 7.2,
pIII-800 512K RAM).
It starts and works fine until some time is passed, then it starts
eating my memory and CPU.
I have the following config in my.cnf:
[mysqld]
set-variable = max_connections=200
set-variable = key_buffer=16M
s
Hello All,
I am new to this list and hope that someone could answer this
question for me.
I am running on a fresh install of Redhat 7.2 and am trying to
connect to MySQL from a program that I have to test the connections,
but am getting error messages saying that the host in not allowed to
conne
Hi Gurus,
I downloaded and installed MySql successfully, on a Windows 2000 O/S. I want
to locate the "my-example.cnf" file, copy it to my root directory and rename
it "my.cnf". However, the "my-example.cnf" file I locate is a shortcut,
pointing to no physical target. As a result, after going th
- Original Message -
From: "Andrew Crum" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 12:15 AM
Subject: License Question
> Can I statically link to libmysqlclient? If so, what are the implications?
> Will I have to distribute my application's source? IANAL
Whenever I try to issue a query which has a left join for two tables and a
where clause for a column in the second table that is a varchar the query
runs indefinitely. If I change the where clause to search on a numeric type
column the query runs and returns expected values.
Does anyone know what
does your test app connect with root as the user?
-Original Message-
From: Lonnie Cumberland [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:12 PM
To: [EMAIL PROTECTED]
Subject: connections to MySQL
Hello All,
I am new to this list and hope that someone could answer this
Show us your table structure, some table values and the SELECT statement
that works and the one that doesn't
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 12:13 PM
To: '[EMAIL PROTECTED]'
Subject: Left Join problem - Please Help
Whene
Hi all,
If one uses the timestamp data type for a column inside a table, when
executing an update query on said table on a spesific record, will the
timestamp column be updated as well or will it retain its first value?
Thanks for any info in advance,
George
mysql, query, sql
-
timestamp is automatically updated
-Original Message-
From: George Labuschagne [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 1:20 PM
To: [EMAIL PROTECTED]
Subject: When does the timestamp field gets updated?
Hi all,
If one uses the timestamp data type for a column inside a
Only the first TIMESTAMP field gets updated when an updat to a record is
made, so if you want to maintain the time a record was created, and when it
was updated, use two timestamp fields, the first field will be the time
updated, but to do this you must initialize the second timestamp field wit
Hi Darrin,
This is very starnge as I just installed two FreeBSD 4.5 machines
this week and had no problems! I installed on SMP based machines,
with very few changes from the GENERIC kernel. Is this a fresh
install of FreeBSD 4.5? If not can you run a 'make world' and 'make
kernel' again? Did
ADO supports ODBC drivers and all ODBC functionality as well as the newer
ADO/OLEDB interfaces. You should be fine with the ODBC.
Michele Harlass
DBA
AbcEd.com, Inc
-Original Message-
From: Guy Davis [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 13, 2002 1:29 PM
To: [EMAIL PROTE
Bonjour Jean-françois,
Le DESC qui utilise l'INDEX est un fonction de MySQL 4.0. Il y a
un bug en la version 4.0.1 (Quelque fois il n'utilise pas l'index
descendre ) mais pour la plus part ça marche bien. En autre il y a un
forum de MySQL en français à:
Liens utils :
Poster un message: [EMA
I don't think it's hanging. I think it's going through the process of
determining joint criteria for 11,900 table entries multiplied by 88,000
other table entries, then doing a text search on the result, which is much
slower than an integer search.
I'm posting this back to the mysql list to see
possibly
-Original Message-
From: Miretsky, Anya [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 2:32 PM
To: 'Rick Emery'
Subject: RE: Left Join problem - Please Help
When I do this without specifying a left join with just :select biblio.*
from biblio,keyword where p_biblio=f
Hello,
I am having trouble with Mysqld unexpectedly crashing.
I am running mysqld in a situation where there is a nearly constant
load on 6 databases, each with about 20 open connections (mostly
inserts and selects, occasionally a delete). Once every 3-4 days, at
seemingly random points (i.e. i
I have a written a Windows client that accesses a MySQL server (Linux)
via the MySQL C API. Stored in the MySQL database are large files
(larger than a Mbyte). The C API makes it very easy for the client to
query and alter the database. However, I have some special needs that
don't appear to be
I need some help here. Let's see if I can clearly describe it.
I have a database containing "news" stories. Each story is assigned a
"rating" (1 thru 5) indicating its importance. (A story with a rating of 5
is more important than a story with rating of 1.)
Now, lets say that there are ten s
Description:
The errors and crashes herein are related to the use of a software
package called Phorums... version 3.2.11... The query that was crashed
on here, is made against the phorums3211 database.
Log errors as follows:
--
020209 13:52:17 Aborted co
How about
SELECT * FROM news WHERE rating <= 4
ORDER BY rating DESC, RAND() LIMIT 1;
Michael
On Fri, 15 Feb 2002, Brent Macnaughton wrote:
>
> I need some help here. Let's see if I can clearly describe it.
>
> I have a database containing "news" stories. Each story is assigned a
> "r
At 13:35 15/02/2002 -0500, Juwon Aikulola wrote:
Hi!
>Hi Gurus,
>I downloaded and installed MySql successfully, on a Windows 2000 O/S. I
>want to locate the "my-example.cnf" file, copy it to my root directory and
>rename it "my.cnf". However, the "my-example.cnf" file I locate is a
>shortcut, p
Hi,
I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
I try to run it to finish installation and set up users, i get the
following error:
/usr/local/mysql# mysql start
su: mysql: command not found
I have also tried running MySQL with the mysqld start, mysqld, and mysql
c
Prefix it with the path:
/usr/local/mysql/mysqld start
or whatever.
On Friday 15 February 2002 3:16 pm, Mark M Jervis Jr. wrote:
> Hi,
>I am trying to install run MySQL version 3.23.43-pc-linux-gnu-i686. When
> I try to run it to finish installation and set up users, i get the
> following er
* Miretsky, Anya
> Select distinct
> biblio.* from biblio left join keyword on
> biblio.p_biblio=keyword.fk_biblio
> where keyword="SOMESTRING";
Try swapping the tables:
Select distinct
biblio.* from keyword left join biblio on
biblio.p_biblio=keyword.fk_biblio
where keyword="SOMESTRING";
The l
Hi there,
I'm having som difficulties trying to figure out MySQL's unique indexes
and primary keys.
Case:
mysql> create table flaf (lala varchar(20) not null, unique(lala));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into flaf VALUES ('hest');
Query OK, 1 row affected (0.00 sec)
my
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: pengzhao
To: [EMAIL PROTECTED]
Subject: Msql-Mysql-modules-1.2219 fails in the test, on Itanium machine
>Description:
Hi List,
I am new to the MySql C++ API and I am compiling one file it gives me error
saying
Error E2303 ..\..\include\sqlplus\resiter1.hh 56: Type name expected
Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected
Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected
and many war
George/Rick, a quick addition.
It is not clear from the question: do you want to have the timestamp updated, or do
you want to leave it be?
RTFM:
6.2.2.2 The DATETIME, DATE, and TIMESTAMP Types
...
The TIMESTAMP column type provides a type that you can use to automatically mark
INSERT or UPDAT
On Tuesday 12 February 2002 09:23 pm, you wrote:
> Sasha,
>
> I compressed it first, 'cause it was nearly 400MB in size. It's on
> the FTP site as mysqld.core.bz2.
Jeremy - in case you are wondering why it is taking me so long to reply -
we've made a mess on our Linux build machine before the
I see people speaking about mysql 4.0.2... but where you get it? they write
some thing about it on web page but 4.0.2 is not in the download list...
maybe someone can say if mysql 4 is stable? I mean if I can use it without
100 crash in 1 hour :)
Sorry for bad english :)
Jean-Francois Dionne
---
On Fri, Feb 15, 2002 at 08:03:19PM -0500, Jean-Francois Dionne wrote:
> I see people speaking about mysql 4.0.2... but where you get it?
> they write some thing about it on web page but 4.0.2 is not in the
> download list...
It's from the MySQL source tree. See this url:
http://www.mysql.com
So it's better using 4.0.1 of 4.0.2?
Jean-Francois Dionne
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jean-Francois Dionne" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 15, 2002 8:12 PM
Subject: Re: information on mysql 4.0.2
> On Fri, Feb
Hi,
No problem so far with mysql 4.0.x, no crash at all on a production server
with a really high load.
If you want to use mysql 4.0.2, take a look here :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Je
Hi Andreas,
On Sat, 2002-02-16 at 08:52, Andreas Frøsting wrote:
> Why does MySQL have this strange behavoir, treating unique indexes
> case-insensitive?
> Can anyone explain MySQL's behaviour and how I do a workaround making
> unique indexes and primary keys case sensitive?
> I've been over the
Wouldn't replace change all the entries in your table row, same effect as update?
I believe the question is how to test which entry in a form has a new value and
replace/update only that value in the table.
If I have a form...
__
|Employee Record Update|
|
1 - 100 of 115 matches
Mail list logo
