Hello.
The start point for you in such kind of problems should be researching
the output of the following statement:
SHOW VARIABLES LIKE '%char%';
Please, run it from different environments (PHP, MySQL Query Browser),
and send results to the list. Include the CREATE statement for you
Hellou!
I have MySQL(charset is utf-8) + PHP 5.0.5. Latvian symbols(auczsnsczikl) not
correctly viewed in MySQL Query Browser, but in 'phpmyadmin' its ok. When i use
php to viewed data with latvian symbols in IE, then latvian symbols(aui.)
is converted to ? symbols.
Please Help!
Ar
Hi,
I need to make relationishp between 4 tables in my system.
I just don´t know how to make.
Somebody could help me, please?
The tables are: Order, Employee, ItensOrder and Unit.
My objective: to program a report of Order that appears in the screen the fields (
id_order, name_employee
The attachment describing your tables didn't come through. However,
here's roughly how your SELECT statement might look:
SELECT Order.id_order, Employee.name_employee,
ItemsOrder.date_order, Unit.name_unit, ItemsOrder.status_order
FROM Order, Employee, ItemsOrder, Unit
WHERE
I prefer to explicitly declare my INNER JOINs (not to imply them by using
commas to make a list of tables). That way I avoid accidentally creating
any Cartesian products of any tables by leaving out a WHERE condition.
Missing ON conditions are much easier to spot (IMHO).
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the
error again. Please again!!!
On Thu, 18 Dec 2003, Chris Elsworth wrote:
On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote:
031217 14:32:34 Warning: setrlimit couldn't increase number of
You must be 'root' to do a ulimit -n 1024.
Marc.
-Message d'origine-
De : Carlos André Moura de Amorim [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 19 décembre 2003 14:55
À : Chris Elsworth
Cc : [EMAIL PROTECTED]
Objet : Re: Help me - please
i added ulimit -n 1024 in mysql_install_db
what distro are you using? what is running on this server? another
server is runnin' on the same machine? what hardware are you using? is
it heavy loaded?
On Fri, 2003-12-19 at 09:54, Carlos Andr Moura de Amorim wrote:
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the
de Amorim [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 19 décembre 2003 14:55
À : Chris Elsworth
Cc : [EMAIL PROTECTED]
Objet : Re: Help me - please
i added ulimit -n 1024 in mysql_install_db, i can't to install. Appear the
error again. Please again!!!
On Thu, 18 Dec 2003, Chris
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
Installing all prepared tables
031217 14:32:34 Warning: setrlimit couldn't increase number of open files
to more than 256 (request: 510)
031217 14:32:34
On Thu, Dec 18, 2003 at 05:28:30PM -0200, Carlos Andr? Moura de Amorim wrote:
031217 14:32:34 Warning: setrlimit couldn't increase number of open files
to more than 256 (request: 510)
It might be worth putting a ulimit -n 1024 (or some other decent
number) in the rc.d script that starts
Hi every one :
i'm trying to make a db program using Mysql cbuilder6 .
on my table a have fields named patient_Id .
its an auto_increment value but i got problem .
the problem is when i try to get the value of that fields i got nothing just
0 although i execute the commands
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful.
select * from your_table order by no desc limit 0,1
-Original Message-
From: mustakim abas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 12:07 PM
To: [EMAIL PROTECTED]
Subject: help me, please
Hello, i am new in mysql. I got a problem. I try write
my C program
On Thu, 19 Dec 2002, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Provided I understand your question, then I would
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Bigger than what?
Select max(No) from table
Marcos Henke
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: mustakim abas [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 1:51 PM
Subject: Re: help me, please
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new
At 8:06 -0800 12/19/02, mustakim abas wrote:
Hello, i am new in mysql. I got a problem. I try write
my C program with mysql API.I have 5 field in
table.No,Name,Phone,Date,Time. How can i take one row
where the No is bigger?
Thanks for help.
Bigger than what?
Maybe
SELECT No, Name,
Bas,
Thursday, July 04, 2002, 9:43:07 PM, you wrote:
BM When I start mysqlgui on my mandrake 8.2 machine the program starts, but
BM I get an error message:
BM Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2)
BM I don't know what to do and I cannot acces the help file or
When I start mysqlgui on my mandrake 8.2 machine the program starts, but
I get an error message:
Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2)
I don't know what to do and I cannot acces the help file or find
documentation on MySQLserver.
Please tell me how I can solve
: Thursday, July 04, 2002 11:43 AM
Subject: help me please with mysqlgui
When I start mysqlgui on my mandrake 8.2 machine the program starts, but
I get an error message:
Can't connect to local MySQL server through socket'/tmp/mysql.sock'(2)
I don't know what to do and I cannot acces the help file
hi
i was just wondering.is it posible to manipulate flat
file databases with My SQL?.if it is..where can i get
more info on this?. i really don't have any idea how
to use MySQL with flat file databases. thanks.
__
Do You Yahoo!?
Yahoo! - Official
socket '/var/run/mysqld/mysqld.sock' (111)'
Check that mysqld is running and that the socket:
'/var/run/mysqld/mysqld.sock' exists!
If you know what's the problem, help me please
thank u
=
E . K . A
___
Do You Yahoo!? -- Pour faire
at 'localhost' failed
error: 'Can't connect to local MySQL server through
socket '/var/run/mysqld/mysqld.sock' (111)'
Check that mysqld is running and that the socket:
'/var/run/mysqld/mysqld.sock' exists!
If you know what's the problem, help me please
thank u
Well, the error message
I use mysql-jdbc-java.
I connect java with my database and I've this message :
DBLocationHandler: Figuring out the locations and names! (This is a one-time
operation!)
*** ERROR ***
DBLocationHandler:SQL Exception: Column Index out of range
*
java.sql.SQLException: Column Index
25 matches
Mail list logo