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--; i0) {
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_increment fields
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
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 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
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
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
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
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
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
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,
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
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:
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 not
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 \
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
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)
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, 2001
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.
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 thread
%% "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 work. So
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 10 items in
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 sentence:
---
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;
}
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
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] and see
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:
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 configure
"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 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 receive
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,
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
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:
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
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
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
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
Try Mascon's CopyPaste 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 fighting a
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
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
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 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
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
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 to
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
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 database"
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
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
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 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:
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
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
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") writes:
"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 than
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'm
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
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
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
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
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 same
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
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 too or
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
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:palmy@TT
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
On Fri, Jan 05, 2001 at 12:10:55AM -0800, Jeremy D. Zawodny wrote:
Is it possible to make a mysql database safe to publish it via an CD
so that noone could read it even if he has good knowledges about
mysql
What good would publishing a database be if nobody can read it?
Perhaps you
I'm working for a company that has a paranoid client, and the client wants
their database to be 'secure'.
By 'secure' they mean that even if someone gains root access on the
server, the data in the database can't be compromised (obtained).
I can think of a couple of ways to do this, but I don't
If you mean databases others have already replied.
If you mean multiple instances of the mysql server then that is also a yes.
I haven't tried but I do know you have to specify a different port for the
2nd instance. This is also in the manual.
- Original Message -
From: "SED" [EMAIL
Hi,
I am trying to setup a new MySQL server where I am working. The old one was on a
machine with Apache/PHP4 and worked fine but recently MySQL was placing a big load on
this machine so we decided to move it to its own server.
I've set it up fine on a machine with Red Hat 7, MySQL 3.23.32
79 matches
Mail list logo