RE: A polite query about how to get MySQL to work

Hi, You haven't provided as enough information to be able to help you.. Send us your table structure and your PHP code.. Thanks. Gurhan -Original Message- From: Gloria L. McMillan [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 3:55 PM To: [EMAIL PROTECTED] Subject: A polite

RE: Order by

Hi, SELECT FROM table ORDER BY short_description+0; will do it.. Gurhan -Original Message- From: Steve Buehler [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 4:41 PM To: mysql Subject: Order by Is there a way to use ORDER BY, or something else, that will order the

RE: Birthday select

SELECT ... FROm table WHERE datecolumn=NOW(); Gurhan -Original Message- From: Soheil Shaghaghi [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 11:09 AM To: [EMAIL PROTECTED] Subject: Birthday select Hi everyone. I have a sql database of users with their birth date (Y/M/D).

RE: Birthday select

-Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 11:47 AM To: [EMAIL PROTECTED] Subject: RE: Birthday select On 19 Apr 2002, at 11:21, Gurhan Ozen wrote: SELECT ... FROm table WHERE datecolumn=NOW(); Do you have a lot of newborn users at your

RE: MySQLDump

Hi Ben, You need to run mysqldump command in the unix shell prompt, NOT in mysql shell. See: http://www.mysql.com/doc/m/y/mysqldump.html Gurhan -Original Message- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:45 AM To: [EMAIL PROTECTED] Subject: MySQLDump

RE: LOOKUP

for it. Sincerely, Gurhan -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:54 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP Gurhan, I think Simon was looking for a way to make the enum dynamic from another table

RE: Re[2]: sorting

Hi , I have resent another message and corrected that my solution wouldn't work because I oversaw the numbers with more than one digit, like you said. Roger Baklund posted the right syntax for it : -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April

RE: LOOKUP

Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 1:58 PM To: 'Gurhan Ozen'; 'Simon Tienery'; [EMAIL PROTECTED] Subject: RE: LOOKUP That's what I thought too. A workaround occurs to me though, but I'm not sure if it would muck things up. At any point where

RE: new to MySQL

This pages might be helpful: http://www.mysql.com/doc/T/a/Table_types.html http://www.innodb.com/ Gurhan -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 3:06 PM To: [EMAIL PROTECTED] Subject: new to MySQL Hey Everbody, I am still

RE: print on top

Hi Jule, You need to sort your records with ORDER BY clause . I don't know what your table looks like and obviously don't know if you have suitable columd for it.. Say you have a newsid field defined with int datatype with auto_increment property, then you can issue your statement as SELECT ..

RE: Password handoff

mysql -u user -pPASSWORD ... See: http://www.mysql.com/doc/m/y/mysql.html Notice that there is no space between -p and the password.. Gurhan -Original Message- From: BJ Phillips [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 16, 2002 2:05 PM To: Mysql Help Subject: Password handoff

RE: Saving and re-using SQL statements

Hi Neal, I am not clearly understanding your question , do you mean that you have some variables in your queries?? Normally you would just save your query in a file and either run it in the shell command line in batch mode with '' operator or would just call it in mysql shell with 'source'

RE: Is there a sql query to Copying tables

Hi, You can just do SHOW CREATE TABLE ... and copy+paste it with a different table name in the command line.. See: http://www.mysql.com/doc/S/H/SHOW_CREATE_TABLE.html Or else, if you are using phpMyAdmin , you can do it with a mouse click. Gurhan -Original Message- From: Jason

RE: Boolean!

ENUM datatype might help you... See: http://www.mysql.com/doc/E/N/ENUM.html Gurhan -Original Message- From: T.Thiessens [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 10:50 AM To: [EMAIL PROTECTED] Subject: Boolean! Hello! Well their you have it! It's a mysql freakshow out

RE: Handling Memo Fields from MS-Access?

Hi .. Mysql's LOAD DATA INFILE will take newline character as the lines' terminating character, but you can always change by LINES TERMINATED BY clause. So, say you have | character as the line ending character in your text file, you can just add LINES TERMINATED BY '|' clause to your LOAD DATA

RE: Do any of your applications work?

-Original Message- From: Hugh O'Loughlin [mailto:[EMAIL PROTECTED]] Sent: Saturday, April 06, 2002 7:32 AM To: [EMAIL PROTECTED] Subject: Do any of your applications work? Responsible Person, We have been asked by a client, to use your products in our intergration efforts. Your MySQL

RE: SQL Script stopping

You have a semicolon(;) after the line Service CHAR (80) Besides after CREATE TABLE tablename syntax you have to define the columns and their datatypes in parenthesis. See: http://www.mysql.com/doc/C/R/CREATE_TABLE.html Gurhan -Original Message- From: Jim Swanson [mailto:[EMAIL

RE: Insert ?'s

Then you need to fix your messages so that it will pass thru the filter. That statement is wrong because INSERT INTO statement inserts a new record to the table so you can't have a where restriction. If you wanna change the logo value where seller_ID=1 then use UPDATE TABLE syntax. See:

RE: printing the database

Hi, Try to use tee command to log all the output into a file. It will have the column names and everything you see in the screen. See: http://www.mysql.com/doc/m/y/mysql.html Gurhan -Original Message- From: colin o [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 4:14 PM To:

RE: create tmp table of column list of a table for future use

Are you trying to create a new table with an existing table's structure only ? or with the structure and data? If you just wanna duplicate a table with the data inside it you can use CREATE TABLE .. SELECT ... syntax. More info is at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html IF you just

RE: Newbie table question

Hi Graham, You can just use INSERT INTO ... SELECT ... statement for it . See the manual: http://www.mysql.com/doc/I/N/INSERT_SELECT.html Gurhan -Original Message- From: Graham Nichols [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04, 2002 10:44 AM To: [EMAIL PROTECTED] Subject:

RE: Transfert Data from one DB to another

IS it something that you can get the data with mysqldump into an sql file and then load it into the database you want it to be transferred to? If yes you can do it all in the command line. Gurhan -Original Message- From: David BORDAS [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 04,

RE: Transfert Data from one DB to another

Hi david, Just create another table in your database with the structure and data of the table. See CREATE TABLE ... SELECT ... syntax at : http://www.mysql.com/doc/C/R/CREATE_TABLE.html for this task. Then update all the category values from 2 to 4 in that table. Use mysqldump to copy it into

RE: Not null not working??

Hi Andrew, If you insert NULL value into a column that is defined as NOT NULL , the server puts in empty string ('') for the value... Try to use PHP to enforce $login to have a string value. Or you can compile a source distribution with -DDONT_USE_DEFAULT_FIELDS option to overcome this. See :

RE: Parameter passing on shell script

Hi Oswaldo.. You have the parameter inside the sql file , not in the script itself. Try this: #!/bin/bash QUERY=load data infile '/home/loader/txt/file_${date_proc}.txt into table debits fields terminated by ';' mysql -u user -ppass -D dbname -e $QUERY Gurhan -Original Message-

nothing technical....

Thought some might be interested in such articles. Seems like Oracle's got caught red handed scrambling:) http://reuters.com/news_article.jhtml?type=technologynewsStoryID=725126 Just for the filter: MySQL rocks :) Gurhan -

RE: scheduled job

Hi, No there is not.. You have use crontab with a batch file to do that. Gurhan -Original Message- From: Okan CIMEN [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 21, 2002 9:27 AM To: [EMAIL PROTECTED] Subject: scheduled job Hello, I am planning to call a scheduled (lets say

RE: SubSelect Problem

Hi Alex, MySQL doesn't support sub-selects yet. Gurhan -Original Message- From: Alex Speed [mailto:[EMAIL PROTECTED]] Sent: Monday, March 18, 2002 7:13 PM To: [EMAIL PROTECTED] Subject: SubSelect Problem SELECT textid, title, description from structure where textid in (select

RE: INSERT ... SELECT not supported?

Hi!, INSERT INTO ... SELECT statement works in MySQL. The web site is : http://www.mysql.com/doc/I/N/INSERT_SELECT.html I have no idea what you meant by it doesn't work for the same tables.. But as the answer to your question, you could do something like: SELECT @a:=MAX(fieldname) FROM TABLE;

RE: ID order...

Yes it is a strange question.. MySQL result sets are in the order you asked in the query. IF you would like the result set to be in order by a field called ID then just add order by ID at the end of your query.. Is this what you were asking? If not , can you give more insights of what the query

RE: ID order...

Hi, Just add order by ID in your query it will give you the results in the way you'd like... Gurhan -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 1:17 AM To: Gurhan Ozen; mysql lists.mysql.com Subject: Re: ID order... Ok, here

RE: ID order...

ugh..I guess that would be a question for the developers:) I don't know the answer to that question.. Gurhan -Original Message- From: Chuck PUP Payne [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 1:24 AM To: Gurhan Ozen; [EMAIL PROTECTED] Subject: Re: ID order... Ok

RE: BLOB in MYSQ

Hi, First of all, download MySQL++ for VC++ at: http://www.mysql.com/downloads/download.php?file=Downloads/mysql++/mysql++-1 .7.1-1-win32-vc++.zip And there are working examples on how to load and retrieve binary data from blob columns using MySQL++ at:

RE: Grants to a database table that doesn't exist yet

Hi Luc, I don't know if this will help you but you can do: GRANT DELETE,SELECT,UPDATE on qbslive.* TO . But this will give permission to ALL tables in qbslive database... Gurhan -Original Message- From: Luc Foisy [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 10:45 AM

RE: joining 2 identical tables

Hi Christian, You can create a temporary table (see manual http://www.mysql.com/doc/C/R/CREATE_TABLE.html) with the same structure as prv or com and populate it with prv's and com's data by using INSERT INTO SELECT ... syntax (see manual http://www.mysql.com/doc/I/N/INSERT_SELECT.html)

RE: drop down list using php and mysql

Hi, This type of qustion should be forwarded to PHP-DB list. Its adres is: [EMAIL PROTECTED] . As for the answer to your question.. IF you'd like to create a dynamic drop-down menu.. You can just just query the table for the options to be displayed and loop through the result set and print them

RE: drop down list using php and mysql

A correction... for line has the greater sign wrong:) It has to be : for ($i=0; $numresult $i; $i++) Sorry about that:) Gurhan -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 6:01 PM To: mailing list; [EMAIL PROTECTED] Subject: RE: drop

RE: update mysql database via php form

Hi, didn't really understand what you are asking.. Can you please be more specific? What exactly you are asking? Gurhan -Original Message- From: Valerie Brooks [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 5:28 PM To: [EMAIL PROTECTED] Subject: update mysql database via php

RE: drop down list using php and mysql

: Nathan [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 6:31 PM To: Gurhan Ozen; mailing list; [EMAIL PROTECTED] Subject: Re: drop down list using php and mysql You could also bypass the num_rows entirely... ?php $query=select field from table; $result=mysql_query($query) or exit

RE: Fetching an optional array from an optional column

Hi, Since you are using a form to query the table i assume the subject1, subject and geographic will be variables. So, you could do something like: SELECT * FROM links WHERE (subject1='$sub1' OR subject2='$sub2') AND GEOGRAPHIC like '$geo%' In this way, if the user enters no value for the

RE: Fetching an optional array from an optional column

this: SELECT * FROM links WHERE (SUBJECT1='Legislation' OR SUBJECT2='Legislation') AND GEOGRAPHIC='%' ORDER BY ORGANIZATION ASC Any ideas? Again, thanks for your help -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 4:18 PM To: [EMAIL PROTECTED

RE: Fetching an optional array from an optional column

By the way.. YOu must use LIKE for it to work.. GEOGRAPHIC= won't work it has to be GEOGRAPHIC LIKE .. Thanks, Gurhan -Original Message- From: Gurhan Ozen [mailto:[EMAIL PROTECTED]] Sent: Friday, March 15, 2002 7:37 PM To: [EMAIL PROTECTED] Subject: RE: Fetching an optional array from

RE: automating mysql command

You sure can do it.. Just put your sql commands into a .sql file and use mysql file.sql syntax to to have them executed by mysql. And you can always use cron in Unix to do it periodically.In your Unix box do: man crontab man cron to learn more about cron jobs. You can also consult to

RE: How do I get the time?

Hi Kathy, Are you trying to get current time in mysql ?? If yes, you can do it by issuing: SELECT NOW(); statement... Gurhan -Original Message- From: Kathy Reyes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 5:17 PM To: [EMAIL PROTECTED] Subject: How do I get the time?

RE: Selecting across servers

SELECT databasename.tablename.column, databasename.tablename.column FROM databasename.tablename, databasename.tablename; Gurhan -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 6:14 PM To: [EMAIL PROTECTED] Subject: RE: Selecting across

RE: MS-DOS Window

Hi Robbie, There are a few ways you can capture the output to a file.. First of all, you can have all your sql statement in a file , say myquery.sql file, and call it from command line and redirect it to a different file such as this: C:\mysql\bin\mysql myquery.sql outputfile.txt Or, you can

RE: Query structure question

SELECT COUNT(*) AS number_of_letters FROM tablename WHERE TO_DAYS(NOW()) - TO_DAYS(datefield) = 30 AND status='published' GROUP BY datefield; But this won't return anything for the days when no letters has been published though... Gurhan -Original Message- From: John Hughes

RE: 3.22.32: max table size

Quoted from http://www.mysql.com/doc/T/a/Table_size.html is: By default, MySQL tables have a maximum size of about 4G. You can check the maximum table size for a table with the SHOW TABLE STATUS command or with the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax. Gurhan -Original

RE: MySQL Book

The bible is MySQL by PAul DuBois ISBN: 0735709211 homepage: http://www.kitebird.com/mysql-book/ Gurhan -Original Message- From: Danis Stéphane (NHQ-AC) [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 21, 2002 2:08 PM To: Mysql (E-mail) Subject: MySQL Book Any book you guys

RE: long query on php

It shouldn't be a problem as long as the syntax is right... Gurhan -Original Message- From: savaidis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:14 PM To: MySQL list (E-mail) Subject: long query on php How is possible to pass a long query to MySQL server with php?

RE: Help me to create a table with autoincrementing field

Check out: http://www.mysql.com/doc/C/R/CREATE_TABLE.html Gurhan -Original Message- From: Charitha [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 10:51 PM To: [EMAIL PROTECTED] Subject: Help me to create a table with autoincrementing field Hi all there, I am a

RE: mysql web-based admin tool?

Phpmyadmin is pretty good for what you ar elooking for. You can find it at: http://www.phpwizard.net/projects/phpMyAdmin/ Gurhan -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 10:54 AM To: [EMAIL PROTECTED] Subject: mysql web-based admin

RE: Help with setting up the JDBC driver

Billy, Where is the source code you are trying to compile located? Is it same as where you keep your .jar file? If not, give java_home/jre/lib/ext path to javac as an -classpath option ... The drivers don't know where to find the databases.. Your program specifies them the server IP,

RE: Please Help with Pattern Matching

Doug, MySql is doing what it is supposed to... If you specify '%MWF%' it will only select the values with the string literal 'MWF' in it. If you would like to match all the rows that have either M or W or F in it, then use a query like : select schdays from courses where schdays LIKE %M% OR

RE: Need some easy select assistance

Yes it is so easy.. You just need to use table joins.. Check out: http://www.mysql.com/doc/J/O/JOIN.html Gurhan -Original Message- From: Torkil Johnsen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 3:50 PM To: [EMAIL PROTECTED] Subject: Need some easy select assistance

any good web hosting with php and mysql support?

Hi All, I am currently looking for a reliable web host to host my personal website. I know there are millions of web hosting companies that have PHP and MYSQL support but I just can't trust any of the fully-assured and confident webhosting ads anymore. I would like to get a service from a

RE: apostrophe's in PHP MySQL

=AddSlashes($feedback); Refer to http://www.php.net/manual/en/function.addslashes.php if you need to see more info. Gurhan Ozen MCI WorldCom Quality Assurance Team [EMAIL PROTECTED] ph: 703-449-4754 Vnet: 228-4754 1-800-PAGE-MCI pin: 1927052 AIM: Greywolf1923 -Original Message- From: Tim

Binary files..

Hi, Is it possible to store binary files ( .jpgs, .gifs, .zips, etc) in mysql tables? If yes, can you point me to any direction? Thank you very much. Gurhan - Before posting, please check:

<    1   2