On Thu, Jan 24, 2002 at 09:23:28AM -0600, Greg Donald wrote:
> Will MySQL, at any time in the near future, support multi-master
> replication?
Yes. It is being worked on. Well, at least dual-master is.
> What we need is a way to combine databases from different machines
> back onto one databa
On Wed, Jan 23, 2002 at 02:32:49PM +0300, Artem V. Ryabov wrote:
> Hello mysql,
>
> Why query type
>
> select count(*) from table_name where key_field between 'min' and
> 'max' so slow?
>
> example:
>
> mysql> select count(*) from Textes where ID between 7937 and 45061;
> +--+
> | count
On Tue, Jan 22, 2002 at 10:12:55AM -0600, Solsberry, Glendon wrote:
> I have mySQL v3.23 running on a Mandrake 8.1 box (AMD 1600XP, 512MB
> RAM). The problem is that the main query (listed below) takes
> approximately 3 hours to run.
[snip]
Wow! Thanks for all the detail.
> The query is this
On Wed, Jan 23, 2002 at 05:40:24PM -0500, Keith C. Ivey wrote:
> On 23 Jan 2002, at 14:20, Jeremy Zawodny wrote:
>
> > I think that what you want is really:
> >
> > http://www.mysql.com/doc/U/p/Update_log.html
>
> Why do you say that? As I understand it, the update log records only
> querie
On Tue, Jan 22, 2002 at 12:13:10PM +0530, sreedhar wrote:
> Dear all,
>
> Is there any equivalents to ROLES in SQL-Server in MySQL.
Not really, no.
Have you already seen the documentation for MySQL's privilege system
in the manual?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Ya
On Tue, Jan 22, 2002 at 02:28:32PM -0500, Wendell Dingus wrote:
> You might have just hit the nail on the head.. Server1 is
> replicating everything to server2 but it is only saving changes to
> one particular database. Those changes are being manually gathered
> via mysqlbinlog and sent to serve
On Thu, Jan 10, 2002 at 05:35:04PM +0100, [EMAIL PROTECTED] wrote:
> Jeremy,
>
> Reading through the TOC, it sounds like a book I'd definitely buy!
Great!
> At 15:58 2002-01-10, you wrote:
> >2. How to cover "common problems" in a way that folks can find them
> > without reading the whole boo
On Fri, Jan 25, 2002 at 03:12:02PM +0900, Mitsuru Hirai wrote:
> Hello.
> What would be the most effective way to compare 2 databases to see
> if they are identical? This is for the replication. We would like
> to check if a slave DB is identical to the primary DB.
What, you don't trust it?! :-
On Fri, Jan 25, 2002 at 01:05:12PM +0530, Chetan Lavti wrote:
>
> I am going to use the MySQL version 3.23.47 for as our database.
> The issue is which table type to use.
>
> I want that the database should be (memory-resident). I have tried
> with the MyISAM tables which doesn't solves my purpos
hi,
I am going to use the MySQL version 3.23.47 for as our database.
The issue is which table type to use.
I want that the database should be (memory-resident). I have tried with
the MyISAM tables which doesn't solves my purpose as in this case the
data are stored in the files.
I have also tried
Hi,
I have problem with join and order clause. I have 2 table join with
amount condition and sort by order clause. The result of this join
generate unwanted row to me.
example
table1
No. Amount Count
1 1000 2
Are there platforms other than Windows (OS/2, perhaps?) on which MySQL
is able to use named pipes?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 22 days, processed 511,767,
Hello.
What would be the most effective way to compare 2 databases to see if
they are identical? This is for the replication. We would like to check
if a slave DB is identical to the primary DB.
Thank you very much.
Mitsur Hirai
On Thu, Jan 24, 2002 at 07:34:14PM -0800, Steven Roussey wrote:
>
> In honor of Jeremy:
> MySQL 3.23.47-log: up 5 days, processed 595,464,211 queries (1,350/sec.
> avg)
> :)
Very nice!
Fast and using a recent version. I really need to upgrade one of
these days. I keep meaning to get my slaves
>Description:
"configure: error: No size for char type.
A likely cause for this could be that there isn't any
static libraries installed. You can verify this by checking if you have libm.a
in /lib, /usr/lib or some other standard place. If this is the problem,
On Friday 25 January 2002 10:35, Hery Yulianto wrote:
> Hi Brothers or Sisters,
> I need to know, how to configure MySQL can be support unicode like Chinese
> (simplified and Traditional), Croation,Chezh or whatever.
>
> I using PHP programming and needed can transaction with Chinese character.
>
Hahaha. This is a static database. But you are right I don't know
how much this will actually help. Hard disk isn't an issue. It was
just an experiment...(that I have no time for anyway!)
Thanks,
Michael
On Friday, January 25, 2002, at 06:19 PM, DL Neil wrote:
> ...and because no one has
On Fri, Jan 25, 2002 at 01:06:12PM +1030, Graham wrote:
> I have looked at the documentation and have been unable to locate any
> information in respect of calculated fields.
> Can anyone verify the lack of this feature in mysql or point me to the area
> of the documentation which discusses
> them
> Is this just something we have to live with or does
> MySQL 4 handle this better?
Something to live with. Someday, I'm sure MySQL will optimize this case.
Conceptually its not that hard. You split it into multiple queries that
track an index. If it is a select, you also UNION the results back
In the last episode (Jan 25), Graham said:
> I have looked at the documentation and have been unable to locate any
> information in respect of calculated fields. Can anyone verify the
> lack of this feature in mysql or point me to the area of the
> documentation which discusses them if the are ind
I have looked at the documentation and have been unable to locate any
information in respect of calculated fields.
Can anyone verify the lack of this feature in mysql or point me to the area
of the documentation which discusses
them if the are indeed included.
If they are not available has anyone
Hi Brothers or Sisters,
I need to know, how to configure MySQL can be support unicode like Chinese
(simplified and Traditional), Croation,Chezh or whatever.
I using PHP programming and needed can transaction with Chinese character.
Thank you for explain to me
Best Regard,
Hery
--
Anyone,
Are there any other good mailing lists out the about databases?.. If so, can
you post the site where i can sign up for them?
Thanks,
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Anyone,
Are there any other mailing lists about databases out there? If so, can you
post a link to their site where i can register?
Thanks,
Mike
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Just for the record, found the glitch: somehow, somebody on the way decided
to change LF's into CRLF's (I remotely dumped the data and e-mailed it
locally where I test the setup process, so maybe the mail agent?). I just had
to replace 0x0d0a's into 0x0a's in a hex editor and everything works
Is this just something we have to live with or does MySQL 4 handle this
better?
Brian.
- Original Message -
From: "Andrew Schmidt" <[EMAIL PROTECTED]>
To: "Brian Moon" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, January 24, 2002 3:11 PM
Subject: RE: Slow updates with two key
Hi all!
I bumped in a strange problem.
I dumped a help table (i.e. only text) into a file. The table contains two
fields: a "topic" (unique) field and a "content" field. Then performed a
"LOAD DATA INFILE" on the resulting file in a different database with
identical structure. Everything work
...and because no one has been really cynical...
After that query runs, then prepare for a coffee overload whilst you perform the ALTER
TABLE, then get ready
because if you shorten the field to (say) 12 characters/bytes the very next day,
someone with a 13 character
name is going to try to regi
I will be putting variable length text into a field (up to 255 characters
but typically around 60 characters) and wonder what makes for faster
retrieval? Or does it matter? A field defined as Varchar(255) or Text? It
is unlikely this field will be used for searching and it will not be
indexed
I actually have all the records in a 1GB text file, so here comes perl
to the rescue!! (Easier than C to me, maybe I'll do it in Java as an
exercise.)
BTW if anyone has any questions on the ability of MacOS X with medium
size DBs. This DB is running on a 500Mhz iMac G3 with 1GB of RAM and
M
On Thu, Jan 24, 2002 at 12:19:12PM +0200, Oleg Prokopyev wrote:
> Ken Menzel wrote:
> >
> > Hi Oleg,
> > There is some sort of thread problem with freebsd but it usuually is
> > not that bad. How did you compile MySQL? I would recommend using the
> > ports version of Mysql (cd /usr/ports/data
At 05:58 PM 1/24/2002 -0500, Michael Stearne wrote:
>The problem is, this query really hurts (I don't know if it finishes) for
>unindexed field for 2.9 million rows. But I'm sure it will finish eventually.
Yes, it will really hurt. After all, there's no way for MySQL to do this
other than pul
Does anyone have a best practices for efficiently storing md5 hash
values in MySQL?
Since it is a 32 character string of hex numbers, I originally stored
them in a char(32) binary column. But that is wasted space (by a factor
of 2). And of course, these things add up, both in data files and
inde
The problem is, this query really hurts (I don't know if it finishes)
for unindexed field for 2.9 million rows. But I'm sure it will finish
eventually.
Michael
Roger Karnouk wrote:
>select max(length(firstname)) from TableName;
>
>-Original Message-
>From: Michael Stearne [mailto:[EM
Acck!
Yes, please please do that. O(n) instead of O(n^2) (*). This is a much
better solution.
I was trying to convert 'there exists n such that for all m where n != m,
n >= m, return n'. Damn logic.
(*) To be honest, I'm not even sure what the runtime of my original query
was. A good qu
select max(length(firstname)) from TableName;
-Original Message-
From: Michael Stearne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 24, 2002 4:38 PM
To: Christopher Thompson
Cc: [EMAIL PROTECTED]
Subject: Re: Tighly packed table
Christopher Thompson wrote:
> At 04:10 PM 1/24/2002
On Thu, 24 Jan 2002, Shankar Unni wrote:
> Should we take this offline?
>
> The Redhat packaging for MySQL calls it "mysql" (lowercase). MySQL AB's
> packaging calls it "MySQL" (upper/mixed case). The layout in each of those
> packages is quite different.
But that wasn't the problem.
> So ver
A quick question. When creating a table that will hold values generated
by the password() function, what kind of column should this be stored
in...I am assuming VARCHAR(?). Could someone kindly tell me the length?
I've skimmed the whole manual and I can't find any reference to this.
Thank you!
Hi!
CHECK TABLE does not do anything on BDB tables.
On InnoDB and MyISAM tables CHECK TABLE tries to verify the physical
consistency of the table and its indexes.
The way to repair InnoDB or BDB tables is to dump, drop, and reimport them.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order techn
On Thu, 24 Jan 2002, Shankar Unni wrote:
> Jim Lucas [jimmysql] wrote:
>
> > But I am installing all the apps from the RPM's that came from Redhat.com
> > and Mysql.com and with the Redhat CD. Now shouldn't these all work
> > together?
>
> Reasonable people would expect that, yes, but evidentl
Jim Lucas [jimmysql] wrote:
> But I am installing all the apps from the RPM's that came from Redhat.com
> and Mysql.com and with the Redhat CD. Now shouldn't these all work
> together?
Reasonable people would expect that, yes, but evidently the folks at Redhat
are not talking to the folks at
Christopher Thompson wrote:
> At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote:
>
>> We have a somewhat large read-only table (2.9 million recs). I am
>> wonder if there is a utility that will look at each row of each
>> columns and come up with a summary of the largest field (in character
>
On Thu, 24 Jan 2002, Jim Lucas [jimmysql] wrote:
> Is this what you had to do?
No, I don't do it. If you stay with the stable version of MySQL, you avoid
this problem. MySQL 4 will show up in Red Hat Linux (at least the
development tree when it's declared the) stable branch, and applications
Is this what you had to do? If so, could you point me to a location on the
web or in a book store to aquire knowledge on how to "compile" new software.
I have only compiled one piece of software, Courier Mail Service. It was
interesting!
But, I feel that I would need a little more help with all
At 04:10 PM 1/24/2002 -0500, Michael Stearne wrote:
>We have a somewhat large read-only table (2.9 million recs). I am wonder
>if there is a utility that will look at each row of each columns and come
>up with a summary of the largest field (in character length) for each
>column. For example,
On Thu, Jan 24, 2002 at 04:06:57PM -0500, Michael Stearne wrote:
>
> When doing selects on a read-only myISAM packed table, are varchar
> fields still slower than char fields?
Since it's essentially a MyISAM table with compression done at the
row-level, I'd expect so. But the difference has to b
Sorry... trying to get a lot of info out without a lot of text...
lkup_info is populated when data is loaded, and data is loaded
daily... so MAX(date) would work fine with sub selects, which
don't exist... though I have an auto increment field as well.
I guess I will just have to keep a s
MySQL can only use 1 index per query. So take your first query for example:
update forum set approved='N' where id=644122 or thread=644122
it can only use the id key OR the thread key, not both. and since you have an 'or'
in your query MySQL must scan the entire table for either id being 64
We have a somewhat large read-only table (2.9 million recs). I am wonder
if there is a utility that will look at each row of each columns and
come up with a summary of the largest field (in character length) for
each column. For example, scan each row's firstname field and report
that the lon
When doing selects on a read-only myISAM packed table, are varchar
fields still slower than char fields?
Thanks,
Michael
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
Sounds like you have a table (lkup_info) of load dates (date), in which you
record fileid (did) and date. Sounds like you do not have a separate table
of fileids. I'm assuming that the lkup_info table is updated synchronously
with the loading of each file that the table is recording, though y
I have pasted below some queries and a table structure that I am finding to
be very slow.
As you can see, if I or the two keyed fields, the query takes ~7 seconds.
If I just run them by themselves, it takes no measurable time.
Is this something we just have to live with? Or, is there something
Hello,
I am using Visual C++ 6.0 and I have some linking
problems while trying to run the example program
MFC_ex.cpp included in the downloading files in the
mysql.com website.
Here are the errors I get:
Configuration: MFC_ex - Win32
Debug
Linking...
MFC_e
I'm trying to increase the maxium number of connections to my MySQL database
but I am not sure how to do this. I've gone to the manual and it doesn't
say too much (maybe i'm looking in the wrong spot?). The machine I'm
running is an AMD 650 with 512 Ram on RedHat 7.1 and MySQL 3.23.41 so I
found
how can i select a join and then use the resulting table in another
join? i did it with a temporary table, but is there a way to do it with
a single compound statement? thanks in advance!
-
Before posting, please check:
htt
Hi all MySQL'ers,
We have finally completed our initial public version of the DataBreeze
Web Application system that uses MySQL as the underlying SQL database.
The system requires Linux(or unix), Apache, Perl, ModPerl and MySQL.
As this is a MySQL specific system, feedback from the MySQL communi
Of course not ;)
I only run myisamchk -a on several table, and I noticed sometime a similar
message (although the tables seem to work perfectly)
Jocelyn
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "Fournier Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTE
On Thursday 24 January 2002 11:44 am, Sinisa Milivojevic wrote:
> >?(2) Can someone give me an idea what these correspond to:
> >?
> >? ? ?Connect Out
Slave connecting to master.
--
MySQL Development Team
For technical support contracts, visit https://order.mysql.com/
__ ___ ___
I don't know of any changes that happened right at the time that it went
down. Now, the box _was_ rooted :-), but I *think* mysql going down was
independent of that. Since then I've reinstalled every rpm on the system,
so it should be clean. MySQL hangs as I install the rpm for it though as
soo
MySQL 3.23.41 on Solaris
Is it possible to select only the latest entries
from a table?
For instance I have a table of datasets that get
loaded each day. I want to find the latest date that
each dataset was loaded.
I thought maybe a join against itself might be the
answer, but this does
hi.
i'm trying to benchmark pgsql living in cygwin on a 2K box with mysql
installed normaly on windows. i get:
C:\mysql\bench>perl
run-all-tests --host=PAVILION --server=Pg --user=n
--password=x --log --comment "2x Pentium II 400mz, 256M, under
vmware"
Got error: 'connect
http://mmmysql.sourceforge.net/
On Thu, 24 Jan 2002, Rahadul Kabir wrote:
> hi,
> I recently installed MySQL3.23.47 and now I need the JDBC drivers for
> it. Does anyone know where can I find a Free JDBC driver that would work
> with MySQL 3.23.47-1?
> thanks so much
>
> --rahad
>
>
> -
hi,
I recently installed MySQL3.23.47 and now I need the JDBC drivers for
it. Does anyone know where can I find a Free JDBC driver that would work
with MySQL 3.23.47-1?
thanks so much
--rahad
-
Before posting, please check:
On Wed, 23 Jan 2002 16:53:47 -0800
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> In sql/sql_parse.cc:72 (roughly), a list of command names is defined:
>
> const char *command_name[]={
> "Sleep", "Quit", "Init DB", "Query", "Field List", "Create DB",
> "Drop DB", "Refresh", "Shutdown", "S
Jacob Friis Larsen wrote:
>I found files whith names like "localhost-bin.001", "localhost-bin.002" in
>/tmp/
>What are they ?
>
Log files.
>
>
>Also, what does it mean that my MySQL database version is 3.23.47-log. What
>
It means it is logging.
>
>does "-log" mean ?
>
>Regards Jacob
>
>[ w
Ooops!! This seems to be a bug in EMS MySQL Manager... Sorry to bother
you all...
Regards
Peter
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: do 24 jan 2002 18:51
To: Peter Bremer; Mysql (E-mail)
Subject: Re: Problem with UPDATE and User Variables
At
Kalok,
Thursday, January 24, 2002, 6:51:26 PM, you wrote:
KL> I'm having the same need.
KL> It looks like the following is intended for MyISAM tables only:
KL> http://www.mysql.com/doc/U/s/Using_mysqlcheck.html
KL> Has anyone else had any other luck ?
Sometimes mysqlcheck works for BDB tables.
I found files whith names like "localhost-bin.001", "localhost-bin.002" in
/tmp/
What are they ?
Also, what does it mean that my MySQL database version is 3.23.47-log. What
does "-log" mean ?
Regards Jacob
[ www.sharksforum.com | www.eksperten.dk | +45 70 27 07 67 ]
--
At 18:32 +0100 1/24/02, Peter Bremer wrote:
>Hi,
>
>Can anybody explain why the following does not work?
>
> SELECT @variable := value1;
> UPDATE table SET field1 = @variable WHERE field2 = value2;
>
>The result is always that field1 is set to NULL...
Works for me, if I substitute a real valu
Christopher Thompson writes:
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> For various reasons, I need a C++ API to MySQL for use in Windows (and
> possibly Linux as well). I know I can find one or two in the
> downloads/contrib section but I'm looking for suggestions.
>
> I'm quit
Hi, I'm new at the Database Maintenance Role.
Can anyone tell me what are the basic things that need to be done to keep my
database healthy ?
i.e. I've heard that it's good to regularly rebuild indexes. How frequently
should that be done ?
And what is the best way to go about it.
- Origi
At 05:19 PM 1/24/2002 +, [EMAIL PROTECTED] wrote:
>I've installed Mysql on my machine, two of my machines, one on win98 and
>other on windows 2000. But for some reason when the developer is trying to
>run any query from a VB applications, it tends to slow and hang both the
>machines. I 'm try
What if you run SQL questons from MySQL command line?
What SQL questons are you trying to run?
Simon
PS yes MySQL if very fast
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 24 January 2002 17:19
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Mysql very s
Hi,
Can anybody explain why the following does not work?
SELECT @variable := value1;
UPDATE table SET field1 = @variable WHERE field2 = value2;
The result is always that field1 is set to NULL...
Regards,
Peter Bremer
Hi,
I've installed Mysql on my machine, two of my machines, one on win98 and
other on windows 2000. But for some reason when the developer is trying to
run any query from a VB applications, it tends to slow and hang both the
machines. I 'm trying to use mysql as its supposed to be faster and bett
>Next question:
>
>How do you increase that variable?
Check the manual:
http://www.mysql.com/doc/S/e/Server_parameters.html
> Also, is there a number that is
>generally considered too high or does that depend on the server you are
>running MySQL on? (an example would be GREAT!)
It depends:
mysql, database
http://shop.barnesandnoble.com/booksearch/results.asp?WRD=MySql&userid=6AF42
HL01D
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
Victor,
Thursday, January 24, 2002, 10:59:03 AM, you wrote:
VHRV> Hi there.
VHRV> Im having some troubles with mysql and FULLTEXT.
[]
VHRV> Now, I have the next rows:
VHRV> ID NAME KIND
VHRV> 1Boby Asiatic and colored
VHRV> 2Linda Amer
Hello Chetan,
CL> hi,
CL> I wanted to set variable query_cache_size..
CL> I have tried for this as in below but the machine hangs up every time i
CL> am doing this...
CL> Any other method by which I can set this Variable..?
Try to run safe_mysqld in background mode.
CL> shell> mysqld -u root --
I'm having the same need.
It looks like the following is intended for MyISAM tables only:
http://www.mysql.com/doc/U/s/Using_mysqlcheck.html
Has anyone else had any other luck ?
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, Januar
I have seen this question a couple times on the mailing list, but have
not seen a legitimate answer except a link to the website it can be
downloaded. I have downloaded and set everything up for MyVBQL, but I
am new to databases in general and have no idea where to start to even
try to connect. I
Next question:
How do you increase that variable? Also, is there a number that is
generally considered too high or does that depend on the server you are
running MySQL on? (an example would be GREAT!)
thanks.
- Original Message -
From: "Roger Baklund" <[EMAIL PROTECTED]>
To: <[EMAIL PR
log into the mysql command line, type
show variables
and look for
max_connections
In the last episode (Thursday 24 January 2002 11:24 am), Jay Paulson wrote:
How do you know what the maximum connections you can have at one time with
mysql?
--
* Jay Paulson
> How do you know what the maximum connections you can have at one time with
> mysql?
mysql> show variables like "max_connections";
--
Roger
query, table
-
Before posting, please check:
http://www.mysql.com/ma
How do you know what the maximum connections you can have at one time with
mysql?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To requ
http://www.mysql.com/doc/R/e/Resetting_permissions.html
after starting mysql with the --skip-grant-tables, you'll have to
execute a grant statement
http://www.mysql.com/doc/G/R/GRANT.html
GRANT ALL PRIVILEGES ON *.* TO root@localhost INDENTIFIED BY
'somepassword' WITH GRANT OPTION;
then rest
Please help. I accidentally deleted the root user and now I can't do
anything. How can I recreate this user with super user privileges? I'm
new to MySQL so please be detailed.
Thanks in advance
Lisa
-
Before posting, pleas
Will MySQL, at any time in the near future, support multi-master
replication? We're looking at splitting some very large databases up among
several machines, but we need a way to bring them back together for our
stats creation databases on the backend.
What we need is a way to combine databases
These are the items that iam interested in selling..
Could you help me with some details on the goods, history, origin etc.
are these worth anything and if so who would i contact with regards to
selling them? and the best way to sell them ie auction etc
APOLOGISE IF YOU HAVE ALREADY RECEIVED THIS
Ives,
Thursday, January 24, 2002, 5:04:09 AM, you wrote:
IS> Hi there,
IS> yesterday my mysql server (running under irix) has gone away
IS> and took one table with it
IS> so i tried to recover the data with isamchk -o table_name
IS> unfortunalty during the recoveryprocess half of the data
IS> w
Roman,
Thursday, January 24, 2002, 2:36:45 PM, you wrote:
RZ> i create table from script:
RZ> create table if not exists msg00m1 (
RZ> id int primary key auto_increment,
RZ> hid int not null,
RZ> dsg char(10) not null,
RZ> nt char(7) not null,
RZ> gn char(2) not nu
Princy,
Thursday, January 24, 2002, 3:23:24 PM, you wrote:
PT> Hi !
PT> I did try using the mysql client gui but you cant create indexes thru that.
PT> Also, since I've exported from access, the datatype all seem to be
PT> MEDIUMTEXT.
PT> So, when I try the create index syntax,
PT> ie, CREATE
Rahadul,
Thursday, January 24, 2002, 12:17:17 AM, you wrote:
RK> Hi,
RK>I installed MySQL version 3.23.47. It starts up and stop when i
RK> use the following command
RK> /etc/rc.d/init.d/mysql start
RK> /etc/rc.d/init.d/mysql stop
RK> Bu I attem to start /usr/sbin/mysqld server and edit
Alex,
Thursday, January 24, 2002, 1:15:38 AM, you wrote:
AS> How to check disk space been used for all of the tables of a specific
AS> mysql account?
In general, you cannot check that. But tables are just files
residing in the datadir - you can check the size of the files.
AS> Alex
--
Manish,
Thursday, January 24, 2002, 8:57:01 AM, you wrote:
MM> Hi
MM> i have 3.23.32 version of mysql. i wants to export the database from
MM> \mysql\bin\
MM> please tell.
If you would like to export database, use mysqldump:
http://www.mysql.com/doc/m/y/mysqldump.html
If you would like to mov
Diana,
Wednesday, January 23, 2002, 7:33:35 PM, you wrote:
DS> Maybe you did not execute FLUSH PRIVILEGES or run mysqladmin
DS> flush-privileges to tell the server to reload the grant tables.
DS> Until this, your changes will not take effect.
There is no need to run "mysqladmin reload" or "FLU
Matthew,
Thursday, January 24, 2002, 12:30:13 AM, you wrote:
MD> thanks a simple but effective explination.
You can insert whatever you want in that field - here applies all
the rules of a primary key. But when you insert zero (or nothing),
the database server will insert the next available f
Angela,
Thursday, January 24, 2002, 11:15:46 AM, you wrote:
AH> With an older MySQL-Version this construction worked fine but with the
AH> new one not at all:
AH> "SELECT ... ORDER BY RAND() LIMIT 1"
This should work fine. I think there are problems in your
statement where you have put "..."
Alessandro,
Wednesday, January 23, 2002, 9:43:00 PM, you wrote:
>> How did you install MySQL? Is it the binary distribution from MySQL or you
>> have compiled the software from the sources?
AT> I used the rpm inside the SuSE's distribution.
Download the binary distribution from http://www.my
Hello
What do to if mysql_use_result return NULL ? I can't understand ?
I have only one query by connection, of course.
I talk about SELECT statement in my query (not INSERT or anything else)
Mysql run on linux.
>From time to time mysql_use_result() return NULL.
I throw and catch an excepti
1 - 100 of 135 matches
Mail list logo