Greetings list,
I'm having a MySQL login problem that I cannot figure out, and (surprise
surprise), I'm something of a newcomer to MySQL. I have read two decent
MySQL books, searched the MySQL.com online manual, and searched the web for
everything I can think of, to no avail.
Here is my problem
>
>
> Or you can add
>
> safe_show_database
>
> to your my.cnf, or call safe_mysqld with the added option "
> --safe_show_database"
do you have to compile mysql with some special parameter? My version
(3.23.37, SuSE rpm) fails with a "unrecognized command" error when I try to
start it after havin
Is it an option to drop the table and recreate and repopulate it?
I would give it a try and think that your problem will be gone.
You can easily do that with mysqldump. Ask again if you need more
help.
Alex Pukinskis schrieb am Mittwoch, 22. August 2001, 22:48:26:
> I've made some progress fi
Calvin Xu schrieb am Donnerstag, 23. August 2001, 03:16:09:
> select subject,subhead,subsubhead,data2,data3,see_also
> from npl_detail where ( (subject like '% asia %' OR
> subhead like '% asia %' OR subsubhead like '% asia %'
> or data2 like '% asia %' or data3 like '% asia %' or
> see_also li
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: uninitialized data
>Description:
uninitialized data in "insert" and
On 22 Aug 2001 17:35:58 +0100, Elizabeth Alderton wrote:
> If I do a SELECT query to bring data down to a PC (this is being done
> through Delphi) how can I encrypt the data so that it comes safely?
>
> Equally when doing UPDATE and INSERT in the other direction I would want to
> encrypt the data
On Thu, Aug 23, 2001 at 08:35:44AM +0800, Osman Omar wrote:
> I have these data inside my tables
>
> id modelname datein
> 1 str-de345 20010901
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php (th
Are you sure its not the full page ads and embedded ad-spam in cnet
articles?
"s. keeling" wrote:
>
> On Wed, Aug 22, 2001 at 03:19:43PM -0600, Sasha Pachev wrote:
> >
> > Just to make it difficult for people to migrate to Oracle, the only
> > documentation that we provide for the PASSWORD() fu
On Wed, Aug 22, 2001 at 06:24:45PM -0600, s. keeling wrote:
>
> I just don't get it. Oracle promises features that never seem to
> work 'til years afterwards, costs a mountain of money, and (for
> instance) SQL*Plus is garbage compared to mysql-client.
As I drove my Oracle's world headquarters
Hello there,
I couldn't send email out from my mysql server so I
couldn't use mysqlbug to report the problem. I am
trying to enter the information in the mysqlbug
format:
>Description:
The following sql statement couldn't return me
results:
select subject,subhead,subsubhead,data2,data3,see_als
http://devshed.com/Server_Side/MySQL/Intro/
At 11:22 AM 8/22/2001 -0500, randys wrote:
>I am a user whom it loves to use the services of mysql, but do not have
>like beginning, please to send the manuals to me of as to begin to work
>this fabulous manejador of data base
>
>att. randy ochoa
Ch
On Wednesday 22 August 2001 16:14, you wrote:
> is there a way in Perl/DBI to select the possible values of a set or
> enum type? this can't be dependant on on querying actual records, but
> querying the data itself. Of course this is outside of doing a desc and
> parsing the output information
I have these data inside my tables
id modelname datein
1 str-de345 20010901
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To reques
On Wed, Aug 22, 2001 at 03:19:43PM -0600, Sasha Pachev wrote:
>
> Just to make it difficult for people to migrate to Oracle, the only
> documentation that we provide for the PASSWORD() function algorithm is the
> source :-)
>
> On a serious note, what is it that makes MySQL not good enough for
Nope, didn't solve it. I added that to the mysqld command and restarted
it (checked with ps -ef to make sure it took) and it still does it.
Sasha also suggested that I try using straight IP addresses everywhere,
and I did that, but it hasn't helped yet.
Thanks for the suggestion, though.
Tim
> We're having problems with connecting to our MySQL database after making
> some changes to our system. Unfortunately, we had to reassign it's IP
> address and, at the same time, our customer wanted to change the domain
> name for the system. Changing both seems to have been a bad thing.
>
> Now,
Date |22 Aug 2001 16:32:32 -0500
>From |Roger Davenport <[EMAIL PROTECTED]>
Hello!
RD> Can mysql support mucroseconds in the datetime field?
RD> mydate datetime(14,4) for instance? I havn't had success so far ;-)
RD> Roger
RD> p.s. please cc me, as I am not part of the list. TIA
No, mysql d
- Original Message -
From: "Mike Jackson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Stefan Hinz" <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 1:59 PM
Subject: Re: ldap authentication for mysql
> PHP is not the solution. On the other hand, Zope just might be... I am
> studyi
At 15:45 2001-08-22 -0400, Ide, James J Mr CMH/LGB wrote:
Hi!
My guess is that the append query is too much heavy for
Access, then try to emigrate the data (if possible)
using filter on the append query to make it with
several steps.
Other option is to use, other goods clients programs
that you f
On Sun, Aug 19, 2001 at 10:21:46AM -0400, Philip Mak wrote:
> On Sun, 19 Aug 2001, Sinisa Milivojevic wrote:
>
> > If this is happening on Windows, we truly can not do anything about
> > it.
> >
> > You could help there by forcing all table names to be lower-case by
> > starting mysql service wit
I always grant all on a particular database to the user who's purchased
the service. I reserve the right to add and delete users, but you could
set up a web page for users to add and remove users for their own
database. making it idiot proof and not exploitable by the script kiddies
would be to
On Wed, Aug 22, 2001 at 10:45:58AM -0700, Jason Brunk wrote:
>
> i read somewhere that you can setup virtual mysql servers, so that
> users can actually have their own sql server to administer with
> whatever databases they want to create, with out interferring or
> even seeing other peoples datab
I read the mannual to use InnoDB.
following is my c:\my.cnf file. I am still getting above message. I
tried with 3.23.39a-win and also with mysql-3.23.41-win.zip. I do have
data and logs directory created.
Please help
vitthal
# Example mysql config file for medium systems.
#
# This is for a syst
Hi!
> "Peter" == Peter Zaitsev <[EMAIL PROTECTED]> writes:
Peter> Hello mysql,
Peter> I was trying to load very huge (5GB 45mil rows) to the text dump in
Peter> sorted order (according to primary key).
Peter> The problem is mysql somehow does not wants to scan the table by
Peter> pr
On Wednesday 22 August 2001 15:40, you wrote:
> We're having problems with connecting to our MySQL database after making
> some changes to our system. Unfortunately, we had to reassign it's IP
> address and, at the same time, our customer wanted to change the domain
> name for the system. Chang
On Wednesday 22 August 2001 15:37, you wrote:
> Can mysql support mucroseconds in the datetime field?
>
> mydate datetime(14,4) for instance? I havn't had success so far ;-)
No, it cannot, at this time. We might consider adding it in 4.0. For the time
being, you will have to resort to a hack w
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Andy Yates writes:
>> Is there a symbol file for the mysqld in MySQL-3.23.41-1.i386.rpm? If so
>> where is it? MySQL keeps crashing and I'm trying to look at the stack
>> trace.
>>
>> Thanks!
>>
>> Andy
Sinisa>
Or you can add
safe_show_database
to your my.cnf, or call safe_mysqld with the added option "
--safe_show_database"
See http://www.mysql.com/doc/S/H/SHOW_VARIABLES.html for more information.
"Stefan Hinz" <[EMAIL PROTECTED]> wrote:
Dear Ulv,
> My problem is that every user sees every oth
Hi!
> "werner" == werner writes:
werner> Ulv Michel schrieb am Mittwoch, 22. August 2001, 11:53:01:
>> Hi all,
>> I am running a webhosting server using SuSE 7.2 /mysql 3.23 /php 4. We are
>> hosting a small amount of virtual servers, allowing our customers to user
>> php and mysql. My p
Can mysql support mucroseconds in the datetime field?
mydate datetime(14,4) for instance? I havn't had success so far ;-)
Roger
p.s. please cc me, as I am not part of the list. TIA
-
Before posting, please check:
http://
We're having problems with connecting to our MySQL database after making
some changes to our system. Unfortunately, we had to reassign it's IP
address and, at the same time, our customer wanted to change the domain
name for the system. Changing both seems to have been a bad thing.
Now, with ev
On Wednesday 22 August 2001 15:12, you wrote:
> >> http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
> >> PASSWORD() encryption is non-reversible. PASSWORD() does not perform
> password encryption in the same way that Unix passwords are encrypted.
>
> Hello,
>
> we are using mysql passw
Jeremy Zawodny wrote:
>
> On Wed, Aug 22, 2001 at 05:03:05PM +0200, Stefan Hinz wrote:
> > Dear Jeremy,
> >
> > > > Is there currently a way for mysql to take it's users
> > > > and passwords from an ldap server?
> >
> > > There is not.
> >
> > There is: It's called PHP ;-)
> >
> > See http://php
I've made some progress figuring out my case issue. It seems that somehow
I'm ending up with shadow tables. I discovered this after I ran an ALTER
command. My db has 4 tables:
mysql> show tables\g
+-+
| Tables_in_hbperfrev |
+-+
| employee|
|
Date |Wed, 22 Aug 2001 10:49:47 -0700
>From |"Jason Brunk" <[EMAIL PROTECTED]>
Hello!
JB> i have noticed something, i have ported some asp, and visual basic applications
from MSSql to MySql, and i have noticed something with the dates, i have to change my
entire date format. Does anyone know
is there a way in Perl/DBI to select the possible values of a set or
enum type? this can't be dependant on on querying actual records, but
querying the data itself. Of course this is outside of doing a desc and
parsing the output information in my code itself. but more like:
select possibil
Hans Zaunere schrieb am Dienstag, 21. August 2001, 17:27:47:
> Can someone explain to me when and when not to use
> single, double, or no quotes at all around values in a
> query. I noticed when I updating an enum field I
> needed a quote, but not when updating an int field.
> Or could someo
I use a random key generating SHA-1 js module for all my encryption for
passwords. You could do something the same using a fixed key system so that
once it's on the server you can decrypt it. However, I haven't tried it yet
with SHA-1 so don't know how difficult or sane it would be to try.
chuc
Hello!
I have two tables. One contains invoices, one contains customers.
How do I delete customers that are not linked to any invoice.
The relation is one to many (invoices --> customers).
I can select them with:
select customers.* from customers left join invoices on
invoices.cust_id=custome
Curtis Maurand schrieb am Mittwoch, 22. August 2001, 21:17:40:
> A caveat is that you get the last_insert_id for your connection. Not the
> last one in the database.
I'm puzzled. There is no last_insert_id of the database, only of
a certain table, and it is indeed the one last manipulated. S
My setup:
Dell PowerEdge 4200 with 512 mb ram, plenty of free disk space
WinNT Server 4.0 with sp6
MS Access 97
MySQL 3.23.38-nt (installed binany from mysql-3_23_38-win.zip)
MyODBC 2.50.38 (installed from myodbc-2_50_38-nt.zip)
My objective:
Copy data from two large MS Access 97 to MySQL tabl
What do you mean by "bring data down?" Would this be over a network? If
so, what OS would the other machine be running? I'll assume it's Unix
because that's my favorite. Seeing that mysql prints to STDOUT you could
write a script to interface with MySQL, get the output, encrypt it, and then
se
#1 no.
#2 yes. run /usr/sbin/setup and go to system services. Then check off
the mysql entry and save it.
or you can put "/etc/rc.d/init.d/mysqld start" in your rc.local file,
HTH
Curtis
On Wed, 22 Aug 2001 [EMAIL PROTECTED] wrote:
> Good Morning.
>
> I recently installed mysql-3.23.41-pc
A caveat is that you get the last_insert_id for your connection. Not the
last one in the database.
Curtis
On Wed, 22 Aug 2001, Dr. Werner Stürenburg wrote:
>
>
> Jari Mäkelä schrieb am Mittwoch, 22. August 2001, 14:57:06:
>
> > At 13:19 22.8.2001 +0200, you wrote:
> >>LAST_INSERT_ID() should
http://www.mysql.com/ es la pagina de mysql. Desde alli puede encontrar
la documentacion - en varios formatos- es de las mejores que pueda
conseguir.
Happy reading,
---
Claudia M. Castaneda
Phone 301 286 3397
On Wed, 22 Aug 2001, randys wrote:
> I am a user whom it loves to use the se
Are instructions available for building the MySQL source tree on a Win32 platform for
a Win32 target!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
> >a good editor to use when working on MySQL and PHP code please?
> >I use WinNT and 2000 platforms and am new to Open System tools (although
> >'old' in the business).
>
> I don't understand the relation between the use of an editor and the Open
> Source
> systems.
Claudio,
M$ dev tools tend
On Wed, Aug 22, 2001 at 05:03:05PM +0200, Stefan Hinz wrote:
> Dear Jeremy,
>
> > > Is there currently a way for mysql to take it's users
> > > and passwords from an ldap server?
>
> > There is not.
>
> There is: It's called PHP ;-)
>
> See http://php.net/manual/en/ref.ldap.php and
> http://ph
Sasha,
Hey that works for me. I'm personally not to fond of HTML email any ways
;-)
Sasha Pachev wrote:
>
> On Wednesday 22 August 2001 01:53, Colin Faber wrote:
> > Sasha,
> >
> > Are you sure its working?
>
> That is a bug in the filter, or rather a lack of feature. It is currently
> treats
We've had a lot of shakeups recently because of our DSL service going out
of business. While shifting over, we also changed our primary Domain name
for the site. I'm not an expert at configuring networks, and especially
not at configuring MySQL, so I'm thinking these problems are my own doing.
On Wed, 22 Aug 2001, Eugene Reuter wrote:
> I am running MySql 3.23.40-max on Caldera OpenUnix8/LKP with Apache
> 1.3.20/php4.0.6. I just installed it and I am testing it.
> After I installed php, I tested it with simple php side and after 5 or 6 hits.
> I am getting:
> Warning: Can't create a ne
>> http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
>> PASSWORD() encryption is non-reversible. PASSWORD() does not perform
password encryption in the same way that Unix passwords are encrypted.
Hello,
we are using mysql password() function to encrypt users' passwords (I mean
the users
What about
SELECT id FROM table WHERE ok=1 AND type=1 and field like '%text'.
MySQL would have chance to create a temp table, reduce its contents via
ok=1 AND type=1 and then do the expensive like '%text%' matches...
Just my $0.02,
Guus
> -Original Message-
> From: Osus [mailto:[EMAIL
Elizabeth Alderton schrieb am Mittwoch, 22. August 2001, 17:00:53:
> If I do a SELECT query to bring data down to a PC (this is
> being done through Delphi) how can I encrypt the data so that
> it comes safely?
> Equally when doing UPDATE and INSERT in the other direction I
> would want to enc
> > Created a table which will be used to track/process URLs:
> > CREATE TABLE dbURLlist(
> > IDSMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
> > AGING TINYINT UNSIGNED * ,
> > URL TINYTEXT NOT NULL,
> > PRIMARY KEY (ID),
> > INDEX (URL (25)))
> >
> > In a PHP script (a
Jason Brunk schrieb am Mittwoch, 22. August 2001, 19:45:58:
> i read somewhere that you can setup virtual mysql servers, so
> that users can actually have their own sql server to administer
> with whatever databases they want to create, with out
> interferring or even seeing other peoples datab
If I do a SELECT query to bring data down to a PC (this is being done
through Delphi) how can I encrypt the data so that it comes safely?
Equally when doing UPDATE and INSERT in the other direction I would want to
encrypt the data.
Can anyone help please?
We can't afford to use ssh - we would h
On Wednesday 22 August 2001 01:53, Colin Faber wrote:
> Sasha,
>
> Are you sure its working?
That is a bug in the filter, or rather a lack of feature. It is currently
treats everything after the header as the boby, and it accepted
"quoted-printable" in the header of one attachment part because
The slow queries are those like...
SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1
WHERE field like '%text%' <-- this will not use an index. Read the manual
about fulltext. It may or may meet your needs. It works pretty good. If the
text is a word you could also buil
Hello!
I have two tables. One contains invoices, one contains customers.
How do I delete customers that are not linked to any invoice.
The relation is one to many (invoices --> customers).
I can select them with:
select customers.* from customers left join invoices on
invoices.cust_id=customers
mysql> explain select * from dominf.domip order by ip desc;
'ORDER BY something DESC' does not use an index. It must be ascending. See
the manual.
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please
On Tuesday 21 August 2001 23:30, Alexander Skwar wrote:
> So sprach »Sasha Pachev« am 2001-08-21 um 19:51:25 -0600 :
> > I have updated the filter, this message should make it.
>
> This message arrived 5 times at the list - or at least, I got it 5
> times. All the messages had different times.
>
On 22-Aug-2001 Osus wrote:
> Hi,
>
> The slow queries are those like...
>
> SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1
>
> where table have about 20.000 records and field is a text field.
> I need to find ALL the records that have "text", even if text is "a" i have
> t
Hi!
On Aug 22, Marty McCoy wrote:
> Hi,
>
> I'm performing a FULLTEXT search against varchar columns of one of our
> tables. One of our columns contains embedded serial numbers such as
> "02-123456" and "04-234567". The problem that when I do a FULLTEXT search
> against "02-123456", it bring
If I do a SELECT query to bring data down to a PC (this is being done through Delphi)
how can I encrypt the data so that it comes safely?
Equally when doing UPDATE and INSERT in the other direction I would want to encrypt
the data.
Can anyone help please?
Regards
Elizabeth
On 22-Aug-2001 Jeremy Morano wrote:
> Hi ,
>
> I was wondering if there was a way to retreive a column_name instead of a
> value in an sql select query?
>
> For example if my table has the fieldfirstname, lastname, telephone,
> movie1, movie2, movie3..
>
>
> And my first record is
> Created a table which will be used to track/process URLs:
> CREATE TABLE dbURLlist(
> IDSMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
> AGING TINYINT UNSIGNED * ,
> URL TINYTEXT NOT NULL,
> PRIMARY KEY (ID),
> INDEX (URL (25)))
>
> In a PHP script (also prototyped us
On Wed, 22 Aug 2001, Marty McCoy wrote:
> I'm performing a FULLTEXT search against varchar columns of one of our
> tables. One of our columns contains embedded serial numbers such as
> "02-123456" and "04-234567". The problem that when I do a FULLTEXT search
> against "02-123456", it brings back
At 11:50 2001-08-21 +0200, ARAKON wrote:
Hi!
Try to put the header windows.h before mysql.h and add the
header for the winsock if you are using it.
Regards,
Miguel
>i'm using mysql 3.23.40 for windows, when i try to build one very
>simple application, it shows me that error:
>
>e:\pere\mysql 3
On 22-Aug-2001 Johan Nilsson wrote:
>>> Is it possible for me to do a SELECT COUNT(*) and GROUP BY the
>>answers based
>>> on a INTERVAL e.g. HOUR?
>>>
>>
>>SELECT HOUR(time) as hour,count(*) as cnt FROM foo GROUP BY hour;
>>
>
> Thanks, but I wrote a bad test data =(
>
> +
I am a user whom it loves to use the services of mysql, but do not have like
beginning, please to send the manuals to me of as to begin to work this fabulous
manejador of data base
att. randy ochoa
TextPad works for me.
Sammi
Sammi Thompson
Futura Interactive Ltd
1-5 Clerkenwell Road
London EC1M 5PA
T +44 [0]20 7608 1616
F +44 [0]20 7608 1605
www.futura.com
- Original Message -
From: "DL Neil" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 22, 2001 3:56 PM
At 03:56 PM 8/22/01 +0100, DL Neil wrote:
>Does one of our more experienced brethren know of an article/web page
>comparing offerings/discussing
>a good editor to use when working on MySQL and PHP code please?
>
>I use WinNT and 2000 platforms and am new to Open System tools (although
>'old' in
On Tue, Aug 21, 2001 at 04:08:42PM -0400, Sekaran, Chandra wrote:
> Hi We have a licensed MySQL software.
> I have one question. During Database Maintenance, i don't want users to be
> connected with the database.
> I want to start my database in restricted mode, thereby other than DBA, no
> one c
If I do a SELECT query to bring data down to a PC (this is being done through Delphi)
how can I encrypt the data so that it comes safely?
Equally when doing UPDATE and INSERT in the other direction I would want to encrypt
the data.
Can anyone help please?
Regards
Elizabeth
>
> Besides that theoretical stuff, though, the real problem is that
> INSERT is for inserting new records into a database table. What
> you're trying to do is UPDATE existing records with new data. And
> there's no INSERT ... SELECT counterpart in the UPDATE syntax.
What about replace?
repla
On Wednesday 22 August 2001 16:48, Jeremy Morano wrote:
>
> I was wondering if there was a way to retreive a column_name instead of a
> value in an sql select query?
>
> For example if my table has the fieldfirstname, lastname, telephone,
> movie1, movie2, movie3..
>
>
> And my first reco
At 10:48 AM 8/22/01 -0400, you wrote:
>For example if my table has the fieldfirstname, lastname, telephone,
>movie1, movie2, movie3..
You haven't done a good job of database normalization. Those movies should
be broken out to their own table.
Onto what you were talking about, I kno
hi
from the manual:
"Aborted_clients : This means that something of the following has happened:
· The client program did not call mysql_close() before exit.
· The client had been sleeping more than wait_timeout or
interactive_timeout without doing any requests. See section ·
·
I install MYSQL on Redhat 7.1 using RPMs ...
I start the server the same way you do, but
to start it automatically, i went to the control
panel (GNOME) Programs->System->Control Panel
and enter the services and levels configuration (Run level Manager)
and move the MSQLD service from NON Automatica
Hi,
I'm performing a FULLTEXT search against varchar columns of one of our
tables. One of our columns contains embedded serial numbers such as
"02-123456" and "04-234567". The problem that when I do a FULLTEXT search
against "02-123456", it brings back results with the following values:
...
Hi,
The slow queries are those like...
SELECT id FROM table WHERE field like '%text%' AND ok=1 AND type=1
where table have about 20.000 records and field is a text field.
I need to find ALL the records that have "text", even if text is "a" i have
to find all the records that have one "a".
Man
Dear Mike,
AFAIK you cannot do this with SQL, but you can use PHP. See
http://php.net/manual/en/ref.ldap.php for a description.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
Dear Ulv,
> My problem is that every user sees every other users
> databases. Is there a way to setup mysql so that every local user has
his
> own empty database? Please tell me how this has to be set up.
When they can state "show databases", other users will see databases
where they have no acc
Dear Jeremy,
> > Is there currently a way for mysql to take it's users
> > and passwords from an ldap server?
> There is not.
There is: It's called PHP ;-)
See http://php.net/manual/en/ref.ldap.php and
http://php.net/manual/en/ref.mysql.php
Regards,
--
Stefan Hinz
Geschäftsführer / CEO i
Dear Ben,
there is no need for two separate .sql files (maybe there *is* a need,
you will know ;-)
To dump structures from one database, all tables and all data included,
and with "drop table" so you can restore overwriting existing tables:
mysqldump my_db --add-drop-table > my_db.sql
To r
Created a table which will be used to track/process URLs:
CREATE TABLE dbURLlist(
IDSMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
AGING TINYINT UNSIGNED * ,
URL TINYTEXT NOT NULL,
PRIMARY KEY (ID),
INDEX (URL (25)))
In a PHP script (also prototyped using MySQL-Front) I
Does one of our more experienced brethren know of an article/web page comparing
offerings/discussing
a good editor to use when working on MySQL and PHP code please?
I use WinNT and 2000 platforms and am new to Open System tools (although 'old' in the
business).
Please advise,
=dn
--
At 14:01 2001-08-22 +0200, Yarek wrote:
Hi
>I wanted to install MySQL under Windows 2000 with default-charset=latin2. I
>cannot use binary distribution because it is not compiled with this
>charset. So, I loaded and compiled source for MySQL 2.3.41 under Cygwin
>(Win32,
>POSIX compatible). I rece
i have noticed something, i have ported some asp, and visual basic applications from
MSSql to MySql, and i have noticed something with the dates, i have to change my
entire date format. Does anyone know how to set the way dates are interpreted in
MySQL?
jason
http://mrtg.whitetec.com
Hi ,
I was wondering if there was a way to retreive a column_name instead of a
value in an sql select query?
For example if my table has the fieldfirstname, lastname, telephone,
movie1, movie2, movie3..
And my first record is JohnDoe 555-
good ba
i read somewhere that you can setup virtual mysql servers, so that users can actually
have their own sql server to administer with whatever databases they want to create,
with out interferring or even seeing other peoples databases. Does anyone know how to
do this? could you help me?
jason
Sure this is possible, take a look at the 'grant' command... and for each
local user add their mysql account giving them access to their database
only.. then other users will not be able to read any db but their own.
ryan
- Original Message -
From: "Ulv Michel" <[EMAIL PROTECTED]>
To: <[
Hi,
Try
http://www.avukatpro.com/mysql.html
http://www.dwam.net/MySQL/
Ken
- Original Message -
From: "Pablo Javier Gonzalez Mateos" <[EMAIL PROTECTED]>
To: "Lista MySQL Ingles" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 5:12 PM
Subject: VB with MySQL
> Hello, im new in the lis
Grigory Bakunov wrote:
> Hello!
>
>
> TW> Hi all,
>
> TW> I'm running MySQL Ver 3.23.32 for -freebsd4.2 on i386, With PHP4
> TW> compiled statically into Apache 1.3.17. All connections
> to the database
> TW> are non-persistent connections. It's a pretty busy
> server, hitting
> TW> abou
Hi
I am running MySql 3.23.40-max on Caldera OpenUnix8/LKP with Apache
1.3.20/php4.0.6. I just installed it and I am testing it.
After I installed php, I tested it with simple php side and after 5 or 6 hits.
I am getting:
Warning: Can't create a new thread (errno 11). If you are not out of
av
Good Morning.
I recently installed mysql-3.23.41-pc-linux-gnu-i686.tar.gz onto RH Linux
7.1 via MySQL Manual instructions for "Installing a MySQL Binary
Distribution". I can start the server via safe_mysqld with no apparent
problems.
Question #1:
My Linux/MySQL newbie question...Do you need to
Rafal Jank wrote:
>
> Peter Zaitsev wrote:
> >
> > Hello mysql,
> >
> > I was trying to load very huge (5GB 45mil rows) to the text dump in
> > sorted order (according to primary key).
> > The problem is mysql somehow does not wants to scan the table by
> > primary key to produce sorted o
Jari Mäkelä schrieb am Mittwoch, 22. August 2001, 14:57:06:
> At 13:19 22.8.2001 +0200, you wrote:
>>LAST_INSERT_ID() should return the last autoincrement value of
>>the last insert
> Yep it sure did, managed to get to machine and test it out. Total mess.
> but;
> $query = "SELECT LAST_INSER
1 - 100 of 135 matches
Mail list logo
