Victoria
Monday, August 19, 2002 11:58 AM, you wrote :
VR> Hi, David!
VR> You can find new 3.23.52 binary packages at www.mysql.com
VR> Could you install new packages and check if loading problem occurs
VR> again?
One of our production server is running 3.23.52 ( the tar.gz one ).
Uptime is 26 H
On Wed, 21 Aug 2002, Paul Maine wrote:
> The following table uses order_id as the primary key. My problem is that I
> need to be able to change order_id so that it is not a primary key. Next, I
> want to add a new auto incrementing key. What sql commands should I use to
> first back up the table
I think you're missing a few things:
1) Does your user have a password set? If it does, u need to use the
following line to pass your username and password:
Connection connection = java.sql.DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "username", "password");
2) You n
On Wed, 21 Aug 2002, Brian Moon wrote:
> If I have a query like:
> select field1 from table where field2=0 order by field3 desc limit 30;
> and I have keys:
> key field2 (field2)
> key field3 (field3)
>
> Will MySQL use one key to select and one to order? Or do I need a:
>
> key field2_field3 (
On Wed, Aug 21, 2002 at 11:57:53PM -0500, Brian Moon wrote:
> I have a table:
>
> CREATE TABLE `single_table` (
> `forum_id` int(10) unsigned NOT NULL default '0',
> `id` int(10) unsigned NOT NULL auto_increment,
> `datestamp` datetime NOT NULL default '-00-00 00:00:00',
> `thread` in
On Thu, Aug 22, 2002 at 02:40:54PM +1000, Jerry van Leeuwen wrote:
>
> I find myself in the position where I really would like to use 4.0.x in a
> production environment where currently 3.23.x is being used. (Mainly because
> of the ability of 4.0.x to use indexes on ORDER BY ... DESC, which ar
I have a table:
CREATE TABLE `single_table` (
`forum_id` int(10) unsigned NOT NULL default '0',
`id` int(10) unsigned NOT NULL auto_increment,
`datestamp` datetime NOT NULL default '-00-00 00:00:00',
`thread` int(10) unsigned NOT NULL default '0',
`parent` int(10) unsigned NOT NULL
Hi
I'm just getting started with mysql so please bear with me. =8-}
I do a 3 table query like:
SELECT a.x, b.y, c.z
FROM a, b, c
WHERE a.b_fk = b.id AND a.c_fk = c.id;
That works so far.
In c can be rows which aren't active anymore.
There is a good_from and a good_until DATETIME field which
Hey, Im trying to create a db on a server (over which I have no
control) and I keep getting this error:
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
'@localhost' to database 'musica''
Any suggestions?
Andrew
My homepage
http://www.andrewski.fr.st
---
I find myself in the position where I really would like to use 4.0.x in a
production environment where currently 3.23.x is being used. (Mainly because
of the ability of 4.0.x to use indexes on ORDER BY ... DESC, which are
currently just too slow).
What I need to know is how stable can I consi
Hi,
I have redhat 7.1 and I am using mysql server 3.23.36
and I could login as a user to the linux server and run
mysql program from the command line and connect to database
I want to and do all SQL commands without any problems...
But when I run a program that has
Class.forName("org.gjt.mm.mys
try select * from table where field2=0 order by field3 desc limit 30
I think you need the column to compare.
> If I have a query like:
>
> select field1 from table where field2=0 order by field3 desc limit 30;
>
> and I have keys:
>
> key field2 (field2)
> key field3 (field3)
>
> Will MySQL u
this is a php question, try:
http://www.php.net/manual/en/function.number-format.php
> Hi,
>
> I just want to know if mysql can set the output of a certain currency to
> this pattern :
>
> $1,500.00
>
> If I use a comma on a certain amount then I add it up to another amount with
> a comma I ge
If I have a query like:
select field1 from table where field2=0 order by field3 desc limit 30;
and I have keys:
key field2 (field2)
key field3 (field3)
Will MySQL use one key to select and one to order? Or do I need a:
key field2_field3 (field2, field3)
This is a big table and i don't want
Hi,
We want to set quota per user. Is that possible on MySQL ? If so
how can that be done?
Alex
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the lis
I definitely fixed some problems when using Foxpro in DBD::ODBC in the
later/latest versions. However, I do not believe that ActiveState has
caught up with me yet. Use search.cpan.org searching for DBD::ODBC to check
the changes information and compare that with the version you are running
now.
Hi,
I just want to know if mysql can set the output of a certain currency to
this pattern :
$1,500.00
If I use a comma on a certain amount then I add it up to another amount with
a comma I get the wrong
answer. I'm using php & mysql by the way.
Any hints on this one?
Regards,
Delz
The following table uses order_id as the primary key. My problem is that I
need to be able to change order_id so that it is not a primary key. Next, I
want to add a new auto incrementing key. What sql commands should I use to
first back up the table and then to accomplish this modification. This i
Being fairly new to mysql, I'm trying to do the following and coming up
empty handed.
I'm in the process of writing a set of sql scripts (aka, text files to be
sourced (\.) inside of the MySQL interpreter)
Ideally, I would like to be able to have the following behaviour:
On error, rollback t
Yes,
I see that now in the docs and it makes perfect sense. Sorry about that.
My bad.
--Gabe
Benjamin Pflugmann wrote:
> Hello.
>
> On Wed 2002-08-21 at 16:49:06 -0400, [EMAIL PROTECTED] wrote:
>
>>I need to figure out values in a column of a given table that do not
>>exist in a a column
I just joined this list, so I hope my question is appropriate. I'm trying to
build mysql-3.23.52 on my UltraEnterprise 3500, running Solaris 7. I can't use
a pre-compiled binary because I need to install it in /opt/local rather than
/usr/local. I'm using GCC/G++ 3.2, in /opt/local/bin. My $
Hello.
On Wed 2002-08-21 at 16:49:06 -0400, [EMAIL PROTECTED] wrote:
>
> I need to figure out values in a column of a given table that do not
> exist in a a column of another given table without subselects.
>
> For example:
>
> If I have one table called "TABLEA" with column name "id" and val
This is copied from http://www.openoffice.org/issues/show_bug.cgi?id=6600
Hi,
I encountered that MySQL only ask for english locale and doesn't work
if this locale is not available. As I remember they only ask for
LC_ENGLISH or something like that. Sorry that I could say more about,
I don't know
Hey all, i'm trying to setup a system in which a slave takes over as master in the
case the master dies.
we're using innodb w/ databases of about 500 megs, so scp/rsyncing those every night
is a pretty daunting task, not to mention we can never be sure that the secondary DB
has the most recent
I need to figure out values in a column of a given table that do not
exist in a a column of another given table without subselects.
For example:
If I have one table called "TABLEA" with column name "id" and values
"1,2,3,4,5,6,7",
and another table called "TABLEB" with column name "id" and v
Ajay Patel - SunService wrote:
>I am a beginner at SQL and would appreciate any help with a simple
>query.
>
>I have two tables:
>
>host
>patch
>
>The host table contains details for a particular host (OS, cpus, memory, etc)
>and the patch table contains patches installed on that host.
>
>For e
select hostid,patch.patchnumber from host
left join patch on host.hostid = patch.hostid
where patchnumber isnull
-Original Message-
From: Ajay Patel - SunService [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 2:27 PM
To: [EMAIL PROTECTED]
Subject: help with a query
I am
What happens when mysql_fetch_rows() returns a valid pointer to free'd memory?
Is this a bug in the library or ??
To reproduce this I'm running freeradius with about 10 different background
test clients repeatively testing a login feature, at the same time running
a script that randomly sleeps b
On Wed, 2002-08-21 at 15:20, Lenz Grimmer wrote:
> That's correct. We build our Alpha binary with the Compaq C/C++ compiler on a
> Compaq DS-20, which has an EV6 processor. So far, we only used the compile
> option "-fast", which by default optimizes for the platform it is currently
> running
I am a beginner at SQL and would appreciate any help with a simple
query.
I have two tables:
host
patch
The host table contains details for a particular host (OS, cpus, memory, etc)
and the patch table contains patches installed on that host.
For example:
Host:
hostid hostname
- Original Message -
From: "Franklin Williams Jr." <[EMAIL PROTECTED]>
Date: Tue, 20 Aug 2002 18:24:52 -0400
To: Joseph Grundy <[EMAIL PROTECTED]>
Subject: Re: insert command
> > - Original Message -
> > From: "Keith C. Ivey" <[EMAIL PROTECTED]>
> > Date: Tue, 20 Aug 2002 16:50:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
On Wednesday 21 August 2002 20:17, Timothy Olden wrote:
> I have been using MySQL version 3.23.33 on my Alpha box for quite a
> while now. A month or two ago I tried to update to mysql-max-4.0.1 only
> to learn that the binary was built o
Hello,
See mysql\data\[hostname].err or mysql\data\mysql.err for what might have
gone wrong.
Also, you could try starting your mysqld with the following (not as a
service): mysqld-(max-)nt --console --standalone
Then, if there's something wrong in the error log, you can copy/paste the
last line
On Wed, Aug 21, 2002 at 11:37:57AM -0700, abw wrote:
> Hello,
>
> Having a problem here. I'm trying to get a Mysql 3.23 database from a Red
> Hat 7 machine over to a Mysql 3.23 on a Solaris Sparcstation.
>
> I was able to dump the database using the mysqldump command. The database
> has 3 tabl
I did not have any problem installing mysql ver 3.23.52 on Windows NT
workstation or xp pro, however, on Windows 2000 server mysql service
does not start. When I try to start it I get error 1067-the process
terminated unexpectedly. In all cases I install the software on drive D
and create the my.i
Hello,
Having a problem here. I'm trying to get a Mysql 3.23 database from a Red
Hat 7 machine over to a Mysql 3.23 on a Solaris Sparcstation.
I was able to dump the database using the mysqldump command. The database
has 3 tables, and I used the following syntax:
mysqldump -u -p table_name
Hi folks,
I was just wondering, where I can see, which queries are used from the bin-log.
I am using a setup with "...do-table" so I restricted it but I am not sure if all the
queries
are taken to update the tables.
is there a log where I can see, what was done?
I looked at the relay-log but my
Then it doesn't belong on the MySQl list, does it?
Norris, Joseph wrote:
>Agreed except in this case what I have to read is a FoxPro database -
>(yuck!)
>
>-Original Message-
>From: Gerald Clark [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, August 21, 2002 11:28 AM
>To: Norris, Joseph
>Cc
Agreed except in this case what I have to read is a FoxPro database -
(yuck!)
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 11:28 AM
To: Norris, Joseph
Cc: Mysql_List (E-mail); Perl Database (E-mail); Perl Web (E-mail); Perl
Win32 Users
Why use odbc when native drivers are available?
Norris, Joseph wrote:
>Groups,
>
>I have this snippet of code:
>
>$dbh = DBI->connect( "dbi:ODBC:${db_name}", "$user", "$pass")
> or &DoError("Unable to connect: $DBI::errstr");
>
>#$dbh->debug(2);
>
>$fsql = qq!select empl_no_a, user_ln, user_fn,
>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:
All,
I have been using MySQL version 3.23.33 on my Alpha box for quite a
while now. A month or two ago I tried to update to mysql-max-4.0.1 only
to learn that the binary was built on an EV6 processor and would not
work on the EV56 chip.
I could but knowing what a pain it would be for me to pull
On Wednesday 21 August 2002 10:40 am, Egor Egorov wrote:
Well, loosely...
SET AUTOCOMMIT=0
does not START a transaction, what it does is signal the database that from
now on transactions will be explicit, not implicit. That means you NEED to
have a transaction to get anything to stick in the
Groups,
I have this snippet of code:
$dbh = DBI->connect( "dbi:ODBC:${db_name}", "$user", "$pass")
or &DoError("Unable to connect: $DBI::errstr");
#$dbh->debug(2);
$fsql = qq!select empl_no_a, user_ln, user_fn, user_mi, aka,
longname_a, longname_b, longname_c, useaka from activeempsinfo!
I ran out of tables that I can join in
one select (31) and rebuilt MySQL with
table_map's typedef changed from ulong
to ulonglong.
First it all worked fine. But after
half a day of not very heavy load strange
things began happening. Indexes got
corrupted. So some of the joins that
worked before s
I am guessing that it is quicker to join 2 tables based than it is to do 2
selects in a php script
opinions???
Randy
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists
Fifield, Mike wrote:
>I have a table with around 150 entries in it. I am querying the table with
>the fallowing command.
>SELECT * FROM guestbook LIMIT 140,9
>This is working fine I am getting the last 9 entries but I would like it to
>return them in reverse order. Is there a way to do this? I
On Wed, Aug 21, 2002 at 12:30:02PM -0300, Ray da Costa wrote:
> Oi, for gentility!
>
> Could inform which the procedure to share the MySql that is in my machine
> with the escritorio friends.
I may be misunderstanding you.
If you have a MySQL database on your machine, and you want other peo
I have a table with around 150 entries in it. I am querying the table with
the fallowing command.
SELECT * FROM guestbook LIMIT 140,9
This is working fine I am getting the last 9 entries but I would like it to
return them in reverse order. Is there a way to do this? I tried this
SELECT * FROM
Hello
I have a compilation problem with MySQLGUI.
I have downloaded ans installed
MySQL using the following version
mysql-3.23.52
Msql-Mysql-modules-1.2219
DBI-1.18
Data-Dumper-2.101
MySQL pass all the tests and work OK.
then MYSQLGUI using the following version
fltk-1.0
testing mysql list server to see if my posts are recieved
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <
Hi,
I am looking for dates for new versions and the bug fixes they will have contained.
I am using 4.0.1... however I have a handles leak. I have been told by another source
that this will be resolved in 4.1
My question is, using MyODBC(3.51.03)... Is this a problem with 3.x stable releases or
Is their anyway of finding out what queries are causing tmp tables to write
to disk?
Cheers
John Wards
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 3:40 PM
Subject: Re: Re: temp tables
> John,
> Tuesday, August 20,
* Victoria Reznichenko
> RB> 3) How can the server know that the max_allowed_packet for
> RB> _this_ connection
> RB> (the UPDATE'ing connection) isn't smaller than the
> RB> max_allowed_packet value
> RB> for a future SELECT connection? (I could do the UPDATE ...
> RB> CONCAT(... with
> RB> max_a
(filter bypass words - Mysql, sql, query)
Group,
I have just got into a situation in which I need to explore replication and
I know nothing about it. Can any one direct me to specific documentation on
this and maybe a simple tutorial for the "greener" of us?
Thanks.
--
I am trying to install MYSQL on Solaris 9 sparc edition. I am using the
following options:
CFLAGS="-O3 -mcpu=v8 -Wa,-xarch=v8plusa" CXX=gcc
CXXFLAGS="-O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-constructors -fno-exceptio
ns -fno-rtti"
./configure --prefix=/usr/local/mysql --localstatedir=/www_data/my
Oi, for gentility!
Could inform which the procedure to share the MySql that is in my machine
with the escritorio friends.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysq
> I guess this is easy, but it is defeating me.
> I am having a problem with this query:
>
> $keyword = "search";
> SELECT * FROM table WHERE field LIKE '%$keyword%'
>
> The problem is I don't want "sear" or earch but exactly "search".
If you're looking for an exact match, where field will contai
At 05:27 PM 8/20/2002 -0400, walt wrote:
> > I have added this one, thanks.
>Hmmm...
>When you set up the master database, did you copy all the *.frm, *.MYD, *.MYI
>to the slave database?
Ok, after a lot of hair-pulling, I downgraded and used 3.23, and what do
you know, replication worked out fi
On 21 Aug 2002, at 16:27, tibyke wrote:
> > $keyword = "search";
> > SELECT * FROM table WHERE field LIKE '%$keyword%'
> >
> > The problem is I don't want "sear" or earch but exactly "search".
>
> like "% $keyword %";
But that won't find "search" if it's at the beginning or end of a
string, o
Robert,
when you use the "LIKE" statement any word that is similar to your desired
search criteria will be selected.
if you desire an exact match then use:
SELECT * FROM table WHERE field =
Shaun
- Original Message -
From: "Robert Macwange" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
You have carriage returns in your data file.
Try adding a 'terminated by' to your load data.
compo guy wrote:
> I am using MySQL version 3.23.11-alpha on Win98. I have created a
> database with a table borrower whose description is as follow:
>
> mysql> describe borrower;
> +---+--
Jim,
Wednesday, August 21, 2002, 2:51:51 PM, you wrote:
JB> sql, query
JB> I understand I must use InnoDB tables if I plan to use constraints.
JB> If I:
JB>CREATE TABLE TEMP_TEST(A CHAR(2),B CHAR(2))
JB>TYPE = InnoDB;
JB> Well the test table gets created, but it is, according to
JB> SHO
Randy,
Tuesday, August 20, 2002, 7:49:09 PM, you wrote:
RJ> in a innodb table type using mysql max
RJ> is a begin statement the same as set autocommitt = 0??
Yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://w
sherzodr,
Wednesday, August 21, 2002, 9:01:44 AM, you wrote:
s> If i have a single quote (') inside the /* */ comments,
s> it gives me a syntax error. Why?
Because the single quote even in the comments means that quoted string
begun:
http://www.mysql.com/doc/en/Comments.html
--
For
John,
Tuesday, August 20, 2002, 5:27:27 PM, you wrote:
JW> Ta,
JW> But is it normal to have Temp table bigger than 10meg? And a lot of them?
JW> Here is my latest data from STATUS
JW> Created_tmp_disk_tables 46598
JW> Created_tmp_tables 87839
JW> Uptime 81773
JW> And I have set tmp_table_cache
OZGUR,
Wednesday, August 21, 2002, 10:09:06 AM, you wrote:
OG> I am very new with mysql. I have just installed it to Sun OS but there
OG> is a message " ERROR 2002: Can't connect to local MySql server thought
OG> '/tmp/mysql.sock' (2)".
OG> Does anyone have knowledge about problem and help me?
Richard,
Tuesday, August 20, 2002, 9:04:05 PM, you wrote:
RU> Is it fixed only in MySQL 4.x, or will it be in the next point
RU> release of 3.x as well?
No, it wasn't changed in 3.23, only in 4.0.3..
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Roger,
Tuesday, August 20, 2002, 5:34:25 PM, you wrote:
RB> Maybe... :)
RB> On the other hand:
RB> 1) The documentation on max_allowed_packet talks only about transferring
RB> data, not storing. (This should be easy to fix.)
Agreed..
RB> 2) The mere existence of LONGBLOB and LONGTEXT suggests
> Hello y'all,
>
> I guess this is easy, but it is defeating me.
> I am having a problem with this query:
>
> $keyword = "search";
> SELECT * FROM table WHERE field LIKE '%$keyword%'
>
> The problem is I don't want "sear" or earch but exactly "search".
like "% $keyword %";
---
Use FullText indexing or a REGEXP.
Brian.
- Original Message -
From: "Robert Macwange" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 9:18 AM
Subject: Exact word search
| Hello y'all,
|
| I guess this is easy, but it is defeating me.
| I am having a proble
Robert,
> ... WHERE field LIKE '%search%'
means everything that contains "search".
Examples: "abcsearch", "searchabc", "abcsearchabc".
But it doesn't mean "abcearch", "searcabc", "searc".
Best regards,
Mikhail.
- Original Message -
From: "Robert Macwange" <[EMAIL PROTECTED]>
To: <[EMAI
Robert Macwange wrote:
> Hello y'all,
>
> I guess this is easy, but it is defeating me.
> I am having a problem with this query:
>
> $keyword = "search";
> SELECT * FROM table WHERE field LIKE '%$keyword%'
Hint, for 'search' in middle of phrase:
SELECT * FROM table WHERE field LIKE '% $keywo
Jim, it must be that the innodb parameters aren't set up in /etc/my.cnf.
Case doesn't matter on the "type=innodb".
I've set up a tablespace called pracexpr1 that has the following section for
innodb in my my.cnf:
# Uncomment the following if you are using Innobase tables
innodb_data_file_path = p
Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = "search";
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want "sear" or earch but exactly "search".
What am I missing?
..
Regards, Robert (Newbie)
Hi.
I have problem.
I would like to upgrad from 3.23.51 on my win98 to 3.23.52 but with innodb
tables 3.23.52 hang on starting. and my win98 goes slowly and slowly.
ctrl-alt-del helps :)
In log i see:
010820 20:20:13 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 2. Aborting!
010820 20:20:13 Aborting
> Hardware?
> Operating System and version?
> MySql version?
> Precompiled, you compiled?
> Which compiler?
Intel Dual 1Ghz, 1Gb RAM, RedHat Linux 6.2, kernel 2.4.16, MySQL 3.23.52
from rpms (happened the same with 3.23.46). As I said before, this only
happens the last few days, we were runnin
I am using MySQL version 3.23.11-alpha on Win98. I have created a
database with a table borrower whose description is as follow:
mysql> describe borrower;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+--
Hardware?
Operating System and version?
MySql version?
Precompiled, you compiled?
Which compiler?
[EMAIL PROTECTED] wrote:
> Hi. These last days, after some months of running relatively smoothly,
>I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it
>just goes astray an
You seem to havew a leading space in your newuser account.
Juri Nysschen wrote:
>Hi
>
>I have a problem with privileges on MySql NT 3.23.52. I hope that someone
>can provide me with a solution.
>
>If a user has USAGE privileges on the mysql db (*.*), and ALL privileges on
>another db (CUSTOMDB)
Hi,
> According to the documentation, you can use:
> FLUSH TABLES WITH READ LOCK
> for that.
> See http://www.mysql.com/doc/en/FLUSH.html
> for details
Well, that seems perfect. I guess I should have RTFM before ;))
Thanks a lot
Antoine.
---
Hi.
I have problem.
I would like to upgrad from 3.23.51 on my win98 to 3.23.52 but with innodb
tables 3.23.52 hang on starting. and my win98 goes slowly and slowly.
ctrl-alt-del helps :)
In log i see:
010820 20:20:13 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 2. Aborting!
010820 20:20:13 Aborting
Antoine wrote:
> Hi,
>
> I use LVM (Linux Volume Manager) on my box. The MySQL datadir is mounted
> on a specific ext3-formatted logical volume ; thus I am able to make live
> snapshots of the database using the LVM snapshot fonctionnality.
> Internally, LVM snapshots function by syncing the orig
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ozgur,
I would make sure that your MySQL server is running. I believe this
problem has been asked many a-time, and should be covered in the
documentation.
HTH,
Bryant Hester
Juxtapose, inc.
> Hi All,
> I am very new with mysql. I have just insta
* Jaskaran Singh
> I am inserting the fields through VB.
> When I insert the record in the table of Mysql . Mysql inserts
> the record properly (very first record) with the contents of the fields
> shorter than the length of the field. If I try to insert another
> records in the table with len
Hi!
I have 2 tables
Table 'candidate_index' holds information like
firstName,lastName,phoneNumber etc.
Example
id | firstName | lastName | phoneNumber
1 | Peter | Engström | 3236363
2 | John| Smith | 3773737
...
Table 'candidate_skills' holds the skills a candidate have
Exa
sql, query
I understand I must use InnoDB tables if I plan to use constraints.
If I:
CREATE TABLE TEMP_TEST(A CHAR(2),B CHAR(2))
TYPE = InnoDB;
Well the test table gets created, but it is, according to
SHOW TABLE STATUS, a MyISAM table. How can I set Type to InnoDB
and make it stick.
And
Hi,
I use LVM (Linux Volume Manager) on my box. The MySQL datadir is mounted
on a specific ext3-formatted logical volume ; thus I am able to make live
snapshots of the database using the LVM snapshot fonctionnality.
Internally, LVM snapshots function by syncing the original partition to
disk and
The MySQL database we use is a 4.0.2 source RPM on a RedHat 7.3
MySQL locks tables while they are being updated and unlocks the table
when the update is finished. But sometimes MySQL doesn't unlock certain
tables. And in the process list their is nothing being processed.
Does anybody know why or
Hi Neil,
after some help from Aron Pilhofer and the online manual I got this
statement
select (to_days(deadline)) - (to_days(current_date))
thanks!! K:)
on 21/8/02 7:58 Uhr, Neil Mansilla at [EMAIL PROTECTED] wrote:
> On Wed, 21 Aug 2002, Kai Vermehr wrote:
>
>> how can I calculate the diff
Dear Friends
I observed the very strange problem with my Mysql , My be this is the feature or I
have not configured it properly
please do tell me the reasons and remedy.
Problem is
I am inserting the fields through VB.
When I insert the record in the table of Mysql . Mysql inserts the record
Hope this is the right term ;-)
Background:
I log my radius logs to mysql
I had a problem (self inflicted) with the table where I logged it into.
I copied the files out and recreated the database so that I don't ose to
many logs.
I took the old files .MYDetc and recreated the database on a
Too many connections
Is the message you get when all are used up. The limit is about 1000 (Linux)
but can be set higher.
With MySQL you can set a limit for each user. So I would set this to say 100
for each user and 1000 in total.
What courses this is pconnects or threads that will not drop. If yo
Hi. These last days, after some months of running relatively smoothly,
I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it
just goes astray and virtually hangs. Load goes up to +200%, all
connections are occupied and it just doesn't do anything. The only way to
stop it is
>Description:
Replication cannot be started
>How-To-Repeat:
Following the set up instructions in section 4.10 "Replication in
MySQL" of the MySQL documentation
>Fix:
Not known
>Submitter-Id:
>Originator:B.L. Choy
>Organization:
>MySQL support: none
>Synopsi
A couple of weeks ago I came across this error which effectively closed down
our site.
Two things:
(1) I am using Perl DBI to interface mySQL is there any way to effectively
capture such errors and provide an alternate web page? I guess there has to
be, but I experimented with the 'PrintError' a
Hi
I have a problem with privileges on MySql NT 3.23.52. I hope that someone
can provide me with a solution.
If a user has USAGE privileges on the mysql db (*.*), and ALL privileges on
another db (CUSTOMDB) in the system, that user can't login nor can they
access the CUSTOMDB. The error reported
On Wed, Aug 21, 2002 at 03:59:20AM +0100, Donna Robinson wrote:
>
> Filter fodder: query, sql
>
> On Wednesday 21 August 2002 3:03 am, Nathaniel Mallet wrote:
> > I haven't read Managing and Using MySQL, but I do own (and read cover to
> > cover) MySQL and mSQL. While it's not a bad book, it's de
> Hi All,
> I am very new with mysql. I have just installed it to Sun OS but there
> is a message " ERROR 2002: Can't connect to local MySql server thought
> '/tmp/mysql.sock' (2)".
> Does anyone have knowledge about problem and help me?
> Regards,
*
99 matches
Mail list logo
