Greetings,
I need to get a tool to create reports using mysql databases. It would be
great if the resultant reports could be run by themselves (not inside the
report development environment).
Anybody have any recommendations ?
thanks,
Darryl
--
MySQL General Mailing List
For list archives: ht
Greetings,
I have a table in my database called item. It has two fields: item and
description.
Unfortunately the item field has got data with quotes around it. IE
"KP-00310". I
need to clean up the data and have the field contain just KP-00310. Since I
have
10,000 records, I need a update state
Greetings,
I am currently using Mysql 3.23.52. I am looking for events (when a record
is added, mod'd or deleted
from a table, and event is sent to each client connected to the DB.
Firebird can do this,
but before I port my application to firebird, I was wondering if Mysql had
something similar ?
I am running MySql 3.23.53. I am developing a multi-user
application in delphi using the Zeoslib controls.
Since it is going to be a multi-user application, should I use
Innodb ?
If so, are there any good tutorial/references for the Innodb ?
thanks,
Darryl
--
MySQL General Mailing List
For
Greetings,
I am running Mysql 3.23. Is there an sql statment that will allow me
programmatically
to retrieve the names of the tables in a database ?
thanks,
Darryl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PR
D]
> Subject: RE: Which ports
>
>
> This has to be the top lazy question of the year.
>
> Do you know google.com or mysql.com ?
>
> Like google.com:
> Mysql port
>
> _
> Steve Poirier
>
>
>
> > -Origi
Greetings,
I have Mysql installed on my freebsd box. I want to
be able to access the database from the internet, but
I need to allow the ports used in my firewall. What
ports does mysql use ?
thanks,
Darryl
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
Greetings,
Someone on a technical forum I participate in stated that
MySQL was converting to be a commercial application.
I always knew that MySQL had a commercial arm, but always
continued to have the Open Source arm as well.
For project planning purposes, will there continue to be an
open source
This is basic, but need help anyway.
I am using PHP and Mysql on a webpage. Here
is my query which works:
$query = "SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate)) as
timein FROM emp2 where mo
nth(hdate)=$mymonth order by timein";
now I need to modify it so that it ignores all
I have a two tables.
One has catagories, the other has articles.
I need a query that deletes catagories only
if not articles have that catagory.
Table faqcat(cat int not null auto_increment, name varchar(20))
Table article(aid in not null auto_increment, cat int, .)
Want to :
delete from faq
Greetings,
I am just trying to wrap my brain around joins.
I have a table employee. For each record in employee, I want to see
if a record exists in table emp2 based on a field value in both tables. IE,
for each employee
for each emp2
if employee.field1 = emp2.field3 then
do some
greetings,
When I am doing a select or update statement, I was wondering if there were
functions to compare strings. IE
Select * from employee,emp2 where uppercase(employee.fname)
matches(emp2.fname*)
that is to compare two fields from two tables and see if they match
regardless of whether
one i
Sorry about the wrap, but in the file each is on its own line (no wrap).
Cut and paste causes a
wrap in outlook.
thanks,
Darryl
>-Original Message-
>From: Darryl Hoar [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, September 02, 2003 4:31 PM
>To: [EMAIL PROTECTED]
>Subject: m
greetings,
I have created a text file in windows (from a database) that has the format
empnum name fname lname ext email listit bm bd hd
bm, bd are integers and hd is date.
I have tried to import using the follow command
#mysqlimport -u root -pmypass -d --local iweb emp2.txt
it imports the 97 r
I have data that is in a progress database. I need to get
a copy of the data into my mysql database. What would
be the best approach ? I can dump the data in any specific
format, so.
Never tried ODBC with Progress (8.2C12), so don't know if
that can/will work.
thanks,
Darryl
--
MySQL Ge
Greetings,
in my last email nobody tackled the schema copy issue.
Here is what I need to do:
I have a live database that contains several tables. I need
to create a history database with the same tables (without the data).
I would like to do this without manually creating all the tables in
the his
Greetings,
I am trying to figure out how to define a field type as boolean. Is there a
way? Or must
I define the field as integer and represent true/false with 1/0 ?
I have a schema defined for a database. I would like to copy that schema to
another
database. Is there a simple way to accomplish
Well,
I have a firewall on my LAN, but need to have access to the database
server from the wild internet. What ports do I need to forward ?
thanks in advance.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED
Greetings,
I created a database. I am having problems connecting
to the database remotely. Getting "Access Denied".
If I log into the machine that the database is on and
mysql -u darryl -ppassword
I get in.
If I try to connect from another machine, "Access denied for
[EMAIL PROTECTED]".
How d
Greetings,
I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website.
I installed it per the INSTALL-BINARY readme file.
When I try (from /usr/local/mysql) issue:
bin/safe_mysqld --user=mysql &
It starts and immediately stops mysqld. The .err file contains
020904 21:41:45 mysql
Greetings,
I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website.
I installed it per the INSTALL-BINARY readme file.
When I try (from /usr/local/mysql) issue:
bin/safe_mysqld --user=mysql &
It starts and immediately stops mysqld. The .err file contains
020904 21:41:45 mysql
21 matches
Mail list logo