Barry,
This can be done using normal insert/update statements. You only have to
'escape' the binary zero, the backslash and the quotes (' or ") out;
suppose jpg contains the binary data, the following code will do the trick:
(pseudo code:)
for (i=length(jpg); i--; i>0) {
if (jpg[i] in [#0,
> Rus wrote:
> >
> > That's strange. I thought that auto_increment field not suppose
> to use same
> > value. May be it's problem connected with transaction. Check doc's on
> > COMMIT. Try to set AUTOCOMMIT=1
>
> It's real. Here is a demonstration. First, the table definition...
Auto_incremen
> hi I am pretty new at this and would like to know how does one store a
> binary blob to the mysql DB ie I would like to store a jpeg to the db
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_13_0
http://www.bitbybit.dk/mysqlfaq/faq.html#ch14_1_0
/ Carsten
--
Carsten H. Pedersen
keeper and mainta
Hi all !
I have a problem : I have a table "my_table".
desc my_table :
FieldType NullKeyDefaultExtra
mytable_sidint(11)
auto_increment
value double (6.2)
this i
Hi,
>> 1. I think I need to optimise table_cache. It's currently set to the
>> default of 64. There are a total of 70 tables on the system. The
>> manual says you should increase table_cache if the Opened_tables
>> status variable is big. How large is 'big'? This value is currently
>> 274 on my s
I have installed MySQL (MySQL-Shareware-3.22_34-WIN) on Windows 9X, and
everything is working properly. And I have just tried to install it on
Windows2000.
The installation run without error. But when I try to up the server by
typing mysqld, the server don't up. Can't MySQL server run on Win2000?
first was an error message in log file ...
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 backtrace. You can use the following inform
I think you could use 'WHERE catid IN'
For example, on PHP
$catlist="1,2,3,4,5";
... select ... where ... catid in ($catlist)
And of course you should use category id in web form instead category name.
- Original Message -
From: Beasley, Julien <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
stack
0x2ab204d7
0x2aba4017
0x2aba3744
0x815ae9f
0x80b8fb3
0x80bec45
0x80be385
0x2ab60213
0x8089f41
db:/raid # resolve_stack_dump -s mysql.sym -n stack
0x2ab204d7 _end + 580057983
0x2aba4017 _end + 580597439
0x2aba3744 _end + 580595180
0x815ae9f my_malloc + 31
0x80b8fb3 vio_new + 27
0x80bec45 ha
While on the subject of backup scripts -
Someone had asked on a message board for my webhost about
whether a script existed for backing up a MySQL database,
and, rotating backups. I couldn't find anything that did
everything that he asked, so I wrote something myself. It's
written in Perl and us
Hi Jan, your problems may OR may not be resolved by upgrading your
Linux(?) system to kernel 2.4x, glibc2.2x and MySql to 2.32.30.
I haven't been able to get a confirmation from the MySQL people that this
actualy solves the problem - it is however clear that it is the dual
CPUs that are causing th
I would much appreciate to hear from experienced mySQL practitioners on
the following:
I have a large relation in mind (strictly fixed length for performance)
with potentially 1-3 million entries.
Associated with each of these rows i have a variable number of blobs.
I would not consider storing t
I don't think that solves his problem, since he wants to know AND, not
OR...
the closest thing I could get to was using select into... although it
seems like it might be possible with a left join, i just can't figure
out how.
one of the things that I thought of with select into was to select cou
Hello all,
I am using Delphi 5 + MyODBC (ADO)
I have a TADOQuery connected to the ODBC data source.
This is my SQL string :
SELECT tnCUSTOMERS.fnADDRESS1,
tnCUSTOMERS.fnADDRESS2,
tnCUSTOMERS.fnPSC,
tnCUSTOMERS.fnCOMPANY,
tnCUSTOMERS.fnICO,
tnCUSTOMERS.fnDIC,
tnINVOICES.fnDATUM_SPLATNOSTI,
tnIN
Hello, I have the problem:
There is server with directory size quotes for users and user's access to his
own MySQL database. Problem: every user can use unlimited disc
space by creating objects in his database. How can i limit size of
each database? I think, it's very useful thing, but i haven't f
>Description:
Mysqld does not stay running -
safe_mysqld produces this output on the console:
Starting mysqld daemon with databases from /var/lib/mysql
010128 20:09:46 mysqld ended
from the log file:
010128 20:09:46 mysqld started
010128 20:09:46 /usr/libexec/mysqld: Can't find file:
'./my
I was wondering what the SQL command is to find the filed names of a
database once it has been created.
I'm trrying to write a script that will allow 'options' table to be created
where there is an ID fiield for the product then fields representing each of
the avalible options eg red blue green w
hi Jamie
I' not too sure about the fields for the tables but I think a better way to
implement this is to seperate the items from the options hence you have
three tables instead of one,ie
table 1
*product_id,
(other product fields)
table 2
*option_id,
name,
value,
Hensen Yi writes:
> I got a error when I run the sample file of Mysql++ , the file is
> simple1.cc
> I compile use below command:
>
> g++ -g -o mysimple simple1.cc /usr/lib/libsqlplus.so -L/usr/lib/mysql
> -I/usr/include/mysql/ -lmysqlclient -lnsl -lz -crypt -lsocket -lm
>
> and I did
Hi
I'm trying to compile to MySQL latin2 sorting and cp1250_latin2
character set conversion.
I've compiled mysql-3.23.31 with these configure options:
--without-debug \
--without-readline \
--enable-shared \
--with-extra-charsets=complex \
--without-bench \
--localstatedir=/var/lib/mysql \
--wi
Hi there!
I'm new to SQL and I can't figure out a query which would give me the result
I need. What I want to do is this:
I have table that stores names of players and number of the game they play
(one player can play more games concurrently). Other users can join the
game. For given user I want
I am new to EJB, so it may be a stupid one, but:
Can MySQL be used for CMP or the database has to suport transactions?
Thanks,
laszlo
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lis
Try sorting in DESCending order.
SELECT * FROM item ORDER BY id DESC LIMIT 10;
-Tilghman
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -Original Message-
> From: Remco van den Berg [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 20
Hi there,
I really get nuts
Macromedia Generator needs COLUMNS to create a chart. But data to be
visualized is stored in one ROW (whole record).
Therefore I need a SQL- query which generates one column out of one row
like:
my wish:my source:
++
| capt.
Hi Dennis,
Also check out Paul Dubois' excellent book, MySQL from New Riders
Ken
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: "MacDonell, Dennis" <[EMAIL PROTECTED]>
To: "'MySQL List'" <[EMAIL
On Wed, Jan 31, 2001 at 08:00:23AM -0600, The Tilghman wrote:
> Try sorting in DESCending order.
>
> SELECT * FROM item ORDER BY id DESC LIMIT 10;
>
> -Tilghman
People,
Thanks for all the answers, but the question was:
"How to get the last 10 items in incrementing order."
Please read threa
Hi,
I am in "little" trouble.
My task is to build an online database.
The company has the database in MS Access and they need to put it on the
website so people can search the database for the retail store nearest them.
My problem is that I am quite new in MySQL and I don't know:
1) how to tran
%% "Evan James Dembskey" <[EMAIL PROTECTED]> writes:
ejd> I believe that MySQL needs to be compiled with GNU make. I have
ejd> to install MySQL on a Dec Alpha running Digital UNIX V4.0D
ejd> (Rev. 878). There are a number of apps running on the Dec that
ejd> require the native make to wor
Patrick Meyer wrote:
> I am slowly gaining connections to the database that just sleep. I know
> these can arise from not closing the database. I am accessing it via MyODBC
> from Active Server Pages. However, I set wait_timeout to 3600... I have
> some that have been there for days... just sl
Remco van den Berg wrote:
>
> On Wed, Jan 31, 2001 at 08:00:23AM -0600, The Tilghman wrote:
> > Try sorting in DESCending order.
> >
> > SELECT * FROM item ORDER BY id DESC LIMIT 10;
> >
> > -Tilghman
>
> People,
>
> Thanks for all the answers, but the question was:
>
> "How to get the last
On Wed, Jan 31, 2001 at 02:25:14PM +0100, Bartlomiej Czardybon wrote:
>
> --
> [TCX] [MyODBC] Can't initialize character set 9
> (path: c:\mysql\share\charsets) (#2019)
> --
>
> There is no directory c:\mysql in default MyODBC Win95 installation ...
>
In MyODBC Readme file there is a sentenc
Hello,I installed Mysql 31 on a server with an NT
platform.Before that there was a Mysql 23 on it.When it is installed I
made new users on it.I did it like that.GRANT ALL PRIVILEGES ON *.*
TO dbuser@***.***.***.***(ip-address) IDENTIFIED BY 'password' WITH GRANT
OPTION;When that is done I ca
I think the only way to do it is first get the amount of items:
SELECT COUNT(*) FROM item;
if you use PHP, store the count in a variable called $count.
subtract 10 from count:
$limit = 10;
if($count < $limit) {
$limit = $count;
}
$count = $count - 10;
if($count < 0) {
$count = 0;
}
th
On Wed, 31 Jan 2001, Andrew Benham wrote:
> I'm glad it's not just me. I have 2 v3.22.32 servers running under
> HP-UX 10.20
> Both servers are being used by FCGI processes on the web with persistant
> connections to the database servers.
Ok, I'll join in on this. I have servers running Slackware
This works:
select * from db.table A, db.table B WHERE A.id=B.id order by B.id,A.id desc
limit 10;
regards
rene
- Original Message -
From: "Remco van den Berg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 3:15 PM
Subject: Re: How to select the 10 last i
mistake, sorry. works not either (see last message)
- Original Message -
From: "Remco van den Berg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 3:15 PM
Subject: Re: How to select the 10 last items from a table?
> On Wed, Jan 31, 2001 at 08:00:23AM -0600,
> That syntax seems correct. Make sure you have defined Row as:
> MYSQL_ROW Row;
Yes this is a structure, not a pointer.
> and that result is defined as
> MYSQL_RES *result;
Yes it is a pointer.
>
> printf("\n\t%u %4s",j,Row); <---YOUR problem seems to be here! change
> Row to Row[0]
Someone please help me. This query has always worked until now, now all of a
sudden I get a weird error:
SELECT DISTINCT(signup_date), COUNT(*) AS count,
CONCAT(SUBSTRING(MONTHNAME(signup_date),1,3), ' ', DAYOFMONTH(signup_date),
', ', YEAR(signup_date)) AS signup_date_display FROM members GROUP
I've noted that Lassolite is available for MySql on
Linux. I'd like to know if anyone knows about when a full
Lasso version for Linux/SQL will be available for purchase.
/Peter
-
Before posting, please check:
http://www.mys
> "SB" == Scott Baker <[EMAIL PROTECTED]> writes:
SB> That's the way that I do. I setup my server to shutdown the MySQL process
SB> at 3am, zip up my var directory, and then restart the process. Can you
SB> copy the data with the server running?
See mysqlhotcopy that comes with recent my
I sent this email two days ago and haven't heard from anyone
>Date: Mon, 29 Jan 2001 14:51:30 -0500
>To: [EMAIL PROTECTED]
>From: Sanam Azeem <[EMAIL PROTECTED]>
>Subject: Error during make...
>
>Hello,
>
>We're installing Mysql source mysql-3.23.8-alpha on AIX 4.3.3.0. We were
>able to run
Hi!
> "Tim" == Tim Bunce <[EMAIL PROTECTED]> writes:
Tim> On Tue, Jan 30, 2001 at 01:13:43PM -0800, Jeremy D. Zawodny wrote:
>> On Tue, Jan 30, 2001 at 05:08:46PM +, Tim Bunce wrote:
>> > On Tue, Jan 30, 2001 at 10:57:16PM +0800, Sam Wong wrote:
>> > > >
>> > > > So why isn't the --with
> "EJD" == Evan James Dembskey <[EMAIL PROTECTED]> writes:
EJD> is it possible to install Gnu make onto teh Dec in a way that it does not
EJD> interfere at all with the rest of the system? If so, how do I do it?
When you install gnu make, call it "gmake". Then run "gmake" when you
need it.
I have downloaded the .zip file for Windows 95/98/NT/2000. Does it work for
Windows ME? Also I have heard, and I can't remember where from, that if you
are using a win32 version it has to be licensed. Is that the case? I will
be using it along with MyODBC to pull data from an AS400 to automate
I don't know if this is a solution, but you could try using the latest stable
source code 3.23.32 and see if it fixed the problem.
> >We're installing Mysql source mysql-3.23.8-alpha on AIX 4.3.3.0. We were
> >able to run configure without a problem but have problem once make is run,
> >we rec
Daren Cotter wrote:
>
> Someone please help me. This query has always worked until now, now all of a
> sudden I get a weird error:
>
> SELECT DISTINCT(signup_date), COUNT(*) AS count,
> CONCAT(SUBSTRING(MONTHNAME(signup_date),1,3), ' ', DAYOFMONTH(signup_date),
> ', ', YEAR(signup_date)) AS sign
Hi,
Converting from Access to mySQL:
You can use myaccess from www.mysql.com it's a script to paste in MSAccess
that generates the SQL with tables and data, or
you can use DBTools (http://dbtools.vila.bol.com.br), it's a client for
windows with import wizard to import from MDB/XLS/DBF/DB and ODB
Hi,
> I've noted that Lassolite is available for MySql on
> Linux. I'd like to know if anyone knows about when a full
> Lasso version for Linux/SQL will be available for purchase.
All the information Blue World - whom I wouldn't touch with the proverbial
barge pole, due to previous experiences w
I'm trying to remember... yes I did have that problem. It's fixed now. I
think you just need to have a primary key that is auto_incremented and the
newest MyODBC.
At 06:49 PM 1/30/2001 -0800, Gregory King wrote:
>Im trying to use myodbc to enter some data through MS access. The problem
>is
At 12:08 PM -0500 1/30/01, Angela wrote:
>I'm guessing you're using PHP? I know when we did some upgrades, the
>function changed. It used to be mysql_inser_id([result set]), but when
>we upgraded it now wants mysql_insert_id([mysql link])
>I believe it was a change between PHP3 and PHP4, but I c
Hello!
On a Sun with
SunOS ai001273 5.6 Generic_105181-13 sun4u sparc SUNW,Ultra-30
I configured
./configure --prefix=/opt/ZITP7.33 --enable-shared --with-pthread
--with-low-memory --enable-assembler --enable-thread-safe-client
--with-mysqld-user=www --without-readline --with-e
At 10:25 AM -0600 1/31/01, Gerald L. Clark wrote:
>Daren Cotter wrote:
>>
>> Someone please help me. This query has always worked until now, now all of a
>> sudden I get a weird error:
>>
>> SELECT DISTINCT(signup_date), COUNT(*) AS count,
>> CONCAT(SUBSTRING(MONTHNAME(signup_date),1,3), ' ',
I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1
and for database connection i use mm.mysql.jdbc-1.2c
Here is my problem
I have got MySql to run fine but when i try to interfaec it over the web i get
te follwoing error
error 500
javax.servlet.ServletException: Ser
its not pretty and its not Perl, but this is what we use:
#!/bin/sh
cd ../mysql
for d in *
do
mysqldump -u root --password=putyourpasswordhere --add-drop-table -l $d >
../mysqlback/$d.dmp
done
Script is run from /var/lib/mydump so ../mysql gets /var/lib/mydump
which under debian is the direct
I'm running a simple master/slave configuration with mysql-3.23.29-gamma
under Solaris 2.6. Sometime last night, one of the tables disappeared
on the slave. I got thousands of errors like this:
Can't open file: 'netgroup.MYD'. (errno: 144)
I fixed it with `drop table netgroup' and `loa
At the risk of getting flamed for something that may or may not be in the
manual,
at the beginning of Paul's email
% perror 127
127 = Record-file is crashed
When I did a man perror from Solaris 2.6, it says that perror returns the
last system
error. I guess what's confusing me is that an erro
If your using PHP there is an article here on doing it with PHP3, it works
on 4 as well. HTH
http://www.phpbuilder.com/columns/florian19991014.php3
Dave W.
-Original Message-
From: Barry Radloff [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 10:56 PM
To: '[EMAIL P
At 9:34 AM -0800 1/31/01, Oson, Chris M. wrote:
>At the risk of getting flamed for something that may or may not be in the
>manual,
>at the beginning of Paul's email
>
>% perror 127
>127 = Record-file is crashed
>
>When I did a man perror from Solaris 2.6, it says that perror returns the
>last sys
Not sure if this was ever asked, but I'm fighting a dilemma over
here and the answer to this greatly affects what I'll end up doing: I
know I can PULL FROM an MySQL database (sitting on a Limix box) INTO MS
Excel. And that works great. However, I'm looking for a way to go the
other way aro
Hi,
I have only used MySQL. Today I read that all SQL use the same
query-language, so if you program something, e.g. in PHP, you can also use
is with other SQL-databases, with perhaps minor adjustments for the
database-connections.
Is this true?
Regards,
Sumarlidi Einar Dadason
SED - Graphic D
Sorry, that's not a very good formulation of the question.
I have 2 tables, and I want to retrieve data from records in table
A only if there are corresponding records in B. I don't care what's in the
records in table B: all I want to know is which items in A _have_ records
in B.
If I do
Try Mascon's Copy&Paste or Import & Export: http://www.scibit.com/Mascon
> -Original Message-
> From: Ashley M. Kirchner [mailto:[EMAIL PROTECTED]]
> Sent: 31 January 2001 20:19
> To: MySQL Mailing List
> Subject: Excel->MySQL
>
>
>
> Not sure if this was ever asked, but I'm fighti
SQL itself is not the way the data is stored. SQL stands for Structured
Query Language and is a way of retrieving and modifying/adding records.
If you write your SQL carefuly, yes you can use it pretty much "as is" on
any SQL system. There are little changes and such however that every SQL
serv
I have just installed MyODBC on my machine (Windows ME) and everything is
working fine, but I've looked through the manual and I can't find anything
showing commands on how to connect to other databases. Can someone point me
in the right direction?
Thanks.
John Halladay
--
Hi,
Can I have two (or more) different SQL-databases running at the same time on
the same server (or same computer)? Does it varies between the systems?
And if I can, are they all available to PHP at the same time?
Regards,
Sumarlidi Einar Dadason
SED - Graphic Design
SQL is a language that is based on standards that are modified every so
often. So,
yes, in general there are SQL statements that you put together will work
with Access,
MSSQL, Informix, DB2, and Oracle, etc.
But *THE* key issue is that each DBMS application has it's own hooks that
are nativ
>Description:
Replication problem. When I restart my slave server, it is unable to connect
to the master. It says it cannot find the log file on the server. I noticed that it
looks like the log file it's looking for looks correct but it has has a Line-Feed
included in it. I tried fixing
Just because you send a message doesn't mean it's gonna get answered!!
Have you successfully installed a non alpha version of the db?
On 31 Jan 2001 11:09:33 -0500, Sanam Azeem wrote:
> I sent this email two days ago and haven't heard from anyone
>
> >Date: Mon, 29 Jan 2001 14:51:30 -0500
HI.
i want to syncronize two databases (one locally at my place, one at my isp)
with the same tables/fields.
like i call every xx houres a script and then the things i delete or add
gets added and deleted at my isp too or the other way arround.
is there allready a tool who does this ?
Rio
--
Hi,
I have a problem with mysql 3.23.30 (binary distribution) and Slackware 7.
Runnining different programs that access to database, the numbers of mysqld
grow up.
But when a single program exit, the number of mysqld processes should
decrease by one.
This works on RedHat 7.0 with the same m
SQL is a language used in most database servers. Each database server
however may have a tiny little different syntax, but for the most part
everything is the same. Some databases also include database specific
code which is not portable to other database servers.
PHP, Perl, C, etc. are just lan
Sorry for having to post the same problem a second time -
but by now I'm really at a loss.
Is there really no one out there to give me a hint?
I need the output of a query result (all query information is in one
row) in one column (!). So, e.g., if you have all temperature lows in
one row, how ca
Hi there,
I'm using MySQL 2.50.36.nt from Visual FoxPro 6.0 SP4. The OS is Windows
2000 Professional.
I've created a database with a remote view. The remote view was generated
using the Wizard. I selected MySQL from used Available Data Sources. The
remote view of the table demo from the MySQ
Change the way it's stored in the table.
Seriously, if the data is stored in a single row, there is no way via SQL
(not defined in standards, not available in any SQL server implementation
I've seen either), then the program has to convert that into columns. The
standard mysql utility is capable
A database server can contain multiple databases.
On 31 Jan 2001 19:01:02 +, SED wrote:
> Hi,
>
> Can I have two (or more) different SQL-databases running at the same time on
> the same server (or same computer)? Does it varies between the systems?
>
> And if I can, are they all available
Yeah, you should really change the way the database is setup but you
could also do something like this. Have perl return an array and just do
a foreach on the array and that will give you all the values of each
column on the row, without you knowing how many rows there are.
Even if your not usin
SED wrote:
>
> Hi,
>
> Can I have two (or more) different SQL-databases running at the same time on
> the same server (or same computer)? Does it varies between the systems?
>
> And if I can, are they all available to PHP at the same time?
>
> Regards,
> Sumarlidi Einar Dadason
See "create d
Hi,
I'm sorry, for my previus question "To thread or not to thread "
but now all it's OK. :)
Looking at /etc/my.cnf, i could see two variables:
set-variable= thread_cache=8
set-variable= thread_concurrency=8 # Try number of CPU's*2
this should set the edge to the maximum threads
On Wed, Jan 31, 2001 at 05:07:09PM +0200, Michael Widenius wrote:
>
> The problem is not just the open; The problem is that we currently have to map
> all read/writes to a handler that checks if the table is raid or not.
Fair enough.
> What we need in the future is to add a wrapper around file
I need to run more mysql processes than the default of 3. Where is this
configured?
Thanks,
CC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
Hi,
I installed MyODBC and even configured it. MySQL db running on Solaris is
running under the root user. While defining the DSN using MyODBC in the
username I tried putting root user and the password for the same but I keep
getting error "can't connect to MySQL Server". The instance for MySQL i
I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1
and for database connection i use mm.mysql.jdbc-1.2c
Here is my problem
I have got MySql to run fine but when i try to interfaec it over the web i get
te follwoing error
error 500
javax.servlet.ServletException: Ser
We're looking at moving a web-based application currently built with
Microsoft Access and Cold Fusion to a real database platform. I've only
just started poking around mySQL, so I'm not really up on its capabilities.
One of the things this application relies on fairly heavily is stored
queries (
select t2.id from gamers t1,games t2 where t1.user="jack" and t2.id<>t1.gid
group by t2.id
Original Message -
From: zbynek <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 4:31 PM
Subject: Selecting games which a given user can join
> Hi there!
>
> I'm new
You just create a DSN in the control panel, and tell your ODBC compliant
software to use that data source.
At 11:46 AM 1/31/2001 -0700, John Halladay wrote:
>I have just installed MyODBC on my machine (Windows ME) and everything is
>working fine, but I've looked through the manual and I can't f
That's nice :)
- Original Message -
From: Harald Fuchs <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 8:34 PM
Subject: Re: Auto-Increment - how can I avoid repeating IDs?
> In article <009f01c08b0f$c85bbec0$be66bcd4@ruscomp>,
> [EMAIL PROTECTED] ("Rus") wr
"Jesse E. Stay II" wrote:
>
> I seem to have run into a problem lately where all of the sudden my
> server keeps giving me "too many connections" errors, locking anyone out
> of the site. I have set max_connections to 210, which shouldn't matter
> anyway because we haven't had any more users tha
If i get it right, you should use CONCAT
- Original Message -
From: leo.putz <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 31, 2001 10:50 PM
Subject: Once again ... row to column conversion
> Sorry for having to post the same problem a second time -
> but by now I
Hi,
When you say 'hangs', what do you mean? Does CTRL-C work? Does the server
have to be killed with kill -9?
Are you running the program in the background?
# bin/safe_mysqld &
If so, can mysql CLI connect to the running server?
Regards
quentin
-Original Message-
From: David Birchfi
i too am interested, especially for the Mac.
pleasepleasepleaseplease
At 5:14 PM -0800 1/31/01, David Wilde wrote:
>Has anyone ever been able to get ER/Studio to work with MySQL? Are there
>any other database design tools such as ER/Studio that support MySQL
>directly? Is this a project for sou
Hi,
Each time I install mysql from a binary release that I have created, I have
to modify safe_mysqld so that it can be called from mysql.server.
This is because safe_mysqld checks to see if it knows what is going on
before checking the command line args to see where things should be.
Shouldn't
Don't know for sure with Mac, but if it's the same as *nix, it means you
haven't started the mysql server yet. Once you start it, the socket file
will automatically be created. The manual explains this.
- Original Message -
From: "Peter Likidis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED
No, mysql cannot connect to other database servers, it can't even connect
to other mysql servers except through replication.
John Halladay wrote:
>
> Connecting to the tables in MySQL works fine. For example I can connect to
> the MySQL tables using MS Access. I would like to know if it is po
Hi, I'm trying to make mysqlgui on Linux 6.x. I have the following problem and any
advice will be welcome:
g++ -O3 -g -pipe -fforce-mem -fforce-addr -I. -I../mysql++-1.7.8/sqlplusint
-I../mysql-3.23.26/include -c do_sql.cc
do_sql.cc: In function `stat
Gosh, this list is broken. No reply-to to the list... Had to manually
forward this message because I saw that only after I send the message to
SED
So sprach SED am Wed, Jan 31, 2001 at 07:01:02PM -:
> Can I have two (or more) different SQL-databases running at the same time on
> the sam
I seem to have run into a problem lately where all of the sudden my
server keeps giving me "too many connections" errors, locking anyone out
of the site. I have set max_connections to 210, which shouldn't matter
anyway because we haven't had any more users than usual accessing the
site. The only
On Wed, Jan 31, 2001 at 08:08:11PM +0100, [EMAIL PROTECTED] wrote:
> HI.
>
> i want to syncronize two databases (one locally at my place, one at
> my isp) with the same tables/fields. like i call every xx houres a
> script and then the things i delete or add gets added and deleted at
> my isp to
That's what I would have suggested as well, but I tried that on a test table
and it returned all t2.id's in t2.
Julien Beasley
Bridge News Asia Applications Specialist
> -Original Message-
> From: Rus [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 01, 2001 10:26 AM
> To: [EMAIL P
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:palmy@TT
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
1 - 100 of 105 matches
Mail list logo
