On Wed, Jan 17, 2001 at 11:53:40PM -0800, Mike Wexler wrote:
>
> Actually, I'm pretty sure it would need to be done in the MySQL
> server. It could be done with either the master or the slave, but I
> think the slave would be cleaner.
Probably true. I just haven't thought too hard about it. I m
From: "Marcos Minshew" <[EMAIL PROTECTED]>
Sent: Wednesday, January 17, 2001 10:05 PM
> >From what I've read in the docs, this should work, yes?
>
> select mcorder.ord_id, project.address, mcuser.last_name
> from
> project inner join
> (mcuser inner join
>mcorder
> on mcus
Sasha Pachev writes:
>
>
>
> We will add a stricter sanity check for the referers to work around
> the bugs in some browsers.
Completo.
--
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Matt Wagner <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
Jeremy D. Zawodny writes:
> On Thu, Jan 18, 2001 at 01:21:05PM -0700, Basuki Setiawan wrote:
> > So do I
>
> In their usual amazing fashion, the MySQL team responded very quickly
> and put the changes online only hours after I sent them a diff.
This is only because you caught all of us (that ar
Dear All,
I hope somebody can help me, I have installed MySQL on a Windows 2000 system
and it is working fine.
However I require Transactions, Record Locking and RollBack, so I have also
downloaded the Berkley DB v3.2.3, this is where my problems start. I am
using MS Visual C++ v6, when I try
Jeremy D. Zawodny wrote:
> On Wed, Jan 17, 2001 at 11:53:40PM -0800, Mike Wexler wrote:
>
>
>> Actually, I'm pretty sure it would need to be done in the MySQL
>
>> server. It could be done with either the master or the slave, but I
>
>> think the slave would be cleaner.
>
>
>
> Probably
Hi all...
I would like to have some explanation about skip-locking feature of the
safe_mysqld. I've already read the manual pages of safe_mysqld.
The questions are as follows:
1) for a single daemon installation, without any isamcheck occuring
during normal operation, is there any difference in
[EMAIL PROTECTED] writes:
> I've spent most of this day reading and rereading the documents on setting up
> MySQL. I'm currently working on NIDS and have setup MySQL on the same box as
> the sensor for logging of packets to verify that I had the NIDS setup
> correctly for db logging. I then inst
Chetram Ramnarain writes:
> Hello,
>
> I am trying to download a copy of MySQL for my Win 98/NT computer. There are
> so many different kinds of downloads, which one do I choose. Which
> documentation do I need? HELP! Anyone. I am trying to learn this software,
> as it was recommended to me.
Hi!
On Thu, Jan 18, 2001 at 01:09:35AM -0800, Mike Wexler wrote:
>
> >
> > Probably true. I just haven't thought too hard about it. I might
> > be possible today for the *first* slave, but after that it seems
> > like it can't be done.
>
> I don't see why not. I'm assuming the master would transmit
On Wednesday 17 January 2001 23:38 kerry finn wrote:
> Hi,
>
> I'm new to MySQL. I've installed MySQL on bothWin2000 and Solaris 2.8
> machines. Everything locally works fine. When I tried to connect from
> the Win2000 (dhcp-70-219) machine to the Solaris machine
> I get the following error:
>
>
On Thu, Jan 18, 2001 at 10:13:15AM +0100, Marco Bizzarri wrote:
> Hi all...
>
> I would like to have some explanation about skip-locking feature of
> the safe_mysqld. I've already read the manual pages of safe_mysqld.
>
> The questions are as follows:
>
> 1) for a single daemon installation, wi
cpcs writes:
> sir,
> can i build mysql database in win 98 and install on server runnin on
> winNT
Hi!
Yes. Although, technically, the database will reside with the server
installation on the NT machine. :)
You just need the *client* program(s) on your win98 box.
http://www.mysql.com/doc/m
Paul Wisén writes:
> This works:
>
> mysql> select trim('foo' FROM 'foobaar');
> ++
> | trim('foo' FROM 'foobaar') |
> ++
> | baar |
> ++
> 1 row in
I can't seem to get mysql server started on win2k. hell I don't even know which file
to run to start it up. I did try all though and nothing seems to work.
Tom
Hi
I have developed several apps using Access/ADO front end via
MyODBC with MySQL back end over the last couple of years.
There are 2 problems that I come across time and time again, and I
wondered if anyone could throw any light on these.
To recreate these I made a table on my MySQL server c
If you've been reading all the mail I've been generating about
replication recently, you know what this is. If not, read on...
WHAT IS IT?
---
myrepl is a Perl script which helps to setup replication for the
first time on a MySQL master server. myrepl will do all of its
work
Anyone here keeping MySQL on a separate server than their Apache/Linux/PHP box?
Any advice?
I assume I should re-use persistent connections and things like that to reduce needing
to open new connections via TCP/IP.
But anything else I should know? Any URL where I can read more about doing thi
Hi,
>> This works:
>>
>> mysql> select trim('foo' FROM 'foobaar');
>> ++
>> | trim('foo' FROM 'foobaar') |
>> ++
>> | baar |
>> ++
>> 1 row in set (0.00 sec)
>>
>> This does not work: !
>>
Hi,
I have had the same problem.
After deinstalling the last DCE Patch PHSS_19739 everything works okay.
Best regards
Andre
On 18-Jan-01 [EMAIL PROTECTED] wrote:
>>Description:
> I downloaded the binary for mysql-3.23.30-gamma-hp-hpux10.20-hppa1.1.
> And followed the following procedure :-
Hi,
Problem description:
Yesterday, mysqld died with following message in error log:
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that
may
help in finding out why mysqld died
Attemping
Hi
At 21:45 17/01/2001 -0500, Chetram Ramnarain wrote:
>Hello,
>
>I am trying to download a copy of MySQL for my Win 98/NT computer. There are
>so many different kinds of downloads, which one do I choose. Which
>documentation do I need? HELP! Anyone. I am trying to learn this software,
>as it was
Hi
I'm trying to do a search-engine that searches for "whole words only"
Example:
There are 3 companies in the database:
1. WineMaster
2. Taste of Wine
3. There is some wine in the garden
The table is called tbCompanies, and have the field Company.
How do I select-statement that searches for W
i have a problem using mysql
queries like = "select id from table1 where id in (select id2 from table2)" doesn't
seem to work in the mysql version i have .
if anyone knows how to resolve the problems, please reply to my message
thank u all
Maybe you should read the manual for the answer! It is well explained under
Limitations!
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> "Rih Naoufal" <[EMAIL PROTECTED]> 2001/01/18 01:45:07 >>>
i have a problem using mysql
queries like = "select id from table1 where id in (select id2 from table2)"
Hi!
I'm trying to recompile the server with support for more than 16 keys.
This is what i have changed:
sql/unireg.h:#define MAX_KEY 32 /* Max used keys
*/
But when i try to insert data into a table with more than 16 defined
keys i get:
ERROR 1062: Duplicate entry '1' for
I guess I can replace it with a null string..
select REPLACE('foo', 'foo', '');
Works just fine!
Thanx!
Well, then my SET problems is fixed.
I wanted a way to add, replace or remove elements in a set without doing
it with any extra code.
fyi then, this could come handy.
To:
Add an element
Joseph Bueno writes:
> Hi,
>
> Problem description:
> Yesterday, mysqld died with following message in error log:
>
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tells you how to use a
> stack trace and/or the core file to produce a readable backtrace that
> ma
Stefan Olsson writes:
> Hi!
>
> I'm trying to recompile the server with support for more than 16 keys.
> This is what i have changed:
> sql/unireg.h:#define MAX_KEY 32 /* Max used keys
> */
>
> But when i try to insert data into a table with more than 16 defined
One of the buggy ones is Internet Explorer 5.x for Mac.
Nikke
> The problem is a buggy browser that decides to submit http:// or some other
> non-empty garbage for a referrer. manual.php gives absolute URL for the
> search results to bounce you back to the mirror if you search from the
> mirror.
Sinisa Milivojevic wrote:
>
> Stefan Olsson writes:
> > Hi!
> >
> > I'm trying to recompile the server with support for more than 16 keys.
> > This is what i have changed:
> > sql/unireg.h:#define MAX_KEY 32 /* Max used keys
> > */
> >
> > But when i try to insert
Valgard Blondal wrote:
>
> Hi,
>
> I was wandering if someone could help on this.
>
> I am using mysql with php3 on a shared server, version 3.22.32
>
> I had been running this for few days without any problems, but
> when about 100 users were in to the database, the sign up form
> at http://w
Adam Weeks wrote:
>
> I'm running RH7 with the most recent updates to mySQL from RH's update
> pages, but I'm still having problems accessing the SQL server through
> the client as "myself" (root is fine, of course)
>
> Even with full permissions,
> I get
> ERROR 2002: Can't connect to local MyS
Stefan Olsson writes:
> By new mysql you mean which version ?
> In this new version, is it the same variable to change?
>
> /Stefan
>
> --
> I have yet to see any problem, however complicated, which, when looked
> at in the right way, did not become still more complicated.
>
I meant
Fai wrote:
>
> According to MySQL rule, the column matching order in mysql database should be as
>following:
> ++-+-
> | Host | user|
> ++ +-
> |localhost| |root ||localhost| | ||pit.sample.com |root
>||pit
Oliver Hinds wrote:
>
> Has anyone experienced problems using DBI and perl with update statements
> not updating tables when the equivalent statement at the command line
> works, and all other operations work perfectly?
>
> Oliver Hinds
>
>
Only when I make the wrong assumption about what perl
Charles Crawford wrote:
>
> Description:
> problems starting safe_mysqld --user=mysql &
> How-To-Repeat:
> OK, I tested this on two different servers and got the same results
> with each. Both of the servers have a fresh install of RH 7.0 with
> all of the rpm from
I installed mysql on a Suse 6.4 and it's works, but with only one problem
when I tried connecting from another computer with a php file it says
Warning : MySQL connection failed : host ' ... ' is not allowed to
connect to this MySQL server on ' ... ' line X
If someone could help me please send
From: "Tom" <[EMAIL PROTECTED]>
Sent: Thursday, January 18, 2001 11:18 AM
> I can't seem to get mysql server started on win2k. hell
> I don't even know which file to run to start it up. I did
> try all though and nothing seems to work.
http://www.mysql.com/doc/N/T/NT_start.html
Normally I'm no
Hi,
Still not any info about the buffer-overflow discovered last week ?
Shouldn't be fixed at the beginning of the week ?
Please, dear MySQL team, give us info !!
Regards,
Nicob
-
Before posting, please check:
http://www.my
Hi!
This is the first time I am posting to the MySQL mailing list. So let
us see if this message gets through.
Monty recommended that I should write to this list. I am currently
putting my database engine called Innobase under MySQL as a new
transactional table handler. It is projected to come o
Hello,
I am running out of possibilities. I scaled down my perl script to just
test a database that I have set up. It is a very small program,
however, I get an error when I run the script. I cannot figure out what
the heck is wrong with my commands that would give me those errors. I
just w
Hi,
I need to generate a select statement that has a comparison in it.
I have checked the FAQ to no avail.
I want to write something like this:
SELECT * FROM customers WHERE name =~ 'Jo'
which uses the =~ comparison (used in Perl) to return any records that
contain the letters 'Jo', which could
Try something like:
SELECT your_columns FROM your_table
WHERE Company like '% wine %'
OR Company = 'wine';
This would give all matches for " wine " or "wine"
Not the best I know but it may work in your situation.
- Scott
> I'm trying to do a search-engine that
SELECT * FROM customers WHERE name LIKE "Jo%"
String comparisons are not case sensitive unless the comparison involves a
binary string.
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, J
A small correction: if you want "Jo" to match John or LittleJohn, you need
to do:
SELECT * FROM customers WHERE name LIKE "%Jo%"
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
-Original Message-
From: Craig Atkins [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January
Hi.
I have a database where information is submitted to.
On the submit page I want to show the ID number of next 'thing' to be
submitted.
I use auto increment for the ID.
There must be some way of asking what the last ID number was (I can then add
one to this)
is there a function for this? or do
something like this I was hoping
SELECT MAX([database.[ID]) AS [LAST-DEFECT] FROM [database]
> Hi.
>
> I have a database where information is submitted to.
> On the submit page I want to show the ID number of next 'thing' to be
> submitted.
> I use auto increment for the ID.
> There must be som
Hi!
On Jan 18, Nicolas GREGOIRE wrote:
> Hi,
>
> Still not any info about the buffer-overflow discovered last week ?
> Shouldn't be fixed at the beginning of the week ?
>
> Please, dear MySQL team, give us info !!
>
> Regards,
> Nicob
Fixed in latest release (3.23.31).
Regards,
Sergei
--
My
> Anyone here keeping MySQL on a separate server than their Apache/Linux/PHP box?
>
> Any advice?
>
> I assume I should re-use persistent connections and things like that to reduce
>needing to open new connections via TCP/IP.
>
> But anything else I should know? Any URL where I can read more
> > is there a function for this? or do I have to get all IDs and parse out
>the
> > last one?
Try this function:
SELECT DISTINCT last_insert_id() from "table_name"
Regards,
David
-
Before posting, please c
>Description:
Trying to set the mysql root password using the command line given
results in a permissions error connecting to the database @localhost.
>How-To-Repeat:
Cd to my home directory, and execute:
./usr/local/mysql/bin/mysqladmin -u root password 'anypassword'
>Fix:
Unknown
>Submitter-
>
>But it happens more likely if You load more tables
>at once with a script, e.g.
>
>drop table one
>drop table two
>drop table three
>load table one from master
>load table two from master
>load table three from master
>
>> >load table first,second,...,last from master
>> >
>> >this command sh
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def
I have a calendar db, and in there a base table (with
holidays and such). I need to create a table, exactly the
same as the base (data included). Is there an easy way of
doing this?..
Alejandro Lujan Toro
CAI: Centro de Aplicación de la Informática
Em
Hi Sasha,
Sasha Pachev wrote:
> Apparently, LOAD TABLE FROM MASTER is buggy - until we get it cleaned up, use
> mysqlhotcopy to copy the tables instead. I'll be doing a thorough code
> examination shortly.
nice to hear, this seems to decrease the number of places wher the bug can
hide ;-)
> I
I am getting this message when I run configure in mysql 3.23.30 gamma
installation on Solaris 2.7:
...
configure: error: can not run test program while cross compiling
My hardware is SPARC.
I found in a discussion list that this problem would be related with libm.a
and LD_LIBRARY_PATH. I tr
Jeremy D. Zawodny wrote:
> On Thu, Jan 18, 2001 at 01:09:35AM -0800, Mike Wexler wrote:
>
>
>>> Probably true. I just haven't thought too hard about it. I might
>
>>> be possible today for the *first* slave, but after that it seems
>
>>> like it can't be done.
>
>>
>> I don't see why not.
My set-up:
MySQL server 3.23.30 with MSAccess97 via MyODBC 2.50.36 (all latest patches
to everything)
I have no trouble running this set up, BUT...
Even when I am the only person connected (after flush and restart of
server) and I open my Access database and go directly to edit one
particular t
Hello,
I am working on loading data into a table from a text file. I've read
the documentation on the LOAD DATA command. But I noticed that it only
works with some kind of delimited file. Is there any way to load a
fixed width file???
Thanks in advance!
phiLLip
-
I think it would have to be considered a simple bug. If you're not
convinced by the 'both' example he gave, here's one that's even more
obviously a bug:
mysql> select trim(leading 'foo' from 'foo');
++
| trim(leading 'foo' from 'foo') |
On Thu, 18 Jan 2001, Gerald L. Clark wrote:
> Oliver Hinds wrote:
> >
> > Has anyone experienced problems using DBI and perl with update statements
> > not updating tables when the equivalent statement at the command line
> > works, and all other operations work perfectly?
> >
> > Oliver Hind
Hi,
You can use the function mysql_insert_id(MYSQL *mysql) and add 1 to the
result.
If you want an SQL approach, you might want to use SELECT MAX(your_auto_inc)
FROM your_table
Regards
Jorge
MySQL Development Team
__ ___ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <[EM
We are thinking of moving to MySQL. We have a table of several tens
of millions of rows, with two indices, which will be accessed by
roughly 100 different processes. At any one time, 5 or so of the
processes will be doing selects on the table, while 40 or so will be
doing updates. However, no tw
As far as hardware goes, you should be able to increase performance with
more RAM and faster disks such as UW-160 SCSI.
Also, I don't think they make dual processor motherboards for Athalons.
- Scott
> (The total throughput we need is on the order of 100 indexed updates
> per second; currently
On Thu, Jan 18, 2001 at 04:47:47PM +0200, Heikki Tuuri wrote:
> Monty recommended that I should write to this list. I am currently
> putting my database engine called Innobase under MySQL as a new
> transactional table handler. It is projected to come out with MySQL
> version 4 as free open sourc
I have these tables:
table fields
a IPadd, MAC
u IPadd, MAC, user
si IPadd, deviceID, ifIndex
sf deviceID, ifIndex, MAC
For any given values of IPadd and MAC in 'a' there may or may not
be records in 'u', 'si' and 's
The 1.9.7 manual section (http://www.mysql.com/doc/n/o/node_17.html) is a list
of distributions that includes MySQL, and various distributions arent listed
there.
Conectiva Linux ships MySQL since version 4.0 (up to the last version, 6.0).
Sorry, I'm not in the list, any replys please CC it to m
If there is a possibility for outside testing of this then I would also like
the opportunity, alpha/beta code or not.
Sounds extremely interesting.
Andy Jennings
Programmer/Systems Engineer
eAccountable
214-273-5492
-Original Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Dear All
I can't get mysql-3.23-31 to configure with Berkeley DB support
My configure line is thus:
./configure --prefix=/usr/local/mysql-3.23.31 \
--enable-assembler \
--with-mysqld-ldflags=-all-static \
--with-mysqld-user=mysql \
--localstatedir=/var/lib/mysql \
--sysconfdir=/etc \
--with-ext
Has anyone else experienced a problem in which queries get mangled
(using mysql 3.23.30 for both client and server, client is on redhat
6.2, server is on solaris 2.7)? It appears to happen only for one query
in particular (posted below).
select parts.part_code,parts.price,parts.name FROM parts,p
I have a table called CONTENT. Columns called ID (primarykey), DOCUMENT
(varchar(50)), DESCRIPTION (text). People submit files to our intranet and
we collect info. about them in this table. If people have made changes to
the doc. they just resubmit it to the intranet. So there can be many recor
I am currently developing an export control system that uses mysql and
would be very interested in testing your new tansaction table handler.
Roger Grayson
[EMAIL PROTECTED]
Motorola::SPS::ASP::SoCDT::MACS::me
Andy Jennings wrote:
>
> If there is a possibility for outside testing of this then I
Sorry, I was away for a bit, and got side tracked!
I have a tiered Access application running over a WAN, and performance has turned out
to be an issue. But to convert the Access queries into something that MySQL can
understand takes a while. I started converting them before, but ran into a s
I went to their ftp site and got the updated ones last night and they
worked.
I can't understand why they don't test these things before they release the
CD's.
Oh well, can't complain too much though... it's a pretty nice system
and there is always help around the corner. It just gets frustrati
I run a small business. A year and a half ago I embarked on a jorney to
port my DOS Foxpro Database to linux. I selected mysql as an the engine
and and begand writing the app. using perl/dbi and perlmenu
module/curses as the front end at first I used NFS to share the databse
files on the LAN. I
Hi.
On Thu, Jan 18, 2001 at 03:25:24PM -0500, [EMAIL PROTECTED] wrote:
> Sorry, I was away for a bit, and got side tracked!
>
> I have a tiered Access application running over a WAN, and
> performance has turned out to be an issue. But to convert the
> Access queries into something that MySQL c
Oliver Hinds wrote:
>
> On Thu, 18 Jan 2001, Gerald L. Clark wrote:
>
> > Oliver Hinds wrote:
> > >
> > > Has anyone experienced problems using DBI and perl with update statements
> > > not updating tables when the equivalent statement at the command line
> > > works, and all other operations wo
On Wed, Jan 17, 2001 at 03:17:52PM -0600, Richard Reina wrote:
> I run a small business. A year and a half ago I embarked on a
> jorney to port my DOS Foxpro Database to linux. I selected mysql as
> an the engine and and begand writing the app. using perl/dbi and
> perlmenu module/curses as the
I know it's not "correct" to just jump in and ask and I apologize, but I'm
under a bit of a time crunch here...
I need to find a web front end that I can use to update a table in MySQL.
What I'm looking for is a program that will display an entire table with
records as a web page for editing. So
Dear subscribers
I just baught the book "mySQL" from DuBois and it refers to a sample data base called
samp_db. This data base should be on the url: www.mysql.com/contrib/rxamples/
but this url doesn't existe. If anybody, who read this book has this file or knows
where i can download it from, p
Thanks for the reply. Curses worked OK. But I was convinced that a web
server would be more efficient than NFS for sharing the database files.
Is that true? Or is a NFS a longtime viable solution for clients on the
LAN quering the database.
Richard
"Jeremy D. Zawodny" wrote:
>
> On Wed, Jan
Hello all,
I am running 3.23.31 (rpm install) on a couple servers. The replication is
setup for bi-directional although most, if not all, of the updates are only
going in one direction. The other direction is only if the webserver fails
over and suddenly users are updating the backup server's
On Thu, Jan 18, 2001 at 10:32:35PM +0100, Adel Sabet wrote:
> Dear subscribers
>
> I just baught the book "mySQL" from DuBois and it refers to a sample data base
>called samp_db. This data base should be on the url: www.mysql.com/contrib/rxamples/
> but this url doesn't existe. If anybody, who r
On Wed, Jan 17, 2001 at 03:58:11PM -0600, Richard Reina wrote:
> Thanks for the reply. Curses worked OK. But I was convinced that a
> web server would be more efficient than NFS for sharing the database
> files. Is that true? Or is a NFS a longtime viable solution for
> clients on the LAN que
Hi!
First: Note that it will take a short while until SourceForge and all
mirrors have the new version; Don't email us for a couple of days if
you can't find the 3.23.31 version on a mirror!
MySQL 3.23 is now finally released as a production release.
The 3.23 release has several major new fe
Hi,
Try http://www.mysql.com/documentation/books.html, and in the detail of
Paul's book is a like to download the examples.
Regards
Quentin
-Original Message-
From: Adel Sabet [mailto:[EMAIL PROTECTED]]
Sent: Friday, 19 January 2001 10:33
To: [EMAIL PROTECTED]
Subject: DuBois' book
D
The link contained in the coumentation, http://dbimysql.photoflux.com/,
leads to page that points to a non existant link.
So.I HAVE checked the docs before asking. I require more
information on using the Perl API with my mysql than perldoc DBD:mysql
provides. Any links would be appreciated.
You can connect to the DB on Linux using ODBC over any TCP/IP network, and
you don't need to worry about NFS, File sharing, Samba etc.
All you need is MySQL on Linux connected to your network and ODBC will
connect on port 3306 over TCP/IP, that's all you need.
A system built this way can use many
The client programs connect to mysqld over the network.
Compile the clients to run on the workstations.
Then set your mysql host to be the server.
One server, many clients.
Richard Reina wrote:
>
> Thanks for the reply. Curses worked OK. But I was convinced that a web
> server would be more ef
On Thu, Jan 18, 2001 at 01:49:30PM -0800, Jeremy D. Zawodny wrote:
> On Wed, Jan 17, 2001 at 03:58:11PM -0600, Richard Reina wrote:
>
> > Thanks for the reply. Curses worked OK. But I was convinced that a
> > web server would be more efficient than NFS for sharing the database
> > files. Is th
1. I would just keep the names in the database table. Storing the
images themselves would require a blob field, which means that you would
have to run OPTIMIZE TABLE a lot more often to keep it running fast. If
you just store the name, you can use a varchar. Not only does it take
up less space
Hi!
> "Matt" == Matt Wagner <[EMAIL PROTECTED]> writes:
Matt> Paul Wisén writes:
>> This works:
>>
mysql> select trim('foo' FROM 'foobaar');
>> ++
>> | trim('foo' FROM 'foobaar') |
>> ++
>> | baar |
>> +-
How can I do the following:
update location set location.city_id = location_city.city_id where
location.city = location_city.name;
I want to update one field in a table with values from another table. Is
this possible within MySQL or do I need to write some code to do this.
Any help would be g
Try phpMyAdmin if you are also using php. I use it all the time, works
great.
Search at phpbuilder.com for it.
Jason Frisvold wrote:
> I know it's not "correct" to just jump in and ask and I apologize, but I'm
> under a bit of a time crunch here...
>
> I need to find a web front end that I ca
Can someone tell me whats worng with my syntax:
use DBI;
$dbh = DBI->connect("DBI:mysql:rushload\@leader","richard", "passwd");
leader = name of server, rushload = name of database
Do I need a port number if so which one should I use?
Richard
"Jeremy D. Zawodny" wrote:
>
> On Wed, Jan 17,
Hi.
On Thu, Jan 18, 2001 at 05:39:25PM -0500, [EMAIL PROTECTED] wrote:
>
> How can I do the following:
>
> update location set location.city_id = location_city.city_id where
> location.city = location_city.name;
>
> I want to update one field in a table with values from another table. Is
> thi
The grant was done by:
# echo "grant INSERT,SELECT on snort.* to
snortdb@'XXX.XXX.0.0/255.255.0.0';" | mysql -u root -p
The system has TCP wrappers setup and the hosts.allow file is empty and
hosts.deny is set to ALL:ALL. next time I'm at work I'll try putting in
hosts.allow the ip address of t
>Description:
I just downloaded MySQL 3.23.31 and the "patched version" of
Berkeley DB 3.2.3h from the www.mysql.com site. I ran configure
with the option to enable the Berkeley DB, but it fails, telling
me I don't have the proper version of the DB. Here are the l
hi!
make sure you have the dbi module configured with mysql.
use this syntax:
use DBI;
$dbh = DBI->connect("dbi:mysql:rushload:leader","richard", "passwd");
>Can someone tell me whats worng with my syntax:
>
>use DBI;
>$dbh = DBI->connect("DBI:mysql:rushload\@leader","richard", "passwd");
>
>
1 - 100 of 122 matches
Mail list logo
