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.
>
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
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
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
> debuggin
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 & 1<<4' or 'where property_field & 102
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 prog
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
> featu
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,1
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
gener
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
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
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 tran
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 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.
As
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
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,00
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 releas
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
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 miscon
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 interna
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,
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 defin
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: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 selv
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 (i
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
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,
B
your
original post about 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: "Ja
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 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
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.
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 t
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.
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, [EMAIL
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 copy&paste by me :-)
> but this is the final working version:
Glad it worked out.
Bye,
Benjamin.
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 re-im
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 w
Hi.
On Fri 2003-01-31 at 17:22:37 -, [EMAIL PROTECTED] wrote:
[...]
> select count(*) from percentile where ;
>
> 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.
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 o
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.descript
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 W
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 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 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
> take
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 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: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
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 wo
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 a
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
>
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?
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 ha
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 th
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 th
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:
>
>
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 DA
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>
> ***
>
>
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. M
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 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 fun
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, '
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 "
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 t
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 charact
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 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 c
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?
B
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
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 kno
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 for
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
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.
[...]
> Wh
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 an
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.
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 'h
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
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 b
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 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
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 CREAT
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 in
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 e
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 lis
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.
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:
>
> $d
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 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" i
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 acc
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 g
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 ine
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.
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 "S
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 us
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 re
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 pr
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 Tue 2002-12-10 at 21:30:21 -0800, [EMAIL PROTECTED] wrote:
> Hello,
>
> I am wondering about the case where a client sends
> mysql_query("commit")
> but never gets a response.
>
> Is the transaction complete, or not? Perhaps the "commit" was lost in the
> network -- but, on the othe
Hello.
On Tue 2002-12-10 at 16:05:05 -0800, [EMAIL PROTECTED] wrote:
> I am just working on mySQL and create two tables, defined licenseID is
> the primary key in license_info, and foreign key in license_data.
> But I tested it didn't work the way as like in Oracle delete cascade or
> update casca
Hello.
On Tue 2002-12-10 at 13:50:04 -0800, [EMAIL PROTECTED] wrote:
>
> Would like to ask people's thoughts on whether Perl or
> PHP has higher performance with MySQL. I've heard
> rumours that DBI is slower than the PHP MySQL driver.
> What's your experience?
The speed difference (if any) is so
1 - 100 of 726 matches
Mail list logo
