I'm looking for a simple CRM (adresses / contacts / orders)
system using MySQL as a back-end. If anyone on this list
has developed (or have knowledge of) a system with the
following requirements, please drop me a message.
- MySQL *must* be the backend (for integration w/ other
company data)
-
On Thu, Sep 06, 2001 at 06:08:00PM +0800, Chun-Hung Chen wrote:
> When configuring mysql, some errors happened.The report of config.log
> and error messages are listed below.The environment I use is Sun Solaris
> 8(SunOS 5.8) with gcc 2.95.3.
[snip]
> configure:2376: checking return type of spri
On Wed, Sep 05, 2001 at 03:43:00PM -0500, Jeff Adams wrote:
> Greetings,
>
> This morning we sucessfully inserted a new record on our master
> MySQL machine. 4 1/2 hours later, the change showed up on the
> slaves. I was under the impression that MySQl replication would
> occur in a more timely f
On Wed, Sep 05, 2001 at 01:33:03PM -0700, A. Clausen wrote:
>
> I've been running a master/slave MySQL database system for about
> four months now and I've got nearly 360mb of binary logs. I want to
> archive anything over about a month old, but I've heard that there
> is a procedure that you hav
On Thu, Sep 06, 2001 at 12:36:12PM -0700, Duc Chau wrote:
>
> I just wanted to know how stable is mysql databse replication is?
> What we have in mind is a tiered system.
>
> $master (california)-<(internet ssh tunnel)
> \$slave (texas)<
> 10 other slav
scott.alexander writes:
> > Why would I loose(sic) all of a sudden my autoincrement feature on a table.
Did it pass CHECK TABLE, and if not did REPAIR TABLE help?
If not, try myisamchk -o, but make sure you're not using the
table when you do it.
//C
--
Carl Troein - Círdan / Istari-PixelMag
On Thu, Sep 06, 2001 at 04:35:57PM -0700, Aaron Brick wrote:
> good day -
>
> i have found cases in which the daemon blocks waiting on a select() and
> just plain refuses to process certain queries. since i am reading in a 60
> meg file, meaning about 3.5 million queries, this consistently happen
Hi all,
How can I retrieve mysql admin password if I forget it??
Rgds,
unplug
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reque
Hi all
I was just getting thru the documentation of MySQL at the mysql.com
site and there it is specified that
"The recommended way to install MySQL on Linux is by using an RPM file"
Can anyone tell me in what way it is different installing mysql from the
rpm's and from the source code ??
exc
Ken writes:
> Query question:
>
> Can anyone think of a way to accomplish this in a single query?:
>
> I have a table with elements that each have a date.
> For a given record, I want to get, in one query, the record just earlier than this
>record's date, and the record just later than this r
On Fri, 7 Sep 2001, scott.alexander wrote:
> Hi,
>
> Why would I loose all of a sudden my autoincrement feature on a table.
>
> I have not changed the table definition and all of a sudden I get
> DUPLICATE ENTRY for KEY 1 errors.
>
BTW it is of type INT and the last entry was only 22700.
Below i
Hi,
Why would I loose all of a sudden my autoincrement feature on a table.
I have not changed the table definition and all of a sudden I get
DUPLICATE ENTRY for KEY 1 errors.
thanks
Scott
-
Before posting, please check:
h
> SELECT COUNT(*) as count, hostname FROM host_list GROUP BY hostname ORDER
BY
> count DESC
>
>
> here is my current output
> 283 host1
> 210 host2
> 200 host10
> 110 host 3
> .
> 1 host941
>
>
> what I would like to do is list say just the hosts that have greater then
> Im managing to do this, but I can see that the method im using is
> not as efficient as it could be. What I want to do is this
> Make a query which will grab the record in a table that has the
> highest ID number. The ID field is auto incremental so what its
> saying is that the record with
Sorry I am new to SQL and any help would be greatly appreciated
Here is my table
CREATE TABLE host_list (
number mediumint(9) NOT NULL auto_increment,
date datetime NOT NULL default '-00-00 00:00:00',
hostname varchar(75) NOT NULL default '',
PRIMARY KEY (number)
) TYPE=MyISAM;
h
This is what I use in those situations:
select * from TABLE_NAME order by ID desc limit 1;
On Fri, Sep 07, at 01:43pm, Chris Aitken ([EMAIL PROTECTED]) wrote:
> Hi all,
>
> Just quickly,
>
> Im managing to do this, but I can see that the method im using is not as
> efficient as it could be.
On Thu, Sep 06, 2001 at 11:07:25PM -0700, Chadrick Mahaffey wrote:
[...]
> shell> cd mysql_installation_directory
> shell> ./bin/mysql_install_db
> shell> ./bin/safe_mysqld --user=mysql &
>
> what does all this mean? I tried to type this in my command console changing
> / to \ and I don't unders
> I know these are pathetic questions to most of you so please have patience
> with a Windows user...
Hehe, welcome to the world of the command line...
> what is "shell>"?
In windows world, this is the 'MS-DOS Prompt'. Will probably look like this
to you:
C:\>
In unix, it is typically something l
I dont know if it's me or what but that Manual is driving me crazy just
searching! I cant find out how to copy a table and rename it at the same
time. pls help
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, ple
On Thu, 6 Sep 2001, Chadrick Mahaffey wrote:
> I realize that I'm going to be in the minority here but I have to say it.
> Open source would go much farther if they had self explanatory GUIs and had
> basic pre-setup apps that were ready for the average user to use.
Perhaps your company should
Hi all,
Just quickly,
Im managing to do this, but I can see that the method im using is not as
efficient as it could be. What I want to do is this Make a query which
will grab the record in a table that has the highest ID number. The ID
field is auto incremental so what its saying is that
Sorry - had to get that out of my system before I begin. I just downloaded
the latest MySQL and installed it in my f:\mysql dir on my windows machine.
I read the documentation and realize that I am lost even before I get
started. Believe me I don't want to be...
I have been an MS Access user for
Hello all,
I have searched the archives and found various suggestions and tired
them (and variations of them) and I cannot get "mysqld" running on Mac
OS 10.0.4 (Darwin 1.3.7).
I had previously built and run 3.23.39 on the same machine, but I cannot
get 3.23.41 running - it built and install
Hello all,
I'm working on a tcsh script (using MacOSX 10.0.4) that performs a mysql
query and pipes the output to the mail command.
When I execute the script from the command line as root, it executes
perfectly.
However, when I allow the script to execute via /etc/crontab, (which is
what I r
Sounds like a left join, maybe even a "natural join", which I haven't tried yet.
select message
from project left join daily on project.uid = daily.uid
order by timestamp
Check manual for syntax.
Or am I missing something?
- Ken
[EMAIL PROTECTED]
At 05:47 PM 9/6/01 -0700, Michael Garvin wrote
Ok, we just can't seem to find a solution for this problem. Thought I'd
post it up to see if anyone has any input.
Say you have 2 tables project_notes and daily_notes.
Each table has a timestamp, and a user_id.
Is there any way, in one query, to select all messages from both tables
that were e
I have been having consistent problems with index corruption using BDB
tables in the 3.23.38 source version. Looking at the Change Log entries for
3.23.40, i think upgrading may help me out. Does anyone have a more detailed
explanation of the bugs addressed by these two fixes:
Changes in release
Query question:
Can anyone think of a way to accomplish this in a single query?:
I have a table with elements that each have a date.
For a given record, I want to get, in one query, the record just earlier than this
record's date, and the record just later than this record's date.
I can easily
good day -
i have found cases in which the daemon blocks waiting on a select() and
just plain refuses to process certain queries. since i am reading in a 60
meg file, meaning about 3.5 million queries, this consistently happens
somewhere in the middle. i am using 3.23.41.
restarting the server o
At 3:45 PM -0700 9/6/01, Anthony E. wrote:
>I have a tabdelimited file with 10 cols, and want to
>only import 5 of them with LOAD DATA INFILE.
>
>I know how to define which cols go where in the mysql
>table, but this assumes i want to import every column
>from the tabdelimited file.
>
>How do I ig
I have a tabdelimited file with 10 cols, and want to
only import 5 of them with LOAD DATA INFILE.
I know how to define which cols go where in the mysql
table, but this assumes i want to import every column
from the tabdelimited file.
How do I ignore certain cols from the import file?
ie - tab.t
At 6:17 PM -0400 9/6/01, Christopher Bergeron wrote:
>How can I delete a file from disk if it exists from mysql?
You can't do this.
> If it's not
>possible, how can I append to an existing datafile? is there an append
>function using SELECT * FROM DATA INTO OUTFILE "filename";
No. In f
>I have a tab delimited file from a spreadsheet that
>has a field "Name" (includes first and last name).
>
>I am importing the file into a table that has
>"firstName" and "lastName" as seperate fields.
>
>Is there a way to split the field from the text file
>"Name" into two different fields in the
How can I delete a file from disk if it exists from mysql? If it's not
possible, how can I append to an existing datafile? is there an append
function using SELECT * FROM DATA INTO OUTFILE "filename";
-
Before posting, pl
Thank you to everyone who helped. That enum worked great and right after I
posted I checked the manual again for the columns and got it. Once again,
thanx, and I'll post more here. Anyway, the true false thing was for a
members section of my web site that says that if they confirmed their email
Maybe I should add that I run:
OS:
Linux 2.2.18 (Slackware 8.0)
mysql --version :
/usr/local/mysql/bin/mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686)
Hardware:
intel Pentium 133, 96Mb memory
/Mattias
>Hi!
>
>I've just installed (a couple of days ago) mysql.
>I will use mysql for u
That would be a tough one - you'd first have to make sure every single record has no
more than two "words" in that field. there's no guarantee that a field "name" would
actually always contain only two names, or even two names at all. When I get stuffy, I
spell my name as "A. Marjolein Katsma"
Hi!
I've just installed (a couple of days ago) mysql.
I will use mysql for using with hlstats. That is
a stats-program for HalfLife Counter Strike. (game)
But I got errors... I guess it's a problem with mysql
or me not knowing how to do it.
Here is some printouts what I'm trying to do:
mysql>
I have a tab delimited file from a spreadsheet that
has a field "Name" (includes first and last name).
I am importing the file into a table that has
"firstName" and "lastName" as seperate fields.
Is there a way to split the field from the text file
"Name" into two different fields in the databas
Hello All,
I came accross an interesting delima today after working on a client's database,
they are using MySQL 3.23.32 on a linux box. The database had 12 tables in it,
and almost all of them where displaying the corrupted table handler error, these
where ISAM tables. Now I used isamchk to repa
At 22:53 06.09.01, you wrote:
>mysql> SELECT receiver_id, associate_of, user_name FROM receivers;
>+-+--+-+
>| receiver_id | associate_of | user_name |
>+-+--+-+
>| 1 |0 | arnold |
>| 2
Someone the other day said this worked:
started safe_mysqld with --skip-grant-tables and then did:
mysql -u root mysql
mysql> UPDATE user SET password=PASSWORD('abc') WHERE User='root'
-> AND Host='whichever host you want to match'
- Original Message -
From: "Mike Ryerse" <[EMAIL P
Agreed, however, my question was, is "@@IDENTITY" recognized by mySQL, I
just need to create something that can be easily convertible from MS-SQL to
mySQL, etc. and so each difference needs to be documented.
-Original Message-
From: Dana Powers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, S
Balazs Szemes wrote:
> Hi,
> It is a recursive table design, meaning that a person can have a boss. The
> boss' id is stored in the associate_of column. Eg. elmer is barney's
> associate, barney is boss of elmer, and diana
>
> Let's say I only know the user_name 'barney', and I would like to sele
LAST_INSERT_ID() is similar. It will give you the value for autoincrement
fields. Note that this is connection dependent ( so your last_insert_id() is
not the same as my last_insert_id() ). You would do something like this:
INSERT INTO tablex ( columnx ) VALUES ( 'valuex' );
INSERT INTO tabley (
Hi,
Please help me with a query. I looked in the documentation w/o success.
Consider this table:
mysql> SELECT receiver_id, associate_of, user_name FROM receivers;
+-+--+-+
| receiver_id | associate_of | user_name |
+-+--+---
I think what you see is the fact that x86systems have overtaken
workstations in some respect.
have a look at spec.org for specint (which should be most relevant for
databases)
the same is true for memory throughput (look out for streambench)
At 01:13 PM 9/6/2001 -0700, Floyd Mann wrote:
>Hello
"Joshua M. Schmidlkofer" wrote:
> Of course. you COULD use Python, cleaner that Perl(tm) [jk no flames
> please]
Sorry. If you don't program in hex assembly you are a wussy and you drink light
beer.
> How is your ex-hell [excel] file being generated? Is it a .csv or is it
> actually an X
On Thu, Sep 06, 2001 at 12:50:47PM -0700, Adams, Bill TQO wrote:
> Mike Ryerse wrote:
>
> > I have resently installed mysql 3.23.41 on Redhat 7.1
> >
> > When I installed it, I could access the example
> > databases 'mysql' and 'test'. Mysql said to change
> > the root password right away with :
Ok
The problem are that I have checked this command but
after I insert the root (unix root) and not the db
root.
Thanks you very much !
Emiliano
--- Sheena Sidhu <[EMAIL PROTECTED]> wrote:
> emiliano ,
> the reason you cannot use mysql to connect to
> use mysql database but can
> us
I have never tested with your magnitude - no where near that. You obviously
would have one maching connected to the master per sub-network-cluster. [thus
calling it tiered =].
I have tested over a network, using artificial packet destuction (for good
measure), from a Linux box, running th
Hello -
This week we moved from running MySQL 3.23.33 on a Dual PIII 750 machine to
running MySQL 3.23.41 a Sun E220 Dual UltraSparc || 450 machine. Both
machines have 1 Gb of RAM, both machines are dedicated to running MySQL,
both keep data and log files on seperate SCSI drives, and both are ru
Access and MS-SQL Server have a method called @@IDENTITY used in retrieving
the last inserted ID of a recordset. Is mySQL ok with that command. I
suppose I could try it, but I'm interested in views etc. also.
Dave Carter
Chief Web Architect
Accelerated Business Technologies, Inc.
http://www.abti
Of course. you COULD use Python, cleaner that Perl(tm) [jk no flames
please]
The advantage of Python, is that if you are using excel, you could go from
excel [via python] into MySQL. Or you could use Python in much the same way
that one could use Perl to process the log file. Of course
Hi !!!
Scuse me if before I insert few data to analize the problem :-)
Now
at the shell I insert the command 'mysql' then at the prompt of mysql if I
insert the command 'connect test' this work and I can use sql command to work
on the database. If I else insert 'connect mysql' (the other db
Mike Ryerse wrote:
> I have resently installed mysql 3.23.41 on Redhat 7.1
>
> When I installed it, I could access the example
> databases 'mysql' and 'test'. Mysql said to change
> the root password right away with :
> mysqladmin -h host -u root -p password 'new password'
Note, do not put a sp
I was just browsing through the searchable online MySQL manual, trying to
find a list of the aggregate functions (as I don't trust the list in the
O'Reilly book, considering the number of typos and missing information in
other sections), and couldn't find anything.. Is there a list in the
manual?
I just wanted to know how stable is mysql databse replication is? What we
have in mind is a tiered system.
$master (california)-<(internet ssh tunnel)
\$slave (texas)<
10 other slave machines on
the same network
Mike Ryerse wrote:
> I have resently installed mysql 3.23.41 on Redhat 7.1
>
> When I installed it, I could access the example
> databases 'mysql' and 'test'. Mysql said to change
> the root password right away with :
> mysqladmin -h host -u root -p password 'new password'
THis will fail sin
I have resently installed mysql 3.23.41 on Redhat 7.1
When I installed it, I could access the example
databases 'mysql' and 'test'. Mysql said to change
the root password right away with :
mysqladmin -h host -u root -p password 'new password'
so I did it, but now mysql won't let me log in as an
Hi!
I found the following from www.greatbridge.com (the principal
PostgreSQL support company).
Regards,
Heikki
Innobase Oy
...
Great Bridge ceases operations
Open source pioneer closes after failing to identify a qualified investor or
acquirer
NORFOLK, Va., September 6, 2001 Great Br
Shouldn't Max_data_length on a heap table be the same as the
max_heap_table_size variable as long is max_rows is not set? My heap table can
grow up to about 200mb. If I set the limit max_heap_table_size at 256MB,
Max_data_length ends up being around 110MB. This gives me the 'table is full'
error
The queries were...
> > select * from cookies left join users on cookies.uid=users.uid left join
> > sessions on users.uid=sessions.uid where
> > cookies.cookie="e3bd03382561eb3619b66fbea2af217d";
> >
> > select * from cookies left join users on cookies.uid=users.uid left join
> > extended on
Dear Kyle,
Thank you for your response.
What I was attempting actually led to a security hole for clients.
I am implementing your method instead as it appears to be a solution which
would work well.
Thanks so much for such a detailed response.
Best regards,
Mustafa.
- Original Message --
Hi, can someone tell me how the index number on the bin logs are
incremented?
When i update my master machine the changes are still going to
$machine-name-bin.001
on my slave
its looking for Log_file
$machine-name-bin.002
can someone tell me how these number are incremented? the .00#
how
> A better solution would be to do it in /etc/my.cnf, so that it will be
> system-wide.
BINGO!!! That did it!
The only additional question I have at this point, then, is what to do
about
my scenario where I want to run 3.22 and 3.23 concurrently on a box where
the user will be the same for
> create a .my.cnf in the home directory of the user that will be running
> the clients, and enter a
> [client]
>
> paragraph that defines the socket.
A better solution would be to do it in /etc/my.cnf, so that it will be
system-wide for the database.
--
Ed Carp, N7EKG - [EMAIL PROTECTED] - 2
create a .my.cnf in the home directory of the user that will be running
the clients, and enter a
[client]
paragraph that defines the socket.
BW wrote:
> Ed,
>
>
>> 1. Is MySQL actually running?
>
> Yes.
>
>
>> 2. If so, where is it putting mysql.sock?
>
> It is putting it into /raid/mysq
[EMAIL PROTECTED] writes:
> First, if there is an FAQ or installation documentation please direct me
> there and I'll review before requesting assistance.
>
> If there is neither, I am unable to successfully run mysqlgui on the
> following platform: Sun Ultra 10 running Solaris 8 with current
> R
Ed,
> 1. Is MySQL actually running?
Yes.
> 2. If so, where is it putting mysql.sock?
It is putting it into /raid/mysql/data/mysql41.sock -- I specified this
location in the socket variable(?) in both [client] and [mysqld] sections of
the my.cnf file. my.cnf is located in /raid/mysql/data; there
As Ed said, you need to make sure that ld.so.1 is in your path.
At 09:03 -0500 2001/09/06, Ed Carp wrote:
>Isn't there an ldconfig or similar for Solaris? You'd need to configure /etc/ld.so
>(or whatever the equivalent is on Solaris), then run ldconfig to tell the run-time
>library loaded where
Michael,
Have a look at the thread "Can't get MySQL running on Win2K" (started by me) - I have
it working now (thanks Heikki!) and the solution might be of use to you as well.
At 08:27 2001-09-06 -0700, Michael Tam wrote:
>Hi all,
>
>I have uninstall mysql3.23.39 from Win2k and after I ins
Heikki,
Thanks a lot for your help! This mail list is a great resource (but I knew that
already ;-))
Now that I have moved the whole [mysqld] section from C:\my.cnf to R:\Win2000\my.ini
and rebooted, everything has started to work - the service now starts automatically.
(If something else wil
Paul DuBois wrote:
>
> At 6:54 AM -0500 9/6/01, Ed Carp wrote:
> >Igor Brynskich ([EMAIL PROTECTED]) writes:
> >
> >> First, thanks to everyone who interested in our product -- EMS MySQL
> >> Manager -- and answered to our previous announce!
> >>
> >> This message intended for shed light on so
Henning Schroeder wrote:
> At 17:52 06.09.01, you wrote:
>
> >It is copying ALL of the results into the temp table. If you can (e.g.
> >you know you will
> >never want more than N records), add a LIMIT 0,N to the end of the SELECT
> >so that when you
> >have an old timestamp it will not hang the
At 17:25 06.09.01, you wrote:
>Or ENUM:
>ALTER TABLE myTable CHANGE COLUM myColumn ENUM( 'T', 'F' );
>
>Of course if you are using this to drive a web page Mike's solution is better.
> Or you would want to enum( 1, 0 ) or enum( '1', '' );
yes, but do *not* use enum('t','f') because with some fo
Mike wrote:
> Is there a way to continualy update a MySQL database with an Excell file?
>
> Reason:
>
> Just to have some fun I am building a Code Red hall of shame in PHP and
> MySQL. I am anoyed from cleaning XX's and NN's all day in my Apache
> logs.And they call Open software Virul...
>
>
At 17:52 06.09.01, you wrote:
>It is copying ALL of the results into the temp table. If you can (e.g.
>you know you will
>never want more than N records), add a LIMIT 0,N to the end of the SELECT
>so that when you
>have an old timestamp it will not hang the database.
as i use
select count (
I beleive this is a bug in mysqlshow:
I have a database with an underscore in it's name (which is valid), but
mysqlshow thinks I'm trying to do a wildcard and lists databases which match
the pattern instead of showing what I want it to show. For instance:
"If last argument contains a shell or SQ
How can one rectify the following?
Warning: Access denied for user: 'myuser@localhost' (Using password: YES) in
/usr/home/lee24/html/therapytables/new/lib/dblib.php on line 24
Can't connect to localhost as myuser
MySQL Error: Access denied for user: 'myuser@localhost' (Using password: YES)
Thi
Hi!
Is there a way or command for mysql that shows me
a) what tables are currently locked
b) with what kind of lock
c) which query caused the lock
d) and maybe how long the lock exists?
I usually try to figure out via mysqladmin processlist and look for the one
query that isn´t locked as the c
At 08:27 06/09/2001 -0700, Michael Tam wrote:
Hi,
When you get this type of error, do the following process:
- Verify in your SCM the state of the service. You should
see that it isn't initiated.
- Open a DOS screen at \mysql\bin
- Remove the service: mysqld-max-nt --remove
- Start the serve
Henning Schroeder wrote:
> i also tried logging the queries that appear often with "copying to temp
> table" status and now have a nice set of them, though i don´t quite
> understand *why* the are copying. below are two:
> (the rows count is *way* to high, probably because the timestamps are
> an
Is anyone running into Database login problems with Mysql 3.23.41?
--
contact:
Dave Yadallee NetLine 2000 The Edmonton Internet Service Company
[EMAIL PROTECTED] http://www.nl2k.ab.ca
990-3244
-
Before posting, please check:
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> BAUMEISTER Alexandre writes:
>> Bonjour,
>>
>> With 3.22 I used to do some queries like "DELETE FROM TABLE". And
>> this was very rapid as Mysql only deletes and re-create the files.
>>
>> I knew that DELETE w
hi!
> "Jeremy" == Jeremy Zawodny <[EMAIL PROTECTED]> writes:
Jeremy> I've run across a need that has made we want to extend the way UNLOCK
Jeremy> TABLES works. And after looking at the manual:
Jeremy> http://www.mysql.com/doc/L/O/LOCK_TABLES.html
Jeremy> I see that one of the reader c
Hi!
I have a small comment to this.
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
>> I have no interest in any other clients except possibly to investigate
>> whether or not they produced anything like the same behaviour that I am
>> observing with my own application.
>>
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Peter Duffy writes:
>> Hi Sinisa,
>>
>> My problems are within the mysqlclient and MyODBC libraries, both used
>> directly by the application (and therefore all on the "client" side of
>> the socket.) Both the mysqlcl
Harald Fuchs wrote:
> In article <[EMAIL PROTECTED]>,
> "Adams, Bill TQO" <[EMAIL PROTECTED]> writes:
>
> >> I need to read the fields of a table dynamically using
> >> DBI.pm
> >>
> >> The resulting cgi script should be a form that has a
> >> checkbox for each field...the user will then create a
hi wesley and the gang,
thank you very much for your help so far. i optimized the indexes and added
another one i obviously forgot before, and the database is smoother now. a
bit at least, it now maxes out at 65q/s instead of 50...
At 13:12 06.09.01, you wrote:
> > idea? And how am I supposed
Mike Wexler wrote:
> Deryck Henson wrote:
> >
> > Let me rephrase that checkbox one::
>
> >
> > TRUE or FALSE
>
> ALTER TABLE myTable CHANGE COLUMN myColumn TINYINT(1)
>
> And you use 1 for TRUE and 0 for FALSE.
Or ENUM:
ALTER TABLE myTable CHANGE COLUM myColumn ENUM( 'T', 'F' );
Of course if y
Hi all,
I have uninstall mysql3.23.39 from Win2k and after I install
mysql3.23.41-max ... I was unable to run it as service. When I tried to
start the service I receive the following message ...
Could not start the MySql service on Local Computer
Error 1067: The process terminated unexpecte
Paul DuBois wrote:
> At 9:27 AM -0300 9/6/01, Amilton Martins wrote:
> >I want to write date type in the format "DD/MM/" to the database?
> >Can I do this with some parameter to mysql.ini?
>
> No. For storage, you must convert it to CCYY-MM-DD format.
> For display, you can format it to the
Show us what you type, and what error message you get.
Emiliano Carlesi wrote:
> Hi !!!
> I'm new in this ml.
> I've installed MySQL on my linux box follow the
> instruction ... I have :
>
> create user mysql
> create group mysql
> compiled mysql
> exec the script install_db
> changed permissio
http://www.anse.de/mysqlfront/
Use a GUI it's a lot easier
- Original Message -
From: "Attila Soki" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 11:03 PM
Subject: Re: How to do simple stuff
> hi
>
> | Add a column
>
> add an integer column:
Hi !!!
I'm new in this ml.
I've installed MySQL on my linux box follow the
instruction ... I have :
create user mysql
create group mysql
compiled mysql
exec the script install_db
changed permission
etc ...
all this operation are doing by root user.
I can connect to the db 'test' without problem
>Date: Thu, 06 Sep 2001 17:24:21
>To: Marjolein Katsma <[EMAIL PROTECTED]>
>From: Heikki Tuuri <[EMAIL PROTECTED]>
>Subject: Re:Can't get MySQL running on Win2K
>X-Attachments: C:\MY.CNF;
>
>Hi!
>
>I think it is best to have only one my.ini
>or my.cnf in your system. Otherwise there
>will be conf
Paul DuBois wrote:
> >> Complete price list you can find at
> >> http://www.mysqlmanager.com/purchase.phtml
> >
> >Q. Why should I pay $95 for your product when I can download and use
> >PHPMyAdmin (or any number of other products) for free?
>
> Legitimate question. A feature comparison could b
Your question is not clear.
Show us what you entered, and what the error message was.
snehalata wrote:
> Hi,
>
> We are facing problem with mysql on linux.
> We are unable to give the password for admin user.
> Can you please give all the list for installation and user creation
> as well
[EMAIL PROTECTED] ([EMAIL PROTECTED]) writes:
> First, if there is an FAQ or installation documentation please direct me
> there and I'll review before requesting assistance.
>
> If there is neither, I am unable to successfully run mysqlgui on the
> following platform: Sun Ultra 10 running Solar
1 - 100 of 145 matches
Mail list logo