Hi all.
I have this kind of problem setup:
1. I have a bunch of records and I need to store some record specific data
about each of them (date, owner etc).
2. I have a list of categories (=groups) in which a record may belong to and
I have to be able to store some group specific data (name, co
Pls help me, how to create views in mysql.
there isn't menu for views in mysql such as SQL Server 2000 ?
thx
Timotius,
[EMAIL PROTECTED] +62-31-531-2358 ext. 205
--
MySQL General Mailing List
For list
That works, Emery. Thanks a lot.
Dummy me, I was wrong. Seems that Access is just a tool rather than a
Database, then what's the database behind M$ Access?
cheers,
feng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
hay ross
i had ot pick up data rows for the dates between from-date and to-date
user selection u know
i went about the problem with a loop .
heres the code
for($loop_mon=$frm_mon; $loop_mon<=$to_mon ; $loop_mon++){
$ftch_rprt_dta_qry = "select sum($rprt_col)
from $rprt_tbl,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi!
On Sat, 11 Oct 2003, Wang Feng wrote:
> That works, Emery. Thanks a lot.
>
>
> Dummy me, I was wrong. Seems that Access is just a tool rather than a
> Database, then what's the database behind M$ Access?
It's the Microsoft Jet engine - a small,
I read in the manual that SymLinks should be avoided when not really needed.
I might be wrong!
Thanks
Emery
- Original Message -
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
To: "'Randy Chrismon'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, October 10, 2003 23:01
S
MySQL doesn't support views as of now. It's a feature MySQL is missing for
long time. For more information have a look at
http://www.mysql.com/doc/en/ANSI_diff_Views.html
Nitin
- Original Message -
From: "Timotius" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Saturday, Octob
"Timotius" <[EMAIL PROTECTED]> wrote:
>
> Pls help me, how to create views in mysql.
>
> there isn't menu for views in mysql such as SQL Server 2000 ?
Views currently are not supported in MySQL:
http://www.mysql.com/doc/en/ANSI_diff_Views.html
--
For technical support contracts, goto
Hi
We are pleased to announce the 2.0.2 release of Rekall, a personal,
programmable DBMS system for Linux and Windows. Rekall is the only viable
alternative to MS Access for Linux. With Rekall you will be able to quickly
and easily build database applications using Rekall forms and reports. A
ful
Hallo,
dies ist nur ein Testbeitrag ob das Abonieren funktioniert hat ...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi all,
I'd like to write a mysql client with mingw. It compiles without
problems but if I try to run the app I get an error message which says
somthing like (free translation from german):
Entry point for [EMAIL PROTECTED] function not found in libmySQL.dll.
What I've done so far:
cd into the m
- Original Message -
From: "Pakó Géza" <[EMAIL PROTECTED]>
To: "Jouni Hartikainen" <[EMAIL PROTECTED]>
Sent: Saturday, October 11, 2003 7:03 PM
Subject: Re: How to search by groups efficiently with MySql 4.0.15?
> how about:
>
> select record.*
> from link
> where group_id='x'
> left joi
Hi,
I have a text file with 120'000 lines. When I do a
load data local infile
only 85'416 records are loaded. There is no message of the sort
Query OK, X rows affected
just the next prompt is displayed.
I'll be glad for any hint what could cause this behavior. I'm using
versi
Victoria Reznichenko wrote:
relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0?
Is it in the manual because relay-log-purge is available in 4.0.x?
AFAICT, 4.1.1 isn't available for download from the mysql.com site.
4.1.0-alpha is. How would one obtain 4.1.1?
Would this work to m
Wolfgang -
> I have a text file with 120'000 lines. When I do a
> load data local infile
> only 85'416 records are loaded. There is no message of the sort
> Query OK, X rows affected
> just the next prompt is displayed.
>
> I'll be glad for any hint what could cause this behavior.
Hi,
I'm just starting out with mysql and would like to know if there are any good
database diagramming and development tools for mysql. Something that would
allow me to create a db and all the relationships graphically and then have the
sql code automatically produced. Ideally I'm looking for so
I have to correct my previos mail: using load data infile, all rows are
correctly loaded into the table. Yet, the control center displays a
smaller number of total records than the true number, which is
correctly displayed by count(*). What does the display in the control
center mean?
Wolfgang
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi;
I've been using the libmysqlclient library for a while now, and
developing some client application which are using MySQL server as DB
backend.
Now I'd like to use the libmysqld, so that I can have a an embedded
server, still this same applicatio
At 13:26 -0500 10/11/03, Christopher L. Everett wrote:
Victoria Reznichenko wrote:
relay-log-purge is available from 4.1.1. Do you use 4.1.1 or 4.1.0?
Is it in the manual because relay-log-purge is available in 4.0.x?
Sorry, what?
AFAICT, 4.1.1 isn't available for download from the mysql.com sit
19 matches
Mail list logo