Hi Leandro
This is a HPUX problem. This errormessage gives you the real problem :
: setrlimit couldn't increase number of open files to more than 60
you have to change the kernel settings to allow the OS to use more than 60
simultaneous open files.
if you use the "sam" program and choose "sam ker
Hi,
I have a table:
CREATE TABLE WI_PICTUREFILES (
SECTIONID VARCHAR(50) BINARY NOT NULL,
PICTUREID VARCHAR(50) BINARY,
PICTUREFILE VARCHAR(200) BINARY NOT NULL,
PICFILEXT VARCHAR(5) BINARY NOT NULL,
SHEETNO VARCHAR(2) BINARY,
Dear sir,
i am trying to intall mysql on red hat linux 6.0 ,pls advise me from where will i get
the installable and how to install it with the help of rpm utility.
with regards
Vijay NIIT_gry
-
Before posting, pleas
Synopsis: 3.23.42 & 3.23.41 won't compile
Release: mysql-3.23.42 (Source distribution)
Environment:
Redhat Linux 7.0 w/
Linux version 2.2.16-22
gcc version 3.0.1 (3.0 has same results)
glibc: 1.2
Build options:
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-r
Just to join ALL the records from ALL 15 tables together in one big blob of
data and have there be a something that tells me which table each record
comes from.
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Deryck Henson" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL P
This relates to the earlier posts I made about left joins. I was shown how
to do it with a where clause, but now how do I do it WITHOUT one? Like
SELECT * FROM basetable left join 2ndtable on (basetable.*=2ndtable.*)
Something like that... I need help with this as you can see.
- Deryck H
- h
>
>
>
>Original Message Follows
>From: "Rodney Broom" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: Re: uploading 200,000 x 5 rows
>Date: Thu, 13 Sep 2001 18:42:22 -0700
>
>Hi Carlos,
>
>I'm glad to help, but I'd like to clarify several things, first.
>
>thanx a l
OK, well, as you all know, I am using mysql only for ASP Connectivity.
Sooo, this is my question: Every time I try to use this statement to open a
table, it gives me an error::
statement used-
rs.open "SELECT username, codeid FROM user_votes where username =
'"&user&"'", dbconn
if rs.fields("co
Original Message Follows
From: "Rodney Broom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Subject: Re: uploading 200,000 x 5 rows
Date: Thu, 13 Sep 2001 18:42:22 -0700
Hi Carlos,
I'm glad to help, but I'd like to clarify several things, first.
thanx a lot ;)
> ...with about 200,000
I am a new one in database area. Hopefully someone can help me or give me
clue to solve the problem.
I have already run mySql in c:\winnt\System32\cmd.exe, and create a database
(table test1)
in c:\mysql\data\test directory. The classpath I setup in control system
environment, C:\jdk1.3.0_02; c
I am not able to download "WIN 32 static binary of MySQLGUI 1.7.5-2" from
"http://www.mysql.com/downloads/gui-mysqlgui.html "
What is actually happening is that on downloading, the zipped file is not
opening through Winzip and a message is being shown
that the downloaded ziiped file is not a valid
Hi Mark:
"insert delayed" helps little.
I think there are two reasons.
1. One reason "insert delayed" speeding up insertion is that the client
will return immediately after it issues a "insert delayed" query. I think
all those inserts must be stored in a delayed queue and will be executed
w
Hello
[ It seems the post didn't make it through the first time ]
While programming a journal in perl/axkit I realize that the problems
of both creating useful indexes for searching content efficiently and
parse user input and create the right sql queries from it are sooo
common that there *m
Setup mysql a few months back as a backend to radius.
Welp, one thing that caught my attention last week was disk space.
I have mysql going to /usr/local/var (default for mysql I believe)
At any rate when this machine was setup it was given a 15GB /var partition
and just over 1GB for /
Actually, version 4.0 will. I'll have to wait til then but for now, I'll
use you other advice. Thanx
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Loyd Goodbar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 20
Duh on me... what about this (may not work with MySQL, does it support unions
yet?)
insert into mastertable (user,name,info)
(select * from one where user='loyd'
union
select * from two where user='loyd'
union
...)
repeat to table 15. Since 15 tables have the same structure, this will work.
At 07:55 AM 9/13/2001 -0500, Michael Sims wrote:
>Hi,
>
>I posted this query to the list via the newsgroup mailing.database.mysql a
>few days ago but didn't receive any replies.
My apologies to the list...someone in alt.php was kind enough to point out
that my question is answered in section 6.
Dear Educator,
Columbine (Littleton, CO)Jonesboro, ARWest Paducah, KYPearl, MS...
Immediately, you know why these places are linked together. The names of
these schools are forever burned into our memories and the national conscience...
Are you concerned about the rising number of
Hi Siva,
I know I'm about to get in trouble with the FreeBSD people, but here goes:
I'm not a real big fan of FreeBSD's /usr/ports/ thing. My suggestion would be to
download the source in a TAR ball, unpack it, run:
% configure
% make
% make install
If that doesn't succeed, hollar back with t
What version of FreeBSD do you have installed? Was it upgraded from an
earlier version? If so, was the ports collection upgraded as well?
This sounds like you have incompatible versions of the system and the ports
collection installed.
- Original Message -
From: "Siva Namburi" <[EMAIL
The directory /usr/local/src/mysql-3.23.42-source-bin/var/ does not exist on
your system. You probably do not really want your database files stored in
such a cryptic directory name. You probably need to use the --basedir
or --datadir parameters to mysqld to tell it where your databases really
Well lets get it running
Basic install nothing fancy
./configure
make
make install
to fix your error create a symlink
su to root
ln -s var/lib/mysql/mysql.sock /tmp/mysql.sock
Cheers
M;)
-Original Message-
From: Nick Torenvliet [mailto:[EMAIL PROTECTED]]
Sent: Thursday, Septem
Sure...
SQL Query:
SELECT * FROM asp, c, cpp, java, javascript, coldfusion, xml, pascal, vb,
perl, cgi, php, assembly, python where user = '"&user&"'
(gets an ambiguous error and I know why)
Database structure (all tables the same)
Tables- ASP, C, CPP, Java, Javascript, Coldfusion, XML, VB, P
Nick Torenvliet wrote:
> ...I've run ./configure
Did you run 'make'?
---
Rodney Broom
Programmer: Desert.Net
Keywords: sql, spam-off
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Hi Carlos,
I'm glad to help, but I'd like to clarify several things, first.
> ...with about 200,000 data about books
> (title, clasif, year, publisher, authors, subjects, etc etc)
So you have a single file with data for multiple tables?
> After each sequential parsing (one book)
What defi
>Dude, I AM going to be inserting data!
Yeah, I know. And I said below, in effect, "so what"?
I'm still waiting for an answer what that has to do with
anything. When you insert, you insert back into the
original table, not the merge table. So what's the
problem?
>
>- Deryck H
>- http://www.
the sock file is in the /usr/lib/mysql dir i created a symlink of the
file from there to /tmp
On Thu, 2001-09-13 at 14:32, Nick Torenvliet wrote:
>
> I'm trying to start my first ever installation of mysql, so I've installed
> the tar.gz (3.23.42 on Linux) and I've run ./configure from /my
Dude, I AM going to be inserting data!
- Deryck H
- http://www.comp-u-exchange.com
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Deryck Henson" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 8:04 PM
Subject:
At 7:55 PM -0500 9/13/01, Deryck Henson wrote:
>OK, first of all, brilliant and well thought out. One problem, every one of
>my tables are EXACTLY the same. All I want to do is take the records from
>all 15 of the tables where the username(column) in them is what I say. When
>I try to do this,
At 1:46 AM +0100 9/14/01, Jamie Burns wrote:
>Hello,
>
>I have a query as follows:
>
> SELECT products.*, avg(ratings.rating) AS rating
> FROM products, ratings
> WHERE products.ref = ratings.product_ref
> GROUP BY products.ref
> ORDER BY rating
>
>In one sense this query works fine - it
OK, first of all, brilliant and well thought out. One problem, every one of
my tables are EXACTLY the same. All I want to do is take the records from
all 15 of the tables where the username(column) in them is what I say. When
I try to do this, it gives me an error that says it's ambiguous. So
Hi.
Just use a LEFT JOIN and you will get a "default of NULL" whenever
there is no entry in the rating table for a product_ref.
Bye,
Benjamin.
On Fri, Sep 14, 2001 at 01:46:01AM +0100, [EMAIL PROTECTED] wrote:
> Hello,
>
> I have a query as follows:
>
> SELECT products.*, avg(ratin
This site has precompiled MySQL binaries for Mac OS X:
http://www.entropy.ch/software/macosx/mysql/
It also has easy to follow installation instructions. You need to use
your Users utility to add the MySQL user instead of the useradd and
groupadd commands. Complete instructions are at the site
Hello,
I have a query as follows:
SELECT products.*, avg(ratings.rating) AS rating
FROM products, ratings
WHERE products.ref = ratings.product_ref
GROUP BY products.ref
ORDER BY rating
In one sense this query works fine - it adds a new column called 'rating'
(which is a dynamically ca
Huston we have a problem:
table1:
purchase_order (primary key)
client_number
buyer_name
table2:
client_number
buyer_number
buyer_name
(all three combine for the primary key for table2)
Query:
select table1.purchase_order, table1.buyer_name,
table2.buyer_number from
table1 inner join table1
At 10:06 AM +0100 9/13/01, Robin Keech wrote:
>I have a requirement to use a sequence number table that I can reserve a
>block of sequences, (so auto increment is not suitable).
>
>This is my proposed table structure
>
>create table SEQNO (
>SEQNO INT UNSIGNED NOT NULL DEFAULT 0,
>SESSION
Hi all, mysql-team
i have a very very complicated problem , hope to be clear.
i have a file report (.txt) with about 200,000 data about books (title,
clasif, year, publisher, authors, subjects, etc etc) without tabs or
separation, i built a parser to split each field and works fine.
After e
Has anyone had any experience using Mysql via MyODBC with Ipswitch's IMail mail server?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
> Have you also increased your master maxfiles as well? If not, you're not
> getting the number of file handles you expect you are. I'd also consider
> upgrading to 4.3, as it's much faster than 3.x.
>
> Try this --
> sysctl -w kern.maxfiles=16424
kern.maxfiles is already the same as .maxfiles
I am having a few problems with the install.
First off Mac OS X does not support the groupadd or useradd
commands.
Next the scripts/mysql_install_db fails and tells me to look for
more i\
nformation in ./data logs, however in the data directory there are no
log files\
.
>How
Is anyone using mySQL as an LDAP database backend? I'm looking into
using LDAP as a means to keep a user directory (employee id, name, phone
#, email, etc...). Unfortunately it seems that most of what I've found
recommend using Berkeley DB or Gnu's GDBM. I don't want yet another
database to le
Just had this same error and fixed it...with help.
You need to set a symlink to the /tmp
ln -s /tmp/mysql var/lib/mysql/mysql.sock
I may have this backwards..I'll send it from home when I get there.
M;)
-Original Message-
FROM: Nick Torenvliet
TO: Mysql (E-mail)
DATE: Thu 9/13/01 1
> database,sql,query,table
>
> Igor Brynskich wrote:
> >
> > Dear Sirs and Madams,
> >
>
Perhaps you should consider creating your own mail list for minor
release announcements? We do this for Data Architect. I am sure that 90%
of the people on this list received your last announcement so this o
I'm trying to start my first ever installation of mysql, so I've installed
the tar.gz (3.23.42 on Linux) and I've run ./configure from /mysqlhome when
I try to star the server I get the following message
Can't connect ot local MySQL server through socket '/tmp/mysql.sock'
When I do a find I can
Bernard,
you could look at the source code of
the mysql client. I think it is written
in C or C++, and should show how you get
the C API working.
Unfortunately there is no global command
to set all sessions to autocommit = 0.
There has been discussion of adding such
an option.
Regards,
Heikki
Hi... I downloaded the mysql v3.23.42 and I processed as the instruction in
INTALL-BINARY file, but when I run mysqld, I got the following:
# bin/mysqld
010913 15:49:43 Warning: setrlimit couldn't increase number of open files to
more than 60
010913 15:49:43 Warning: Changed limits: max_connect
Hello all,
I had installed mysql-max 3.23.41 beta some time back. Now I
was trying to get the binary , but cannot find it anywhere! Also, if I use
the stable 3.23.41 do I make some installation etc. changes? Any advice will
be greatly appreciated.
Thanks,
Sheena.
---
You need to install Perl DBI, Mysql and Data-Dumper modules
On Thu 13 Sep 2001 21:12, OPEN.org System Administrator wrote:
> I get the following error message when trying to run-all-test. Any help
> would be greatly appreciated.
>
> /usr/local/mysql/sql-bench # ./run-all-tests
> Can't locate DBI.
I get the following error message when trying to run-all-test. Any help
would be greatly appreciated.
/usr/local/mysql/sql-bench # ./run-all-tests
Can't locate DBI.pm in @INC (@INC contains:
/opt/perl5/lib/5.00503/PA-RISC1.1 /opt/perl5/lib/5.00503
/opt/perl5/lib/site_perl/
5.005/PA-RISC1.1 /opt/p
Have you also increased your master maxfiles as well? If not, you're not
getting the number of file handles you expect you are. I'd also consider
upgrading to 4.3, as it's much faster than 3.x.
Try this --
sysctl -w kern.maxfiles=16424
"Chris Bolt" <[EMAIL PROTECTED]> wrote:
Right now M
It's amazing what a search on google will turn up.
First result when searching on "convert mysql to oracle" came up with:
http://freshmeat.net/projects/m2o.pl/?highlight=m2o
Nick
- Original Message -
From: "g g" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 1
On Thursday 13 September 2001 19:16, g g wrote:
> Hi.
>
>
> Is anyone aware of any tool to convert a mysql
> database to an oracle database?
see:
http://www.mysql.com/news/article-57.html
Ian Barwick
--
Ian Barwick - Developer - [EMAIL PROTECTED]
akademie.de asp GmbH - http://www.akademie.d
On Thu, Sep 13, 2001 at 10:16:35AM -0700, g g wrote:
> Hi.
>
>
> Is anyone aware of any tool to convert a mysql database to an oracle
> database?
Oracle published one several months back.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408
On Thursday 13 September 2001 15:36, Frank Fisher wrote:
> Ian Barwick wrote:
> > In Windows you can probably do something involving the mouse and some
> > icon-thingies, or maybe a simple DIR at the command line.
>
> Right-click on the MySQL database folder, selecting "Properties".
>
> Under DOS,
Thanks, My SQL
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Lisa Howell" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 1:48 PM
Subject: Re: Re: USFlag - HalfMast - available on my site
> Your message cannot be posted because it appears to be either spam or
> simply off to
Hi.
Is anyone aware of any tool to convert a mysql
database to an oracle database?
thanks
__
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/
---
On Thu, Sep 13, 2001 at 12:56:10PM -0400, Paul Schmidt wrote:
>
> Okay this may seem odd, but here goes.
>
> I have a client, they have a nice big Netware server, with lots of
> extra disk space. I know that Linux can access NetWare volumes, so
> is it possible to set up a small (read cheap) Li
"Srinivasa T.N." wrote:
>
> Hi,
> The m/c on which I have my database is also Unix, and the machine
> from which I want to connect is also Unix. Instead of directly
> connecting to database, I want to use ODBC in between, so that, if
> tomorrow, my database changes, I should not change my pr
Okay this may seem odd, but here goes.
I have a client, they have a nice big Netware server, with lots of
extra disk space. I know that Linux can access NetWare volumes, so
is it possible to set up a small (read cheap) Linux box for the
database server, and store the actual database files on
Hello,
I am using Innobase with MySql version 3.23.39 under Linux
and want to run WITHOUT autocommit mode
(<= autocommit=0 for using commit/roolback instructions)
I have made a test whith 2 INTERACTIVE MySql sessions and this works fine.
BUT, when I use the C API (mysql_real_query), it DOESN't
thanks for that
i tried doing that (\u mydatabasename;) but same results:
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:937749
Current database: databasename
ERROR 2000: You have an error in your SQL syntax near 'unique,
Object1 varchar(60),
Obje
On Thu, Sep 13, 2001 at 02:17:51PM +0200, Sergei Golubchik wrote:
> On Sep 07, Doug Poland wrote:
> > On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> > > Lorang Jacques ([EMAIL PROTECTED]) writes:
> > >
> > > > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
>
The manual says this is a valid my.cnf option for replication:
slave_read_timeout=# Number of seconds to wait for more data from the master before
aborting the read.
http://www.mysql.com/doc/R/e/Replication_Options.html
My server (mysql-3.23.41-sun-solaris2.8-sparc) doesn't recognize that. The
Show us your table definitions, what you tried, and
what you think didn't work.
Deryck Henson wrote:
> Well, before I asked which joins to use and now I want to know how to use
> the LEFT JOINS. They would be quite useful on my site right now. Any help
> is appreaciated and dont say to read
Hi!
Can I put the DB files in another dir instead of default dir?
Let me explain:
In my actual system, the files are in /var/lib/mysql (for all tables).
I want to put the tables (files) of the user Jonh in the Jonh\'s user directory.
The same for many others users.
How can I do that?
Thanks,
You COULD do what we do:
select GET_LOCK(date)
select & (update | insert)
select RELEASE_LOCK(date)
[I don't recall the exact syntax on the get lock)
Anyway, all of our software uses this to emulate row-level locking. It is
not as elegant as a 2 line SQL statement,but it is effect
Read the MySQL manual, it is very well written and will tell you exactly how to create
any index you
like. Try here: http://www.mysql.com/doc/O/p/Optimizing_Database_Structure.html
# Nathan
- Original Message -
From: "Miguel Enriquez Alvarado" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
"alter table" & "add index" command
Please look at the online manual it is very good
Simon
-Original Message-
From: Miguel Enriquez Alvarado [mailto:[EMAIL PROTECTED]]
Sent: 13 September 2001 15:05
To: [EMAIL PROTECTED]
Subject: i am begginer ...
hi all good morning.
i ahve a questio
hi all good morning.
i ahve a question: i use delphi and want work with mysql too, need create indexes in
the tables of mysql for more speend in the querys?
how can create the indexes?
thanks
-
Before posting, please check:
Hi,
The m/c on which I have my database is also Unix, and the machine
from which I want to connect is also Unix. Instead of directly
connecting to database, I want to use ODBC in between, so that, if
tomorrow, my database changes, I should not change my program. Any idea
about how to go
REPLACE is different than UPDATE - replace deletes the row and then inserts
a new one. Update updates the values in the existing row. Big difference
if you aren't updating all columns...
- Original Message -
From: "Rene Tegel" <[EMAIL PROTECTED]>
To: "Torgil Zechel" <[EMAIL PROTECTED]>
>
> create table saveMovie (
> -> id int not null auto_increment,
You attempted to create a table without telling MySQL which database to use
(or without creating a database in the first place). Either:
\u MyDatabaseName
-OR-
create database MyDatabaseName;
\u MyDatabaseName;
before t
>
> I'm new to MySQL and I was wondering if there was a command that you can
> issue to see the current size of a mysql database (in kb or MB)?
>
If your intent is to get the size 'on the fly' from within a web page, you
can use the filesystem object. I use ChiliSoft ASP but the solution is the
hi
i'm totally new to this so you'll have to forgive these questions if they
are really basic.
the situation with my server is that i have a user name that is associated
with a mysql database
i logged in (after telnetting in) as the user using:
mysql -u username -p
i then entered my password
Ian Barwick wrote:
> In Windows you can probably do something involving the mouse and some
> icon-thingies, or maybe a simple DIR at the command line.
Right-click on the MySQL database folder, selecting "Properties".
Under DOS, substitute your Unix command with DIR and look at the total
at t
On Thursday 13 September 2001 03:12, Antoine E. Hall wrote:
> Hello,
>
> I'm new to MySQL and I was wondering if there was a command that you can
> issue to see the current size of a mysql database (in kb or MB)?
Not in MySQL as such (unless I've missed something in the meantime).
In Unix/Linux
Hi,
I posted this query to the list via the newsgroup mailing.database.mysql a
few days ago but didn't receive any replies. If someone could respond and
let me know whether or not I'm asking something that should be obvious or
if this is just something that's not that common so know one knows
Dear Sirs and Madams,
EMS HiTech company is announcing the next version (0.91) of MySQL Manager --
A Powerful MySQL Administration and Development Tool for
Windows95/98/ME/NT/2000/XP.
You can download the latest version from
http://www.mysqlmanager.com/download.phtml
First, thanks to all our us
Hi!
On Sep 07, Doug Poland wrote:
> On Fri, Sep 07, 2001 at 10:41:33AM -0500, Ed Carp wrote:
> > Lorang Jacques ([EMAIL PROTECTED]) writes:
> >
> > > Now I was wondering if it would get faster by using FULLTEXTSEARCH on my
> > > tables. As it is quiet some work, I first want to ask you guys if t
Hi,
>UPDATE stats SET count=count+1 WHERE date=XXX
>
>BUT, if the date is not there, no counter will be updated so I must first
>check this and insert a record if date is not found. Since there is more
>than one thread that can write to this table I must use a lock:
You COULD do the following (
Torgil Zechel writes:
> table stats
> count int unsigned not null default 0
> datetimestamp (using only year/month part)
>
> I update this table with:
>
> UPDATE stats SET count=count+1 WHERE date=XXX
>
> BUT, if the date is not there, no counter will be upda
check the replace syntax:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#REPLACE
regards
rene
On Thu, 13 Sep 2001 13:40:44 +0200
"Torgil Zechel" <[EMAIL PROTECTED]> wrote:
> Hi!
>
> I have a counter that is increased each time an event occur. The number of
> events
Well, before I asked which joins to use and now I want to know how to use
the LEFT JOINS. They would be quite useful on my site right now. Any help
is appreaciated and dont say to read the manual cause Ive tried that and it
doesnt give a good enough explanation. This will be very helpful when
d
Hi!
I have a counter that is increased each time an event occur. The number of
events should be reported as events / month, so along with the counter i
have a date-field. The table structure looks like this:
table stats
count int unsigned not null default 0
date
Hi,
when I compilling mysql that occur something error below on solaris.
Soft Spc.
Solaris 8
Mysql 3.23.42
gcc 3.0.1
GNU Make 3.79.1
My steps:
gunzip -d -c mysql-3.23.4.tar.gz | tar xvf -
cd mysql-3.23.42
CC=gcc CFLAGS="-O3" CXXLD=g++ \
CXX=gcc CXXFLAGS="-O3 -fe
Hi
I am using windows2000 server and MYSQL ver3.23.41-win and Active Server
Pages to retreive MYSQL result set to my webpage, It is retreiving well if
there is only one row in the table( It is not reaching EOF immediately),
but if there is more then one row (in group by result) then immediately
r
I have a requirement to use a sequence number table that I can reserve a
block of sequences, (so auto increment is not suitable).
This is my proposed table structure
create table SEQNO (
SEQNO INT UNSIGNED NOT NULL DEFAULT 0,
SESSION VARCHAR(10),
LOCK_TIMEOUT TIMESTAMP);
my blocks will
James Clifford wrote:
> newbie DB developer question
> Are stored procedures scripts or compiled code ?
> James
>
It can be either. Compiled code generally offers greater performance while something
that
has to be accepted by an interpreter will be more robust, provided the interpreter is
solid
Hi,
Looks like you didn't run "mysql_install_db".
NOTE: You'll have to change ownership of the database to mysql:mysql.
Regards,
Ian.
> I installed MYSQL on a HPUX 11 machine and I ran the "mysql-test-run"
> script and everything
> passed, but when I start mysql up using "bin/safe_mysqld"
Endre Stølsvik wrote:
> On Tue, 11 Sep 2001, Arnulf Kristiansen wrote:
>
> | I have just started to look into the stored procedure issue. We will come up with a
> | definite plan within a short period of time.
>
> But does this mean that you won't welcome any other initiative or ideas
> from oth
90 matches
Mail list logo