hi guyz
i ve to alter my table n make two fields primary key
(well the combination of the two to be xact)
any idea how to do dis ?
thnx a mill
toby
:S:S:S:S:S:S:S mysql query :S:S:S:S:S:S:S
_
Join the worlds largest
Ok, I've been having this problem every so often and it's happening
more and more these days and I still can't figure out a solution. I
know this sounds vague, but maybe you can help me make it less so...
I'm running version 3.23.44 and after a while, the maximum number of
connections is
Hi,
Does MySQL provide for any way to pad a field? I have accounts numbers
that vary from 3-5 digits, and would like them 8 digits padded by zeros
(479 becomes 0479, 17234 becomes 00017234, etc). I know I could
probably write a script to fix that before entering the data into the
database,
At 15:46 +0200 10/11/02, Alex Polite wrote:
On Thu, Oct 10, 2002 at 05:56:31PM -0500, Paul DuBois wrote:
At 12:58 +0200 10/10/02, Alex Polite wrote:
Is there any way I could display a MySQL database as a filesystem
under Linux?
What does that mean?
What I want is a device that actually
Anthony,
Friday, October 11, 2002, 5:26:39 AM, you wrote:
AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in
AWM this users environment (RH 7.3).
AWM my.cnf has been modified to include individual user, port ,
AWM bind-address and host specifics (and etc) unique to
jfield,
Thursday, October 10, 2002, 1:33:10 AM, you wrote:
jazdc After adding a key to a nullable column, null values will
jazdc successfully join through to null values in other tables.
jazdc This only seems to happen when the index is added after
jazdc the row contains null values. This
Paul,
Thursday, October 10, 2002, 5:59:39 PM, you wrote:
PG i would like to know if row level grants are in development
PG or are planned to be soon.
PG i am writing a software and i need row level grants,
PG so i would like to know if i'd better wait for mysql to include
PG this feature or
Tonino,
Friday, October 11, 2002, 10:05:42 AM, you wrote:
T Just a short question - Does anyone know the progress of stored
T procedure support in MySQL 4
Stored procedures will come in v5.0
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Perumal,
Saturday, October 12, 2002, 11:27:44 AM, you wrote:
P Please anybody could tell me how to start mysql-max to work with DB.
P What i did : start mysqld like
P ./configure --prefix
P =/usr/local/mysqlit starts like
P
I just switched mysql from OSX 10.1.5 to 10.2.1with Marc Liyanage
package but I ran with the following error :
[Ordinateur-de-Pierre-Vaudrey:~] pierreva% mysql
dyld: mysql Undefined symbols:
/sw/lib/libreadline.4.2.dylib undefined reference to _tgetent expected
to be defined in
At 12:58 Uhr +0200 10.10.2002, Alex Polite wrote:
Is there any way I could display a MySQL database as a filesystem
under Linux?
We have created a virtual filesystem using MySQL as storage, using
the LD_PRELOAD version of AVFS. The filesystem logic is written in
Perl (embedded perl
On Thu, Oct 10, 2002 at 05:56:31PM -0500, Paul DuBois wrote:
At 12:58 +0200 10/10/02, Alex Polite wrote:
Is there any way I could display a MySQL database as a filesystem
under Linux?
What does that mean?
What I want is a device that actually is an interface to a db table.
I mount (read
At 10:10 -0400 10/11/02, Michael T. Babcock wrote:
John Ragan wrote:
try corereader. it will run queries against your mysql, oracle,
and ms sql server (and anything else laying around). you can
switch between your servers with a click.
Am I the only one getting tired of these non-SQL
Pretty interesting stuff:
http://www.osnews.com/story.php?news_id=836
http://newsforge.com/article.pl?sid=02/03/22/204220tid=9
Anthony
Anthony W. Marino
Pres./CTO, AWM Objects
David Garamond wrote:
Jan Steinman wrote:
Today's modern operating systems really stopped evolving in the
Is there a way to find out what index an sql query is using? I know you can
use explain, but those are just possible indexes that the query might use.
I'm trying to find out exacly what execution path it is taking. Something
similar to Oracle's set autotrace on;
MySql version -
Tim,
Saturday, October 12, 2002, 1:21:59 AM, you wrote:
TJ I am attempting to delete a table from a database,
TJ then recreate it and load data into the table.
TJ The drop and create commands are working properly,
TJ here's a screen dump:
TJ mysql DROP TABLE IF EXISTS
I had the same problem. No, in MySQL you can't. But
you can use number_format() function of PHP. Check PHP
Manual for How-to
Nikos
--- Putte Koivisto [EMAIL PROTECTED] :
Is there a simple solution to define MySQL to use
comma instead of dot in
numeric fields?
Group,
I have the following query:
select phones.*, ops.plid, ops.box, ops.mac
from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
(phones.suffix1 = ops.phone) order by ops.mac
When I change the order by to a field in the phones table - sorts just fine
and produces
We found the same thing, after installing the glibc auto-rpm from Redhat.
The updated glibc packages from Red Hat will whack your
/etc/nsswitch.conf file. That is, it will mess with the order of how
things are searched for.
We noticed this with mysql not being able resolve remote server IPs.
Description:
Server version 3.23.49-log
Protocol version10
OS Linux atlas 2.4.18-5smp #1
Mysqld two days ago began to crash on accepting non-local mysql connections. After a
day of database testing and debug researching I used the --skip-name-resolve in
Group,
I have the following query:
select phones.*, ops.plid, ops.box, ops.mac
from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
(phones.suffix1 = ops.phone) order by ops.mac
When I change the order by to a field in the phones table - sorts just fine
and produces
At 13:15 +0300 10/11/02, Victoria Reznichenko wrote:
Abhi,
Thursday, October 10, 2002, 8:30:43 PM, you wrote:
A I am not able to connect mysql server after executing this command
A ./safe_mysqld -O key_buffer=64M -O table_cache=256 -O
A sort_buffer=4M -O read_buffer_size=1M
The
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Actually, I remember reading about a mysqlfs system, like that, cd to a table,
ls for records.. rm to remove and such. that was over a year ago at least..
check sourceforge or google, I bet they'd be able to tell more. Archives
might too.
rick wrote:
I know how to make a whole batch SQL script silent (-s option of mysql), but is there
a way within a script to make one or more individual statements silent? In Oracle
PL/SQL, it can be done using echo on/off and termout on/off.
Just for testing, I created a script noecho.sh:
At 11:50 -0400 10/11/02, Edward Peloke wrote:
sql query
when I am defining a table, how do I set the default of a datetime column to
the current time? I tried setting the default to now() but it just fills
the column with 00:00 etc..
You don't. Default values must be constants.
The
Hello All:
I am attempting to delete a table from a database,
then recreate it and load data into the table.
The drop and create commands are working properly,
here's a screen dump:
mysql DROP TABLE IF EXISTS testthis;
Query OK, 0 rows affected (0.16 sec)
mysql CREATE TABLE
At 11:01 +0530 10/11/02, Insanely Great wrote:
Greetings...
I dont think that there is any SQL statement to do that.
As of changing the name, You can just go to the data directory of MySQL and
change the name of the directory of the database. MySQL stores each database
as a directoyr so
ok.
At 10:10 -0400 10/11/02, Michael T. Babcock wrote:
John Ragan wrote:
try corereader. it will run queries against your mysql, oracle,
and ms sql server (and anything else laying around). you can
switch between your servers with a click.
Am I the only one getting tired of these
At 6:58 -0500 10/11/02, rick wrote:
I know how to make a whole batch SQL script silent (-s option of
mysql), but is there a way within a script to make one or more
individual statements silent? In Oracle PL/SQL, it can be done
using echo on/off and termout on/off.
Not really, though maybe
Hi there,
This is an error message from MySQL when I try to connect to my remote
MySQL server. Does anyone know what this message mean. I'm completely
puzzled.
I used to make the same connection with the exactly the same command
routinely get connected easily. But all in a sudden, I cannot
Hi folks,
I am using the MySQL C++ API to put together a football management game.
I wont bore anyone with the implementation details, basically I would
like to know how to distribute the games database so that an end-user
does not need to have MySQL installed to run it. I am running MySQL
There has been such a project for quite a while. Take a look at
http://no.spam.ee/~tonu/ and find the link about SQLFS.
j- k-
On Thursday 10 October 2002 02:58, Alex Polite wrote:
Is there any way I could display a MySQL database as a filesystem
under Linux?
alex
--
Joshua
Group,
I have the following query:
select phones.*, ops.plid, ops.box, ops.mac
from phones, ops where
(ops.box = 'Mcds') or (ops.box = 'Mn3300') and
(phones.suffix1 = ops.phone) order by ops.mac
When I change the order by to a field in the phones table - sorts just fine
and produces
I was wondering, what happens if two programs use the embedded mysql
library and try to access the same database?
Or, what happens if you run the mysql database server on the machine and
use the embedded mysql library to access a database?
how does the mysql lib require the application writer
Chuck,
I have database that has grown in size, I want to see what ID files have
been deleted. Is there a way or do I have to print out the list and find
them myself?
Assuming by files you mean rows, and assuming a table named t1, a column
in it named id, and you having done something like
Dear Sir/Madam,
I have tried the config below, and I successfully see the replicated record in
client side but only ONCE.
After I have seen the replication works. I continued with my normal
transactional work including altering table structure.
But later when I checked the replication status.
At 10:11 -0700 10/11/02, Bryan Koschmann - GKT wrote:
Hi,
Does MySQL provide for any way to pad a field? I have accounts numbers
that vary from 3-5 digits, and would like them 8 digits padded by zeros
(479 becomes 0479, 17234 becomes 00017234, etc). I know I could
probably write a script to
See the ZEROFILL column attribute:
http://www.mysql.com/doc/en/Column_types.html
http://www.mysql.com/doc/en/Numeric_types.html
If necessary, you can use an ALTER TABLE command to add that
attribute to the appropriate columns.
- steve
At 10:11 AM -0700 10/11/02,
Dear sir,
Please anybody could tell me how to start mysql-max to work with DB.
What i did : start mysqld like
./configure --prefix
=/usr/local/mysqlit starts like
Starting mysqld daemon with databases from
Description:
When I create a fulltext index I get:
ERROR 1005: Can't create table './inventory/#sql-4024_116c.frm' (errno: 140)
How-To-Repeat:
alter table inventory.item add fulltext(storeId, catId, itemNo, title,
type, publisher, condition, color, subCategory,
Norris,
Saturday, October 12, 2002, 2:11:36 AM, you wrote:
NJ I have the following query:
NJ select phones.*, ops.plid, ops.box, ops.mac
NJ from phones, ops where
NJ (ops.box = 'Mcds') or (ops.box = 'Mn3300') and
NJ (phones.suffix1 = ops.phone) order by ops.mac
NJ When I change the order
Hello
After a reboot, the database server running Redhat 7.2 and mySQL
3.23.41-1 started acting funny. When I try to telnet to port 3306 of the
server, nothing happens and when i check in the log file for mysql, i
get something like:
Number of processes running now: 1
mysqld process hanging,
Hello,
#If I have a file t.txt
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
111 222 333 ddd 444 ddd
# A table
CREATE TABLE userdata (
a1 varchar(128) NOT NULL default '',
a2 varchar(128) NOT NULL default '',
a3 varchar(128) NOT NULL default '',
a4 varchar(128) NOT NULL default '',
KEY a1
Here's something:
http://no.spam.ee/~tonu/modules.php?name=Newsnew_topic=2
Anthony
Jayce^ wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Actually, I remember reading about a mysqlfs system, like that, cd to a table,
ls for records.. rm to remove and such. that was over a year ago at
Recently our DB, which is running MySQL 3.23.52, started experiencing
intermittant load spikes, of the magnitude of 200+ load averages. Normally,
our high spike is about 0.90 load. When this starts happening, we notice a
lot of processes cleaning up within the database. Can someone clue me in
On Friday, Oct 11, 2002, at 15:21 America/Phoenix, Tim Johnson wrote:
Hello All:
I am attempting to delete a table from a database,
then recreate it and load data into the table.
The drop and create commands are working properly,
here's a screen dump:
mysql DROP TABLE IF
we had the same problem. We had mysql and BIND running on single server.
Upgrading BIND helped to solve this problem.
.:: Andrius Armonas ::.
.:: [EMAIL PROTECTED] ::.
.:: http://baubas.andrius.org ::.
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday,
On Saturday, Oct 12, 2002, at 04:24 America/Phoenix, Pierre Vaudrey
wrote:
I just switched mysql from OSX 10.1.5 to 10.2.1with Marc Liyanage
package but I ran with the following error :
[Ordinateur-de-Pierre-Vaudrey:~] pierreva% mysql
dyld: mysql Undefined symbols:
Hi,
I have database that has grown in size, I want to see what ID files have
been deleted. Is there a way or do I have to print out the list and find
them myself?
Is there a sql or query statement that will let me find them.
Chuck Payne
From: Paul DuBois [EMAIL PROTECTED]
At 12:58 +0200 10/10/02, Alex Polite wrote:
Is there any way I could display a MySQL database as a filesystem
under Linux?
What does that mean?
There's a long (though obscure) history of using database-like engines as filesystems.
There are considerable
Hi there,
Lost connection to MySQL server during query
This is an error message from MySQL when I try to connect to my remote
MySQL server. Does anyone know what this message mean. I'm completely
puzzled.
I used to make the same connection with the exactly the same command
routinely get
51 matches
Mail list logo