I know this is a bit StarOffice specific, still, I already know of
a similarity of functionality with M$ Access when talking to MySQL
server. (table is required to have a primary key for inserts to work).
Maybe it is a similar answer this time too.
Is it possible to create a form for inputing
Sir,
I have downloaded the binary stable version of
MySQL from the site www.mysql.com.The package I
downloaded is ..
mysql-3.23.37-pc-linux-gnu-i686.tar.gz
After unzipping and untaring,I entered then
directory
mysql-3.23.37-pc-linux-gnu-i686 and then i executed
the
./configure co
add % line to your grants.
that means this user can connect from everywhere.
read mysql documents Section 6.13 for detail instructions.
shell> mysql --user=root mysql
mysql> INSERT INTO user VALUES('localhost','monty',PASSWORD('some_pass'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
On 26-Apr-01 [EMAIL PROTECTED] wrote:
> I have two table I need to join in a query. The second table needs to be
> join twice (I think) to the first. Details as follows (tables pared
> down)...
>
> Table games
> gameid
> hometeamid
> guestteamid
>
> Table team
> teamid
> sponsor
>
> I wan
I have two table I need to join in a query. The second table needs to be
join twice (I think) to the first. Details as follows (tables pared down)...
Table games
gameid
hometeamid
guestteamid
Table team
teamid
sponsor
I want a query to return game.gamid, team.sponsor (hometeam), team.spons
As I'm having a lot of problems with the source distro, I'm considering
moving to your RPMs.
The manual suggests that there are a lot of problems with Linux and threads,
etc... and to use the prebuilt binaries if you can...
I've been using a source distro for awhile. What do I have to do to inst
Hi,
I have a database created with all data stored in Microsoft Access 2000. Can someone
tell me what would be the easiest and fastest way to port all the data from MS-Access
2000 to MySQL.
Any help in this regard would be highly appreciated.
Thanks in advance
-RamanGet your FREE download of MSN
Hello,
I'm running mysql 3.23.37 on a Debian potato install.
I ran through the install from the mysql.com web site. Everything seems to
work ok but I do have one question. When I run mysqladmin or mysql I have to
put a ./ in front. I get a command not found if I don't. Is this correct
behavior?
I haven't installed mysql from the scratch, but used a precompiled
version that comes with my distribution. Since I've updated it
I see some *-bin.* files grow steadily very huge.
What are these files in my /var/lib/mysql directory good for?
Some kind of journalling for replication?
Do I really
Sorry to be such an everything newbie. Perhaps this a unix error and not
MySQL but a simple Describe statement reports that a *.frm file is missing,
yet that file exists in the same folder. What could be wrong? Sorry about
the long LS. TIA, John ...
# mysql -p mysql
Didn't find any fields i
hiya,
using mysql under zope i want to extract day and hours/minutes from a
date-time field to have them displayed in different columns. read my manual, done
that. problem is though that my syntax is more or less as follows:
select
HOUR(hora) as lahora
from mytable
which returns the hour but wi
On 25-Apr-01 [EMAIL PROTECTED] wrote:
> I used Access (sorry) to develop a db design. I then used ODBC to export it
> to MySQL. The tables all lost their primary key definitions. Now I need to
> set them back to be a primary key. I have tried:
> ALTER TABLE def_categories MODIFY ID PRIMARY KE
Since the original posting on this list, I've received many
useful submissions and commentary from a variety of sources.
Fortunately, I've even been able to include some of it. :)
Here's the latest version:
http://netgraft.com/~mbac/research/mysqlmyths.html
I appreciate all feedback.
--
Micha
I was wondering where do I find out the changes that were made
from release to release with MySQL such as changes made from
3.23.26 to 3.23.27?
/'^'\
( o o )
--oOO
On Wed, Apr 25, 2001 at 04:12:39PM -0600, Devin Atencio wrote:
>
> I was wondering where do I find out the changes that were made from
> release to release with MySQL such as changes made from 3.23.26 to
> 3.23.27?
They are documented in the MySQL manual.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED
I am in the process of building a database/php app that is going to require
transaction support. Which table type should I go with? BerkeleyDB or
Innobase?? It looks like the InnoDB has some neat features like row-level
locking, etc. but is it stable enough for a production system, or should it
be
The error which occurs during ./configure is:
ld: fatal: library -ldir: not found
and
ld: fatal: Symbol referencing errors
By the way, what should the LD_RUN_PATH environment variable be set as.
Signed,
Still Clueless
;-{
- Original Message -
From: James Bonham
To: [EMAIL PROTECTED
Try http://www.mysql.com/doc/A/d/Adding_users.html
-Original Message-
FROM: Perico
TO: [EMAIL PROTECTED]
DATE: Wed 4/25/01 12:28
SUBJECT: Adding a new user.
Can somebody tell me how can I add a new user to a database?.
Now, I connect always as an anonymous user.
(Sorry if the question
I find it humorous that you're Email address is "perl_programmer2001", yet
you don't know how to set your PATH variable...
Type "echo $PATH" and see if "/usr/local/bin" is included in it. If so, you
can do what I usually do, which is to add 'symbolic links' from there to
programs that I want
Hello!
I am to do a tool working with different kind of database.
Developping at first for Oracle this tool use the command:
SELECT TABLE_NAME FROM USER_TABLES
in order to get generically tables in the databse used by the user.
Is there a way to do the same with mySql, and if yes, ho
If you're logged on as "root" on the system, you should be able to 'stop'
mysql, remove the contents of the "var" subdirectory (NOT /var), and re-run
"bin/mysql_install_db"...
(I hope I'm right...)
TWooly wrote:
> Hey I installed the MySQL pkg from http://pkg.nl.cobalt.com a couple of
> wee
Hello
I am using mysql with jboss. Jboss server requires the db driver to support "jdbc2.0
Optional package" support, to facilitate transaction.
Can you comment on this please?
Thanks
ramesh
_
Chat with your friends as soon as they come on
Hey I installed the MySQL pkg from http://pkg.nl.cobalt.com a couple of
weeks ago and I went through steps just like on the site. That all went
ok but since then I have been busy and forgot what I changed the root pass
to. Is there any way to recover this? If not what is the best thing to do
to
> OS: Red Hat Linux 6.0 / Intel
> 1GB RAM
>
> MySQL 3.23.36
> PHP4.0.4PL1
> Linux kernel 2.4.3
> Using the my.cnf for medium sized sites
>
> mySQL starts with safe_mysqld and there are three threads
> running. Queries come in and out and it's quite fast. Using
> mysqladmin proc status shows n
Hi,
I have been using xmysqladmin successfully for quite
some time to change the table structure of my databases
(as I haven't been able to fugure out how to do this with
mysqlgui...)
After doing lots of upgrades here, Linux -> 2.4.3, glibc -> 2.2
and mysql -> 3.23.31 xmysqladmin started coredu
Hi Everybody!
I'm installing Mysql on a solaris 2.7 sparc machine.
In the mysql manual is this passage:
"You will find several files and subdirectories in the
mysql directory. The most important for installation
purposes are the `bin' and `scripts' subdirectories.
`bin'
This directory contains
Don't give process privilege to anyone else, tht way a connection will be
reserved.
On Wed, 25 Apr 2001, Hunter Hillegas wrote:
> Running mysqladmin -p proc reports:
>
> too many connections...
>
> That's why I can't diagnose it.
>
> I'm logging in as root. How else would I get process_priv?
PHP has a function called phpinfo() that lets you see it's internal
settings.
It's reporting the mySQL client API as 3.23.22-beta... I'm using 3.23.36...
That's compiling PHP with it's internal client libraries for mySQL...
Maybe that's part of the problem?
I tried to compile PHP against the ne
Hi,
I installed the Win32 static binary of MySQL GUI 1.7.4-2. client version on one
computer.
I have also MySQL 3.23.37 mysqld-nt server installed on another computer. I can ping
each other.
I tried to connect from client to server, but failed. Error shows: Access denied for
user: 'administrato
Hi there,
I tried to build MySQL for my Sol. 2.7 for x86, and when I run the
"configure", I got error message says that the size of "char" is zero,
and
maybe because I don't have the "libm.a" installed.
I checked my system, I have both libm.a and libm.so installed in both
/usr/lib and /lib,
so wha
I'm running PHP4.0.4pl1 - the latest version.
Web users are logging in as a user called dummy.
I guess I'll have to look in the manual to see how to remove the
process_priv(). I don't think they need it...
Thanks,
Hunter
> From: "Andrew Schmidt" <[EMAIL PROTECTED]>
> Date: Wed, 25 Apr 2001 15:
Who are web users logging in as? Take away their process_priv if they have
it (unless they need it).
Also, what version of php are you running? As old versions contained leaks
in connections
In the change log for php 4.0.4
Fixed mysql_close(), pg_close(), msql_close() and sybase_close() - t
Running mysqladmin -p proc reports:
too many connections...
That's why I can't diagnose it.
I'm logging in as root. How else would I get process_priv? I haven't changed
any parameters so I should be able to get in but I cannot.
What am I doing wrong?
Hunter
> From: "Andrew Schmidt" <[EMAIL P
taken from the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
W_PROCESSLIST
SHOW PROCESSLIST shows you which threads are running. You can also get this
information using the mysqladmin processlist command. If you have the
process privilege, you can see a
I used Access (sorry) to develop a db design. I then used ODBC to export it
to MySQL. The tables all lost their primary key definitions. Now I need to
set them back to be a primary key. I have tried:
ALTER TABLE def_categories MODIFY ID PRIMARY KEY
Any help is appreciated!
Sean Tibbetts
Web
I tried to add a comment to your web page.
got error :
Error: query insert into
web.user(email,pass,firstname,lastname,address,city,state,zipcode,id,phone,cell,fax,company,show_email,created)
values ('[EMAIL PROTECTED]','passwd','Yusuf ','Incekara','Omeraga Mah No :
87','İzmit/KOCAELİ','KO'
>Description:
mysqld daemon fails when starting with databases from /var/lib/mysql
there's only the 'mysql' and 'test' database and it still fails.
I used a previus database and it suddenly disapeared. It was deleted
without reason.
on a second try even the
Heikki sent his response to the wrong address...
-- Forwarded Message --
Subject: Re: TEMPORARY + InnoDB + select coun(*) + Bye = mysqld crash
Date: 25 Apr 2001 17:18:06 -
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Alex,
MySQL obviously tries to drop the
Can somebody tell me how can I add a new user to a database?.
Now, I connect always as an anonymous user.
(Sorry if the question is too simple, but I don't find an adduser
command or something similar).
Thanks a lot.
-
Before
I have a Java program accesing MySql using JDBC.
In that program, I update very frequently the database. However, I'd
like to know if there is some way to check the real update frequency in
the MySQL database.
Is there some application or mechanism to know that?.
Thanks a lot.
---
Hello Everyone,
I'm trying write a small Dump application to Dump a MySQL DB similar to
MySQLDump.exe because I don't like shelling out to the exe (DOS windows
showing, etc.).
However, on some tables, I get an EOF before it reached the end. Anyone
ever do this?
Thanks,
Lee
Alex,
MySQL obviously tries to drop the table when you exit
from the mysql client, since the table is temporary.
I have not tested TEMPORARY tables. I just tried on prerelease .38 and
it does not work in that version either.
I will fix it in .38 if Monty has not yet put out it.
Regards,
Heikki
Hello all
I am running linux mandrake with Mysql vers 3.23.23-beta, for
pc-linux-gnu on i686
I've had a problem with recieving to many connections which i am working
on but my MAIN problem currently is that it will not allow me to insert
into tables.
I cleared out all the connections and can que
Stephan,
You can not join within an update clause - 'update' supports one table
only.
regards,
P
On Wed, 25 Apr 2001, Stéphane PRIN wrote:
> > database,sql,query
>
> > Hi everybody,
> >
> > i have 2 tables
> >
> > 1) test
> > - id_test
> > - country_name
> > - etc...
> >
> > 2
My machine is intel 55mhz 256mb ram 2x 10gig HD on SCSI
OS = linux 7
server installtion with database server support.
i downloaded :
mysql-3.23.36-1.i386.rpm AND mysql-client-3.23.36-1.i386.rpm
and placed them in /home/george/rpm
I did:
rpm -ivh mysql-3.23.36-1.i386.rpm mysql-client-3.23.36-1.
Heikki,
Mysql-3.23.36, Solaris 2.8.
My mysqld crashes when I create a TEMPORARY InnoDB table from the console
if I do a SELECT COUNT(*) before exiting from the console.
No problem with MyISAM tables, no problem with no TEMPORARY table.
mysql> CREATE TEMPORARY TABLE mybuffer ( id int
On Wed, 25 Apr 2001, george wrote:
> rpm -ivh mysql-3.23.36-1.i386.rpm mysql-client-3.23.36-1.i386.rpm
Better approach would be to use the update switch. rpm -Uvh
>
> the output says:
>
> file /usr/bin/safe_mysqld from install of mysql-3.23-36-1 conflicts with
> file from package mysql-serv
I think there is a problem with the Asking_questions.html page.
When I try to create a "New User", it gives me the following:
Error: query select country_id, name from web.country order by name failed:
Unknown column 'country_id' in 'field list'
Anyway, I'm writing to report the following bug:
Hi!
Take a look at MySQL++ page on www.mysql.com
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| La
chown -R mysql /var/lib/mysql
[EMAIL PROTECTED] wrote:
>
> Hi everyone,
>
> I tried to install mysql (v3.23.30-gamma) on a SuSE Linux 7.1. Everything
> seems to work fine, but whenever I start the safe_mysqld, it ends after few
> seconds.
>
> I did install the databases, but there seems to be
> database,sql,query
> Hi everybody,
>
> i have 2 tables
>
> 1) test
> - id_test
> - country_name
> - etc...
>
> 2) country
> - id_country
> - contry_name
>
>
> i want to join this 2 tables in case of deuce of the country_name
> and update test.id_test with the value of
I would like to know where I can find examples and documentations about C++ mysql
API's, I want create a class for access to connection.
Hi everyone,
I tried to install mysql (v3.23.30-gamma) on a SuSE Linux 7.1. Everything
seems to work fine, but whenever I start the safe_mysqld, it ends after few
seconds.
I did install the databases, but there seems to be a problem with the
directory-structure - however I have no idea how I ran
Hello,
I have made several attempts at compiling and installing MySQL 3.23.36 and MySQL++
1.7.8 on Solaris 2.7 Ultra Sparc.
I have included the latest versions of GNU binutils, libtool, make, gcc as indicated
in the documentation in the proper path.
I have tried using environment variable set
Simply download the source from www.mysql.com (MYSQL C++ API). There are
precompiled libs for VC++ and BC++, and these libs are TRUELY AWESOME!!
- Original Message -
From: "Lorenzo De Vito" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 25, 2001 7:28 AM
Subject: C++ A
OS: Red Hat Linux 6.0 / Intel
1GB RAM
MySQL 3.23.36
PHP4.0.4PL1
Linux kernel 2.4.3
Using the my.cnf for medium sized sites
mySQL starts with safe_mysqld and there are three threads running. Queries
come in and out and it's quite fast. Using mysqladmin proc status shows no
queries running.
After
matthieu VIDAL writes:
> Hi
>
> Thanks for your very good work.
>
> The problem is : I'am not able to edit or create table when using mysqlgui 1.7.4-2
>on Win 98 2nd edition. When I try to select the corresponding menu, no new window
>appears and nothing happen.
>
> Thanks for your help.
Edi
gcc -o conftest -O3 -DHAVE_CURSES_H
-I/servers/space/neuwirth/src/mysql-3.23.37/include/
-DHAVE_RWLOCK_T conftest.c -lz -lcrypt -lgen -lsocket -lnsl -lm
-lpthread -lthread
In file included from /usr/include/stdio.h:23,
from conftest.c:4:
/usr/include/sys/va_list.h: In function
What you might try looking at is your environment variable
$LD_LIBRARY_PATH. If you don't have it in your environment, set it up
with all the usual lib places i.e
/lib:/usr/lib:/usr/local/lib:/usr/share/lib:/usr/local/share/lib and so
one. I think that this should clear up your problem with cros
Have a look at urSQL -- http://www.urbanresearch.com/ursql
On Tue, 24 Apr 2001, Hao Cheng wrote:
> Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering
> if there is any great client side tools of it, like the toad for oracle?
> actually I'm not expecting it to be that function
checking host system type... sparc-sun-solaris2.7
checking target system type... sparc-sun-solaris2.7
i am trying to install mysql 3.23.37 from source on solaris 2.7 on
sparc.
i managed to install the binary distribution, and it works,
but it does not work with php4.0.4pl1
i suspect this is beca
solaris 2.7 + gcc 2.95.2
mysql 3.23.37
in my last message i describe the probolem that
configure thinks it is cross compiling.
when i manually changt the configure file to avoid this test,
i get the next error
configure output:
checking size of char... 0
configure: error: No size for char ty
Heikki,
HT> check by other queries whether it is the table which contains a
HT> duplicate row, or if the SELECT gives a wrong answer.
HT> Check what
HT> SELECT * FROM ... WHERE symbole='1rPFTE';
HT> returns.
Really strange :
mysql> select * from livequote_last_PAR where symbole='1rPFTE' o
Hi
Thanks for your very good work.
The problem is : I'am not able to edit or create table when using mysqlgui 1.7.4-2 on
Win 98 2nd edition. When I try to select the corresponding menu, no new window appears
and nothing happen.
Thanks for your help.
Hi all,
I'm having more merge table woes! I'm trying to alter a merge table to remap
it without dropping and re-creating. This is what I get:
mysql> ALTER TABLE eventlog_all UNION=(eventlog_11, <..lots of tables...>,
eventlog_88);
ERROR 1031: Table handler for '#sql-1f1_ea6d9' doesn't have this
- Original Message -
From: Yusuf Incekara
To: [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2001 2:50 PM
Subject: About Last Insert ID and Getting Column Names
I created a Visual Basic Project that uses Last insert id function and
getting column names.
Working properly.
Anyone inte
Heikki,
Another exemple :
mysql> select * from livequote_last_PAR where symbole='1rPFTE' order by id desc;
+-+---+-+--++
| symbole | id| date| last | volume |
+-+---+-+--++
|
Hey,
I dunno whether it's a bug or just I don't know how to use transactions
properly. I've got 3.23.36 on FreeBSD 4.2-STABLE, and when I do this:
CREATE TABLE test TYPE=Innobase SELECT * otherdb.sometable;
MySQL hangs. If I limit the SELECT query to 10-100 rows, it executes quite
fast (same if
"Howard Picken" <[EMAIL PROTECTED]> wrote:
> I'm trying to import a csv file into a db.
> all text fields are " enclosed and all fields are , delimited.
> the file is 900 records long.
>
> The error I'm getting is..
>
> ERROR 1062 at line 1: Duplicate entry '127' for key 1
Your ID field is type
Hello,I am a java developper and using mysql database
engine, I am using tomcat, I wrote a
servlet wich writes a sentences, it works fine but the
accentual characters like à é è are replaced by ?
character, can some one help me, it's urgent.
Thanks
Heikki,
I did the downgrade to Mysql-3.23.36. I don't have this problem with
3.23.36 !
Alex.
HT> check by other queries whether it is the table which contains a
HT> duplicate row, or if the SELECT gives a wrong answer.
HT> Check what
HT> SELECT * FROM ... WHERE symbole='1rPFTE';
HT> r
Matt Benic writes:
> we're looking at implementing a system that will need to store an
> average of between 3 and 5 million records in the main table - we've decided
> interbase cant handle our volume-will mysql be able to do it?
>
> Matt Benic
> +27 72 182 6161
> [EMAIL PROTECTED]
> http://i
Kristian Lukander writes:
> Hi!
>
> I'm having problems compiling the example programs provided with the
> MySQL++ API package on MS Visual C++ 6.0. The compiler reports errors on
> longlongs. Does anybody know hot to get around this? What files should be
> included in the project?
>
> Thanks
Tianlin,
you are right. If InnoDB did a scan from a secondary index to an
empty table, then it returned an error code MySQL did not accept
in this context. I changed now the error code and it will be right
in the next release .38, if Monty has not yet gotten it out.
Regards,
Heikki
...
Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering =
if there is any great client side tools of it, like the toad for oracle? =
actually I'm not expecting it to be that functional, but at least i wish =
it's better than the one in the mySQL package.
Any input is greatly apprec
Jason Holliston writes:
> This is probably something I'll smack my head about afterward, but here
> goes: is it possible to execute multiple queries in the MySQL client GUI on
> Win32? What's accepted on the command line or in a .sql script doesn't work
> when pasted into it. Thanks in advance!
we're looking at implementing a system that will need to store an
average of between 3 and 5 million records in the main table - we've decided
interbase cant handle our volume-will mysql be able to do it?
Matt Benic
+27 72 182 6161
[EMAIL PROTECTED]
http://i.am/mbenic
Alex,
check by other queries whether it is the table which contains a
duplicate row, or if the SELECT gives a wrong answer.
Check what
SELECT * FROM ... WHERE symbole='1rPFTE';
returns.
Regards,
Heikki
At 12:04 PM 4/25/01 +0200, you wrote:
>Bonjour,
>
> Mysql-3.23.37 on Solaris 2.8.
>
>
Hi there
Depending on whether you have downloaded the new mysqld-max or not, if you
have not, then you have to compile with the Berkelely DB option, if you
have, then you just create the tale with type=bdb.
Look at the table afterwards, "show table status", if it is MYIsam then you
don't have th
Bonjour,
Mysql-3.23.37 on Solaris 2.8.
I created this table :
CREATE TABLE livequote_last_PAR (
symbole char(20) NOT NULL default '',
id int(10) unsigned NOT NULL default '0',
date datetime NOT NULL default '-00-00 00:00:00',
last double(17,5) NOT NULL default '0.0',
volum
Hi!
I'm having problems compiling the example programs provided with the
MySQL++ API package on MS Visual C++ 6.0. The compiler reports errors on
longlongs. Does anybody know hot to get around this? What files should be
included in the project?
Thanks in advance on any info,
Kristian
hi !
I need to insert a value into the database whose column type is datetime. the value
that i am receiving is on the form of a string.
the problem is that how does one convert this value recieved from a jsp page to the
datatype that of SQL using JDBC callable statement.
thanking you in anti
Hi!
We just encountered that MySQL seeems not to accept a "LIKE '%...'" clause
in a DELETE statement. In the annotated online documentation it is said a
DELETE statement can be followed by any valid WHERE clause. LIKE is listed
as a common string comparison function in the SELECT and WHERE functi
Dear all,
Does anyone know how I can run a script that calls other scripts in order to
create the DB and its tables?
How do I do it from my Windows NT?
Thanks
>From: "Sascha Dahl" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Subject: LIKE clause in DELETE-Statement
>Date: Wed, 25 Apr 2001 1
Hi !
I have simply question. When do i have use transaction in mysql ??
I have mysql 3.23.37 from RPM for Redhat Linux. do i have to compile from source when
i want transaction with BDB tables ?? Or i simply type type=bdb when i create table
and it'all. Now my table uses transaction ??
Regards
Get the actual version 1.17 of MySQL-Front at http://www.mysqlfront.de/ or
http://www.anse.de/mysqlfront/
Greetings,
Ansgar Becker
[EMAIL PROTECTED] | http://www.anse.de
AB7670-RIPE
Hi, I'm new to MySQL. I'm using it in Windows 2000. I'm just wondering if
there is any great client side tools o
86 matches
Mail list logo
