I looked at SAP about 6 months ago. I don't know what MySQL has done with
SAP since they took it over, but I found SAP to have limited (and poor)
documentation, was difficult to setup, was a source-code nightmare (it's
written in more than one language, and uses a pre-compiler to unify the
source-b
Duke, Brian wrote:
I agree with that. the LERG does not get generated by us.
I push it immediately to Mysql every week.
so you are recommending:
$query="SELECT LERG_6.SWITCH, `LERG_6.SHA INDICATOR` FROM LERG_6 WHERE `LERG_6.SHA INDICATOR` = 00;"
(the backticks are around `LERG_6.SHA INDICATOR`
I agree with that. the LERG does not get generated by us.
I push it immediately to Mysql every week.
so you are recommending:
$query="SELECT LERG_6.SWITCH, `LERG_6.SHA INDICATOR` FROM LERG_6 WHERE `LERG_6.SHA
INDICATOR` = 00;"
(the backticks are around `LERG_6.SHA INDICATOR`)
is this correct?
Duke, Brian wrote:
I have a question about spaces in fieldnames.
locally running Access03 and using MyODBC3.51 to populate a MySQL40 database.
The Database name and table names are ok.
It's the field names I am having trouble with. The tables are huge and there are 26 tables.
The ODBC process comp
I have a question about spaces in fieldnames.
locally running Access03 and using MyODBC3.51 to populate a MySQL40 database.
The Database name and table names are ok.
It's the field names I am having trouble with. The tables are huge and there are 26
tables.
The ODBC process completes but due to
On 12/6/03 8:52 AM Dan Anderson wrote:
I am using the Perl DBI to connect to a mySQL database. I am
using prepare and execute statements to send the query to the database
and then execute it. Is there any benefit to doing this versus using
do?
The O'Reilly book "Programming the Perl DBI"
On Sat, Dec 06, 2003 at 08:20:57PM +0100, Franz Edler wrote:
> >
> > Errno 13 is Permission Denied. Is the mysql daemon running with
> > sufficient privileges to read the directory and files within it?
> > All the database files should be owned by the mysql user, and are
> > generally in the mysql
> From: Chris Elsworth Sent: Saturday, December 06, 2003 5:09 PM
>
> > The msqld.log file shows:
> > 031206 15:05:20 mysqld started
> > 031206 15:05:20 Fatal error: Can't open privilege tables:
> > Can't find file: './mysql/host.frm' (errno: 13)
> > 031206 15:05:20 Abo
Hi,
I am a mySQL newbie and would appreciate any possible help you may be
able to provide with the following query.
I recently installed mySQL on Mac OS X.2 following all the necessary
instructions, got the mySQL daemon running. All fine and well I
thought until I tried to access the mySQL da
On Dec 05, 2003, at 17:00, Lost Idols wrote:
A newbie here, with a simple question (I guess).
I just installed MySQL on my OS X 10.2
But failed pretty quick. Please help me... I wanna get started.
This it what it looks like after following the description in the
ReadMe file.
Last login: Fri Dec
I am using the Perl DBI to connect to a mySQL database. I am
using prepare and execute statements to send the query to the database
and then execute it. Is there any benefit to doing this versus using
do?
Thanks,
Dan
--
MySQL General Mailing List
For list archives: http://lists.mysq
On Sat, Dec 06, 2003 at 03:52:05PM +0100, Franz Edler wrote:
>
> The msqld.log file shows:
> 031206 15:05:20 mysqld started
> 031206 15:05:20 Fatal error: Can't open privilege tables:
> Can't find file: './mysql/host.frm' (errno: 13)
> 031206 15:05:20 Aborting
> 031206 1
Bhartendu Maheshwari <[EMAIL PROTECTED]> wrote on 06/12/2003
14:40:29:
> I know at the time of table creation mysql creates 3 file .frm, .MYD,
> .MYI and is stored in the path given by --datadir=, I want to know
> when I call insert row then where is this data goes I mean in which file
email the form contents to yourself or write it to a text file and store
that on your server.
hth
jeff
Wesley Philpot
Hello,
I have made a fresh installation of SuSE Linux 9.0.
Now I try to install MySQL, but I cannot start mysqld, it always terminates.
These are the two installation commands I used after installing with YaST:
LPC:~ # mysql_install_db
-> all tables have been created in /var/lib/mysql/my
I have just made a form using html, I wish to publish it, on to my website, but do I
need to have a databse on a server so that my customers can submit their information
to me?
Is there another way of doing it.
I look forward to your reply.
Dear All,
I am working on linux 8.0 and mysql 4.0.18. I want to know where the
mysql stores the data files and index files?
I know at the time of table creation mysql creates 3 file .frm, .MYD,
.MYI and is stored in the path given by --datadir=, I want to know
when I call insert row then whe
Hi,
I'm having problems to make a query.
Situation:
One table with data:
JobID,Year,Week,Place,Name
1,2003,1,Place1,Person1
2,2003,1,Place2,Person2
3,2003,2,Place1,Person3
4,2003,2,Place2,Person4
5,2003,3,Place1,Person2
6,2003,3,Place2,Person6
7,2003,3,Place3,Person5
8,2003,4,Place1,Person1
9,
Hi,This query is give an error like below;There is
a column that name and description are date in Table that also include
database.in the table,there are some date like
that:2003-12-01,2003-11-16,2003-12-01,2003-12-03,2003-11-19. when i run this
query,if i query between 2003-12-01 and 2003-12
[EMAIL PROTECTED] wrote:
>
> I have been reading and following the instructions from:
> http://www.mysql.com/doc/en/Resetting_permissions.html
>
> But, if I do:
> ./bin/mysqld_safe --skip-grant-tables
> And then I:
> mysqladmin -u root password 'mypassword'
> I get:
> mysqladmin: unable to change
Hi there I have some trouble with MyISAM tables. I
have found that supports 3 different types of the 1:1
relation.
a)1:1
b)1:1 (Non-Identyfying)
c)1:1 (Descedent Obj.)
What all these about?
What type of tables do u use normally?
I want to deploy a small application with a few tables
(up
"Prathima Rao" <[EMAIL PROTECTED]> wrote:
>
> dear mysq team,
>
> i have myodbc 3.51.01 version now how do i upgrade to latest version 3.51.06
> please help
What OS do you use?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
On 12/5/03 10:40 PM Bob MacIsaac wrote:
[...]
This is likely something simple but I've spent too much time on it with no
results - hope somebody can help - thanks.
Hi Bob -
try looking into the $dbh->quote() method.
--Jo
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mys
23 matches
Mail list logo
