Hi Peter,
The collumn is a datatime... You are tight that date probably should be is a
reserved word..
I must say that I never had any troubles with it, I started using it when I
was a newbie with PHP about a year ago...
On almost all my tables I always have an auto-increment column with the name
OK.i FIND i make a mistake in edit the PATH ,now it can find ar
now i can run mysql in my box,but i still get errors in make
i compile mysql as below:
1.CC=gcc CFLAGS="-O6" CXX=gcc
CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=/usr/local/mysql --with-mysqld-us
did you read the bottom of your own eMail? there's a link to unsubscribe appended
to every mail on this list!
-kg
alain siani wrote:
> I would like to unsubscribe of this list!!! Help me please !
>
> My address : [EMAIL PROTECTED]
>
> --
> Alain Siani
> (query,mysql)
>
> --
I would like to unsubscribe of this list!!! Help me please !
My address : [EMAIL PROTECTED]
--
Alain Siani
(query,mysql)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
Did anybody succeed in compiling MySQL and Berkeley DB on a Slackware
7.x system and not get a SIGSEGV?
Please let me know how you did it.
Thank you.
=
ing. Andrei Boros
Centrul pt. Tehnologia Informatiei
Societatea Romana de Radiodifuziune
Usually it is not in the folders that are listed below. It is in one of
the server's folder that you don't usually have access to view.
Since you have only ftp you need to install phpMyAdmin from phpMyAdmin.net
on your server, htdocs.
Export your database using mysqldump dbname > somename.sql
I don't think I can help you with your XWindows problem, plus this is the
wrong list for it. However, one word of advice. You may find it less
troublesome if you download the latest version from the mysql site or one of
its mirrors rather than using a packaged installation.
- Original Messa
Hi,
I have SuSE 7.0 running on a my machine. When i tried to install MySQL
3.23.32 from SuSE 7.1 CD, my XWindows stopped working. Infact SuSE 7.0 CD
comes with MySQL 3.23.10. Could somebody help me out with the problem??
Regards,
Ganesh
--
i have granted the correct privileges to the slave machine on the
master. like i said before it doesnt really come to that stage. had it come
to that stage, it would have said something like Access Denied if the
privileges were not proper.
The 2 machines are able to ping each
Hi,
It is my first time using MySQL on Unix system, and my
first time sending email to the mailing list. If the
question I am asking has been asked before - I am
sorry, I have just subscribed to MySQL mailing list.
;-)
Here is my question.
I have MySQL Server successfully installed on HP-UX
11
Hi,
It is my first time using MySQL on Unix system, and my
first time sending email to the mailing list. If the
question I am asking has been asked before - I am
sorry, I have just subscribed to MySQL mailing list.
;-)
Here is my question.
I have MySQL Server successfully installed on HP-UX
11
Hello all,
Does anyone know:
1. what the disadvantages/advantages are in building a static binary (EXCEPT for the
extra space)
2. read somewhere that turning of the swap could improve performance. Anyone can
testify for or against that?
3. is there a potential impact in performance when running
Is there a particular reason that you are planning to shut it down? Lack
of interest in maintaining it? Hosting cost? Lack of traffic?
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http
On Tuesday 10 April 2001 10:55, Sasha Pachev wrote:
> Scott:
>
> See my comments below regarding the replication bug you have reported.
>
> error from log file:
> 010410 15:18:20 Slave: connected to master 'navrep@hsNavYkfPrd4:3306',
> replication started in log 'hsNavYkfPrd4-bin.060' at positi
Sorry it should have been fi instead of if
in rc.local add
if [-x /path/to/mysqld]; then
echo "MySQL started"
/path/to/mysqld start
fi
DT
- Original Message -
From: "Deependra B. Tandukar" <[EMAIL PROTECTED]>
To: "Brian Warn" <[EMAIL PROTECTED]>; "Ngu Nguyen" <[EMAIL PROTECTED]>
Cc:
I have a mini-HOWTO on my user site that I follow verbatim to have successful
compiles everytime. This PATH should also be used below.
< http://users.talstar.com/forager/MySQL-HOWTO.html >
On 10-Apr-01, System Admin. said something totally profound about Re: 3.23.36 in
solaris8 x86 that made m
Hi all,
I have had this website that captures the list email messages and placed it into a
searchable db. I did this as a learning exercise and think it is pretty cool but am
wondering if I should just shut em down.
Take a look and if I get enough feedback, I will keep them running for at le
Dear Ngu,
in rc.local add
if [-x /path/to/mysqld]; then
echo "MySQL started"
/path/to/mysqld start
if
Warm Regards,
Deependra B. Tandukar
www.coremag.net/cvs/dt.htm
Training and Networking Assistant
ICOD/ICIMOD
www.icimod.org
Co-ordinator
CORExpress
The Only Native Computer Magazine of Nepal
w
Hi,
Make sure all these path is in your path environment:
/usr/local/bin /usr/local/sbin /usr/sbin /usr/bin /usr/ccs/bin /usr/ucb
this shpuld do it. Make sure that you run configure first before you run
make.
HTH
Pe'
*--*
Syste
- Original Message -
From: "System Admin." <[EMAIL PROTECTED]>
To: "Àä·ç" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 9:31 AM
Subject: Re: 3.23.36 in solaris8 x86
Hi,
Did you get the pre-compiled gcc?. It will tells you that it cross
compiled. So, what you can do is download gcc
k, I followed the instuctions on the MySQL page, downloaded
mysql-3.23.36-pc-linux-gnu-i686.tar.gz for redhat linux and then followed
the install directions:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell
um...what?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 12:29 PM
To: [EMAIL PROTECTED]
Subject: installation problem with Linux
>Description:
sadsa
>How-To-Repeat:
sasa
>Fix:
none
>Submitter-Id:
>Originator:
- Original Message -
From: "Àä·ç" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 10:26 AM
Subject: 3.23.36 in solaris8 x86
> I Want to Install mysql in solaris8 intel x86
> but i can't pass configure,i have installed gcc ,glibc ,automake ,autoconf
> [root@sola
Absolutely! There are a couple of ways to handle the interface (we use
MyODBC) ... suggest you search the archive or check out the other API's at
http://www.mysql.com/downloads/index.html
Gerald Jensen
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday,
I have just installed version 3.23.36 on an Intel running windows 2000
Pro.
I am trying to use MS Access as a front end but can not get a connect
string to recognize the mysqld server.
My event viewer is showning me the following problems at startup.
value named MaxMpxCT inthe servers registry
>Description:
sadsa
>How-To-Repeat:
sasa
>Fix:
none
>Submitter-Id:
>Originator:Richard McMahon
>Organization: Institute of Astronomy, University of Cambridge
>MySQL support: [none | licence | email support | extended email support ]
none
>Synopsis:
installation probl
Duh, ignore this message; I had my head misthreaded when I screwed it
on this morning.
Date: 10 Apr 2001 17:01:48 -0700
From: Rusty Wright <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: only 1 entry per user in user table?
Also n
What I want is there to just be 1 password entry for each user,
ignoring the host. As it is now the password is tied to both the user
and host. I would also like to be able to globally specify the hosts
that can connect to the server, ignoring the user, password, and
databases.
Also note that they could use this to do a brute-force search for the
root user's password. E.g., mysql -p -u root -h hishost (or the
equivalent in a c, perl, etc. program).
Date: 10 Apr 2001 16:57:41 -0700
From: Rusty Wright <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
CC: [EMAIL PROTE
If you mean use % for the host in the user table, that has the
negative consequence that they can connect to the mysql server from
any machine on the internet; e.g. they can do
mysql -p -u dentry -h hishost
Since they're not specifying a databse they can get this basic
connection to the
Did you try using % for the host instead?
> I'm trying to set it up so that I have only 1 entry per user in my
> mysql user table. My users will have the same privileges regardless
> of what host they come in from. There's only 1 database they'll be
> working with. There are 2 users, user "d
"Erik Kabo" <[EMAIL PROTECTED]> wrote:
> I installed MySQL version 3.23 in RedHat 7.0 using gnorpm. After I
installed
> it, the server appears to be working fine, but there is no client
software.
> I try running "mysql" at the command prompt, but I get a command not found
> error.
Did you enter t
I'm trying to set it up so that I have only 1 entry per user in my
mysql user table. My users will have the same privileges regardless
of what host they come in from. There's only 1 database they'll be
working with. There are 2 users, user "dentry" can add and edit
information in the database n
On Tue, Apr 10, 2001 at 06:37:17PM -0400, Erik Kabo wrote:
> Hi,
>
> I installed MySQL version 3.23 in RedHat 7.0 using gnorpm. After I installed
> it, the server appears to be working fine, but there is no client software.
> I try running "mysql" at the command prompt, but I get a command not fo
(embarasing subject line typo fixed)
On Tue, 10 Apr 2001, Michael Widenius wrote:
>
> Hi!
>
> > "Stephen" == Stephen Beynon <[EMAIL PROTECTED]> writes:
>
[snip]
>
> >> [EMAIL PROTECTED] writes:
> >> > >Description:
> >> > When transfering a database application to use an Alpha Linux ser
k, I followed the instuctions on the MySQL page, downloaded
mysql-3.23.36-pc-linux-gnu-i686.tar.gz for redhat linux and then followed
the install directions:
shell> groupadd mysql
shell> useradd -g mysql mysql
shell> cd /usr/local
shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf -
shell
I saw that MySQL now includes BDB in the source tree.
When will be released a binary package with BDB and transactions support
already compiled? I'm interested in the Linux, Irix and Windows
versions.
--
Florin Andrei
-
Befor
Hi,
I installed MySQL version 3.23 in RedHat 7.0 using gnorpm. After I installed
it, the server appears to be working fine, but there is no client software.
I try running "mysql" at the command prompt, but I get a command not found
error. I tried the GUI on your download page, but it just stalls
OR, you can do what I usually do, and create a 'symbolic' link from
"/usr/local/bin" to programs 'outside' of your path, that you feel are safe to
run 'automatically' (i.e. "cd /usr/local/bin; ln -s
/usr/local/mysql/bin/mysql ")
Brian Warn wrote:
> Make sure in (solaris + ksh) /etc/profile o
Sorry, I figured it out... I need to create a FULLTEXT index on the
columns I want to search, then I have the "match" those columns in the
query.
:-)
I'm having problems working with MATCH (a, b) AGAINST ('something').
My database log files are expanding very quickly - and when I look at them,
they are logging all of the select statements, not just the delete, insert,
update, etc. statements.
How do I specify for the logfiles to only log "update" statements and not
the selects?
Thanks,
Kim Albee
--
Dear Y'all -
Well, I'm pretty giddy having just gotten my linux box to successfully
communicate with M$ SQL Server on a remote NT machine. As promised,
in gratitude for earlier help from list members I've written this
e-mail outlining how I got it to work.
The real trick was to follow the inst
I'm having problems working with MATCH (a, b) AGAINST ('something')...
my query is:
SELECT name, MATCH (summary, description) AGAINST ('New York') AS
relevant_num FROM people;
I get the error message:
ERROR 1191: Can't find FULLTEXT index matching the column list
When I show index on the ta
mysql sql db
I am unable to get replication running. I have set up both master and slave
systems with version 3.23.33-log of musql. I can do a "load table from
master" but when I start the slave, all I get in the slave log is:
010410 16:37:24 Slave: Failed reading log event, reconnecting to r
Hi,
I was wondering how I can run mysql commands without typing "/usr/local/mysql/bin/" up
front. E.g. Just "mysql --user=... --host=... -p .." instead of
"/usr/local/mysql/bin/mysql --user=... --host=... -p .."
Thanks,
Ngu
Hi Gerald,
I installed ldconfig, and then zlib. Now went back to install DBD and get
the following when running make test (looks similar to original problem):
[root@clx Msql-Mysql-modules-1.2210]# make test
make[1]: Entering directory `/perlmods/Msql-Mysql-modules-1.2210/mysql'
make[1]: Leavin
Make sure in (solaris + ksh) /etc/profile or $HOME/.profile that
/usr/local/mysql/bin is in the path for the user under which you run mysql:
e.g.
PATH=/usr/bin:/usr/local/bin:/usr/local/mysql/bin
-Brian
- Original Message -
From: "Ngu Nguyen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
On Tue, Apr 10, 2001 at 01:05:34PM -0700, Ngu Nguyen wrote:
> Hi,
>
> I was wondering how I can run mysql commands without typing "/usr/local/mysql/bin/"
>up front. E.g. Just "mysql --user=... --host=... -p .." instead of
>"/usr/local/mysql/bin/mysql --user=... --host=... -p .."
Add
There are quite a few hits here:
http://freshmeat.net/search/?q=inventory
Regards,
Gary "SuperID" Huntress
===
FreeSQL.org offering free database hosting to developers
Visit http://www.freesql.org
-Original Message-
From: Sanborn, Ed [
Ok, this is confusing me. Under FreeBSD 4.2 and MySQL 3.23.36-debug:
The mysqld process is not running as root, but as 'mysqld:mysqld'.
bmdb2# ps -orgid,ruid,command -eww -p 46884
RGID RUID COMMAND
6724 6724 MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld/db/mojo
log_dir=/var/mysqld/log TMPD
Does anyone out there have a good inventory solution?
I'm in search of a web-based inventory database that will be used by
our internal IS department. Utilizing MySQL, Perl and/or PHP I'm
trying to build a database that will allow us to track our IT equipment.
I'd like the following features:
W
Make sure it is executable.
Ngu Nguyen wrote:
>
> Hi,
>
> I just finished installing mysql, but the only way I can start mysql is using
>"./configure" or "./bin/safe_mysqld". In the documentation it tells me to use
>"mysql.server start" but this command doesn't work. I was wondering if any
\ is an escape character in MYSQL. Use two \\ to insert a single \
- Original Message -
From: "Jack A. Tinsley Jr." <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Monday, April 09, 2001 12:34 AM
Subject: Disappearing "\"
> First, things, first - I am a newbie to My
Ngu Nguyen wrote:
> Hi,
>
> I just finished installing mysql, but the only way I can start mysql is using
>"./configure" or "./bin/safe_mysqld". In the documentation it tells me to use
>"mysql.server start" but this command doesn't work. I was wondering if anyone could
>tell me what I am doi
there is not a MySQLGui for mac, at least not one that comes from Mysql.com
there is a program called MacSQL Monitor from runtime labs though
www.runtimelabs.com
it is pretty good.
I don't know if myodbc compiles on OS X or not, but definitely not on os 9
and lower
On 4/10/01 11:22 AM, "Webmas
Hi!
I am currently building a web site for Sciences-Espace. We work on
macintosh computers. I found a version of MySQL for mac but not the
MySQLGui (the API), or MyODBC. Please tell if a version for mac exists
and how I can get it.
Sincerely,
SCRIPT
--
I am using Virtual Bulletin Board on a win2k box (not by choice) and ever since I
moved the forum over, the mysqld-nt.exe crashes every 5 minutes. Is this semi common
among win2k? is there something I can do? I am running 3.23.34
Kode
Hi!
> "Stephen" == Stephen Beynon <[EMAIL PROTECTED]> writes:
Stephen> On Mon, 9 Apr 2001, Sinisa Milivojevic wrote:
Stephen> The problem still exists on gcc 2.95.3 (I was part way through installing
Stephen> this when I recieved your mail - I can try 2.95.2 if you think that would
Stephen>
Scott:
See my comments below regarding the replication bug you have reported.
error from log file:
010410 15:18:20 Slave: connected to master 'navrep@hsNavYkfPrd4:3306',
replication started in log 'hsNavYkfPrd4-bin.060' at position 14290269
ERROR: 1064 You have an error in your SQL syntax near
I followed the instructions at the top of the mysql.server file and it works
great for me:
# Copyright Abandoned 1996 TCX DataKonsult AB & Monty Program KB & Detron HB
# This file is public domain and comes with NO WARRANTY of any kind
# Mysql daemon start/stop script.
# Usually this is put in
Hi,
I just finished installing mysql, but the only way I can start mysql is using
"./configure" or "./bin/safe_mysqld". In the documentation it tells me to use
"mysql.server start" but this command doesn't work. I was wondering if anyone could
tell me what I am doing wrong.
I am also wonder
I have a very simple MySQL and web project. I need to get in contact with some MYSQL
and web developers.
The requirements for the project can be found at www.diary.intranets.com. You will
need to enter as a guest and view the documents section. 'Requirements.doc'
Thanks in advance,
Roger.
-
Hi All,
I have installed PHPTriad V1.0 on my Win98 and it is about the best
programme I have ever used. What I need to know is, when I have created my
site and upload it to my ISP's server (Linux / FreeBSD / MySQL + PHP 4) are
there any pitfalls or code differences I should be aware of?
Kinde
Although I don't think that I have my replicating servers misconfigured,
here is the scenario of what seems to cause replication to crash:
Replication working fine, all servers updating and all have the same
data.
All servers running 3.23.36 binary RPMs from mysql.com
**hsNavYkfPrd4**
[my
You are using MyISAM tables which do not support transactions. You need to
convert your table to either BDB or INNOBASE type in order to use
transactions. All the info is in the manual..
John Barton
Unix Systems Administrator
Primary Networks, Inc.
[EMAIL PROTECTED]
On Tue, 10 Apr 2001, Bruno Ro
On Tue, 10 Apr 2001, Peter Pentchev wrote:
> First, get a book on SQL. Read about joins in SELECT statements.
>
> Then, if you still need a quick answer, try the following:
>
> INSERT INTO table_c(name, score)
> SELECT name, a.score - b.score
> FROM table_a a
> LEFT JOIN table_b b ON b.name =
**READ THE MANUAL BEFORE POSTING TO THE LIST**
http://www.mysql.com/docs
On Tue, 10 Apr 2001, Bruno Roselli wrote:
> Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?
>
> mysql> BEGIN;
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> UPDATE tabgral set codigo=2 where cod
Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ?
mysql> BEGIN;
Query OK, 0 rows affected (0.00 sec)
mysql> UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> ROLLBACK;
ERROR 1196: Warn
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: make fails with compile error using MacOS X Darwin
>Description:
make gives:
mysqld.cc: In function `void init_signals()':
mysqld.cc:1241: assignment to `void (*)(int)' from `void (*)()'
make[3]: *** [mysqld.o] Error 1
make[2]: *** [all-recur
Hi,
This doesn't make any sense to me... For some reason, dropping an index is
causing an error 1062. I would think this would only occur when creating an
index or inserting an item...
---
mysql> show index from user;
+---++--+--+-+---+-
On Tue, Apr 10, 2001 at 12:37:10PM +0300, Yusuf Incekara wrote:
>
> does mysql binary win32 dist support innobase and bdb tables. if
> yes how ? if not when will you implement?
I don't think Innobase is availabe on Windows yet.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo
If your using "R"edhat, use "R"pm. Otherwise, use the tarball.
David Loszewski wrote:
>
> is it recommended to install mysql by rpm or tar?
>
> dave
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php
On Tue, Apr 10, 2001 at 02:25:44PM +0300, Sinisa Milivojevic wrote:
>
> Can anyone of you guys come with a repeatable test case that will
> always lead to the situation as described. Then we could try to fix
> it.
I produced one about 9 months ago and gave it to Tim Smith. Had to
send him a CD-R
mysqladmin variables
and check the results against the candidates.
The config files should be searched for in the order listed in the
manual.
If the right one is not being read, the mysql user probably does not
have
read privileges on that file.
Martin Bringe wrote:
>
> How can I check at run
Check with your ISP.
You need shell access.
ashok wrote:
>
> hi,
>
> sir,we have to upload mysql database on our website,the isp people has enable mysql
>for our websites,now we wanted to upload or export the mysql table,
> please give us the suggetion where to upload the tables and how odbc h
I'm getting strange results that I think can be
explained by having an index that isn't set up right.
CREATE TABLE URL_POLICY (
url_id INTEGER NOT NULL,
policy_idINTEGER NOT NULL,
policy_order INTEGER NULL,
PRIMARY KEY (url_id, policy_id)
) TYPE=BDB;
INSERT INTO testtbl va
Anoop k gupta wrote:
How did you try to connect?
Did you telnet in and connect from the server?
Did you try to connect remotely?
What commands did you try? ( disguise your user and password in the
example )
What is the EXACT error message you got?
>
> Thanks.
>
> Now my hosting company provid
Hi there
If you set the IP in mysql DB to localhost can you log on then with the
right password and user name..?
If you can the try changing it back.
I always for get to flush my tables.!
Simon
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: 10 April 2001 14
Have your script delete it first.
Niklas Rudemo wrote:
>
> Maybe I didn't state the problem clearly enough.
> I want write to a file that does exist,
> i.e., overwrite the existing file.
>
> -Original Message-
> From: Paul DuBois [mailto:[EMAIL PROTECTED]]
> Sent: den 9 april 2001 17:01
Maybe the is no such file or directory.
Or maybe you are not root when you execute the command.
Did you check that the directory exists?
Maybe this binary version puts it somewhere else.
try :
find / -name mysql -print
and see where it might be installed.
[EMAIL PROTECTED] wrote:
>
> i typed
Hi!
We are working on a binary release of MySQL -MAX with BDB and
Innobase. At least on Linux and Win NT.
I would not be surprised if it comes this week, though
I am not responsible for building it :).
Regards,
Heikki Tuuri
Innobase Oy
You granted the proper priveleges for the slave machine on the master as
specified in
the instructions?
You can ping each way?
You have the master and slave port numbers set the same?
They are both running the latest version?
Running out of ideas.
MCA Department PESIT wrote:
>
> Hi,
>i h
Hi,
I ported to MySQL a database that has BINARY(n) columns. MySQL
silently changed them to VARCHAR(n) BINARY.
And now the ResultSetMetaData.getColumnType() returns type 12=VARCHAR.
Can I in some way access the attribute BINARY?!
Valentin
this is a stupid robot :)
my message was not off topic
- Original Message -
From: <[EMAIL PROTECTED]>
To: Avukatpro Limited Sirketi <[EMAIL PROTECTED]>
Sent: Tuesday, April 10, 2001 12:09 AM
Subject: Re: About BDB and INNOBASE
> Your message cannot be posted because it appears to be eit
Or insert a record, get the lastinsertid, and delete the record. Keeps
the file small
and guarantees a unique number every time.
Cal Evans wrote:
>
> Make a table in your database called ID
>
> Create table ID (ID bigint auto_increment not null,
> lockedBy varchar(10) null};
And if they don't read the manual, how do they know which table types
they will need?
Nobody who has not read the manual should expect to be able to post
without
geting a reminder to RTFM.
He obviously did not read about how to properly post a problem.
He asked if MySql supports transactions.
Are
Hi!
People are reporting performance problems also from the FreeBSD port of
Innobase. There seems to be a runaway thread which gets free sometimes
and eats up 100 % of the CPU. It was not fixed with the latest patches to
Innobase.
I will try setting thread priorities in 3.23.37. That might help,
>I have a primary key listed as ID
>
>When I first added about 10 records and then deleted a few records and
>then added more records it didn't replace the missing records.
>
>When I select all records to view I now get:
>
>1
>2 why didn't it go to 3, 4 and 5 after 2?
>6
>7
>8
>
>
>
>When I add a
Hi everybody!
We are running Mysql on Linux. With a large database (aprox 25 mil rows in
diffrent tables).
We can't run joins because they lock the tables, so we have to write a
script in c++ that takes out rows from one table and then take data from
another table (a sort of fake-join).
We also
Lawrence S. Stephens III writes:
> I am trying to compile mysqlgui-1.7.4. My g++ compiler is version
> -- gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release). I am running
> Linux 2.4.1 and KDE 2.1. I got the following error message, please help.
>
> ---
Johan Andersson writes:
> I've had the same problem on an Intel P-III 800 w 256M RAM running FreeBSD
>4.1-RELEASE with
> both the distribution from the ports tree and the source dist. from mysql.com.
>
> I tried to solve the problem with analysing all the database traffic, but mysql were
>takin
Hello,
I am wondering if there is a site that attempts to count or estimate the number of
Internet servers that use mySQL. Do you happen to know if there is a mySQL equivalent
to www.netcraft.com/survey (which attempts to count Apache servers)? If anyone knows
of a resource that might be rele
Suppose you buy a book and learn how to do it.. rather than asking others
to solve your problem.
You've got MySQL and PHP.. so you should be able to do it..
Bye,
B.
>I am using MySQL in RedHat 6.2 with PHP 4.0. I have a question on MySQL.
>Suppose I have two tables A and B in my database:
>The username used if not specified in the mysql command, is your *nix
>username, so for instance, if I'm logged in as benji and type:
>
>mysql -p
> **
>
>The mysql username is also benji.
I would NOT consider it a good idea to use the same username for a shell
account and a mysql account..
On Tue, Apr 10, 2001 at 12:48:26PM +0200, Guerin Damien wrote:
> Hi,
>
> How use CHECK constraint in a CREATE TABLE declaration ??
> The language used is MySQL
> Indeed, i try many attempt but no success... Somebody could help me ??
>
> I try to do that :
>
> create table Picsou (
> nam
How can I check at runtime, wich config-file is used by mysqld? We are using
mysql 3.23.36 under Linux.
Thanks
Martin
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
hi,
sir,we have to upload mysql database on our website,the isp people has enable mysql
for our websites,now we wanted to upload or export the mysql table,
please give us the suggetion where to upload the tables and how odbc has to be enable,
when we are connecting to our site through ftp we ar
First, get a book on SQL. Read about joins in SELECT statements.
Then, if you still need a quick answer, try the following:
INSERT INTO table_c(name, score)
SELECT name, a.score - b.score
FROM table_a a
LEFT JOIN table_b b ON b.name = a.name;
Hope that helps.
G'luck,
Peter
--
No language ca
Hi,
How use CHECK constraint in a CREATE TABLE declaration ??
The language used is MySQL
Indeed, i try many attempt but no success... Somebody could help me ??
I try to do that :
create table Picsou (
name varchar(5)
check (name=='fifi' or name=='riri' or name=='loulou')
)
;
Bu
--- [EMAIL PROTECTED] wrote:
> 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 your message:
>
> database,sql,query
>
> If you just reply to this message, and includ
1 - 100 of 123 matches
Mail list logo
