Does MySQL 4.0 allow mixing of character sets in a database?
I'd like a table which lists the locale string for a particular
phrase in multiple languages. I have it working in french, english, german
etc in MySQL 3.23 but I needed a seperate instance of mysql installed for
the russian database to
Hi !!
I just installed MySQL CC, in localhost it works fine. But I cant
connect it with my remote MySQL database (server).
The mistake may be that im not sure in the HOST field, please someone
helpme.
Thanks
Javier (from Buenos Aires)
P.S. Sorry for my terrible english.
Dear my friends
I am trying to read the content per line of a query
result with mysql_fetch_row. But I got this error
message :
Musingin homepage
koneksi sukses. Sukses memilih database. Sukses
melakukan query. Besar hasil query 1.
Warning: mysql_fetch_row(): supplied argument is
I recently installed MySQL 4.0.12 on Mac OS X (using the package
provided in the downloads section) and I must have corrupted something
because I can't get the mysql command to work. I thought the easiest
thing to do would be to uninstall the whole thing and start over, but I
can't figure out
Hi,
On Sun, Mar 30, 2003 at 05:39:13AM -0800, Prabu Subroto wrote:
Dear my friends
I am trying to read the content per line of a query
result with mysql_fetch_row. But I got this error
message :
Musingin homepage
koneksi sukses. Sukses memilih database. Sukses
melakukan
On 30-Mar-2003 Prabu Subroto wrote:
Dear my friends
I am trying to read the content per line of a query
result with mysql_fetch_row. But I got this error
message :
snip
$konek=mysql_connect(localhost, prabu,
password)
or die(Connect problem: . mysql_error());
snip
On Sun, 30 Mar 2003 05:39:13 -0800 (PST), Prabu Subroto
[EMAIL PROTECTED] wrote:
Warning: mysql_fetch_row(): supplied argument is not a
valid MySQL result resource
That is a very common error message. It usually means that your query
doesn't return what you had intended it to. When I get this
Dear Fred...
It is solved. Thank you very much, my friend.
--- Fred van Engen [EMAIL PROTECTED] wrote:
Hi,
On Sun, Mar 30, 2003 at 05:39:13AM -0800, Prabu
Subroto wrote:
Dear my friends
I am trying to read the content per line of a
query
result with mysql_fetch_row. But I got
# [EMAIL PROTECTED] / 2003-03-28 21:47:28 -0500:
I'm experienced with SQL, but new to MySql and PHP, which I'm using
together to create a dynamic web site. Right now, I'm having minor
difficulties with date formatting. It seems that when I retrieve a date
from MySQL into PHP, it shows up
# [EMAIL PROTECTED] / 2003-03-29 21:52:18 -0500:
I just downloaded and installed the mysql-max-4.0.12.pkg, ran
cd /usr/local/mysql
sudo ./bin/mysqld_safe
(Enter your password)
(Press CTRL+Z)
(Press CTRL+D to exit the shell)
bg
as specified in the readme. When attempting to
This is not a MySQL question.
http://www.php.net/manual/en/function.explode.php (probably)
visit: http://www.php.net/links.php for tutorials on PHP.
If you can control the layout of the database you could use another type of
column. See the MySQL manual for more information.
B.
At 21:47
I've got MySQL-Max (4.0.1) installed and running. I've run the script
from the mysql.com site to generate the keys.
When I do a show variables LIKE have%, have_openssl=NO. How can I
set have_openssl = YES? I'm assuming that this will then enable SSL,
right?
Also when I use the my.cnf that
Hello, I was starting a php/mysql project in december and seeked for help on
this mailing list, it has been a great help for solving problems.
My application is a website where you can order meals from restaurants that
are within your postcode area (UK only)
The database structure has grown up to
# [EMAIL PROTECTED] / 2003-03-30 17:49:27 +0200:
Hello, I was starting a php/mysql project in december and seeked for help on
this mailing list, it has been a great help for solving problems.
My application is a website where you can order meals from restaurants that
are within your postcode
Damien,
1. If a column is a primary key, there is no need to declare it a unique.
2. Without foreign keys, your CREATE statements don't reveal table
relationships.
3. The best way I know to validate a schema is to (i) write or draw all the
application's use cases, (ii) from the use cases derive
Hi,
I can only find Windows software for modelling of Entity Relationship
Diagrams.
Surely, there have to be someone out there that have made a general
Java app dealing with this and with MySQL support? Does anyone know?
Michael
Helloworld Media
Box 13085, 103 02 Stockholm, Sweden
Visitors:
ArgUML (http://argouml.tigris.org/) is an open-source UML modeller written
in Java, but you will have to code the DDL generator yourself. The
commericial spinoff of ArgoUML is Poseidon, but the Poseidon folks told me
last week that they have no plans to write a DDL generator.
PB
-
-
Attempting to compile the 4.1 mysql library I encounter a missing function:
ret = select(0, NULL, NULL, NULL, t) == -1 ?
__os_get_errno() : 0;
called from os_sleep()
Where is this function?
Thank You,
Martin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
That does it! Thanks much.
Jim
On Saturday, March 29, 2003, at 06:14 PM, Bruce Feist wrote:
Jim Miller wrote:
I want to do a join and select of these tables that will give me all
the Entrants who did NOT enter contest 1 (i.e., Mary and Bill).
Try:
select entrant.name
from entrant
In the windows distribution within the example mytest.c
there is a a call to pszT = mysql_stat( myData ) ;
which produces this error
myTest.obj : error LNK2001: unresolved external symbol [EMAIL PROTECTED]
Where is the mysql_stat function located?
Thank You,
Martin
- Original Message -
Title: ODBC performance vs
Howdy,
While I've had a bit of experience with proprietary database systems, I'm quite new to ODBC with which I'm prototyping a replacement configuration database for my employer. The query performance of ODBC seems to leave a lot to be desired and a
Hi Bruce,
Try looking at php's date function
(http://www.php.net/manual/en/function.date.php). That function allows
you to format a date variable however you need it to. And to convert
mySQL's returned string into a date php can use, try the strtotime
function
Description:
The docs seem to be wrong.
Although openssl x509 -text -in mycert.pem write e.g. the Subject
as C=DE, ST=NRW, L=Aachen..., MySQL needs the format that is used
e openssl x509 -in mycert -subject: /C=DE/ST=NRW/L=Aachen
How-To-Repeat:
Just try
I need some assistance. I have a support system set up where people
can search for various things using a fulltext index. The problem
that I am having, though, is that I cannot seem to figure out how to
get search results from values like 10.2.4 or 6.0.4. This is with
MySQL 4.0.12, with the
It is solved. Thanks Don.
--- Don Read [EMAIL PROTECTED] wrote:
On 30-Mar-2003 Prabu Subroto wrote:
Dear my friends
I am trying to read the content per line of a
query
result with mysql_fetch_row. But I got this
error
message :
snip
$konek=mysql_connect(localhost,
Dear Fred.
Your explanation is very complete. Thank you very much
for your generousity.
My problem has been solved, Thank you.
--- Fred van Engen [EMAIL PROTECTED] wrote:
Hi,
On Sun, Mar 30, 2003 at 05:39:13AM -0800, Prabu
Subroto wrote:
Dear my friends
I am trying to read the
After removing every directory I could find related to MySQL, I used
the OS X Package Installer to re-install MySQL.
But I get the following error when I follow the instructions to start
mysql (from the logfile):
030330 16:22:20 mysqld started
030330 16:22:21 InnoDB: Operating system error
In my SELECT statement below, I am having problems
figuring out what I should be putting in place of the
second to last LEFT JOIN join. It's the one that
reads:
LEFT JOIN DomesticAddresses AS DomADD
I want to LEFT JOIN the columns DomesticAddresses
and DomAdd to the column
thanks heaps that works abosultely fine
-Original Message-
From: Don Read [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 6:00 PM
To: Daniel Rossi
Cc: [EMAIL PROTECTED]
Subject: RE: get table name from select staement as output as field
On 30-Mar-2003 Daniel Rossi wrote:
hi
Hi, I'm a newbie to MySQL, and I'm wondering whether there is any way to
set validations on acceptable field values when using the 'create
table()' etc. statements? I've performed a (most cursory) search of the
documentation, but that didn't turn up anything useful. Any suggestions?
Many
I was just receiving that error this morning after I changed my hostname
and my mysql server wasn't starting properly. Once I got the server
started, the error went away.
So, I believe that just means that your server's not running or
accepting connections.
But, that's just a guess.
Mark
Original Message
Subject: Foreign key ... ON UPDATE CASEADE
Date: Thu, 27 Mar 2003 12:08:34 +1100
From: vinita Vigine Murugiah [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Hello
I have been use mysql ver 3.23.53, also I'm using on DELETE CASECADE. It
seems working fine.
I
I am trying to do one of two things.
First I'd rather do this, but if not possible, then the other way that
I'll describe will suffice.
1) I need to have a default value of a column named invoice_id be this:
Column names of importance:
idinvoice_id
id is auto_increment and BIGINT unsigned.
Hi Bruce,
I gather that PHP can treat any data as a string and will do by
default, unless you try and do something to the data that suggests
it is not a string. ie, you can return a result '23' from a
database and find the first character of it, as if it were a
string, but you can also then add
First option, I don't think, is possible.
Reg. 2, You can get MAX(Id) before inserting, increment it by 1 in your
script and then Insert 'gcId' as the invoice_id value.
Bhavin.
- Original Message -
From: MySQL List [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 7:23
I don't think Validation is possible. Look up ENUM, which is very different,
but just might help you a little.
- Original Message -
From: warm-fusion [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 5:25 PM
Subject: Validations
Hi, I'm a newbie to MySQL, and I'm
As Bhavin stated, ENUM is one way to do this, but you can (and should)
validate all data in your scripts prior to entering it in your database.
(assuming that you're not just using the command-line interface and have an
actual GUI)
All user-supplied information should be checked for validity -
Hi, I'm a newbie to MySQL
I have use mysqldump to backup a database to an file named test.sql ,but how I
can load the test.sql to create the same database to another server??
Thanks!
Best Regards
Li Yang
Does anyone else get this message after installing and attempting to run
mysql (version 4.0.12)??
I downloaded and installed mysql-4.0.12-win.zip file.
then from the command prompt, I typed mysqld to start the service. Then I
typed mysql and I got the error message:
Cant connect to Mysql server
Edit the script created by mysqldump. Add
create database if not exists databaseName;
to the beginning of the script.
Or what I usually do is create the database first then use:
mysql -A databaseName test.sql
to load it.
=C=
* Cal Evans
* http://www.christianperformer.com
* Stay plugged
Could anyone please let me know how to set the min word lenght to 3 for
Free Text search, I am using PHP.
Ben
Regards,
Ben
* Ben Edwards +44 (0)117 968 2602 *
* Critical Site Builder
Could anyone please let me know how to set the min word lenght to 3
for Free Text search, I am using PHP.
Ben
Regards,
Ben
Check out this message:
http://www.listsearch.com/mysql.lasso?id=287087
Adam.
---
Adam Randall
I am looking for any type of documentation on using Crystal Reports with
MySQL. I have connected to mysqld from CR but when it shows the
selected database, there are no tables listed. Is there something I
have to configure in the MyODBC driver? Please help me out with any
advice you may have.
Nevermind I got it
$next_number = $dbh-selectrow_array(qq{ SELECT MAX(id) FROM
whatever_table });
Richard.
- Original Message -
From: MySQL List [EMAIL PROTECTED]
To: Bhavin Vyas [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, March 30, 2003 9:44 PM
Subject: Re: Help With Default
woah let me get it straight , u are compiling on a RH 6 machine to be installed on a
RH 7 ? why not compile and install on the same machine , i really cant say if it
makesd a difference but they do have different kernels and are years apart , i've had
no trouble whatsoever compiling and
Hello, Heikki!
In my last suggestion, you replied :
Jungsu, Jeremy,
it can be considered as a bug that MySQL/InnoDB does not replicate the
setting
SET FOREIGN_KEY_CHECKS=0
I am working on fixing this bug in 4.0.x.
(I suggested it MySQL 4.0.11.)
but, set foreign_key_checks=0 still does not
u can use highly customizabe MySQL DATE_FORMAT() function for retrieving
date in desired format. Relevant portion from manual is reprodcued below
inside quotes.
For manipulating date in php, u can use the MySQL UNIX_TIMESTAMP(date)
function to return unix timestamp of the date and use the php
what do you mean by row number? afaik, in RDBMS primary key is the
identifier for a particular row.
u hv to use the primary key of the row in the where clause...
SELECT * FROM table WHERE primary_key_column=primary key of the row to
retrieve
regds,
-Original Message-
From: Marc Bakker
I'm learning the ropes with MySQL. I've got it installed on a WinME
system, and one of the first things I've noticed is that it doesn't
seem to care about users. Is that correct? In particular, I've tried
out the GRANT command to create a new user, but MySQL doesn't seem
to recognize the new
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sat, 29 Mar 2003, Ken Tozier wrote:
I just downloaded and installed the mysql-max-4.0.12.pkg, ran
cd /usr/local/mysql
sudo ./bin/mysqld_safe
(Enter your password)
(Press CTRL+Z)
(Press CTRL+D to exit the shell)
bg
Ugh,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Sun, 30 Mar 2003, Todd O'Bryan wrote:
I recently installed MySQL 4.0.12 on Mac OS X (using the package
provided in the downloads section) and I must have corrupted something
because I can't get the mysql command to work. I thought the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sun, 30 Mar 2003, Todd O'Bryan wrote:
After some research, I was clever (?!) enough to chown all the files and
directories in the mysql directory so that mysql is now the owner.
It should be enough to chown the data directory to mysql.
030330
52 matches
Mail list logo