Excuse me for late response.
When I do it from the mysql prompt it works fine but trough the API (I use
DAC for MySQL from microolap, maybe the bug is in there software!!) it
doesn't work fine.
I have try it on several versions: 4.1.1, 5.0.0 and 4.0.0.
Thank you for your help. If you think it
Hi,
> Hello people ! I was hoping for some wisdom from the good folks on this
> list about moving databases from access to MySQL.
>
> I am aware of the brute force method of exporting in CSV format or tab
> delimited formats and using mysqlimport to move the tables.
>
> 1. I was wondering if there
Arjun
The free DBTools DBManager can import Access databases directly to MySQL :
http://www.dbtools.com.br/EN/dbmanagerpro.php
Freddie
-Ursprüngliche Nachricht-
Von: Arjun Subramanian [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 19. März 2004 02:56
An: [EMAIL PROTECTED]
Betreff: Migrat
*Dear Friends!*
Can someone shed some light on how "SQL injection" attack occurs when
*magic_quotes_gpc *is"ON" and how it prevents when its "OFF". To my
understanding apostrophise are escaped automatically in POST/GET/COOKIE
when its ON, so how it tends towards SQL Injection.
Someone sugges
Hi *,
Can somebody show me how to sum for time, my format is hh:mm:ss, need to do
sum for the time as we usually sum a field with integer type. But I am not
sure sum can use for time format.
Thanks in advance
~Elle~
Try SQLyog - www.webyog.com
I use the ODBC Import Facility regularly.
regards
Karam
--- Arjun Subramanian <[EMAIL PROTECTED]> wrote:
> Hello people ! I was hoping for some wisdom from the
> good folks on this
> list about moving databases from access to MySQL.
>
> I am aware of the brute force
Found that function right after I posted. Thanks, it should do exactly
what I need.
Roger Baklund wrote:
* Scott Plumlee
I've got two separate tables, each with id fields that are
auto-increment. The created fields below are timestamps. The tables
are Innodb tables using transactions to proce
It looks as though, when I go into my databases, and use the command
"SHOW TABLE STATUS", that InnoDB tables do not have some information.
I am on MySQL 4.1.0-alpha-debug. Has this been fixed in later versions?
Example:
mysql> show table status;
+--+++-+
Arjun Subramanian wrote:
Do you have any
specific sites or utilities in mind ?
Try the code posted in this newsgroup posting:
http://groups.google.com/groups?q=macro+access+export+mysql&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=tchs8rl5phqib7%40corp.supernews.com&rnum=3
It's a little long to post here
Hi bob ! thanks for your quick reply. I did do a search on google. I
bumped into a bunch of stuff that really lead nowhere. Do you have any
specific sites or utilities in mind ?
Arjun Subramanian
Georgia Tech Station 32003
Atlanta GA 30332
Cell: +404.429.5513
"I'm MySQL certified. Are you?"
---
Hello people ! I was hoping for some wisdom from the good folks on this
list about moving databases from access to MySQL.
I am aware of the brute force method of exporting in CSV format or tab
delimited formats and using mysqlimport to move the tables.
1. I was wondering if there was a way to du
I have a table that has employee names, pay rates, and unique IDs. I want
to select all of the distinct employee names, and if there are two employees
with the same name, I want to be able to choose only one; the one with the
highest pay rate. If there are two identical employee names with the sa
I need some help with a complex query of mine.
The query in question looks like this:
SELECT DISTINCT film_film.filmid, titel, pdf, termin, aar,
film_serier.serieid, serienamn, screener, har_affisch, har_bilder, max(
datum )
FROM (
(
(
`film_film`
LEFT JOIN film_rel_regissoerer ON film_film.f
Has anyone done much testing with RAID stripe sizes for heavy
concurrency InnoDB-based applications?
I'm expecting that using a stripe size that matches InnoDB's page size
would make sense, but it could save a lot of testing if someone else
has already done this.
Thanks,
Jeremy
--
Jeremy D. Zaw
Not sure if you can...
Maybe add it to the ToDo list at:
http://www.mysql.com/doc/en/Fulltext_TODO.html
Cheers,
Andrew
p.s. also see you at the conference...
-Original Message-
From: Trevor Price [mailto:[EMAIL PROTECTED]
Sent: Thursday 18 March 2004 21:10
To: [EMAIL PROTECTED]
Subj
> or must you use the CONCAT() function?
Yes
SELECT concat(firstname,' ',lastname) AS fullname FROM customers;
Cheers,
Andrew
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]
Sent: Thursday 18 March 2004 22:30
To: [EMAIL PROTECTED]
Subject: String Concatenation Operator?
At 19:14 18/3/2004, José Angel Blanco Linares wrote:
Hi,
Hi, everybody
I have in my office two pc machines. One of them is a Pentium III with Windows
98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP
and MyODBC 2.50.39. The MySQL database is running on a linux server,
Does MySQL have a string contatenation operator, or must you use the
CONCAT() function?
SELECT firstname + ' ' + lastname AS fullname
FROM customers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
* Scott Plumlee
> I've got two separate tables, each with id fields that are
> auto-increment. The created fields below are timestamps. The tables
> are Innodb tables using transactions to process the statements. This
> will be an online registration process for our business, using PHP and
> MyS
You're using a foreign key.
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html. In order
for the constraints to work, the DB must be type InnoDB. Otherwise the data
checks for integrety must be done by you in the INSERT program.
Respectfully,
Ligaya Turmelle
"pramilav" <[EMAIL PROT
José Angel Blanco Linares wrote:
Hi, everybody
I have in my office two pc machines. One of them is a Pentium III with Windows
98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP
and MyODBC 2.50.39. The MySQL database is running on a linux server, and via
MyODBC I
Hi, everybody
I have in my office two pc machines. One of them is a Pentium III with Windows
98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP
and MyODBC 2.50.39. The MySQL database is running on a linux server, and via
MyODBC I connect to the MySQL server to run my Vi
I used YaSt to uninstall - though I wasn't really happy with the uninstall because I
used the find command on 'mysql' and found lots of stuff that was left behind after
the uninstall.
Anyway I then reinstalled with rpm -i
It probably isn't working 100% yet but it is working enough that I can pl
Mysqlians,
1. How can I tell how many words a fulltext index has indexed?(for
purposes of estimating performance)
2. How can I tell how much index file space a full text is responsible for?
( for regular indicies I use (key_length +4)/.067 ) but my
fulltext's are all on text's.
Thanks,
Tr
Scott Plumlee wrote:
I've looked through the PHP Cookbook and the MySQL cookbook and haven't
seen a solution. I've thought about trying to make some unique hash
with the data to be inserted but if there's another identical set of
data, then the hash would match. I can't use a timestamp in the
I've got two separate tables, each with id fields that are
auto-increment. The created fields below are timestamps. The tables
are Innodb tables using transactions to process the statements. This
will be an online registration process for our business, using PHP and
MySQL. PHP is using sess
You need to stop your MySQL process and then startup MySQL without the
grant tables (skip-grant-tables option). You can then change the
password.
Here some documentation on how to do it in Windows, but it's pretty
much the same for Unix.
http://www.mysql.com/doc/en/Resetting_permissions.html
On
Hi!
- Original Message -
From: "Victor Pendleton" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, March 18, 2004 8:21 PM
Subject: Re: InnoDB - alter column
> 1. The column types must match in order to establish a foreign key
> relationship. Alter the data type wo
On Mar 17, 2004, at 4:41 PM, Paul DuBois wrote:
At 14:06 -0800 3/17/04, James Hughes wrote:
I want to set up some automated table checking and the research I've
done has left me scratching my head.
I'm looking for a definitive answer to this thread:
http://marc.theaimsgroup.com/?l=mysql&m=106159
People,
I have a php web application that has an admin page for inserting course records and
one for selecting course records
and a client page for selecting course record.
In the admin side I insert records with an "insert into Course_Eng" and I select
records witha "select * from Course_Eng
1. The column types must match in order to establish a foreign key
relationship. Alter the data type would invalidate the Foreign key. Therefore
the key must be dropped first.
2. You can not have a relationship on a column that does not exists. Once again
the key must first be dropped.
3-4. Curre
>Table 1
>id_2 | date
>
>Table 2
>id_1 | id_2
>
>Table 3
>id_1
>
>I want to set the table1.date = '2004-03-18' for each record in table3. Any
>ideas?
Based upon your description you could probably use:
UPDATE table3, table2, table1
SET table1.date = '2004-03-18'
where (table3.
Hello,
Does anyone have any idea why the following don't work in MySQL
4.1.1-alpha with InnoDB tables:
1. cannot change column type without first dropping the foreign key
(when there is one)
2. cannot drop the column without first dropping the foreign key (if
there is one)
3. cannot explicitly d
Sorry if I posted this twice - I had some email issues yesterday, and I
didn't know if this made it to the list:
I am using php with mysql, and after moving my tables to a new server, I am
suddenly getting this error:
Query failed: You have an error in your SQL syntax. Check the manual that
cor
I've made a mess of this MySQL installation. I would like to uninstall and start
over.
- Started out installing via YaST
seemed to work but couldn't find MySQL or run it
- Tried installing binaries
had trouble running 'make install' (installed 'make' via YaST but never did find
the
UPDATE table1 t1, table2 t2, table3 t3
SET t1.date = '2004-03-18'
WHERE t1.id_2 = t1.id_2
AND t3.id_1 = t2.id_1
On Thu, 18 Mar 2004, Russell Horn wrote:
> I haev three tables:
>
> Table 1
> id_2 | date
>
> Table 2
> id_1 | id_2
>
> Table 3
> id_1
>
>
> I want to set the table1.date =
I haev three tables:
Table 1
id_2 | date
Table 2
id_1 | id_2
Table 3
id_1
I want to set the table1.date = '2004-03-18' for each record in table3. Any
ideas?
Thanks,
Russell.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
We have various client applications who will need data stored in MySQL
database. We are planning to send data requests from these clients to MySQL
database server through a DBMGR application.
We would like to keep the DBMGR as a single threaded application servicing a
configurable number of connec
jose manuel
<
Hi all:
Long time ago I've installed MySQL on my Debian Machine and I'm pretty sure I did'n
left the "sa" pwd blank as recommended.
Now, I'm installing other apps that need that "sa" pwd in order to be installed
properly butI can't remember the pwd.
is possible to recover the sa passwo
Hi all,
I'm trying to create new columns in a table with 308.000 records and 135
columns. It last 14 minuts to create one column. I make it trough
MySQL4XManager. I don't think is a problem of MySQL4XManager.
I guess is something about two many records and to many columns. Am I wrong?
If I am wro
we are faced to a problem where creating databases
the installation is succeded but we can't create the databases correctly
the instruction ./scripts/mysql_install_db shows
prepare installing database inspite of creating db table
what is the solution?
Do you Yahoo!?
Yahoo! Mail - More reliable
Oh, thanks for your information. I used phpMyAdmin b4, but I never noticed
that it makes from php script! Gosh!!!
Thanks for make it straight.
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Bernd Tannenbaum" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, March 18, 2004 9:4
Hi,
> -Original Message-
> From: Elly Wisata [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 18, 2004 1:55 AM
> To: [EMAIL PROTECTED]
> Cc: 'BGLefty'
> Subject: RE: php script for new database and user
>
> I don't think php script can create database. But maybe I am wrong.
> If I am,
Yes! Yes you can!
Ahem
Basically, MySQL is always a network-aware database whether connections
come in via Named Pipes (blame Bill for those), TCP/IP, UNIX sockets or
via the funky shared memory whatsit that was brought in with MySQL 4.1.x.
All that will be happening in your case is that y
Please read the attached file.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I wish to learn MySQL on my Linux box [SuSE 8.1]
Can I install MySQL on my hard drive and use it for learning *from* the
hard drive, without having to set up a server/network? This would include
MySQLCC.
In other words, can I run MySQL like Access, strictly as a local database,
for learning purp
Hi,
> -Original Message-
> From: Elly Wisata [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 18, 2004 1:55 AM
> To: [EMAIL PROTECTED]
> Cc: 'BGLefty'
> Subject: RE: php script for new database and user
>
> I don't think php script can create database. But maybe I am wrong.
> If I am, ple
On Thursday 18 March 2004 15:41, you wrote:
> Hm it really is the problem i think, so next question :) Where do I
> specify the location of the temp dir? Can I do that somehow in the
> /etc/my.cnf file?
Sure. Put into my.cnf:
[mysqld]
tmpdir=/path/to/the/tmpdir
User that runs mysqld ('mysql' by
This is just my guess, I am still too new to know for sure, but I would say
php can do what ever the user that is logging in can. phpMyAdmin will
create databases, and it is just a PHP Script.
Todd Hackathorn
-Original Message-
From: Elly Wisata [mailto:[EMAIL PROTECTED]
Sent: Thursday
S?ren Neigaard <[EMAIL PROTECTED]> wrote:
> The following SQL (bugzilla):
>
> SELECT =
> products.product,description,disallownew,votesperuser,maxvotesperbug,vote=
> stoconfirm,COUNT(bug_id) FROM products LEFT JOIN bugs ON =
> products.product=3Dbugs.product GROUP BY products.product ORDER BY =
>
May be Unix acces permissions on /root/tmp
(Errcode: 13) = EACCES Permission denied
Like you are using an ORDER BY, mysql needs some temporary space to do the order.
Marc.
-Message d'origine-
De : Søren Neigaard [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 18 mars 2004 13:29
À : [EMAIL PROT
The following SQL (bugzilla):
SELECT
products.product,description,disallownew,votesperuser,maxvotesperbug,votestoconfirm,COUNT(bug_id)
FROM products LEFT JOIN bugs ON products.product=bugs.product GROUP BY
products.product ORDER BY products.product;
Causes this error:
ERROR 1: Can't create/w
Hi all,
It is better i got the settings for *BitKeeper Wizard*
parameters. Becaz when i run it shows parameters and i
select one out of them as;
description : MySQL Source
category : development/building
email: [EMAIL PROTECTED]
name : Arun
street :
city :
st
[EMAIL PROTECTED] wrote:
> Hello colleagues,
> Im'using the MySQL 3.23,
> I've found the following commands
> SET SQL_LOG_BIN=0 Disables update logging if the user has process
> privilege. Ignored otherwise. (Master)
> SET SQL_LOG_BIN=1 Re-enables update logging if the user has process
> p
Hello colleagues,
Im'using the MySQL 3.23,
I've found the following commands
SET SQL_LOG_BIN=0 Disables update logging if the user has process
privilege. Ignored otherwise. (Master)
SET SQL_LOG_BIN=1 Re-enables update logging if the user has process
privilege. Ignored otherwise. (Master)
Jochen,
what's the result of
prompt> mysql -uroot -pXXX -hxxx.xxx.xxx.xxx
when you do it on the client host? (I still suspect that permissions are
not properly granted).
Regards, Thomas Spahni
On Wed, 17 Mar 2004, Jochen Kaechelin wrote:
> I use the following Script to backup a remote MySQL-
Kris Burford <[EMAIL PROTECTED]> wrote:
> hi
>
> wondering whether someone can set me straight on whether it's possible to
> request a set of records from a single table with multiple conditions.
>
> for instance, a "story" table, containing id, title, text, section and
> published_date. what i
Hi,
I want to CREATE a TABLE an specify a collation.
If I do
CREATE TABLE ... DEFAULT CHARACTER SET latin1 COLLATE latin1_german1_ci;
SHOW TABLE STATUS shows me Collation: latin1_swedish_ci
If I omit the keyword DEFAULT the requested collation latin1_german1_ci
is shown by SHOW TABLE STATUS.
So
Hi Alan,
> Thanks for that Chris, interesting thoughts.
>
> For clarification, there is *NO* UPDATEs running on this table. Not a
> single one! :) Many more SELECTs than INSERTs
If you value your data, and these INSERTs are part of
a multi-insert batch of related data, go with the table-type
th
hi
wondering whether someone can set me straight on whether it's possible to
request a set of records from a single table with multiple conditions.
for instance, a "story" table, containing id, title, text, section and
published_date. what i would like is to retrieve is the 5 most recently
pub
Thanks for that Chris, interesting thoughts.
For clarification, there is *NO* UPDATEs running on this table. Not a
single one! :) Many more SELECTs than INSERTs
Chris Nolan wrote:
Alan Williamson wrote:
A quick question for the hardcore MySQL experts out there.
I have a simple table;
---
"Keith Thompson" <[EMAIL PROTECTED]> wrote:
> All of my tables are now InnoDB only. So, what I'd like to do is
> reduce MySQL tunable variables down as much as possible for things
> that don't affect InnoDB so that I'm not wasting memory on buffers
> that will get little or no use.
>
> It's obvio
Alan Williamson wrote:
A quick question for the hardcore MySQL experts out there.
I have a simple table;
---
ID varchar (PK)
DATA longblob
---
This table is a simple persistence cache for one of our servers. It
regularly INSERTs and SELECTs into this table data o
When I first mail to [EMAIL PROTECTED] they said
Quick answer: you probably have an incorrect Internet Proxy setting.
Test if you can connect to mysql.bkbits.net port 14690 using telnet:
C:\> telnet mysql.bkbits.net 14690
A quick question for the hardcore MySQL experts out there.
I have a simple table;
---
ID varchar (PK)
DATA longblob
---
This table is a simple persistence cache for one of our servers. It
regularly INSERTs and SELECTs into this table data of approximately 2KB
- 2
Mark,
I've had some of the same thoughts as yours. Others have mentioned SHOW
CREATE TABLE.
I created a Windows program to put a GUI interface on designing tables for
MySQL to ease the load on my memory while setting up a database. It
includes the ability to insert new fields at any place and
At 02:03 3/18/2004, olinux wrote:
>--- "W. D." wrote:
>> I am a relative newbie to MySQL and PHPmyAdmin. I
>> tried adding
>> data into an existing table by 'uploading' a file in
>> PHPmyAdmin.
>> I know the INSERT INTO commands are valid, since I
>> can import
>> several hundred records using P
--- "W. D." wrote:
> I am a relative newbie to MySQL and PHPmyAdmin. I
> tried adding
> data into an existing table by 'uploading' a file in
> PHPmyAdmin.
> I know the INSERT INTO commands are valid, since I
> can import
> several hundred records using PHPmyAdmin. However,
> when I
> try to impo
Hi,
I have installed the package bk-3.0.4-x86-win32.EXE
from Bitkeeper.com, to get the Mysql-4.1.1 source code
for Windows 2000 box.
It's installed successfully and frame the shortcuts in
my Start menu --> program --> Bitkeeper with
sub menus for
bash shell1
bash shell2
Helptool
70 matches
Mail list logo
