I don't think php script can create database. But maybe I am wrong. If I am,
please somebody make it straight.
Create a database should do it through console or some kind like it.
~Elle~
-Original Message-
From: W. D. [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 18, 2004 2:31 PM
To: [
Hi Folks,
I am a relative newbie to MySQL and PHPmyAdmin. I tried adding
data into an existing table by 'uploading' a file in PHPmyAdmin.
I know the INSERT INTO commands are valid, since I can import
several hundred records using PHPmyAdmin. However, when I
try to import a few thousand records,
At 11:45 3/17/2004, BGLefty wrote:
>
>Is there a simple php script out there somewhere (or an example of how to do
>it) to create a new database, username and password? I would like to have a
>form in a password protected folder on my web site and be able to fill in
>those three variables to create
Matt W wrote:
Hi Michael,
http://www.mysql.com/doc/en/MySQL_indexes.html - Under the example
"WHERE clauses that use indexes":
/* index = 1 OR index = 2 */
... WHERE index=1 OR A=10 AND index=2
And for clarity, that should really have parentheses: index=1 OR (A=10
AND index=2)
Thanks for po
You could also do this with REGEXP, using [[:<:]] and [[:>:]] which are
character classes that match word boundaries, including comma, beginning
of line, and end of line. Then finding rows which include 2, for
example, would look something like this:
SELECT * FROM yourtable WHERE column REGE
Hi Michael, Jochem,
- Original Message -
From: "Michael Stassen"
Sent: Tuesday, March 16, 2004 10:00 AM
Subject: Re: BETWEEN
>
> Jochem van Dieten wrote:
>
> > However, I expect that would result in doing 2 rangescans and a
> > merge. It might be even faster to use:
> > SELECT * FROM sys
Hi Michael,
- Original Message -
From: "Michael Stassen"
Sent: Tuesday, March 16, 2004 9:45 AM
Subject: Re: BETWEEN
>
> Matt W wrote:
> >
> > The query using 2 BETWEENs with OR is exactly how it should be. It
will
> > be fast even in MySQL 3.23. OR is not a problem when the OR parts
>
At 14:06 -0800 3/17/04, James Hughes wrote:
I want to set up some automated table checking and the research I've
done has left me scratching my head.
I'm looking for a definitive answer to this thread:
http://marc.theaimsgroup.com/?l=mysql&m=106159147322752&w=2
With respect to MyISAM tables in 4.
At 1:52 +0200 3/18/04, Lorderon wrote:
Nope.. that doesn't work.. the LIMIT statement limits the rows returned, but
only 1 row is returned from that query always.. I want MySQL to stop the
count when it reaches to 200, rather to have it go over all the table and
return me 3500..
You can't tell COUN
Nope.. that doesn't work.. the LIMIT statement limits the rows returned, but
only 1 row is returned from that query always.. I want MySQL to stop the
count when it reaches to 200, rather to have it go over all the table and
return me 3500..
> SELECT COUNT(*) FROM tbl WHERE where_clause limit 200;
SELECT COUNT(*) FROM tbl WHERE where_clause limit 200;
-Original Message-
From: Lorderon [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 6:45 PM
To: [EMAIL PROTECTED]
Subject: limit stop count
How can I limit a count to stop when he reaches 200 rows?
SELECT COUNT(*) FROM tbl W
How can I limit a count to stop when he reaches 200 rows?
SELECT COUNT(*) FROM tbl WHERE where_clause;=> returns 3500
I want to stop the counting when it reaches to 200, so MySQL will not search
further to count all the 3500 rows..
thanks,
-Lorderon.
--
MySQL General Mailing List
For li
Manuele wrote:
This might sound silly to many... so sorry in advance...
in mysql4
Suppose I have 2 tables:
tableA has 3 columns, 2 of them reference the same column of tableB
Example:
TableA (Items)
Id - FirstType - SecondType
0 - 1 - NULL
1 - 2 - 3
Tabl
John Thorpe wrote:
524288000 Mar 11 11:19 ib_logfile0
524288000 Mar 3 08:59 ib_logfile1
524288000 Mar 11 11:19 ib_logfile2
I would venture a random guess that ib_logfile1 was in use until Mar 3,
then ib_logfile2 began and that around Mar 11 it switched back up to
ib_logfile0 where it st
I want to set up some automated table checking and the research I've
done has left me scratching my head.
I'm looking for a definitive answer to this thread:
http://marc.theaimsgroup.com/?l=mysql&m=106159147322752&w=2
With respect to MyISAM tables in 4.0, there seems to be two different
scenario
All of my tables are now InnoDB only. So, what I'd like to do is
reduce MySQL tunable variables down as much as possible for things
that don't affect InnoDB so that I'm not wasting memory on buffers
that will get little or no use.
It's obvious which variables are only for InnoDB (they start with
Garg, Piyush (EM, GECIS) wrote:
Hi Everybody,
Is there any way we can tranform the Stores procedure and Triggers present under Oracle Custom Application to mysql.
Please tell ways or any tools which can help us rewrite the logic in Mysql.
Thanks and regards,
Piyush
Stored Procedures ar
Egor Egorov wrote:
Yes, use LIMIT clause to get only certain number of rows. For example, to retrieve
forst 10 rows use the following statement:
SELECT .. FROM .. ORDER BY .. LIMIT 0,10;
Then to retrieve next 10 rows:
SELECT .. FROM .. ORDER BY .. LIMIT 10,10; retrieve rows 11-20
Daniel Kasak wrote:
When someone has a MySQL problem, it is often urgent.
While most of my posts to the list seem to appear withing a few
minutes, I can remember many occasions when they took more than a few
hours.
Its also not that difficult to notice duplicates; only the messages to
yoursel
At 21:54 +0100 3/17/04, Ryan A wrote:
Hey Paul,
>error: 'Access denied for user: '[EMAIL PROTECTED]'
(Using password: NO)'
That's a good sign, actually.
Finally a good sign.
I means that
mysqladmin was able to
find the server and attempt to connect to it.
That's good. The server rejected
At 12:24 -0800 3/17/04, [EMAIL PROTECTED] wrote:
Hey,
Thanks for replying.
I see that my mysql server IS running...
Do you have a /var/lib/mysql/mysql.sock file? How about /tmp/mysql.sock?
**That didnt work.
"Didn't work"? I didn't ask you do try anything, I just asked if either
of those files
Hey,
Thanks for replying.
I see that my mysql server IS running...
> Do you have a /var/lib/mysql/mysql.sock file? How about /tmp/mysql.sock?
**That didnt work.
**And neither did this:
[EMAIL PROTECTED] root]# mysqladmin -u root -h 127.0.0.1 variables
mysqladmin: connect to server at '127.0.0
At 11:32 -0800 3/17/04, [EMAIL PROTECTED] wrote:
Hey,
thanks for replying.
Your mysql server is not running my friend! =)
Try /etc/init.d/mysqld start <-- this should be able to turn it on!
You can not change the passwords with the server off
I finally found the correct place to start and di
Are there any open source (or other) to load an XML document directly to
a MySQL table or set of tables?
Any recommendations would be greatly appreciated.
Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
Life is not a journey to the grave arriving safely in a well preserved
body,
Hey,
thanks for replying.
> Your mysql server is not running my friend! =)
>
> Try /etc/init.d/mysqld start <-- this should be able to turn it on!
> You can not change the passwords with the server off
I finally found the correct place to start and did this:
/usr/sbin/mysqld start
but got
Before I start, this is a compile problem (or so I
think) and from what little I read in this forum, it
looks ok to post. If not and you know the proper place
to post, please let me know. Now for the good
stuff
I'm attempting to write a simple tool in C that needs
to be compiled statically wit
Installing 4.0.18 on a Mac OS X 10.3.3 system
creates the "data" directory and its contents
as owned by "root" instead of "mysql."
I tried blowing away the data/mysql directory and
running scripts/mysql_install_db. I tried logging
in as root and doing a recursive chown. Finally
I deleted everythi
Your mysql server is not running my friend! =)
Try /etc/init.d/mysqld start <-- this should be able to turn it on!
You can not change the passwords with the server off
Best Regards
On Wed, 2004-03-17 at 14:04, [EMAIL PROTECTED] wrote:
> (newbie warning)
> Hi,
> I just removed 3.23 and installed
At 10:04 -0800 3/17/04, [EMAIL PROTECTED] wrote:
(newbie warning)
Hi,
I just removed 3.23 and installed 4 (the first time I have done an
installation.) as per the docs I then tried to make a password for
"root" and ran this from SSH root:
# /usr/bin/mysqladmin -u root password 'jman77'
but got
At 15:02 -0300 3/17/04, Geilson Coutinho Figueiredo wrote:
Hi,
I would like to know what happen when I create an table without a
Primary Key. Does MySQL create an "hide" primary key?
For InnoDB and BDB, yes.
Otherwise, no.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQ
(newbie warning)
Hi,
I just removed 3.23 and installed 4 (the first time I have done an installation.) as
per the docs I then tried to make a password for "root" and ran this from SSH root:
# /usr/bin/mysqladmin -u root password 'jman77'
but got this a reply:
/usr/bin/mysqladmin: connect to s
Hi,
I would like to know what happen when I create an table without a
Primary Key. Does MySQL create an "hide" primary key?
Regards,
Geilson Coutinho Figueiredo.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAI
I have some tables for placing orders. Depending on the department, an
order must be approved by 1, or more, specific approvers.
create table department (
deptID int not null,
deptName varchar(32),
...
)
create table approvers (
deptID int not null,
appS
Is there a simple php script out there somewhere (or an example of how to do
it) to create a new database, username and password? I would like to have a
form in a password protected folder on my web site and be able to fill in
those three variables to create a new database on my installation of my
i did the update to 10.3.3 (client) yesterday without a hitch. it's probably a good
idea to do a backup anyways.
> --
> From: Scott Haneda
> Sent: Tuesday, March 16, 2004 6:21 PM
> To: MySql
> Subject: OS X 10.3.3 and byte ordering update
>
> I saw a little blip ab
Richard Carlier <[EMAIL PROTECTED]> wrote:
> Bonjour,
>
> "Horizontal" is not the word but I don't know how to explain... and by
> extension how to find in archive of list...
>
> Maybe an example ?
>
> I have this
> +---+---+
> | a | b |
> +---+---+
> |
At 9:01 +0100 3/17/04, Bram Mariën wrote:
Hey
I'm fairly new to MYSQL (installed 4.0.18 yesterday, but have played with it
in the past), and I must say, I'm really really impressed about the speed,
and the easy of administrating the server and it's data!
But, as I've looked through the documentati
Bonjour,
you simply cannot do this. In SQL, every column has one value, everything else
is not normalized, and normalization is required in relational dbms. If you
want to have such a list, you would need to do it in you application, given
it's a (PHP,Java etc) application accessing the database
Bonjour,
"Horizontal" is not the word but I don't know how to explain... and by
extension how to find in archive of list...
Maybe an example ?
I have this
+---+---+
| a | b |
+---+---+
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
> > /usr/bin/mysqldump: Got error: 2003: Can't connect to MySQL
> > server on '212.87.142.236' (111) when trying to connect
> >
> >
> > Permissions are ok and I can modify the complete db with my php
> > scripts.
> >
> > where's the error?
>
> Check
> - that MySQL server is running
> - that you u
On 03/17/2004 9:46 AM, Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 9:39 -0600 3/17/04, David Bourne wrote:
>> I saw this too in an Apple tech note. It would have been nice if
>> they had included version numbers. Was this change made with a
>> version of MySQL that are publicly available? I seem t
Here is the technote URL:
http://docs.info.apple.com/article.html?artnum=107852#sql
It includes directions for dumping and restoring (not that you would
need it Paul, great book).
MySQL is only updated on OS X Server, not the client version of OS X. I
can also confirm that my updated client did
Jochen Kaechelin <[EMAIL PROTECTED]> wrote:
> I use the following Script to backup a remote MySQL-Server.
>
>
> DATUM=`date +"%Y_%m_%d__%H_%M"`
> BACKUPDIR="/home/jochen/SICHERUNG/MySQL_Dumps/debby/$DATUM"
>
> echo ""
> echo "Erzeuge Sicherungvereichnis $BACKUPDIR..."
> echo ""
>
> mkdir -p $B
At 9:39 -0600 3/17/04, David Bourne wrote:
I saw this too in an Apple tech note. It would have been nice if
they had included version numbers. Was this change made with a
version of MySQL that are publicly available? I seem to remember
seeing a dump/reload requirement a few versions ago.
db
Can
I saw this too in an Apple tech note. It would have been nice if they
had included version numbers. Was this change made with a version of
MySQL that are publicly available? I seem to remember seeing a
dump/reload requirement a few versions ago.
db
On 17/03/2004, at 5:18 AM, [EMAIL PROTECTED]
I'm a bit new to mysql replication. Can someone please
explain how to implement the --replicate-do-table
start up option?
Replication is up and running, but I would like to
limit the replication to just two specific tables in
one database only.
Using mysql v4.0.18 Linux/x86
Your advice will be g
"Mike R" <[EMAIL PROTECTED]> wrote:
>
> I am using php with mysql, and after moving my tables to a new server, I am
> suddenly getting this error:
>
> 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 n
I use the following Script to backup a remote MySQL-Server.
DATUM=`date +"%Y_%m_%d__%H_%M"`
BACKUPDIR="/home/jochen/SICHERUNG/MySQL_Dumps/debby/$DATUM"
echo ""
echo "Erzeuge Sicherungvereichnis $BACKUPDIR..."
echo ""
mkdir -p $BACKUPDIR
for DB in db1 db2
do
echo ""
echo "E
Thanks Peter,
Will try out XAMPP.
Regards
-Original Message-
From: Peter Lovatt [mailto:[EMAIL PROTECTED]
Sent: 17 March 2004 10:50
To: Terry Smith; [EMAIL PROTECTED]
Subject: RE: New to MySQL
Hi
To use phpMyAdmin you need a webserver and php installed - the code suggests
you either are
Thanks for the reply. I will have a look at MySQLCC.
Regards
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 17 March 2004 13:30
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: New to MySQL
Why don't you try MySQLCC from the MySQL site?
-Original Mes
I am using php with mysql, and after moving my tables to a new server, I am
suddenly getting this error:
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
'this = 'No', fp_ext = 'No', username = 'jre
My best guess is somewhere around summer, 2005
On Wed, 2004-03-17 at 09:41, Garg, Piyush (EM, GECIS) wrote:
> Hi Everyone,
>
> Can you please tell what is the expected date for the Production release of Mysql
> 5.0.
>
> Many Thanks and Regards,
> Piyush
--
|.
REVOKE ALL PRIVILEGES FROM [EMAIL PROTECTED] seems to be a 4.1 form of the command
(I have 4.0.15) but adding '@localhost' did the trick. Thank you.
On Wed, 17 Mar 2004, Michael Stassen wrote:
>
> [EMAIL PROTECTED] wrote:
>
> > I was trying to allocate a new user and I typed something like:
> >
>
I think this was a bug that was fixed in later versions of mysql, but
I'm not totally sure if it actually has been fixed .
I did get past this error though:
Error initializing relay log position: Could not find target log during
relay log initialization
What I had to do was shutdown the whole sl
Hi Everyone,
Can you please tell what is the expected date for the Production release of Mysql 5.0.
Many Thanks and Regards,
Piyush
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
>
> (newbie warning)
> Hi,
> We just got a dedicated host who gave us mysql 3.23,
> they want quite $ a bit to upgrade us which we cant afford so I decided to this this
> myself.
>
> This is on a linux machine.
>
> I have never worked on Linux, only windows.
>
> I have
Why don't you try MySQLCC from the MySQL site?
-Original Message-
From: Terry Smith [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 4:25 AM
To: [EMAIL PROTECTED]
Subject: New to MySQL
I have just started having a look at MySQL. I have the server installed and
running with the
You have a number of options, but to name a couple you could:
.. Use a tool called DBScriptor to export schema/data out of Oracle
and with a few tweaks
it can generate MySQL DDL/insert statements.
.. Use an ODBC "pump" tool like those included with the Borland
tools lik
Dear All,
I have created a table Product1 with columns pid, data, keyword. I had
been requested to create another table Product2 with the columns pid,
cname, itis given that (pid -int - reference to Product1).
My problem is how will i create a second table.
Help needed.
Thanks,
Pramilav
--
M
(newbie warning)
Hi,
We just got a dedicated host who gave us mysql 3.23,
they want quite $ a bit to upgrade us which we cant afford so I decided to this this
myself.
This is on a linux machine.
I have never worked on Linux, only windows.
I have downloaded the necessary file/s to do this after
Take the following InnoDB table in MySQL 4.1.1-alpha:
create table tt1 (
r1 int(10),
key (r1),
constraint r1 foreign key (r1) references pfwuser(usrid)
) type=InnoDB;
If I try to change the column type like this:
alter table tt1 modify r1 varchar(255);
I get an error:
mysql> alter table t
"Lorderon" <[EMAIL PROTECTED]> wrote:
>
> How can I define a column of BLOB (or TEXT) with exact length of 1024 bytes?
No.
> Can I index it?
You can index prefix of the column.
>
> I want to run a select query using FIND_IN_SET function on that column.. but
> I'm afraid it will be slow.. any
Mirza,
> Does anyone knows where to find headers and libraries for mysql
> development on Cygwin platform? thanks.
This has been discussed before.
A quick search through all lists on http://lists.mysql.com/mysql shows
that the win32 list is probably the better place to ask Cygwin-related
questi
Hi
To use phpMyAdmin you need a webserver and php installed - the code suggests
you either are not running through a webserver or that it is not configured
for php.
If you are not developing for php you might take a look at windows front
ends for mysql - search the list for recommendations
HTH
I have just started having a look at MySQL. I have the server installed and
running with the default settings and I now need to create a database and
tables. I will be testing all locally on WinXPpro.
I would like to use phpMyAdmin but am having some trouble displaying the
index.php page. IE show
HI!
Sorry for taking so much time to answer, i been away of town!.
Glad to hear it worked! =)
Best Regards!
On Mon, 2004-03-15 at 12:43, Chris Sanchez wrote:
> Hola,
>
> I made 4 changes and it worked. changed 3306 and mysql.sock for both
> client and server, now it works fine. Those two op
Does anyone knows where to find headers and libraries for mysql
development on Cygwin platform? thanks.
Mirza Hadzic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Everybody,
Is there any way we can tranform the Stores procedure and Triggers present under
Oracle Custom Application to mysql.
Please tell ways or any tools which can help us rewrite the logic in Mysql.
Thanks and regards,
Piyush
--
MySQL General Mailing List
For list archives: http://lists
Udbhav Shah <[EMAIL PROTECTED]> wrote:
> Hi Everybody
> Commands:
>
>> mysql -uroot
> mysql> grant select,insert,update,delete on
> try.TBL_MACIP to 'tryAdmin1'@'localhost';
>>mysql -utryAdmin1
> mysql> use try
> mysql> select * from TBL_MACIP;
>>/etc/init.d/mysql restrat
>>mysql -utryAdmin1
> mys
Prasad wrote:
Hi,
I am developing a database in mysql 4.Is it possible to downgrade the same
into mysql 3.23.If its possible then how?
Refer to http://www.mysql.com/doc/en/Upgrade.html. It talks about both
upgrade and downgrade
--
MySQL General Mailing List
For list archives: http://lists.mysq
Udbhav Shah wrote:
Hi Everybody
Commands:
mysql -uroot
mysql> grant select,insert,update,delete on
try.TBL_MACIP to 'tryAdmin1'@'localhost';
mysql -utryAdmin1
mysql> use try
mysql> select * from TBL_MACIP;
/etc/init.d/mysql restrat
mysql -utryAdmin1
mysql>use try
ERROR 1044 (42000): Access denied
Lorderon wrote:
"Chris Nolan" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Which version of MySQL?? The difference will be different (!!) depending
on the version in use.
In general, full text search uses a tree-structure. Doubling the number
of entries in the tree is likely to r
Bram Mariën wrote:
Hey
I'm fairly new to MYSQL (installed 4.0.18 yesterday, but have played with it
in the past), and I must say, I'm really really impressed about the speed,
and the easy of administrating the server and it's data!
But, as I've looked through the documentation, I miss the presc
Hey
I'm fairly new to MYSQL (installed 4.0.18 yesterday, but have played with it
in the past), and I must say, I'm really really impressed about the speed,
and the easy of administrating the server and it's data!
But, as I've looked through the documentation, I miss the prescence of
'ROLE' in M
74 matches
Mail list logo
