Can anybody help me with this please
-Original Message-
From: suresh [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 2:20 PM
To: [EMAIL PROTECTED]
Subject: make problems on solaris 8 x86
Hello
I am installing mysql 3.23.37 on solaris 8 x86.
I am having problem with
Hi all!
I have been attempting to set up a system that involves replication and
have run into some minor problems.
I am only replicating one database but not all of the tables in the database.
So when changes are made to the replicated dataase, it is logged to the
binary log even if it is from
Hi.
I'd like to build an HA MySQL server using shared storage over
Fibre Channel.
Having a look at the mailing list archives, the issue was addressed
earlier on (I could find traces of it as early as 1999) but AFAICS
no definitive solution has been reached.
I know there is a commercial solution
Hi,
I'm tring to make connection.setAutoCommit(false) with
org.gjt.mm.mysql.Driver driver, I recieve an exception that says : cannot
disable AUTOCOMMIT .
Is it the driver, should I use different driver, and suggestion ?
Thanks a lot
einav.
Einav Lavi-Pdut
software engineer
[EMAIL PROTECTED]
Dear Colleagues,
How can one validate a date in mysql ?
Kind regards,
Pieter
Validate a date?
see Date and Time functions in the manual.
Vankeerberghen, Pieter wrote:
Dear Colleagues,
How can one validate a date in mysql ?
Kind regards,
Pieter
-
Before posting, please check:
Thank you, Ok, I looked in the manual but I coul dnot obtain an answer. How
can I check that a date I'm importing is valid, e.g. how to check for
20001131 (MMDD) ?
Kind regards,
Pieter
-Original Message-
From: Colin Faber [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 11:18
Gilfether, Ryan writes:
Anyone have success in using mysql++ with MFC in Visual C++ 6.0, if so what
did you do to get it to work? I emailed the guy who did the mysql++ port for
Visual C++ and he told me that it is a major problem getting it to work with
MFC. I tried all the stuff he suggested
VVM Ravikumar Sarma Chengalvala writes:
Hi Sinisa,
Thanks for spending the time.Here are few observations
on mysql_escape_string().I have checked it up and
found to be working but with the following problems.
i)
It works well when I want to insert strings like:
'xyz or x'yz.
ii)
When I
VVM Ravikumar Sarma Chengalvala writes:
Hi Sinisa,
1.
Thanks for the detailed mails .I got to the problem I
am facing with '\' character.
2.
Actually I am expecting the function to add an
additional \ when a single '\' comes as a part of
string.For example:
I want to insert a File path
On Tue, May 15, 2001 at 11:27:19AM +0200, Vankeerberghen, Pieter wrote:
Thank you, Ok, I looked in the manual but I coul dnot obtain an answer. How
can I check that a date I'm importing is valid, e.g. how to check for
20001131 (MMDD) ?
You'll have to do this kind of validation checks in
Steve Ruby writes:
Due to the fact that piping a table from mysqldump to an INNODB table
can be as much as 30X slower if the insert is not done with
transactions,
would it make sense to add some option to mysqldump to make every X
inserts a transaction.
for example
mysqldump
Peter Kovari writes:
Could someone tell us, how to change individual data fields with
MYSQLGUI, or when is this feature going to be available?
Does anyone know about any other tool that enables you to change
individual data fields in tables?
Thanks,
-Peter
HI!
For the moment, to
Florin Andrei writes:
On 12 May 2001 00:51:11 +0300, Michael Widenius wrote:
That's great news!!!
Congratulations, guys!
Now the problems: :-)
cut
Best regards, and keep up the good work!
--
Florin Andrei
Remember, son:
if you never try, you never fail - Homer Simpson
---
Jeffrey Mulliken writes:
If I am posting this to the wrong list, please let me know which is the
more appropriate list. Thanks.
I am trying to get a new installation of Bugzilla, v 2.12 installed
and working. I used a binary tarball of 3.23.36 for the installation.
I am also using
root writes:
Description:
When I sent this problem to the list earlier, I hadn't read about mysqlbug, so
please excuse the
improper question submission. Here is the repeat;
I am trying to get a new installation of Bugzilla, v 2.12 installed and working.
I used a binary
You can do this yourself, pretty easily by building an index in
advance. I've been using the following technique to implement full text
searching since before it existed in MySQL in any form. Tokenize
each unique word in a document and store the word count in tables:
tbl_tokens:
token_id int
hunter writes:
Are you saying that the current version of gcc for RedHat Linux 7.1
(i.e. 2.96) is not working for you and thus preventing the rpm from
building? Thats awfully interesting, and you should report the bug, if
that is indeed what you are seeing, to bugzilla...
Yes, the above
I would like to create multiple tables in a database.
HowTo Use REFERENTIAL INTEGRITY with MySQL ?
May I use FOREIGN KEY or REFERENCES?
Note: MySQL Release = 3.23.36
Thanks for help :)
-
Before posting, please check:
On Tue, May 15, 2001 at 12:43:02PM +0200, RAZAKA wrote:
I would like to create multiple tables in a database.
HowTo Use REFERENTIAL INTEGRITY with MySQL ?
May I use FOREIGN KEY or REFERENCES?
Note: MySQL Release = 3.23.36
Thanks for help :)
In short, you can't..
From the MySQL manual
How would I login to mysql in telnet and create tables
Regards,Terrell Johnson
Dedicated support Technician
Catalog.com, Inc.
http://www.catalog.com
ICQ#113201638
Hi there
I am working on a site where they are using ISAM files, (.ISM .IS1), I
want to know if there is a way of accessing these from MYSQL? From what I
have been able to tell they appear totally differently in comparison to some
of my MYISAM table when I open them in Notepad. Can anyone shed
mysql -u username -p
enter your password
use yourdatabase;
create table mytablename(...
(see the manual for proper syntax on creating tables)
- Original Message -
From: Terrell Johnson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 12:28 PM
I'm working a project with the same exact scenario right now. My ver. of
mySQL is 3.23.xx and my client's is 3.22.xx. there table sturcturing is ISAM
and mine is myISAM. The only I've been able to transfer succesfully is by
dumping all the data and re-importing on the clients end.
-Original
Dear Colleagues,
How can one validate a date in mysql ?
Kind regards,
Pieter
The simplest way that i know is:
date_add(datestring, interval 0 day)
This function wil return the correct date or NULL with months outside 1..12
and days outside 1..31.
Here are some examples:
select
Hi,
I'm new on the list. I subscribed because I need help about a problem I
have.
I heard that this problem is well-known and well-documented, but it never
work ...
In fact, I'm unable to start MySQL(-3.23.38) (even with 3.23.32) on a RedHat
7.0. It doesn't say anything wrong, but MySQL is
Hi Help!
I would like to store some short binary data (encrypted). I used a
varchar(24) binary field for this.
But it seems that MySQL cuts white-spaces from the end when storing the
data in the table. When the encrypted string now has a white-space at
end, MySQL will cut it and this will
What kind of speed can you expect to get from this after tbl_doc_index fills
up with tens of millions of rows? Is this scheme suitable for that magnitude
of data?
Also, if you wish to generate a query that generates all documents that
contain token x or token y, would mysql neglect to use the
Varchar fields are not binary, blobs are.
ryan
Hi Help!
I would like to store some short binary data (encrypted). I used a
varchar(24) binary field for this.
But it seems that MySQL cuts white-spaces from the end when storing the
data in the table. When the encrypted string now has a
Description:
Trying to compile mysql source on a Intel-Compaq running Solaris 8.
Get the following error:
checking return type of sprintf... configure: error: can not run test
program while cross compiling
config.log says:
configure:2369: checking
Hi all.
I'm new in this list, so may be this questions has already done
here.
I need to update my database daily at midnight. I want some file
from which I can connect to mysql, switch to some database and work into
tables (basically with delete and load commands).
How can
Oops,
I read the file size wrong in the printout. It was only
300 MB. Then we can suspect that you ran out of disk space.
But knowing the MySQL version would help.
Regards,
Heikki
...
Eugene,
does your operating system support
Max file size is 300M, not 2G. Isn't it?
B.R. Eugene
On Tue, 15 May 2001, Heikki Tuuri wrote:
Eugene,
does your operating system support over 2 GB files?
Which MySQL version you are running? What is the opeerating system?
I guess the problem is that the OS does not support over 2 GB
Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but
then i can't stop the server...i tried ./mysqladmin shutdown, ./mysqladmin
-u root shutdown, but it doesn't work..any one can help???
mysql 3.23.37
Thank you,
EISSEN Chalrie
Hello,
This is more like a UNIX question: In our LINUX box
startup file, we have an entry to start mysql.
However, when the machine boots, mysql starts as root.
How do we make it to start as mysqladm (the user
we setup for mysql)
Any help is much appreciated.
Christopher Lambrou,
CGL
mysql Ver 11.15 Distrib 3.23.37, for sun-solaris2.7 (sparc)
SunOS 5.7 Generic_106541-02 sun4u sparc SUNW,Ultra-5_10
On Tue, 15 May 2001, Heikki Tuuri wrote:
Hi!
Ok, the error turned out to be out of disk space. But for some reason
the error handling code in os0file.c did not recognize
Andy Woo wrote:
I have the same problem. Whatsssup? :-)
/usr/bin/mysqladmin: connect to server at 'breguet' failed
error: 'Host 'breguet.experia.com' is not allowed to connect to this
MySQL server'
what can I do to solve this ?...
I don't know i removed the things, and tried to
On Tue, May 15, 2001 at 10:24:38AM -0400, Chris Lambrou [CGL] wrote:
Hello,
This is more like a UNIX question: In our LINUX box
startup file, we have an entry to start mysql.
However, when the machine boots, mysql starts as root.
How do we make it to start as mysqladm (the user
we
Chris Wilkinson wrote:
I am attempting to upload an Access db to a remote mysql server - at
dsvr in the UK.
I get connected (I think) but receive the following error message:
Microsoft Access ODBC - call failed [Microsoft][ODBC Driver Manager #0]
Can you point me in the right direction
My name is Martin Leduc from Solution Globale, Chicoutimi. We are interested by a
MySQL Solution, but we have a big problem and we dont know how to solve this one.
We use MyODBC 2.50.37 and MySQL 3.23.36 to 38 (bug fixed) and we have anytime the same
trouble. Null value with NOT NULL TEXT
Anyway, I'm running SuSE 7.1 and here is my error messages:-
jedi:/usr/bin # safe_mysqld
Starting mysqld daemon with databases from /var/lib/mysql
010516 06:05:54 mysqld ended
I checked my log, it said
010516 06:05:54 mysqld started
010516 6:05:54 /usr/sbin/mysqld: Can't find file:
I'm not for sure but when you create a user you can allow that user to only
connect from specific locations. Such as localhost or from anywhere or even
a specfied locationm 123.222.111.2. Not sure if this will help at all??
Good Luck.
-Original Message-
From: stephane parenton
Steve,
I cannot promise any such tools in the next 6 months.
My TODO list has the two important items currently:
support for arbitrary size BLOBs and CHECK TABLE.
The right way to proceed now is to test existing tools and their speed.
Could you measure the speed of the following options in
Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here are my
observations:
1) Manual is not clear on permissions of directories - They should be mysql.root
owned. The error in the error log just says cannot create file. This could be one of
many things! I had to use my
This is a known bug when running MySQL on Darwin / Mac OS X right now.
Last I heard some listy was submitting a diff or a patch to the
maintainers, but I haven't heard anything about it for a little while.
Any news, folks? Works a treat on Darwin, otherwise.
Zach
On Tuesday, May 15, 2001,
On Tue, May 15, 2001 at 04:45:22PM +0200, Viktor van den Berg wrote:
Hi,
I am new to this list, so maybe this question is asked before.
I like to know how to use the except statement in MYSQL. EXCEPT is
(almost?) the same as an exlusive or (XOR):
select userid from user1
except
Steve,
your observations suggest that it is MySQL which is holding some
semaphore while it is aborting a connection (which in your case
required a big rollback). The operating system seems to be innocent.
On Windows NT I have seen that disk operations will freeze the
computer almost totally.
Excuse me but what do you mean by FullText ? Is this a full-text search
engine in MySQL ???
-Original Message-
From: ryc [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 3:29 PM
To: James Treworgy; Chris Nichols
Cc: [EMAIL PROTECTED]
Subject: Re: Re[2]: MySQL FullText
Richard,
thank you for the observations. Some comments:
Just installed MaxSQL 3.23.38 on a test system to check out InnoDB. Here
are my
observations:
1) Manual is not clear on permissions of directories - They should be
mysql.root
owned. The error in the error log just says cannot create
Steve,
At 09:48 AM 5/15/01 -0600, you wrote:
Heikki Tuuri wrote:
Steve,
your observations suggest that it is MySQL which is holding some
semaphore while it is aborting a connection (which in your case
required a big rollback). The operating system seems to be innocent.
If the large
Well, if you really just want it stopped, the usual unix rule is to ps -ax |
grep mysql, read the PIDs then kill -11 [PID] kill the safe_mysqld script
first or it will restart the mysql daemon.
EISSEN Charlie wrote:
Hello, i'm running mysqld on darwin (mac os x client)...Start is good, but
Steve
Thanks for replying. I have an Access 2000 database called webugnet and
I am attempting to Export it. I have installed MyODBC and configured a
mysql connection to the sql server on DSVR.
So, in the table window right click on the database and select Export
This brings up an Export
On the mysql.com website under downloads: contributed there
is a chunk of VBA code you can put in an access database to make
it export to a SQL text file, use that, you are better off,
otherwise export from Access to text (comma separated for example)
and use LOAD DATA in mysql to load the
After installing mysql, when i try to connect the server
reply
access denied for root@localhost
How is it possible? I set the password for user root, and
all seems to be right
++ SIMONE LUCARELLI
| _ | agenzia giornalistica
||___ ___| | TUTTOCALCIO
| / /
It looks like they're running Sun Solaris version 2.6 (SunOS 5.6) on an
Intel-based system (as apposed to a SPARC based Sun server). The MySQL
site only shows binaries available for the SPARC version of Solaris, so
you'll have to download and compile the 'source' distribution...
-
I am new to the world of mySQL and have just installed it on a Windows 2000
Advanced Server and I need to figure out how make the db accessible from a
remote PC for administration. Can anyone provide me with some direction in
that area? Bear in mind, I am a newbie.
Thanks very much,
Ray
In message 1D9A6579106BD411BA9700A0C9A50975191A97@AFTERBURNER, Randy
Davis [EMAIL PROTECTED] writes
I was wondering if anybody would be able to help me with this. I've got a
MySQL database set up on my Linux server. I want to be able to access it
remotely, but all we get when we try to access
Hi Everyone,
I've compiled the mysql 4.0 version on my computer to test the speed of
creating full text indexes.
I read that it was supposed to be 100 x faster than 3.23. However, it
seems just as slow to me. I've been building an index on my 400+MB
table for 5 days now. Does anyone have any
4.12.18.1 Mac OS X Public beta
MySQL should work without any probelms on Mac OS X public beta. (Darwin);
You don't
need the pthread patches for this os!
typo: probelms
_
Get Your Private, Free E-mail from MSN Hotmail at
When I try and update a recordset I get the following problem-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Query based update failed. The row to update could not be found.
/Part1_Section1_Process.asp, line 82
Line 82 happens to be when I call rs.Update()
The problem only occurs
On 15 May 2001 13:21:12 +0300, Sinisa Milivojevic wrote:
The reason why you are having problems in building from source is that
you are most probably using gcc 2.96, which is simply broken.
Will you accept further patches to the spec file that will try to
autodetect the compiler and make use
Hello All,
is there any kind of row number pseudo-column that identifies a
particular row's position in the query's result set? Something like
RowNum in oracle.
Thanks!
-- john
--
===
John Cartwright
Professional
Try this program. Go to http://www.artronic.hr/mysql/index.htm and get
mysqladmin. Its a windows client to manage mysql databases. You then can
put in the ip address of the computer you want to connect to that is running
a mysql database. So you would put your win2000 server ip. Then put in a
Richard,
I made some measurements with fsync. If I create first the big data file
without O_SYNC and after that make a single fsync, I get a write speed
of 5 MB/s, which is 5 times more than with O_SYNC.
On the other hand, opening a log file in the O_SYNC mode makes commits
much faster than by
When I run mysqlbinlog on my binary.log file (I specified that filename),
under some situations I cannot read the file, I get Bad Magic Number error.
/etc/my.cnf
log-bin=/usr/local/mysql/data/binary.log
Results:
- On mysql 3.23.35 on Solaris 7 I have to run flush master from the mysql
client
I'll maybe say something stupid, but if you have your files with your SQL
commands, couldn't you use this command ? :
mysql -u your_user -pyour_password /path/to/your/SQL/commands/file
?
-Original Message-
From: Aires Lima Trindade [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, May 15,
correct me if I'm mistaken, but I believe the latest version of mysql is
3.23.38
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 1:04 PM
To: [EMAIL PROTECTED]
Subject: MySQL 4.0 FULLTEXT SPEED
Hi Everyone,
Hi,
We can decalre a varchar field as BINARY if we need
case sensitive storage of field values.
Regards,
Ravi
--- ryc [EMAIL PROTECTED] wrote: Varchar fields are
not binary, blobs are.
ryan
Hi Help!
I would like to store some short binary data
(encrypted). I used a
varchar(24)
Hi,
Can some one tell me the default memory the mysql
allocates when we initially create a database and how
to increase the memory subsequently.
Regards,
Ravi
Do You Yahoo!?
Get your free @yahoo.co.uk address at
At 09:42 15/05/2001 -0700, Ray Pollard wrote:
Hi,
There are several ways to do this. For example you can use
script languages like PHP (you find in our contribution pages
applications ready), also you can use SSH (maybe you need a
commercial SSH server to run on Windows) or you can use telnet
I've encountered this before. Several of my clients use mySQL and most of
them Linux, however my servers that run mySQL all are W2k. The issue
happened like you said when migrating data from w2k to linux. It was a few
versions ago in 3.22 however, but the auto-increment field didn't translate
for
It wasnt my original post, however the problem with the full-text engine
built into mysql is at the current time it is very slow with many records. I
was inquiring if this other method would be any faster.
ryan
Excuse me but what do you mean by FullText ? Is this a full-text search
engine in
Hello,
On Tue, 15 May 2001, Aires Lima Trindade wrote:
How to run SQL commands from a text file but they wasn't clear for me.
Does anybody can share with me old experience or a real example
about this case?
C:\mysql\bincopy con upd.sql
USE akw;
INSERT INTO tmp (id,c1)
Hello,
From: Richard Ellerbrock [EMAIL PROTECTED]
Just installed MaxSQL 3.23.38 on a test system to check out InnoDB.
Here are my observations:
May I add my ones ...
If there are some missing entries in the my.cnf or the INNODB
handler can't be started because of permission problems and
Can anyone shed light on why this doesn't work, and perhaps tell me how I
can ALTER the enum values .. or is this just not possible?
mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action
ENUM('added','modified','deleted') NOT NULL DEFAULT added;
ERROR 1064: You have an error
Doh!
mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action
ENUM('added','modified','deleted','recovered') NOT NULL DEFAULT
'added';
Query OK, 25 rows affected (0.01 sec)
Records: 25 Duplicates: 0 Warnings: 0
Time to squash this bug in MysqlTool
I'm not a database god, but why would you want to store binary data in a
varchar feild when there are feilds of type binary to do store that type of
data? How can binary be upper or lower case?
-Original Message-
From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]]
Sent:
At 03:53 PM 5/15/01 +0200, DEVOS BASTIEN wrote:
Excuse me but what do you mean by FullText ? Is this a full-text search
engine in MySQL ???
FULLTEXT is a kind of index in MySQL that allows for faster queries and
search-engine like relevance values for sorting the results.
Here's a link to some
Maybe he's running in some windows version??
It seems to me that your example using std-in is the easiest. I would
suggest also writing a perl program but in this case I thing your example is
right on. Then again if he's using the windows version, I have no idea.
-Original Message-
I need am looking for a server for virtual hosting of websites. Ideally it would be
running Linux and be rack mounted. Right now we have a couple of websites that
require database support on another companies server and we are looking at hosting
them on-site. Currently we have a couple of
You need to quote the default value.
--zak
- Original Message -
From: Abraham Ingersoll [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 12:39 PM
Subject: alter table change enum set
Can anyone shed light on why this doesn't work, and perhaps tell me how I
can
Here is what I am trying to do:
I am creating a clockin/out utility with php and mysql. I need to do some
error checking and look at the last record of the current employee to make
sure it is a completed transaction. In other words, I want to make sure that
before I clock someone in, that they
hi.
put quotes around 'added'.
-ravi.
-Original Message-
From: Abraham Ingersoll [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 2:40 PM
To: [EMAIL PROTECTED]
Subject: alter table change enum set
Can anyone shed light on why this doesn't work, and perhaps tell me how I
can
DEFAULT 'added'; ?
Abraham Ingersoll wrote:
Can anyone shed light on why this doesn't work, and perhaps tell me how I
can ALTER the enum values .. or is this just not possible?
mysql ALTER TABLE nt_zone_record_log CHANGE COLUMN action action
ENUM('added','modified','deleted') NOT
On Tue, May 15, 2001 at 02:06:32PM -0400, Dave Carter wrote:
correct me if I'm mistaken, but I believe the latest version of mysql is
3.23.38
That's the released version, yes.
But you can pull a source copy of the MySQL 4.0 tree and compile it
yourself if you're in the mood for some fun. :-)
- This was posted before, but under a title that made it sound like a read
the manual, silly type of question. Hopefully someone can answer this.
I would like to be able to filter users based on other criteria than just
their name/host. Will mysql complain/refuse to work if I add columns to
Look on Ebay for Compaq 1850R 'rackmount' servers...
You can find one with 'dual' Pentium II CPU's, dual power supplies (which you can
plug into 2 different circuits or UPS's), and enough SCSI drive slots to provide the
disk space (and the different number of storage devices to 'mirror' and
When i try to create a database with the command :
mysql create gnudip2;
Told me an error :
ERROR 1064: You have an error in your SQL syntax near 'gnudip2' at line 1
Why this error ??, What is wrong ??
Thanks
Ana Elisa Martinez
try:
mysqlCREATE DATABASE gnudip2;
From: Ana Elisa Martinez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Error creating database
Date: Tue, 15 May 2001 16:09:09 -0400
When i try to create a database with the command :
mysql create gnudip2;
Told me an error :
ERROR 1064: You have an
With windows, you can use type filename.sql | mysql ...
Maybe he's running in some windows version??
It seems to me that your example using std-in is the easiest. I would
suggest also writing a perl program but in this case I thing your
example is
right on. Then again if he's using the
Hi! I wonder what would be faster. Let's say I want to run two kinds of
SQL queries on the table:
SELECT id FROM mytable WHERE key1=? AND key2=? AND key3=?;
DELETE FROM mytable WHERE key1=? AND key2=? AND id=?;
What's better? This:
CREATE TABLE mytable (
key1 CHAR(20) NOT NULL,
key2
create database gnudip2;
make sure you have the right permissions as well!
- Original Message -
From: Ana Elisa Martinez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 9:09 PM
Subject: Error creating database
When i try to create a database with the command :
I have some complex multi-step queries that take over 60 seconds on Free BSD 4.2. They
seemed much faster on Linux.
Should FreeBSD 4.2 be just as fast as Linux on comparable hardware ?
When I simulate concurrent users the query times go up oddly.
1 user 66 seconds
2 users 157 seconds
3
I also get somthing like that,
much mor productive to do somthing like
create database gnudip2(id int(10),some_colum varchar(255));
Trying to show that you add columns with the same command.
Darrell
On Tue, 15 May 2001, Ana Elisa Martinez wrote:
When i try to create a database with the
there is no command line.. you go to the mysql.com site, download
the access converter on the contributed programs page, copy the code
into an access module (macro), edit the code to tell it where to
save the result and run it.
It will produce a text file, then you can do
mysql mydatabase
Try: http://eliteukserve.net/dedicatedservers/dedicated_servers.html
We specialise in managed custom server solutions. We have great experience in
providing mass virtual solutions incorporating Linux
based systems such as SuSE and RedHat with MySQL.
I would say perhaps a Dual PIII 1GHz SCSI
Hi there,
I'm trying to install MySql and Mysql client
(including MySql GUI) both on Windows and Unix/Linux.
I'm having trouble reset the root password:
I ran:
./bin/mysqladmin -u root password 'mysqlroot'
./bin/mysqladmin: connect to server at 'localhost'
failed
error: 'Access denied for user:
I have a similar mysql enum question. What if I have the following:
enum('foo','bar','baz') default 'bar' not null.
What if I want to change the value of bar to bee? What is the best way
to implement this?
Nicole Sweeney
Software Configuration Engineer
Akamai Technologies
858-909-3654 work
hello,
is it possible to set server varibales through SQL and if so
what user-rights do i need?
thanx in advance
regards peet
I found FULLTEXT (MATCH/AGAINST) indexes and the SOUNDEX function. Are
there other MySQL features that help with Fuzzy searching?
Soundex seems very useful, but I'm not sure how to apply it to multi-word
strings.
I'd also be interested in pointers to general info on writing fuzzy
1 - 100 of 104 matches
Mail list logo