On Thu, Jan 30, 2003 at 10:08:08AM +0100, Webmaster LLBfrance wrote:
Hello,
Can you tell me how to drop or desactivate a foreign key without
losing any data in SQL for MySQL 3.23.51 ?
Hello JeanClaude,
Unfortunately, foreign keys cannot currently be conveniently dropped.
:( The InnoDB
In the last episode (Jan 30), Maximo Migliari said:
Note that for the name field, the characters ç, í, â, are all appearing
correctly.
Now when I select this information from PHP and print it as a webpage, this
is what I get:
? instead of â,
¡ instead of í
? instead of ç
What's
Mary,
The Production server has MYSQL 3.23 and an older version of MYODBC
then I
have.
They run in 8 minutes on my test server , about 4 minutes each.
Printing to
a PDF driver.
On the Production Server they take HOURS to run and print.
Maybe this won't help too much, but I've experienced
On Thu, Jan 30, 2003 at 11:40:06AM -0500, Anna Noel Leavitt wrote:
Hello all-
I am using MySql, php and forms in HTML to update information. When I
select results from column type VARCHAR, if the information stored
in the column has a space in it (for example, Tampa Bay), it will only
The problem is probably in either your PHP or HTML, not MySQL. It is common
to store mutliple words separated by a whitespace in varchar and text
fields.
-Original Message-
From: Anna Noel Leavitt [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 30, 2003 8:40 AM
To: [EMAIL PROTECTED]
On Thu, Jan 30, 2003 at 10:46:27PM +0530, [EMAIL PROTECTED] wrote:
Hi Group,
I want to start my mysql with max_connections option. Now I am getting To
many connction error. So I want to allow 200 concurrent connections...
I tried with
safe_mysqld max_connections=200
But it is not coming
At 1:26 -0700 1/30/03, Mike Walth wrote:
Has anyone done any work with getting images into and out of a MYSQL
database? I have used mysql for some time, but never stored an image in a
blob field. I am curious on how to insert the image from a web form upload,
and how to display the picture on
I'm 97.5% sure this will turn out to be a HTML form issue. You
probably echo the field without quotes like this
input type=text name=some_name value=Tampa Bay /
instead of
input type=text name=some_name value=Tampa Bay /
-steve
At 11:40 AM -0500 1/30/03, Anna Noel Leavitt wrote:
Hello
: Has anyone done any work with getting images into and out of a MYSQL
: database? I have used mysql for some time, but never
: stored an image
: in a
: blob field. I am curious on how to insert the image from a web form
: upload,
: and how to display the picture
Hello-
I am in the early stages of setting up a website running mysql. The idea is
for the user to be able to compare insurance policies and choose the best
one. I want to give them the option of choosing several insurance plans and
compare them side by side. My question is would it be
PHP works fine to update a mysql database on the
server.
But I would like to access a device connected to the
serial
port or a USB port on the client computer through an
applet and store this information in the database on
the
server.
I have tried to find an example of such a transaction
on
the
I think flush logs should do it.
http://www.mysql.com/doc/en/FLUSH.html
Bhavin.
- Original Message -
From: Matthias Trevarthan [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 2:31 PM
Subject: FreeBSD bin-log rotation script
Howdy list,
Does anyone have a
From postings at:
http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html
ALTER TABLE tbl_name AUTO_INCREMENT = 1000
will start your records at 1000
Bhavin.
- Original Message -
From: Mike Doanh Tran [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 2:15 PM
is there any simple ways to interface python with
mysql if yes tell me the details how do we do it in
windows and linux
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
Hallo list,
this might sound ridiculous. But, because my computer is dual booting
Linux/Windows, I'm looking for ways to put the datasource in windows D:\
or vfat, so that the data can be shared mutually by the two OS. But
until now I still cannot do that.
I have tried to:
- change the owner
Am Donnerstag, 30. Januar 2003 20:15 schrieb Mike Doanh Tran:
Hi all,
I am creating a new table with an auto_increment primary key.
How do i tell mysql to start incrementing at a certain value, let say
1000 instead of 1?
Thanks,
MT
SET INSERT_ID=1000 does it.
Have a look at
Hello Zak,
Thanks for your response.
I try the way you told me, but it seems there is
another problem :
The old foreign keys always exist.
In consequence, there are double references.
How can i resolve that problem ?
Thanks in advance.
JeanClaude
-Message d'origine-
De : Zak Greant
Hi
When creating a table can you use multiple Table_Options?
The O'Reilly Managing Using MySQL show on page 288 a table been created
with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB;
But the MySQL manual says or:-
table_options:
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE |
Hi All
Is it possible to mix javascript and PHP in the same script??
I have a number of web based apps written in PHP/MySql and while they
are functionally pretty good they are aesthetically garbage. I'll like
to pretty up the interfaces with rollovers etc, but haven't got time to
learn JS
any further news about 4.1 binaries release date?
TIA
(mysql, sql)
__
Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino
http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html
Hi,
You should not use mysqlimport but mysql:
mysql my_db file.sql
See http://www.mysql.com/doc/en/mysqldump.html
for details.
Regards,
Joseph Bueno
Elby Vaz wrote:
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport?
Hi there,
Can someone point me to amn (exhaustive) list of features in MySQL Max that
are not present in MySQL Standard? Or any other documentation that lists
the differences between the two?
Thanks in advance,
Vikram
--
Luke: I don't believe it!
Yoda: That, is why you fail.
Elby,
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport?
mysqlimport ??
You do this with mysql in batch mode, not with mysqldump:
shell mysql your_database file.sql
Regards,
--
Donal
With MySQL, temp_explanations MUST exist before you can INSERT INTO it.
Based on the assumption that temp_explanations is non-existent, you will
have to CREATE TABLE temp_explanations first before running an INSERT
INTO.
Hope that helps.
Inyang
Hello,
I want to do the following query
Hi
When creating a table can you use multiple Table_Options?
The O'Reilly Managing Using MySQL show on page 288 a table been created
with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB;
But the MySQL manual says or:-
table_options:
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE |
You can add the entry to my.cnf:
[mysqld]
set-variable= max_connections=200
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: How can I start my mysql server with max_connections option
Date: Thu, 30 Jan 2003 22:46:27 +0530 (IST)
Hi Group,
I want to start my mysql with
Hello
I use Microsoft Visual Studio (not Dev-C++) to connect to mySQL using ADO.
That works fine. If you are programming on the Microsoft Windows platform,
you could try using ADO for your connection object (ADODB.Connection).
Inyang
Everytime I try to compile with the MySql.h or any other
Hi,
I was already questioning my sanity, but the problem below is
reproduceable:
This is how my table looks:
mysql describe T_ORDH;
--+--+-+++
Field |Type |Null |Key |Default |Extra
The fastest way would be to use C.
But the reason for using a DB would be.
1. Access to data. You could use PhPMyAdmin or some thing you put together
to update the policy so making managing the data easy (possibly so non
tickers should make changes).
2. If the data you are getting needs to be
Hi there, I have a little question for you in the mysql community..
I was wondering how persons in this community handles changes to the
database when your application that uses the database needs some new
tables, columns, etc...
Do you have an application with a sort of upgrade functionallity
Is there any way to partition MyISAM tables in mysql? i have a huge
table and want to partition it.
Do InnoDB tables support partitioning?
thanks.
Prasanth
-
Before posting, please check:
http://www.mysql.com/manual.php
Have used many databases but am just getting into MySQL and am totally rapt
about it :) I am writing a front end in realBasic that needs to be able to
run on various backends, MySQL being the main one. All of the others have a
boolean type of column. What is the general practice to mimic¹ a
How i list connected users(active) to mysql server?
it is important to know connected users for me?
Mysql runs in server-client system, and each host of clients are different
(i assume)
Mustafa Yelmer
Software Engineer
+90 212 2128200-1228
[EMAIL PROTECTED]
So, my dear friends, could we conclude that Linux is a more appropriate
platform for running MySQL
on a multi-processed machine?
I was desperate to try and compile MySQL 4.0.9-gamma on my FreeBSD
4.7-stable machine, which is
dual processed. I managed to compile fine once, but it gave errors
hi list,
getting this with mysql-3.23.55 on 2 machines (on other it compiled):
make all-am
make[3]: Entering directory `/usr/src/mysql-3.23.55/include'
make[3]: Nothing to be done for `all-am'.
make[3]: Leaving directory `/usr/src/mysql-3.23.55/include'
make[2]: Leaving directory
* Keith C. Ivey
[...]
Jonas said the tables had 25 floats in each record, so the added
integer ID and deletion flag would only occur 1/25 as often. There
You are probably right. I focused on the 1 value/minute are stored part,
and wondered why he would store a float for each field in a
Hi all,
I get this error when compiling MySQL 4.0.9-gamma on Windows
.\debug\Strings.obj
LINK : fatal error LNK1181: cannot open input file .\debug\Strings.obj
Error executing link.exe.
Am using VC++ 6.0
Any help you can offer would be appreciated. Thanks!
Vikram
dell 4100 256mb, 11gb hd, Redhat 8.0 grub-linux
linux novice cannot resolve apache-php-mysql linkage 3.
local closed system (No modem, no www access, no internet)
big snip
see linux novice cannot resolve apache-php-mysql linkage 2.
for lengthy details
I've installed RH at least 20 times, and
On Thu, Jan 30, 2003 at 09:48:16PM -0800, vishnu mahendra wrote:
is there any simple ways to interface python with
mysql if yes tell me the details how do we do it in
windows and linux
I never used Python, but this is very easy to find:
http://www.python.org/
Thanks for the tip about the 14 columns, Sergei and Dan. I reduced the
number of columns by two and the index seemed to build just fine. I would
like to make a suggestion though. I originally tried to create the fulltext
index with more than 16 columns and received an error saying that I could
How can I create different user accounts for a table?. (I've just installed
the MySQL, and the root just don't have a password yet..how can assign one?
Thxs in advance,
Alex
-
Before posting, please check:
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT b.id, p.part_code, p.product_type, p.description, po1.options,
b.price, b.quantity, b.price*b.quantity AS total
FROM (products AS p LEFT JOIN
You don't.
you use the file as input to the mysql client.
mysql file.sql
Elby Vaz wrote:
I created a file.sql with mysqldump.
mysqldump my_db my_table file.sql
What I do to get this file with the mysqlimport?
mysqlimport ??
Thanks,
e.
If your application is opening one database, and then updating
medic.sometable, the update will not be recorded in the bin file.
sam wrote:
I am trying to use replication with 4.0.9.
Changes to the datbase are not being recorded in
the bin file on the master for a DB called Medic
when
thanks. we are doing the data load today and will upgrade the MYODBC to
3.51 before we do it. This will be a good test as the load takes 6 hours
on the current version.
Mary Stickney
TAG-TMI
Data Warehouse Programmer
402-474-7612 x 3099
[EMAIL PROTECTED]
-Original Message-
From:
Hi Maximo,
Try this: add this to your HTML document
meta http-equiv=Content-Type content=text/html;
charset=iso-8859-1
Hope it helps
Ken
- Original Message -
From: Maximo Migliari [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003 11:19 AM
Subject: Character
JD,
my answer may seem ridiculous, too, but with the following setup you
should be able to use MySQL databases and tables both under Linux and
Windows on the same machine.
About the only thing you need is access to the MySQL data directory from
both Linux and Windows. Regardless of the operating
Hi, I have been using autoincrement fields for some
time but was wondering how does it work in some
special situations.
Ex. suppose I have an autoincrement field called num
and the last one has value of 10.
I delete the last on and insert a new one. Which
value will it have ? 10 or 11
I read
Hello,
For windows check out Python from:
www.ActiveState.com
It comes with some nice additions.
Also check out the Python Mysql interface (v2.xx) api.
www.python.org/topics/database/
For windows the Rekall front end (Access like and an
alternative to php) looks promising.
www.thekompany.com
Jonathan,
The O'Reilly Managing Using MySQL show on page 288 a table been
created
with two options ...)AUTO_INCREMENT = 1, TYPE=InnoDB;
But the MySQL manual says or:-
table_options:
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
or AUTO_INCREMENT = #
Oh, I stumbled
: Am Donnerstag, 30. Januar 2003 20:15 schrieb Mike Doanh Tran:
: Hi all,
:
: I am creating a new table with an auto_increment primary key.
: How do i tell mysql to start incrementing at a certain
: value, let say
: 1000 instead of 1?
:
: Thanks,
:
Steve,
this list is not the right place to ask JavaScript questions. Please
check out an appropriate list at http://php.net/.
But, anyway, it's possible to mix JS and PHP, no problem.
Regards,
--
Stefan Hinz [EMAIL PROTECTED]
Geschäftsführer / CEO iConnect GmbH http://iConnect.de
Hi All
Is it possible to mix javascript and PHP in the same script??
Client-side Javascript can be sent to the user along with your html.
For Example:
echo (HTMLHEAD\n);
echo (SCRIPT TYPE=\text/javascript\\n);
echo (!--\n;
echo (function hello() {\n);
echo ( alert('Hi');\n);
echo (}\n);
Hi Steve,
Yes, it is possible to mix PHP and JavaScript, for example:
var givemeaphpvalue = ?php echo $phpvalue; ?;
I use PHP and Javascript together quite often.
Regards,
Kevin
- Original Message -
From: Steve Davies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 31,
Hi Steve,
You can definitely mix javascript and PHP in the same script so long as
you follow the correct syntax for each language.There is no way out here
really...if you want to include javascript in your scripts then you have
to learn it:-) unless you want to hire someone to do it for you...
Is it possible to mix javascript and PHP in the same script??
Yes it is, but you have to remember that PHP is server side and Javascript
is Client side.
I have a number of web based apps written in PHP/MySql and while they
are functionally pretty good they are aesthetically garbage. I'll like
You might find this helpful - I did.
http://www.phpbuilder.com/columns/florian19991014.php3
Has anyone done any work with getting images into and out of a MYSQL
database? I have used mysql for some time, but never
stored an image
in a
blob field.
Absoulutely.
Since PHP is server-side you can write javascript dynamically on the fly
which are then executed client-side.
Here's a simple example:
!-- yourpage.php--
script language=Javascript
var today = '?php echo date(Y-m-d, time()); ?';
/script
-Original Message-
From: Steve
I am trying to get a count of Distinct IP's from my homemade hit-log
database (don't ask). The db is MySQL. I'm trying this:
SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp),
DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN
'2003013000' AND '2003013100') GROUP BY
Hi All,
Can anyone help me get this query working in MySQL, this was created using
Access, but it doesn't port well for MySQL syntax:
SELECT basket.id,
products.part_code,
products.product_type,
products.description,
product_options_1.options,
basket.price, basket.quantity,
Also, this might help to solve the problem, this is a graphical schema of
the query from MS Access, to give you all a better idea of what I'm trying
to accomplish...
http://www.netsmith.ltd.uk/example.gif
- Original Message -
From: Kevin Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
At 21:48 -0800 1/30/03, vishnu mahendra wrote:
is there any simple ways to interface python with
mysql if yes tell me the details how do we do it in
windows and linux
Yes.
You can find an article describing how to do it at:
http://www.kitebird.com/articles/
You can find a bunch of scripts
Steve:
On Fri, 31 Jan 2003 08:27:11 +, Steve Davies wrote:
Is it possible to mix javascript and PHP in the same script??
Certainly. Exactly as HTML and PHP are intermingled in a document.
I have a number of web based apps written in PHP/MySql and while they
are functionally pretty
Vikram,
Can someone point me to amn (exhaustive) list of features in MySQL Max
that
are not present in MySQL Standard? Or any other documentation that
lists
the differences between the two?
http://www.mysql.com/products/mysql/index.html (not too exhaustive,
though)
Regards,
--
Stefan Hinz
* vishnu mahendra
is there any simple ways to interface python with mysql
URL: http://sourceforge.net/projects/mysql-python
if yes tell me the details how do we do it in
windows and linux
You will find instructions on the sourceforge site.
A small demo, low level API:
import _mysql
c =
Hi,
From a web form I am collecting information to a table. On the form there is
a textarea element storing to a text field on the mysql table. Since the
textarea can hold the enter key, it's stored in to the field also, but when
i try to call that cell and display it on the web page, i see that
Description:
For some reason the numeric fields in the middle ('sessionfid', 'ipfid') are not
putting values in there even though
it says it went through fine.
mysql DESC phpss_log;
++--+---+--+-+-++
| Field
You van use the LOAD DATA INFILE statement
Check this
http://www.mysql.com/doc/en/LOAD_DATA.html
for more information
HTH
Dobromir Velev
[EMAIL PROTECTED]
www.websitepulse.com
- Original Message -
From: Andrew [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 30, 2003
I was trying to install mysql on a mac g4 following the instructions
provided by the followin link
http://www.mysql.com/doc/en/Quick_install.html
but when I got to the make command I got the following error:
[localhost:~/mysql-4.0.4-beta] erix% make
make: Command not found.
I also found out
I've had a look through the archives and cannot see a solution to this.
I am wondering if there is a nicer way to do the following.
I have a table where one of the columns contains a time period for an
activity that I am logging. I need to grab the 95th percentile, when
ordered by duration. I
Of course. Javascript is a client side scripting language and is run in
the users browser, whereas PHP is run on the server. The javascript is
just text to the PHP parser, like HTML.
Javascript will allow you to do dynamic stuff, but if you are looking
for aesthetics you would be better off
Hi all,
my problem is the following, it's possible to insert an image in a table
with the libmysqlclient ?
My language is C
i'm working with GNU/Linux
Best Regards,
Stephane Wirtel
-
Before posting, please check:
Timestamp columns update automatically.
http://www.mysql.com/doc/en/DATETIME.html
Peter
^_^
-Original Message-
From: Marco Deppe [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 31, 2003 6:18 AM
To: [EMAIL PROTECTED]
Subject: TIMESTAMP field is updated unintentionally
Hi,
PHP is server side, javascript is client side, they do not interact with
each other. PHP gets parsed by on the server before the page is rendered,
javascript is interpreted by the browser. You can either have PHP generate
the javascript or just put it in the page. Rollovers have nothing to do
- Original Message -
From: Steve Davies [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 31, 2003 3:27 AM
Subject: MySql, PHP and Javascript
Hi All
Is it possible to mix javascript and PHP in the same script??
Short answer: Yes :)
Longer explanation:
Javascript is
At 13:40 -0800 1/30/03, R. Hannes Niedner wrote:
If I create a FULLTEXT index for 2 or more columns in a table will I be able
to use it for a MATCH only against a single column (of the above) or do I
have to create additional FULLTEXT indices for each of these columns?
The latter. When you use
Hi,
It is a feature, the first TIMESTAMP field is automatically
updated each time you update the record. Check the manual
for details:
http://www.mysql.com/doc/en/DATETIME.html
If you want mysql to automatically set it at creation time only,
your workaround is OK.
You can also convert
77 matches
Mail list logo