Hi Richard,
Do you think the following links may help? I got them from the online
manual:
[1] http://www.mysql.com/doc/en/CREATE_DATABASE.html
[2] http://www.mysql.com/doc/en/CREATE_TABLE.html
[3] http://www.mysql.com/doc/en/CREATE_FUNCTION.html
[4] http://www.mysq
I thought of a new feature... XSLT's "position()"-like functionality
in the new releases of MySQL.
position(), in XSLT, returns position of the node in the document tree.
In MySQL it would return position of the record in the returned result set
(from SELECT query):
Example:
SELECT POSIT
: Is there a way to get a row number returned with any select query?
Row number is not available for some queries (ex.DELETE FROM table_name)
for efficiency. You can disable it with a dummy WHERE clause:
DELETE FROM table_name WHERE 1 > 0;
It will be slower, but you'll get the desire
:Putting
: links for each
: function under the categories might help with that. The
: links could go to
: the specific place on the big page (there would be no
: need for a separate
: page for each one). Of course, this is probably OT at this point.
Try http://www.
: Does any one have a suggestion on running a daily / weekly e-mail
: notification based on results from a MySQL query?
In your cron file do something like:
echo "select * from table" | mysql [options] db | mail
[EMAIL PROTECTED]
If it's a more complex query:
cat ~/quer
: Is there a safe way to allow ordinary users, who should
: not have MySQL root privileges, to create databases using
: any name they choose? It seems to me that I would need to
: use "GRANT ALL ON *.* TO user WITH GRANT OPTION". This
: would be dangerous because of the othe
: > select count(*) from Yellow WHERE MATCH(street_add)
: AGAINST('+GUIDO
: > +MIGLIOLI' IN BOOLEAN MODE) AND street_short = '';
: >
: > and the result was 50 rows in set.
: >
: > But when I ran the update:
: > UPDATE yellowtest.Yellow SET street_short = 'MIGLIOLI'
: Hi :
:
: When I try running my perl scripts using DBI interface
: with mysql, I got
: this message:Can't locate DBI.pm in @INC((@INC contain :
: /usr/lib/perl5/5.6.0/i386-linux
: /usr/lib/perl5/5.6.0./usr/libperl5/site_perl/5.6.0/i386-linux
: /usr/lib/perl5/site_
: SYNOPSIS:
:
: Wondering if anyone knows of, or has built, or is
: interested in building
: a program that will take two .sql schema dumps (one new
: and one old) and
: create the ALTER / CREATE TABLE syntax to make the old
: one look like the
: new one. It
: I am now thinking about using MySQL as my main office DB. Is
: it going to be
: easy te retrieve dta if there is crash or worse case senario
: my OS dies? I
: guess this is a back up question really?
Try to backup your DB as often. "mysqldump" utility is mostly for that.
:
: - what is the stored character code of the enter key in the
: text field, i am
: figuring out to find that character and replace it with the
: element,
: for the exact display,
That's what's normally done. Line breaks are usually represented by "\n"
escape characte
That is one bloody complex query :).
As far as I know, MySQL does not support RIGHT JOIN leyword, so that's where
it's failing. Someone slap me if I'm wrong.
It may be possible to fetch the results you want without such a hairy query.
Just include a partial dump of involved tables and concise des
:
: I am trying to get a count of Distinct IP's from my homemade hit-log
: database (don't ask). The db is MySQL. I'm trying this:
:
: SELECT DISTINCT ClientIP, COUNT(*), Month(TimeStamp),
: DayOfMonth(TimeStamp) FROM RedirectLog WHERE (TimeStamp BETWEEN
: '2003013
Wow, one hell of a discussion! :-)
: Now, let's say DATADIR is in /var/lib/mysql/ under Linux, and under
: Windows this is c:\mysql\data\ (I'm not informed how paths will look
: like when you share them between OS's).
:
Guys, are you sure you can share files between two absolutely
: When creating a table can you use multiple Table_Options?
:
: The O'Reilly "Managing & Using MySQL" show on page 288 a
: table been created
: with two options "...)AUTO_INCREMENT = 1, TYPE=InnoDB;"
No commas used to seperate multiple options. Here is an example I just
tri
: The fastest way would be to use C.
: But the reason for using a DB would be.
: 1. Access to data. You could use PhPMyAdmin or some thing you
: put together
: to update the policy so making managing the data easy (possibly so non
: tickers should make changes).
: 2. If
I normally do not use PHPMyAdmin. But when I had to do that once
on a client's sites (he didn't have shell access to a shared server ),
i had a similar problem. I couldn't import its own dump.
I believe it was a bug, and should've been resolved in later versions of
PHPMyAdmin. Try to update.
Sher
: Am Donnerstag, 30. Januar 2003 20:15 schrieb Mike Doanh Tran:
: > Hi all,
: >
: > I am creating a new table with an auto_increment primary key.
: > How do i tell mysql to start incrementing at a certain
: value, let say
: > 1000 instead of 1?
: >
: > Thanks,
: > Has anyone done any work with getting images into and out of a MYSQL
: > database? I have used mysql for some time, but never
: stored an image
: in a
: > blob field. I am curious on how to insert the image from a web form
: upload,
: > and how to display the pictu
:Has anyone done any work with getting images into and out of a MYSQL
:database? I have used mysql for some time, but never stored
:an image in a
:blob field. I am curious on how to insert the image from a
:web form upload,
:and how to display the picture on another HTML p
:is there a way to use the date part of a datetime field that
:still uses the
:index on the datetime field? i've tried a few different things
:and it keeps
:saying in the explain it says that its a possible_key, but
:NULL for the key
I'm not sure if this ignores the indexes
:+---+--+--+-+-++
:| Field | Type | Null | Key | Default | Extra |
:+---+--+--+-+-++
:| id | int(11) | | PRI | NULL|
:auto_increment |
I have a hit logger tool, which does approximately 200,000 INSERTs a day
into tables.
The other application uses the same tables to run somewhat complex SELECT
queries.
Since these tables will be large, SELECT queries are quite slow.
Indexing the tables produced prefect results for these SELECT q
:when i type
:mysql_query("insert into table_name ('$var list'...); i come
:up with a bunch
:of
:blank/empty variables...
Try to debug your query by outputting to the stdout instead of sending to
the
mysql server. You can do it by simply echo()ing your query as it is to the
bro
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
I heard about Innodb here a lot, but where can i find more info about
it. I search mysql manuals, but no results.
Any resources?
> Hi,
>
> I have a lot of MyISAM table that i wanna convert ot Innodb.
They don't
> have any foreign keys nor BLOB or TEXT column as index. How should i
do
ntiums are much more faster then Ultras. Do you
aggree?
--
Sherzod Ruzmetov <[EMAIL PROTECTED]>
http://www.UltraCgis.com, Consultant
989.774.6265
010010100101010101001100
++
| There is nothing wrong with your tools.|
| But we
AUTO_INCREMENT PRIMARY
KEY;
--
Sherzod Ruzmetov <[EMAIL PROTECTED]>
http://www.UltraCgis.com, Consultant
989.774.6265
010010100101010101001100
++
| There is nothing wrong with your tools.|
| But we
I have a column with a date in the future. Trying to figure out a query
that would tell me how many days, mins left till that date.
I'm realy tired, and can't think right now :(
-
Before posting, please check:
http://www.my
I can install other moduels successfully. But when it comes to DBI, and
DBD::mysql, it keeps throwing out the following error:
make - not ok
make returned bad status
I am lost :-(. What could that be?
-sherzodOR
-
Before po
Please,help1
[sherzod@cral mysql-3.23.39]$ ./configure
loading cache ./config.cache
checking host system type... i586-pc-linux-gnu
checking target system type... i586-pc-linux-gnu
checking build system type... i586-pc-linux-gnu
checking for a BSD compatible install... /usr/bi
While installing mysql in a linux box (mandarake) i had this error.
Please, guys, help me out. I need to install this mysql in this box as
soon as possible :(
[root@cral mysql]# scripts/mysql_install_db
scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary
file
WARNING: The h
anyone try to insert images e.h. gif into mysql database.. I have tried
using blob type but how would I verify that it is OK.
suggun>
suggun> Thanks in advance,
suggun> Regards,
suggun> Moonesh
suggun>
--
Sherzod Ruzmetov
[EMAIL PROTECTED]
http
w to create a auto
digital number field in mysql table,
websig>
websig> create table namelist ( name char(60), ID auto, date date());
websig>
websig>
websig>
websig>
--
Sherzod Ruzmetov
[EMAIL PROTECTE
(the list archive)
jake.w>
jake.w> To request this thread, e-mail <[EMAIL PROTECTED]>
jake.w> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
jake.w> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
jake.w>
--
Sherzod Ruzmetov
[EMAIL PROTECTED]
>http://www.mysql.com/manual.php (the manual)
dpengu>http://lists.mysql.com/ (the list archive)
dpengu>
dpengu> To request this thread, e-mail <[EMAIL PROTECTED]>
dpengu> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
dpengu> Trouble unsubscribing? Tr
Sent on Jul 3 by Daniel Aderhold to [EMAIL PROTECTED]
aderho> Can anyone give the adress of another manual of MySQL (not from mysql.com).
Why is that ??? The manually you're not willing to use is indeed the *official*
manual, which also means the more comprehensive one you can think of. If yo
LOL, No you are not (i guess). It's just this mailing list software that stupid
:)
So ignore it. Afterall, even though you are Annoying, that's this mailing list
software making you annoying , isn't it :)
--
sherzod_ruzmetov (sherzodR)
email: <[EMAIL PROTECTED]>
So what if I have a fertile brai
Hi Alexandrino.
Have you tried
% mysqldump db_name [table_name]
?
Try it
--
Sherzod Ruzmetov
[EMAIL PROTECTED]
http://www.ultracgis.com/sherzodR
Sent on Jul 3 by Alexandrino B. Arvesu to [EMAIL PROTECTED]
alex> Hi,
alex>
alex> Is there a way of converting mySQL data
Actually, a new book by Paul is to be published "MySql and Perl for WWW".
Gonna be a great one. (to be published on August 13th)
--
sherzod_ruzmetov (sherzodR)
email: <[EMAIL PROTECTED]>
It really doesn't bother me if people want to use grep or map in a void
context. It didn't bother me
I do aggree with dave's point. Could we do that, please
On Thu, 28 Jun 2001, Dave Halliday wrote:
> Quick question - just signed up for this list and I was wondering if it
> would be possible to put a " [MySQL] " tag in the subject line?
>
> There doesn't seem to be a standard identifier in
It is a binary colum
-
-sherzodR
phone: (517) 774-2702
email: [EMAIL PROTECTED]
On Wed, 27 Jun 2001, Tobias Eggendorfer wrote:
> Hi,
>
> I suppose I found a bug :-)
> According to LIKE in a SELECT-query is case-insensitive. In fact,
> it is, when using it on varcha
Try to design your tables so, that it would be impossible to enter
dublicate primary keys. And don't let users (if it's CGi application) to
set or play with your primary keys (well, we could talk more about this
one).
If you used AUTO_INCREMENT, or UNIQUE, I bet you wouldn't have such
problem.
Please, go through the manual found at http://www.mysql.com
-
-sherzodR
phone: (517) 774-2702
email: [EMAIL PROTECTED]
On Wed, 27 Jun 2001, Richard Bergeron wrote:
> Hi,
>
> I'm new to this flavor of SQL, I've downloaded WinMySQLadmin version 1.1 for Win98,
> I seem
lahblahblah';
> will leave CreationDate as its original value, and change UpdatedDate to
> whatever the current timestamp is because it is first in the table
> description/create definition.
>
> hth.
> -ravi.
>
>
> -Original Message-
> From: Sherzod Ruzmetov [ma
rst_ timestamp column in a table.
. Could you tell me more about it? And how does it solve thr problem?
>
> hth.
>
> -ravi.
>
> -Original Message-
> From: Sherzod Ruzmetov [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 27, 2001 1:40 PM
> To
I, c. Then you just have to INSERT INTO it NOW() manually, that works
On Wed, 27 Jun 2001, Pete Harlan wrote:
> TIMESTAMP is not the solution to his problem; he wants the date to
> default to now() when the record is created, not updated.
>
> There's currently no way to do this in MySQL; def
Try this:
CEATE TABLE new_table
SELECT DISTINCT NAME, EMAIL, AGE
FROM whatever_table
On Wed, 27 Jun 2001, tom harrow wrote:
> Actually I now realise that im solving the wrong proplem.
>
> here is a simplified version of my dilema
>
> *
> NAME EM
Well, I can say that the problem is becasue of GROUP BY clause.
I'd say its use in that query is void isn't it?
Correct me if I'm wrong, but as far as I know, there should be summary
functions in your select, which I cannot see in yours. So it should give
you an error
-sherzdoR
On Wed, 27 Jun
Why bother when the following works:
mysql> SELECT price FROM shop ORDER BY price DESC LIMIT 1;
On Tue, 26 Jun 2001, R Talbot wrote:
> Following the Tutorial
> Creating and populating the table Shop in the db Test..
> Why won't the following syntax work?
>
> mysql> select price
> ->
As a student CGI programmer, I've been working on an online questionnaire.
I have been working so hard to design the mysql db part, still I'm not
sure if I've done it right. Still somethings seem to be awkward.
Here I'm DESCRIBing the tables for you, then i'm explaining how I
inteded to use i
Can someone explain me why is it waste of space???
Thank you
-sherzodR
On Tue, 26 Jun 2001, Tim Bunce wrote:
> On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote:
> > On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote:
> > >
> > > Is there a way/tool to migrate th
But how about TIMESTAMP?
For example:
CREATE TABLE time_test (creation_date TIMESTAMP, info VARCHAR(100));
This should work fine too,doesn't it?
-sherzodR
On Tue, 26 Jun 2001, Paul DuBois wrote:
> At 2:43 PM -0400 6/26/01, Richard Bates wrote:
> >How do I get a default date time in the cre
54 matches
Mail list logo