Type this line of code before your line
$db = mysql_pconnect("localhost", "testdb", "test123") or
die(mysql_error());
The error u get will be pretty descriptive.
If not revert back to me.
nev L.
-Original Message-
From: Ricardo Fitzgerald [mailto:[EMAIL PROTECTED]]
@ $db = mysql_
Have a look below:
--
If expr1 is TRUE (expr1 <> 0 and expr1 <> NULL) then IF() returns expr2,
else it returns expr3. IF() returns a numeric or string value, depending on
the context in which it is used:
mysql> select IF(1>2,2,3);
-> 3
mysql> select IF(1<2,'yes','no');
Hi All
Is there any function in mysql which acts similar like decode() in Oracle..
The decode function acts like a procedural case statement inside a single
SQL statment to return different values or columns based on the the values
of other columns in the select statement.
It is extremely versa
Hi,
I'm developing a web application using mysqld as a localhost but
accessed from anywhere. My problem is simple, after entering form
data, and execute the php script, always returns an error I wrote in
case of unsuccesful connection to the db.
I did everything , create a user with many privile
Hi !!
You could maybe buffer the data in Your application
and then run inserts later... like this.
struct oneRow{
double timestamp;
double data;
etc, etc
}
struct oneRow rows[num_of_rows];
for (int i = 1; i < num_of_rows; i++)
{
// collect data
rows[i].timestamp = (double) i;
r
Hi.
Please, please always cite error message if you get any. Most time
they will be instant clue to some list members and without them it is
almost always the start of "guessing time".
That said, it sounds as if the "another user" does not have the file
privilege to access the UNIX socket (that
Hi There
This Is Pragneshkumar Gandhi From India
I am New To This Mailing List.
I have one problem
Yesterday i installed mysql in my linux box.
and it is working fine with root login.
i installed mysql with root login.
but if i login as another user
and on typing mysql on $ promt. it is giving so
On Fri, May 31, 2002 at 01:49:11AM -0300, Cesar Mello - Axi wrote:
> Hello,
>
> I intend to use MySQL in a data acquisition software. The actual
> version stores the acquired data straight in files. The sample rate
> can get up to 50 kHz. I would like to know if there is some way to
> improve MyS
At 7:10 PM -0400 5/30/02, Adam Hooper wrote:
>You forgot to include your C code. :)
Thanks. While trying to figure out what sections to post, I found
the error. The logic path that was being executed by the query in
question failed to go through the initialization routine properly.
Basically
Hello,
I intend to use MySQL in a data acquisition software. The actual version
stores the acquired data straight in files. The sample rate can get up to 50
kHz. I would like to know if there is some way to improve MySQL insert rate.
The following C++ code with mysql++ takes 5 seconds to execute
Have you tried to run the query in MySQL's console?
- Carsten
> -Oprindelig meddelelse-
> Fra: Rob Galvin [mailto:[EMAIL PROTECTED]]
> Sendt: 30. maj 2002 20:29
> Til: [EMAIL PROTECTED]
> Emne: ADO recordset is not returning rows in ASP page
>
>
> I have an active server page using an
Or another approach could be (using same example tables)
mysql> set @a:=0; set @b:=0; set @c:=0;
mysql> select
id,@b:=IF(id=@a+1,id,concat(@a+1,"..",id-1)),@a:=id,@flag:=IF(@b=id,id,"MISS
ING") from seq;
++---++-
--+
Thanks!
I'll choose option A since i'm being paid to build a database (now I'm
behind;( not reinstall sql and debian's woody will be pushed into stable
soon (along with mysql-server 3.23.49-8 etc which is the point of going
with debian). Thanks again!
-justin
-Original Message-
Fr
Hi everyone,
Somewhat new to the list (and very new to mySQL), so thanks for you help
in advance. I installed RedHat 7.1 (Seawolf) on a PC, and it came with
mysql 3.23.36. I logged in as a regular admin user and typed mysql to
get started... see what I could get accomplished just playing around
Hi.
Okay, now the problem is clear. mysqladmin 3.23.37 uses backticks (`)
around the database names (as you can see in the error message you
quoted) to support special chars therein, but backticks for quoting
column/table/database names where only intrudcued in 3.23.6, so the
3.22.32 server doesn
Benjamin,
In response to your mail of Friday, May 31, 2002 1:24:17 AM:
BP> Hello.
Thanks for the feedback.
BP> 3.23.36 is a bit outdated by now
Sure -- actually that's why I was vague about the side-issue (below)
and why I checked the changelogs for an explicit fix to my main
problem.
BP>
Thanks alot!!!
Anthony
> In the last episode (May 30), Anthony W. Marino said:
> > Where/how can I access the most recently updated code for MySQL Max
> > 4.x.
>
> http://www.mysql.com/doc/I/n/Installing_source_tree.html
-
Bef
Hi.
There are no build-in commands or functions to do so, but it is
possbile anyhow. This has been discussed on the list a while ago, so
you'll find it in the archives:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80264
Basically it boild down to using CONCAT/REPLACE (will issue warning
about
this is the version packaged with the stable branch of debian. Thanks,
justin
oba:~# mysql -V
mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686)
oba:~# mysqladmin -V
mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686
oba:~# mysqladmin ver
mysqladmin Ver 8.19 Distrib 3.23.37,
Hi.
That's the documented behaviour:
http://www.mysql.com/doc/C/o/Connection_access.html
For "jwgas@localhost" the entry "@localhost" has a higher precedence
than "jwgas@%" because it is considered more specific. You may want
consider removing the "@localhost" entry completely, depending on your
Hi.
On Thu, May 30, 2002 at 06:15:07PM +0300, [EMAIL PROTECTED] wrote:
> Philip Mak wrote:
> > It sounds like what you want can be accomplished by a simple "port
> > forwarder" program (search for that phrase on Google) which listens on
> > one TCP/IP port and forwards the results to another TCP/
Hello.
On Thu, May 30, 2002 at 10:52:46PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
>
> (FYI: "mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386)")
3.23.36 is a bit outdated by now (more than a year old) and there have
been several bug fixes regarding GRANT/REVOKE since then. So you may
c
Hi professional,
I got the following error when I install mysql 3.23.49 binary on sun
solaris 2.8:
ld.so.1: ./bin/mysqld: fatal: libz.so.1: open failed: No such file or
directory
Killed
Installation of grant tables failed!
Could you tell me where I can get this library libz.so.1 installed?
Than
exactly.mysqladmin -V
mysqladmin Ver 8.19 Distrib 3.23.37, for pc-linux-gnu on i686
this and every other command in mysqladmin work except for create and
drop. dunno why. I'd like to get on to building databases instead of
permissions over and over.
I ssh into the box. User/pass are sa
Hi.
This works fine for me. What is the output of
mysqladmin -V
mysqladmin version
?
Bye,
Benjamin.
On Thu, May 30, 2002 at 03:09:11PM -0700, [EMAIL PROTECTED] wrote:
> mysqladmin create test2
> mysqladmin: CREATE DATABASE failed; error: 'You have an error in your
> SQL syntax near
Hi!
I suspect that there might be a bug in the LOAD DATA and SOURCE statements
of MySQL-4.0.1-2 (alpha), but since I'm not 100% sure, I am sending this
to the list and maybe someone else migt be able to reproduce...
My configuration:
RedHat Linux 7.3 on i686
MySQL-4.0.1-2 server+client
MySQL bu
You forgot to include your C code. :)
Adam Hooper
[EMAIL PROTECTED]
On Thu, 30 May 2002 15:59:31 -0700
Bill Rausch <[EMAIL PROTECTED]> wrote:
> I have a program prototyped in PHP that works fine, but when I
> convert it to C using libmysqlclient the program fails inside the
> mysqlclient lib
I have a program prototyped in PHP that works fine, but when I
convert it to C using libmysqlclient the program fails inside the
mysqlclient library with a segmentation fault on a particular query.
It fails on two different platforms (Linux and Mac OS X).
The database I'm using is very simple
mysqladmin create test2
mysqladmin: CREATE DATABASE failed; error: 'You have an error in your
SQL syntax near '`test2`' at line 1'
-Original Message-
From: Myk Melez [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 2:59 PM
To: [EMAIL PROTECTED]
Cc: mysql
Subject: Re: what causes t
Justin,
The error message states that you have a syntax error in the CREATE
DATABASE statement. This is probably just a typo, but the only way for
us to diagnose the problem is for you to post the exact statement that
gives you the error.
-myk
justin cunningham wrote:
>mysqladmin: CREATE
A simple and fast way to find the gaps is to use a self LEFT JOIN, such as:
select a.id from seq a left join seq b on a.id + 1 = b.id
where b.id is null;
The result set will show any row in seq where there was no record with ID
one greater than that record's value.
You'll get back the last row,
Hi,
(FYI: "mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386)")
After extensive testing, I have found that: -
(a) [SIDE ISSUE]
Logged-in as a user (using password) and modifying privileges in
another MySQL (root) session, even with "flush privileges", the
privileges do not
Hi.
On Tue, May 28, 2002 at 06:51:11PM -0400, [EMAIL PROTECTED] wrote:
> How do you reference a column name in another table to avoid repeating the
> values?
I am not sure if I understand you correctly, but I assume you mean this:
Given the following table layout (it's a simplification in that
Hi.
On Tue, May 28, 2002 at 04:32:20PM -0700, [EMAIL PROTECTED] wrote:
> Thanks for the reply! Should I change the structure such that all
> varchar fields are in the same table?
I see no reason for this. It may make a (minor) speed difference, but
you should only ever change your table layout
In the last episode (May 30), Anthony W. Marino said:
> Where/how can I access the most recently updated code for MySQL Max
> 4.x.
http://www.mysql.com/doc/I/n/Installing_source_tree.html
--
Dan Nelson
[EMAIL PROTECTED]
--
Hi.
I meant the system environment variable. I do not really believe that
it causes the problem, because it shouldn't be able to shift by a
whole day. But this is the only thing I know of which may influence
time values. On second thought, I really think it isn't TZ, because
that influences only
mysqladmin: CREATE DATABASE failed; error: 'You have an error in your
SQL syntax near 'whateverunamethedatabase'
I can complete every function with msyqladmin except create and drop.
What am I doing wrong. I've read all the docs online, sent similar
emails with no response. This is not an acce
Where/how can I access the most recently updated code for MySQL Max 4.x.
Thanks,
Anthony
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
I have been trying to use the commandline mysql
program,
but I can't log in from the same machine:
[root@linux01 rcv]# mysql -u jwgas -p
Enter password:
ERROR 1045: Access denied for user: 'jwgas@localhost'
(Using password: YES)
But if I specify an ip address, I can !?
[root@linux01 rcv]# mysql
On Thu, May 30, 2002 at 03:17:53PM -0500, mos wrote:
> I'm going to be tackling this problem in a few days and I wanted to bounce
> it off of a few MySQL heads first to see if it generates any ideas. (or
> sparks?)
>
> Here's is the problem. I have an auto-inc column and rows will get deleted
Hello,
I have the following kind of table :
CREATE TABLE route (
route_k BIGINT UNSIGNED NOT NULL,
state ENUM('down', 'up') NOT NULL,
[ ... other columns ...]
PRIMARY KEY (route_k),
KEY state (state)
) TYPE = MyISAM;
---
Now here is the time taken by
At 01:24 PM 5/30/2002, you wrote:
>Hey guys,
>I have a very simple question, I though I knew the answer but the MySql
>manual has confused me
>
>I have a simple select from a database of say...1k records...I use
>
>select id from myTable where sal>1000;
>
>Lets say this statement would n
I'm going to be tackling this problem in a few days and I wanted to bounce
it off of a few MySQL heads first to see if it generates any ideas. (or
sparks?)
Here's is the problem. I have an auto-inc column and rows will get deleted
from the table and of course it will create a hole in the seque
On 30 May 2002, at 8:58, Dan Vande More wrote:
> If I do in the fs then there is tons of overhead because of new
> folders, each client having thier own folder(and subfolders) etc.
> And then htaccess'ing the dir's independently along with the
> overhead of keeping track of the htaccess files.
T
At 10:25 AM 5/30/2002, you wrote:
>Hi all,
>
>How is MySql compare to Access database? I understand that Access
>database is fit for a small environment where you have 5 to 10 users. Can
>MySql handle larger environment like Oracle, Microsoft SQL or it is just
>like Access?
Andy,
On Thu, May 30, 2002 at 02:30:07PM -0500, Philip Molter wrote:
> On Thu, May 30, 2002 at 10:43:58AM -0700, Jeremy Zawodny wrote:
> : Heikki,
> :
> : That reminds me of an InnoDB wish-list item I have. I like the level
> : of detail provided in the InnoDB monitor output. However, I'd really
> :
On Thu, May 30, 2002 at 10:43:58AM -0700, Jeremy Zawodny wrote:
: Heikki,
:
: That reminds me of an InnoDB wish-list item I have. I like the level
: of detail provided in the InnoDB monitor output. However, I'd really
: like to be available via MySQL rather than just in the logs. That
: will m
In short, it would be "LIMIT 20,0" If I'm not mistaken. However, the db isn't going to
kick out the string
"The query returned 0-20 of 132 records" for you.
Are you trying to do database pagination? Mulitple rows spread across multiple page
views? If that's the case, PHPBuilder has an article
select count(*) from myTable where sal > 1000;
Ryan Sander
Web Developer
[EMAIL PROTECTED]
http://cantonrep.com
> --
> From: [EMAIL PROTECTED]
> Sent: Thursday, May 30, 2002 2:24 PM
> To: [EMAIL PROTECTED]
> Subject: count...I think
>
>
> Hey guys,
> I have a ver
I have an active server page using an ADO recordset. When the SQL command is
a join of two tables with a count/group by there are no records being
returned (RS.EOF is true).
code snippet:
dbConn = "DSN=dbTestCases"
sqlVar = "Select " & _
"TestCases.TestCaseId, Count(*)" & _
" from TestCaseProject
Hey guys,
I have a very simple question, I though I knew the answer but the MySql manual has
confused me
I have a simple select from a database of say...1k records...I use
select id from myTable where sal>1000;
Lets say this statement would normally return 132 records, but how do I kn
Memon, Michele would like to recall the message, "Need help with query
result".
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
I believe that's modify. Check man page.
Alter table yourtablename MODIFY yourfieldname varchar (25) (or whatever
) not null default 'no comment'
-Original Message-
From: Anil Garg [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 7:37 AM
To: MySql Mail List
Subject: changing col
I've sent similar questions to the list with no replies so here's the
best I can do for you.
I use debian so I dunno what's specific to it beyond the created user to
start and stop the damon so; try
mysqlaccess user host db to see what privileges you've got.
u can restart msyql or safe_mysql
On Thu, May 09, 2002 at 09:31:06AM +0100, Robert Cross wrote:
>
> BTW, a big "thank you" to whomever wrote "mysqlbinlog" as it saved the day!
> (my database was well and truely broken)
That's Sasha. He wrote most (all?) of the replication code in MySQL.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]
On Thu, May 30, 2002 at 12:16:28PM +0300, Heikki Tuuri wrote:
>
> However, if there are lots of updates, and the user has a dangling
> uncommitted consistent read to the database for a long time, then the size
> of the undo logs may become significant also in InnoDB. I have to consider
> adding t
How would you guarantee the success of the transaction? If it fails as a result of a
hardware failure, then ultimately, the system as a whole has suffered a hardware
failure. If it fails for any other reason, then it's an issue with software or bad
data. Once those things are figured out, you p
Thanks Philip, I spent some time looking for that list, but obviously
didn't look hard enuf.
Ryan
> > 2) Why would these sample words have no match?
> > Cannot match against "when", "most", "like", "goes" Why are these
> > words not in the index? The file contains 1 million title records
> > an
On Thu, May 30, 2002 at 06:18:46PM +0200, Iago Sineiro wrote:
> Hi all.
>
> I have two questions about InnoDB table type.
>
> 1) I execute command SHOW TABLE STATUS for a table and the value for column
> Rows is different from the result of SELECT COUNT(*) for that table.
>
> mysql> SHOW TABLE
"LeTortorec, Jean-Louis" a écrit :
>
> Hello every one:
>
> I have a problem modifying the structure of a table:
> ALTER TABLE t_logs CHANGE log_id log_id INT(11) NOT NULL
> AUTO_INCREMENT;
> ERROR 1: Can't create/write to file './intranet/#sql-484_285.frm'
> (Errcode: 13)
>
>
Hello Everyone,
I haven't used SQL in a long time and I am having trouble designing the
query to get the result I need. I have 1 select query that looks like this:
SELECT WC.FIRST_NAME & ' ' & WC.LAST_NAME AS NAME, C.COMM_NO AS PHONE
FROM WRK_CNTRCTR AS WC, WRK_COMM_NUMBER AS C
WHERE WC.PERS_ID =
Hello every one:
I have a problem modifying the structure of a table:
ALTER TABLE t_logs CHANGE log_id log_id INT(11) NOT NULL
AUTO_INCREMENT;
ERROR 1: Can't create/write to file './intranet/#sql-484_285.frm'
(Errcode: 13)
I made sure that the rights on the MYI, MYD and frm file
Hi all.
I have two questions about InnoDB table type.
1) I execute command SHOW TABLE STATUS for a table and the value for column
Rows is different from the result of SELECT COUNT(*) for that table.
mysql> SHOW TABLE STATUS LIKE 'ALBARANCL';
+---++++-
[snip]
How is MySql compare to Access database? I understand that Access database
is fit for a small environment where you have 5 to 10 users. Can MySql
handle larger environment like Oracle, Microsoft SQL or it is just like
Access?
[/snip]
In my experience M$ Access really can only handle 2-3
Hello all,
I am trying to change part of a field across several
hundred rows, and am having difficulties. Here's the
setup: I have rows with field values of
"Rodregues0001" through "Rodregues0214". What I wish
to do is change the "Rodregues" to "TampaBay" while
leaving the number intact. Is ther
On Thu, May 30, 2002 at 08:15:41AM -0700, Ryan Barber wrote:
> 2) Why would these sample words have no match?
> Cannot match against "when", "most", "like", "goes" Why are these
> words not in the index? The file contains 1 million title records
> and all of these words are in the file many times.
At 14:28 30/5/2002 +0200, Inbal Ovadia wrote:
Hi,
>Hi all,
>I want to run multiple mySQL servers on my machine.
>Can i do this on windows 2000
This will possible with the next release of 4.0.2
>or just on Unix?
Regards,
Miguel
--
For technical support contracts, goto https://order.mysql.c
At 23:49 29/5/2002 -0400, Charles Brown wrote:
Hi,
>I removed the "user=" and "password=" entries from the my.ini
>file, because I didn't like seeing a password exposed in plain text.
>This seemed to have no effect on MySQL at all. What are those
>entries for? Do I need them? What should they b
on?=
From: [EMAIL PROTECTED]
MIME-Version: 1.0
Cc:
Return-Path: [EMAIL PROTECTED]
Originating-IP: 213.89.182.213
X-Priority: 3
X-Mailer: DCS.net Webmail ver. 0.1
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Why not use the best part from both !!!
u
Hi all,
How is MySql compare to Access database? I understand that Access database
is fit for a small environment where you have 5 to 10 users. Can MySql
handle larger environment like Oracle, Microsoft SQL or it is just like
Access?
_
Hi,
We have two major concerns with the full-text search in MySQL. They appear
to be simple problems that can be fixed. We are about to use MySQL in a big
way, and we would like to license it, however these problems are a major
obstacle that must be fixed (or at least understood).
1) Using the w
This may perhaps be an old bug and already fixed
entry in my.cnf
replicate-do-db=qbslive
Slave stopped replicating at some time ( not in logs )
I tried to start it back up and it would not budge so I checked the logs
020530 9:55:15 Slave: connected to master '[EMAIL PROTECTED]:3306',
repli
Philip Mak wrote:
> On Thu, May 30, 2002 at 05:53:03PM +0300, Dmitry Alyabyev wrote:
>> Is it possible to set up one mysql server *only* for listening on
>> socket and transfer client requests to another one server through
>> network connection ? Of course I mean return results too :-)
>
> It so
Hi,
Can anyone help me on this:
I have a MYSQL installed on a LINUX server.
My problem is:
The response time to a MYSQL request is sometimes very long (30s).
I have the following logs in file mysqld.log:
020529 14:52:44 22 Connect atos@was02 on
22 Init DB pve
020529 14:52:48
OK, I cannot find this sql query on the website or in any of my manuals.
I have a table that contains a set datatype eg
CREATE TABLE testjason (
ID int(11) NOT NULL auto_increment,
SomeSetColumn set('a','b','c') NOT NULL default '',
) TYPE=MyISAM;
I neet to perform an UPDATE on this ta
Anil,
Thursday, May 30, 2002, 5:36:32 PM, you wrote:
AG> Can anyone plz give me the query for chaning the column name of an existing
AG> table(which does not affect the elements of that column).
AG> I hope there is a way to do that.
Use ALTER TABLE to change column name:
http://www.mysql.
mysql-readers,
Thursday, May 30, 2002, 1:31:50 PM, you wrote:
EE>> Yeah, "Access denied" error means that user doesn't have necessary
EE>> permissions. Can you provide some more info? i.e. full error
EE>> message, how did you set up file_priv using GRANT statement or
EE>> updated privilege tables
Inbal,
Thursday, May 30, 2002, 1:44:34 PM, you wrote:
IO> i have mysql-3.23.41
IO> should i install 3.23.50?
Since 3.23.41 there was fixed a lot of bugs and made a lot of
changes. I suggest you to upgrade MySQL to a newer version, but there
is only a pre-release of 3.23.50 existent, on which a n
Arul,
Thursday, May 30, 2002, 2:05:52 PM, you wrote:
A> First of all i would like to know the basic difference between Inno DB and
A> My ISAM Table types..
Check the manual:
http://www.mysql.com/doc/T/a/Table_types.html
A> I wanted mySQL to support AutoIncrement , Transactions,Foreign Key
On Thu, May 30, 2002 at 05:53:03PM +0300, Dmitry Alyabyev wrote:
> Is it possible to set up one mysql server *only* for listening on
> socket and transfer client requests to another one server through
> network connection ? Of course I mean return results too :-)
It sounds like what you want can
I'm trying to find any and all thoughts on whether to store files in the db (PDF's,
word docs etc) or in the filesystem. If I do in the fs then there is tons of overhead
because of new folders, each client having thier own folder(and subfolders) etc. And
then htaccess'ing the dir's independentl
Hello
Is it possible to set up one mysql server *only* for listening on socket and
transfer client requests to another one server through network connection ?
Of course I mean return results too :-)
--
Dimitry
-
Before posti
ALTER TABLE tablename CHANGE oldname newname VARCHAR(40)
Simon
-Original Message-
From: Anil Garg [mailto:[EMAIL PROTECTED]]
Sent: 30 May 2002 15:37
To: MySql Mail List
Subject: changing column name
Hi
Can anyone plz give me the query for chaning the column name of an existing
table
Hi
Can anyone plz give me the query for chaning the column name of an existing
table(which does not affect the elements of that column).
I hope there is a way to do that.
Any help appreciated
Thanx
Anil
-
Before posting, ple
I have read the documentation and I understand the grant and revoke but
mysql -u is just not working for me. Yesterday I was able to do a mysql -u
root and it would ask me for my password and I would enter the one that I
created for root in my grant statement and it would let me in. But any
othe
Hi Iago,
This is really a freebsd related question and not MySQL. I believe
that the archives contain some info. Anyway you need to build a
custom kernel for freebsd see /usr/src/sys/i386/conf/LINT.
look for this section:
# Certain applications can grow to be larger than the 128M limit
# that
Hello all,
I am testing MySql Max 4.0.1 alpha. I have configured innodb tablespace and created
the two manual tables example.
But when I try to do a mysqldump to re-create the tables on another DB or 'SHOW CREATE
TABLE child', NO-FOREIGN key information is gathered on results.
However 'SHOW
All the numeric types are returned as strings. If you want to convert
them to numbers, you need
to use scanf or atod type functions.
Michael Flora wrote:
> Hello all, this is my first post to this list. I am relatively new to
> MySQL, and my question might be a basic one.
>
> I have a table
create table newTableOne
select A.name as groupA, B.name as groupB, C.name as groupC
from tableOne, tableTwo as A, tableTwo as B, tableTwo as C
where tableOne.groupA = A.ref_id
and tableOne.groupB = B.ref_id
and tableOne.groupC = C.ref_id;
Then re-add your indices and integrity constraints, doubl
Hi
I am using mysql 3.2133b, Sun Solaris 2.6, JHTML and Apache. I have
been getting Time-out requesting db connectionUnable to connect to
database server where url was jdbc:z1MySQL://localhost:3306 error
whenever the JHTML is initialized for the first time. It works fine when i
click on the refre
Arul,
do the equivalent of
mysqladmin variables | grep 'inno' | less
and check that innodb is up and running.
Thomas
--
sql, query
On Thu, 30 May 2002, Arul wrote:
> Hi All
>
> First of all i would like to know the basic difference between Inno DB and
> My ISAM Table types..
>
> I wanted
I have a table one with the following format:
groupAgroupBgroupC
ref1 ref2 ref1
ref2 ref3 ref2
ref4 ref2 ref1
another table two will have the full name for those
ref.
ref_id name
ref1 actual_name1
Try
http://www.mysql.com/downloads/mysql-3.23-pre.html
Mehalick, Richard RE SITI-ITPSCA wrote:
>On the MySQL download page, 3.23.50 is not available, only 3.23.49a. Is
>that the same thing?
>
>Rick
>
>
>
--
--
\|/ __\|/
`@" / o
On the MySQL download page, 3.23.50 is not available, only 3.23.49a. Is
that the same thing?
Rick
-Original Message-
From: David BORDAS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 5:34 AM
To: Inbal Ovadia
Cc: [EMAIL PROTECTED]
Subject: Re: mysql-3.23.50
I think you'll find
You have to look a bit more.
There is lots about runing MySQL on windows.
It also will not get the MS SQL worm that is about
So just have a nother look it will be woth it.
Simon
PS start..
http://www.mysql.com/doc/W/i/Windows_installation.html
-Original Message-
From: Inbal
- Original Message -
From: "Luca Lafranchi" <[EMAIL PROTECTED]>
To: "Arul" <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 5:10 PM
Subject: Re: JDBC Transactions
> Hi Arul, this is not a direct answer to your question, only a note about
> foreign keys and MySQL: if I'm right (please so
Hi all,
I want to run multiple mySQL servers on my machine.
Can i do this on windows 2000 or just on Unix?
because the manual talk about Unix.
How can i do this on windows?
thanks
-
Before posting, please check:
http://www.m
Thanx Mark
But i am new to MySQL...
First of all i would like to know the basic difference between Inno DB and
My ISAM Table types..
I wanted mySQL to support AutoIncrement , Transactions,Foreign Key
Constraints,Blob, Text etc...so as per the documents i thought of using a
InnoDB Table...
Curr
Arul wrote:
>Hi All,
>
>We are currently running a website which is running on Weblogic and Oracle
>DB.I just thought of porting it to JBoss and MySQL.
>
>Well..i am not sure how far does MySQL supports Transactions..
>I am currently using 3.23.49 Max on Win 2K.
>
>Does this version of MySQL Supp
Hi All
First of all i would like to know the basic difference between Inno DB and
My ISAM Table types..
I wanted mySQL to support AutoIncrement , Transactions,Foreign Key
Constraints,Blob, Text etc...so as per the documents i thought of using a
InnoDB Table...
Currently i am using 3.23.49 Max o
1 - 100 of 120 matches
Mail list logo
