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 cienu,
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).
http://dev.mysql.com/do
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 Order.id_order=ItemsO
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
>
> -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_insta
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 th
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
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 o
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 my
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 Warn
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
SQLClient
>
> 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
SEL
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
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?
---
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
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 pro
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. Afforda
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 o
IL PROTECTED]>
Sent: 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
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
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 pa
" mysqladmin: connect to server 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.soc
nnect 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
=
E . K . A
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 o
I create a connection with Java and mm.mysql-1.0.
I 'm running and this the complier messages :
SQLException: General error: Access denied for user: '@localhost' to database 'link'
SQLState: S1000
VendorError: 1044
java.lang.NullPointerException
at conectiondb.ConnectionDB.(ConnectionDB.jav
26 matches
Mail list logo