Hello list:
I have a php website which uses utf-8 encoding. But
recently the shared hosting company has upgraded mySQL
to 4.1.13 and now all varchars are shown incorrectly (
all collation attribute are set as latin_swidish_ci
now" ).. the phpMyAdmin verson is 2.6.4-pl2. my site
is at http://www.cn
mos a écrit :
> This should be so simple, yet I've struck out.
>
> I have 2 tables, each with a common column called "pid" which is an
> integer and is a unique index. There are approx 18 million rows in each
> table, and one of the tables has approx 5000 fewer rows than the other
> table. So it s
add a user in the table for your remote hostname or ip number.
On 12/31/05, Jon Miller <[EMAIL PROTECTED]> wrote:
>
> I'm trying to initialize to a database on another server from a mail
> server. I can telnet to it but cannot initialize the database.
> The account and user exists in the database
I'm trying to initialize to a database on another server from a mail server. I
can telnet to it but cannot initialize the database.
The account and user exists in the database and the paasword as I've tried it
from the mysql server.
Is there another test I can do to find out exactly what is caus
I'm trying to initialize to a database on another server from a mail server. I
can telnet to it but cannot initialize the database.
The account and user exists in the database and the paasword as I've tried it
from the mysql server.
Is there another test I can do to find out exactly what is caus
I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest
why MySQL Adminstrator says the table has 497 rows, while doing a query or
a count on the same table shows that it only has 434?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
This should be so simple, yet I've struck out.
I have 2 tables, each with a common column called "pid" which is an integer
and is a unique index. There are approx 18 million rows in each table, and
one of the tables has approx 5000 fewer rows than the other table. So it
should be a piece of ca
Hi,
I have db users from all over the world. I only understand english. This
is rarely a problem since I almost never need to look at users data, but
every once in a while I do need to, usually this is while reviewing
logfiles.
Here is an example. Selecting a text field from a table I g
Hi John,
What kind of engine are you using on your table? MyIsam or InnoDB or are
you using merged tables?
If you query your system variables what is your max_write_lock_count?
If you create a copy of the table: mysql>create table cp1 like
USERS_PER_HOUR; and you try the insert again; is the
Jon Miller wrote:
I have a sql script that needs to be re entered using the following command mysql
< create.sql but the database already exists. IS there a way to overwrite or
update the database using the script, or do I have to delete the existing database?
Hello,
Dotan Cohen schrieb:
I keep a lot of personal information in a MySQL database. I have a few
querys premade for the wife to use, but we have gotten to the point
where we need a solution for her to be able to run her own queries.
She is NOT about to learn SQL, and myPHPadmin is a little too
11 matches
Mail list logo