On Fri, 9 Aug 2002, Thomas Seifert wrote:
On Thu, 8 Aug 2002 03:02:40 -0700
Jeremy Zawodny [EMAIL PROTECTED] wrote:
btw:
I did a quick benchmark with mysql4 and its query caching running with
innodb.
Quite impressive, the app run with double the number of pages per second as
Gloria
in a database on adjunct faculty.
Well, I set my table up withalphnumeric codes and most stats software
want those mutliple choices as numbers.
=which is why most people design to enter such data as number codes (1~5)
rather than alpha.
So I need to change the things already
Obiajulu,
Please refer to previous response and the as yet unanswered question within.
I have the following values in my db table:
Id. regdate
001040-1467
011910-2002
021700-1789
031550-2002
041600-1700
051900-2000
...
How
why do i get an erro like
ERROR 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
what could be wrong with this error
please send me the reason for it and also
how do i overcome this problem
regards
samratsam
Get Your Private, Free E-mail from
Hello,
Using MysqlTool v0.94 on Netscape Communicator 4.79 to access MySQL
vers 3.23.49 on FreeBSD 4.x
Suddenly starting returning
Please enable cookies. Multi-user MysqlTool
uses cookies to store encrypted connection information.
Browser has Accept all cookies set.
Steven,
I have forwarded this to the build master of MySQL AB. I too noticed that
the mysqld.sym file did not work in the
mysql-4.0.2-alpha-pc-linux-gnu-i686
.tar.gz distro, but did not realize that the .sym file was totally empty.
The .sym file works in the .rpm distro, but unfortunately that
Hello,
I need to ask for some help and I can't find anything in the manuals. I
am writing a php based app that as one of it's functions keeps an
employee time sheet. The times are stored in a mysql database with 2
columns - time_in and time_out. What I need to do is subtract these to
columns
Hello Christopher,
I need to ask for some help and I can't find anything in the manuals. I
am writing a php based app that as one of it's functions keeps an
employee time sheet. The times are stored in a mysql database with 2
columns - time_in and time_out. What I need to do is subtract
Alexander Burbello[EMAIL PROTECTED] Wrote:
Hi,
how can I lock only one row in the table?
What table type I have to use to lock?
If you use MyISAM table (default table on MySQL 3.23.x) you can't
use InnoDB table for enabling row level locking,
BTW it's default table for MySQL 4.x
Regards
Thanks for the quick response. The times are stored in TIME format. If I
do the following:
SELECT *, time_out-time_in as job_time from time_sheet;
the job_time column gives me the right time, but is not formatted, for
example:
time_in = 11:00
time_out = 13:15
job_time= 21500
Any pointers?
Hi,
I am trying to setup a PHP form to send to mySQL
database. I know how to connect to mySQL but need
help getting the information in the form to update
into the mySQL database.
I have the following table called contacts, I'd like
the form to have the following fields.
firstName
lastName
Hi,
I would like to create a members area on my site,
using mySQL for the database to hold usernames and
passwords to login to the area.
I need to know the following if anyone can help
please.
- What code would I need to make a login page form
that has username and password? (lets say the
Chris,
A pointer is a type of shark! Just like them, this suggestion has sharp
teeth too - change the time_in value to 11:45 and see what I mean...
This topic was discussed one week ago (Time Calculations) - see archives
(to save you that, I'll forward you a copy privately (list doesn't like
I am installing a new MySQL installation on a new Xserve and I am
getting this message;
[xserve:/usr/local/mysql] admin% sudo ./scripts/mysql_install_db
Sorry, the host 'xserve' could not be looked up.
Please configure the 'hostname' command to return a correct hostname.
If you want to solve
Hi,
In Win32 distribution version of MySQL(ver 4.x) , mysql.dll don't have entry
point for mysql_ssl_clear().
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
Hi, Jerry,
Here's your simplified form:
form action=addcontacts.php method=post
input name=firstName type=text
input name=lastName type=text
input name=email type=text
/form
Here is the page addcontacts.php:
html
body
?
if ($REQUEST_METHOD == POST) {
$usr =
Why is mysql adding a postfix to my USE request? I know that test.test
doesn't exist, i don't want it to, i'm not asking for anything.anything why
will it append this suffix to my request?
mysql show databases;
+--+
| Database |
+--+
| mysql|
| test |
+--+
2
What are you trying to do here?
MySQL is giving this error because the table 'test' does not exist in the
'test' database. Are you mistaking database for tables? I think perhaps you
need to take a look more carefully at the manual about creating tables.
Mike
- Original Message -
From:
From: david [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 10, 2002 1:42 PM
Subject: ERROR 1146: Table 'test.test' doesn't exist - Why is mysql adding
a postfix to my USE request?
Why is mysql adding a postfix to my USE request? I know that test.test
doesn't exist, i don't want it to, i'm not
try using localhost.
you have to set the hostname in the install script.
on 8/10/02 1:08 PM, Alex Pilson, typed:
I am installing a new MySQL installation on a new Xserve and I am
getting this message;
[xserve:/usr/local/mysql] admin% sudo ./scripts/mysql_install_db
Sorry, the host
Hi all,
While trying to upgrade a table struture i get the following error :
ALTER TABLE Prefixtest_T_Stories ADD COLUMN IndexDisplay char(1) default 'Y'
Error: 7 - Error on rename of '.\testbase\Prefixtest_t_stories.MYI' to
'.\testbase\#sql2-118-3.MYI' (Errcode: 13)
I m running a mysql 401
I'm getting this in 3.23 on OS X.
As near as I can figure out when I used this installer disk from open osx it
reset my drive permissions to read only excepting anything in my specific
user folder (including desktop).
I'm stuck here too so any help would be appreciated.
Brian Loomis
From:
-Original Message-
From: William dw [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 10, 2002 5:34 PM
To: Mysql
Subject: FW: Error: 7 - Error on rename ... (Errcode: 13)
Error code 13 = Permission denied.
Check your permissions :)
-Original Message-
From: David yahoo
mysql.sock file doesn't exist in the /var/lib/mysql directory. Stop and
restart mysql server.
Regards,
Bhavin.
- Original Message -
From: samratsam [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 10, 2002 4:28 AM
Subject: ERROR 2002: Can't connect to local MySQL server
I am creating several tables in MySQL and linking via primary keys. I am held
up on one issue, for one row in one table i have a column 'favorites' where i
want to hold up to 10 unique entries, how do i implement this?
userTable
userId varchar(20)
name varchar(30)
email varchar(40)
I am not very sure I understand the questionbut maybe column type 'enum'
is what you are looking for.
- Original Message -
From: david [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, August 10, 2002 9:43 PM
Subject: MySQL database design, one column, 10 entries?
I am
Hi,
This is a problem of the sort that is starting to make me a little
supersituous. I am using mySQL various versions, one of which is 4.01 max on
FreeBSD 4.5 stable, DBI 1.30 and I believe the latest DBD::mysql module.
Well the weird thing that is happening is that on this particular machine
27 matches
Mail list logo