hi,
i've just started work with MySQL. Does anybody know how can i
use stored procedures with MySQL? Is this capability supported?
Thanks
John Dimos
-
Before posting, please check:
http://www.mysql.com/manual.php (the man
Dear All
Could any one tell me what all the chages I have to make in
order
to make my existing (english version) of MySQL database
compatable
to the Japanese language.
Thanks and Regards
Aravind
-
Before posting, please chec
Hi,
I am geeting an error Unexpected
Exception: java.io.IOException message given: Unexpected end of input stream
Is there any limitation on the length of the query string (In mm.mysql
driver?)? Can any one help me out to avoid this error.
LOG:
SELECT
PURCHASE_ORDERS.ORDER_ID,PURCHAS
There was a former posting here:
At 09:19 AM 4/4/2002, you wrote:
Can someone please recommend CASE tools that function well with MySQL
databases?
Need to do some reverse engineering ... create the ERD, data dictionary,
etc
Regards,
Michelle Smith
Michelle,
CaseStudio 2 is quite g
Hello,
You wrote you use BDE urg,
I jumped to the ADO-components. I feel they are much faster.
Currently I use mysql 4.0.1 and the myODBC 3.51 without an error.
Before this I used mysql 3.23 and myODBC 2.50 without error.
Adib.
[EMAIL PROTECTED] wrote:
> hi,
> i'd like to know which ODBC driv
°í¼ø¹Î,
Wednesday, April 10, 2002, 4:55:53 AM, you wrote:
°> I have two mysql servers in a machine. OS is linux and system is dell.
°> I ran the servers in a separate datadir, socket and port yesterday. But
°> after six hours from the start two of them corrupted accidently.
°> I ran two servers
Scott,
Tuesday, April 9, 2002, 6:20:38 PM, you wrote:
SA> I been using mysqlimport for a long time with no problems.
SA> But today when I try (as root)
SA> mysqlimport admin /usr/local/systems/admin/data/person.txt -p
SA> I get
SA> mysqlimport: Error: Can't get stat of
SA> '/usr/local/syste
Jianping,
Tuesday, April 09, 2002, 5:55:08 PM, you wrote:
JZ> I have a redhat 7.1 server, I want to get rid of the installed mysql
JZ> server. How can check which version is installed and how to get rid of it?
You can indicate MySQL server version using SELECT VERSION()
statement or run mysqld (
Yiannis,
Wednesday, April 10, 2002, 10:17:03 AM, you wrote:
YD> i've just started work with MySQL. Does anybody know how can i
YD> use stored procedures with MySQL? Is this capability supported?
MySQL doesn't have stored procedures yet, but it is in our plans to
support them, look at:
ht
Aravind NagaVenkata Gorthy repeated himself:
> Dear All
> Could any one tell me what all the chages I have to make in
> order
> to make my existing (english version) of MySQL database
> compatable
> to the Japanese language.
So I repeat myself:
Boy. That's a tough one. I'm really not sure what y
You are right, but my master generate about 150Mb of binlog x day, i a slave
fail after 4 day it will reexec a lot of query and take some time. how can i
safely rotate the log in master+slaves without restarting them?
The Mysql manual explain how to rotate from a `hostnmae`-bin`.002 (or > 001)
Hi, cannot seem to sucessfully make a simply link between Sage Line 50 and
MySQL. When accessing the tables the damn thing throws up errors and can
import structure but fails to import data. I am using MySQL-Front to do
this.
Anyone have any idea where i am going wrong or something to try. BTW Sa
Hello ,
i've just started work with MySQL. Does anybody know how can i
use transaction with MySQL? Is this capability supported?
I write web-shop... Sory my eng is bed...
--
Best regards,
maxim mailto:[EMAIL PROTECTED]
--
How about if master crashes?...is there anyway to recover?...aside from
copying all stuff from slave to master...
R.B.Roa
PhilCom Corporation
Tel. No. 858-
Mobile No. (63) (919-xxx)
-Original Message-
From: Davide Giunchi [SMTP:[EMAIL PROTECTED]]
Sent
On Wed, 10 Apr 2002 13:27:30 +0300
maxim <[EMAIL PROTECTED]> wrote:
> Hello ,
>
>
>
> i've just started work with MySQL. Does anybody know how can i
> use transaction with MySQL? Is this capability supported?
> I write web-shop... Sory my eng is bed...
>
what term do you mean with "transactio
On Tue, 9 Apr 2002, David BORDAS wrote:
> Sent: Tuesday, April 09, 2002 2:14 PM
> Subject: Re: TIMESTAMP(14) or Bigint ??
>
> TIMESTAMP is 4 Bytes and DATETIME is 8 Bytes. So, 4 Bytes difference
> per 5 Millions records = a 20 MB bigger table ...
David
If storage space is an issue you may want
On Wed, 10 Apr 2002, maxim wrote:
> Hello ,
> i've just started work with MySQL. Does anybody know how can i
> use transaction with MySQL? Is this capability supported?
> I write web-shop... Sory my eng is bed...
Maxim,
MySQL supports different table types. Some of them (BDB and InnoDB)
support
Hello Dicky,
Wednesday, April 10, 2002, 1:42:00 PM, you wrote:
DWP> On Wed, 10 Apr 2002 13:27:30 +0300
DWP> maxim <[EMAIL PROTECTED]> wrote:
>> Hello ,
>>
>>
>>
>> i've just started work with MySQL. Does anybody know how can i
>> use transaction with MySQL? Is this capability supported?
>> I
- Original Message -
From: "Chris Lamrock" <[EMAIL PROTECTED]>
To: "Egor Egorov" <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 10:21 AM
Subject: Re: mysql_install_db still locking :-(
> Egor,
>
> I'm running :
>
> Red Hat Linux release 7.0 (Guinness)
>
> on a Pentium III 450 with 12
Hi -
This is my first post to the mySQL list, so hello world!
I am not a great expert in mySQL or SQL in general, but I have some
knowledge and experience with Access, mSQL, Oracle & mySQL.
I am trying to build a procedure on Mac OS9 using MacSQL as a mySQL client,
controlled by Applescript (be
Hi all!
Problem. How to ensure(supply) reservation MySQL in
a context of creation the Internet shop to raise(increase)
his(its) reliability.
--
Best regards,
maxim mailto:[EMAIL PROTECTED]
-
Befo
respected sir/madam,
i installed the client and server files (rpm)
of MYSql for linux , but failed to get the gui working.
could you please help me in this regards.
thanking you
hitesh patel
On Wed, 10 Apr 2002 [EMAIL PROTECTED] wrote :
>Your message cannot be posted because it appe
Aman,
Tuesday, April 09, 2002, 5:24:49 PM, you wrote:
AR> Hello everyone
AR> I want to alter 50 tables, and for each the names start with the string
AR> 'mak'
AR> Is there an SQL query, so that I can do the change in one command.
AR> I have tried using wildcards - they don't seem to work in SQL.
maxim,
Wednesday, April 10, 2002, 1:27:30 PM, you wrote:
m> i've just started work with MySQL. Does anybody know how can i
m> use transaction with MySQL? Is this capability supported?
m> I write web-shop... Sory my eng is bed...
Yes, MySQL supports transactions on the transaction-safe tables
(In
I have simple question.I have installed on my computer WinNT 4.0, Apache 1.3.14,
PHP4 (4.0.4pl1), MySQL MAX 4.0.1. There's problem with char set win1250. I don't know
how can I link this char
PZ> set. Script with this row $spojeni = MySQL_Connect("localhost"); sends an error
Warning: MySQL Co
Hello sean,
Wednesday, April 10, 2002, 2:37:34 PM, you wrote:
sosi> Hi maxim,
sosi> I'm not sure what you mean, given your earlier posts you seem
sosi> to be talking about transactions in mysql. if thats the case
sosi> i recommend you take a look at innodb. its a table type for
sosi> mysql th
Hello Victoria,
Wednesday, April 10, 2002, 3:07:01 PM, you wrote:
VR> Hello maxim,
VR> Wednesday, April 10, 2002, 2:14:54 PM, you wrote:
m>> ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apache ..
m>> ÷ÏÐÒÏÓ: ÇÄÅ ÍÏÖÎÏ ÎÁÊÔÉ ÐÏÄÒÏÂÎÕÀ ÄÏËÕÍÅÎÔÁÃÉÀ Ï ÏÓÏÂÅÎÎÏÓÔÑÈ
m>> ÉÐÏÌØÚÏ×ÁÎÉÉ SQL × MySQL .. É
Very interesting conversation, ...
íÙ ÎÅ ÇÏ×ÏÒÉÍ ÐÏ ÒÕÓÓÊÉ :-)
Adib.
maxim wrote:
> Hello Victoria,
>
> Wednesday, April 10, 2002, 3:07:01 PM, you wrote:
>
> VR> Hello maxim,
> VR> Wednesday, April 10, 2002, 2:14:54 PM, you wrote:
>
> m>> ñ ÐÉÛÕ ÄÉÐÌÏÍ, É-ÎÅÔ ÍÁÇÁÚÉÎ MySQL+php+Apach
Two of my co-workers attended the MySQL training in San Francisco last
month. We have successfully installed 4.01 on a SUN Ultra 250 running
Solaris 2.8. Four myisam tables were created and populated. When we tried
to install the same software on a SUN Sparc 20 running Solaris 2.6 errors
were e
Hello All,
I am sorry for Russian. I shall mean.
The question remains open. How to reach(achieve) a high degree
of reliability of system the Internet of commerce on a basis MySQL.
At the expense of that it is possible to raise(increase) reliability
of system?
--
Best regards,
maxim
Egor, I'm using the following:
Red Hat Linux release 7.0 (Guinness)
on a Pentium III 450 with 128 meg of Ram.
Are you thinking I may need to run an older version of Mysql?
Thanks for the reply!
Chris
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECT
Thank you for your help, but I know that I must compile kernel (mysqld) with this char
set. But, this I can do with Unix (or Linux, etc.). What can I do with kernel for
Win32? Is any mysqld with char set win1250 compiled in? Or must I download any other
version of MySQL? And which version (wher
At 07:55 10-04-02 -0500, Lee, Tom J wrote:
>When we tried
>to install the same software on a SUN Sparc 20 running Solaris 2.6 errors
>were encountered. Something about a missing file 'librt.so.1'. We thought
>the OS version was 2.7. Not correct! I downloaded the binary MySQL version
>3.22.32 f
my boss figured out a nice solution to this
ORDER BY IF(ABS(Item) > 0,LPAD(Item,9,'0'),Item)
This will pad numbers ( ok it might not do so hot with DECIMAL, but it can
be fixed to work I supposed) with 0
So it should sort
1
2
00010
00022
00050
00230
instead o
Today I have used MM.MySQL-2.0.12 and noticed, that German umlauts are
represented as ?. In MM.MySQL-2.0.7 everything was all right there.
Volker
-
Before posting, please check:
http://www.mysql.com/manual.php (the manua
Hi again...
When I felt proud because last week I had asked about how to use NOW(), and
get answer that got me working, but now I have a strange problem. It listing
dates, but it not listing like it should, when the web page is create it
going 9, 8, 5, 10 on the dates. Here is the SQL statement I
Hi everyone,
When is it appropriate to use Char instead of Varchar and vice versa?
Thanks
Luke
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
Hi
How can i deinstall the mysqld as a service?
Thx for help
mfg
Ely Van Kenobi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To req
[EMAIL PROTECTED] wrote:
>
> When is it appropriate to use Char instead of Varchar and vice versa?
Use char when you expect the length of the field to always be the same.
Use varchar when you're not sure.
Basically, when you're using varchar you're assigning a limit to the size
of the string th
Hi Luke,
> When is it appropriate to use Char instead of Varchar and vice versa?
Use CHAR for when you know in advance how many characters are going to be in
that field. A good example is for MD5 hashes: they are always 32 characters
long, so you can use CHAR(32).
Use VARCHAR for when you don't
At 16:41 +0200 4/10/02, Elyasin Shaladi wrote:
>Hi
>
>How can i deinstall the mysqld as a service?
>Thx for help
Shut down the server, then issue this command:
mysqld --remove
>
>mfg
>
>Ely Van Kenobi
-
Before posting, please
Luke,
Wednesday, April 10, 2002, 4:18:48 PM, you wrote:
LvB> When is it appropriate to use Char instead of Varchar and vice versa?
CHAR column type has fixed length, VARCHAR is variable-length string.
CHAR column type appropriate to use when you have data with the same
length. Don't forget that
HITESH,
Wednesday, April 10, 2002, 2:29:23 PM, you wrote:
HP> i installed the client and server files (rpm)
HP> of MYSql for linux , but failed to get the gui working.
HP> could you please help me in this regards.
What exactly doesn't work?
Is it a failure to start MySQLGUI or to conne
Chris,
Wednesday, April 10, 2002, 2:01:05 PM, you wrote:
>> Egor,
>>
>> I'm running :
>>
>> Red Hat Linux release 7.0 (Guinness)
>>
>> on a Pentium III 450 with 128 meg of Ram.
>>
>> Are you thinking I may need to run an older version of Mysql?
Well, this looks very weird to me. The configuation
i have been working on getting this query as fast as possible and figured
it was time to come to the mailing list.
the below table currently holds about 43 thousand records with potential to
grow to around 1,000,000 records.
CREATE TABLE `RADPOOL` (
`id` int(11) NOT NULL auto_increment,
It depends on who you talk to and what you want to do. varchar will use
less disk space, but char is faster to access (except for InnoDB tables,
where varchar has the advantage). The benefit is using char is that the
rows have a fixed length so MySQL knows exactly where each row starts and
can
> Hi again...
Hi,
> When I felt proud because last week I had asked about how to
> use NOW(), and
> get answer that got me working, but now I have a strange
> problem. It listing
> dates, but it not listing like it should, when the web page
> is create it
> going 9, 8, 5, 10 on the dates. He
Your alias and column name are the same.
Which one do you think is being tested?
Also DATE is a reserved word.
Chuck \"PUP\" Payne wrote:
>Hi again...
>
>When I felt proud because last week I had asked about how to use NOW(), and
>get answer that got me working, but now I have a strange problem
also, note that char is changed to varchar in some cases, such as when there
is a text field in the table.
-Original Message-
From: Jon Haworth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 10:40 AM
To: 'Luke van Blerk'; [EMAIL PROTECTED]
Subject: RE: Char vs Varchar field ty
Katen
Try using a compound index with STATE and POOL
INDEX ipoolstate( POOL, STATE )
Use EXPLAIN SELECT to see what mysql thinks.
David
PS anybody know if KEY is the same as INDEX?
-Original Message-
From: Steve Katen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 8
(one should not mess up strg and shift :-/)
> Hi again...
Hi,
> When I felt proud because last week I had asked about how to
> use NOW(), and
> get answer that got me working, but now I have a strange
> problem. It listing
> dates, but it not listing like it should, when the web page
> is c
i made the change, but it looks like it didn't speed the query up at all.
here are the results from the first explain:
mysql> explain select TIME_STAMP, YIADDR from RADPOOL where STATE=0 and
POOL='GLOBAL-POOL-SJC' ORDER BY TIME_STAMP limit 1;
+-+--+---+---
>Description:
I'm using Mysql 4.0.1 with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
mysqldump -q -K -t --ta
»Chuck PUP Payne« sagte am 2002-04-10 um 10:27:19 -0400 :
> going 9, 8, 5, 10 on the dates. Here is the SQL statement I am using...
That's because your DATE which you've made with DATE_FORMAT is treated
as string. To fix it, I'd write:
> SELECT DATE_FORMAT(DATE, '%M %D, %Y') AS DATE, Title, Lin
Hello,
where can I find a simple php to generate a default html table from a MySql table ?
thanks
Luigi
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
I am new to MySQL and I have a test database that I am playing with. Through
an accident while playing around, I ended up with two identicle records in
the database. I did a filter to try and change just one of them but both
would come up, so I couldn't see how I was supposed to delete just one of
Hello-
I am a Sybase user with a mysql question. Does mysql do bulk copy (bcp)?
Bulk copy allows a mass copy from a file a database and vice versa. I know
there is mysqldump but, i am not sure if that is what i am looking for. Can
anyone explain?
thanks,
brian
---
Hi,
I'm trying to use the old MS Visio Modeler with mysql. I have
downloaded and installed the myODBC driver and set up a DNS. But I keep
getting this connection error:
"Can't connect to MySQL server on 'www.jsicorp.com'(10060)"
I set the username and password the same as what works with phpMy
>Description:
I'm using Mysql 4.0.1 with query caching:
set-variable = query_cache_limit=10M
set-variable = query_cache_size=10M
set-variable = query_cache_startup_type=1
The Command:
mysqldump -q -K -t --t
mysqld --remove
use
mysqld --help
for more info.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 3:41 PM
To: MySQL-Mailingliste
Subject: Mysqld as service
Hi
How can i deinstall the mysqld as a service?
Thx for help
mfg
El
You are 100% correct.
Since MySQL does not support "cursors", I always put an auto_increment
column in my tables for just this purpose.
(This is what other DBMS' do, they just do it behind your back)
Unfortunately, the way MySQL really handles result sets doesn't lend itself
to simply adding
Try
mysqld --remove
>From the MySQL\bin directory.
I assume you mean a service on NT
Alternatively you can just stop the service in MMC and set it to manual
so it never starts. But I'm guessing this isn't what you want
Let me know
-Original Message-
From: [EMAIL PROTECTED] [mailto:[
>You are 100% correct.
>
>Since MySQL does not support "cursors", I always
>put an auto_increment column in my tables for just
>this purpose.
>
>(This is what other DBMS' do, they just do it behind
>your back)
You're right. I use DBase IV at work and every record has an internal record
number.
>
Can anyone comment on the stability of the current 4.x MySQL release.
I'd be using MyISAM tables and only features which are currently
available in the 3.23.x series.
--
do svidaniya,
~mitch
-
Before posting, please check
Katen
The manual has a section on optimization. If you have done
deletes on this table, the table may not be optimized.
Try: OPTIMIZE TABLE RADPOOL1
It does lock the table while doing it.
Other than that, I don't know what else to do.
David
-Original Message-
From: Steve Katen [ma
I'm trying to connect to mysql using lasso but no success.
The message I get is that there are no databases found.
Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5
What do I need to do to connect to mysql from lasso?
Also, how do I start a deamon at boot?
Thanks
Juan M. Quiro
>Description:
I have downloaded a binary version of mysql, perform all installations steps
from the manual. As soon as I started to execute safe_mysqld --user=mysql &
I got a core dump and the program exited. Please help
>How-To-Repeat:
>Fix:
>Submitter
Hi Nick,
I am seeing some rather strange problem here with mysqldump, after
trying very hard to reproduce the problem on a test server, I gave
up. Do the options make any difference when you run it? Can you send
a trace of the actual dump? I was seeing mysqldump terminate in my
case, now
I have started using MySQL because I want to learn about something new and
to keep a database of my growing comic book collection, which would be handy
should something should ever happen to them. In doing this, I have started
to think of other ways to use MySQL, such as managing my CD collection
On 10 Apr 2002, at 12:16, Jeffrey Flowers wrote:
> Perhaps having a column in my
> database with a serialized, unique record number would be a way to prevent
> this in the future?
That would allow you to delete just one of the duplicates (which you
also do with LIMIT 1 on your DELETE query), bu
On Wed, Apr 10, 2002 at 01:41:30PM -0400, Jeffrey Flowers wrote:
> I have started using MySQL because I want to learn about something new and
> to keep a database of my growing comic book collection, which would be handy
> should something should ever happen to them. In doing this, I have started
On Wed, Apr 10, 2002 at 10:06:47AM -0700, [EMAIL PROTECTED] wrote:
>
> Can anyone comment on the stability of the current 4.x MySQL
> release.
>
> I'd be using MyISAM tables and only features which are currently
> available in the 3.23.x series.
For my purposes, the 4.0.x builds I've used are j
Hi,
I'm using MySQL version 3.23.37 which works fine. However I am
currently trying to convert a MS Access database to MySQL and some of
the column names have embedded spaces i.e. "First Name". Now according
to the manual MySQL supports quoting of identifiers (for the above
reason), I can
Hi.
Well, your are right, indexes are not used at all, so ignore
everything about key_buffer and indexes I said, regarding this issue
(but key_buffer=16MG seems small with 1GB anyhow ;-)
Depending on how often you need the query, and how much columns are
involved, you may want to consider to add
I guess
make install prefix=/home/turner/mysql/test
just isn't an option. How would I request this functionality be provided
in the make file?
Thanks, Dave Turner
On Tue, Apr 09, 2002 at 05:45:04PM -0700, David Turner wrote:
> Thanks, but what I need to do is have
>
> make install install
ANSI92 states that quoted identifiers are delimited by double quotes "
-Original Message-
From: Nicholas A Read <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Date: Wed, 10 Apr 2002 19:39:52 +0100
Subject: Mysql and Quoted Identifiers
>
> Hi,
> I'm using MySQL version 3.23.37 which work
Hi.
(I am replying to the wrong mail, because I already delete the one
from Steve...)
The slow part is probably the "using filesort". I am not sure, if it
will work, but try a key over all used column, i.e.
INDEX ( POOL, STATE, TIMESTAMP )
If it works (i.e. if MySQL correctly "sees" that it ca
http://www.php.net/links.php
Mike
- Original Message -
From: "Luigi Stefano Sona" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 12:12 PM
Subject: a little help for a beginner
> Hello,
> where can I find a simple php to generate a default html table from a
ben,
I did that about three minutes after I got Davids email. Things seem to be
working a lot faster now, and the "using filesort" is gone. i am assuming
there isn't much more i can do to make this thing faster, but anything else
i can do would be awesome!
heres is the explain:
mysql> expla
Hi.
You have to use backticks (`) instead of single quotes (') as in
CREATE TABLE TEST (`ID` INTEGER)
When MySQL has been started with --ansi, double quotes (") will have
the same meaning. See http://www.mysql.com/doc/L/e/Legal_names.html
for more info.
Bye,
Benjamin.
On Wed, Apr 10
Hi,
I downloaded mysql Ver 3.23.49 binary to
a local directory. other than (/usr/local)
I changed ./bin/mysqlaccess for MySQL location, etc.
but for some reason it dies as sooon as starts.
I notice that some scripts and files in bin directory
Hi,
If I have two MYSQL tables with two columns for email addresses respectively:
csc_teammembers.tes_email AND cscflash_mb.email
Now, what I want to do is query only those email addresses in cscflash_mb that
DO NOT have a match in the csc-teammembers dbtable.
Can I just do a select statement
Well, I haven't kept up on the Cobalt product line, but, I wasn't aware that
they had intel based offerings.
I thought they were all RISC chip based.
That probably explains why I86 binaries won;t install..
If they don't have a binary for Cobalt Cube/RaQ systems, it's compile
time...
Hi.
As I said, or at least, tried to say, a key over all used columns
should help. Adding the column from ORDER BY avoids the "using
filesort". Adding YIADDR (which I simply overlooked last time) should
add "using index", as I mentioned. This means, that the data file is
not touched at all, but o
Hi,
If I have two mysql tables with two columns for email addresses respectively:
csc_teammembers.tes_email AND cscflash_mb.email
Now, what I want to do is only query those email addresses in cscflash_mb that
DO NOT have a match in the csc-teammembers dbtable.
Can I just do a select statement
Hi,
We want to use only MYSQL4.0 for our production database. Please let us know when the
Beta release is scheduled.
Regards
See Dave Matthews Band live or win a signed guitar
http://r.lycos.com/r/bmgfly_mail_dmb/http://win.ipromotions.com/lycos_020201/splash.asp
At 10:17 AM -0700 4/10/02, Juan M. Quiroz wrote:
>I'm trying to connect to mysql using lasso but no success.
>The message I get is that there are no databases found.
>
>Our environment is mysql 3.23.49 on osx server 10.1.3 and lasso 5
>
>What do I need to do to connect to mysql from lasso?
Hi Jua
Hello,
I probably installed a PHP script that created a table with a - in its name.
I can't figure out how to even touch this table. If I try:
mysql> describe A-14c;
ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1
This table exists for sure though:
| Tables_in_blesysdb
Hi,
We are developing a webbased serch application on MYSQL and PHP. I am sure most of you
must have already implemented
such application. Could you share with me the logic of such application. We were
planning to keep a keyword search
and my people feel that that will require additional load
Try enclosing it:
describe `A-14c`;
nickg
-Original Message-
From: David Chen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 10, 2002 2:05 PM
To: [EMAIL PROTECTED]
Subject: "-" character in table name
Hello,
I probably installed a PHP script that created a table with a - in its
Have you tried delimiting the table name with some form of quotes?
> -Original Message-
> From: David Chen [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 10, 2002 4:05 PM
> To: [EMAIL PROTECTED]
> Subject: "-" character in table name
>
>
> Hello,
>
> I probably installed a PHP s
mysql> describe 'A-14c';
ERROR 1064: You have an error in your SQL syntax near ''A-14c'' at line 1
It's not working...
- Original Message -
From: "nickg" <[EMAIL PROTECTED]>
To: "David Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 2:13 PM
Subject: RE: "-"
` = back ticks next to the 1 and above the Tab, not ' = apostrophe next to
the ; and Enter, you should be able to copy directly from the e-mail
mysql> describe A-14c;
ERROR 1064: You have an error in your SQL syntax near '-14c' at line 1
mysql> describe 'A-14c';
ERROR 1064: You have an error in
Folks, I've got a problem with a straight-forward master->slave replication
setup that has failed to replicate some data to the second server (or so it
appears). Below is a bunch of info including the last few lines of
mysqld.log from both servers, specs of the boxes, cron entries, etc... The
odd
Sorry, new member didn't know whether I should hit reply or send as new message.
SELECT cscflash_mb.email FROM cscflash_mb LEFT JOIN csc_teammembers USING
(email)
WHERE csc_teammembers.tes_email IS NULL;
MySQL said: Unknown column 'csc_teammembers.email' in 'on clause'
What ON clause? Note: in
Hi
Installation packages for the Raq range can be found at
http://pkgmaster.com/packages/raq/
>From the main control panel go to 'Control Panel' and 'Install Software'
MySql for Raq2 is not there, though it is for Raq3 and above, so perhaps
worth a try.
I installed it and it was almost 'hand
Hello,
This is an announcement of a new product that will interest some of you.
I have completed work for the first Beta release of a native ADO.NET
provider to MySQL.
You can find the details at http://www.mattculbreth.com/eidmysql.
Thank you,
Matt Culbreth
---
I'm trying to compile my program using libmysqlclient_r
--enable-thread-safe-client.
Would using mysql.h suffice or is there any specific header file to be
included.
I'm asking this because mysql_thread_init() call is not being recognized
when I'm trying to compile the program
regards
Hi,
I have written the following test case in which I'm trying to access
the database using differant threads each thread calls this function
test2(), access to which is protected by a pthread_mutex_lock() at the
beginning of the test and pthread_mutex_unlock() at the end of the test.
The same
Hi
We are in the process of developing Ultra High Availability ecommerce sites
based on php and MySql.
1. The software itself is well tested
2. The site is duplicated on two or more servers in separate data centres,
with live replication.
3. Nameservers for the domain are on the s
1 - 100 of 131 matches
Mail list logo
