Alan Chu wrote:
I am now using msql and wants to change to mysql. Is there any problem
in install both in the same server?
Regards,
Alan
-
Before posting, please check:
http://www.mysql.com/manual.php (the
It is easy make an error while writing SQL coimmand to create table, etc...
So I'd like to write this command (CREATE TABLE) in a file then run this
command in mysql:
How can I do?
how can I write it?
Thank you in advance.
Mario.
in UNIX derivatives,
vi a text file, and write your create/other sql into it then save and close
it.
cat your_file | ./bin/mysql -uyour_username -p your_database
you will be prompted to enter a password for your username.
then enter your password.
- Original Message -
From: [EMAIL
resend!
pls reply
--
From: Sulman
Sent: Monday, March 26, 2001 9:21 PM
To: '[EMAIL PROTECTED]'
Subject:MySQL Approach97
Hi All!
I'm new in the mailing list just want to know about the data transfer from
Approach97 to MySQL.
In my company we are running Approach97
Hi,
This is my full code
$www_domain="select Failed_Signups.EmailAddress.Email from
Failed_Signups.EmailAddress left join www_domain_net.Members on
Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where
www_domain_net.Members.EmailAddress is null";
Respected Sir
i want to know how i store a image in mysql.i sue perl for scripting on linux.
please help me
thanks
allah hafiz
Hi,
I'm not very experienced yet with MySQL and MyODBC. So I would
appreciate very much any help how I could start solving the following
problem:
We are running a CAD/CAM-system on SGI-Workstations under IRIX 6.5.2 to 6.5.10 and
have extended this system by some own applications written in
Read the archives of this list.
P
On Fri, 30 Mar 2001, Sheikh wrote:
Respected Sir
i want to know how i store a image in mysql.i sue perl for scripting on linux.
please help me
thanks
allah hafiz
-
Before posting,
Peter Adamka writes:
Thanks a lot, but I've make a mistake (supposing tha t I've done something
I didn't ;-) -inserting -lfleditor switch). Sorry for it.
Malmo
Malmo If I only got 20$ for evryone
[EMAIL PROTECTED] writes:
Hi !
I notice a bug with MySQL 3.23.36 with REPLACE DELAYED which crash my MyISAM
tables.
The problem was present in MySQL 3.23.34, but not in 3.23.33 nor 3.23.35.
The bug occurs randomly and makes MySQL restart...
With REPLACE instead of REPLACE
On Thu, Mar 29, 2001 at 07:57:41PM +0300, Michael Widenius wrote:
mysql rename tables test1 to test3, test2 to test1, test3 to test2;
Peter ERROR 1192: Can't execute the given command because you have active locked
Peter tables or an active transaction
I bet this happens when you have a
Hackley, Susan writes:
Help,
I am trying to install the Sun Solaris 2.7 Sparc static binary of
MySQLGUI 1.6 for the MySQLGUI the result was:
ld.so.1:./mysqlgui-solaris-2.7-sparc-static-1.6
:fatal:libstdc++.so.2.10.0:open fatal: no such file or directory
1. Trying to install
Hubert Feyrer writes:
On Tue, 27 Mar 2001, Sinisa Milivojevic wrote:
You also need fl_editor package. You will find a link on mysqlgui
page.
OK, that indeed got me further. (Is it only me, or does putting a header
file into one package, and the source in another one really sound
Scott Ellsworth writes:
Howdy, all.
The following error came up when compiling under OS X release.
c++ -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME="\"/usr/local/mysql\""
-DDATADIR="\"/usr/local/mysql/var\""
command in mysql:
How can I do?
how can I write it?
Create a .sql file.. check the archive, same question has been asked 1 or
two days ago. Otherwise read info on websites about MySQL and other SQL
languages
Bye,
B.
-
Silvio Picano writes:
Hi,
Been running mysql-3.22.32 / Solaris / Sun / dual-processor:
Mysql.pm 1.2214 + DBI 1.14 + perl 5.004_04
Database with 40 tables.
Biggest table has 2,131,447 rows in it.
No problems for 6 months.
Recently ported to mysql-3.23.35 / Linux 2.2.12-20smp
So, is there any support for stored procedures in MySQL or not
I don't think so, what do you think ?
thank you
Hi Darius,
Just an idea: can you cut the binary data into separate small(er) chuncks
and then store it in different records? (Using some identifier to know
which chunks belong together, what is their order,...) This may make data
handling harder, but you can reduce the memory load of the server;
Frank Hennrich - Loher AG writes:
Hi,
I'm not very experienced yet with MySQL and MyODBC. So I would
appreciate very much any help how I could start solving the following
problem:
We are running a CAD/CAM-system on SGI-Workstations under IRIX 6.5.2 to 6.5.10 and
have extended
Does somebody try to build MySQL-3.2.36 on Slackware 7.1?
I have an error trying to make test.
configuration:
[30-Mar-01][15:55]{ilya@odin} ~/Sources/mysql-3.23.36./configure
--prefix=/usr/local/mysql --enable-assembler --with-berkeley-db
--with-charset=koi8_ru
I don't mean to be argumentative, but what is everyones love affair with stored
procedures? I like putting my logic in the mid-tier and I'm constantly battling my
Sybase Admin at work who maligns me whenever they spot a query in my codeeven a
very simple select "oh, I can make that a
THe manual says
To avoid using ROLLBACK, you can use the following strategy:
Use LOCK TABLES ... to lock all the tables you want to access.
Test conditions.
Update if everything is okay.
Use UNLOCK TABLES to release your locks.
I didn't quite understasnd the meaning of Test Conditions
Hello,
I have a Cobalt Qube2.
I have recently compiled Apache 1.3.19, PHP4.0.3pl1 and MySQL 3.23.33.
Even though, everything compiled normally. I am unable to load PHP4 as a
DSO. When I run 'apachectl configtest', I get this error:
Syntax error on line 239 of /etc/httpd/conf/httpd.conf:
Cannot
Sir, I looked quickly through the mass of data supplied below, and it
looks like you only tried myisamchk with the -r -q option
combination. Try it with just -r. If that doesn't work, try it with
-o. If that doesn't work, restore from backup.
Got backup?
Bob Hall
Antonio gulli wrote:
Sir, try
SELECT g1.name, g1.score, g1.id
FROM grades g1, grades g2
WHERE g1.name = g2.name
GROUP BY g1.name, g1.score
HAVING Max(g1.score) = Max(g2.score);
Bob Hall
Q: I have the following table "grades".
++++
| name | score |id |
Stored procedures offer several advantages over embedded SQL.
1: It is easier to write, debug and modify SQL code in a stored procedure
with a tool designed to do that. You can write PHP from the command line
also but not many people do it.
2: Placing the code in a stored procedure allows you
At 18:52 29/03/01 +0200, you wrote:
Hello again!
Sorry but didn't see your other comments on first reading.
I thought that the key cache meant that mysqld would only hold key/indexes
in memory and that the data the indexs point to would
still be read/written from disk. It's just that it seems
How come nobody has mentioned that complex data manipulation can be performed
on the server without waistuful and slow transmission of unwanted data
to the client? that seems like the biggest advantage to me.
Meaning that if I have to do something to the data that SQL doesn't allow
without
Hi
Agreed but it still incurrs a performance penulty; more so when the server is
under heavy load
On Friday 30 March 2001 16:15, Steve Ruby wrote:
How come nobody has mentioned that complex data manipulation can be
performed on the server without waistuful and slow transmission of unwanted
For the longest time, I'v ebacked up my various MySQL databases using
mysqldump. However, I hated restarting the database each night (on a few
occasions it would restart but the databases could not be accessed until it
was restarted again) Plus I think mysqlhotcopy is a more elegant solution.
Hi out there,
I'm new with MySQL.
I have installed Linux 6.0 and MySQL 3.23.33
This happens when I want to create a database:
[mysql@nestorix mysql]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49 to server version: 3.23.33
Type 'help;' or '\h'
No.
In other implementations, executing 100 stored procedures is actually LESS
taxing to the server than executing the same code 100 times. The stored
procedure can be compiled once and execute 100 times. The embedded sql
cannot.
Cal
http://www.calevans.com
-Original Message-
From:
I tried -r
I tried -o
I tried to truncate the table and re-build the index from scratch.
I tried to create ex-novo a table, import data from scratch and it
result in a corrupted table.
None of these seems to work
Bob Hall wrote:
Sir, I looked quickly through the mass of data supplied below,
On Fri, 30 Mar 2001, Herman Pool wrote:
Hi out there,
I'm new with MySQL.
I have installed Linux 6.0 and MySQL 3.23.33
This happens when I want to create a database:
[mysql@nestorix mysql]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49
Am 17:44 30.03.2001 schrieb Herman Pool:
Hi out there,
I'm new with MySQL.
I have installed Linux 6.0 and MySQL 3.23.33
This happens when I want to create a database:
[mysql@nestorix mysql]$ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 49 to server
Hi Seung!
Yes, you have to do some tuning to get the performance from a transactional
database. You should not use autocommit=1, because then the database
has to physically write the log segment to disk after each individual
insert. Try to insert your data in a single transaction, only a single
If you can export all your data from any database program, using any field
and record delimiter character you like, then it can be imported into MySQL.
There is always a way.
Not being familiar with Approach97, I can't answer for sure, but
If there is absolutely no way to export your data as a
Hi Seung!
Yes, you have to do some tuning to get the performance from a transactional
database. You should not use autocommit=1, because then the database
has to physically write the log segment to disk after each individual
insert. Try to insert your data in a single transaction, only a single
Hi again,
Im looking for someone that has a win 2000 mysqld compiled with --with-raid
Any one?
Need it. And dont have any possibillity to compile it myself.
/roger
Does anyone know of a software package that can create stats from the
MySQL logs? Something similar to Analog (for HTTP logs).
Any and all help is greatly appreciated,
Bill
-
Before posting, please check:
I received several of these messages when I repaired a table. Can anyone
give me any insight about this message.
Should I export all data to a new table or can this message be ignored?
Found block with too small length at 3532; Skipped
--Bill
Description:
I have installed MySQL version 3.23.36 (having previously used 3.23.34a)
After I restarted the daemon, I ran the mysql 'monitor' program to check on the
existing databases and tables. Mysql reported for each table: "Didn't find any fields
in table 'table-name'". This
join
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL
Received the error again this morning;
I was able to copy an older copy of .frm file into
tbl_status.frm (via Sinisa's response), and the problems
went away; all data appears to be intact.
[Largest *.MYD files is 186 mbytes *.MYI is 32 mbytes.
Note that all database directories files reside
Now that our use of MySQL is being questioned (but
they are pretty much convinced). What the higher-ups
want to know is a few examples of medium to large
companies using mysql for mission critical stuff.
If any one can provide some I would be much appreciated.
We are a financial company
I read that SGI (sgi.com) uses all kinds of MySQL DBMS's behind the scenes.
Presumably, they're running on Irix. ;-)
HTH,
Jed
On 3/30/01 11:48 AM, you wanted me to know this:
Now that our use of MySQL is being questioned (but
they are pretty much convinced). What the higher-ups
want to
www.livejournal.com www.slashdot.org www.everything2.com
At 02:48 PM 3/30/2001 -0500, Anthony R. J. Ball wrote:
Now that our use of MySQL is being questioned (but
they are pretty much convinced). What the higher-ups
want to know is a few examples of medium to large
companies using mysql for
Hehe, yeah, I mentioned slashdot... for some reason,
they just weren't impressed :)
You know the type... unless they are a big money
company, then they can't be doing anything mission critical :)
www.livejournal.com www.slashdot.org www.everything2.com
--
___ __ ____ _ _
On Fri, Mar 30, 2001 at 02:56:53PM -0500, Anthony R. J. Ball wrote:
Hehe, yeah, I mentioned slashdot... for some reason,
they just weren't impressed :)
You know the type... unless they are a big money
company, then they can't be doing anything mission critical :)
We use MySQL
I know that www.yahoo.com uses it somewhere... but I can't remember where I read that
(probably on this list a while ago)
- Original Message -
From: "Anthony R. J. Ball" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 12:48 PM
Subject: Need examples of companies
Greetings:
We Manage Servers (http://www.wemanageservers.com/) - Their ASP-based
advanced monitoring service utilizes the power of mySQL.
While I don't have the institutions name, I was told by Verio Advanced they
have a financial institution running mySQL.
XOXO Clothes
Check this Motorola press release, it may help you...
Motorola Teams With MySQL AB to Offer Tools for Developers to Create Mobile
Database Applications
http://www.corporate-ir.net/ireye/ir_site.zhtml?ticker=MOTscript=410layout
=-6item_id=161725
- Original Message -
From: "Anthony R.
Some MySQL Users
http://www.mysql.com/documentation/mysql/bychapter/manual_Users.html#Users
Regards,
Ernesto Vargas
- Original Message -
From: "Anthony R. J. Ball" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 30, 2001 2:48 PM
Subject: Need examples of companies using
I'd like to write a simple application with API of MySql.
I see "4.4.1 A Simple Exaple" of the manual but I can't find the file
"simple1.cc" that should be in my computer... but there isn't.
How can install it?
thank you in advance, Mario.
I asked for the same things awhile back. But you got more responses
then I did!
I got the yahoo address from
Jeremy D . Zawodny
http://biz.yahoo.com/ne.html
Thanks Jeremy, its a good site
At 02:48 PM 3/30/2001 -0500, you wrote:
Now that our use of MySQL is being questioned (but
they are
I have write a simple program in C/C++.
this program use API for Mysql (linux)
the question is :
How to compile this programs?
Tank you in advance, Mario.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
My company is using it for all database functions. We're an online
'collection' agency and have been using it for the past 6 months (versions
3.22.23 upgraded to 3.23.36). In comparison with Borland's
"Interbase" ("Ibase"), which I supported at the late "Money Store"
corporation for all 100 of
If he is talking about the Samples that come with Paul DuBois book MySQL
thay are at:
http://www.mysql.com/Downloads/Contrib/Examples/samp_db.tar.gz
Jason Maderios
-Original Message-
From: Mike Roberts [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 30, 2001 5:21 PM
To: Anthony R. J.
In the last episode (Mar 30), Heikki Tuuri said:
The FreeBSD bug is known. I will run tests on our FreeBSD machine in
the next few days. Obviously there is something wrong with the
FreeBSD port. Was it so that it hung and used 100 % of CPU? That has
been reported also from Italy.
I have a
Hi All,
On Tue, Mar 27, 2001 at 02:28:05PM +0100, Rafael Martinez wrote:
I am thinking to install our DB server in a 4-way machine with
Intel Xeon processors/1MB cache. I can see in the mysql documentation that mysql
works OK in a 2-way machine but that in a 4-way system has to be tested.
Not sure how much use to you it would be, but my employers, Dexterus Ltd,
trust my judgement enough to have adopted my recommendation to use MySQL
as an "embedded" DBMS in our smallscale PC-based systems. It has been
deployed in a "farm" of PC's running Linux to co-ordinate virus scanning
of
Greetings Steve:
At 12:01 AM 3/31/2001 +0100, Steve Allsopp wrote:
"Dexterus (www.dexterus.com) is a VC-funded company set up to provide
application services to the banking industry in the City of London. While
we are still in the pre-launch stages (we launch Tuesday!), we are aiming
for a
Rol wrote:
Hallo all,
A table containing some text needs to have some of the letters changed (eg.
letter to be replaced with "auml;" ).
Is there a way to use a replace function to search for such chararcters in a
text and then replace it with the html tag?
Yes of course and this
How are you supposed to convince people that MySQL is a worthy
DBMS with boring testimonials about millions of dollars worth of dataflow
and incredible fault tolerance?
If you REALLY want to sell MySQL, point them to http://m4m4sex.com/, a web site
that is dedicated to helping men find men for
Two things that I am sure will be answered very quickly.
1) I have a development box that I have successfully installed and
configured 3 seperate instances. Each instances has its own port number.
When playing around with mysqladmin I know I can specify the port number as
an option, but
On Fri, 30 Mar 2001, Kristopher Briscoe wrote:
Two things that I am sure will be answered very quickly.
1) I have a development box that I have successfully installed and
configured 3 seperate instances. Each instances has its own port number.
When playing around with mysqladmin I know
Two things that I am sure will be answered very quickly.
1) I have a development box that I have successfully installed and
configured 3 seperate instances. Each instances has its own port
number.
When playing around with mysqladmin I know I can specify the port
number as
an option, but
Hi,
We have been encountering a problem running mysql on sgi. We normally run
it as a normal user, which writes the file /tmp/mysql.sock. However, when
the machine is rebooted while the daemon is running, the mysql.sock file's
ownership will change to root. After that we can no longer start
want to know is a few examples of medium to large
companies using mysql for mission critical stuff.
I too am in a similar situation, needing links to large organisations on
mySQL. This would help me to replace the largest-ever (proposed) deployment
of MSSQL (as per the official release of
At 5:56 PM -0800 3/30/01, Guo, Zhian wrote:
Hi,
We have been encountering a problem running mysql on sgi. We normally run
it as a normal user, which writes the file /tmp/mysql.sock. However, when
the machine is rebooted while the daemon is running, the mysql.sock file's
ownership will change
I am interesting in develop tools, for plataforms,like
PHP, Linux, Apache, etc...
but I have a Sistem, with Clipper, and I need know, if
MySQL supports, NTX indexs, is very important, for
me,know this, Can you help me please...
Atte: Aarón Reyes
Make sure you have installed the MySql-shared package
At the command prompt type
gcc -lmysqlclient -I/usr/include/mysql file.c
where file.c will be file that contains the C APIs
Best Of Luck
Shambhu.
_
Chat with your friends as soon as
Dear All,
Is it possible to mail only three columns from a database ? Third column
being email ID?
I need to send email to all with a valid email ID in a database.
Thanks
Regards
Prasad
-
Before posting, please check:
Hi, everybody, I have a couple of quesitons
1. From the mysql manual, if I want to use 'autocommit=0', it says that I type 'set
autocommit=0' and this only applies to a session. So, when I want to back up data
using 'shellmysql datablse data.sql', do I need to add 'set autocommit=0' at the
we are having no suitable driver error. Please help us to get rid off this problem.
we are having SunOS 5.7+tomcat webserver+mysql 3.23.32.
thanks,
naveen
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What did you do to get the error
Adrian
On Fri, 30 Mar 2001, Lebrun Jonathan wrote:
What's error 1062 ?
Thanks.
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.2 (GNU/Linux)
Comment: For info see http://www.gnupg.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
What are the results you expect. There are always workarounds
Adrian
On Fri, 30 Mar 2001, Ramasamy Palaniappan wrote:
Sir,
created the following tables as primary and secondary
primary : partycode(primary key),partyname
secondary :
Dear:
I can not start mysql server.
There is an error when I start mysql using :mysqld start or safe_mysqld
The error is :
Can not connect to 'localhost' throught ~/mysql.sock
Please check is file ~/mysql.sock exist!
I checked the file, it exists, but it have zero byte. And my linux
78 matches
Mail list logo