Home > MySQL Help
MySQL Help
MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).
Hiding MySQL databases from listing
When using a MySQL Client to connect to our MySQL server I get a list of all the databases on that server. Is there a way to hide some or all of the database names from displaying?
When using a MySQL Client to connect to our MySQL server I get a list of all the databases on that server. Is there a way to hide some or all of the database names from displaying?
answer(0) view(147) status(
)
)
size limitation
Hi, I need to developp a small but flexible application for an estate agency. I was thinking about using PHP and mySQL. The database will include the basic fields (such as address, rooms, city,...). 1.- What could be the size limitation in...
Hi, I need to developp a small but flexible application for an estate agency. I was thinking about using PHP and mySQL. The database will include the basic fields (such as address, rooms, city,...). 1.- What could be the size limitation in...
answer(1) view(553) status()
)
date handling MySQL
Hi ;-) I'm creating a simple intranet application with PHP/mySQL. In this application, I have a form: in this form there are fields with dates. In belgium, dates are stored in the form dd/mm/yyyy. MySQL requires the dates to be stored as ...
Hi ;-) I'm creating a simple intranet application with PHP/mySQL. In this application, I have a form: in this form there are fields with dates. In belgium, dates are stored in the form dd/mm/yyyy. MySQL requires the dates to be stored as ...
answer(0) view(252) status()
)
Table Integrity / Locking
When using php3/mysql to dynamically run a site, should any kind of table locking be implemented to maintain the db integrity? My site will have users posting to the database as well as pages being built off the database. If so, what woul...
When using php3/mysql to dynamically run a site, should any kind of table locking be implemented to maintain the db integrity? My site will have users posting to the database as well as pages being built off the database. If so, what woul...
answer(0) view(693) status()
)
Help finding out if table exists in mysql
In a Perl CGI script working with Mysql, I am trying to write: if a table does not exist, create it; How do I find out if a table exists? What value can I capture for my if statement?
In a Perl CGI script working with Mysql, I am trying to write: if a table does not exist, create it; How do I find out if a table exists? What value can I capture for my if statement?
answer(4) view(757) status()
)
Results Listing
I am using MySQL together with PHP3. I want to create a 'search engine' where the results are not displayed as one big listing on a single page, but on multiple pages with something like 20 results per page. The user will have the option to...
I am using MySQL together with PHP3. I want to create a 'search engine' where the results are not displayed as one big listing on a single page, but on multiple pages with something like 20 results per page. The user will have the option to...
answer(2) view(595) status()
)
MySQL, PHP APACHE RedHat Linux6.1
I have install the above on my pc mysql works fine on mysql>prompt and php runs fine with apahce as DSO module. However, when I have the following code in test.phtml : mysql_connect("localhost","webuser",""...
I have install the above on my pc mysql works fine on mysql>prompt and php runs fine with apahce as DSO module. However, when I have the following code in test.phtml : mysql_connect("localhost","webuser",""...
answer(2) view(497) status()
)
How to change mysql table permissions
Hi, What is the command to change permissions of mysql table? I am getting following error when I perform command from mysql command propmt. mysql> SELECT * INTO OUTFILE 'output.txt' fields terminated by '|' FROM information1; ERROR 10...
Hi, What is the command to change permissions of mysql table? I am getting following error when I perform command from mysql command propmt. mysql> SELECT * INTO OUTFILE 'output.txt' fields terminated by '|' FROM information1; ERROR 10...
answer(6) view(874) status()
)
MySQL query
I am trying to build a form based upon a query to MySQL. The form is a list of products, each with a quantity listbox (HTML <select> field). Each product may have a different set of allowable qty's (i.e., product 1 can be ordered in ...
I am trying to build a form based upon a query to MySQL. The form is a list of products, each with a quantity listbox (HTML <select> field). Each product may have a different set of allowable qty's (i.e., product 1 can be ordered in ...
answer(5) view(959) status()
)
change datatype
I have already assigned a DATATYPE eg. userid VARCHAR(20) now, I want to change it to VARCHAR(40) what should i type in MySQL?
I have already assigned a DATATYPE eg. userid VARCHAR(20) now, I want to change it to VARCHAR(40) what should i type in MySQL?
answer(2) view(85) status()
)
mysqld conflicting queries?!?
Hello, I have just begun to use mysql for a project I'm working on. mysql is running on one machine, and on another, there are multiple instances of a mysql client that repeatedly (and quite frequently) connect, query, and disconnect from ...
Hello, I have just begun to use mysql for a project I'm working on. mysql is running on one machine, and on another, there are multiple instances of a mysql client that repeatedly (and quite frequently) connect, query, and disconnect from ...
answer(0) view(330) status()
)
Adding rows and columns to tables?
I am creating a program for a company to allow them to edit the database through their website. The only difficulty I have run into is the editing of a tables' dimensions. I need to know how to add rows and columns or just create a table wh...
I am creating a program for a company to allow them to edit the database through their website. The only difficulty I have run into is the editing of a tables' dimensions. I need to know how to add rows and columns or just create a table wh...
answer(3) view(841) status()
)
Submitting Articles to a database using email
I want to set up a way that articles sent via email and stored in a database while still preserving the text formatting. I have seen an example of this before where I submit the article in the body of the message and the subject must be s...
I want to set up a way that articles sent via email and stored in a database while still preserving the text formatting. I have seen an example of this before where I submit the article in the body of the message and the subject must be s...
answer(0) view(384) status()
)
E-mail clean ups - Wildcards and more
Hi, I have a table of user inputed e-mails and a lot of them haven't put correct e-mails in. When I use the mail(email, blah, blah); command and loop through all of them, it stops on some of them giving me errors. How would I either: 1. B...
Hi, I have a table of user inputed e-mails and a lot of them haven't put correct e-mails in. When I use the mail(email, blah, blah); command and loop through all of them, it stops on some of them giving me errors. How would I either: 1. B...
answer(4) view(824) status()
)
PHP or PERL
im a newbie and im trying to decide whether to use PHP or PERL to access mysql. i have worked with perl to write some simple cgi scripts and i have seen some PHP code so i know a little bit about both languges.
im a newbie and im trying to decide whether to use PHP or PERL to access mysql. i have worked with perl to write some simple cgi scripts and i have seen some PHP code so i know a little bit about both languges.
answer(3) view(880) status()
)
Storage limitations in MySQL
Just wondering what character limitations exist in reference to storing text into a table. For example, if I wish to store some sort of a description within a database, am I allowed ( ) - _ + = ' " ; : / ? . < > , http:// etc. ?...
Just wondering what character limitations exist in reference to storing text into a table. For example, if I wish to store some sort of a description within a database, am I allowed ( ) - _ + = ' " ; : / ? . < > , http:// etc. ?...
answer(1) view(150) status()
)
Any way to create a duplicate db for testing?
I am changing some functions and would prefer not to develop on the 'live' database. Is there any way to duplicate the db and work against that while I debug? ------------------ Thanks for the help. ebryan@lumenet.com
I am changing some functions and would prefer not to develop on the 'live' database. Is there any way to duplicate the db and work against that while I debug? ------------------ Thanks for the help. ebryan@lumenet.com
answer(4) view(823) status()
)
work for a Mysql developer
I'm looking for a Mysql expert to work with me for a 3-4 week period. Must available to start asap. Thanks, mhm
I'm looking for a Mysql expert to work with me for a 3-4 week period. Must available to start asap. Thanks, mhm
answer(2) view(135) status()
)
Keys
I am having trouble understanding when and where to use KEY/INDEX. Can someone give me a good example of where I would and would NOT use it? If I have a database full of books and prices which people are searching, is that a good place to...
I am having trouble understanding when and where to use KEY/INDEX. Can someone give me a good example of where I would and would NOT use it? If I have a database full of books and prices which people are searching, is that a good place to...
answer(1) view(960) status()
)
MySQL with Java
Anyone have experience using MySQL with Apache JServ Servlets? I am planning to use this approach for my website, and I would love some pointers or tips if you could provide them (maybe some potential pitfalls to avoid!!). I'm essentially...
Anyone have experience using MySQL with Apache JServ Servlets? I am planning to use this approach for my website, and I would love some pointers or tips if you could provide them (maybe some potential pitfalls to avoid!!). I'm essentially...
answer(0) view(296) status()
)
Inputing multiple form options in SET
Hello. I have an HTML form with multiple options that I would like to input into a MySQL database as a SET. When the form is submitted, the data is sent as Variable=1&Variable=2&Variable=3, etc, while MySQL appears to want it subm...
Hello. I have an HTML form with multiple options that I would like to input into a MySQL database as a SET. When the form is submitted, the data is sent as Variable=1&Variable=2&Variable=3, etc, while MySQL appears to want it subm...
answer(1) view(263) status()
)
DATE COMPARISON
Hello, i have a STAMPDATE(14) type column. i would like to know if there is more than 24 hours between a field of this type and the current date. Shall i cast the dates to hours ? Thank you for your help. Kaila.
Hello, i have a STAMPDATE(14) type column. i would like to know if there is more than 24 hours between a field of this type and the current date. Shall i cast the dates to hours ? Thank you for your help. Kaila.
answer(0) view(29) status()
)
help! insert and replace via replace
Good day Please help! I need replase and insert date with one SQL command.. I create table: CREATE TABLE days ( user VARCHAR(8) NOT NULL, date DATE NOT NULL, count BIGINT UNSIGNED NOT NULL DEFAULT 0, INDEX (user), UNIQUE INDEX (date)); ...
Good day Please help! I need replase and insert date with one SQL command.. I create table: CREATE TABLE days ( user VARCHAR(8) NOT NULL, date DATE NOT NULL, count BIGINT UNSIGNED NOT NULL DEFAULT 0, INDEX (user), UNIQUE INDEX (date)); ...
answer(0) view(103) status()
)
Adding New Users in MySQL (mysqladmin)
I have hit a brick wall with this one: when I use the command ./bin/mysqladmin -u (user) -p (password) I get this: ./bin/mysqladmin: unable to change password; error: 'You are using MySQL as an anonymous users and anonymous users are not ...
I have hit a brick wall with this one: when I use the command ./bin/mysqladmin -u (user) -p (password) I get this: ./bin/mysqladmin: unable to change password; error: 'You are using MySQL as an anonymous users and anonymous users are not ...
answer(3) view(414) status()
)
Can I see the table?
OK, I've been working with MySQL/PHP for a little over an hour right now, but in all the documentation I find... there is nothing that explains how to post the complete table on a webpage. Is this a capability of MySQL? If so how do I do ...
OK, I've been working with MySQL/PHP for a little over an hour right now, but in all the documentation I find... there is nothing that explains how to post the complete table on a webpage. Is this a capability of MySQL? If so how do I do ...
answer(2) view(599) status()
)
Default Values
Yay! I finally got my table set up; my search and submit working... I just have 2 questions now... 1) Is it possible to set a defaulty value as a picture or word? I have tried pretty much everything I could see available to me (I access...
Yay! I finally got my table set up; my search and submit working... I just have 2 questions now... 1) Is it possible to set a defaulty value as a picture or word? I have tried pretty much everything I could see available to me (I access...
answer(0) view(521) status()
)
Newbie question - Datatype
I am a newbie in SQL. And here is my quetion: TINYINT(M) what does 'M' means here? The length? eg. TINYINT(2)UNSIGNED means 2 digits, numbers ranging from 0 to 99? and TINYINT(1) UNSIGNED means numbers from 0 to 9? and what command is use...
I am a newbie in SQL. And here is my quetion: TINYINT(M) what does 'M' means here? The length? eg. TINYINT(2)UNSIGNED means 2 digits, numbers ranging from 0 to 99? and TINYINT(1) UNSIGNED means numbers from 0 to 9? and what command is use...
answer(4) view(815) status()
)
moving database from 1 server to another
When I move my site which uses a MySQL database, how would I move the whole database from the old MySQL server to the new one? URL
When I move my site which uses a MySQL database, how would I move the whole database from the old MySQL server to the new one? URL
answer(1) view(573) status()
)
Building the Perl mysql DBD without MySQL
I'm in a bit of a predicament right now.. I'm working with a MySQL database that is running on a Win32 box, and I've been put in charge of writing a bunch of Perl scripts on a BSDI 3.1 box that will interface with the MySQL database. I...
I'm in a bit of a predicament right now.. I'm working with a MySQL database that is running on a Win32 box, and I've been put in charge of writing a bunch of Perl scripts on a BSDI 3.1 box that will interface with the MySQL database. I...
answer(0) view(147) status()
)
How to change location of mysql.sock
I am trying to setup an intranet using planet-intra linux demo, this requires mysql. I have mysql up and running, however the install of planetintra is looking for the mysql socket in the /tmp directory. My install has it stored under var/...
I am trying to setup an intranet using planet-intra linux demo, this requires mysql. I have mysql up and running, however the install of planetintra is looking for the mysql socket in the /tmp directory. My install has it stored under var/...
answer(0) view(629) status()
)
Programming
- PHP Development
- Perl Programming
- C Programming
- Java Help
- Python Programming
- ASP Programming
- .Net Development
- Visual Basic Programming
- XML Programming
- WAP Programming
- HTML Programming
- JavaScript Development
- CSS Help
- Flash Help
- Photoshop Help
- Web Design Help
- Database Management
- MySQL Help
- MS SQL Development
- Oracle Development
- Mail Server Help
- Apache Development
- DNS
- IIS
- Networking Help
- FTP Help
Related Pages
- MySQL & PHP - How to hide connection details
- password
- SQL PHP mailing list system
- Select * from Multiple Tables?
- Can you exclude a specific table from mysqldump?
- Suggested structure for multiple warehouse tracking.
- Column Types for file upload
- Access front end, MySQL back end - performance
- Table optimization question between updates and selects
- Access > MySql / PHPMyAdmin
- How to check overhead of table?
- Shameless plea for help with queries :(
- SLOW Perl / MySQL execution times
- Can't get date into ddmmyy
- Lose connection to mysql server?
- removing parentheses in where clause
- prev/next
- Links not working in the whole page!
- Reading MySql numerical date in php
- how to correct the mysql time with the system real time
Home -
About Infoqu -
Contact -
Privacy Statement -
Link to Infoqu -
Bookmark Infoqu
Copyright 2007-2010 by Infoqu. All rights reserved
Copyright 2007-2010 by Infoqu. All rights reserved