On Wed 2003-04-02 at 13:32:22 +0300, [EMAIL PROTECTED] wrote:
Hello mysql,
We make updade of database from 3.23.49 to 4.0.12
Before update we can see host of connections /see Example1/.
After update every connections looks like they made from local host
/see Example2/, but they did not.
Any
Hi.
On Mon 2003-03-31 at 21:20:25 +0100, [EMAIL PROTECTED] wrote:
Sorry everybody. I assumed that as it had been out for a long time (2
years?) it was stable.
It's been 1 1/2 years (Oct 2001). But that was an alpha release. The
open development model of MySQL screws numbers a bit. The first
Hi.
On Thu 2003-03-20 at 08:25:08 +0200, [EMAIL PROTECTED] wrote:
Hi, I have a question I hope you can help me with.
I try to develop a database in Borlands Delphi or with C++ and Visual Studio
6 (Windows 2000). Probably I choose Delphi.
Now I want to use MySQL as a platform for my program.
Hi.
On Thu 2003-03-20 at 15:52:25 +0100, [EMAIL PROTECTED] wrote:
I use a lot of SET-alike fields in my tables. The fields are used to store
properties and such; every bit stands for a specific value. The fields are
queries like 'where property_field 14' or 'where property_field 1025'
if
On Thu 2003-03-20 at 15:59:29 +0100, [EMAIL PROTECTED] wrote:
Hi,
I was upgrading from 4.0.10 to 4.0.12 when a strange thing happened. I
compiled from source on SuSE-8.0 (gcc version 2.95.3, kernel 2.4.18-4GB)
and installed and everything was fine. However I noticed that I had
debugging
On Thu 2003-03-20 at 14:01:52 -0500, [EMAIL PROTECTED] wrote:
I have a table with a column defined as the following.
hash CHAR(16) BINARY NOT NULL
Most data inserts fine. However, if data has trailing white space
(ASCII character 32), it seems to be getting truncated by MySQL during
the
Hello.
On Mon 2003-03-17 at 18:08:08 -0600, [EMAIL PROTECTED] wrote:
I have an table with a column
numberINT NOT NULL PRIMARY KEY
This table contains many records and there are gaps in the number
sequence. I would like to modify this column to use the AUTO INCREMENT
feature but
Hi.
On Wed 2003-03-12 at 14:39:26 +0200, [EMAIL PROTECTED] wrote:
Hi,
I do not know how to compile, but I sure want to try the new features of
4.1.
There is no date yet for the first binary release of 4.1. They will
publish such an alpha release when they consider it mature enough for
general
On Wed 2003-03-12 at 11:16:09 -0600, [EMAIL PROTECTED] wrote:
At 11:41 -0500 3/12/03, Douglas B. Jones wrote:
Hi,
I understood replace to only increment n when it matches the
name value.
In that case, you want a primary key on (name,n) with n being
auto_increment.
There are 122,111
On Mon 2003-03-10 at 15:06:05 -0500, [EMAIL PROTECTED] wrote:
If you're indexing all 50 characters, index fewer of them.
Not that I think you're wrong, but help me understand, please:
It seems to me that this would cause the index creation to go faster,
but the execution of the SELECT
Hi!
On Mon 2003-03-10 at 16:44:40 -0500, [EMAIL PROTECTED] wrote:
[...]
- Given a system user 'junk' I would like to create a master user
'junk' that can have all permissions (including grant?) on all 'junk_*'
databases so that he can create and manage his own databases
- Given a master
Hi.
On Sun 2003-03-09 at 11:34:33 -0500, [EMAIL PROTECTED] wrote:
From what I understand, transactions are a kind of protection that
prevents certain commands from executing if certain other conditions
haven't been met.
Not completely. They can do much more.
Another way to look at
Hi.
On Thu 2003-03-06 at 12:45:19 +, [EMAIL PROTECTED] wrote:
If I develop a software for my company that works with MySQL and this
software will be used only inside the company, do I have to purchase
commercial license?
No, the GPL license will do: The GPL focuses on _distributing_
On Wed 2003-03-05 at 11:17:37 -0500, [EMAIL PROTECTED] wrote:
In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
Everything except stuff that only works when it's in the HAVING
clause. The
On Wed 2003-03-05 at 17:12:23 -0600, [EMAIL PROTECTED] wrote:
[...]
BA_DATE = '2003-02-25 00:00:00' AND BA_DATE = '2003-02-25 23:59:59'
or
TO_DAYS(FROM_DAYS(BA_DATE)) = '2003-02-25'
Hm. You mean FROM_DAYS(TO_DAYS(BA_DATE)), don't you? BA_DATE is a
timestamp, not a number of days.
Aside
Hello.
On Thu 2003-02-27 at 14:52:56 -0800, [EMAIL PROTECTED] wrote:
[...]
Anyways, I'm running into a little bit of a performance issue as the old
database report writer had direct access to the database through a c library
(no sql interface). On some reports there can be as many as 100,000
Hi.
On Wed 2003-02-26 at 18:36:07 +0100, [EMAIL PROTECTED] wrote:
[...]
As Mark has already stated, this is a typo - it should have read GAMMA
instead. Sorry for the confusion.
Would you mind to elaborate a bit on the current state of the 4.0
cycle? Since Monty suggested in the 4.0.8 release
Hello.
On Mon 2003-02-24 at 11:28:05 +, [EMAIL PROTECTED] wrote:
Hello,
In a table like this:
ID
Item1 char(100)
Item2 char(100)
.
.
ItemN char(100)
What's the cleanest way to do this mysql query:
SELECT * FROM MyTable WHERE AnyColumn LIKE '%mysearch%'
Only way I can
On Tue 2003-02-18 at 01:17:16 -0800, [EMAIL PROTECTED] wrote:
Just curious since max has more featured compiled in yet it's quite
smaller for download at mysql.com.
Because the MySQL-Max package only contains mysqld-max, and you are
supposed to install it alongside of the MySQL package, which
Hi.
Just a little correction.
On Tue 2003-02-18 at 12:44:39 +0100, [EMAIL PROTECTED] wrote:
Hi Maciej,
I don't know much about Interbase, but MySQL is for some cases a very good
choice!
Some database engineers would say MySQL isn't a database because it has no
transactions by know (in a
On Tue 2003-02-18 at 12:02:59 +, [EMAIL PROTECTED] wrote:
[...]
This is the main reason why I am looking at PostgreSQL at the moment,
although I've not looked much at Interbase, any good?
Either that, or fork MySQL into FreeMySQL, as we can do under the GPL,
and not charge our selves
Hi.
On Tue 2003-02-18 at 11:48:53 +, [EMAIL PROTECTED] wrote:
hi Maciej,
the only arguments you can get in favour of mysql is that it's free, and
some of its SQL statement are faster than interbase.
Well, and outstanding support, IMHO.
Interbase has the advantage of having views,
On Tue 2003-02-18 at 12:57:04 +, [EMAIL PROTECTED] wrote:
[...]
Most benchmark published actually give credit to mysql when it comes to
Mysql Vs Interbase, but as an end user, the best tests are the one i
conduct myself in my premises.
Therefor when i say that mysql Vs interbase
On Tue 2003-02-18 at 16:11:11 +, [EMAIL PROTECTED] wrote:
Benjamin Pflugmann wrote:
[...]
There is also some middle ground here. Which is the overlap of the two.
No. Either the way you distribute your software is GPL-compliant or
not. If it is not, you need a commercial license
Hi.
First, I am not a lawyer.
On Tue 2003-02-18 at 15:48:00 -0500, [EMAIL PROTECTED] wrote:
Quick question about the license issue that I thought of while reading
through the Interbase Vs. MySQL threads.
If I develop a program that uses MySQL for my company and it is only used
for internal
On Tue 2003-02-18 at 17:06:17 +, [EMAIL PROTECTED] wrote:
This will be my last posting. I don't belive I am being constructive
and have no wish to instantly be hated by the whole of MySQL.
[...]
Oh, I do not have anything at all against you. I just tried to correct
what I saw as a
the problem to the end. As I said, that is a list
of volunteers and your attitude surely doesn't help you to get answers.
Bye,
Benjamin.
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: Jason Maskell [EMAIL PROTECTED]
Sent: Monday, February 17, 2003 3:35 AM
On Mon 2003-02-17 at 12:14:12 +0100, [EMAIL PROTECTED] wrote:
[...]
Please disregard this mail. It was not supposed to go to the list.
(forgot to remove the CC that my mailer is set up to automatically
append for mails going to my -mysql address).
My apologies about that, Jason.
Bye,
Hi.
On Sat 2003-02-08 at 16:06:03 +, [EMAIL PROTECTED] wrote:
[...]
Re: InnoDB foreign keys bug Yesterday 12:30:56 am
BUG: InnoDB ORDER BY DESC may hang in 4.0.10 Yesterday 12:40:40 am
and they arrived 24 hours after being sent!
Yes, the list server is lagging behind now for a while
Hello.
On Sat 2003-02-08 at 07:24:17 -0700, [EMAIL PROTECTED] wrote:
[...]
Do you think the following links may help?
* http://www.mysql.com/doc/en/Replication_HOWTO.html
* http://www.mysql.com/doc/en/Replication.html
* http://www.mysql.com/doc/en/Replication_FAQ.html
Hi.
On Mon 2003-02-03 at 10:19:59 +0100, [EMAIL PROTECTED] wrote:
[...]
That can be made to work with several versions. In other words, it
would not check a version number saved in the database, but determine
the version by the database structure itself.
That would give #2 with the
Hi.
On Tue 2003-02-04 at 17:04:39 -, [EMAIL PROTECTED] wrote:
I noticed that when you return a zerofill field from a select statement into
a server-side language, say PHP or Perl, it will store the number with the
zeros included, great no problem.
However, if I insert into that table
Hi.
On Tue 2003-02-04 at 12:25:08 -0500, [EMAIL PROTECTED] wrote:
Ok I'm stumped on what I think should be a somewhat simple query. What I
have so far is a list of names that is in a list of projects AND in a the
main contact list by doing the following query:
SELECT p.name, p.company FROM
Hi.
First of all, do all of us, including yourself, a favor and upgrade to
4.0.9 (or 4.0.10 which should come out this week). Reporting problems
against a 7 months old alpha version is not very, well, productive, if
the current release is gamma quality.
On Mon 2003-02-03 at 10:04:58 +0100,
Hello.
On Fri 2003-01-31 at 13:45:26 -0600, [EMAIL PROTECTED] wrote:
Description:
One of our customers had a table named group, admitedly a bad design
but still not something that should cause mysqldump to fail hard!
Please be more specific. Did mysqldump error out or the
On Sat 2003-02-01 at 10:35:46 -, [EMAIL PROTECTED] wrote:
Hi Benjamin,
Wow, that sure sorted that problem out... I had to rejig it slightly to
get it to work,
Oops... too much copypaste by me :-)
but this is the final working version:
Glad it worked out.
Bye,
Benjamin.
Hi.
Accessing MySQL is equally easy in any of the languages (C++, Perl,
PHP, Java). So if that is the main point and it's correct that you,
Prabu, are already comfortable with C++, stick with it.
A reason a lot of people use Perl, PHP or Java is that many use MySQL
in conjunction with web pages
Hi.
I am sorry, I am not able to follow you. Maybe you should describe in
more detail what components are involved and what you want to
archieve. (If you simply want to store information you get from a
device, I don't understand where the database related problem is -
just store the data as you
Hi.
On Fri 2003-01-31 at 10:39:13 +, [EMAIL PROTECTED] wrote:
Hi
When creating a table can you use multiple Table_Options?
Yes. How about simply trying out beforehand?
The O'Reilly Managing Using MySQL show on page 288 a table been created
with two options ...)AUTO_INCREMENT = 1,
Hi.
On Fri 2003-01-31 at 08:27:11 +, [EMAIL PROTECTED] wrote:
Is it possible to mix javascript and PHP in the same script??
Of course. One (PHP) is run on the server side in order to create a
page which is sent to the client (here: the browser). The other
(Javascript) may be contained in
Hi.
On Fri 2003-01-31 at 10:05:40 +0100, [EMAIL PROTECTED] wrote:
any further news about 4.1 binaries release date?
Why the eagerness? 4.1 will be alpha. If you are going to use it
seriously (in your development), you want to compile it yourself
anyhow, because you will have to recompile it in
Hi.
On Fri 2003-01-31 at 12:17:42 +0100, [EMAIL PROTECTED] wrote:
I was already questioning my sanity, but the problem below is
reproduceable:
[...]
If I do
mysql update T_ORDH set STATUS=2 where PK_ID=26272;
ERSTELL_DATUM is set to the current date. I know that a timestamp
takes the
Hi.
On Fri 2003-01-31 at 12:32:51 +0100, [EMAIL PROTECTED] wrote:
Hi there, I have a little question for you in the mysql community..
I was wondering how persons in this community handles changes to the
database when your application that uses the database needs some new
tables, columns,
Hi.
On Fri 2003-01-31 at 06:48:45 -0800, [EMAIL PROTECTED] wrote:
Hi, I have been using autoincrement fields for some
time but was wondering how does it work in some
special situations.
Most of this depends on which MySQL version you use and which table
type, unfortunately. OTOH, for the
Hi.
On Fri 2003-01-31 at 10:44:58 -0500, [EMAIL PROTECTED] wrote:
I am trying to get a count of Distinct IP's from my homemade hit-log
database (don't ask). The db is MySQL. I'm trying this:
SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp),
DayOfMonth(TimeStamp) FROM RedirectLog WHERE
Hi.
On Fri 2003-01-31 at 15:46:37 -, [EMAIL PROTECTED] wrote:
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT basket.id,
products.part_code,
products.product_type,
products.description,
Hi.
In which way is this a MySQL related problem? Please choose a more
appropriate forum next time.
On Fri 2003-01-31 at 18:22:50 +0200, [EMAIL PROTECTED] wrote:
Hi,
From a web form I am collecting information to a table. On the form there is
a textarea element storing to a text field on
Hi.
On Fri 2003-01-31 at 17:22:37 -, [EMAIL PROTECTED] wrote:
[...]
select count(*) from percentile where criteria;
Work out 95% or this value.
create temporary table percentile (id int unsigned auto_increment
primary key, scantime decimal(20,10));
insert into percentile (scantime)
Hi.
On Fri 2003-01-31 at 18:56:19 +0100, [EMAIL PROTECTED] wrote:
Hi all,
my problem is the following, it's possible to insert an image in a table
with the libmysqlclient ?
Yes.
My language is C
i'm working with GNU/Linux
Bye,
Benjamin.
PS: In explanation: if you want a
Hi.
On Mon 2003-01-27 at 16:31:48 -0800, [EMAIL PROTECTED] wrote:
If I manually shut down mysql, I usaully use the mysqladmin shutdown
command. However, I noticed that the red hat way of stopping mysql in
its init scripts is by issuing a kill command to the pid. U, is
this wise? What
On Mon 2003-01-27 at 21:45:54 -0500, [EMAIL PROTECTED] wrote:
Stefan --
...and then Stefan Hinz, iConnect (Berlin) said...
%
...
% backing up my MySQL databases on a Win2K box at home to a Linux box in
...
% hand, I have only 128 MBit upstream from my Win machine, and maybe you
% will
Hi.
On Sun 2003-01-26 at 00:26:32 +0100, [EMAIL PROTECTED] wrote:
Here is the table definition as requested.
I'm sorry I could take a full dump... Each record consist of approx 600 KB
(just as in the Paradox table) so the file would be very big. (200 MB).
Well, you should have told us that
Hi.
On Sun 2003-01-26 at 15:22:06 +0100, [EMAIL PROTECTED] wrote:
Benjamin Pflugmann [EMAIL PROTECTED] wrote:
[...]
Why does MySQL needs to scan the Entire Table (all 200 MB) when I only have
selected ID ProductionYear in the SELECT statement ??
Because you have a table with variable-width
Hi.
On Sat 2003-01-25 at 13:36:01 +0100, [EMAIL PROTECTED] wrote:
[...]
mysql select count(id) as Films, ProductionYear from DVD
- group by ProductionYear
- order by ProductionYear desc;
[...]
39 rows in set (13.32 sec)
mysql
***
How is this
On Sat 2003-01-25 at 14:11:06 +0100, [EMAIL PROTECTED] wrote:
[...]
What I want is the combined output of selects like these (example with 2
users) :
SELECT timecode,
sum(cpuusage) AS jfn
FROM process
WHERE systemid = '2'
AND username = 'jfn'
AND timecode now() - INTERVAL 1 DAY
GROUP
On Sat 2003-01-25 at 14:16:35 +0100, [EMAIL PROTECTED] wrote:
Hello,
i just installed MySQL 3.23.55 on a SuSE Linux 8.1 system (compiled
myself), and after firing up mysqld and starting a scan (via nmap; my
server has no firewall) from another server, i get the following message:
Hi.
On Sat 2003-01-25 at 14:25:14 -0400, [EMAIL PROTECTED] wrote:
On Fri, 2003-01-24 at 20:27, Hoffman, Geoffrey wrote:
[...]
It's returning only stories in a section that have photos,
but I need it to return all the stories in a section whether
it has a photo or not.
I think the
On Fri 2003-01-24 at 07:59:16 -0600, [EMAIL PROTECTED] wrote:
sub-selects are not yet (to the best of my knowledge) supported in MySQL.
To be a bit more precise: They are not supported in any stable release
of MySQL. They are going to be supported in Version 4.1, which is
still declared alpha.
Hi.
On Wed 2003-01-22 at 23:07:24 -0800, [EMAIL PROTECTED] wrote:
I'm really just currious as to WHAT you would want to see as opposed
to NULL?
Well, you asking the wrong guy, because I did not need that feature,
but I'll try to explain anyhow.
They want to see an error instead. It is the
Hello.
On Wed 2003-01-22 at 09:13:20 +0100, [EMAIL PROTECTED] wrote:
Steve,
([Defendant] Query WITH a join - 8.79 seconds!
EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE
Cases.CaseNumber = Defendants.CaseNumber AND Filed = 1999-01-01 AND
(Defendant LIKE owen% OR
Hello.
On Tue 2003-01-21 at 18:52:06 +0200, [EMAIL PROTECTED] wrote:
Hello all,
I've tried the following sql queries:
mysql create table a(id int unsigned not null auto_increment primary key,
name text);
Query OK, 0 rows affected (0.01 sec)
mysql insert into a values(null, 'one'),
Hello.
On Wed 2003-01-22 at 08:53:23 +0100, [EMAIL PROTECTED] wrote:
seems like LAST_INSERT_ID() will not always return the correct value. If
you use ANSI-SQL INSERT, the function works fine. If you use MySQL
extended INSERT (i.e. with more than one record per insert statement),
the
Hello.
On Mon 2003-01-20 at 09:26:18 -0500, [EMAIL PROTECTED] wrote:
I'm brand-new to MySQL/PHP and to this list, spending an interesting
holiday weekend devoted to trying to start learning the
MySQL/PHP/Apached axis.
There're three things that had me thinking of just giving it all up.
Hi.
On Mon 2003-01-20 at 15:05:46 -0700, [EMAIL PROTECTED] wrote:
We need to store numbers that exceed the precision of the DOUBLE
datatype. The mysql manual makes no mention of a size bigger than
DOUBLE. Storing the number as a string is not preferable because of the
extra space a character
Hi.
On Mon 2003-01-20 at 16:51:53 -0700, [EMAIL PROTECTED] wrote:
Just a quick question. I am just starting to learn MySQL. I am on a
windows XP pro computer but want to create scripts using php and cgi for
all platforms. If I create a database using MySQL on windows, is the
database
Hi.
On Thu 2003-01-16 at 13:54:14 +0200, [EMAIL PROTECTED] wrote:
Hi,
If i understand well you wish to concatenate different strings.
Are many options but the most handy solution is if you use sprintf.
Well, in C++ you would rather use stringstream, because it has better
type and bounds
Hello.
On Tue 2003-01-14 at 09:32:02 -0800, [EMAIL PROTECTED] wrote:
I'm aware that NULL and are not the same thing.. I would like to
prevent the column from accepting values automatically ( with out the
presence of a DEFAULT).
[...]
The problem is: You have a DEFAULT, you just don't know
Hi.
As Jeremy said, most info can be found by reading the archives or the
manual.
On Tue 2003-01-14 at 11:41:16 +0200, [EMAIL PROTECTED] wrote:
I've asked on another list which database they recommend among MySQL and MS
SQL, and ... possibly PostgreSQL.
Most of that list members answered me
Hello.
Please start a new thread instead of replying to an existing one. Or
else, your message will be sorted with the original thread for people
with decent mail readers.
On Wed 2003-01-15 at 14:42:05 -0500, [EMAIL PROTECTED] wrote:
How do you query the table that is the results of a query?
Hi.
On Tue 2003-01-14 at 06:02:10 +, [EMAIL PROTECTED] wrote:
SELECT id,first,last FROM names ORDER BY id LIMIT 2,1;
Work? Limits to one result, start at second offset. (I may have the 2,1 in
the wrong order though)
Ok my gut would say that this would not give the result I want
On Tue 2003-01-14 at 09:22:40 -0500, [EMAIL PROTECTED] wrote:
One solution could be something like
SELECT id, first, last
FROM names
WHERE last '$previouslast' AND first 'previousfirst'
ORDER BY last, first
LIMIT 1
[...]
I don't think it would loop forever, since you
Hi.
On Sun 2003-01-12 at 22:01:37 -0500, [EMAIL PROTECTED] wrote:
On Sun, Jan 12, 2003 at 08:12:35PM -0700, Rodney Broom wrote:
I'm trying to delete 5 million rows...
[...]
If I was deleting things regularly, I'd have to delete maybe a couple
hundred thousand rows every day.
[...]
When I
Hello.
On Sun 2003-01-12 at 11:18:08 +, [EMAIL PROTECTED] wrote:
I've setup a mysql table field which is a SET type, but it seems to be
completely pointless. I can't see why I should use a SET type rather than a
string for the following reasons:
1. I appear to be able to store
Hello.
On Wed 2003-01-01 at 15:38:23 -0500, [EMAIL PROTECTED] wrote:
If I am reading the documentation correctly, MySQL will not maintain a
UNIQUE INDEX across the tables that make-up a merged table.
Correct. Although it is called a UNIQUE index, the MERGE table doesn't
hold it's own index and
David,
On Tue 2002-12-31 at 06:47:38 -0500, [EMAIL PROTECTED] wrote:
[...]
Oh, I see... I've been thinking about that, too; I currently use a
datetime field, but all I really need is a date and an hour. I figure
with one combined field I can match against -YY-ZZ% but maybe two
fields
Hi David.
On Sun 2002-12-29 at 16:21:56 -0500, [EMAIL PROTECTED] wrote:
...and then Benjamin Pflugmann said...
[...]
No; everything is one hour. Two hours is two bookings.
Ah. Good. That makes the case easier and is exactly the case my last
answer was about.
[...]
% know beforehand when
Hi again.
On Sun 2002-12-29 at 15:21:33 -0500, [EMAIL PROTECTED] wrote:
...and then Benjamin Pflugmann said...
[...]
% Of course, that's only possible if you can live with being
% MySQL-specific.
Hmmm... so it's a mysql thing and not a SQL thing. Well, I'd like to
avoid that, even though
Hi.
On Mon 2002-12-30 at 16:53:08 -0500, [EMAIL PROTECTED] wrote:
[...]
hashsum tinyblob not null , # hash of the card: have we seen this one?
index (hashsum) # for quick lookups
Whenever I try this with the index, I get
ERROR 1170 at line 49: BLOB column 'hash'
Hello.
On Sun 2002-12-29 at 11:26:01 +0100, [EMAIL PROTECTED] wrote:
Hello,
I had a problem few days ago. I'm doing my questbook, and I were thinking
what would hapen if I delete some row. Now I know, nothing. I had one column
ID (auto_increment) in my table. I wanted it to be one by one even
On Sun 2002-12-29 at 05:28:57 -0500, [EMAIL PROTECTED] wrote:
sql, table
I'm storing a SHA1 checksum as varchar(20) binary in my application.
After running a test, it seems MySQL will strip trailing spaces from a
varchar column, even if it is binary!
Yes, the BINARY keyword only
On Sat 2002-12-28 at 05:05:45 -0500, [EMAIL PROTECTED] wrote:
...and then Benjamin Pflugmann said...
[...]
% If you choose to go the SQL route, have a look at TEMPORARY TABLES,
% CREATE TABLE ... SELECT and INSERT ... SELECT. Don't forget that you
You mean a CREATE TABLE command that has
Hi.
On Sat 2002-12-28 at 08:15:58 -0500, [EMAIL PROTECTED] wrote:
[...]
create table schedule
(
# ID number
id smallint not null default 0 auto_increment primary key ,
client smallint , # references client.id
class smallint , # references classtypes.id
place
Hello.
On Sun 2002-12-29 at 21:40:22 +0300, [EMAIL PROTECTED] wrote:
tell me please where i need write my question about InnoDB in MySQL ?
This mailing list is fine for questions about InnoDB. But your
question is not a MySQL problem, but a misunderstanding about PHP and
Web pages in general.
Hi.
On Fri 2002-12-27 at 17:19:26 -0800, [EMAIL PROTECTED] wrote:
I looked through the documentation, but I couldn't find anything relevant
to this, so here goes...
I have MySQL with databases running on a Solaris machine, and MySQL with
different databases running on an Irix machine. I
On Fri 2002-12-27 at 23:45:25 -0800, [EMAIL PROTECTED] wrote:
for some reason i have a page in asp just showing code and no actual
visual data. any ideas ?
Ask in a Microsoft / ASP related forum?
I do not see how your question has anything to do with MySQL, so it's
off-topic here. This list
Hello.
On Wed 2002-12-25 at 20:06:22 -0800, [EMAIL PROTECTED] wrote:
My company is currently upgrade our company'database from PICK, an
old database system to mysql..
Our company database got 1 table where the record is more than 40
million records, and the other table also got about i
Hello.
On Thu 2002-12-26 at 09:26:09 -0500, [EMAIL PROTECTED] wrote:
i would try using php to have you page connect to the mysql database.. The code gets
parsed
first then is loaded into the browser...so the user pass for the database is never
seen.. i
would use something like:
$db =
Hello.
On Wed 2002-12-25 at 11:47:22 +0200, [EMAIL PROTECTED] wrote:
Hi all,
I gave the following command in the default MySQL client:
select from_days(365);
The result is -00-00 instead of 0001-00-00.
If I gave the following command:
select from_days(366);
It gives the
Hello.
On Wed 2002-12-25 at 13:15:58 +0200, [EMAIL PROTECTED] wrote:
Hi all,
I want to make a CGI program in Perl that queries a MySQL database, and the
problem is that I need to write the password for the database in the program
and this password can be seen by any user that has an account
Hello.
On Thu 2002-12-26 at 00:09:55 +0100, [EMAIL PROTECTED] wrote:
Hi there,
I'm using MySql 3.23.?? with Connector/J on Win32.
My Problem is that the database lets me UPDATE NOT NULL Fields with
NULL-Values.
This is not a special Java Problem!
For example:
The Field Name in
Hello.
On Sun 2002-12-22 at 08:56:43 -0500, [EMAIL PROTECTED] wrote:
I really don't want to do this client side (I'd have to execute
approximately 10 queries for every page load just for this small task).
Selecting the entire table into a temp table to number the rows also
seems rather
Hi.
On Fri 2002-12-20 at 10:13:57 +0200, [EMAIL PROTECTED] wrote:
Hi .
Simple but still tricky question : what mean 'thread' in mysql's server
point of view ?
I've set the thread_cache_size=30 in my.cnf .
I use Mysql with Php and my aplication's behaviour is like this :
connect -
Hello.
On Wed 2002-12-18 at 14:49:12 +, [EMAIL PROTECTED] wrote:
Hi,
I posted this a few days ago, but haven't seen a reply as yet, and I'm
getting quite desperate now!!
You probably got no reply because there is no real solution to your
problem.
I've managed to delete all the
Hi.
On Wed 2002-12-18 at 18:40:04 +, [EMAIL PROTECTED] wrote:
PLATFORM: 3.23.52-max-nt with Windows 2000 professional (default table type)
I have discovered a performace issue when joining several tables together.
The performance is extremely poor when performing select queries using
Hello.
For changing one table, the recommended way is
ALTER TABLE foo TYPE=MYISAM;
There is no built-in way to change several tables at once. I regulary
have the need to apply the same command to some tables. If you use
some UNIX shell, you can do something like this:
mysql your_db -t -e
Hi.
On Thu 2002-12-12 at 02:25:51 -0500, [EMAIL PROTECTED] wrote:
Hi,
Not sure if this is a PHP of a MySQL question, so I am sending it to both
groups.
Usually it is preferred that you send it only to the list which is
more appropriate first (toss a coin, if you must ;-) and only if you
Hello.
On Wed 2002-12-11 at 05:14:09 -0800, [EMAIL PROTECTED] wrote:
Hello:
I am having a strange problem that it appears that no one else is
having. I am running Slackware Linux with a 2.4.18 kernel, and MySQL
3.23.52-log. It is running on a dual CPU system with 860M ram.
The problem
Hello.
On Sat 2002-12-07 at 10:14:57 -0800, [EMAIL PROTECTED] wrote:
I have the binlog files stored to a separate drive (actually a partition on
a drive other than the raid array for the tables). When this partition
becomes full, mysql's load average goes from 1.5 to 25 and stays there until
Hello.
On Sat 2002-12-07 at 13:35:03 -0500, [EMAIL PROTECTED] wrote:
I found that kill -9 seems to be the only way to kill the hung process.
I'll see if I can find another way.
OK. Sorry about my over-reaction, but it was not obvious from your
mail that nothing else worked. Rather a bit too
Hello.
As a side note, did you try the precompiled binary for HP-UX already?
http://www.mysql.com/downloads/mysql-3.23.html
On Mon 2002-12-09 at 08:22:44 -0800, [EMAIL PROTECTED] wrote:
Benjamin,
Thanks for you information, now I tried to use gcc
Which version?
compile:
CC=gcc CXX=gcc
1 - 100 of 678 matches
Mail list logo