Hi,
IM>I'm not either sure if they're used during normal operation, but that way
you
IM>could get a file number like (x / 3) + [a few files] where x is the
number of
IM>files with MyISAM. Also, InnoDB should support .frm:less tables someday
in
IM>2003 (at least www.innodb.com says so). But if you
On Fri, Sep 27, 2002 at 01:37:24PM +0930, David Lloyd wrote:
>
> What's the advantages of using Embedded MySQL instead of, say, Berkely's
> DB?
Well, the SQL interface is probably the biggest advantage. There is
no query language for Berkely DB, so ad-hoc queries are time-consuming
to code.
--
Hello all,
We use MySQL 3.23.51 on a NT Server and a Win2000 Server.
On the Win2000 server all works fine. But wen we install MySQl on the NT
Server
CPU Usage goes through 100% for a while (20-30 seconds).
What could be the reason of this?
And how can we fix it?
Regards
Peter Zuidema
[EMAIL PR
On Thu, Sep 26, 2002 at 11:24:14AM -0700, Gary Traffanstedt wrote:
> sql,query
>
> I have a table that has approximately 40 colums and all but 1 of
> them I have been able to make fixed width. The sole hold out is of
> the type "TEXT" and needs to be able to hold approximately 1000
> characters.
On Thu, Sep 26, 2002 at 11:52:52AM -0500, Pete Harlan wrote:
> On Wed, Sep 25, 2002 at 08:49:43PM +0300, Iikka Meril?inen wrote:
> > Hello,
> >
> > If the number of files is your concern, have you considered using InnoDB? It
> > spans tables across any number of data files you want. The performan
HI!
there is a problem in mysql database.there r two
tables.one table is named as transactions and the
other is named as the code.the transactions table has
got the 12 fields which r the following 1.clientid int
2.date date 3.isinno text 4.debit int 5.credit
int 6.desc text
7.dpid1 text
In the last episode (Sep 26), zxcv said:
> MySQL status:
>
> Threads: 1 Questions: 1860358 Slow queries: 5 Opens: 2004 Flush
> tables: 1 Open tables: 256 Queries per second avg: 0.524
>
> MySQL show status:
>
> | Table_locks_immediate| 3052077|
> | Table_locks_waited | 0
Hi Ivan
Make sure that you have the image in the path you have specified.
I checked it mysel and below are the results.
Even if the size exceeds, a truncated data should be there.
So it is evident, you are doing wrong with your path or the image is not
there.
mysql> create table tblob( title var
Greetings,
I am indeed in a very strange situation, to me at least. We've got a
good-sized database (about 60gb) over 4k tables. We average about 300
queries per second. We've recently noticed some strange behavior at around
430 connections. We get the "unable to create new thread (errno 11)
dear kayamboo,
i've tried it, but seems there still something strange with this matter, so
i decided to create one table with myisam table type (default table type),
and i try to input data in this table. but when i check this up (do query) i
have null value in mediumblob field (pic).
this is th
Hello all,
MySQL 3.23.51
Apache 1.3.26
In my php connection to MySQL I send a message if there is a problem.
Today for the first time in 3 years of MySQL/Apache use I received the
following error message:
[26-Sep-2002 15:49:14] ERROR: Couldn't connect to the DB while drawing the
main page qui
On Thu, 2002-09-26 at 18:28, Mihail Manolov wrote:
> mysql < datadump.sql
Thanks, I finally found it. the mysql manual doesn't have anything about
exporting/importing, I was using the wrong words for searching.
--
Chip
> - Original Message -
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PR
What's the advantages of using Embedded MySQL instead of, say, Berkely's
DB?
[mysql, query]
DSL
--
Qualcuno no mi basta.
Vivere cercando il grande amore.
Vivere come se mai dovessimo morire.
(Anastasio, Valli e Travato)
-
At 02:08 AM 9/20/2002, you wrote:
>Hi all,
>
>
>anyone knows a good method to retrieve 1 random selevted record out of
>thouseands?
>
>right now I'm using
>
>select ID from table ORDER BY rand() LIMIT 1
>
>however, this seems like a very slow method, like mysql first organizes a
>few thousand reco
I get the following error using either the 3.0 or 3.01 jars of the
Connector/J:
com.mysql.jdbc.NotUpdatable: Result Set not updateable. The query that
generated this result s
et must select only one table, and must select all primary keys from
that table. See the JDBC 2.1 API Specification, secti
I need some help with a slight problem I'm having getting my data to display
to the correct page. What I'm trying to do is allow users to post data to
some pages on my site and make that data available for viewing.
So far I have it so that I can connect to the db and post the data to the
table. I
Hello MySQL,
I am re-sending this message as it seems like the one I send the
20th did not go through. I have now read a larger part about the
possibly SQL 2003 standard, and am convinced this will really be of
importance for the future of MySQL as well. The standard is not just
ANSI, b
Try:
SELECT fieldname FROM table ORDER 0+fieldname;
Hope it helps.
Mihail
- Original Message -
From: "John Almberg" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 8:04 PM
Subject: SQL question
> I'm trying to sort a table on a character-type
mysql < datadump.sql
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 4:44 PM
Subject: db dump question
> I need to copy a database and all its tables and contents to a backup
> server. The server
> they live on is on an ISP, the
I'm trying to sort a table on a character-type field that contains mostly
numbers. This field always contains either a number or a number followed by
a character. Like '57' or '57a'.
I'd like to sort the table *numerically* on this field, not *alphabetically*
on this field. That is, I'd like the
Hi
After installing MySQL-3.23.52-1.i386.rpm the following is displayed:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h password 'new-password'
See the manual for more instruction
Since you have already dumped the structure and data to a file all you need to
do is paste the contents of that file to mysql. You could also use phpMyAdmin
(since you mentioned using it) to load the entire text file - look under
the 'SQL' tab (in more recent versions).
Quoting [EMAIL PROTECT
Hi everyone,
I'm using the select query shown below to extract some data from mysql.
Everything works fine until I try to retrieve anyone with a double
nationality, i.e. "Swiss/Italian".
Do I have to escape the "/" somehow? (If I have to, how?)
Any comments or hints on where to look up that pro
Hello all,
How do I stop a query once it has started without quitting the MySQL client?
I have a MySQL daemon and client (v3.23.36) running on a RedHat Linux 7.1
box. I ran a query that joined two large tables (>300K rows each) on
columns that I had forgot to index. When I pressed Ctrl-C, thi
Hi Andrew and Richard,
The password and connection info is scrambled up. You can look, If
you want to check it out for your self look in the source code of
./mysql-3.23.XX/libmysql search for the following functions.
especially in 'mysql_real_connect' function. It is not the best
method, but
Robert Fox wrote:
>Hi Frank-
>
>I'm new to the MySQL world, and I am also a DBA with an Oracle background.
>This was a surprise to me as well. However, the only solution that I know
>of is to encapsulate your SELECT elements in a Concat() function. So, your
>SQL statement would be:
>
>select c
Bug Report:
Version: 3.23.51-max
OS: Windows ME
Problem:
Synopsis: Does not use index when ordering records on datetime field in
the descending order, even though though this field is NOT NULL.
I created the following table:
CREATE TABLE Threads (threadID int NOT NULL PRIMARY KEY,
On Thursday 26 September 2002 12:35 pm, Andrew Braithwaite scribbled something
about:
> Hi Bence,
>
> We are running mysql with over 1,000 tables - plenty of them have 10
> Million to 40 Milion records (Geographic data) - about 500 concurrent
> sessions doing about 800 to 1000 queries total per s
Hello Victoria,
I have installed mysql 3.23.49 for Sorlaris and I have installed it
from the source distribution.
Do you have any idea about my problem?
Thanks :-)
Victoria Reznichenko wrote:
>Vaso,
>Thursday, September 26, 2002, 9:54:06 AM, you wrote:
>
>VK> I have started mysql server keepin
I need to copy a database and all its tables and contents to a backup
server. The server
they live on is on an ISP, the server I want to back the up on is in my
office in another town.
I can access the ISP's server via phpMyAdmin and dump the data to a .sql
file, but then
what do I do to recre
At 20:46 26/09/2002 +0200, MySQL wrote:
>Hi all,
>
>I'm a DBA in the Oracle World.
>
>I want to make a sql query in mysql, with a concat (||) known i Oracle
>world.
>
>Like this.
>
>select numer ||','|| text from Table:
You need to specify the keyword CONCAT and enclose it in brackets,
like this:
Hi Frank-
I'm new to the MySQL world, and I am also a DBA with an Oracle background.
This was a surprise to me as well. However, the only solution that I know
of is to encapsulate your SELECT elements in a Concat() function. So, your
SQL statement would be:
select concat(numer, text)
from tab
Hi!
- Original Message -
From: ""Orr, Steve"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 9:56 PM
Subject: RE: MyISAM or InnoDB
>
>
> MySQL doesn't provide "native" support for transactions but is dependent
on
> the Berkeley or InnoDB table
Please read following text only with koi8-r codepage!
---cut---
mysql> DROP TABLE IF EXISTS COUNTRIES;
Query OK, 0 rows affected (0.02 sec)
mysql> CREATE TABLE COUNTRIES (Name varchar(30) NOT NULL DEFAULT 'n/a',
-> PRIMARY KEY (Name) );
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INT
You almost answered your own question. In mysql you use the concat()
command:
select concat(number,',',text) from Table
On Thursday, September 26, 2002, at 03:17 PM, MySQL wrote:
> Hi all,
>
> I'm a DBA in the Oracle World.
>
> I want to make a sql query in mysql, with a concat (||) known i Ora
I installed the MySQL-3.23.52-1.i386.rpm packet on my RedHat 7.3 server
machine.
Installation went OK, then it told me to change my root password by typeing:
/usr/bin/mysqladmin -u root password newpasswd
But i cant find mysqladmin at /bin/ directory! I cant find it no where.
Is is loacted som
Here's an update on this issue: The problem is when copy/pasting
Japanese characters into MySQL, certain characters are being corrupted.
I've ruled out Word as the problem.
I've ruled out my content tool as the problem.
I've ruled out the ASP display page as the problem.
I've configured my Reg
From: MySQL <[EMAIL PROTECTED]>
> select numer ||','|| text from Table:
SELECT CONCAT(numer, '||', text) FROM Table;
---
Rodney Broom
President, R.Broom Consulting
http://www.rbroom.com/
-
Before posting, please check:
I am new to mySQL (and this list), and trying to implement it into our
application.
I am having trouble with the search syntax.
My regular SQL, I was using (from MS SQL 2000)
WHERE title LIKE '%#form.search#%'
OR content LIKE '%#form.search#%'
This doesn't seem to work in mySQL.
I have tried
There are common one-way encryption, like md5, this is commonly what I do, I
encrypt with md5 when I insert the password into my database on the DB
server, and then I encrypt with PHP on the Web server side, so therefore, I
am only ever sending my md5 encrypted password over the "wire". Since it
Concat and Concat_WS from the mysql web site
CONCAT(str1,str2,...)
Returns the string that results from concatenating the arguments.
Returns NULL if any argument is NULL. May have more than 2 arguments. A
numeric argument is converted to the equivalent string form:
mysql> SELECT CONCAT('My', '
>My host is running 3.22.5 on a redhat. Im trying to log in and use the
>LOAD command but I cant get past 'ERROR 2002: Can't connect to local
>MySQL server through socket '/tmp/mysql.sock' (2).'
>
>I connecting remotely with putty and sshing in on port 22. at command
>prompt I was told by host to
Hi Frank,
You can use the concat() function:
select concat(numer, ',', text) from Table.
The online docs for MySQL contain a great reference for functions:
http://www.mysql.com/doc/en/Functions.html
--jeff
> Hi all,
>
> I'm a DBA in the Oracle World.
>
> I want to make a sql query in mysql,
:I want to make a sql query in mysql, with a concat (||) known i Oracle
:world.
:
:Like this.
:
:select numer ||','|| text from Table:
Instead, try the following:
SELECT CONCAT(number, ',', text) FROM Table;
-
Before
Hi,
You need to use :
Select concat(numer,',',test) from table;
See: http://www.mysql.com/doc/en/String_functions.html for more.
Cheers,
Andrew
-Original Message-
From: MySQL [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 26 September 2002 19:47
To: [EMAIL PROTECTED]
Subject: Mysql
Hi,
Well, why not trying... concat() :)
SELECT concat(numer,',',text) FROM Table;
http://www.mysql.com/doc/en/String_functions.html
Regards,
Jocelyn Fournier
- Original Message -
From: "MySQL" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 8:46 PM
Subj
Hi Bence,
We are running mysql with over 1,000 tables - plenty of them have 10 Million
to 40 Milion records (Geographic data) - about 500 concurrent sessions doing
about 800 to 1000 queries total per second at peak.
We haven't had any problems in the last 2.5 years. (our system is read heavy
&
Yes, I've also tested the LIKE 'abc%' but forgot to include it in my mail :)
CREATE TABLE `threadhardwarefr12` (
`numeropost` mediumint(8) unsigned NOT NULL default '0',
`numreponse` int(10) unsigned NOT NULL default '0',
`pseudo` varchar(35) NOT NULL default '',
`date` datetime NOT NULL
Jocelyn,
- Original Message -
From: "Jocelyn Fournier" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 9:53 PM
Sub
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tried the same on mysql, bu
BTW, I assume Monty's change means that MyISAM tables are able to not use
filesorting on
"WHERE key_name1='constant' ORDER BY key_name DESC "
type queries whereas InnoDB tables are not able to do so ?
e.g. :
mysql> ALTER TABLE threadhardwarefr13 type=innodb;
mysql> EXPLAIN SELECT LOWER(pseudo),da
Heikki, Jeremy,
FYI, I've just tested latest pull (including Monty's patch) without Heikki
1.1318 changeset (Remove the flag HA_NOT_READ_PREFIX_LAST because ORDER BY
orders wrong then;) and now it works perfectly fine :
mysql> SELECT LOWER(pseudo),date,numreponse FROM threadhardwarefr12 WHERE
nu
Hi Sean,
> "If expr is given as an arguement to LAST_INSERT_ID(), the value of the
> arguement is returned by the function, is set as the next value to be
> returned by LAST_INSERT_ID(), and is used as the next AUTO_INCREMENT
> value"
I don't think this entire statement is correct. The onlin
Hi all,
I'm a DBA in the Oracle World.
I want to make a sql query in mysql, with a concat (||) known i Oracle
world.
Like this.
select numer ||','|| text from Table:
Where the output will be eg.
1,HI
2,Frank
And so on
Hope one of you can see my problem. I've tried the same on mysql, bu
Jeremy,
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: "Jocelyn Fournier" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Thursday, September 26,
sql,query
I have a table that has approximately 40 colums and all but 1 of them I have
been able to make fixed width. The sole hold out is of the type "TEXT" and
needs to be able to hold approximately 1000 characters. The reason why I want
it to be a fixed width field is for speed and
Hi,
Sounds to me like the mysql server isn't running (check with your
administrator & ask him/her to start mysql).
If the server is running and you enter the wrong info, you should get the
following message..
ERROR 2000: Access denied for user: 'cbslink@localhost' (Using password:
YES)
Cheers,
Greetings...
I believe MySQL is stable and fast enuf for your puprpose. And its pretty
easy to start up.
Insane
- Original Message -
From: "Bence Szabo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 7:52 PM
Subject: what about the stability?
> Hi,
> Thi
Hello,
Start your mysqld with --safe-show-database parameter (or edit your my.cnf,
respectively).
Regards,
Iikka
On Thu, 26 Sep 2002, Saleem wrote:
> Hi,
>
> I have mysql-3.23.32-1.7 machine, and the problem I have is that is that
> all users are able to see all databases in mysql
How can I
Hi,
My understanding is that it sends it plain text, then mysql encodes it
server-side & does the match. There is client-server ssl planned soon
though...
Cheers,
Andrew
-Original Message-
From: Richard Fox [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 26 September 2002 16:18
To: [EMAIL
I am sure I am going to feel ignorant when I get the answer to this question
because it will be something simple that I have overlooked, but here goes
anyhow.
I am using MySQL Version 3.23.51-max.
I am developing an N-tier application using Java on the server side
accessing MySQL through JDBC.
>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:
You can try stunnel for forcing the connection through ssl. Works with
most tcp applications transparently.
On Thursday, September 26, 2002, at 12:40 PM, John Holmes wrote:
>> I am connecting to a mysql server on a remote machine, and opened up
> port
>> 3306 for this purpose. But, I am conc
On Wed, Sep 25, 2002 at 09:43:13PM +0300, Heikki Tuuri wrote:
> Jocelyn,
>
> below the latest patch which puts the code as it was in 4.0.3. Some LIKE
> 'abc%' ... DESC queries may return wrong results, but this is the best we
> can get to 4.0.4.
>
> I have to ask Monty about the use of HA_READ_P
Hi,
My host is running 3.22.5 on a redhat. Im trying to log in and use the
LOAD command but I cant get past 'ERROR 2002: Can't connect to local
MySQL server through socket '/tmp/mysql.sock' (2).'
I connecting remotely with putty and sshing in on port 22. at command
prompt I was told by host to "
Hi,
I'm not either sure if they're used during normal operation, but that way you
could get a file number like (x / 3) + [a few files] where x is the number of
files with MyISAM. Also, InnoDB should support .frm:less tables someday in
2003 (at least www.innodb.com says so). But if you bump into p
On Wed, Sep 25, 2002 at 08:49:43PM +0300, Iikka Meril?inen wrote:
> Hello,
>
> If the number of files is your concern, have you considered using InnoDB? It
> spans tables across any number of data files you want. The performance is
> great, too.
The .frm files are still there, though, one per fi
Hi,
I have mysql-3.23.32-1.7 machine, and the problem I have is that is that
all users are able to see all databases in mysql
How can I restrict
each user to only view the database he's been assigned permission for?
Thanks in advance!
Saleem
---
Maybe you could somehow setup your SSH tunnel before-hand
(at server start up or something) and use that instead.
Adam Voigt
[EMAIL PROTECTED]
On Thu, 2002-09-26 at 12:40, John Holmes wrote:
> > I am connecting to a mysql server on a remote machine, and opened up
> port
> > 3306 for this purpos
> I am connecting to a mysql server on a remote machine, and opened up
port
> 3306 for this purpose. But, I am concerned about sending a clear text
> password, via the mysql_pconnect() call. My question is, what is the
> procedure for connecting to a remote server with an encrypted
password?
> Or
MySQL doesn't provide "native" support for transactions but is dependent on
the Berkeley or InnoDB table types.
Does MySQL really provide TRUE row level locking? That's the claim but is it
valid? The InnoDB web site seems to be more accurate by explaining that
locking is a next-key value locki
On Thu, Sep 26, 2002 at 10:31:06AM +0100, Andrew Bryant wrote:
> We have 125 million smallish images (each one is tens of KB, produced by
> gene sequencing machines). Currently we store these in tarfiles and
> index the images (the offset in the tar file) using an Oracle
> database. Each tarfile
I've read a bit about using LAST_INSERT_ID(expr)
to set the next auto_increment value.
my question is, if i have 2 tables, like follows
CREATE TABLE A (
id int not null auto_increment primary key,
...
)type=MyISAM;
CREATE TABLE B (
id int not null auto_increment primary key,
...
)type=MyISAM;
I would highly recommend a simple design:
1) Create a large filesystem on your drive(s) using ReiserFS (because of fast file
finding capabilities).
2) Create a table that has one entry per image with an auto_increment primary key.
3) Insert a new record every time you 'store' an image, grab the
Hi,
I am connecting to a mysql server on a remote machine, and opened up port
3306 for this purpose. But, I am concerned about sending a clear text
password, via the mysql_pconnect() call. My question is, what is the
procedure for connecting to a remote server with an encrypted password? Or,
do
>From: Iikka Meriläinen <[EMAIL PROTECTED]>
>To: toby - <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: mysql all messedup ... :'( .
>Date: Thu, 26 Sep 2002 17:26:10 +0300 (EEST)
>
>Did you check Egor's last message to you on the list? After starting mysqld
>with --skip-grant-table
William,
Wednesday, September 25, 2002, 11:26:20 AM, you wrote:
WM> Can someone tell me if I can load only one column of data from a tab
WM> delimited text file into MySQL 4.0?
If this column is first in the text file, yes. But you get warnings.
WM> If so, then can I assume that I can
WM> load
Did you check Egor's last message to you on the list? After starting mysqld
with --skip-grant-tables you should be able to connect with this:
mysql -u root
on the server, otherwise use mysql -u root -h your.server.ip.address
It won't be of much help if you can't get 'root' working. Please try to
Vaso,
Thursday, September 26, 2002, 9:54:06 AM, you wrote:
VK> I have started mysql server keeping binary logs and once in a while I
VK> execute "reset master".
VK> Irregularly mysqld crashes and in the error logs I read the lines
VK> bellow:
VK> mysqld got signal 11;
VK> This could be because y
CREATE TABLE TableC SELECT tableA.field1,table1.field2,tableB.field1
FROM tableA,tableB WHERE joinCondition
That should do it, if I got the syntax correct. You do want to use the
create/select combo though.
On Thursday, September 26, 2002, at 12:59 AM, Jack wrote:
> Dear all
> i had two table
u think that d make much of a difference
:( ...
i cant work with the thing any more yaar
rather cant make it work .
the thing that i waz actually playin with last week ... :S
and i jst cannot recall how i handled it last time i installed it on n all
...
though i had my myadmin's config
Hi,
I am trying to install pam_mysql but seem to have a dependency problem.
This is the output from make:
lawrence:/usr/local/pam_mysql # make
mkdir -p ./dynamic
gcc -O2 -Dlinux -DLINUX_PAM -ansi -D_POSIX_SOURCE -Wall -Wwrite-strings
-Wpointer-arith -Wcast-qual -Wcast-align -Wtraditional
-Wstri
Hi again,
Sorry, you _did_ mention your MySQL version... wrote the reply in quite a
hurry. Why aren't you using the latest version (3.23.52)?
Iikka
On Thu, 26 Sep 2002, toby - wrote:
> ok guys
>
> i ve actually done it fo myslf ... :'(
> mysql s all screwedup ...
> i reinstalled it last n
Hi,
Er, I don't want to be rude, but those dots drive me crazy.
Could you include more details? What version of MySQL running now? Running as
a service r from the command line? You can't even log in? What does MySQL
client say? I suggest using the command line client for early troubleshooting,
j
Pascale Lunal wrote:
> Dear Joseph,
>
> Thank you for your quick reply. The MERGE function may do the trick but
> then I would have to type the name of the 50 tables ! The idea was to
> avoid having to type evey single table. Also, what will happen if new
> tables are created ? I'll have to re
> Hi,
>
> can anyone tell me how can i set the default datetime as current
> datetime in the mysql. so that every time i insert a record in the table
> current datetime automaticall inserted.
> Thanks in advance.
>From MySQL manual section 6.5.3:
"Default values must be constants. This means, fo
antispam,
Wednesday, September 25, 2002, 7:04:03 PM, you wrote:
afn> Hi Victoria..
Hi!
First of all answer to the mailing list, not to me.
afn> thanks.. for the mail.. i feel confident now.. i dont have log or backup..
could you please
afn> tell me how to turn on logs ??
Check the followi
Patrick,
Thursday, September 26, 2002, 3:38:24 PM, you wrote:
PF> I'm new to MySQL. I've been able to query the database via PHP and display
PF> it within a html page. I would like to out put the results to a flat file
PF> tab delimited instead of onto a new page.
Use SELECT INTO OUTFILE:
Daya,
Thursday, September 26, 2002, 7:53:46 AM, you wrote:
DKD> can anyone tell me how can i set the default datetime as current datetime in
DKD> the mysql. so that every time i insert a record in the table current
DKD> datetime automaticall inserted.
DKD> Thanks in advance.
Take a look at TIMES
tl,
Thursday, September 26, 2002, 3:44:30 PM, you wrote:
t> Please help me "mysqldump":
t> ON:
t> mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1 > database.gz
t> I have an error :
t> mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm'
(errno: 24) when u
toby,
Thursday, September 26, 2002, 2:53:08 PM, you wrote:
t> i ve actually done it fo myslf ... :'(
t> mysql s all screwedup ...
t> i reinstalled it last night and myadmin too ... now ...
t> ive created two users and databases n ...
t> wolla
t> i cnt even login ... :'(
Start MySQL serv
Mann,
Wednesday, September 25, 2002, 10:29:55 PM, you wrote:
MJ> Hello all, I am brand new to MySql and I wanted to know if you could
MJ> recommend any books that are a good start on learning the mechanics of
MJ> MySql. Thanks!
Paul DuBois's book "MySQL" :) It's really a good book.
Searchable
weng,
Thursday, September 26, 2002, 3:05:25 AM, you wrote:
wc> i've installed ver 3.23.47 sa win2k pero di ko sya
wc> mstart as service..
wc> if i type this==>mysqladmin create database01
wc> ERROR==>mysqladmin: connect to server at 'localhost'
wc> failed
wc> error: 'Can't connect to MYSQL ser
Sridhar,
Wednesday, September 25, 2002, 6:11:30 PM, you wrote:
>> SP> Currently i get around this issue by analyzing the BDB tables, but this
>> SP> seems to be a temporary solution. The issue is intermittent, keeps
>> SP> surfacing
>> SP> again after a certain no of days. Did not find any relate
Clayburn,
Thursday, September 26, 2002, 3:58:13 AM, you wrote:
CWJI> I create a table with a VarChar field set to not null. When I do an
CWJI> insert into this table with no value for this field it goes through
CWJI> without a problem. I realize MySQL inserts a empty string into the
CWJI> fie
CP,
Thursday, September 26, 2002, 11:00:10 AM, you wrote:
C> I am trying to do a master-slave replication on mysql-3.23.42. My master is
C> sitting on a FreeBSD machine and the slave is running in a Red Hat Linux 7.1
C> machine.
C> From the log, the master-slave connection is okay, but the slave
Is it possible to run the new MySQL 4.0.3 on a system that uses glibc-2.1.3,
especially the MySQL-shared?
/Klaus
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi!
Could you send me the file /mysql/sql/ha_innodb.cc so that I could check
what assertion fails in your snapshot of the source tree?
Thank you,
Heikki
Innobase Oy
- Original Message -
From: <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 12:3
[EMAIL PROTECTED] wrote:
>
>
> > When I am trying to install mysql-shared-4.0.3 on a redhat
>
> > 6.2 system with kernel 2.2.19, i get following dependenci
>
> > problem I need glibc 2.2, i need the mysql-shared in ordre
> to
> > get the php-mysql modul to work.
> >
> > How can i fix this
Please help me "mysqldump":
ON:
>mysqldump --opt --user=user_name -pPassword _stat_ | gzip -1 > database.gz
I have an error :
>mysqldump: Got error: 1017: Can't find file: './_stat_/_stat_193_219_2_250.frm'
>(errno: 24) when using LOCK TABLES
Thanks very much.
-
1 - 100 of 126 matches
Mail list logo
