PEBCAK:
I found two self-referencing symbolic links in /usr/lib. I don't
know how they got there, but removing them let the compile
continue.
Thanks all who tried to help me.
--
fil krohnengold
network systems administrator
american museum of natural history
[EMAIL PROTECTED]
MySQL's Documentation:
A name may start with any character that is legal in a name. In particular,
a name may start with a number (this differs from many other database
systems!). However, a name cannot consist only of numbers.
MyQuestion:
Why can't a column name be just a number?
For example:
What would
SELECT 42 FROM SOME_TABLE
return? column name 42 or the numerical value 42 ?
M
-Original Message-
From: Sparta Cruz [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 08:23
To: MySQL
Subject: Column Names
MySQL's Documentation:
A name may start with any character that
I'll try posting this again, because nobody has replied to it.
To put the problem more succinctly: I think there is a flaw in the mysql
LOCK statement semantics, because if I use LOCK then all tables that are
accessed while the LOCK is active must be locked for READ or WRITE
access (or insert,
I have datetime and I want to add a number or seconds to it. That number can
be greater than 60, it can actually be greater than the equivalent of a years
in seconds.
How do I add these seconds to the value of a datetime field through an update
with MySQL?
Hello,
Can anybody here help me.
I have a MySQL server running on Linux to which I wish to connect from a
machine running NT. This is fine normally using
MyODBC.
However the following scenario does not work.
The DSN is a file DSN on another NT box and is accessed using UNC e.g.
I see that PREPARE is on a TODO list for MYSQL. Does anyone know
if or when it might be available (or if it is high priority).
I'm having to parse SQL statements myself to extract column and table names
and then match columns to tables to get column information. PREPARE would
mean that MYSQL
Why don't you forget about the automated subscription service and use the
phone or email to get the money in. Once you have your 5-10+ subscriptions
up and running then you can upgrade properly and then get your shopping cart
or whatever.
Presumably you'll also want to use a different
* Kodrik
I have datetime and I want to add a number or seconds to it. That
number can be greater than 60, it can actually be greater than the
equivalent of a years in seconds.
How do I add these seconds to the value of a datetime field
through an update with MySQL?
update table set
Hi,
The better way of storage is to normalize it.
Hope this way it will help you out.
SQL DESC EVENTS
Name Null?Type
-
EVENTID
You are using InnoDB or MyISAM???
If u r going for InnoDB,
Refer to InnoDB Engine manual for the version 3.23.47 at www.innodb.com.
Here you details of different LOCK types.
You can select the appropriate lock type at row level for different
possibilities.
Hope this works!!
Cheers :)
Rama
Hello,
I cannot guarantee somehow an individual user the whole computing time
used up.
Have mysql anything prozess accounting?
Or other restrictions of CPU Time - User account?
The problem is:
one user had 100 (and more) prozesses to run, an other user starts queries
and he can get no more
On Monday 07 January 2002 01:13 am, Roger Baklund wrote:
* Kodrik
I have datetime and I want to add a number or seconds to it. That
number can be greater than 60, it can actually be greater than the
equivalent of a years in seconds.
How do I add these seconds to the value of a
You can set MySQL questions to low priority if this Is what you need but you
would have to ask the user to do this.
As MySQL is so fast and can run 1000 threads plus your user should not slow
any thing down.
The other thing to look at is run a copy of MySQL for each user!
Hope this helps
Simon
Hi,
I'm using INSERT DELAYED to insert about 120GB of data into mysql from mysqldumpped
data from remote server. After the weekend I've found such output from our perl script
(after was dumped let's say 60GB):
Just dumping Mthermoautotrophicum.orf
Just dumping Mthermoautotrophicum.orf_data
Newbee! Loaded binaries (not RPM or Package) on RH Linux7.2. How to start
the MySQL server manually and how to configure it (ie port on which it is
running). Not finding the proper documentation page on www.mysql.com.
-
Before
HI!!!
I am trying to execute the following query, in which i
am tring to insert data from the table testtable into
the same table testtable.
insert into testtable(col1,col2) select col1.col2 from
testtable;
This query does not execute and generatethe following
error:-
Not Unique table/alias:
Start by /usr/local/mysql/bin/safe_mysqld --user=mysql
after scripts/mysql_install_db of cores
to configure (port etc.) edit /etc/my.cnf
Simon
-Original Message-
From: R.C.Nougain [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 10:03
To: [EMAIL PROTECTED]
Subject: How to start the
You cold use temp tables?
Simon
-Original Message-
From: amit lonkar [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 10:08
To: [EMAIL PROTECTED]
Subject: URGENT
HI!!!
I am trying to execute the following query, in which i
am tring to insert data from the table testtable into
the
I have sql commands written in a file. How to run this file at sql prompt
so that commands executed thru this batch file. Something similar to Oracles
sql @/mydir/mysql.sql
-
Before posting, please check:
In the script file add the first statement as 'use db_name;'
Mysql/binmysql file_name.sql
Thanks,
Rama Raju
-Original Message-
From: D Bamud [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 4:01 PM
To: [EMAIL PROTECTED]
Subject: How to run commands written in a file
I have
* D Bamud
I have sql commands written in a file. How to run this file at sql prompt
so that commands executed thru this batch file. Something similar
to Oracles
sql @/mydir/mysql.sql
mysql source myfile.sql
or
mysql \. myfile.sql
--
Roger
Hello,
Can anybody here help me.
I have a MySQL server running on Linux to which I wish to connect from a
machine running NT. This is fine normally using
MyODBC.
However the following scenario does not work.
The DSN is a file DSN on another NT box and is accessed using UNC e.g.
Hi,
I have written the following code using C-API and would like to retrieve
the info from MYSQL.
But it gives me error messages. Please let me know where iam going
wrong.
the code and error messages are :
#include stdio.h
#include mysql/mysql.h
main()
{
int sel;
MYSQL
Description:
When WHERE clause contains OR mysql don't any keys and don't perorm
validity check even.
USE KEY directive does not change this.
How-To-Repeat:
create table t (
a int unsigned,
b int unsigned,
key(a),
key(b));
insert about 2000 random rows
select count(*) from t;
2048
1.
I can report a major crash, when entering passwords and mail it to the
list as written in the file mysqlbug.
If you are interested please read the following lines and the .crash.log
(perhaps you can give me a hint what could have been wrong):
I am working with an Apple PowerBook G3 with MacOS
Prabhu,
4.0.x is the development version. 3.23.xx is better tested. But 4.0.1 looks
good now that it has been out a couple of weeks. Upgrading to 4.0.1 is
another possibility.
Regards,
Heikki Tuuri
Innobase Oy
---
MySQL/InnoDB - transactions, row level locking, and foreign key support for
Hi
Is it possible auto_increment start 100 instead of 1 .
for example
create table a
( a int(10) primary key auto_increment 100);
Manish Mehta
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
Manish,
If you manually insert a record with a value of 100 in the auto_increment
field, then it will work from then on.
If there is a way to create the table telling the value to start at 100,
then I don't know what it is.
Hope this is a help
John Lodge
-Original Message-
From:
hi.
yes it is possible.
1. Create an new column which has an auto_increment option
2. Insert the first dataset manually as followed:
INSERT INTO test (auto, char) VALUES ('100', 'Hello World!')
3. From there on your auto column will count starting from 100, 101, 102,
...
Greeting
-
I just installed mysql under my new linux system.
I did a test command of
./mysqladmin -u root password new-password
thus setting the root users password to new-password
this appeared to work.
I now want to change the root users password now that I have the syntax
correct.
I do a
Which is the **best, easy, compact** book available on MySQL. Delhi India.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
I would need those to finish the on-line help in my mystatus and myvars
moodss modules for the 4.0.1 server.
Please let me know if this is not the right place to post this.
in SHOW STATUS:
Com_ha_close
Com_ha_open
Com_ha_read
Com_show_binlogs
Qcache_queries_in_cache
Qcache_inserts
Qcache_hits
Hello,
I have corrected the code as I would have written it. Also are you sure the
file mysql.h
is where you think it is?
#include stdio.h
#include mysql/mysql.h
main()
{
int sel;
MYSQL mysql=NULL;
MYSQL *connection;
MYSQL_RES *result;
mysql_init(mysql);
MySQL by Paul DuBois
www.newriders.com
ISBN 0-7357-0921-1
This book is easy to use.
It gets it right when it commes to newuser V olduser.
Its not that compact but it is to the pont.
Simon
PS you also helps on the list some times..
-Original Message-
From: D Bamud [mailto:[EMAIL
Hi,
my laptop is running windows 2000 and is called jaguar.
I have mysql running on a linux server called jordan.
when I fire up mysqlui and tell it to connec to jordan as root I get
prompted for a password. I enter the password (that I have tested and is
correct) and it say at the bottom of
Hi,
the manual referes to creating users using mysqladmin and mysqlaccess, I
have looked at these commands and cannot see how I can create mysql users.
Am I missing something that is staring me in the face ?
Thanks,
Matt.
(slowing getting the hang of what is going on now)
Hi,
[..]
produces the following error messages.
/tmp/ccPhnnJk.o: In function `main':
/tmp/ccPhnnJk.o(.text+0x14): undefined reference to `mysql_init'
/tmp/ccPhnnJk.o(.text+0x5a): undefined reference to `mysql_real_connect'
/tmp/ccPhnnJk.o(.text+0x6d): undefined reference to `mysql_query'
MySql mSQL O'Reilly press isbn 1-56592-434-7
-Original Message-
From: D Bamud [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 1:04 PM
To: [EMAIL PROTECTED]
Subject: MySQL Book
Which is the **best, easy, compact** book available on MySQL. Delhi India.
look for 'GRANT SYNTAX' in the manual.
Regards
M
-Original Message-
From: Matthew Darcy [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 13:16
To: MySql List
Subject: creating users ??? I must be blind.
Hi,
the manual referes to creating users using mysqladmin and mysqlaccess, I
Initially you will have had no password, so
setting root's password to 'test1' would be done with:
mysqladmin -u root password test1
To change this password to test2 use:
mysqladmin -u root -ptest1 password test2
Regards
M
-Original Message-
From: Matthew Darcy [mailto:[EMAIL
I'm a newbie in DB administration. Could somebody tell me what do I need to
start a web-based project for book listing, mail lists etc, all retrieved
from a database updated by LAN users and listed on a web page?
Thanks in advance!
Viorel C
I´ve just another question,
I couldn´t get the info from the manual, I suppose that´s because
I don´t know other basics on Mysql .. :-(
I´ve been using the temporary table, and it works well, but, I can only
display the results set just once in my script, is that normal?
I´ve been trying to
I've read the TODO list regarding the fulltext search
and noticed that it doesn't include any more options
for truncating. I'm in need of a database which
supports pre-truncating - masking would be great too
:) It would be great if my favourite database would
get full pre-truncation :)
Q: Will
Me...
I would use MySQL (as it if very fast, and never brakes)
I also like PHP as it just fits in with MySQL so well!
Simon
-Original Message-
From: Viorel C [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 23:52
To: [EMAIL PROTECTED]
Subject: hey folks!
I'm a newbie in DB
Dear All,
I wonder whether one can use the full text indexes in mysql to find out
what words in a document are likely to be relevant key words.
I've several thousand text documents in a table with a full text index,
and I can search for documents corresponding to some given keywords
using the
If you are using php, the function you want is mysql_data_seek($result,0) to
reset the result set.
John Lodge
-Original Message-
From: Walter D. Funk [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 2:04 PM
To: [EMAIL PROTECTED]
Subject: TEMPORARY TABLES
Ive just another
-Original Message-
From: Viorel C [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 23:52
To: [EMAIL PROTECTED]
Subject: hey folks!
I'm a newbie in DB administration. Could somebody tell me what do I need
to start a web-based project for book listing, mail lists etc, all
I have changed a fulltext variable ft_min_word_len from the default 4 to
1, and the manual says to rebuild my fulltext indexes once again.
I verified that this variable changed with SHOW VARIABLES and it did change.
I have tried optimize table, analyze table, repair table which all
finished
Sascha Kettner wrote:
Hi!
I have the following script to be executed via post from a web-form; the
var. Pin, msisd and knd are given by the form but however, the script is
not working. I always get no results as if there are no matches, but
this isnt right! This is regardless which
Hi,
Could somebody please help me with the following. I want an equivalent for:
select afield from atable where max(index) = index;
I tried this, and that works, but it seems to me that there is a better
(cleaner) way to accomplish the same.
select afield from atable order by
This is not a MySQL question.
You should take it to a Linux list.
The answer, I think, is You don't.
SankaraNarayanan Mahadevan wrote:
Hi,
I have developed an application in PHP/MySQL in Linux
environment. I need to burn it in a CD and give it to
the client. I need to do one thing - that
Your question is too vague to answer.
What operating system and hardware are you running.
Which file did you download?
What EXACTLY was the error message?
EDA Peach wrote:
Hi,
Wondering if anyone might be able to help me with a
slight problem. I downloaded the static version of
the
Hi Fred,
You might want to look into www.netsaint.org . The mysql plugin is
in the contrib directory, you can add functions like restart,
althougth safe_mysqld should restart the daemon itself.
best of luck,
Ken
- Original Message -
From: Fred Taurus [EMAIL PROTECTED]
To: [EMAIL
Hi!
Are you running mysqld under the safe_mysqld script, which automatically
restarts mysqld after a crash?
If yes, look at the 'hostname'.err file and send its contents to me.
Or, if you run mysqld from the command prompt, capture what mysqld prints to
the command prompt window.
If mysqld
I am inserting user details from a file. The file has users seperated by
commas(,)
example of file
manjeet,tom,tim,,john,alexander
Using perl script i am reading the file and seperating user info at commas
and inserting into database.
Now my problem is that i don't want to insert the fourth
Hi All,
New to mySql. I've setup ok, running ok, read thru
the privilege system docs. My question is about the
user root: is it absolutely necessary to keep this
user or is it ok to delete the root user (after
setting up an equivalent super-user under another
name)?
Thanks,
Jeff
Hi Jeff
As long as you have a user that has access to all of MySQL and can enter
from root on the systems, what you call it is not important.
Infact it is a good thing to change the root user name for security.
Simon
-Original Message-
From: Jeff Corliss [mailto:[EMAIL PROTECTED]]
Sent:
* Manjeet
I am inserting user details from a file. The file has users seperated by
commas(,)
example of file
manjeet,tom,tim,,john,alexander
Using perl script i am reading the file and seperating user info at commas
and inserting into database.
Now my problem is that i don't want to
I've downloaded and am trying to use the MySQLGUI as well
and had the same problem, but figured it had to me a
firewall problem so I opened up port 3306 in my IPchains
and it let me through only now it's telling me that the
computer I am coming from is not allowed to connect to
MySQL server.
Jean-Luc,
for InnoDB variables look at section 2 of http://www.innodb.com/ibman.html
Regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
.
I would need those to
After a long day of trying and reading all sorts of manuals and faqs and
newsgroups
I still can't create tables with the mySQLgui (1.7.5.2 windows) running in
win 2000 pro standalone feature
I can read the test database (empty of course)and the users dbase
in neither of them I'm able of creating
I am having the same problem.
My laptop jaguar is not allowed to connect to my server (jordan)
I get jaguar is not allowed. I think it is something to do with granting
user root from jaguar to root@jordan ??? I am trying to figure out what is
going on ?
If you read back I posted a couple
Hi,
I've installed MySql on a RedHat box and configured log-bin. Everything is
running OK.
My question is, if a user does any insert, delete or update, can I see which
user (username) has performed that action?
Where can I log this information and retrieve it later, for auditing
purposes?
If you have rights to access other database then simply type
databasename.table
Bye
I want to select from two databases at one time, like
use forum
select from users a, auth.users b where a.name = b.name
The databases are running on the same mysql server. Do I have to
Yes you can..
We have a log called mysql.log that has user@IP/domain and then the
question.
All you need to do is edit my.cnf to make shore it is on.
We keep all the logs can just gunzip them up.all you need is a perl
script to get the data back out.
Simon
-Original Message-
From:
I never sent a mail to unsubscribe ???
have I been booted from the list or what ??
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
To confirm that you would like
[EMAIL PROTECTED]
removed from the mysql mailing list, please send an empty reply
to this
On Mon, 7 Jan 2002, Arne Mueller wrote:
I wonder whether one can use the full text indexes in mysql to find out
what words in a document are likely to be relevant key words.
. . .
I'd be nice to have a command like this:
select keywords(10.0) from MyDocs where DocId = 666;
. . .
Isn't
You need to create a user with login privileges from any location.
GRANT ALL PRIVILEGES ON *.* TO foo@% IDENTIFIED BY 'apassword' WITH
GRANT OPTION;
AND, as is appended to each post,
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
The unsubscribe request came from [EMAIL PROTECTED] according to the
headers. I'd bet this was an accident. The same thing happened to me a
while back. If you'll look at the bottom of my reply, you'll notice that
*my* unsubscribe info is included. (Usually, I cut that section out of my
apologies, I don't have the space to keep all mails as this group puts out a
100+ messages a day I glance through them and if they are not relevant I
delete them unless I know I'll need them in the future.
-Original Message-
From: Doug Thompson [mailto:[EMAIL PROTECTED]]
Sent: 07 January
I am running mysql on windows 98 could not get the
mysql_install_db to work.
Anyone familar with this problem or know a way around?
I checked the folder 'scripts' but did not see
mysql_install_db in there ???
thanks in advance
=
Regards,
Investorclb
MySql mSQL O'Reilly press isbn 1-56592-434-7
is probably the worst book about mysql.
Please note that the O'Reilly book was originally suppose to be about msql
but near the end of the project they noticed that mysql was gaining
popularity on msql so they threw in some information on
mysql.
Hello,
I have a question for you. I have a Solaris 5.6 server running Mysql. It is our
company' website. I just know the server's root password and I don't know mysql
database user name and password. Is it possible to login to Mysql database by using
the server root and its password? How
My ISP has version 3.22.23b-log installed on my hosting service machine,
and I have repeatedly encountered problems importing tables to the database
that have indexes that are not given a default value or that are not
specifically stated to be NOT NULL.
Others using the same programs have
Hello list,
The problem:
I have two mysql-servers A and B with the same Database DB. Sometimes, I
would like to make a snapshot of DB from A and then synchronize DB on B
with this snapshot. OK, logical dump on A, destroy DB on B and import
would work, but this ain't elegant, or?
Is there a
No but you can start MySQL with out grant tables.
See on line manual and don't know password.
Or ./mysql --help
Simon
-Original Message-
From: Cindy Yu [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 17:48
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Mysql
I'm trying to create a select statement that will go into a table find the
number of rows in the table then select a single random row and return it. I
am using Java/mySQL with the mm.mysql JDBC drivers. I've been playing around
with the following statement but it doesn't seem to like the
Hi Simon,
Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the
error:
mysql not found. How can I find mysql server?
Cindy
Simon Green [EMAIL PROTECTED] 01/07 10:05 AM
No but you can start MySQL with out grant tables.
See on line manual and don't know
Hi Erwin
Try
Select afield from atable where index=(select max(index) from atable);
[]s
Paulo Botelho
- Original Message -
From: Erwin Hogeweg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, January 07, 2002 12:47 PM
Subject: Neede MySQL query Equivalent.
Hi,
Could
I am using mysql 3.23.39 on Linux Redhat 7.1...
I use the following queries,
CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY,
message CHAR(20));
CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY,
message CHAR(20));
INSERT INTO t1 (message) VALUES
(Testing),(table),(t1);
INSERT INTO t2
Have you verified that the mysql internal data bases don't exist?
If you are running a Win binary, they should already exist. I don't even
think mysql_install_db is part of the Win dist. It is a shell script used
in UNIX installations.
~rob
Sent: Monday, January 07, 2002 11:38 AM
To: [EMAIL
--- Simon Green [EMAIL PROTECTED] wrote:
Hi Jeff
As long as you have a user that has access to all of
MySQL and can enter
from root on the systems, what you call it is not
important.
Infact it is a good thing to change the root user
name for security.
Simon
Thanks for the response - the
D Bamud wrote:
Which is the **best, easy, compact** book available on MySQL. Delhi India.
I found that MySQL by Michael Kofler (Apress, ISBN 1-893115-57-7) was a
rather good and informative book.
Cheers,
Markus
--
Markus Lervik
UNIX-administrator with a kungfoo grip
Vaasa City Library -
D Bamud wrote:
Which is the **best, easy, compact** book available on MySQL. Delhi India.
MySQL by Paul Dubois, New Riders Publishing, ISBN 0-7357-0921-1
--
Regards,
Doug
-
Before posting, please check:
I'm running RedHat Linux 7.0 (2.2.16-22) with MySQL 3.23.32... It's been
working perfectly until suddenly this morning at 1:40AM it stopped
responding.
I restarted the whole system, and still nothing. It says Running with
the PIDs when I do a mysqld status and when I do a mysqld start it
Hi,
I have another example of this strange behaviour. I've managed to dump
most of the table and then after certain row got the error 127. This
machine is linux 2.2.17 in this particular example operating on table
close to the 2GB limit.
mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
try restarting port mapper on the linux box.
also make sure swap is not almost used as sockets uses tmp to swap out tcp
requests.
-Original Message-
From: Michael J. Cermak, Jr. [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 19:36
To: [EMAIL PROTECTED]
Subject: Newbie needs serious
Hello MySQL-users !
Houston, I've got a problem here.
I'm running the following query from a PHP-Script:
SELECT years.year AS yearlist, count(years.year) AS gamecount
FROM years
LEFT JOIN games
ON years.year = games.release_year
GROUP BY years.year
ORDER BY gamecount DESC, yearlist
Jens,
You need to select on the games on the left, to ensure that you don't end up
with years on the left with no corresponding game records. Try this:
SELECT years.year AS yearlist, count(years.year) AS gamecount
FROM games
LEFT JOIN years
ON games.release_year = years.year
GROUP BY
Jens Mildner wrote:
Hello MySQL-users !
Houston, I've got a problem here.
I'm running the following query from a PHP-Script:
SELECT years.year AS yearlist, count(years.year) AS gamecount
FROM years
LEFT JOIN games
ON years.year = games.release_year
GROUP BY years.year
From: Jens Mildner [EMAIL PROTECTED]
Every year from years.year should be returned along with the
number of games that have been released in that year...
Years in which no games were released are returned with a
gamecount of 1.
This is a side effect of the JOIN syntax. Try this:
On Mon, Jan 07, 2002 at 03:52:10PM -0800, Viorel C wrote:
I'm a newbie in DB administration. Could somebody tell me what do I need to
start a web-based project for book listing, mail lists etc, all retrieved
from a database updated by LAN users and listed on a web page?
Go for
Hi,
Doing a mysqldump of a large table to /tmp, I filled up /tmp, which caused
mysqld to reset.
This is while using 3.23.40 on Solaris 2.6
What additional information should I provide to help address this problem?
From: Quentin Bennett
To: [EMAIL PROTECTED]
Subject: [Mysql crash]
Try the -q option to mysqldump so it doesn't buffer up the whole thing.
Quentin Bennett wrote:
Hi,
Doing a mysqldump of a large table to /tmp, I filled up /tmp, which caused
mysqld to reset.
This is while using 3.23.40 on Solaris 2.6
What additional information should I provide to
I'm porting a MS-SQL system to a Solaris machine running Mysql.
In the MS-SQL there is a datatype of money what would be the proper
datatype in mysql to use as a replacement for this?
Keith
-
Before posting, please check:
Hi!
Please upgrade to 3.23.47. Many bugs have been fixed since .41.
This is a bug in gcc-2.95.3, at least in some builds of the compiler.
Fix: edit mysql/innobase/btr/btr0sea.c
and replace
UNIV_INLINE
about on line 455 (in MySQL-3.23.47) of the file by
static
Or download a ready binary
I don't know if this is a bug or a feature. Just an observation concerning
creating MYISAM tables with auto_increment.
CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000;
INSERT INTO mytable VALUES(NULL);
INSERT INTO mytable VALUES(NULL);
these above INSERTS create
You can also set the auto_increment start value in the CREATE table:
CREATE TABLE mytable (
myval int auto_increment)
AUTO_INCREMENT=100;
Note that the AUTO_INCREMENT=100 is set outside of the fields' definitions.
However, when you delete all records with DELETE FROM mytable, the counter
will
Hi,
I'm starting a reporting application project and I want to use mysql as
the backend to store the data... The only problem is my data I'm
grabbing the information off a message bus and each object has an
undefined number of
field=value pairs...
does anyone know of documentation or
1 - 100 of 119 matches
Mail list logo
