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
Sorry, I'm confused on what you have (machines? what is running on what?),
what your ISP has and what you are trying to do. Do you know about
phpmyadmin program? Maybe it is what you're looking for.
Most importantly, why did your ISP recommend you use ODBC on a Win2k? Do
they have some restric
I am running LInux and MYSQL. My billing program for my ISP has recommended
that I setup ODBC on my Win2k machine so I can execute commands to mysql to
add and remove users. The software has the commands built in, however I must
configure my server and ODBC to work for MYSQL.
Is there any simp
Hi there,
I am setting up a lab on MySQL and I am not able to.
Its a red hat 7.0 server and has PHP installed and working with apache.
I installed MySQL from the very RPMs Red Hat provided.
Whenever I try to start the server, I get the error message:
Can't connect to local MySQL server through so
Is there anyway to tell how many connections are currently being served by
MySQL. I'm using this in combination with PHP. Also, does MySQL
automatically shut down when you leave the page? I'm not using
mysql_pconnect - just the regular mysql_connect.
Thanks,
Mike
---
Rolf Hopkins writes:
> select colname
> from tablename
> where (where clause)
> order by b,a,c
>
> This is all in the manual. If you have a search on the internet, you should
> be able to find a manual in chinese, if you haven't already got one. I know
> there is one in traditional chinese, but
select colname
from tablename
where (where clause)
order by b,a,c
This is all in the manual. If you have a search on the internet, you should
be able to find a manual in chinese, if you haven't already got one. I know
there is one in traditional chinese, but I'm sure there is one for
simplified
I want to write a sql to order by a column, whe column contain only three type
"a", "b", "c",
how can I order by the column with the sequence of b,a,c . thank you.
My english is not well ,sorry.,. :)
Best Regards
LSQ
TEL:13500011809
Company:020-83881512-223
E-mail£
Greg Cope writes:
> Chris Johnson wrote:
> >
> > >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
> >
Adel Sabet writes:
> 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/
Hi!
I see someone else has already answered with the correct URL you
need. But I woul
phiLLip maDDux II writes:
> 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???
Hi!
Unfortunately thi
Someone sent me some samples of various connection type (ADO, DAO, etc)
about a month ago but I'll post off list.
- Original Message -
From: "Dwight Mowbray" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 10:18
Subject: Connecting to MySQL with Visual Basic
H
[EMAIL PROTECTED] writes:
> >Description:
> Installed:
> * MySQL-3.23.27-1.i386.rpmMySQL-shared-3.23.27-1.i386.rpm
> * MySQL-client-3.23.27-1.i386.rpm MySQL-devel-3.23.27-1.i386.rpm
>
> #1)
> Had to use "--nodeps" so the server and client portions would
I am having a table of 60 rows of data with userid as
the primary key. I want to start the new data entry
with the userid '1' instead of from '61' now, how can
i do that with out dropping the table and its content
altogether.
TIA
Chakravarthy K Sannedhi
__
Hi.
Can anyone tell me how or refer me to any tutorials on how to connect to mysql using
Microsoft Visual Basic (v. 6)?
Any help would be much appreciated. Thanks.
Kind regards,
Dwight Mowbray.
E-commerce solutions provider.
Email: [EMAIL PROTECTED]
did big table lock remove from MySQL BDB table while updating?
Regards
David
- Original Message -
From: "Michael Widenius" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 6:45 AM
Subject: MySQL 3.23.31 is released
>
> Hi!
This gives me one instance of each file name in the DOCUMENTS column
submitted into the database. The only thing though is it gives me the
oldest of the file name in the DOCUMENTS column which are submitted. Any
ideas how to get the newest one? I've tried adding: , MAX(ID) after the
SELECT *.
Hi,
I'm curious if anyone knows the purpose of the DELETE_ITEMS defines in
the MySQL source tree. I'm guessing they were either put there by their
memory leak checking software, or perhaps to bypass broken compilers? I
see the defines in both 3.22.32's and 3.23.30-gamma's source trees.
I'm on Fr
>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 mcuser.usr_id = mcorder.usr_id)
> on project.prj_id = mcorder.prj_id;
No sir. You've separated th
>Description:
Installed:
* MySQL-3.23.27-1.i386.rpmMySQL-shared-3.23.27-1.i386.rpm
* MySQL-client-3.23.27-1.i386.rpm MySQL-devel-3.23.27-1.i386.rpm
#1)
Had to use "--nodeps" so the server and client portions would pass
the "/usr/bin/perl
Chris Johnson wrote:
>
> >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
Hi,
Running
# perror -v 132
gives
132 = No buffer space available
132 = Old database file
which result is correct?
Quentin Bennett
Transport Systems Division
Infinity Solutions
Phone: + 64 9 358 9720
Fax : + 64 9 309 4142
mailto:[EMAIL PROTECTED]
http://www.infinity.co.nz
The information c
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");
>
>
>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
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
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
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,
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
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
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 |
>> +-
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
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
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
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 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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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 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
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
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
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
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]]
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
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
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
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
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
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
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
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') |
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
-
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
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.
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
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 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
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
>
>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
>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-
> > 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
> 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
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
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.
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
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
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
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
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
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!
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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)"
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
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
1 - 100 of 122 matches
Mail list logo
