hi!
Dynamic shared objects could enable user written code
to be integrated with the server at run time! .
Does MySql support shared objects, since MySql is an
open source database i believe it can support DSO.
If its not true is there any alternative!
In the last episode (Jun 20), Prem Soman said:
hi!
Dynamic shared objects could enable user written code
to be integrated with the server at run time! .
Does MySql support shared objects, since MySql is an
open source database i believe it can support DSO.
Yes, they're called User
Hi, Im hosting a website in a Linux server. By now Im learning PHP and
its amazing. How ever I need to create a online system and meanwhile
Ill to do it in ASP (which I already handle). My host gives me MySQL
and I use it ok. Now, what Ill like to do is to know how to connect my
ASP page to a
Hi!
InnoDB is a MySQL table type which supports transactions, foreign keys, and
a non-free hot backup tool. InnoDB is included in MySQL-Max-3.23 and in all
downloads of MySQL-4.0 and MySQL-4.1. You can download all of these from
http://www.mysql.com.
3.23.57 is a bugfix release of the old stable
Hi!
The following essential change was forgotten from the changelog of 3.23.57
below, though it is listed in the MySQL-3.23.57 changelog:
* Changed the default value of innodb_flush_log_at_trx_commit from 0 to 1.
If you have not specified it explicitly in your my.cnf, and your application
runs
I am currently working on some experiments and have to deal with some millions of
tuples. As you can imagine indexing is essentiall. However My InnoDB file has grown to
over 3.6G and fragmentation is sometimes a big problem. Additionally the file keeps
its size even after dropping the 'big'
thank u nelson!
that was very useful for me. can these UDF's provide a
better way to access the sever specific information
such as the date and number of times the server was
restarted
Want to chat instantly with your
Hi everybody,
Is there any function like Oracle TO_DATE in order to insert a date into a
DATE type field according to a different format than -mm-dd? I wish to
insert a date into a date field but my date format is dd/mm/. If not,
is there any workaround using mysql functions? AFAIK
use DATE_FORMAT(date, format)
e.g:
DATE_FORMAT(1999-12-01, %M %e, %Y) - December 1, 1999
*taken from Paul Dubois MySQL book
BRgds,
--
Richard Bornay
Test Data Managment
ST Assembly Test Services
6824-1367
Marcos Pomar [EMAIL PROTECTED]20/06/2003 05:36 PM
To: [EMAIL PROTECTED]
Hi Marcos,
you can use simple string-functions to manage this.
For example:
dd/mm/ - -mm-dd
CONCAT_WS('-',RIGHT('dd/mm/',4),SUBSTRING('dd/mm/',4,2),LEFT('dd/mm/',2))
CONCAT_WS(separator, string_1 ,string_2 ...)puts strings together with separato
RIGTH(string,N)
I have created tables in a MySQL Database for importing data from an XML
file. My aim is to have MySQL table structures that correspond accurately
with the XML structure. What are the available ways to validate the two
structures or create the first structure from the second?
Also: From a proper
Is there is a way to do a search and replace on the mysql cmd prompt? I
want to replace text in about 20 rows that has the same pattern with a
replacement.
I have a table that has a column 'name' and a column 'url' which holds
menu items for a website. Both columns are type varchar.
'url' has
Try something like this:
UPDATE tablename SET url = concat(programs, substring(url,12)) where url
like (disciplines/%);
Andy
-Original Message-
From: Craig Harding [mailto:[EMAIL PROTECTED]
Sent: 20 June 2003 17:31
To: [EMAIL PROTECTED]
Subject: search and replace.
Is there is
select 8 ^ 5;
ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1
i'm guessing that this means mysql 3.23 doesn't have the xor.
On Thursday 19 June 2003 11:52, Nicholas Elliott wrote:
Remember that this is a binary XOR, not a logical XOR. Mysql does have a
binary XOR
In the last episode (Jun 20), Prem Soman said:
that was very useful for me. can these UDF's provide a better way to
access the sever specific information such as the date and number of
times the server was restarted
The server does not know how many times it has been restarted. You can
easily
I try install MySQL 3.23.56 from sources on my FreeBSD 4.8-STABLE
configure (./configure --enable-assembler --with-innodb) works fine, but
when I say make,
I get next error :
--
Making all in extra
/usr/local/bin/bash ../libtool --mode=link
c -O3 -DDBUG_OFF
Hi:
I have the following problem:
When I insert a date in my table, and after do the insert I select the
column date to see if the date is right but it displays the date like
follows:
2019-06-20
When the original insert is:
2003-06-19
I looked into the manual to figure out how mysql works
On Fri, Jun 20, 2003 at 09:09:50AM -0500, Ray wrote:
select 8 ^ 5;
ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1
i'm guessing that this means mysql 3.23 doesn't have the xor.
It was added in 4.0.2 according to the docs.
Try this:
mysql select version();
Rolf,
You need to separate your functions. You are adding complexity to your
world by storing irrelvant infromation in your database. Critical Data
Handling (in a proper world) is ALWAYS handled separately from display. So
in your example,
You are storing all the html display formatting in
[snip]
When I insert a date in my table, and after do the insert I select the
column date to see if the date is right but it displays the date like
follows:
2019-06-20
When the original insert is:
2003-06-19
[/snip]
Please show us your insert query.
Jay
--
MySQL General Mailing List
For
Hi:
Here is the insert query:
insert into OrdenServicio set folioOrdenServicio='', idCanal='1',
idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no
prende', idEntregaControl='1', numSerie='7349843', estaComponenteBase='1',
observaciones='', idStatusOrden='7',
Hmmm I was having that issue when I shut my server down... i.e. the
mysql daemon... did you turn off your machine, and not have mysql
automatically boot up?
-Original Message-
From: azamka [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:07 PM
To: [EMAIL PROTECTED]
[snip]
insert into OrdenServicio set folioOrdenServicio='', idCanal='1',
idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no
prende', idEntregaControl='1', numSerie='7349843',
estaComponenteBase='1',
observaciones='', idStatusOrden='7', idCanalLevantamiento='1',
Here is the table description:
mysql show create table OrdenServicio;
| OrdenServicio |CREATE TABLE `OrdenServicio` (
`folioOrdenServicio` int(11) NOT NULL auto_increment,
`idCanal` int(3) NOT NULL default '0',
`idTienda` int(8) NOT NULL default '0',
`idPedido` int(8) NOT NULL default '0',
Here's the log. Retrying...
Moving info for table LogOutputStats
Setting fields and metadata.
Using original table.
Tracking field is ResRefID
Starting transfer.
As the Pharoh says... Ye who can interpert my dreams will become second
greatest in the LAAANNND
All the rest of you will
azamka wrote:
I installed mysql manually on red hat 9. It worked fine couple days but from
yesterday i am getting a weird error when i tried to run the mysql. the
error
statement is Error 2002: Can't connect to local MySql server through
socket
'/tmp/mysql.sock'(2).
I am new user of Linux and I
* Miguel Perez
I have the following problem:
When I insert a date in my table, and after do the insert I select the
column date to see if the date is right but it displays the date like
follows:
2019-06-20
When the original insert is:
2003-06-19
You would get this result if you
I am trying to install MySql++ (1.7.9) onto my Mandrake 9.1.
Initially is indicated that it couldn;t find the mysql libraries and I
assume is because I installed Mysql as one of the install options when
installing Mandrake 9.1 as I believe it dosen't include the needed
libraries for mysql++.
I
Hi:
The weird thing is that not always do the same, I mean I always introduce
that insert query, but not always inserts a wrong date, sometimes the date
is correct.
Mikel
From: Roger Baklund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: Miguel Perez [EMAIL PROTECTED]
Subject: Re: odd Date
[snip]
insert into OrdenServicio set folioOrdenServicio='', idCanal='1',
idTienda='107', idPedido='306', idProducto='503578', fallaCliente='no
prende', idEntregaControl='1', numSerie='7349843',
estaComponenteBase='1',
observaciones='', idStatusOrden='7', idCanalLevantamiento='1',
Hello,
I am trying to compile MySQL 3.23.57 on NetBSD 1.6.1. I downloadded
pthreads-1_60_beta6-mysql.tar.gz from your site and extracted it to
mysql-3.23.57/ I ran ./configure --with-mit-threads in mysql-3.23.57 and
everything went fine. However, when I run make, I get the following
errors
On 19-Jun-2003 vernon wrote:
OK, I've done this.
Problem occurs when a user selects 1 and 9.
The SQL statement I have reads like so:
if (isset($HTTP_GET_VARS['check00'])) {
$age00 = '00';
$s_age00 = penpals.agegroup = $age00 AND;
}
Problem is the AND statement. Some
1. check if /usr/local/mysql/data has mysql user and r/w privileges
2. if /usr/local/mysql/data doesn't exist You have to launch mysql_install_db
3. See the your system.err file in /usr/local/mysql/data
I wrote a sample tutotial for MacOS 10.2 at
http://www.santinoc.com/mysql.html
Santino
You can access MySQL databases from ASP by using MyODBC (now
Connector/ODBC) just like you would any other ODBC datasource. I would
suggest doing google searches on MyODBC and ASP in the same search, or
adapt some code from my site www.vbmysql.com, and look in the MyODBC FAQ
for examples. Also
On 20-Jun-2003 Craig Harding wrote:
snip
'url' has about 20 rows starting with 'disciplines/someurl' and I want
to replace 'disciplines' with 'programs'. Is there a way to do this in
mysql? I know I can do it in php, but it would be cool to do it, (and
probably faster) to do it in mysql.
I had MySQL 3.23.56 on my RedHat machine but developed some problems
(that were probably my own fault) so I decided to upgrade to 4.0. I
downloaded the source rpm and rebuilt it on my system (running a fully
updated RedHat 9.0). I removed the old mysql by doing rpm -e on the
components;
If I recall well MyODBC is used when you want to access ODBC compliant
databases on a Linux based computer, however if you want to acces mySQL from
ASP means that you are programming on a Windows based computer, and
therefore you have ODBC client access built-in. What you need to do is to
create a
Sorry about my last comment, I check the documentation and the ODBC
connector (also called MyODBC) is indeed the driver for ODBC in Windows.
E!
- Original Message -
From: Ernesto Silva [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 20, 2003 1:27 PM
Subject: Re: Connecting
Rick,
Sorry your request was taken in the wrong way, I get this request for
various things all the time and they are serious about it. I also see on
a regular basis people get two T1 connections from the same loop
provider, to the same ISP and call it redundant. So the question
remains, how
The bug is:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 257 to server version: 4.0.14-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql use sqlreg3;
Database changed
mysql LOAD DATA LOCAL INFILE
hello all,
i hve been getting the 'mysql ended' error for over a wek now.when i
look into the log file this is what I get
This is from the error logs
030619 17:09:04 mysqld ended
030620 13:14:06 mysqld started
030620 13:14:09 InnoDB: Started
030620 13:14:09 Fatal error: Can't open privilege
Hi there,
I'm just getting started with mySQL and PHP. I've used phpMyAdmin to create
tables and insert data into them from a delimited text file. From there I'm
creating a web page to view the data. Ideally this table would be refreshed
every night as it is a data dump from our production
True, I have a Windows PC, however to test this I'm doing something like
this:
In Notepad I create a file test.asp
Write some ASP code into the file
Save the File
Upload the file to my remote host that works in Linux
Run my ASP script
See my script working ok
/*So ASP can run in a Linux Server
No route to host is a TCP/IP connection thing. Check your settings.
Curtis
TheMechE said:
Here's the log. Retrying...
Moving info for table LogOutputStats
Setting fields and metadata.
Using original table.
Tracking field is ResRefID
Starting transfer.
As the Pharoh says... Ye who
On Fri, 2003-06-20 at 12:16, Barbara Andrew wrote:
snip
I have three books on mySQL, they all talk about how to
construct SQL statements and I'm fine with that. What I can't figure out is
how to get those statements to the right place without having to do it
manually.
This would be the
Pushpinder Singh Garcha wrote:
hello all,
i hve been getting the 'mysql ended' error for over a wek now.when i
look into the log file this is what I get
This is from the error logs
030619 17:09:04 mysqld ended
030620 13:14:06 mysqld started
030620 13:14:09 InnoDB: Started
030620 13:14:09
Hello all,
I'm pretty new to MySQL, but have managed to create a database that is
accessed via PHP which then creates tables from the MySQL data.
Currently, I am using the root user/password combo to grab the info (which
means the password is plaintext in the PHP). I wanted to use the my.cnf
Have you looked at using the MS DTS and MyODBC to perform your
replication/synchronizing from Microsoft?
-Original Message-
From: Paul [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:31 AM
To: [EMAIL PROTECTED]
Subject: Synchronising SQL Server and MySQL
I need to synchronise
I've distilled my problem down to this: I am trying to figure out how to
build some indices on a couple of different tables so as to speed up a
search that involves searching on multiple columns from each of the
tables. Let's pretend I have two tables as follows and that I need to
do a query that
From the InnoDB manual:
Dropping a table or deleting all rows from it is guaranteed to release the space
to other users, but remember that deleted rows can be physically removed only in
a purge operation after they are no longer needed in transaction rollback or
consistent read.
Perhaps that
50 matches
Mail list logo
