So sprach Graeme B. Davis am Tue, May 01, 2001 at 01:09:15PM -0400:
> Ok I was thinking that you had to tell LAST_INSERT_ID the table you wanted
> to get the last insert id from. What if you run a web site and you have 10
> tables in a database, how can you tell what the last insert id of table 6
Hello mysql,
Any ideas how this may happen:
Mysql version 3.23.37, auto recovery turned on.
mysql> check table layers_st50.g00stat_sitepaths;
+---+---+--++
| Table | Op| Msg_type | Msg_text
Subject: rotating binary log files...
Can anyone shed some light on how we should be rotating the binary log
files?
I am running version 3.23.37.
In the manual it states to flush the logs, or execute a refresh command and
that would close the existing log file and rename it to .1 extension an
Rolf Hopkins wrote:
>
> While you can use space in column names, it is not a very good idea as some
> systems can't handle spaces. Your just begging for trouble if you do use
> space. Better to use underscores instead.
>
> - Original Message -
> From: "Mohamad Ilhami" <[EMAIL PROTECTED]
On 04-May-01 [EMAIL PROTECTED] wrote:
> Hi Paul,
>
> I am now confronted with another problem. I need to also provide a CSV
> version.
> I need to use , seperated and " protected text. I have a copy of phpMyAdmin
> that will
> export to this format, but I need to use this at the shell.
> I h
> >I've recently moved from MS-SQL Server 7.0 to mySQL. In MSSQL I
> >used to give the default value 'GetDate()' for a field in the
> >database with the datetime datatype. In mySQL I tried using Now().
> >But when I insert a new row the datetime field is taking :00:00
> >00:00:00 value
While you can use space in column names, it is not a very good idea as some
systems can't handle spaces. Your just begging for trouble if you do use
space. Better to use underscores instead.
- Original Message -
From: "Mohamad Ilhami" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Fri
Yes, I know from experience, it's the best way to do it.
And if you need to get the number generated by an auto_increment column in
an insert, you can use last_insert_id() (or mysql_insert_id() with php).
> Thank you Chris with this info! This will greatly help me out, so as I see
> it now, ther
These are usually FAQs but your getting both which seems strange. "mysqld
ended" usually means that mysqld has already started but the other says it's
not. What does "ps -ef | grep mysql" give you? Also check your
permissions. Log files should be located in /var/lib/mysql
- Original Messag
At 8:37 AM +0700 5/4/01, Taing Nguon wrote:
>Dear Sir/Madam
>
> I just know that there is a tool to convert database from MS Access
>to Mysql, But I do not know the URL of this tool. Could you tell me this
>URL? Thanks
Check this page and look in the "converters" section. Might be what you
w
At 8:21 PM +0200 5/3/01, stefan mojschewitsch wrote:
>hi list,
>
>i have a problem with DEFAULT NULL value in a varchar field.
>mysql is version 3.23.33.
>
>i want to have an user field in a row, to see who has created the row.
>
> create table minidb.tel (
> id int UNSIGN
At 9:35 AM -0700 5/3/01, Scott Baker wrote:
>That's very odd... Technically pconnect should be a lot faster, not
>sure exactly why it's not. The other thing you might want to look
>at is the MySQL idle timeout (or something like that). That's how
>long your pconnects stay connected if they d
At 11:42 AM -0400 5/3/01, John Silva wrote:
>Hi,
>
>When I try to download the Solaris version of the mySQL GUI all I get is a
>screen full of control characters.
Your browser doesn't recognize that it's s'posed to download the file instead
of displaying it. Try shift-click or control-click or w
At 11:26 AM -0400 5/3/01, David C. Troy wrote:
>Hi, List!
>
>I have a table. The table has columns A, B, and C.
>
>I want User1 to be able to read columns A,B, and C, but I want User2 to
>only be able to read column A.
>
>Is this possible using MySQL columns_priv security?
Yes, use the GRANT sta
At 9:32 AM -0400 5/3/01, Terry Gliedt wrote:
>My apologies for even needing to ask this question, but I've
>spend hours combing through the docs and have not figured this
>out. :-(
>
>The problem is basically how to obtain warnings and the question
>comes in a couple of flavors:
>
>For example if
Thank you Chris with this info! This will greatly help me out, so as I see
it now, there is absolutely no advantage to generating your own unique
numbers manually - just let MySQL do it for you am I correct in this
assumption?
Again, thanks!
Patrick
# http://www.mysql.com/doc/R/e/Replication
Hi,
I think mysql support space in column name and table name, using left
tick " ` " like
create table `my foo` (`foo column` char(10) primary
key);
But phpmyadmin is broken with this. So, What about the standard?
TIA
-ilham-
-
At 4:45 AM -0700 5/3/01, Arthur Smith wrote:
>Hi,
>
>My mysql.sock file was deleted. How do I, either recreate it myself, or
>have mysql do it for me.
>
>Art
Restart the server. It will recreate the socket for you.
--
Paul DuBois, [EMAIL PROTECTED]
I have installed MySQL by running mysql_install_db after completing the
installation of RH Linux 7.1 from scratch. The file seems to indicate
that it installs OK. When I try to start the server from the command
line it get a message that says "Starting mysqld daemon with databases
from /var/lib
At 8:33 AM +0530 5/3/01, Sreevatsava Varada wrote:
>Hi,
>
>I've recently moved from MS-SQL Server 7.0 to mySQL. In MSSQL I
>used to give the default value 'GetDate()' for a field in the
>database with the datetime datatype. In mySQL I tried using Now().
>But when I insert a new row the date
Dear Sir/Madam
I just know that there is a tool to convert database from MS Access
to Mysql, But I do not know the URL of this tool. Could you tell me this
URL? Thanks
Regards
Taing Nguon
-
Before posting, please check:
At 8:13 PM +0100 5/3/01, VVM Ravikumar Sarma Chengalvala wrote:
>Hi,
>1.
>I am using C_API for accessing data from MYSQL.
>2.
>mysql_query() function returns the following values:
>0 if the query is successful
>-1 if the query fails.
No. It returns 0 if the query is successful and NON-ZERO if it
http://www.mysql.com/doc/R/e/Replication_Features.html
Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID, and
TIMESTAMP values.
> This sounds encouraging, but are there any known problems with the MySQL
> replication model currently available?? Would the slave servers have t
>Hi Paul,
>Thanks for the help. I was hoping to accomplish this with MySQl, but in the
>end a script works just as good and this is just the first of several I am
>using. For what it's worth I ended up using sed. Here is is if somone else
>could use it:
>sed "s/ /|/g"
>^This is
For replication, yes, there will be a problem, but
this has anything to do with mysql. You'd have the same
problem with a Sybase identity field replicated to another
database server.
A possible solution is this:
1. have a separate table for generating counter fields.
2. make the replicated
Hi Paul,
Thanks for the help. I was hoping to accomplish this with MySQl, but in the
end a script works just as good and this is just the first of several I am
using. For what it's worth I ended up using sed. Here is is if somone else
could use it:
sed "s/ /|/g"
^This is a tab,
I have a major problem could somebody take a seeress look at this
mysql running on cobalt raq4
I have looked through the archives and looked at the manual
can not find anything to explain this
nothing in the mysql log file
I can not access the databases from the web browser I get empty
data
This sounds encouraging, but are there any known problems with the MySQL
replication model currently available?? Would the slave servers have the
same auto_inc column attributes? Could this conflict somehow with the master
server??
Thanks for the quick reply!
Patrick
# Personnaly, i have found a
Personnaly, i have found autoincrement fields to be rock solid.
I use'em all over the place on a 1 Gb database, web based.
Don't do it manually . You'll end up doing the same thing
that mysql gives you for free.
Christopher Lambrou,
CGL Computer Services, Inc.
Empire State Building,
PMB 1
Erik,
You mentioned 40Gig files on Intel platform -
what OS/DBMS did you use then? How about the performance?
Thanks,
Vadim.
Terry Katz wrote:
>
> Erik,
> If your running Linux on an Intel machine (which I assume it is), then
> you've hit Linux's limit for IA32 and 2.2.x kernels .. If you w
Sergei,
I also have the same problem, but in my case the table size exceeds 2Gb,
average record size being around 50Kb.
I'm running 3.23.37 (i686) on a dual PIII 866/ 1Gb RAM / 36Mb SCSI RAID5 w/
RedHat 7.1 (kernel 2.4).
As I type this message, MySQL is still [fulltext-] indexing one of the t
On Thu, May 03, 2001 at 11:48:44PM +0200, Amund Steinsvik wrote:
> If I do a query in a table that contains 350.000 rows and each row
> is about 20 bytes (the tables total size is about 2MB) will a query
> take up a lot of the processor-speed?
Not if the table is indexed properly...
--
Jeremy D
Hello!
I have a database with about 10 tables in it. In every table I have a
RECORD_ID
field so that I can at least uniquely identify a row if I need to, also its
used in relationships. The question is should I use the AUTO_INCREMENT for
this, or should I manually generate this value, getting the
mysql running on cobalt raq4
have look through the archives and looked at the manual
I can not access the databases from the web browser I get empty
databases
When in at telnet erased all the databases including mysql
ran mysql_install_db
logged back in with the web browser and the tables were
On Thu, May 03, 2001 at 12:12:35PM -0700, Bryan Coon wrote:
>
> Would someone briefly explain to me how MySQL uses threading in a
> multi-processor environment?
Yes.
> Currently I have a Dual 1gHz processor box running RedHat 7.1 with
> the smp kernel. Does this automatically take care of thing
If I do a query in a table that contains 350.000 rows and each row is about
20 bytes (the tables total size is about 2MB) will a query take up a lot of
the processor-speed?
And how will the a query work on a web-page? Fast, or?
All the entrys in the table is int-variables.
-
amund
If you just reply to this message, and include the entire text of it in
the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. You have written the following:
hi,
"j.urban" wrote:
>
> Your statement con
I recevied your mail
thanx
Jitender Joshi
Original Message:
X-Track: 15: 40
Received: from web.mysql.com (192.58.197.162)
by mta112.mail.yahoo.com with SMTP; 03 May 2001 14:28:44 -0700 (PDT)
Received: (qmail 28090 invoked by uid 7797); 3 May 2001 21:02:14 -
Mailin
[EMAIL PROTECTED] wrote:
>
> Stefan,
>
> When you insert a row in a table and you do not specify a value
> for a field, mySQL (and any other DBMNS?) will do the following:
>
> 1. If field accepts null: it will set the value of that field
> to null
>
> 2. If field DOES NOT accept null - no defa
This is very basic I know but...
When I ran the costumized bugzilla appl. of my company I got this error:
Content-type: text/html
Software error:
Can't connect to database server. at globals.pl line 90.
For help, please send mail to the webmaster ([EMAIL PROTECTED]), giving
this error message a
>B.> Perhaps a problem with rights.. (settings in phpmyadmin not being
>saved?)..
>B.> Not using phpmyadmin myself.. did read about it.
>
>None of the programs on the web can access the mysql not just
>phpmyadmin. It was working fine before yesterday and now it just wont
>work. is there anything
>Hello All,
>
>I've bumped into a problem and can't figure out how to solve it.
>If anyone has a spare minute to give me a hint on what's wrong
>I'd apreciate it a lot!
>
>The problem is that when I add 'use index ()'
>to my queries, MySQL doesn't always use the whole key,
>but decides what left-m
>I have this tables :
>
>mysql>select * from bid_history;
>+---++-+---+--+-+
>| domain_id | bid_time | user_id | price | bid_type | proxy_price |
>+---++-+---+--+-+
>| 1 |
>Greetings.
>
>I have two tables that are identical in structure, but each contains
>data for different years.
>
>Here is the desc of the first table:
>
>mysql> desc counts2000;
>+-+-+--+-+-+---+
>| Field | Type
Good Day!
I am working on the MySQL section of a reference manual for PHP and need to
confirm one small detail on the length of SET type columns.
It looks like the MYSQL_FIELD->length value for SET columns is the length of
a string containing the SET elements separated by commas.
Is this right?
Hello B.,
Thursday, May 03, 2001, 11:42:39 AM, you wrote:
>>I set up a couple of databases last night in mysql and every thing is
>>working just fine. Today when I try to access the data it is not there
>>Using phpMyAdmin when I look at the databases that are completely empty
>>of tables and da
Interesting question. This really depends on multiple things (operating
system, table locking, etc.)
LinuxThreads are implemented more like multiple processes sharing memory, so
you will see a benefit from having multiple processors as these threads
(processes) are scheduled across both processo
Stefan,
When you insert a row in a table and you do not specify a value
for a field, mySQL (and any other DBMNS?) will do the following:
1. If field accepts null: it will set the value of that field
to null
2. If field DOES NOT accept null - no default value set: it will
set the field's va
Hi,
1.
I am using C_API for accessing data from MYSQL.
2.
mysql_query() function returns the following values:
0 if the query is successful
-1 if the query fails.
3.
At the same time mysql-C_API documentation specifies
that it returns a non zero number if query is a
failure.Does the function retur
Would someone briefly explain to me how MySQL uses threading in a
multi-processor environment?
Currently I have a Dual 1gHz processor box running RedHat 7.1 with the smp
kernel. Does this automatically take care of things? Is mysql parallelized
at all, or is this inherent in the threading? Ins
hi list,
sorry for posting again, i will learn it.
i have a problem with DEFAULT NULL value in a varchar field.
mysql is version 3.23.33.
i want to have an user field in a row, to see who has created the row.
create table minidb.tel (
id int UNSIGNED NOT NULL AUTO_
stat error seems like a permissions error.
I'd guess it's a permissions problem. Perhaps figure out what user the
process trying to stat the file is running under and then figure out
what permissions that user has on the file in question.
(Also check the directory chain going up for permissi
hi list,
i have a problem with DEFAULT NULL value in a varchar field.
mysql is version 3.23.33.
i want to have an user field in a row, to see who has created the row.
create table minidb.tel (
id int UNSIGNED NOT NULL AUTO_INCREMENT,
tel char(16)
>I set up a couple of databases last night in mysql and every thing is
>working just fine. Today when I try to access the data it is not there
>Using phpMyAdmin when I look at the databases that are completely empty
>of tables and data that also includes the mysql database. If I start up
>telnet
I set up a couple of databases last night in mysql and every thing is
working just fine. Today when I try to access the data it is not there
Using phpMyAdmin when I look at the databases that are completely empty
of tables and data that also includes the mysql database. If I start up telnet and
go
Hello,
how I can set Permission on Tables and Columns?
I have create a user "Hugo" with no permissions in the user, hosts and db table.
Then I type:
grant select(Sp1,Sp2), update(Sp2) on MyTestBase.Tab1 to hugo@localhost;
grant select on MyTestBase.Tab1 to hugo@localhost;
flush privileges;
in th
That's very odd... Technically pconnect should be a lot faster, not sure
exactly why it's not. The other thing you might want to look at is the
MySQL idle timeout (or something like that). That's how long your
pconnects stay connected if they don't transfer any traffic. I think it
defaults
There are a few options here.
First off, when making the query, just put the NOW() statement into the
tableit's only a few extra keys to type, and it really isn't that
difficult.
The second option is using the TIMESTAMP type...take a look, it's probably
what your looking for :)
- Origin
Thanks for the reply!, Scott! I considered changing the number of
allowed connections but I figured this would just defer the problem,
as the root problem was the increasing number of connections.
Last night I went through the entire website looking for code that
used mysql_pconnect() in PHP,
One of the best Windows clients for editing queries is
urSQL
(http://www.urbanresearch.com/software/utils/urbsql/urquery.php)
--- Sander Pilon <[EMAIL PROTECTED]> wrote:
>
> But... there are numerous mysql clients available,
> also for windows. I
> bet you can find one with fine edit capabilities
At 5:34 PM +0800 3/14/01, Sudhir wrote:
>Hi,
>
>I am a Sudhir, working as a Software Consultant in Unidux Technologies,
>Singapore. My job here is to suggest Technology. Now we are planning to
>purchase license for the application server JRun. Currently we are
>developing a procurement engine i
hi
can i do a query in a udf?
if so how?
if not then it's more complicated:
i want for security reason that a certain user make a query to the
database and receive the result, but i don't want the user to modify the
query except the where field=variable, so i want to create a function
that do th
Hi,
When I try to download the Solaris version of the mySQL GUI all I get is a
screen full of control characters.
I am attempting this from the following web page:
www.mysql.com/downloads/gui-clients.html
Any help you can give would be appreciated.
John Silva
Senior Engineer
Mesh Networks, Inc
Hi, List!
I have a table. The table has columns A, B, and C.
I want User1 to be able to read columns A,B, and C, but I want User2 to
only be able to read column A.
Is this possible using MySQL columns_priv security?
Thanks,
Dave
===
For some reason the tables BDB corrupt.
Last night it leaves running programs (implemented in C) that consults and
modifies these tables and in morning one of the indexes was corrupt.
All the programs use mysql_close to close the connection to the database.
Look the query i did today of morning
i have a strange problem here;
/usr/local/libexec/mysqld: Fatal error: Error message file
'/usr/local/share/mysql/english/errmsg.sys' had only 194 error messages,
but it should have at least 205 error messages.
Check that the above file is the right version for this program!
010501 22:23:59 m
Hi,
I wanna know how many INSERT queries my MySQL server can resolve in a
second? What benckmark should I use or how should I do this?
I've read something in the manual about looking for sql-bench, but it's
nowhere on my pc. Is it possible that it's not installed??
Greetings,
Raf
_
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Bye..
Stefan Linges
- Original Message -
From: "Marco Battistoni" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 1:17 PM
Subject: U
No editing?!? Psch... louzy programmers.
( see http://www.jpsoft.com/index.htm for proof that consoles in NT/2K
consoled can edit just fine, etc.)
But... there are numerous mysql clients available, also for windows. I
bet you can find one with fine edit capabilities in the contrib section.
( I
> I'm new with Mysql database there is anybody that could explain to me how
to
> create an user in a specific database with encrypted password?
simply use MySQL-Front (www.mysqlfront.de) - adding users with specific
restrictions is very easy there.
Greetings,
Ansgar
-
I think I remember getting around it by installing "binutils" from the GNU site.
That's generaly the problem with solaris. Open source is GNU centric, Solaris
prior to 2.8 is definately NOT.
"EXT-Chung, Kenneth" wrote:
>
>Thanks. I got the gtar from the download page.
>
>Now I have unpa
My apologies for even needing to ask this question, but I've
spend hours combing through the docs and have not figured this
out. :-(
The problem is basically how to obtain warnings and the question
comes in a couple of flavors:
For example if one does "update tbl set my_int='21.3 a' where
my_key
I'm new with Mysql database there is anybody that could explain to me how to
create an user in a specific database with encrypted password?
I'll tank you very much
Marco
_
Get Your Private, Free E-mail from MSN Hotmail a
GGreg . writes:
> Hi,
>
> I've installed the mysql++ RPM under my Mandrake 7.2 and it works.
> After that, yhen I'm trying to compile a src file :
>
>
> #include
> #include
> #include
>
> int main() {
>
>Connection con("MISDIS","localhost","root","DisMis");
>
>Query query = con
Andreas Metzner writes:
> Hello all,
>
> I'm using the libmysql.dll API to interface to a mySQL-Server Database.
> The GUI client is generic, so the user can bind any SELECT query on
> a large database (Logging database).
>
> How can I prevent the mySQL client to use mysql_store_result (),
> sin
Hi,
I've recently moved from MS-SQL Server 7.0 to mySQL. In MSSQL I used to give the
default value 'GetDate()' for a field in the database with the datetime datatype. In
mySQL I tried using Now(). But when I insert a new row the datetime field is taking
:00:00 00:00:00 value. Please let
On Thu, May 03, 2001 at 08:01:11AM -0400, Marc Bragg wrote:
> Hi:
>
> Installed redhat 7.0 and had multiple mysql problems, but php4 from the
> disc seemed fine. Updated mysql to 3.23.37, now it works fine, but "php"
> gives me:
>
> PHP Warning: Unable to load dynamic library '/usr/lib/php4/mysq
you could download the sources of php (4.0.5) and compile it with following
commands:
./configure --with-mysql=/your/path/to/mysql (append here all the other
configurations you would like to use)
make
make install
and normaly this should work..
you might need to edit the httpd.conf file ..
st
Hi,
My mysql.sock file was deleted. How do I, either recreate it myself, or
have mysql do it for me.
Art
__
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Hi:
Installed redhat 7.0 and had multiple mysql problems, but php4 from the
disc seemed fine. Updated mysql to 3.23.37, now it works fine, but "php"
gives me:
PHP Warning: Unable to load dynamic library '/usr/lib/php4/mysql.so' -
libmysqlclient.so.9: cannot open shared object file: No such file
Hi!
To resolve a problem in the MySQL parser I decided to change the
syntax of SELECT ... FROM ... WHERE ... IN SHARE MODE so that
an additional word LOCK is added before IN SHARE MODE.
The change will be effective in 3.23.38.
An example:
SELECT * FROM T WHERE A = 5 LOCK IN SHARE MODE;
The ben
Nandana,
MySQL does not currently support stored procedures or triggers.
The solution is to code the logic in the application. If Java allows
the use of interpreted code, you could maybe store some Java procedures
in TEXT fields in your database. Then your applications could fetch
them from the
Sudhir wrote:
>
> Hi,
>
> I am a Sudhir, working as a Software Consultant in Unidux Technologies,
> Singapore. My job here is to suggest Technology. Now we are planning to
> purchase license for the application server JRun. Currently we are
> developing a procurement engine in Java, using MyS
>Please read "Security" section of the manual to find out how to run mysqld
>as root!
>010503 16:57:03 Aborting
>
>mysqld ended on Thu May 3 16:57:03 SGT 2001
>
>anyone have idea on this?
Perhaps exactly what the message says :-) You tried to run mysqld as root.
You should run mysqld as user
Hi,
I am a Sudhir, working as a Software Consultant in Unidux Technologies,
Singapore. My job here is to suggest Technology. Now we are planning to
purchase license for the application server JRun. Currently we are
developing a procurement engine in Java, using MySql as the data base
server.
I have this tables :
mysql>select * from bid_history;
+---++-+---+--+-+
| domain_id | bid_time | user_id | price | bid_type | proxy_price |
+---++-+---+--+-+
| 1 | 2001050
Hi,
I've installed the mysql++ RPM under my Mandrake 7.2 and it works.
After that, yhen I'm trying to compile a src file :
#include
#include
#include
int main() {
Connection con("MISDIS","localhost","root","DisMis");
Query query = con.query();
query << "select * from Wizard"
mysqld started on Thu May 3 16:57:03 SGT 2001
Please read "Security" section of the manual to find out how to run mysqld as root!
010503 16:57:03 Aborting
mysqld ended on Thu May 3 16:57:03 SGT 2001
anyone have idea on this?
It's just a quick thought, and may not be relevant at all, but ...
If you have a tail on the mysql log file that is doing something with blobs
(binary objects), sometimes the bell character turns up and causes your
system to beep. It worried me untill I realised what was happening.
May not be m
Hi,
I have a date in a string like so "May 02, 2001 09:15:57" and this date is
not a standard MySQL date and so it wont insert correctly.
My question is this, is there a function to convert the date to something
that MySQL can understand or do I have to convert it manualy?
Thanks in advance.
A
How can I install mysql into raq4?
>I just want to create a webbased mailing tool using
>PHP/Mysql...I've done using the fuction mail()...But if i need to have a
>option 'Attachment' then in which way i can do that.
This_is_a_PHP_question.. have a look at the manual at www.php.net also,
checkout www.phpbuilder.com www.devshed.co
At 22:00 2-5-01 -0600, Al Green wrote:
>When I try to run mysqld I get the following message. How do I rebuild the
>.sock
>file. It is not where it should be and the one's that are there are 0 bites
>Any suggestions
The size is right. If the .sock can't be found point to the right location
in y
93 matches
Mail list logo
