It's work
thanks
On Tue, 2002-08-27 at 14:24, Dan Nelson wrote:
> In the last episode (Aug 27), Osman Omar said:
> > below is my tables properties,
> > and my last record id is 127;
> >
> > mysql> desc emcs;
> > ++-+--+-+++
> > | Fie
Hello
First bug: The contact address is no longer existing:
"BUGs can be reported by email to [EMAIL PROTECTED]"
Second bug: perl does not substitute the '~' char to the home directory:
> --- /tmp/mysqlaccess.orig 2002-08-27 08:25:23.0 +0200
> +++ /usr/bin/mysqlaccess
In the last episode (Aug 27), Osman Omar said:
> below is my tables properties,
> and my last record id is 127;
>
> mysql> desc emcs;
> ++-+--+-+++
> | Field | Type| Null | Key | Default| Extra |
> +---
below is my tables properties,
and my last record id is 127;
mysql> desc emcs;
++-+--+-+++
| Field | Type| Null | Key | Default| Extra |
++-+--+-+++
|
Hi all,
I'm a newbie with mysql. I have a few question and would really appreciate
it if you can help me. I'm creating a database for a payroll system. I
actually finish with my entity relationship diagram. What should be the
next step? I know I should create the database already but while
this query in all probability violates some referential integrity... and
this in all probability is a primary key defined in your table.
So please check whether the query is trying to insert duplicate values in a
primary key field
- Original Message -
From: "Osman Omar" <[EMAIL PROTECTED
Hi all,
I'm a newbie with mysql. I have a few question and would really appreciate
it if you can help me. I'm creating a database for a payroll system. I
actually finish with my entity relationship diagram. What should be the
next step? I know I should create the database already but while re
Hi
I get this error.
any idea?
mysql> insert into emcs (insp_date,judge_date,model,lot_no,remark)
values
-> (20020816,20020816,'TA-SL5','010','');
ERROR 1062: Duplicate entry '127' for key 1
mysql>
-
Before posting
is this "tee" or "\T" command supposed to still work in mysql 4.x?
the manual says
* For logging, you can use the `tee' option. The `tee' can be
started with option `--tee=...', or from the command-line
interactively with command `tee'.
of course there isn't a single example of th
Hi all,
I have a table named expenditure whose create statement is as follows,
expenditure | CREATE TABLE `expenditure` (
`expenditureid` int(11) unsigned NOT NULL auto_increment,
`expendituredate` date NOT NULL default '-00-00',
`artifactid` smallint(5) unsigned NOT NULL default '0',
This is the query i run first -
select user.userid, user.name, plan.duration, plan.hour, plan.minute,
plan.status, plan.date, project.projectname,project.projectid from user,
plan, project where user.userid = plan.userid and project.projectid =
plan.projectid and plan.date >= '2002-8-13' and plan
Pada Tue, 27 Aug 2002 10:03:59 +0530
"Karthik" <[EMAIL PROTECTED]> menulis :
> Hi,
>
> Does the mysql max_allowed_packet restrict the amount of data that a query
> can fetch ?
>
> I am facing a problem wherein my query specifies all the 13000 odd records
> if i specify only a few columns. If i
Hi,
Does the mysql max_allowed_packet restrict the amount of data that a query
can fetch ?
I am facing a problem wherein my query specifies all the 13000 odd records
if i specify only a few columns. If i run the same join query with lots of
columns, it only fetches 8000 odd records.
What restri
Mark Stringham :
i think that you can use task plan on windows.such as,
backup.bat:
mysqldump -uroot -pmysql databasename tablename > tablename.sql
move tablename.sql d:\where you want store it\
and add a tast plan in control panel, set the time to 3 o'lock,
set the
Pada Tue, 27 Aug 2002 01:09:32 +
"Will K." <[EMAIL PROTECTED]> menulis :
> hello,
>
> Please dont tell me to RTFM on this one (cause I am already doing that), but
> for clarity's sake... can someone tell me what it means when you use NULL
> and NOT NULL in a query (specifically CREATE TABL
Pada Mon, 26 Aug 2002 20:37:46 -0600
"Mark Stringham" <[EMAIL PROTECTED]> menulis :
> Anyone done it on widows?
>
> Thanks
>
> Mark
for dumping, the syntax is same ... mysqldump bla bla bla ;-)
but for the time, you have to use scheduler application to run the mysqldump :D
--
Write c
Anyone done it on widows?
Thanks
Mark
- Original Message -
From: "Ilyas Keser" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 26, 2002 4:26 PM
Subject: backup script
> Has anyone a shell script example to backup all mysql databases at 3
> o'clock at the night?
>
> Tha
>Stuart Low wrote:
> > Have had continuing issues with trying to actually get LOAD LOCAL INFILE
> > commands working
>At 11:45 26/08/02 +0300, Victoria Reznichenko wrote:
>Did you specified local-infile=1 for client, too?
Hi,
I'm a MySQL newbie and I've got a question on this too.
I can
hello,
Please dont tell me to RTFM on this one (cause I am already doing that), but
for clarity's sake... can someone tell me what it means when you use NULL
and NOT NULL in a query (specifically CREATE TABLE)? Also, when should I
use them?
Will K.
Hi guys
I would like to have a SQL query to couple five tables to accomplish my need.
This is a search page and the user will be searching using the don_id
Presently I am using a simple equi join which works fine if all the five
tables contain data for user_id
But if any of the tables have no va
On Monday, August 26, 2002, at 06:33 PM, [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to t
I use a shell script and set up a cron job. Here's the shell script (I call
it mydbbak.sh)
#
#!/bin/sh
#
# Create /dbbakup directory
# $1 = Unix/MySQL Username
# $2 = Unix/MySQL Password
if [ ! -e /dbbakup ]
then
mkdir /dbbakup
Has anyone a shell script example to backup all mysql databases at 3
o'clock at the night?
Thanks...
ilyas
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
On 26 Aug 2002, at 15:32, Donald J Miller wrote:
> CREATE TABLE filetest(fileid int(5) not null, file BLOB null);
>
> I 've created the table and have used LOAD DATA in order to populate the
> database however I get numerous errors. Can someone shed some light as
> to how to do this correctly?
I'm running SuSE 7.3 Professional with dual AMD 1.2GHz CPUs. I'm fairly
confident that the binary package MySQL 3.23.52 Linux (Intel libc6 systems)
(9.1M) will work, but I'm not 100 percent sure - it's the only logical
option considering what's available. Can someone confirm?
Michael
-
Hi everyone,
In the following code:
sub DATEJOINED{
my %arg = @_;
if (! $arg{USER}) {return undef}
return $arg{USER}->get(field=>'RegistrationDate');
}
The field Registration date is returned from the mysql table for the user
who is
If you don't want to do any username checking (just checking a password)
you can use a blank username. Easiest way to do this is probably
something along the lines of:
GRANT SELECT ON db.* TO temp@'192.168.1.0/255.255.255.0' IDENTIFIED BY
'mypass';
UPDATE mysql.user SET user = '' WHERE user ='tem
How can I get this to allow access from any user with the correct passwd
to the main mysql server? Any user for the 192.168.1% class with a
correct passwd.
It seems I can't have a wildcard for the user statement below?
Thanks
-Original Message-
From: Chris Tucker [mailto:[EMAIL PROT
Hi,
Is there a way convert result of
SELECT NOW()
or
SELECT SYSDATE()
or
SELECT CURRENT_TIMESTAMP
to GMT, in a query?
Thanks,
Pekka
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http:
Please checks the documentation that comes with mysql. It is an excellent
source to learn MySQL.
-Original Message-
From: Robert McKerlie [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 26, 2002 12:27 PM
To: [EMAIL PROTECTED]
Subject: mysql basics
Can anyone suggest a good tutorial for
Hello everyone,
I am trying to create a mysql table to hold either the entire contents
of text or WordPerfect files. I've read about BLOB or TEXT type columns
so I've tried creating a table such as:
CREATE TABLE filetest(fileid int(5) not null, file BLOB null);
I 've created the table and have
Can anyone suggest a good tutorial for someone just starting out with MYSql?
Regards
Robert
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
I need to run the following query:
SELECT WRK_ImplDisp_1.Livello, WRK_ImplDisp_1.Origine, WRK_ImplDisp.Padre,
WRK_ImplDisp_1.Figlio, WRK_ImplDisp.QUnit*WRK_ImplDisp_1.QUnit AS Espr1,
WRK_ImplDisp_1.DaAggregare, -1 AS Espr2
FROM WRK_ImplDisp INNER JOIN WRK_ImplDisp AS WRK_ImplDisp_1 ON
WRK_ImplDi
Randall,
Saturday, August 24, 2002, 12:54:30 AM, you wrote:
RS> At 02:09 PM 8/23/2002 -0500, Dan Nelson wrote:
>>It looks like a mysql developer will have to look at vio_read and
>>figure out why the assert's failing.
RS> Dan,
RS> I was afraid it would be something like that. Thanks for
Daniel,
Monday, August 26, 2002, 12:53:26 AM, you wrote:
DN> some time ago I submitted the bug report below (see
DN> http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:116815:200208:nnjofboiddhkghnpfljl
DN> for the full report). There was no feedback and I now have a better
DN> understanding of the
Well, I bought "MySQL", Edición Especial from Paul DuBois. The editor is
Prentice Hall.
Maybe you can buy it at www.pearsoneducacion.com... jeje I found one about
MySQL and Perl there.
- Original Message -
From: "Markus Jais" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, Aug
Hi,
I'd like to download 4.0.2 for SPARC from
http://www.mysql.com/Downloads/MySQL-4.0/mysql-4.0.2-alpha-sun-solaris2.8-sp
arc.tar.gz
but I can't and I don't know why...
Could you help me please, where should I look for
a downloadable version?
Thanks in advance!
Regards;
Istva
SL> working. Basically, no matter what I specify with LOCAL LOCAL INFILE
mysql
SL> refuses to let my user (setup via Plesk) do a thing.
>Did you specified local-infile=1 for client, too?
Yes. Although it is in phpMyAdmin the original issue is occuring (although I
can replicate it with the console
I am writing a library which is using mysql.
I need to know the count of the *maximum* decimals of a NUMERIC column
before issuing a mysql_fetch_row().
I get the width of the field by:
MYSQL_FIELD *fields = mysql_fetch_fields (MYResult);
printf ("Width: %d\n", fields[i].length);
Doing a "DESCRIB
On Sun, 25 Aug 2002, andy wrote:
> Hi there,
>
> I am trying to write a php script to perform a full text search on a mysql
> db. I do a match against... and it digs out some results out of the db.
>
> There are 2 problems:
>
> 1.
> 2. Is it possible with php to underline the keyword inside t
hello robert,
you might want to try it without any options to Makefile.pl.
if you installed mysql on cygwin, put the mysql bin dir on your path so mysql_config
can be found, then the correct flags should be there.
even with flags, you should write
--libs='...'
instead of
"--libs="
make
Stuart,
Monday, August 26, 2002, 4:28:13 AM, you wrote:
SL> Have had continuing issues with trying to actually get LOAD LOCAL INFILE
SL> commands working. Even after a MySQL recompile it doesn't appear to be
SL> working. Basically, no matter what I specify with LOCAL LOCAL INFILE mysql
SL> refuse
Dave,
Saturday, August 24, 2002, 2:53:59 AM, you wrote:
DR> I upgraded my server and seem to have lost some MySql records. Is there a way to
recover lost records?
DR> Or could it be a index problem?
If you check tables with CHECK TABLE clause, do you get any error or
warning? If so, repair tabl
43 matches
Mail list logo
