FW: how to create database (auto)

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]

RE: Finding functions in manual (was RE: formatting query output)

: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

RE: Row numbers

: 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

RE: Row numbers (I thought of a new feature)

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

RE: Generating an automatic e-mail via MySQL

: 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

RE: Strange Updates

: 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' WHERE

RE: Safe way to allow users to create databases?

: 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 other

RE: Is there a SQL/diff program out there?

: 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

RE: cannot locate dbi.pm while running perl scripts

: 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 :

RE: backup data

: 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.

RE: sql CSV import

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.

RE: What is faster?..

: 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

RE: Question about Table_Options

: 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 tried

RE: Making Lin/Win share DataSource

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

RE: (SQL) Count Distincts

: : 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 :

RE: SQL Syntax

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

FW: line breaks

: : - 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 : br element, : for the exact display, That's what's normally done. Line breaks are usually represented by \n escape

RE: Getting Images in and out of a Blob

: 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

RE: setting auto increment start value

: 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, :

RE: Increment in update

:+---+--+--+-+-++ :| Field | Type | Null | Key | Default | Extra | :+---+--+--+-+-++ :| id | int(11) | | PRI | NULL| :auto_increment |

RE: datetime field question

: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

RE: Getting Images in and out of a Blob

: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

RE: mysql php and blank variables...

: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

Will DELAYED inserts solve my problem ( also related to indexing )

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

Re: MyISAM - Innodb

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

Re: MyISAM - Innodb

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

Re: MyISAM - Innodb

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

Re: Speed difference

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 can make a better one

Re: Adding an incremented id field

PRIMARY KEY; -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 010010100101010101001100 ++ | There is nothing wrong with your tools.| | But we can make a better one

I can't think....

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:

Installing DBI

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

Hellp with this error message. I am lost :(

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 :( ERROR [root@cral mysql]# scripts/mysql_install_db scripts/mysql_install_db: ./bin/my_print_defaults: cannot execute binary file WARNING:

./configure errorRe: Solaris

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...

RE: MySQL with perl error

PROTECTED] dpengu Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php dpengu -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.ultracgis.com/sherzodR - Before posting, please check: http://www.mysql.com

Re: Help please, create table, and set Auto field

number field in mysql table, websig websig create table namelist ( name char(60), ID auto, date date()); websig websig websig websig -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.ultracgis.com/sherzodR - Before

Re: Store picture

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://www.ultracgis.com/sherzodR

Re: converting database as text

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 database to a readable

Re: Funny :-)

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

Re: users in MySQL

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

Re: Good book for MySQL and Perl DBI?

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

Re: message traffic

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 the

RE: DISTINCT

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

RE: DISTINCT

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 EMAIL

Re: Creating Table with a Default Datetime field

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;

RE: Creating Table with a Default Datetime field

. . 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: Pete Harlan Cc: Ravi Raman; Richard Bates; [EMAIL PROTECTED

RE: Creating Table with a Default Datetime field

to whatever the current timestamp is because it is first in the table description/create definition. hth. -ravi. -Original Message- From: Sherzod Ruzmetov [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 2:10 PM To: Ravi Raman Cc: Pete Harlan; Richard Bates; [EMAIL PROTECTED

Re: Table Creation

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 to

Re: Default Datetime?

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

Re: MySql to Oracle migration

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 the

mySQL design for the questionnaire

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

Re: Select and = MAX()

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 - from