-Ursprüngliche Nachricht-
Von: c.smart <[EMAIL PROTECTED]>
An: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Datum: 18 March, 2001 01:11
Betreff: Re: join from two different databases
>Sorry, No Green Beer, No can do that ;-)
>
>Richard Reina wrote:
>
>>
Hello Heikki,
Monday, March 19, 2001, 4:40:30 PM, you wrote:
>>Also the problem with innobase_flush_log_at_trx_commit=0 should be
>>there is no guarantie the last transaction commited will be on it's
>>place if the power would be lost. Also I don't know is it possible in
>>this case for databa
-Ursprüngliche Nachricht-
Von: Pedro <[EMAIL PROTECTED]>
An: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Datum: 19 March, 2001 17:29
Betreff: Alteon + forks
>Hi,
>
> I have 2 servers and 1 alteon in HA. But the problem is that the alteon ,
>when trying, to see if the servers are up or down ,
On Mon, Mar 19, 2001 at 04:06:29PM +0300, Anatoly Chubais wrote:
> Hello!
>
> There's a need to design a system (something like online forum) that
> will be storing huge amount of small messages in database. There
> must be fast access only to messages for the last 3 days (guess this
> means tha
copying tables between databases:
create table db2.table2 select * from db1.table1;
however, you'll loose meta data (indexes) on this table, so you'd have to
create them again.
second method:
use the explorer or a dos shell to rename any table or db as shown in the
\mysql\bin directory. From wi
Hi,
Given this table:
create table occurrance (
word int unsigned not null,
document_id int unsigned not null,
offset mediumint unsigned not null,
key index_word (word),
key index_document_id (document_id),
key index_offset (offset)
) TYPE=MyISAM
..the following query
Hi!
I'm running MySQL on Win NT 4. I'm trying to rename a database from my
program, but I haven't found any inforamtion about this on the MySQL site.
Can anybody help me?
Can a database named 2001 be created? Can a database be copied to another
one via SQL statements?
regards,
m@rko
---
Hi!
I'm running MySQL on Win NT 4. I'm trying to rename a database from my
(Delphi) program, but I haven't found any inforamtion about this on the
MySQL site. Can anybody help me?
P.S.: Can a database named 2001 be created?
regards,
m@rko
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 19 May 2002, Luis wrote:
> #mysqladmin -u root -p password 'newpassword'
>
> or
>
> #mysqladmin -u root password 'newpassword'
>
> i got a error. but when i tried the 2 one it work. But in the manual it says to do
>the top one
Hello Fantik,
Monday, March 19, 2001, 9:43:20 PM, you wrote:
F> I have connet to server MySQL from delphi 5
F> please send mi driver(s) for delphi, or please tell mi how connect.
Try our mySQLDAC: http://www.microolap.com/mysqldac.htm
--
Best regards,
Edward Smirnov
microOLAP Technologies LL
dear sanjeev run on cmmd promt
/etc/rc.d/init.d/mysqld restart
you can now run mysql
luck naveed
- Original Message -
From: Sanjeev Adhyapak <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 17, 2001 11:20 PM
Subject: mysql on redhat 7.0
> Dear Sir,
>
> We have install
On Mon, Mar 19, 2001 at 04:13:25PM -, Pedro wrote:
>
> I have 2 servers and 1 alteon in HA. But the problem is that the
> alteon , when trying, to see if the servers are up or down , makes
> mysql to fork , till it dies..
I'm not sure I understand... Probably because I don't know what an
ale
On Mon, Mar 19, 2001 at 05:06:28PM +0100, Gernot Hueber wrote:
>
> I want provide access to my MySQL Server to several customers. How
> can I count IO traffic per user, and any user accesses (I don't want
> a full log, only log ins)?
There's not built in facility for doing that today.
Are all
On Mon, 19 Mar 2001, Curtis Maurand wrote:
> Hi,
> Just a quick quesiton, I have a table that contains difined as
>
> create table picks(
>handle char(30) primary key,
><...>
> total int unsigned);
>
> there is a user table that has a list of handles and other user info. handle
Hi,
Yes, in MySQL you can go
select handle, sum(total) as t group by handle order by t;
in ANSI (?) you can go
select handle, sum(total) group by handle order by 2;
2 being the column number of the result.
Regards
Quentin
-Original Message-
From: Curtis Maurand [mailto:[EMAIL PROTE
Hi,
Just a quick quesiton, I have a table that contains difined as
create table picks(
handle char(30) primary key,
<...>
total int unsigned);
there is a user table that has a list of handles and other user info. handle is the
primary key.
If I issue the command "select handle, su
hello all.
I'm new to mysql and to this list. Here's my problem. I am using mysql and jsp.
From a jsp page I try to connect to the mysql server I get error " Invalid
authorization specification: Access denied for user : javaworks@localhost (using
password: NO)
at org.git.mm.mysql.MysqlIO.i
> hist.id will never be NULL and 5 at the same time. Your clauses conflict
> with each other.
> You need to re-write your query.
This is ture, except the query suceeds if there is records in 'hist'
Even if it is not a bug it is at least inconsistent behaviour of MySQL
>
> "Michael Griffith" <
Van wrote:
>
> Van wrote:
> >
> > This one's great:
> > /usr/local/libexec/mysqld: ready for connections
> > 010319 1:51:41 Slave: connected to master 'pima@scottsdale:3306', replication
> > started in log 'FIRST' at position 4
> > 010319 1:51:41 Error reading packet from server: Binlog has
Steven Glogger wrote:
>
> after upgrading to 3.23.35 (from 3.22.32) i've got several times:
> 010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin'
> host: `localhost' (Got an error reading communication packets)
>
> it's running on a productive server, but it's not working co
I believe there is a function called Right(). Sample
is as follows (pardon the VB):
DIM sString, sLast4Characters
sString = "Hello There"
sLast4Characters = Right(sString, 4)
So, sLast4Characters now equals "here".
Hope this helps!
--- Hammad Nasim <[EMAIL PROTECTED]> wrote:
> Hi
> I need
Hi
I need some help with substring. How can I extract last four digit of a
field say card_no (this field has in some instance 10 digits and for some
value has 20 digits).
Thanks
On Mon, 19 Mar 2001, Andres M.V. Paglayan wrote:
> Hi you all,
> I´m trying to resolve how to manage a large resultset (about 500),
> showing only 20 rows per page and then to have the option to show more results from
>several buttons,
> like when you search something with a lot of pages in
You can use the 'limit' construct on the end of the select statement.
So for first query do
select blah from blah where blah limit 20;
each succeeding query will be
select blah from blah where blah limit 20,20;
check the doco for explanation.
You can do a count to start with to determine how
I think that this is highly dependant on the language you are using to
display your results; you would probably get more help if you included that.
Good luck,
Dennis
**'
Beridney Computer Services
[EMAIL PROTECTED]
P: 703-566-3196
http://www.beridney.c
Hi you all,
I´m trying to resolve how to manage a large resultset (about 500),
showing only 20 rows per page and then to have the option to show more results from
several buttons,
like when you search something with a lot of pages in the yahoo,
Best wishes for you all.
Thanks in advance.
-
I've got mysql and php installed on my server and i was wondering if
anyone could give me some feedback/pointers on setting up a membership
list for a local chamber of commerce. I've been able to set up the
initial table (calling chamber.txt for the info, converted from a
word.doc) but i need to
hist.id will never be NULL and 5 at the same time. Your clauses conflict
with each other.
You need to re-write your query.
"Michael Griffith" <[EMAIL PROTECTED]> wrote:
EXPLAIN LEFT JOIN fails when joining on an empty table with constant in
WHERE clause
CREATE TABLE idx (
id mediumint,
EXPLAIN LEFT JOIN fails when joining on an empty table with constant in
WHERE clause
CREATE TABLE idx (
id mediumint,
KEY id (id),
) TYPE=MyISAM
CREATE TABLE hist (
id mediumint,
link mediumint,
KEY id (id,link)
) TYPE=MyISAM
Table idx is populated with thousands or records. Consider
Dear MySQL Sirs (or Andrew Schmidt)
Please see attachament for error messages.
Thaks in advance for any help.
Alonso Guarisma
Original Message
Subject: Re: problems with linking
Date: Mon, 19 Mar 2001 19:02:47 -0500
From: Alonso Guarisma <[EMAIL PROTECTED]>
To: Andrew Schmidt <
Hello all. I was wondering if someone could help me out with simple question i have .
I just download MySQL-3.23.33-1.i386.rpm and installed it.
now would this be the right way of setting up the msyql root password
#mysqladmin -u root -p password 'newpassword'
or
#mysqladmin -u ro
"Alexey V. Litvinov" wrote:
>
> Hello JCampell,
>
> Friday, December 22, 2000, 11:25:51 AM, you wrote:
>
> RTFM about SELECT and about DISTINCT option
>
> J> I want to know if it is possible to build a MySQL query which will only
> J> return the unique values of a specific column. Ie if I had
Hello JCampell,
Friday, December 22, 2000, 11:25:51 AM, you wrote:
RTFM about SELECT and about DISTINCT option
J> I want to know if it is possible to build a MySQL query which will only
J> return the unique values of a specific column. Ie if I had this table:
J> id | name |date___
J> 1 |
make sure you have -L/usr/local/mysql/lib/mysql/ in your compile
and make sure that /usr/local/mysql/lib/mysql/ is in your shared object
cache.
ldconfig -r will list your current cache entries.
if /usr/local/mysql/lib/mysql/libmysqlclient.so.10 is not in there then add
the path:
/sbin/ldconfi
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral search where people s
Dear MySQL Sirs,
I have been trying to run a simple client program using the C API and
unfortunatelly I am still getting the same error over and over again:
./client1: error in loading shared libraries: libmysqlclient.so.10:
cannot open shared object file: No such file or directory
Attached is
Hello All,
MySQL version 3.23.33
I was hoping someone maybe able to offer some suggestion on a search query I've
been working for a day or so, but seems to be getting no where fast!
I've attached the tables and test inserts I'm working with. This is for a
business referral search where people s
#
# Table structure for table 'bus_info'
#
CREATE TABLE bus_info (
info_id int(11) unsigned DEFAULT '' NOT NULL auto_increment,
bus_name varchar(100) DEFAULT '' NOT NULL ,
contact_fname varchar(20) DEFAULT '' NOT NULL ,
contact_lname varchar(20) DEFAULT '' NOT NULL ,
refer_by int(8))
On Mon, Mar 19, 2001 at 06:05:47AM -0800, tmb wrote:
> I'm a newbie to the Linux-Apache+MySQL world.
>
> 1 - Will MySQL handle a data base as large as a Yahoo or Google or
> E-Bay ?
Done properly, yes.
> 2 - Will MySQL running on a Linux/Apache system handle traffic that
> approaches that of a
Unfortunately, the deletion criteria are based both on the host it's coming
from, and the date of the records. If I start to break it up along too many
lines, the management starts to outweight the benefits of it being in the
database.
Sounds like looking at innobase is definately a good way to g
Ok. The second one below sounds semi reasonable - it does mean that the
table will be somewhat useless for queries during the delete, but that's not
tragic. Is there any way to drop all the indexes on a table with a single
statement?
Third one sounds good as well, but unfortunately, there is a st
On Mon, Mar 19, 2001 at 02:40:58PM -0600, Neulinger, Nathan R. wrote:
>
> Got any suggestions on how these could be implemented? particular
> table types/setups/etc?
>
> I basically have a situation where 300,000+ rows are being inserted
> into a log table daily, and also needing to be cleared ou
> I basically have a situation where 300,000+ rows are being inserted into a
> log table daily, and also needing to be cleared out based on a
> tstamp. What
> I've found is that the inserts work fantastic, but when I got to do the
> delete, even if it doesn't do anything, it sits there and blocks
Am 22:21 19.03.2001 schrieb Dave Juntgen:
>*This message was transferred with a trial version of CommuniGate(tm) Pro*
>Hello,
> I would like to ask those of you who have used temporary hash tables in
>MySQL version 2.23.x if you have encountered any problems, concurs or known
>issues. I have
Yes, you are right, periods are not allowed, but I am still not getting a
successfully ORDER BY on the field. I tried remove the DATE_FORMAT()
function and everything worked fine. Am'I not allowed to alias function
returns?
- Original Message -
From: "Gerald L. Clark" <[EMAIL PROTECTED]
Can you put any warning that you plan to release new version few days
before release ? I have downloaded 3.23.34, and when i visited mySQL.com
on the next day, 3.23.35 was released.
--
Martin Jeremic - JSoft
http://jsoft.webjump.com/
mailto:[EMAIL PROTECTED]
--
Hello,
I would like to ask those of you who have used temporary hash tables in
MySQL version 2.23.x if you have encountered any problems, concurs or known
issues. I have been testing it myself and everything sees to working just
fine. Please list your thoughts and comments on temporary hash
You're selecting your index column [ID] for every record and generating a
column containing a random number [ID*0+RAND()], ordering by the random
column [ORDER BY rand], and then just grabbing the first record [LIMIT 1].
the RAND() function generates random numbers.
In my version of mysql (most
I've created the databases on the new server, but when I do:
mysqldump --quick --add-drop-table --add-locks --extended-insert
--lock-tables TestDatabase | mysql -h newserver TestDatabase
I get the error message:
ERROR 1063 at line 30: Incorrect column specifier for column 'ID'
The originating
I have suse linux 7.1, I installed mysql and php, I tyr to connect to
the database and I get a socket error why? is there any kind of
special confg? I type mysql on a terminal window and get the error msg,
cheers
-
Before
Hi,
> for mysql < 3.23 you can do something like this.
>
> select ID, ID*0+rand() as rand from partner order by rand limit 1
Thanks a million for the speedy response! It works like a charm!
I don't quite understand how it works though... Could anyone explain? I
really don't like knowing som
It has been. Check the archives for 2-3 weeks ago.
Cal
http://www.calevans.com
-Original Message-
From: Chris Boot [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 2:16 PM
To: MySQL Mailing List
Subject: Selecting random rows with MySQL 3.22?
Hi,
I'm sure this has been cover
Got any suggestions on how these could be implemented? particular table
types/setups/etc?
I basically have a situation where 300,000+ rows are being inserted into a
log table daily, and also needing to be cleared out based on a tstamp. What
I've found is that the inserts work fantastic, but when
Hi.
for mysql < 3.23 you can do something like this.
select ID, ID*0+rand() as rand from partner order by rand limit 1
have fun.
-ravi.
-Original Message-
From: Chris Boot [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 3:16 PM
To: MySQL Mailing List
Subject: Selecting random
Hi.
If you want to store the binary images in the database, the column type will
most likely be a BLOB assuming the images are not bigger that 60k.
If you want to store just url or file paths (http://www.myhost.com/pict.jpg
or /home/bob/image.gif) use a VARCHAR(XX) where XX is a reasonable length
Hi,
I'm sure this has been covered before, so I'm sorry for repeating the
question. A search of the list archives yielded nothing.
What I need to do is grab one random row from a table. What I would do in
MySQL 3.23 is:
SELECT * FROM fid_links WHERE featured='yes' ORDER BY RAND() LIMIT 1
How
Hello,
Just starting out with MySQL. I like to put images or links to images in a database,
Is this possible? If so what would be the column type be?
Thanks for the help
Mike
after upgrading to 3.23.35 (from 3.22.32) i've got several times:
010319 20:45:18 Aborted connection 4 to db: 'unconnected' user: 'admin'
host: `localhost' (Got an error reading communication packets)
it's running on a productive server, but it's not working correctly.
some infos: apache 1.3.19
Hi all,
I'm new to MySQL and am puzzled by a curious problem. This join syntax has
always worked fine for me on SQLServer but it seems to work like an inner
join on MySQL:
SELECT d.doccat_ID, d.doccatname
FROM doccats d LEFT OUTER JOIN doccat_group dg ON d.doccat_ID = dg.doccat_ID
WHERE dg.group
I need to do some tests for a client involving japanese text. I've
recompiled the server with extra charsets = complex to have multi-byte
support.
I see how I can select the default charset upon startup. How can I
tell mysql that a particular set of tables (or the whole DB) should
use the japan
Periods are not allowed in field names.
Dave Juntgen wrote:
>
> Hello everyone, It seems as though I am unable to perform an order by with a
> DATETIME field when the column is named as an alias. For example...
>
> SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents
> OR
Hello,
Sorry, Im don't very good speak english. :(
I have connet to server MySQL from delphi 5
please send mi driver(s) for delphi, or please tell mi how connect.
Fantik
[EMAIL PROTECTED]
-
Before posting, please check:
ht
Hello
On Sat, 17 Mar 2001, Bård Farstad wrote:
> I have a query in my program which is taking to long when I get data
> in the database. I'm currently testing with ~40.000 articles in the
> system. [...] Is it possible to optimize this query further?
Have you played with EXPLAIN SELECT and fri
Hello everyone, It seems as though I am unable to perform an order by with a
DATETIME field when the column is named as an alias. For example...
SELECT DATE_FORMAT(service_date,'%m-%d-%Y') AS 'Serv. Date' FROM documents
ORDER by 'Serv. Date' DESC LIMIT 0,10;
Can anyone give me an explanation?
FYI
Just noticed that statements like
"LOAD DATA LOCAL INFILE 'testload.data' INTO TABLE testload ;"
won't work via replication(3.23.33) or log-update(3.22.32) unless the data
files are copied to remote slave servers in advance. Better implementation?
Workarounds?
Regards,
Jerry.
Hi,
I am trying to upgrade my MySQL server to 3.23.35 from 3.23.33. The
following command is used. I got the following error messages. Any Ideas
!!
rpm -Fvh MySQL-client-3.23.35-1.i386.rpm MySQL-devel-3.23.35-1.i386.rpm
MySQL-client-3.23.35-1.i386.rpm
MySQL-client
Actually I have 2.23.20-gamma and I get 'create dabase blabla' in my update log.
cheers,
thalis
On Mon, 19 Mar 2001 [EMAIL PROTECTED] wrote:
> Hi,
>
> Can you guys confirm that "create database" statements are not logged in
> the log-update log? The version I am using is 3.22.32.
>
>
> Rega
ACABEI DE RECEBER. NÃO TEMOS NADA A PEDER.
Prezados e queridos amigos,
Leiam esta carta e ajam rapidamente. Estou enviando esta carta para
vocês porque recebi informação por parte de um profissional e amigo.
A MICROSOFT e a AOL (America On Line), atualmente as duas maiores
empresas da Internet,
Hi,
Can you guys confirm that "create database" statements are not logged in
the log-update log? The version I am using is 3.22.32.
Regards,
Jerry.
-
Before posting, please check:
http://www.mysql.com/manual.php (the ma
I have no problem doing this with server variables ... here is an example that
I tried on the acc (account) table in our db ...
SET @a:=0;
SELECT @a:=@a+1 AS MyRowNum, acc.* FROM acc;
This gives me the result that you are looking for ...
Eric
Peter Holm wrote:
> Hi,
> how do I get something
Hi,
I have 2 servers and 1 alteon in HA. But the problem is that the alteon ,
when trying, to see if the servers are up or down , makes mysql to fork ,
till it dies..
The connection port we are using is 3306 .
Does anyone have any idea?
Thanks in advance
Best Regards
Pedro
Jazztel Portugal
Hi!
I want provide access to my MySQL Server to several customers.
How can I count IO traffic per user, and any user accesses (I don't want
a full log, only log ins)?
Thanks
--
Dipl.-Ing. Gernot Hueber
Institut für Integrierte Schaltungen
Freistädter Strasse 315/2
A-4040 Linz
Tel: +43 732 2468
Hello,
I am using MySQL for the first time and have it installed on a Windows98
machine. I also am running MySQL Maker by presult and a couple of other
GUIs.
Unfortunatley, it seems like any time I make a table that has fields
which aren't varchar or integer, I can not insert any information in
Source is now a reserved word used to 'source' a text file full of SQL
commands
in the mysql client.
Johan Andersson wrote:
>
> Hi,
>
> I got the following error from mysql (client):
> ERROR at line 1: Failed to open file 'varchar(255),', error: 2
>
> The .sql file I were sending to stdin of m
I have a database that I am manipulating with Access through an MyODBC reference. All
is well except for tables that contain any date/time fields. When I click the
(standard) delete record button on forms that use these tables, I get prompted asking
if I want to delete the form from my Access
This does not answer your problem, but 'timestamp' is a reserved word.
Jan Legenhausen wrote:
>
> Hi,
>
> i just upgraded from 3.23.33 to 3.23.35 and found that a little script of
> mine which simply modifys a table went mad completly.
> I figured out a testcase which shows at least one of the
You have mysqld set for 2000 connections.
How many threads do you have Linux configured for, and how many are open
when
Mysqld crashs?
vinod p wrote:
>
> hi,
>thanks for the interest. The error log just prints
> an incomplete backtrace that is exactly the same after
> every crash. I ran
I want to be able to add a number field to a table and limit the values that the user
can enter. For example if it is an integer filed I may want the user to only enter
the value from 1 to 10. Can I do this within the definition of the field/table or do
I have to do this level of validity che
Hi,
I got the following error from mysql (client):
ERROR at line 1: Failed to open file 'varchar(255),', error: 2
The .sql file I were sending to stdin of mysql has the following content:
CREATE TABLE IDENTITY (
id bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment,
company_id bigint(20
Updates may reference only one table in MySQL.
Phil Tardif wrote:
>
> here is what happens with my update command:
>
> update GGProfiles set GGProfiles.city = USzipcodes.city where
> GGProfiles.zipcode = USzipcodes.zipcode;
> ERROR 1109: Unknown table 'USzipcodes' in field list
>
> the USzipco
Install your curses from your installation CD.
Ali Muhhanmad wrote:
>
> Dear Mysql:
>
> when i execute the configure , it always display:
>
> checking for tgetent in -lncurses... no
> checking for tgetent in -lcurses... no
> checking for tgetent in -ltermcap... no
> checking for termcap f
"Nyström, Rasmus" writes:
> I tried it now.
>
> Not on the 2000 Server, but on my NT4 SP6
>
> The problem still occures, let's me describe the tests.
>
> The table looks like this:
> id| int(10) unsigned | | PRI | NULL| auto_increment
> title | varchar(255) | Y
You clibs are too old. You are probably running a very old
version of Linux.
john1 wrote:
>
> Dear Sir :
>
> MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
> a simple C API program which catched from MySQL tutorial, it
> chokes at the end of compile process . The program is
Hallo MySQLers
I have posted this problem already, but i have still problems installing MySQL
Version 3.23.33 on RS/6000 AIX4.3.3
>Description:
exec(): 0509-036 Cannot load program ../bin/mysqld because of the
following errors:
0509-150 Dependent module /usr/local/lib/libz.a(
Hi Craig,
You can give the following a try which does give you direct access to MySQL
from ASP skipping the slower ODBC and is almost code compatible with your
code:
http://www.scibit.com/MySQLX
or
MyVBQL on the mysql API/contrib pages
Regards
Jacques
http://www.scibit.com
http://www.scibit.com/
Read chapter 6 of the MySQL manual.
It is explained there.
Nyon wrote:
>
> Hi,
>
> I am a newbie in Mysql and is confused about setting login/passwords. Just
> want a simple security measure as I am the only user.
>
> Here's the scenario:
> I managed to connect using PHP to mysql via the mysql
You don't.
You can use telnet to connect and run mysql on that machine, displaying
on yours.
You can use mysql on your machine to connect to mysqld on the remote
machine using the -h
option to mysql. This requires that the grant command has been run on
the server to allow you to connect, and tha
Welcome!
1: You'll have to be more specific than that. How many tables/records per
table are you looking to store? Are you wanting to optimize it for querying
or is it going to be an active database with heavy inserting/updating?
2: That depends on the hardware you run it on. Technically, yes,
> "Nyström, Rasmus" writes:
> > How come the query
> >
> > SELECT
> >
> CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc
> ,created,modif
> > ied,bugstatus,submitter), '"') FROM tbl_bug;
> >
> > returns something like
> > "4","4","4"
> > "10","10","10"
> >
> > while on
I'm a newbie to the Linux-Apache+MySQL world.
1 - Will MySQL handle a data base as large as a Yahoo
or Google or E-Bay ?
2 - Will MySQL running on a Linux/Apache system handle
traffic that approaches that of a Yahoo, Google or
E-Bay?
3 - Does MySQL have an equilivant to "stored
proceedures?
Th
Make sure all directories in the path to your mysql.sock file
are world readable and searchable.
Abid Ghufran wrote:
>
> Dear All,
>
> I am trying to setup a web based email setup on RedHat Linux 7 platform. I
> am using Horde 2.2, Imp 1.2, Php 4, Apache 1.3 alongwith the following rpms
> requi
Hi I am running the latest versions of MySQL and MyODBC on my windows
200 webserver.
I am trying to connect to my database and pull out some simple data with
asp.
The code i am using is:
<%
dim db
dim strConn
dim rs
dim QueryStr
QueryStr = "SELECT * FROM imagedata"
strConn = "mediaSafe"
Set
Hi Peter and Christian!
>>If you are going to be committing on every record, you'll want your
>>tablespace and logfile directories on separate disks to avoid
>>thrashing. If you only have one disk and don't care if you lose the
>>last few transactions if your system crashes, try setting
>>innoba
Hi,
I have 2 servers and 1 alteon in HA. But the problem is that the alteon ,
when trying, to see if the servers are up or down , makes mysql to fork ,
till it dies..
The connection port we are using is 3306 .
Does anyone have any idea?
Thanks in advance
Best Regards
Pedro
Jazztel Portugal - Se
Pascal THIVENT writes:
> hi,
>
> i'm triying to install MySQL/3.23.35 on a sparc running Solaris 7
> Here are the steps I follow :
>
> # cd mysql-3.23.35
> # CC=gcc CFLAGS="-O6 -mcpu=v8 -Wa,-xarch=v8plusa"
> # CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti
> -mcpu=
Hi!
I have installed many of mysql servers and phpMyAdmin clients.
And every time it worked together fine.
Now i have problem on RH70 with mysql and phpMyAdmin:
Database pokus
Error
SQL-query:
Content-Type: application/octet-stream
MySQL said: Unknown database ' pokus'
Back
--
Hello!
There's a need to design a system (something like online forum) that will be
storing huge amount of small messages in database.
There must be fast access only to messages for the last 3 days (guess this means
that main table with indexes on it must be kept small?), while other messages
ca
It won't work in FoxPro because it's a MySQL command, not a FoxPro command.
The FoxPro command line will only accept FoxPro commands, it's not a
replacement for the mysql client.
Being an old Fox-Jockey, I use VFP 6 to move data in and out of MySQL
databases and have not had a problem.
Try using
super!
it work fine.
Thank You!
S pozdravem,
Michal Kolesar
+420 608 225025
[EMAIL PROTECTED]
http://www.egarden.cz
server of free unix services
- Original Message -
From: "Peter Pentchev" <[EMAIL PROTECTED]>
To: "- = k o l i s k o = -" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent:
hi,
i'm triying to install MySQL/3.23.35 on a sparc running Solaris 7
Here are the steps I follow :
# cd mysql-3.23.35
# CC=gcc CFLAGS="-O6 -mcpu=v8 -Wa,-xarch=v8plusa"
# CXX=gcc CXXFLAGS="-O6 -felide-constructors -fno-exceptions -fno-rtti
-mcpu=v8 -Wa,-xarch=v8plusa"
# ./configure --prefix=/usr
1 - 100 of 133 matches
Mail list logo
