Report tool - Mysql
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: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL help
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 statement or something to clean that up. Any ideas ? thanks, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql +events
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 ? thanks in advance, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Create an Innodb database ?
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 list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SQL to list table names
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 PROTECTED]
Which ports
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 unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Which ports
To all of those that provided the information, thank you. Next time I have a question, I will do the research before bothering the list. -Darryl -Original Message- From: Steve Poirier [mailto:[EMAIL PROTECTED] Sent: Monday, August 16, 2004 3:36 PM To: [EMAIL PROTECTED] 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 -Original Message- From: Darryl Hoar [mailto:[EMAIL PROTECTED] Sent: August 16, 2004 1:02 PM To: [EMAIL PROTECTED] Subject: Which ports 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 unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Open Source Status
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 version of MySQL for personal use ? thanks, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Help with Query
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 empnums greater than or equal to . Here is what I tried, but it gives a parse error: $query = SELECT empnum,name,hdate,Photo,(YEAR(Curdate()) - YEAR(hdate)) as timein FROM emp2 where mo nth(hdate)=$mymonth and empnum order by timein; thanks for any help. -Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query help
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 faqcat where cat=1 (if no records in table article have field with cat set to 1. how do I accomplish this with a single query ? thanks, -D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL syntax question
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 is upper,lower,mixed case. Also see if table1.field1 is a partial match to another. So, JOHNATHAN would match Jon or Jonny. thanks, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Select statement
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 something interesting. end emp2 loop end employee loop. can someone point me to the right join syntax to get this done ? thanks, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Importing data into MySQL
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 General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqlimport command question
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 records with 970 errors. When I look at the records created, the empnum field is properly populated, but all other fields are NULL. what am I screwing up here ? thanks, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysqlimport command question
To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: mysqlimport command question Darryl, Provide a copy of the table's details either with a describe table output or the table's definition and a sample of the input file's top 5-rows. Regards, Adam OK, here is the table structure: mysql describe emp2; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+-+-+---+ | empnum | varchar(4) | YES | | NULL| | | name | varchar(30) | YES | | NULL| | | fname | varchar(20) | YES | | NULL| | | lname | varchar(30) | YES | | NULL| | | email | varchar(60) | YES | | NULL| | | ext| varchar(4) | YES | | NULL| | | listit | char(1) | YES | | NULL| | | bdm| int(11) | YES | | NULL| | | bdd| int(11) | YES | | NULL| | | hdate | datetime| YES | | NULL| | ++-+--+-+-+---+ 10 rows in set (0.00 sec) mysql the first 5 records of emp2.txt are: 100 ALBERT JEFFREYALBERT [EMAIL PROTECTED] N 3 6 04/11/88 101 ALBERT STEVEN ALBERT [EMAIL PROTECTED] N 811 08/19/97 105 ARKEMA DORMANDARKEMA [EMAIL PROTECTED] N 729 10/01/87 110 ARKEMA DUANE ARKEMA [EMAIL PROTECTED] N 428 10/28/91 125 BECKER ALOYSIUS BECKER [EMAIL PROTECTED] N1118 03/01/93 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: mysqlimport command question 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 records with 970 errors. When I look at the records created, the empnum field is properly populated, but all other fields are NULL. what am I screwing up here ? thanks, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
copying
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 history db. Is there a more automated way to do this? thanks in advance, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
general questions
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 this ? thanks for the info, Darryl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What port to forward ?
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]
Grant - questions
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 do I setup the username/permissions correctly for remote access ? thanks, Darryl - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem starting mysqld on SCO
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 mysqld started 020904 21:41:45 bdb: /var/opt/K/SCO/Unix/5.0.6Ga/usr/local/mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 /data/log.01: Permission denied 020904 21:41:45 bdb: PANIC: Permission denied 020904 21:41:45 Can't init databases 020904 21:41:45 mysqld ended I have changed the ownership/group as per the instructions and I even went so far as to set the permission on the data directory to 777. Still no joy. Any ideas what step I missed? thanks in advance, Darryl - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem starting mysqld on SCO
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 mysqld started 020904 21:41:45 bdb: /var/opt/K/SCO/Unix/5.0.6Ga/usr/local/mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 /data/log.01: Permission denied 020904 21:41:45 bdb: PANIC: Permission denied 020904 21:41:45 Can't init databases 020904 21:41:45 mysqld ended I have changed the ownership/group as per the instructions and I even went so far as to set the permission on the data directory to 777. Still no joy. Any ideas what step I missed? thanks in advance, Darryl - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php