Bill MacAllister ([EMAIL PROTECTED]) writes:
> > Is this a MySQL issue or not? I'm not sure - I just downloaded
> > MySQL-3.23.47-1.i386.rpm and installed it (this is supposedly the static
> > version of the server, no?) and it gave me exactly the same result, which if
> > it was a Linux issue,
You might try and find it in another format, Access ?, and use one of the
converting programs on the MySQL site. Then get Paul Dubois's book and read
read read.
Cheers
M;)
-Original Message-
From: Luie delos Santos [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 7:59 PM
To: [
I keep getting a port occupied error after doing a default RPM install for
MySQL. I have used it without incident on Windows and was surprised by the
problems. I don't have anything running on port 3306, but it won't start, and
gives me an error. When I type in mysqld it gives me the same error.
I'm trying to create a database system for our school and since 'm still new to MySQL,
I'm wondering if there are any sample databases (student registration/enrollment
information, employee payroll, etc.) published in the internet so that I can have some
idea on how to go about developing our o
You can try...but, an i686 binary may use machine code instructions that are
not present in the i586 chip. Thus, the program will crash with an "illegal
instruction" message.
j- k-
On Friday 01 February 2002 16:11, Steve wrote:
> I'm wanting to install mysql on an older i586 machine r
> I am doing this using mySQlGui 1.7.5-2 on Win 2000
> Professional.
>From what I understand last_insert_id() can only be used
on the same connection as the insert. I'm guessing after every query
mysqlgui runs it disconnects, therefore killing last_insert_id().
-Jason Yates
---
I'm wanting to install mysql on an older i586 machine running RedHat (AMD
K62) and was wondering if the 3.23.47 i686 binary currently available is
OK on older CPUs.
I've been reading but don't understand if the i686 binary is just optimized
for the newer CPUs or if it shouldn't be run on the
I can't figure out how to formulate a query to retrieve a certain set of
data. I have two tables in a many-to-many relationship with each other
via a linking table. I want to get a list of the records in the first
table which have no matching records of a certain value in the second
table (i
Hi,
I just finished doing an online database in PhP/MySQL for a client and
they have asked if it is possible to output it to a MS Access database
so they can use it for Mail Merge, etc. Does anyone know how I would go
about doing this? Thanks. (The DB is MySQL 3.23.38 on FreeBSD 4.3) Many
Thanks.
Hi.
I have a number of tables with autoincrement colums
defined as:
CREATE TABLE HYPERLINK
( ID INT AUTO_INCREMENT NOT NULL ,
URL VARCHAR(255),
PRIMARY KEY(ID)
)
following an insert e.g.
Insert into Hyperlink (URL)
VALUES('http:\\www.yahoo.com')
I have queried with the
Dear all,
I am new to MySQL.
I have just installed the rpm package of mySQL on my RedHat Linux, but
found many problems. First, I can not run the following command:
mysqladmin -u root password "Mypasswd"
Second, it does not allow me to create any databases.
I can log in using "mysql
...perhaps a NEAR function could be added; as a config file or compile-time
option, you could define an accuracy range. Say,
./config --with-epsilon=0.0001
(if memory of my numerical analysis classes serves, the 'fudge factor' was
conventionally symbolized by epsilon; I suppose you co
On Friday 01 February 2002 14:19, Jim Dickenson wrote:
> Am I to assume that based on your response that one should never use a
> float field type if you ever want to select the data?
Er, no,
12.3399 < float_var < 12.3400
works fine.
It is the = operation that doesn't. Remember that
I have a column of type big int that I would like to convert to type int
I used the sql alter command with IGNORE and all the values greater than
2147483647 where all set to 2147483647
now what I would like to happen is I would like to keep the last bit and
have it flag the negative
for example
[ database query mysql ]
Jim Dickenson wrote:
> Am I to assume that based on your response that one should never use a float
> field type if you ever want to select the data?
No, that wasn't quite what he said.
You can certainly select on a float field, as long as you perform a
meaningful o
Hi out there!
We are converting our old access database to MySql, about time!
we are experiencing some problems with "double nested joins", don't know
what else to call them.
the query in access looks something like this:
SELECT arrangement.Navn, arrangement.StartDato, arrangement.SlutDato,
ar
Yes, but you need to use the decimal (fixed-point) type, not the floating
point type. Any program that's directly comparing FP numbers for exact
matches is simply wrong, and certainly won't be portable, even if it works
in one particular environment. Fixed-point numbers CAN be compared for
exac
Hello,
Under mysql 3.22.29, I was able to use isamchk to disable all index keys (-r
-k0), do millions of inserts into the table, then re-enable all the indexes
again with "isamchk -r -k4" (4 indexes). I'm testing out a new Redhat 7.2
Linux server with mysql 3.23.41, and am attempting to load
At 14:57 -0600 2/1/02, Greg Peretti wrote:
>Hi, folks.
>
>I have what I hope is a simple problem. Hope someone can help.
>
>I have a database with a date field in the form 2002-02-01. I would like
>to be able to query the database to determine the day of year of an
>entry (the $yday variable in th
SELECT DATE_FORMAT(date_column, %j) AS newdate FROM table
$j = Day of year (001...366)
- Original Message -
Sent: Friday, February 01, 2002 1:57 PM
Subject: Determining day of year
Hi, folks.
I have what I hope is a simple problem. Hope someone can help.
I have a database with a da
Am I to assume that based on your response that one should never use a float
field type if you ever want to select the data?
This causes a big problem for the way MyODBC 3.51 has been implemented. I
was actually debugging a problem I had in MyODBC when I ran across this. The
way MyODBC works is t
RTFM...
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html
#Date_and_time_functions
SELECT DATE_FORMAT(datefield,'%j') FROM table
David Piasecki
Software Engineer
Netvolution.com, Inc.
http://www.netvolution.com
548 South Spring Street, Suite 814, Los Angeles CA 90
At 13:33 -0800 2/1/02, Jim Dickenson wrote:
>I am running mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
>installed from a binary RPM file. This is using RedHat Linux 7.2.
>
>I have a table described as:
>mysql> describe junk;
>++---+--+-+-+---+
>
Hi, folks.
I have what I hope is a simple problem. Hope someone can help.
I have a database with a date field in the form 2002-02-01. I would like
to be able to query the database to determine the day of year of an
entry (the $yday variable in the localtime function in Perl). February 1
would be
A floating point number can never be equal to 12.3.
It can be close, and with rounding display as 12.3, but it
won't actually be equal to 12.3.
Use a decimal type instead.
Jim Dickenson wrote:
>I am running mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
>installed from a binary RPM f
I am running mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686)
installed from a binary RPM file. This is using RedHat Linux 7.2.
I have a table described as:
mysql> describe junk;
++---+--+-+-+---+
| Field | Type | Null | Key | Default | E
Frank,
Friday, February 01, 2002, 2:29:37 PM, you wrote:
FJS> The real design problem is that I'm new to this. However, ...
FJS> I'm putting together my own "knowledgebase" using MySQL and built from
FJS> various sources including books and list groups of similar form to this
FJS> one. It's b
Michael,
Friday, February 01, 2002, 4:15:24 PM, you wrote:
MM> I have been having an issue where the mysql client is core dumping for no
MM> obvious reason to me.
MM> I loaded a database via a file which created 167 tables. I then loaded
MM> another file to populate some data. I then go int
Isen,
Tuesday, January 29, 2002, 10:15:19 PM, you wrote:
IK> I want to know how to make software using mySQL as the database server.
It's easy.
IK> I'm using SuSE Linux 7.3Pro + KDE 2.2.2
IK> I've open a project in KDevelop 2.0 and put this link -lmysqlclient
IK> but I can't go thru: MYSQL m
SED,
Friday, February 01, 2002, 5:56:38 PM, you wrote:
S> Hi,
S> I'm trying to make a query where I select something distinct ordered by
S> most frequent?
S> I found below example from the manual but I can not figure out how I
S> should order them by most frequent - do you know how?
S>
Hello Carl,
Friday, February 01, 2002, 12:17:07 AM, you wrote:
CM> Victoria,
CM> I'm pretty new and this and have a similar need so I played with the steps
CM> you posted. However, the revoke command did not work. I received the error
CM> "ERROR 1141: There is not such grant defined for user
Tjeerd,
Friday, February 01, 2002, 4:21:31 PM, you wrote:
TvB> Where can I download mysqldump?
MySQL-clients package or MySQL source tree includes mysqldump.
Try to find it in /usr/bin/ or /usr/local/bin/
or try
"whereis mysqldump"
TvB> Tjeerd van Beek
--
For technical support contrac
Vadim,
Friday, February 01, 2002, 5:00:33 AM, you wrote:
VK> Greetings:
VK> I'm trying to update a table T1 based on the condition which is a result
VK> of the key join table A and table B
VK> the following command works with SYBASE but doesn't with MySQL:
VK> update A,B set A.field2='test'
the password function can not be decrypted can it, `cuz i need to show the
users' pass to the sis adm therefore i am considering to use the
encode/decode functions, although i am not secure to use those functions, i
have read in somewhere its not so confident.
does anybody here have some experienc
Chris,
It appears your missing the 'host' in your connection
DBI:mysql:$UserID:localhost",...
>>On Fri, 1 Feb 2002 12:39:31 -0800 (PST), Chris Petersen <[EMAIL PROTECTED]>
>wrote:
>>I did. it dies with "unknown error" - hence my confusion.
>>
>>and for those who didn't catch it, the u
>Description:
Joining multiple tables together in a select statement with where clauses
using the "IN (...)" construct generate duplicated output rows.
>How-To-Repeat:
1. ==>>Load the following into the "test_bug" database:
# MySQL dump 8.14
#
# Host: localhostDatabase: test_bug
#
I did. it dies with "unknown error" - hence my confusion.
and for those who didn't catch it, the userid and database name are
identical (hence the double usage of $UserID in the connect parameters)..
-Chris
On Fri, 1 Feb 2002, Colin Faber wrote:
> To: Chris Petersen <[EMAIL PROTECTED]>
> Fro
'desc' is a reserved word.
If you insist on using it for a field name, enclose it in back-ticks: `desc`
[EMAIL PROTECTED] wrote:
>>Description:
>>
>
> If you create a table with a column name called 'desc' (as the command,
> that is, without the '') mysql allows to create it, but the
A little more information would be helpful, Such as pasting the exact
error here.
Chris Petersen wrote:
>
> ok, after several months away from working with mysql, I figured I should
> get back into things.. anyway, the server is up and running, and I can
> access it with the mysql client, but I
>Description:
If you create a table with a column name called 'desc' (as the command,
that is, without the '') mysql allows to create it, but then you
can't query or do any operation with it, always giving an error like:
You have an error in your SQL syntax near de
cat thefilename | mysql -u -p dbname
--Greg Johnson
-Original Message-
From: David Turner [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 2:13 PM
To: [EMAIL PROTECTED]
Subject: Run a file from mysql prompt
How do I get a file full of sql commands to run
from the mysql promp
Cool, thx.
Dave
On Fri, Feb 01, 2002 at 01:21:18PM -0600, Paul DuBois wrote:
> At 11:12 -0800 2/1/02, David Turner wrote:
> >How do I get a file full of sql commands to run
> >from the mysql prompt?
>
> mysql> source filename;
>
> or
>
> mysql> \. filename;
>
>
> >
> >
> >In oracle I would t
At 11:12 -0800 2/1/02, David Turner wrote:
>How do I get a file full of sql commands to run
>from the mysql prompt?
mysql> source filename;
or
mysql> \. filename;
>
>
>In oracle I would type
>
>
>@thefilename
>
>I know how to do run the file from the unix prompt mysql < thefilename.sql
>
>Tha
How do I get a file full of sql commands to run
from the mysql prompt?
In oracle I would type
@thefilename
I know how to do run the file from the unix prompt mysql < thefilename.sql
Thanks, Dave
-
Before posting, please ch
At 1:33 PM -0500 2/1/02, Jim Van Heule wrote:
>Blue World and MySQL to Speak
>
>Bill Doerrfeld, CEO of Blue World, will present the opening keynote address
>at Lasso Summit on Monday, April 15, 2002 at 9:00 am. He will showcase the
>new Lasso 5 product line. Immediately following, David Axmark, co
Hi,
> when I use the wizard to configure the data source in .NET, it throws an
error, unable to
> use this connection or something.
What is this **configure the data source in .NET** ? Can you please elaborate
?
FYI : I used the following compilation options:
csc /t:exe /out:mycon.exe mycon.cs
At 13:05 -0500 2/1/02, Diego, Emil wrote:
>I have a table that I created and i am trying to create an index that
>contains a text field. I am having prblems with the syntax and keep
>receiving errors whenever I try to create the table.
>
>Here is the SQL statement for the table:
>
>CREATE TABLE
Just to let everyone know, the user must have their FILE permission in the
MySQL authentication tables set to Y.
Thank you to Paul DuBois for pointing this out to me. :)
Kevin
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Kevin Smith" <[EMAIL PROTECTED]>
Cc: <
Sent: F
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
VH PUBLICATIONS AND MIGHTYDATA ANNOUNCE LASSO SUMMIT 2002 EUROPE
Dallas, Texas--February 1, 2002--VH Publications, Inc. and MightyData, LLC
today announced Lasso Summit 2002 Europe scheduled for April 15-16, 2002 at
the Holiday Inn - Kings Cross/Bloomsbury in London, United Kingdom. Lasso
Summit
I have just started playing with MySQL about a week ago. I have read as
much as I can about optimizing the performance of MySQL and believe I
have everything setup according to the documenation i've read and am
very skilled at Linux.
When we attempt to link a table from MySQL, using the MyODBC d
ok, after several months away from working with mysql, I figured I should
get back into things.. anyway, the server is up and running, and I can
access it with the mysql client, but I get an "unknown" error whenever I
try to connect to it via perl DBI...
I'm using:
DBI->connect("DBI:mysql:$User
I have a table that I created and i am trying to create an index that
contains a text field. I am having prblems with the syntax and keep
receiving errors whenever I try to create the table.
Here is the SQL statement for the table:
CREATE TABLE IF NOT EXISTS logInfo (
ID BIGINT UNSIGN
At 17:47 + 2/1/02, Kevin Smith wrote:
>I don't get an error message... I'm actually running the script from the
>shell > prompt, so I'm totally mystified about why it's not working.
Umm, actually it is working, according to the trace below. execute()
returns "0E0", which means the statement
It is part of the standard distributions. If you installed from any of
the packaged distributions, you probably already have it. I know that
it installed for me when I installed on both Linux and WindowsXP.
David A McInnis
Managing Editor, PRWEB
--
PRWeb.com - The Free Newswire. Free
Neil,
Let's extend Kalok's suggestion:
A well-designed database is supposed to contain data that reflects/represents a
'reality'. The telephone
extension guide describes a 'reality' of the PBX as viewed by the users - a telephone
list by any other name -
built to answer the question "how do I p
Paul DuBois wrote:
> At 11:32 -0600 2/1/02, Gerald Clark wrote:
>
>> The single quotes around $image prevent perl from substituting the
>> value.
>> You are trying to load a file named $imageFN.
>> $SQL = "UPDATE banners SET image=load_file(\"$imageFN\") where id=1";
>
>
> But the single quote
I don't get an error message... I'm actually running the script from the
shell > prompt, so I'm totally mystified about why it's not working.
Here is the DBI debug :
[root@server1 cgi-bin]# perl blob.cgi
DBI::db=HASH(0x81b34a0) trace level set to 2 in DBI 1.14-nothread
Note: perl is runn
At 17:41 + 2/1/02, Kevin Smith wrote:
>Yes, it definitely is... I'm running Apache 1.3.22 on Linux RedHat 7.1 and
>MySQL 3.23.47.
Does the script connect to the MySQL server using a MySQL account
that has the FILE privilege?
By the way, you didn't report the error message that you get.
What
Yes, it definitely is... I'm running Apache 1.3.22 on Linux RedHat 7.1 and
MySQL 3.23.47.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Gerald Clark" <[EMAIL PROTECTED]>; "Kevin Smith"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 5:37 PM
That was the problem, I print out $SQL to the screen and it showed the
correct SQL statement, I've tried as you suggested, but it still did not
work... see my DBI debug output below if this will help?
I checked the image path and it is definitely correct.
Any ideas?
Thanks,
Kevin
[root@server1
At 11:32 -0600 2/1/02, Gerald Clark wrote:
>The single quotes around $image prevent perl from substituting the value.
>You are trying to load a file named $imageFN.
>$SQL = "UPDATE banners SET image=load_file(\"$imageFN\") where id=1";
But the single quotes are within a double-quoted string. So
At 10:55 -0600 2/1/02, Rick Emery wrote:
>It's created when that field is the first field in a multi-field index.
That's always what I think at first when I see "MUL", too.
Actually, it means the column is part of a non-unique index.
>
>For example:
>
>mysql> describe mytable;
>+---+
The single quotes around $image prevent perl from substituting the value.
You are trying to load a file named $imageFN.
$SQL = "UPDATE banners SET image=load_file(\"$imageFN\") where id=1";
Kevin Smith wrote:
>After reading some other posts on inserting a image into a blob field, I
>tried using
After reading some other posts on inserting a image into a blob field, I
tried using DBI to insert and the following does not work...
I've double-checked the path and it is correct.
$imageFN = '/var/www/htdocs/corporate/images/homenew.jpg';
$SQL = "UPDATE banners SET image=load_file('$imageFN')
thanks,
that did the trick just fine.
shon
- Original Message -
From: "Rick Emery" <[EMAIL PROTECTED]>
To: "'Shon Stephens'" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 11:55 AM
Subject: RE: what type of key is this?
> It's created when that field is the fi
MAX_EXTENSION=
select a.id + 1 from dude a left join dude b on a.id +1 = b.id where b.id is null and
a.id < MAX_EXTENSION;
You'll have to have one record in the table for this to work. I've done a better job
of this
in Oracle because of nested queries, but I think this could give you a go
It's created when that field is the first field in a multi-field index.
For example:
mysql> describe mytable;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| id| int(11) | YES | |
At 10:36 -0300 2/1/02, [EMAIL PROTECTED] wrote:
>Hi,
>
> I Have a problem with transaction controls... runing the query
>"begin; select * from table; commit;", this query run perfectly in the
>shell, but in my code return error of sintax.
If you're using some kind of MySQL API within a prog
At 10:19 -0600 2/1/02, Paul DuBois wrote:
>At 15:56 + 2/1/02, SED wrote:
>>Hi,
>>
>>I'm trying to make a query where I select something distinct ordered by
>>most frequent?
>>
>>I found below example from the manual but I can not figure out how I
>>should order them by most frequent - do you k
i have been asked to create an sql table with a certain structure. i was
sent a
description of the table. the first column is desribed as having a "MUL"
key. i don't now what that is or how to create it. can someone please help.
thanks,
shon
At 15:56 + 2/1/02, SED wrote:
>Hi,
>
>I'm trying to make a query where I select something distinct ordered by
>most frequent?
>
>I found below example from the manual but I can not figure out how I
>should order them by most frequent - do you know how?
>
> SELECT DISTINCT owner FROM pet
If you're using Linux, you can always do something like:
# cd
# du -s
where is your mysql data directory.
Example:
# cd /var/lib/mysql
# du -s test
9824test
On Fri, 2002-02-01 at 15:18, Peter wrote:
> How can I view/get the size of a MySQL database ?
>
> Many thanks,
> P
Hi,
I'm trying to make a query where I select something distinct ordered by
most frequent?
I found below example from the manual but I can not figure out how I
should order them by most frequent - do you know how?
SELECT DISTINCT owner FROM pet
Regards,
SED
-
To see what an error means do:
# perror
Example:
# perror 127
Error code 127: Unknown error 127
127 = Record-file is crashed
On Fri, 2002-02-01 at 14:15, Dana Sharvit wrote:
> Hi,
> when trying to perform any queries on a specific table I get the following
> error:
> "Got error 127 from table
I just noticed that mysqldump -d outputs
/*!4 ALTER TABLE equity_ind1 DISABLE KEYS */;
at the end of the dump of the table def...
If I understand this correctly... this will be executed
by any version of mysql version 4 and up...
That would be fine, except that since it is not dumping
What kind of code ?
I typically send each of those in as separate queries.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 01, 2002 8:36 AM
Subject: Problem with query
> Hi,
>
> I Have a problem with transaction controls... runing the query
BMJI,
But isn't 'last_insert_id()' only meant to be called after inserting a
record?? If you've never inserted a record (using the current connection),
it seems like calling 'last_insert_id()' would be a meaningless call. It
could return the highest value of the auto-increment column, but it co
At 8:04 -0500 2/1/02, Pax wrote:
>Hi I am newbie to mySQL and Linux in general. I installed Suse 7.3 with
>mySQL and I would like to update it to the latest version.
>
>My questions are:
>- should I uninstall the previous version? And if so, how?
You should read the section in the manual about up
How can I view/get the size of a MySQL database ?
Many thanks,
Peter M
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To
At 8:39 -0600 2/1/02, Gerald Clark wrote:
>Is it a character field?
>If it is it will be an ascii sort, not a numeric sort.
>Try:
>select personal_id+1 as id from Emp_table order by id desc
personal_id+0 might be a bit better.
>
>Vishakha Mali_Wagh wrote:
>
>>Hi all,
>>
>>I have been using mysq
D'Arcy Rittich writes:
> Hi Venu, I am unable to use MyODBC with .NET. What options do you recommend
> setting in DSN? I used Return matching rows, and Change BIGINT to INT, but
> no luck, error message. The Test connection works ok, but when I use the
> wizard to configure the data source in .
Hi!
We shall investigate your test case as soon as we find some time.
--
Regards,
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
It is part of the standard clients package.
Tjeerd van Beek wrote:
>Where can I download mysqldump?
>
>Tjeerd van Beek
>
>
>
>
>-
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists
Hi Venu, I am unable to use MyODBC with .NET. What options do you recommend
setting in DSN? I used Return matching rows, and Change BIGINT to INT, but
no luck, error message. The Test connection works ok, but when I use the
wizard to configure the data source in .NET, it throws an error, unable
[EMAIL PROTECTED] writes:
> I have been trying to download the GUI (Compiled MySSSQLGUI 1.7.5-1)for MySQL with
>no luck. I want to learn SQL using MySQL.
> What gives?
>
> Thanks
> Paul Lachance
> [EMAIL PROTECTED]
>
Hi!
If you are talking about Linux statically built binary, it worked fine
I don't see any code or errors.
[EMAIL PROTECTED] wrote:
>Hi,
>
> I Have a problem with transaction controls... runing the query
>"begin; select * from table; commit;", this query run perfectly in the
>shell, but in my code return error of sintax.
>
> Somebody help me?
>
>
>--
Hi Andreas,
> >I think AUTO_INCREMENT is on a per-connection basis. So if
> you're doing
> >this across different database connections, it will reset to 0.
[snip]
> do a 'select * from where test=1' and you will
> see that the 2 new
> values will be visible to both of the clients.
As I unde
$recno LIMIT 1";
$result = mysql_query($query) or die("Error: ".mysql_error());
?>
-Original Message-
From: Zak Grant [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 6:08 AM
To: [EMAIL PROTECTED]
Subject: Next auto_increment value?
All,
I'm a little (lot!) stuck on generatin
Is it a character field?
If it is it will be an ascii sort, not a numeric sort.
Try:
select personal_id+1 as id from Emp_table order by id desc
Vishakha Mali_Wagh wrote:
>Hi all,
>
>I have been using mysql since long time. But suddenly I noticed that, there is no
>function for sorting interva
What kind of erroneous results? How is the personal_id field defined?
The statement you have is syntacically correct so it must be something
in the data. If the personal_id is a numeric ID and you're storing it
as characters, this will sort differently than if you're sorting by
number. Rememb
I read an article from the developers of amihotornot.com that states that
MySql on Linux (single processor 700Mhz PIII) outperforms Solaris (quad
processors)
Is this because it was developed on Linux? Is it true?
http://www.webtechniques.com/archives/2001/05/hong/
Gary Every
UNIX Administrator
Where can I download mysqldump?
Tjeerd van Beek
-
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
I have been having an issue where the mysql client is core dumping for no
obvious reason to me.
I loaded a database via a file which created 167 tables. I then loaded
another file to populate some data. I then go into mysql and did a show
tables command, then I did a show columns command. wh
Hi,
when trying to perform any queries on a specific table I get the following
error:
"Got error 127 from table handle"
I could not find the meaning of this error in the mysql documentation, any
ideas?
any way I tried repairing the table using myisamchk with no success, any
other ideas?
Thanks
D
Steen,
I'm sorry I don't know the answer that question. I'll post it and see if
you get an answer.
P.S. I just noticed that my previous response to you was posted at 8:12 PM,
although I emailed it about 4:15 PM
-Original Message-
From: Steen Rabol [mailto:[EMAIL PROTECTED]]
Sent: Thurs
Hi,
I am using MySQL 3.23.41 and JDBC to support some servers. When I stress the servers I
get several errors like
java.sql.SQLException: General error: Table testtab was not locked with LOCK TABLES
I get this error on some of the insert attempts, and on half of the update attempts.
I also tr
Hello,
Why score is 0 in my query?
Any suggestions? Seems like fulltext '*' operator produce buggy results.
Alexander
>>>
mysql> \s
--
./mysql Ver 11.19 Distrib 4.0.1-alpha, for pc-solaris2.8 (i386)
Connection id: 9
Current database:
Curr
> CREATE TABLE `a` (
> `id` varchar(12) NOT NULL default '',
> `tipo` char(1) default NULL,
> `valor` double default NULL,
> PRIMARY KEY (`id`)
> ) TYPE=InnoDB;
>
> CREATE TABLE `b` (
> `idA` varchar(12) NOT NULL default '',
> `idB` varchar(12) NOT NULL default '',
> `cantidad` int(10) unsi
Hi I am newbie to mySQL and Linux in general. I installed Suse 7.3 with
mySQL and I would like to update it to the latest version.
My questions are:
- should I uninstall the previous version? And if so, how?
- are there any instruction of compiling it from source?
Thanks
Pax
-
1 - 100 of 115 matches
Mail list logo
