On Fri, 27 Jul 2001 08:54:19 -0700 (PDT), Bryan Capitano
[EMAIL PROTECTED] wrote:
Usually this means your MySQL daemon, mysqld, is not started. Which OS are
you using? Under RedHat Linux, you can get your mysqld running on init
runlevels 3 and 5 (network services with and without X-windows)
Hi All,
I need to import about 30,000 data records from a text file into a MySQL
database table, thru the LOAD DATA feature. The table in question will have a
auto increment column, plus 5 other columns. Should I include a field in the
text file to insert a value into the auto increment column,
On Thu, 26 Jul 2001 09:32:47 -0400, Cavo Vincent Civ AFRL/SNRT
[EMAIL PROTECTED] wrote:
I installed MySQL 3.23.40 on Linux 6.2 and am having trouble
running the tests:
Can't locate DBI.pm in @INC (@INC
contains:/usr/lib/perl5/5.00503/i386-linusr/lib/perl5/5.00503
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
with both the binary distro and source distro with no luck. The install seems to
go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel
2.4.6 i686 system.
The main problem seems to be,
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with
both the binary distro and source distro with no luck. The install seems to go OK,
but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
system.
Please disregard this
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
with both the binary distro and source distro with no luck. The install seems to go
OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
system.
Please disregard this posting,
Regarding the upgrading posting I posted, I must install the upgrade in the same
data dir as the current version or else our customer WebHosting Manager browser
interface will not work properly when access their database's . The current data
dir install is /var/lib/mysql.
Now when you install
I have one other question, does it make a difference where you put the tar.gz
file on the server before you untar it for the install?? Does this have a
bearing on the installation, when you using the binary install??
On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED]
Hi All,
I need to upgrade a server running MySQL v.3.23.38 to .39
Specs:
RedHat/Linux 6.2 i386 512RAM
The only databases currently are the default 'test' and the 'mysql' db's no
other db's created.
The current variables show:
basedir/
datadir /var/lib/mysql
My question is, when
On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote:
Also it's been recommended to install with the Source instead of the
Binary. We want to enable BDB tables handlers also.
Any suggestion would be much appreciated :)
Use the MySQL-MAX binary from mysql.com rather
Jeremy,
Appreciate the info. I think we'll install the Mysql-Max and see how it goes.
THX's
On Thu, 19 Jul 2001 17:53:12 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote:
The binary is known to be good (or at least known). It is a static
binary built with a specific compiler, specific
On Mon, 16 Jul 2001 09:57:26 -0500, Pete Kuczynski [EMAIL PROTECTED]
wrote:
Can anyone tell me for shure if my version of mysql supports
transactions. Version: 3.23.37
The bitbybit web site states that is does not, but someone told me that
it does, help!
We use, on a shared MySQL server for
And Berkeley BDB tables!
On Mon, 16 Jul 2001 10:04:41 -0500, Cal Evans [EMAIL PROTECTED] wrote:
MySQL supports transactions if you are using either InnoDB or Gemini table
types.
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: Pete
I have a client using MySQL 3.23.37. We wanted to use the Berkeley tables but
for some reason they are disabled. when I do a show variables I get:
have_bdb NO
What is the best way to permanently enable the BDB type tables??
THX's
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Hello All,
We just installed MySQL 3.23.39 on a Redhat/Linux6.2 system,..so far so good. We
have about 30 customers who are currently using various dbs and was wondering if
someone could recommend or has setup some sort of automated back up system for
the db's. We use the mysqldump utility do
when you do a mysqladmin variables, where exactly are these variables stored,
and can they be changed. Also if a /etc/my.cnf is going to be used, once it's
been created does the MySQL server need to be shutdown and restarted to
recognize the new my.cnf file??
Again, Thx for the help :)
On Sat, 14 Jul 2001 11:46:15 -0500, Paul DuBois [EMAIL PROTECTED] wrote:
Also if a /etc/my.cnf is going to be used, once it's
been created does the MySQL server need to be shutdown and restarted to
recognize the new my.cnf file??
Yes.
is this the default location it looks for a 'my.cnf'
Hello all,
I'm a bit confused on this issue of installing MySQL and creating a separate
user/group ownership. Now I've read thru many resources, and it recommends not
installing MySQL as root, or is this incorrect??
Is it better to create the new user/groups, then install MySQL under these
Paul,
thanks for the info. So if I'm ready this correctly, I would log into the server
under my UNIX account, not as root, do the install of the server/client Mysql,
create the new user/group, which would make me part of the new user/group, then
start the server under this user/group. Is this
Paul,
OK, I think it make sense now. Appreciate you clearing this up in my head
atleast.
THX's...
thanks for the info. So if I'm ready this correctly, I would log
into the server
under my UNIX account, not as root, do the install of the server/client Mysql,
create the new user/group, which
Gerald,
You lost me on the second table, t2?? The t1 table would store a 'mykey' and the
multiple values(ID's) and table t2 would have the reference 'mykey' to table t1
and the ID column,... this is where you loose me??
On Wed, 11 Jul 2001 08:26:11 -0500, Gerald Clark [EMAIL PROTECTED]
Gerald,
God, it getting scary now, I'm actually starting to grasp all this stuff now.
this is exactly what I came with last nite, but just didn't understand what your
idea was when I first read it. :) This appears to be the best solution.
Thanks for your help,
Cheers,
On Wed, 11 Jul 2001
Joe,
Are you assigning your database variables within the config.php file or directly
into the mysql_connet(...);
config.php:
// database parameters
// alter this as per your configuration
$database=database_name;
$user = username;
$pass = password;
$hostname = localhost;
On Tue, 10 Jul 2001
That's the way should be, never enter your database access info directly into
any type of script, be it PHP or Perl or what ever, store it in a separate file,
no accessible separate file, then have the related script(s) call up the
variables thru the PHP's include, or Perl's 'require' or 'use'
] wrote:
select ID from TABLE_NAME where ID like '%value%'
or I misunderstood the question.
-
Regards,
Rod~
-Original Message-
From: ThunderRain Publishing Corp. [mailto:ThunderRain Publishing
Corp.]On Behalf Of MikemickaloBlezien
Sent: Tuesday, July 10, 2001 10:38
Erich,
You need to create special root or superuser account so that you can connect
from your PC. This will allow you full access from DBtools. This is what I had
to do in order to make the connection. You'll need to log in as the 'root' or
'superuser' to execute your mysql client.
%mysql grant
If someone has been using the database browser tool, DB Tools, I've got a few
questions, if you could possibly contact me off the list, I'd appreciate it. :)
THX
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that
Hi All,
When assigning new Users to various databases, and access settings, in order to
have it take effect immediately, all that is needed is to do a FLUSH PRIVILEGES
or does the MySQL server need to be restarted??
THX,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain
Our Mysql server was shutdown with the mysqladmin -u XXX -p XXX shutdown
and for some reason we can not restart it and can't make any connections to the
Mysql server. This is on a FreeBSD server. what is the correct procedure to
restart the Mysql server??
thanks,
Mike(mickalo)Blezien
Hello All,
Our company is going to be setting up on a dedicated server, so I am in the
process of doing some crash course learning as a system admin. We are looking
at a server with RedHat Linux 6.2 O/S and we want to install MySQL laster stable
version w/InnoDB enabled. Now from the docs, it
Thanks. Which files would I need to download then?? Just the RPM's or RPM's and
the tarball binary?
On Fri, 6 Jul 2001 16:41:05 +0300, Sinisa Milivojevic [EMAIL PROTECTED] wrote:
Use our MySQL-Max binary as it contains InnoDB. Our binaries are built
in the most optimial manner, and LInux
I assume this is the correct one to download then:
mysql-3.23.39-pc-linux-gnu-i686.tar.gz
MikemickaloBlezien [EMAIL PROTECTED] writes:
Thanks. Which files would I need to download then?? Just the RPM's or RPM's and
the tarball binary?
On Fri, 6 Jul 2001 16:54:12 +0300, Sinisa Milivojevic
Hello All,
Was wondering if anyone is fimilar with NuSphere's http://www.nusphere.com/
Enhanced MySQL and what advantages, if any it may have.
THX,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
Hi All,
I've been looking at alot of the GUI's offered at mysql.com, and was wondering
if someone could recommend a good full MySQL administrator, for fully
maintaining MySQL server/clients that is used thru the browser and not locally
on a PC.
thanks,
Mike(mickalo)Blezien
On Fri, 6 Jul 2001 08:27:11 +0300 (EEST), Michael Widenius [EMAIL PROTECTED]
wrote:
Michael,
Strange, I went thru the entire portal section and couldn't find anything about
this NuSphere's Enhanced MySQL. I just happen to notice the small banner on
www.mysql.com home page. But thank for the
thanks all, I guess it's time for new glasses! :)
On Thu, 5 Jul 2001 22:51:56 -0400, D'Arcy Rittich [EMAIL PROTECTED] wrote:
Try here:
http://www.mysql.com/portal/distributions/html/index.html
D'Arcy Rittich
- Original Message -
From: MikemickaloBlezien [EMAIL PROTECTED
Hello all,
We are looking at setting up on dedicated server with the FreeBSD 4.1 OS and
was wonder how well MySQL has worked on this O/S. We would like to compile it
with Innobase if possible.
Appreciate any feedback, recommendations, pro/cons... etc..
THX
Mike(mickalo)Blezien
What is the recommended procedure to correct this error:
...Can't connect to local MySQL server through socket '/tmp/mysql.sock'..
We seem to encounter this error quiet often.
THX,
Mike(mickalo)Blezien
Thunder Rain Internet Publishing
Providing
On Sat, 30 Jun 2001 16:34:06 -0600, Colin Faber [EMAIL PROTECTED] wrote:
it doesn't work on 3.23.32 either!
Check table didn't exist in 3.22
Werner Stuerenburg wrote:
Sorry, I don't understand from the manual how to use this
(running MySQL 3.22.32 on RedHat)
I tried to issue
On Fri, 29 Jun 2001 15:29:08 +0200, Gerlinde Fischer
[EMAIL PROTECTED] wrote:
I don't believe BDB table handler support row-locking. I suggest looking at
using Innobase tables handlers.
Hi,
I have the following configuration
I have Linux
I have compile mysql with the following configure
On Thu, 28 Jun 2001 15:30:14 -0300, Alejandro Ralla [EMAIL PROTECTED]
wrote:
You would need to reformat the input date first, within your middleware, like
Perl or PHP. Then you would be able to enter it into your db.
Hi guys, does anyone help me with this simple thing ??
I have a date format
On Thu, 28 Jun 2001 21:49:57 +0200, Sebastiaan J.A. Kamp [EMAIL PROTECTED]
wrote:
if your using perl, heres a real simple way to format your date:
my $date = 28/06/2001;
my($mn,$day,$yr) = split '/',$date;
my $db_date = join('-',$yr,$mn,$day);
# Your output should now be $db_date = 2001-06-28
On Wed, 27 Jun 2001 16:06:36 -0500, Mark Wakim [EMAIL PROTECTED] wrote:
Well depending how your tracking this person, and message related to him, I
would image some sort of an ID value assigned to the poster would be the easiest
means. something like:
DELETE FROM table_posts WHERE userid =
On Mon, 25 Jun 2001 07:42:39 -0500, Paul DuBois [EMAIL PROTECTED] wrote:
Paul,
appreciate the feedback, but my question wasn't in reference to the actual
coding and how it's used, this I understand, I was referring to when a
transaction is best used, in what type of a scenario. ;)
TIA
At
On Sun, 24 Jun 2001 21:06:16 -0700 (PDT), ricky gonzalez
[EMAIL PROTECTED] wrote:
DROP TABLE table_name;
Hi, I need to delete a table from a database. I
looked through the manual, but it's not listed in the
table of content.
Thank you for your help.
Mike(mickalo)Blezien
Hello All,
I'm current working on project, converting a flatfile system, to use MySQL,
which supports transactions w/Innobase tables. My questions is, as I'm sure many
have coded using transaction w/Perl and DBI. I understand that there as some
draw backs to using transactions when not
On Fri, 22 Jun 2001 11:28:19 -0500, Cal Evans [EMAIL PROTECTED] wrote:
If your using Perl w/DBI, you may want to check out the use of place holders and
bind_columns. Create your create your insert statement outside the loop, then do
the execute() within the loop using placeholders or
On Fri, 22 Jun 2001 15:17:18 -0700, Alberni-dot-Net Tech Mailing Lists
[EMAIL PROTECTED] wrote:
What sort of support for transactions and table/record locking is there in MySQL
right now? I had heard that only table locking was supported, and limited support
for transactions.
we've had
On Mon, 18 Jun 2001 20:19:20 -0300 (EST), Augusto Cesar Castoldi
[EMAIL PROTECTED] wrote:
SELECT VERSION();
te: Mon, 18 Jun 2001 20:19:20 -0300 (EST)
How can I know the version of mysql running on Linux (RedHat 6.2)
thanks,
Augusto
Mike(mickalo)Blezien
On Sat, 16 Jun 2001 14:33:44 -0500 (CDT), Don Read [EMAIL PROTECTED] wrote:
A heck of alot easier with Perl!(Just my opinion) :) Just disable RaiseError and
enable PrintError when using DBI
On 16-Jun-01 Dawn H wrote:
How do I make an error display, but still continue the script? The error
Hello All,
I frequently get this error message.
Seems it has to do with number of open tables bigger than 10??
Do I have a bad setup?? please verify my setup file at the end. I think I
exaggerated the memory, it only uses 4 Megabytes anyway.
bash-2.01$ mysqladmin -i 5 status
Just wanted to add:
it always loses connection when uptime=180
it restarts every 180 seconds?? the uptime count starts again at 0, so does the
query count.
Hello All,
I frequently get this error message.
Seems it has to do with number of open tables bigger than 10??
Do I have a bad setup??
On Thu, 14 Jun 2001 13:50:43 -0300, Nasir Ali [EMAIL PROTECTED] wrote:
Well as they say, ...if all else fails, RTFM.. :) Or pick up Paul Dubois's
book on MySQL.
Can somebody please point me to the good resourse of learning mysql's
SELECT command on the Internet?
Thanks,
On Mon, 11 Jun 2001 17:15:09 +0200, Simon Abolnar
[EMAIL PROTECTED] wrote:
What kind of data type is the column in questions?? VAR, CHAR,...etc.??
Hello!
When I add record in database everything works OK. When I modify data in database
using
RS.Update
function everything works OK again
On Wed, 6 Jun 2001 11:52:14 +0200, alexandre Roussel
[EMAIL PROTECTED] wrote:
subselects are not currently supported with MySQL.
Hi,
I have some problems with the following SQL request that I process with phpMyAdmin :
select * from TABLE2 where FIELD not in (select FIELD from TABLE1);
This
Hello All,
I hoping someone on the list maybe able to offer some recommendations on a good
MySQL backend database shopping cart with advance search features. One of our
client's has out-grown their current cart, which using DBM data files. And it
would cost too much to port it MySQL. They prefer
On Sun, 27 May 2001 16:27:00 -0700, Nicole Lallande [EMAIL PROTECTED]
wrote:
Appreciate all the responses, thanks to all :)
Mike - if you are familiar try Fishcart - http://fishcart.org/ - here's
what I like about it:
ease of implementation
documentation
mailing list support
for a very
On Tue, 22 May 2001 11:15:24 -0700 (PDT), sj c [EMAIL PROTECTED] wrote:
Hi, what is the default port to listen to on MySQL?
I believe it's 3306.
Mike(mickalo)Blezien
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
Hello All,
I need to create a database table with a timestamp column data type, but I don't
what it to change each time the row is updated. How can you prevent the
timestamp column from changing each time it's updated.
thanks,
Mike(mickalo)Blezien
On Tue, 8 May 2001 22:38:52 +0100, green jon [EMAIL PROTECTED] wrote:
MySQL currently does not support sub select queries
Hello,
I have recently converted my Java Servlets to run against mySQL where previously I
was using Microsoft Access. I use Tomcat and have swapped drivers etc and
On Tue, 1 May 2001 09:43:47 -0400 (EDT), Shawn Cummings
[EMAIL PROTECTED] wrote:
I'm looking for an online message forum or mailing list that deals with
Perl/mySQL. Most of the sites I've found are outdated and unused.
Any pointers greatly appreciated.
check out DevShed at
On Wed, 11 Apr 2001 14:42:47 +0200, Gunnar von Boehn [EMAIL PROTECTED] wrote:
with MySQL 3.23+ you can now assign the auto_increment start value, when
creating the table:
AUTO_INCREMENT = 1
For identification of each record in our database
we use an 'autovalue'-column.
It seems that
I posted a couple problems regarding the use of the FULLTEXT indexing and a
search query problem, but never got any responses. So maybe some one may shed
some lite on setting up a table with the FULLTEXT index.
I've read thru the MySQL docs on this and it's not real clear. When setting up a
title FROM bus_search
WHERE MATCH(title,keywords) AGAINST('car deals')
0 rows returned
--
QUERY2:
EXPLAIN SELECT title FROM bus_search
WHERE MATCH(title,keywords) AGAINST('car deals')
Comment
Impossible WHERE noticed after reading const tables
Hi!
On Apr 09, MikemickaloBlezien wrote:
I posted
On Tue, 10 Apr 2001 01:05:47 +0200, Sergei Golubchik [EMAIL PROTECTED] wrote:
Ok, I kind of thought that might be it, but wasn't sure.
Thanks for you assistance.
Then how come I keep getting these results when setting a test table. Am I
missing something here??
Create the table:
DROP
I posted a question regarding a search query we are trying to get to work, and
was hoping someone can tell why this query doesn't work. It should return
results as all the search criteria is there in the tables( for test purposes)
QUERY:
SELECT bi.bus_name,bi.address,bl.city,bl.state,
Hello All,
Just to add some additional info to our problem. If I do a simple query:
select * from bus_search where match(title,keywords) against('Best Car Deals')
I get nothing! and its there! Is it possible the table is not set up properly??
Or I'm I wishing something here??
Table Info:
Hello All,
I have been trying to figure out why the below query doesn't quiet produce the
results we are looking for. I was hoping some one maybe able to shed some lite
on why QUERY #3 returns the wrong results. If addition information is needed,
please feel free to respond privately, off the
Hi all,
We are modifying one of our db tables to include two fields, 'votes' and
'tally' for allowing to display a "rating" system. The 'votes' column will be a
running total of all votes, the 'tally' will be a column to hold the 'votes'
values. Example, if a person submits a vote of 3(with a
On Sat, 31 Mar 2001 11:46:54 -0800 (PST), Chai-Hup Chen [EMAIL PROTECTED] wrote:
Try this:
SELECT count(*) FROM Books WHERE MATCH Title AGAINST 'cisco'
We use a FULLTEXT index search in a couple of our table for business referral
searches, and it works like a charm!
Hope this helps
Hi,
On Sat, 31 Mar 2001 12:39:59 -0800 (PST), Chai-Hup Chen [EMAIL PROTECTED] wrote:
I think if you take a look at the MySQL docs on FULLTEXT it'll explain it alot
better then I probably could.
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
Thanks a lot, the select is much faster
On Sun, 1 Apr 2001 04:07:35 +0330, "Hamid Hashemi Golpayegani" [EMAIL PROTECTED]
wrote:
I think everyone is getting bombarded with this virus message. I gotten 3 of the
already!
I am getting this warning also and I have installed Norton Antivirus 2001
with the lastest update and sure that
On Sun, 25 Mar 2001 12:56:15 -0800 (PST), john lin [EMAIL PROTECTED] wrote:
John,
I'm not a 'C' programmer, but I think you need to enclose your VALUE with single
quotes for a literal value: VALUES('test')
Atleast in Perl, it' done that way.
I am a senior in Polytechnic University working
Hello All,
I have a table with a column called "bus_name" varchar(100) which is used in a
Business Name search form. I need to make the Business Name that is entered into
the search form case in-sensitive to the column "bus_name" IE. If we have a
entry in the column "bus_name" "The Happy Shop",
On Thu, 22 Mar 2001 22:27:06 +, Jordan Elver [EMAIL PROTECTED]
wrote:
Ignore this post! My fault, we had something coded wrong in the script.! It
works fine now.
My apologies to the list! :(
If you add BINARY to the column it WILL make it case sensitive.
On Thursday 22 March 2001 22:01,
searching
for');
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf
Of MikemickaloBlezien
Sent: Thursday, March 22, 2001 4:02 PM
To: [EMAIL PROTECTED]
Subject: Case Sensitive??
Hello All,
I have a table with a column called "bus_na
On Wed, 21 Mar 2001 14:59:38 -, "soon chee keong" [EMAIL PROTECTED]
wrote:
A very basic UPDATE will do the trick.
UPDATE Table_1 SET
C = '20'
WHERE C = '9'
Table_1
-
A B C
-
1018 9
4 3 1
#
# Table structure for table 'bus_info'
#
CREATE TABLE bus_info (
info_id int(11) unsigned DEFAULT '' NOT NULL auto_increment,
bus_name varchar(100) DEFAULT '' NOT NULL ,
contact_fname varchar(20) DEFAULT '' NOT NULL ,
contact_lname varchar(20) DEFAULT '' NOT NULL ,
refer_by int(8))
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral search where people
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral search where people
On Sat, 17 Mar 2001 22:04:37 +0100, "Denis Mettler" [EMAIL PROTECTED]
wrote:
Denis,
Can't you tie the table 1 id and the table 2 category_id together?? Or are this
going to be different?? If they are going to be different, I would suggest then
create a "linking" table to link table 1 to table
Hello All,
We have a table where keywords will be entered into a column (searchwords), up
to 3 unique keywords. Then this column will be used in a keywords search tied to
a Category(a Category has to be selected). The table will have a category
column: category. Basically when a search is done,
On Sat, 10 Mar 2001 14:24:18 -0500, "Tac/Smokescreen Action Network"
[EMAIL PROTECTED] wrote:
Would you happen to have an example?? I did look at the FULL TEXT search, but
I'm not sure this would work in our situation,... but we maybe able to adapt to
it.
TIA,
Of course, the other way to do
On Fri, 9 Mar 2001 18:41:46 -0500, "Tac/Smokescreen Action Network"
[EMAIL PROTECTED] wrote:
I've searched the MySQL manual and can't figure out how to convert one (or
all) tables to MyISAM. (I'm upgrading a very large database from 3.22 to
3.23).
I think there's a way to do it from the
On Tue, 6 Mar 2001 11:14:36 +0100, Fred van Engen [EMAIL PROTECTED]
wrote:
Thanks Fred,
INSERT INTO referral
VALUES (NULL, 'xxx.yyy', 'xxx.yyy', '[EMAIL PROTECTED]');
But an INSERT like this:
This is where I was making the mistake! It works fine now. I was inserting an
blank empty value
On Tue, 06 Mar 2001 09:18:34 -0600, "Gerald L. Clark"
[EMAIL PROTECTED] wrote:
Gerald,
Try giving a number instead of a string as a default for an int.
Not sure I follow, it is a number??
"MikeBlezien" wrote:
Hello All,
I've created a table(using MySQL 3.23.33), using default
On Mon, 5 Mar 2001 16:28:56 +0900, "Cho Bum Rae" [EMAIL PROTECTED] wrote:
check into the LOAD DATA, this should handle it for you.
Manual: http://www.mysql.com/doc/L/O/LOAD_DATA.html
Do you know how to import TXT file into mysql DB?
Because of big size txt file, I cannot input data into DB
Hello All,
Was wonder if any knows of a Perl equivalent to the PHP's version of
phpMyAdmin?? We use phpMyAdmin but have a project that server doesn't have PHP
installed, and frankly, to lazy to do all the typing thru telnet session! :)
TIA,
Mickalo
Mike(mickalo)Blezien
On Sat, 03 Mar 2001 19:51:04 -0500, Alec Solway [EMAIL PROTECTED] wrote:
Try using DECIMAL, this works best for monetary values in my experience.
I'm having some trouble with the following:
I have a sample table that has one record where price == 123.54, however
select * from gpl where
Hello All,
I've created a table(using MySQL 3.23.33), using default values:
DROP TABLE IF EXISTS referral;
CREATE TABLE referral (
refer_id int(10) UNSIGNED DEFAULT '100' NOT NULL,
refer_fname varchar(20) DEFAULT '' NOT NULL,
refer_lname varchar(20) DEFAULT '' NOT NULL,
refer_email
Greetings,
I have a table that has a column where search keywords are entered.
column searchwords
word1 word2 word3 ..etc
Now when this column is queried for a search, I'm wonder how is the best way to
evaluate
matching the keywords. In the SELECT query, would I get better results if I use:
On Thu, 1 Mar 2001 19:32:54 -0800, "Daren Cotter" [EMAIL PROTECTED]
wrote:
So, the question is, why does this not return 400, like it should???
OK, weird! Now I am getting this error...
mysql select count(*) from members where signup_date = '2001-03-01';
ERROR 1032: Can't find record in
Hello all,
I have a table that stores business locations, which contains 'city','state' and
'zip' and this table is utilize for search queries. Which type of indicing take
full advantage of the MySQL optimizer, create a multiple column index
(city,state,zip) or separate indices on each column.
On Tue, 27 Feb 2001 13:53:52 -0700, Steve Ruby [EMAIL PROTECTED]
wrote:
You maybe able to adapt the FullText search for this. You can read the details
on this at:
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
depending what version of MySQL your using.
Is there anyway to do a
Hello all,
Sorry about the slightly off-topic request, but table designs structures are not
my strong point as of yet! :)
I have a project we are working on, and have a rough draft put together before
actually starting. I would greatly appreciate some feedback if improvements,
changes or
Hello All,
I have a project coming up that we are programming with Perl, the coding is no
problems, just need to get some advise as to setting up the db tables properly
so they are efficient and meet our needs. If some one on the list may have some
spare time to take a look at our notes and
On Fri, 23 Feb 2001 15:54:03 +0100, Yong Li [EMAIL PROTECTED]
wrote:
Hi,
I wanted to create a column with type set, and to specify a default
value for this column, but I always got either SQL syntax error or
invalid default value error. What is the right syntax for doing this?
or, it's
On Fri, 23 Feb 2001 18:56:08 +0100, "CGint" [EMAIL PROTECTED] wrote:
I'm about to migrate from an MS-access to MySQL.
I named my primary-key-columns 'Key'.
Now, if i try to query this column I get an error:
mysql SELECT key, description FROM project;
ERROR 1064: You have an error in your SQL
On Fri, 23 Feb 2001 15:50:23 -0500, "Joe and Nancy M"
[EMAIL PROTECTED] wrote:
What is wrong with this syntax, it looks like what chapter 7.7 says.
mysql CREATE TABLE cur (FLD1 char(30), FLD2 numeric(6,2), FLD3 int(7));
I get a parse error.
Joe,
I don't think "numeric" is a valid data
99 matches
Mail list logo