is this declared in php or javascript??
depends on the syntax.
- Original Message -
From: Caroline Jen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:38 AM
Subject: Select Records From the Database
I got null after selecting records from a table in
the
On dinsdag 2 december 2003 9:41 Nitin told the butterflies:
is this declared in php or javascript??
depends on the syntax.
- Original Message -
From: Caroline Jen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:38 AM
Subject: Select Records From the
Best regards
--
Avenger [EMAIL PROTECTED]
Exceed PHP (http://www.phpe.net)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On dinsdag 2 december 2003 4:07 Skippy told the butterflies:
I must admit I'm pretty stumped here. I'm using MySQL 4.0.12.
I have several tables with info, and one which servers as a
link between them (has id's that refer the id's in all the others).
The info tables hold people(table 1),
On maandag 1 december 2003 15:40 Jay Blanchard told the butterflies:
[snip]
Is there a way to export/import MySQL tables in XML format? [/snip]
Well Todd, it is a little more complex than this. How much do
you know about XML?
In fact, exporting is quite simple. Just give
mysqldump
jeepcreep [EMAIL PROTECTED] wrote:
That is what I did.
Check with
ps ax | grep mysqld
if MySQL server is really running.
That's when I get the error 2002 message. Maybe my problem is not with the
mysql.sock file but something else.
Daniel Kasak [EMAIL PROTECTED]
Ian,
when you import the dump(s), put
SET FOREIGN_KEY_CHECKS=0;
at the start of the dump file. I think that the latest version of mysqldump
in upcoming 4.1.1 will put that automatically.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and
Arnoldus Th.J. Koeleman [EMAIL PROTECTED] wrote:
I try to run to different version 3.23 4.0 with ome my.cnf file with
different mysqld section but
Only one is started.
Anybody have any idea how to run two versions
There are several ways and they are described at:
Hi group,
I want to do a LEFT JOIN that takes no condition.
For example I have the following tables:
table_1table_2
--- -
1A
2
[snip]
I want to do a LEFT JOIN that takes no condition.
For example I have the following tables:
table_1table_2
--- -
1A
2
I am in the process of migrating a database and some code from an MSSQL
database and am running into a little problem with some queries. Would
appreciate any help anyone could offer.
I currently have this query which runs fine when using either MSSQL or
Access. However, when I run it against
On dinsdag 2 december 2003 14:06 Director General: NEFACOMP told the
butterflies:
Hi group,
I want to do a LEFT JOIN that takes no condition.
For example I have the following tables:
table_1table_2
---
Access. However, when I run it against MySQL I get an error.
select l.ltsysid,l.lientraknum, c.name from lientrak as l, customer as c
where l.custsysid=c.custsysid
and l.ltsysid in (select l2.ltsysid from lientrak as l2 where
l2.lientraknum
like '2003-%')
Sub queries are not going to be
Bill,
I tested this on the latest 4.1.1 snapshot, and it worked ok: client 2
waited for client 1 to commit. Please test again.
Best regards,
Heikki
Innobase Oy
http://www.innodb.com
InnoDB - transactions, row level locking, and foreign keys for MySQL
InnoDB Hot Backup - hot backup tool for
On dinsdag 2 december 2003 14:44 news told the butterflies:
In article [EMAIL PROTECTED],
Director General: NEFACOMP [EMAIL PROTECTED] writes:
[1 text/plain; iso-8859-1 (quoted-printable)] Hi group,
I want to do a LEFT JOIN that takes no condition.
For example I have the following
Hi,
Can someone please tell me how to set up a linux mysql server to accept
connections from remote machines.
I have tried creating users for all of the remote host, and creating
users with host '%' and '*', everytime I try to connect using myodbc or
mysqlcc, I get the error host {host name} is
Louis van der Merwe wrote:
Hi,
Can someone please tell me how to set up a linux mysql server to accept
connections from remote machines.
I have tried creating users for all of the remote host, and creating
users with host '%' and '*', everytime I try to connect using myodbc or
mysqlcc, I get the
Hi
try running
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON database.*
TO [EMAIL PROTECTED]
IDENTIFIED BY 'pass';
where 'hostname' is the one in the error message
HTH
Peter
-Original Message-
From: Louis van der Merwe [mailto:[EMAIL
You should not need to restart , you will need to 'flush privileges'
though. has that been done?
Jeff
John Nichel
I'm having a tough time with the debug options for mysqlimport. I've
check the docs, but they're as clear as mud. I've tried a number of
combinations of -#d:t:o,filename and everything else I can think of, but
I can't get any debug information.
What I'm really looking for is to get the text
Hi all:
Anyone know a RELIABLE software program for
administering to a mysql database on a webhosting unix
server?
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives:
[snip]
Anyone know a RELIABLE software program for
administering to a mysql database on a webhosting unix
server?
[/snip]
phpmyadmin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
wow!
thanks all for the superquick response.
J
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Anyone have a response to the following:
Hi
I have a db that gets data dumped into it. One of the columns gets unix
timestamp data utime.
I what to covert that into a datetime column so I can utlize indexes and
such.
But I still what the unixtime to remain.
I know I can get the data I want with
Having a problem with a Date data type.
Here's the query:
SELECT distinct date_format(auditdate, %Y%M ) as listUrl, date_format(
auditdate, %Y%m ) as blank
FROM quality_history
WHERE auditdate Now()
ORDER BY listUrl desc
LIMIT 6
auditdate is a DATE datatype
When I run
phpmyadmin is not reliable enough?
joffrey leevy wrote:
Hi all:
Anyone know a RELIABLE software program for
administering to a mysql database on a webhosting unix
server?
Thanks
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
now() gives current date and time. use current_date() instead.
hope it helps
Nitin
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 9:32 PM
Subject: Date data type issue
Having a problem with a Date data type.
Here's the query:
In my opinion MySql front is best and the best thing is further development
of already enriched software started again.
Nitin
- Original Message -
From: Colleen Dick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:42 PM
Subject: Re:
Matthew,
I really don't understand the question. Apostrophes must be properly
escaped when text is inserted into the MySQL db, but any perl script will
easily do this for you. You may convert to HTML at the same time.
If the database gives nothing but a path to a *.txt source then your HTML
code
The time zone matters... your results are exactly 8 hours off... PST is gmt -8. So it
looks like the from_unixtime function is converting to what the time was locally at
that moment in GMT. Not what I would have expected either
What do you get when you run-
select unix_timestamp(urtime)
[snip]
The site is a news based site and has the use of the single quote or
apostrophe (') through most of it's articles. I think that each
article
at present is an external .txt file that is pulled in to Oracle. If I
carried on this method of having an external .txt file would that over
come
Here is those results:
mysql select unix_timestamp(urtime) from t_test;
++
| unix_timestamp(urtime) |
++
| 1070296560 |
| 1070292960 |
++
2 rows in set (0.01 sec)
mysql select * from t_test;
On Mon, 1 Dec 2003, Xavier Fernández i Marín wrote:
Is there any application to export MySQL results of queries to LaTeX
tables? (preferably under GPL)
Xavier,
I have a hack for one of my applications. You can use this as a starting
point, but you will have to adjust directories. It converts
On 2 Dec 2003 at 7:57, Ron McKeever wrote:
I have a db that gets data dumped into it. One of the columns gets
unix timestamp data utime. I what to covert that into a datetime
column so I can utlize indexes and such. But I still what the unixtime
to remain.
You can use indexes with a Unix
Is the fulltext search working for cjk text (use UTF-8) in 4.1.0 alpha ? I
have trouble doing search on cjk text in 4.1.0alpha, though it seems should
be working according to the following doc:
http://www.mysql.com/doc/en/Fulltext_Restrictions.html
Any trick there ?
Thanks
--
MySQL General
Thats seems like a bug to me.
I would think FROM_UNIXTIME would take a unixtime stamp
and covert it to what it is. We know its from GMT
UNIX timestamp =
The timestamp is the current time measured in the number
of seconds since
the Unix Epoch (January 1 1970 00:00:00 GMT).
Ron
-Original
At 11:55 -0500 12/2/03, Hu, Yiguang wrote:
Is the fulltext search working for cjk text (use UTF-8) in 4.1.0 alpha ? I
have trouble doing search on cjk text in 4.1.0alpha, though it seems should
be working according to the following doc:
http://www.mysql.com/doc/en/Fulltext_Restrictions.html
UTF-8
Hi!
I do not know how to use INSERT and UNION together.
For example:
INSERT INTO tmp_table_name (a)
(SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY
a LIMIT 10)
UNION
(SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY
a LIMIT 10)
ORDER BY a;
It does not work. But I think it should. Have
George Georgeus wrote:
Hi!
I do not know how to use INSERT and UNION together.
For example:
INSERT INTO tmp_table_name (a)
(SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY a LIMIT
10) UNION (SELECT a FROM table_name WHERE a=11 AND B=2 ORDER
BY a LIMIT 10) ORDER BY a; It does not work.
We just downloaded MySQL Front the other day... and it's one
of the best that I have seen in awhile :)
just my $0.02
--
MikemickaloBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web
Karl
I have quite a lot of experience with MS Access - write to me off list if
you want me to help you
Freddie
-Ursprüngliche Nachricht-
Von: karl james [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 2. Dezember 2003 15:16
An: [EMAIL PROTECTED]
Betreff: read (Off subject Help)
Hi!
On Dec 02, Hu, Yiguang wrote:
Is the fulltext search working for cjk text (use UTF-8) in 4.1.0 alpha ? I
have trouble doing search on cjk text in 4.1.0alpha, though it seems should
be working according to the following doc:
http://www.mysql.com/doc/en/Fulltext_Restrictions.html
Nope. The
Hi!
On Dec 02, Sergei Golubchik wrote:
Hi!
On Dec 02, Hu, Yiguang wrote:
Is the fulltext search working for cjk text (use UTF-8) in 4.1.0 alpha ? I
have trouble doing search on cjk text in 4.1.0alpha, though it seems should
be working according to the following doc:
On 2 Dec 2003 at 9:12, Ron McKeever wrote:
Thats seems like a bug to me.
I would think FROM_UNIXTIME would take a unixtime stamp
and covert it to what it is. We know its from GMT
A Unix timestamp represents a particular second in time. It doesn't
have a time zone associated with it. Yes,
UNIX_TIMESTAMP takes a DATETIME and returns a Unix timestamp which
matches your definition (seconds since '1970-01-01 00:00:00' GMT).
FROM_UNIXTIME takes a Unix timestamp and returns a DATETIME.
I believe the problem you are having is that mysql expects all DATETIMEs
to be in your timezone.
Hi!
On Dec 02, George Georgeus wrote:
Hi!
I do not know how to use INSERT and UNION together.
For example:
INSERT INTO tmp_table_name (a)
(SELECT a FROM table_name WHERE a=10 AND B=1 ORDER BY
a LIMIT 10)
UNION
(SELECT a FROM table_name WHERE a=11 AND B=2 ORDER BY
a LIMIT 10)
ORDER BY a;
Hi!
On Nov 25, Christophe DIARRA wrote:
Hello.
MySQL 4.1.0 is not respecting the registered privileges.
...
show databases displays an incorrect list of databases. Each user lists a
database it should not, and doesn't show all the databases it should.
Same thing with 'use database' : the
Hi,
I'm building a recruitment website using PHP and mySQL and would like
to be able to search CVs/resumes that people have uploaded to the
server. Most people have them in Word format - what I'd like to be able
to do is copy the text of the document and insert it into a mysql
database so
We have just put up a new MySQL 3.23.x on a modest Sun V120 with 1GB RAM
and a few gig of hard disk space. We're running Solaris 2.8.
We seem to be clueless (I am certainly clueless) about testing various
configuration options so that we are reasonably optimizing the resources
available to
In the last episode (Dec 02), Matt MacLeod said:
I'm building a recruitment website using PHP and mySQL and would like
to be able to search CVs/resumes that people have uploaded to the
server. Most people have them in Word format - what I'd like to be
able to do is copy the text of the
hi, all.
anybody know whether (and how) it's possible to have one server acting
as a backup-server for various other servers, so that it basically does
am incremental backup of ONE database on the to-be-backed-up server?
i was guessing to tell the backup-server to act as a slave for the
On Tue, 2 Dec 2003 10:47:07 +0100 Wouter van Vliet [EMAIL PROTECTED]
wrote:
If you want to select those who HAVE BEEN at level 2 in the yeaer Y,
you can just do level_id = 2. But I guess you want to know who
currently IS at level 2 IN the year Y? In that case, when using a
Yes, that's what I'm
On Tue, 2 Dec 2003 10:17:24 -0500 [EMAIL PROTECTED] wrote:
You should not need to restart , you will need to 'flush privileges'
though. has that been done?
I was under the impression that the latest versions don't even need
'flush privileges' anymore, that any modifications to the mysql
from what I've read in the docs, if you use 'grant' you don't have to flush, but if
you insert into user tables directly, you do
-Original Message-
From: Skippy [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 11:56 AM
To: [EMAIL PROTECTED]
Subject: Re: mysql remote
Greetings Gurus,
I have a mysql server that I need to create a disaster recovery system
for. What I am planning on doing is putting the data dir on a NFS
mounted directory so that I can start mysql on either of two servers in
case one dies. The inbound connections would be load balanced in a
On Dec 2, 2003, at 3:48 PM, Ari Davidow wrote:
We have just put up a new MySQL 3.23.x on a modest Sun V120 with 1GB
RAM and a few gig of hard disk space. We're running Solaris 2.8.
Why are you using an old version of MySQL? MySQL4.0 is the recommend
production version currently.
We seem to be
Hello group,
I have a table that I create with
CREATE TABLE SuperTest (
ID int(11) NOT NULL AUTO_INCREMENT,
Name varchar(64) NOT NULL,
Domain varchar(64) NOT NULL,
PRIMARY KEY(ID)
);
I use that same thing to create a the same table on two servers.
On one
Hi Andrew,
I am not a Guru. I would suggest that you look at MySQL's excellent replication
facility rather than NFS mount a drive. Having your data on an NFS mounted drive will
significantly degrade the performance of your database. Replication will not.
John Griffin
-Original
Hi folks.
I'm storing files in a BLOB table for a number of reasons for my web
app, and I'm trying to break up uploads so I insert smaller chunks (my
app imposes restrictions on memory usage, so reading the whole file at
once and doing an insert doesn't work).
What I do is insert the record,
I'm looking at MySQL for a project where multiple applications sharing the same
database need to collaborate. For example, if one application made a change to a
table, another application would be notified via an event (the applications may run on
different host machines). However, I have not
Hi,
I am working on a database replacement project and evaluating Mysql with Innodb for
the same. Mysql document says, Innodb supports checkpointing but that happens in the
background. That is, when the size of the log file exceeds a limit, it happens in the
back ground.
Is there way to
This is the article for you:
http://php.dreamwerx.net/forums/viewtopic.php?t=6
Shows how to store large files in database... I've currently got gigs and
gigs of files in mysql using this method..
On Tue, 2 Dec 2003, Jim Kutter wrote:
Hi folks.
I'm storing files in a BLOB table for a number
Might just create a common table that stores messages back and forth.. it
stores sender id, recipent, message, etc..
each server polls the table ever so often (cronjob) for messages for it
and processes them, removing them from the queue.. it's like a simple
message broker..
On Tue, 2 Dec
We have discovered that a small number of transactions appear to have
been omitted from the replication process. The input and output
binlogs have been saved and I plan to write a program to compare them
to determine which transactions were not replicated. At this point,
we are expecting to find
We have moved a production application over to a MySQL database and are
experiencing some issues. I'm not the database guy myself, but thought
I'd try the list to see if we could get some help.
The application does general business functions such as AR/AP/SO
Entry/Payroll, etc.
The system
This is not directly supported by MySQL. I used FTP to collect files
from the various databases to be replicated and applied them to the
central database. If the central database is NOT a master for
aany other replication, then you can simply use mysqlbinlog to
update your central database.
If
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: Greg Jones [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, December 02, 2003 8:32 AM
Subject: Re: Query Help
Access. However, when I run it against MySQL I get an error.
select l.ltsysid,l.lientraknum, c.name from
Hi,
I have a mission critical database, that I want to be redundant, so I'm
using, as discussed in another thread, the Cisco LocalDirector, two mysql
machines, and db replication. mySQL version 4.0.16, compiled from source.
Should I make both servers both master and slave, or will this cause
Here are benchmarks for an optimized build of MySQL 4.0.16: (used
-mpowerpc-gpopt and -mpowerpc64 gcc arguments)
alter-table: Total time: 18 wallclock secs ( 0.03 usr 0.06 sys + 0.00
cusr 0.00 csys = 0.09 CPU)
ATIS: Total time: 19 wallclock secs ( 8.65 usr 8.40 sys + 0.00 cusr
0.00 csys
I am ashamed to ask this but I really did not see this
in the manual or elsewhere.
What is the command to rename a database?
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
MySQL General Mailing List
For list archives:
I want to know how could solve the next replication scenario:
I have a master.
I have 5 slaves.
At start the slaves has a master snapshot.
Now imagine slave 1, inserts a record. When it gets connected to the lan, it
must replicate it's changes to the master.
Then the slave 2 gets connected to
hi Joffrey,
You can manually rename the directory that contains the file for the
database you want to rename. Make sure to do this while mysqld is off.
So if we wanted to rename database foo:
% cd /usr/local/mysql/data
% ls -l
drwx-- 2 your uid staff512 Sep 28 19:58 mysql/
Description:
Mysql fails to install due to compile error on line 655. Unable to find
constant VIS_WHITE. This is due to not having the correct vis.h.
ie. HAVE_VIS_H should be false and this library should not be included line 49.
(although there is a different vis.h library installed - from the
rubn ruvalcaba wrote:
I want to know how could solve the next replication scenario:
I have a master.
I have 5 slaves.
At start the slaves has a master snapshot.
Now imagine slave 1, inserts a record. When it gets connected to the
lan, it must replicate it's changes to the master.
No, a slave
Hi,
I am trying use MySQL on RedHat 9 Linux box. I
installed the following rpms for this.
mysql-3.23.54a-11.i386.rpm
mysql-server-3.23.54a-11.i386.rpm
mysql-devel-3.23.54a-11.i386.rpm
After installing I executed the mysql_install_db
script, which executed without giving any error. I
Hi,
I am running a master and a slave. When I created a foreign key in
master, it looked like this:
CONSTRAINT `0_373` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
But on the slave it was like:
CONSTRAINT `0_451` FOREIGN KEY (`prefecture_id`) REFERENCES `prefecture`
(`id`)
The
Hi,
I have one question regarding date column type in
MYSQL.
Can I use the column type for date as Integer instead
of DateTime or Date to store the date as
mmddhhmmss or mmdd?
As I know MYSQL accepts this format. But I am not too
sure about the column type.
What are the pros and cons
77 matches
Mail list logo