Hi!
Sorry if I ask this on the wrong list but it seemed like the best choice
:)
I'm trying to install a MySQL binary downloaded from MySQl
(mysql-standard-4.0.13-ibm-aix4.3.3.0-powerpc) on a AIX 4.3 (oslevel
4.3.3.0)
I have IBM's C for AIX ver 4.4.0 and gcc version 3.2.3 installed on the
machin
please clarify use of set autocommit
SET AUTOCOMMIT = 0 ==> mean start transaction
... - some actions
COMMIT ==> transaction end
now to return to autocommit mode
just one line:
SET AUTOCOMMIT = 1
or two?
SET AUTOCOMMIT = 1
COMMIT
t
I'm new to MySQL, and only have limited experience in modifying some legacy
dBase IV code.
One of the minor aggravations I occasionally encounter when using management
systems is how best to handle names, particularly the many individual name
segments of names. Typically the name field is of a
# [EMAIL PROTECTED] / 2003-06-29 23:24:58 -0500:
>
> > # [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500:
> > > CREATE TABLE extraFieldOptions (
> > > fieldID tinyint(3) unsigned NOT NULL default '0',
> > > fieldOption varchar(16) NOT NULL default '',
> > > fieldValue varchar(16) NOT NULL defa
Shouldn't be a problem.. if you already have a private link between sites
your set, if not drop in a vpn solution to ensure end to end security..
The only main difference betten your situation and most (all servers are
feet apart at LAN speed) is the WAN thruput/etc.. Mysql should keep
re-tryi
If you want to store images in the database, use a blob columntype.. And
take a look at this example alot of people have based mysql binary
storage off: http://www.php4.com/forums/viewtopic.php?t=6
good luck
On Sun, 29 Jun 2003, Digital Directory USA wrote:
> I am new to php and mysql, I have
> # [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500:
> > CREATE TABLE extraFieldOptions (
> > fieldID tinyint(3) unsigned NOT NULL default '0',
> > fieldOption varchar(16) NOT NULL default '',
> > fieldValue varchar(16) NOT NULL default '',
> > PRIMARY KEY (fieldID,fieldOption)
> > ) TYPE=M
# [EMAIL PROTECTED] / 2003-06-29 13:09:03 -0500:
> CREATE TABLE extraFieldOptions (
> fieldID tinyint(3) unsigned NOT NULL default '0',
> fieldOption varchar(16) NOT NULL default '',
> fieldValue varchar(16) NOT NULL default '',
> PRIMARY KEY (fieldID,fieldOption)
> ) TYPE=MyISAM;
> mysq
1 mi. = 1.609 Km.
;-)
On Sunday, June 29, 2003, at 10:37 PM, Rohan Hawthorne wrote:
We work in a largely distributed environment, with servers in the main
server room being thousands of kilometers (that's about 3/4 of a mile)
from clients.
We are hoping to set up a replication system so that sel
We work in a largely distributed environment, with servers in the main
server room being thousands of kilometers (that's about 3/4 of a mile)
from clients.
We are hoping to set up a replication system so that select queries go
to the local server (slave) at
the client and update queries go to t
> In that case they are probably fixed width files. If they are not fixed
> with and are in fact delimited by tab or comma, you can use LOAD DATA to
> bring them in.
>
> See http://www.mysql.com/doc/en/LOAD_DATA.html
And if they are fixed width, you can write a script in something like
Perl to un
At 18:27 + 6/29/03, Blake Howe wrote:
OK i am having problems starting the mysql server on Redhat Linux 8.0.
A little aboutmy background. I have some experience getting around
in linux on the command line. Proably enough just to be dangerous
:-). I have installed and used Mysql under Windows
At 19:32 +0100 6/29/03, Peter Lovatt wrote:
Hi
did you run mysql_install_db ? This sets up the mysql database and initial
privilages
The RPM install should do that automatically.
Peter
-Original Message-
From: Blake Howe [mailto:[EMAIL PROTECTED]
Sent: 29 June 2003 19:27
To: [EMAIL PROTE
> Can any one help me?
Hard to tell without more information. Also, since the issues are likely
to be system/CPU dependent, you may need to ask on a netBSD list, as
well.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
PS:
At 13:18 +0200 6/29/03, Mark Rowlands wrote:
I have a tabletheres a surprise
month protocol port utime
06 tcp21 12
06 tcp21 13
05 udp 43 100232
05 udp 21 100245
what I would like to do is select by month and by protocol but with
# [EMAIL PROTECTED] / 2003-06-28 16:56:13 +0200:
> I use mySQL on HP/UX 11.i - unfortunateley I am unable to lookup the
> used version. What is the command to do that? (according to mysql.info
> it is Version 3.23.42. )
SELECT VERSION();
--
If you cc me or remove the list(s) completely I'll
>Description:
I have just installed MySQL 4.0.4 on Linux kernel 2.4.2-2 on a
Hewlett-Packard
Kayak machine. I ran the mysql_install_db script with no problems,
but am unable
to create a root password as directed by the script. I have started
MySQL with
./bin/mysqld_s
"insane"
you mean extremely fast? or easy to use? i'd like to know what those SPs are good
for...
-yves
-Ursprüngliche Nachricht-
Von: "electroteque" <[EMAIL PROTECTED]>
An: <[EMAIL PROTECTED]>
Gesendet: Montag, 30. Juni 2003 00:09
Betreff: RE: stored procedures in mysql5
> thanks th
thanks this is pretty insane cant wait for its release :D
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 6:07 AM
To: electroteque
Cc: Mysql
Subject: Re: stored procedures in mysql5
On Sun, Jun 29, 2003 at 08:00:29PM +1000, electroteque wrote
On Sun, Jun 29, 2003 at 08:00:29PM +1000, electroteque wrote:
> ok i have a bleeding edge server instance on my server apache2/php5/mysql5
> running alongside the stable server , is stored procedures actually
> functioning in it yet ? is this the correct syntax there is no documentation
> for it ye
Hi,
You have to insert a new blob field where you can store binary data. But
it is not recommanded to store images in a database. I recommande you to
store images on a server filesystem and only the reference to the
images in a database.
Armand
Digital Directory USA wrote:
I am new to php an
Hi all,
Now I'm facing a big problem and see if anyone know how to solve it. I'm
using RS6000 AIX 4.3.2 CPU*2 1G RAM with HA. And DB is MySQL 4.0.12-max.
Here is the content of my.cnf.
[client]
#password = your_password
port= 3306
socket = /tmp/mysql.sock
# Here follo
Hi
did you run mysql_install_db ? This sets up the mysql database and initial
privilages
Peter
-Original Message-
From: Blake Howe [mailto:[EMAIL PROTECTED]
Sent: 29 June 2003 19:27
To: [EMAIL PROTECTED]
Subject: mysql server wont start
OK i am having problems starting the mysql server
I am new to php and mysql, I have searched looked over and cannot find a way to do
this... can it be done?
I have set up the following in mysql. How do I upload the product images to the pPhoto
column. Any suggestions?
ds_produc
Field Type Attributes Null Default Extra
pID
OK i am having problems starting the mysql server on Redhat Linux 8.0.
A little aboutmy background. I have some experience getting around in linux
on the command line. Proably enough just to be dangerous :-). I have
installed and used Mysql under Windows 2000 no problem.
Question:
I installed
I have a table with a two-field primary key, it's structure is like this:
CREATE TABLE extraFieldOptions (
fieldID tinyint(3) unsigned NOT NULL default '0',
fieldOption varchar(16) NOT NULL default '',
fieldValue varchar(16) NOT NULL default '',
PRIMARY KEY (fieldID,fieldOption)
) TYPE=M
# [EMAIL PROTECTED] / 2003-06-29 08:14:28 +0100:
> The table customer_basket contains the products_id which is no good
> for my routine. What I need to check is the categories_id but there
> is no reference in the customers_basket.
>
> Presumably I need to do a join on the table that holds the ca
# [EMAIL PROTECTED] / 2003-06-17 11:44:46 -0400:
> At 05:14 PM 6/16/2003, Roman Neuhauser wrote:
> ># [EMAIL PROTECTED] / 2003-06-16 15:15:31 -0400:
> >> I can use:
> >>
> >> SELECT sum(if(voidreason>0,0,amt)) as sales FROM sdtik where acctno=1234
> >> and datein>=20020615
> >>
> >> to gather custo
I am interested in any thoughts that people may have for creating a scalable mysql
infrastructure.
I have a web application which runs on several front end web servers which hit one
backend mysql
server. Presently I can continue to grow by adding front end webservers -- the mysql
server is not
I cannot find how to upload graphics to a mysql database. Any suggestions?
George Guebely
Digital Directory USA, Inc
(562)628-9677
otherguy (Cameron Wilhelm ) wrote:
Well, keep in mind that although SQL can do a lot in a single
statement, it can't always do *everything* required for a business
function in one statement.
As I'm painfully aware of, but was hopeful about.
Your hopes were sensible -- I believe that some SQL v
I have a tabletheres a surprise
month protocol port utime
06 tcp21 12
06 tcp21 13
05 udp 43 100232
05 udp 21 100245
what I would like to do is select by month and by protocol but within
protocol limit to the top 5 by count of
Hi,
Anyone out there ever successfully implement the
Microsoft Project SQL database architecture on a MySQL server?
-tv
Tom VanderMeulen; mailto:[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTEC
On Sat, Jun 28, 2003 at 01:47:28PM -0400, Wendell Dingus wrote:
> Hello, I've got a situation I'm hoping someone here can help me out with.
We
> have a web server serving up data via some PHP programs pulling from MySQL
> (3.23.56 currently) in INNODB tables. There are 40+ (active) databases
> t
ok i have a bleeding edge server instance on my server apache2/php5/mysql5
running alongside the stable server , is stored procedures actually
functioning in it yet ? is this the correct syntax there is no documentation
for it yet.
create procedure test as select * from tablename;
--
MySQL Gener
Hi,
I think there where 2 possibilities.
1. Add to the customers_basket table the categories_id
SELECT
cat.*
FROM
customers_basket AS cb,
categories AS cat
WHERE
products_id=7
AND
cb.categories_id=cat.categories_id
2. Make a relation table
CREATE TABLE relation_product_category (
On Sun, Jun 29, 2003 at 09:38:09AM +0200, Richard Fuchs wrote:
>
> well it wasn't my choice. personally i'm a linux guy, but right now i'd
> rather have minimum downtime w/o too much playing around.
Ah, got it.
> > Interesting. The skip-name-resolve shouldn't be an issue when using
> > LinuxTh
I am sorry, I forgot to mention that MySql passed or skipped all tests
up to the
ctype_latin1_de test the message in terminal is
ERROR: /usr/local/stayathome/mysql/mysql-test/var/run/master.pid
was not created in 30 seconds; Aborting
I have tried mysql-test-run --force (times out after 30 secon
Jeremy Zawodny wrote:
On Sun, Jun 29, 2003 at 08:55:30AM +0200, Richard Fuchs wrote:
Jeremy Zawodny wrote:
On Sat, Jun 28, 2003 at 01:14:37PM +0200, Richard Fuchs wrote:
are there any known issues with this combination, or with mysql 4.0.13
or freebsd 5.1 in general? what could be the cause fo
[EMAIL PROTECTED] wrote:
Thanks Salam, but a question: this would mean that I must do by hand
every record ID link, no?
I don't think you are building your master html page by hand, do you?
No, of course no hand work.
The script should take care of it e.g. in a loop while fetching the records
Hi MySQL
I want to run a result through a routine but I need to get the result first :)
The table customer_basket contains the products_id which is no good for my
routine. What I need to check is the categories_id but there is no reference in
the customers_basket.
Presumably I need to do a join
On Sun, Jun 29, 2003 at 08:55:30AM +0200, Richard Fuchs wrote:
> Jeremy Zawodny wrote:
> > On Sat, Jun 28, 2003 at 01:14:37PM +0200, Richard Fuchs wrote:
> >
>
> >>
> >>are there any known issues with this combination, or with mysql 4.0.13
> >>or freebsd 5.1 in general? what could be the cause f
42 matches
Mail list logo
