Excuse me,
I get an automatic reply from the mailinglist that my message wasn't send
so I send it again.
regards
hans
At 23:50 28-9-03 -0700, you wrote:
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote:
> Hi all,
>
> We want to migrate to MySQL, and because of its speed, we want to
On Mon, Sep 29, 2003 at 08:45:39AM +0200, Hans van Dalen wrote:
> Hi all,
>
> We want to migrate to MySQL, and because of its speed, we want to use
> MyISAM db. I plan to write code as an "alternate" transaction mechanism.
> But I have read that MySQL version 5 supports Stored Procedures (PL/SQL
Hi all,
We want to migrate to MySQL, and because of its speed, we want to use
MyISAM db. I plan to write code as an "alternate" transaction mechanism.
But I have read that MySQL version 5 supports Stored Procedures (PL/SQL like).
In PL/SQL it is possible to use in your stored procedures transac
Mark Matthews wrote:
> MySQL doesn't have schemas (currently). They are being developed in a
> future version. The DatabaseMetaData interface in JDBC has a method,
> 'getSchemaTerm' which tells you whether a certain database supports
> schemas or not (returning "" when schemas are not supported). M
I have a user who unfortunately named one of his tables "order". He also
has table names with a dash in them. mysqldump is unable to dump the
"order" table and I'm unable to use the ALTER command on it and the tables
with the dashes in their names to rename them. Is there any way to quote
the ta
In mysql 4.1 (and since mysql 4.0.14 or something like that) I believe
it's documented that an insert into X select * from X should work.
It's not working for me on MySQL 4.1.0 alpha, anyone else have this
problem? is it a bug? I haven't found any other reports of this not
working for anyone
In the last episode (Sep 28), Tony Thomas said:
> I've been hearing a bit about SQL injection lately, but the only
> documentation I can find refers to Microsoft or Oracle. Anyone know
> of good articles about injection in MySQL? Prevention? Detection? Is
> MySQL less vulnerable?
I would guess tha
Hi Tony,
Thanks a lot. That solved my problem.
Regards,
Delz
- Original Message -
From: "Tony Thomas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 29, 2003 12:40 PM
Subject: Re: Text formatting
> That's because the browser doesn't read the line breaks without a
In the last episode (Sep 29), delz said:
> I'm using mysql and php but I'm having problems printing my output
> using a browser. It's like this, i have a form and it has a text area
> that has the following contents:
>
> Hello World.
> Hello World.
> Hello World.
>
> What happens is when I output
On Sunday, September 28, 2003, at 11:40 PM, Tony Thomas wrote:
nl4br(); will insert a tag after every new line so your browser
can display it correctly.
Ahem. I mean nl2br();
That's because the browser doesn't read the line breaks without a tag at the end. All you need to do is this:
echo nl2br($textarea);
?>
nl4br(); will insert a tag after every new line so your browser
can display it correctly.
On Sunday, September 28, 2003, at 11:07 PM, delz wrote:
Hi All
Hi All,
I've been hearing a bit about SQL injection lately, but the only
documentation I can find refers to Microsoft or Oracle. Anyone know of
good articles about injection in MySQL? Prevention? Detection? Is MySQL
less vulnerable?
Thanks,
Tony
--
MySQL General Mailing List
For list archive
Hi All,
I'm using mysql and php but I'm having problems printing my output using a
browser. It's like this, i have a form and it has a text area that has the
following contents:
Hello World.
Hello World.
Hello World.
What happens is when I output the content using the php command echo,
i.e.
t
All,
I've got an InnoDb table that requires a composit key constraint. However,
I'm not certain how to word the DDL syntax.
Pretending for a sec this was SQL Server 2000 or Sybase ASE 12.5 I'd use the
following.
CREATE TABLE foo(
pri_1 INTEGER NOT NULL,
pri_2 INTEGER NOT NULL,
pri_3 INTEGER
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Andy Jefferson wrote:
> Hi,
>
> has anyone found a good way of determining the schema name using a JDBC
> connection to MySQL ?
>
> I've tried accessing DatabaseMetaData and calling getSchemas() to get the
> schemas and it returns nothing using 3.0.8 o
On Mon, Sep 29, 2003 at 02:46:46AM +0800, ml wrote:
> Hi all , I have a trouble about how to set quota for sql use , all db under
> mysql are own by mysql:mysql, i can't set any system quota for it , does
> anyone have idea about it ? thx
Check the archives. This was discussed last week.
Jeremy
Tim,
please post the whole contents of the .err log.
Best regards,
Heikki Tuuri
Innobase Oy
http://www.innodb.com
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for MySQL
- Original Message -
From: "tortoise" <[EMAIL PROTECTED]>
News
Hi,
has anyone found a good way of determining the schema name using a JDBC
connection to MySQL ?
I've tried accessing DatabaseMetaData and calling getSchemas() to get the
schemas and it returns nothing using 3.0.8 of the connector.
I've also tried tried DatabaseMetaData.getTables() and grab the
Director General: NEFACOMP wrote:
> Will you please explain?
Yes.
You wrote:
I am developping a software [...]
Also I will try to negociate with them for a customized version of the
MySQL
database (with some amount of $$$ of course) so that the server can be
reached by and only by MY APPLICATIO
Hi all , I have a trouble about how to set quota for sql use , all db under
mysql are own by mysql:mysql, i can't set any system quota for it , does
anyone have idea about it ? thx
Go to the end of the page http://www.mysql.com/downloads/mysql-4.0.html
You will find the source downloads. I said the end of the page.
Thanks
Emery
- Original Message -
From: "Luiz Rafael Culik Guimaraes" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 17:49
Greetings,
Currently i'm evaluating the possibility of moving from LIKE queries to
FULLTEXT search on a site that gets around 30 multi-LIKE queries per
second. The table is quiete simple, with auto_increment field and the
FULLTEXT varchar. What I want is that being able doing multi substring
Greetings,
Currently i'm evaluating the possibility of moving from LIKE queries to
FULLTEXT search on a site that gets around 30 multi-LIKE queries per
second. The table is quiete simple, with auto_increment field and the
FULLTEXT varchar. What I want is that being able doing multi substring
q
commandPrompt> USE DataBaseName;
Thanks
Emery
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 10:55
Subject: newbie Q: create a table in a database
> Hi, folks.
>
> I use Windows XP Pro, MySQL v.1.4
>
> The following i
You need to install a package.
Unless you install PHP from source and include MySQL at Compile time.
If you install PHP from a RPM package, you will need to install a package
called php-mysql-.rpm
Thanks
Emery
- Original Message -
From: "Adam Clauss" <[EMAIL PROTECTED]>
To: "'gam
Go to http://www.rpmfind.com and search for php-mysql
It should give you a list of packages.
So, to use PHP with MySQL you need to install a package with a name like
php-mysql-**.rpm
Hope this helps
Thanks
Emery
- Original Message -
From: "gamalt tant" <[EMAIL PROTECTED]>
To: <[EM
Dear Friends
Where i can get the source for mysql 4.0.14
I´ve like to contribute with an mysqlclient.lib compiled with Borland C++
compilers as existe an version of this lib for 3.23.36
Regards and thanks in advance
Luiz
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus syst
If you have different projects, I think it is better to have different
databases.
Also permissions can be set per database basis.
I am not an expert ;)
Thanks
Emery
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 15:19
Su
Hi,
If i want to use "load data infile" into selected column, for example i have
5 column in one table and i only load data into column 1,2,4 and 5 and i use "load
data infile "abc.txt" replace into table test(t1,t2,t4,t5)" but after i load into the
table, the previous data in colum
Hi!
> "Dathan" == Dathan Vance Pattishall <[EMAIL PROTECTED]> writes:
Dathan> Sometimes I get this error on a slave... for unknown reasons
Dathan> Error 'Incorrect key file for table: 'hasit'. Try to repair it' on query
Dathan> 'REPLACE INTO hasit
Dathan> If there is a wish list could
Hi, folks.
What are the benefits of having several databases rather than just one? The
hosting companies usually charge more bucks if customers asked for more
databases. I'm so curious why people need more databases while they can
create as many tables as they need in 1 database?
cheers,
feng
show create table database.tablename
desc database.tablename
you can use database.tablename in SEVERAL places .
insert into database.tablename values ( ) ..
select from database.tablename where ...
select from database1.tablename1 A, database2.tablename2 B ...
Ed Smith <[EMAIL PROTECTED]> wrote:
> Greetings. When I execute the SQL script below in
> mySQL 4.1, I get
>
> ERROR 1216: Cannot add or update a child row: a
> foreign key constraint fails
>
> It is, of course, choking on the enroll row insert.
> Why is this happening? Here are some things th
That's cool, Leonardo. Thanks.
BTW, how can I show the structure of the table without 'changing' to that
database?
cheers,
feng
- Original Message -
From: "Leonardo Rodrigues Magalhães" <[EMAIL PROTECTED]>
To: "Wang Feng" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, September
I am having intermittent access problems with MySQL and phpBB... I am
unsure
if it is a problem with MySQL, FreeBSD or php, leaning towards MySQLso i
figured i'd try my luck here.
I setup a small forum (7-8 users) that uses phpBB, and I am getting
intermittent "access denied" errors when accessin
You can create a table in any database without 'changing' to that
database, via USE or logging again. You can make
create table database.tablename (tabledefinition);
>
> >c:\mysql\bin\mysql line 1
> mysql>create database DB1line 2
mysql>cre
Neculai, thanks. That answers my question.
cheers,
feng
- Original Message -
From: "Neculai Macarie" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, September 28, 2003 8:01 PM
Subject: Re: newbie Q: create a table in a database
> > >c:\mysql\bin\mysql
> >c:\mysql\bin\mysql line 1
> mysql>create database DB1line 2
mysql>use DB1;
> mysql>create table TB1(id char(3)); ---line 5
- Original Message -
From: "Wang Feng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, Septemb
Hi, folks.
I use Windows XP Pro, MySQL v.1.4
The following is how I access to MySQL and create a database and a table in
that database:
>c:\mysql\bin\mysql line 1
mysql>create database DB1line 2
mysql>quit -
39 matches
Mail list logo