Check on sourceforge.net, there's tons of open php/mysql projects. :)
Luis
On Fri, May 07, 2004 at 11:29:19AM -0700, David Blomstrom wrote:
> Is it possible to copy a working MySQL database and a
> page driven by that database to another website? If
> so, it would a great learning resour
I'm a newbie trying to follow a tutorial. The tutorial says to type:
mysql employees <><><><><><><><><><><><><><><><><>
Robert Ameeti
The church is near but the road is icy; the bar is far away but I'll walk carefully.
<><><><><><><><><><><><><><><><><><>
--
MySQL General Mailing List
For list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Berg wrote:
> Hello,
>
> After adding a primary key (alter table add primary key(col1, col2) to
> an innodb table the server hangs and I get this in the console:
>
> 040509 19:50:24 InnoDB: Started; log sequence number 0 28870268
> mysqld-max
The build from scratch on a redhat machine is not 100% straight forward.
I believe the S90mysqld link in the redhat /etc/rc.d/rc3.d/ looks
specifically for the boot file in /etc/rc.d/init.d/mysqld in order to start.
It's auto generated on a rpm but if you wanted to try subqueries which is
only avai
Sam:
I removed MySQL by removing the directory /etc/local/ &
/etc/local/mysql and then re-installing the mysql-4.0.18.tar.gz. I follwed
the procedure (as you described) & from mysql documentation & again I can
not get mysql auto start.
Do you know which directory/file has mysql error so I can loo
Does it make sense to use a transaction just for the row locking properties,
and then not needing to error check?
I have a situation where I have seperate files that are being run very often
in realtime by many different users. One is calling a list of 12 football
players. The other is updating
> table:
> title_id bigint(50),title char(200), cdate datetime
>
> query:
> select title, max(cdate) as mdt, count(title_id) as
> num
> from entry
> where (date_format(cdate, '%Y-%m-%d %H:%i:%s')
> between '2004-05-07 00:00:01' AND '2004-05-08
> 23:59:59')
> and
> (on = 'Y')
> group by title
> ord
If a column is auto_increment it can't be DEFAULT 0.
PB
- Original Message -
From: Marvin Cummings
To: [EMAIL PROTECTED]
Sent: Sunday, May 09, 2004 7:26 PM
Subject: Error creating table in MySQL 5.0
Wondering if anyone can give me some help with this error I'm getting
wh
I can not seem to find the section in the manual that talks about the max
number of tables MySql can use, can someone point me please?
I have been asked to build a database which could have some potentially
interesting storage needs.
There will be a users table, there can be x users, if all goes
Wondering if anyone can give me some help with this error I'm getting
when trying to create this table:
ERROR 1064 (42000): You have an error in your SQL syntax. Check the
manual that
corresponds to your MySQL server version for the right syntax to use
near '$sql
= "CREATE TABLE $subdivtab
Kirti:
I think you already did that as you said in you first
msg about you installation steps.
> > >>Setup to start MySQL automatically
> > >> % cp /usr/local/ No>/mysql.server
> > >>/etc/init.d
Did you get my prev msg where I suggested to check the
previleges on your mysql.
Usuall
Brian:
No. From where I copy this file from? Is it stright copy or something else?
You might be my savior!!
Thanks.
Kirti
-Original Message-
From: Brian Duke [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 09, 2004 5:44 PM
To: 'Kirti S. Bajwa'; [EMAIL PROTECTED]
Subject: RE: MySQL does no
Can someone please advise me on how to prevent the [EMAIL PROTECTED]
connection? This is preventing me from accessing any of my databases in
phpMyAdmin.
Any responses are appreciated.
Thanks
I know that feeling. perhaps I can help.
do you have an /etc/rc.d/init.d/mysqld file?
> -Original Message-
> From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
> Sent: Sunday, May 09, 2004 3:29 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: MySQL does not automatically start at BOOT time??
>
> H
Hello List:
I have spent the entire weekend solving this problem without success. PLEASE
HELP.
After the last response from Paul, and MySQL not starting at BOOT time, I
thought that I may have done something wrong. So I went ahead and did a
fresh install of RH9 & MySQL Source Distro with one diff
At 18:27 +0200 on 05/09/2004, Thomas Nyman wrote about This thing called MOD:
Hi All
I'm a bit perplexed..perhaps its a language thing,,but
the MYSQL reference manual says that
MOD
..Returns the remainder of N divided by M...
and gives an example SELECT MOD(234,10)
--> 4
Th
P.S. I should add that I'm not trying to import data
between computers or to an online site. This operation
involves nothing but me and my computer.
__
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweeps
Sorry, I didn't mean to send that first message; I hit
send by mistake. This is the real message.
I was delighted to discover how easy it is to import
csv files with phpMyAdmin - until I got the following
error message:
#1148 - The used command is not allowed with this
MySQL version
I found ton
--- "HACKATHORN, TODD (SWBT)" <[EMAIL PROTECTED]> wrote:
> Don't know if this will help, but this is how I
> offer web clients to "save
> as excel" in cold fusion:
>
>
>
>
>
> the key is to change the content like above. I am
> not sure how to do this
> in PHP. But I am sure if you lo
At 18:27 +0200 5/9/04, Thomas Nyman wrote:
Hi All
I'm a bit perplexed..perhaps its a language thing,,but
the MYSQL reference manual says that
MOD
..Returns the remainder of N divided by M...
and gives an example SELECT MOD(234,10)
--> 4
This I do not understand. remainder of
"Grant Cooper" <[EMAIL PROTECTED]> wrote:
> I am trying to find all my empty records. I am looking for NULLs and Empty
> strings but is there a simple way to just as this? I thought MySql may have
> something built in.
>
SELECT .. FROM table WHERE column IS NULL or column = '';
http://dev.mysql.
Hello,
After adding a primary key (alter table add
primary key(col1, col2) to an innodb table the server hangs and I get this in
the console:
040509 19:50:24 InnoDB: Started; log
sequence number 0 28870268mysqld-max-nt.exe: ready for
connections.Version: '4.1.1a-alpha-max-nt' socket: '
> Hi there, I am aware this isnt possible. I would like the power of Innodb,
> but one of my applications also requires the boolean search within blocks
of
> text, how can i do this efficiently ?
I don't know what power of InnoDB you're referring to, but you can always
use InnoDB for certain parts
Hi,
I use mod a lot simply for fast checking if a number is a multiple of
another number
if mod(number1,number2) = 0 then number1 is a multiple of number2
Il giorno 09/mag/04, alle 18:44, Robert Reed ha scritto:
Thomas
MOD is a way to get the remainder from a division
problem. It does not ta
Thomas
MOD is a way to get the remainder from a division
problem. It does not take into account fractions like
we do in real math. It's more basic and elementary.
Mod of 5 by 2 would be 1. The answer is 2 remainder
1, thus the MOD is 1. I myself have never used this
fuction but I'm sure lots
Hi All
I'm a bit perplexed..perhaps its a language thing,,but
the MYSQL reference manual says that
MOD
..Returns the remainder of N divided by M...
and gives an example SELECT MOD(234,10)
--> 4
This I do not understand. remainder of N divided by M - isn't that
simply divisi
>" Query failed : You have an error in your SQL syntax. Check the manual
>that corresponds to your MySQL server version for the right syntax to
>use near 'index = 21' at line 3"
I believe 'index' is a reserved word, usually used for creating indexes.
Using it as a field in a table could quite lik
Hi there, I am aware this isnt possible. I would like the power of Innodb,
but one of my applications also requires the boolean search within blocks of
text, how can i do this efficiently ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
> $query="SELECT * FROM women WHERE 'id=$id'";
This would result in something like:
SELECT * FROM women WHERE 'id=1'
Do you see the error here?
$query="SELECT * FROM women WHERE id=$id";
or
$query="SELECT * FROM women WHERE id='$id'";
would be better...
Tips for debugging this in PHP:
- print th
Thanks for the responses Michael and Bob! Yeah, I'm super noob to all this ^.^
I changed the column to "id" from "index" that seems to have fixed the problem..
kinda... now when I have it print values from the columns in that row, it all seems to
be empty. When I tell it to just print the array
---
On Sunday 09 May 2004 05:29, you wrote:
| > 040508 11:10:24 mysqld started
| > 040508 11:10:24 /usr/sbin/mysqld: Can't find file: 'host.MYD' (errno: 2)
| > 040508 11:10:24 mysqld ended
| Check to see if mysqld is correctly reading your my.cnf, and that no other
| --datadir
LAMP language-- I mean LAMP sets
Sorry
john
-Original Message-
From: john y [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 09, 2004 12:52 AM
To: [EMAIL PROTECTED]
Subject: mysql cluster ??
hello, my question it is about how could I take advantage of MySql
cluster, if I'm running a web serv
hello, my question it is about how could I take advantage of MySql
cluster, if I'm running a web server using LAMP language, do I have to
put a load balancer in front of Mysql servers? How do I code PHP? Should
I point to the load balancer or should I point to one of MySql server?
Thanks
John
I found the answer to my question by reading the online manual with user
comments.
Sorry!.
Mark
- Original Message -
From: "Mark Fuller" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, May 09, 2004 12:25 AM
Subject: auto_increment question
> I would like to use "MEDIUMINT UN
I would like to use "MEDIUMINT UNSIGNED AUTO_INCREMENT". Over time various
rows will be deleted. What happens when auto_increment reaches the maximum
value? Will it roll over to 1? And, will it begin filling those unused
values from past deletes?
Thanks,
Mark
--
MySQL General Mailing List
For
35 matches
Mail list logo
