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).
Percentage query w/ in 15 minute time ranges
Hello, We have a site where our users, after signing up for our site and are flagged as 'verified', can upload Mp3's into our site. There are 3 tables that are involved: A users table which contains page_object_id (in this case wil...
Hello, We have a site where our users, after signing up for our site and are flagged as 'verified', can upload Mp3's into our site. There are 3 tables that are involved: A users table which contains page_object_id (in this case wil...
answer(166) view(1,014) status(
)
)
Help w/ Query Join?
I'm stumped and can't figure this query join out. Any help would be greatly appreciated. Here is my current query: Code: SELECT m.manufacturerName FROM manufacturers AS m INNER JOIN equipment AS e ON e.equipmentManu=m....
I'm stumped and can't figure this query join out. Any help would be greatly appreciated. Here is my current query: Code: SELECT m.manufacturerName FROM manufacturers AS m INNER JOIN equipment AS e ON e.equipmentManu=m....
answer(164) view(288) status()
)
Help w/ MySQL Join Query?
Sorry, guys. I'm stumped. I've tried various MySQL JOINS to no avail. I need to be able to only return records from one table that have records associated with it in another table. The existing query is: PHP Code: ...
Sorry, guys. I'm stumped. I've tried various MySQL JOINS to no avail. I need to be able to only return records from one table that have records associated with it in another table. The existing query is: PHP Code: ...
answer(160) view(627) status()
)
Help w/ complex mysql query
Hey guys, I have what seems like an easy problem to solve, but for the life of me, I can't come up with a successful (and effecient) query. If anyone could help, I'd appreciate it. ok, I have a DB table that collects ping info every 5 mi...
Hey guys, I have what seems like an easy problem to solve, but for the life of me, I can't come up with a successful (and effecient) query. If anyone could help, I'd appreciate it. ok, I have a DB table that collects ping info every 5 mi...
answer(166) view(474) status()
)
ERROR 1005 (HY000) Can't create table (errno: 150)
What is wrong with this SQL? As far as I can tell I have everything right. I'm using the latest version of MySQL also. This is all generated with the latest version of MySQL Workbench. The permissions table I posted below is line 45 i...
What is wrong with this SQL? As far as I can tell I have everything right. I'm using the latest version of MySQL also. This is all generated with the latest version of MySQL Workbench. The permissions table I posted below is line 45 i...
answer(5) view(1,112) status(
)
)
phpmyadmin problems
dear guru's, been fighting for what seems like an eternity now. trying to get everything working locally before exporting to server. So i setup omnihttpd for php stuff, mysql-3.23.58-win.zip, and php-4.3.4-Win32.zip. i got my mysq...
dear guru's, been fighting for what seems like an eternity now. trying to get everything working locally before exporting to server. So i setup omnihttpd for php stuff, mysql-3.23.58-win.zip, and php-4.3.4-Win32.zip. i got my mysq...
answer(1) view(1,441) status()
)
MySQL Count Total BBS Posts
Hello, I have a small problem. I have two tables running the BBS posts and topics. The structure is as follows: BBS Posts post_id,topic_id,author_id,emoticon_id,post_field,uploaded_pic,post_date BBS Topics topic_id,topic_views,post...
Hello, I have a small problem. I have two tables running the BBS posts and topics. The structure is as follows: BBS Posts post_id,topic_id,author_id,emoticon_id,post_field,uploaded_pic,post_date BBS Topics topic_id,topic_views,post...
answer(4) view(780) status()
)
Is MySql missing First and Last aggregate functions?
Is MySql missing the FIRST and LAST aggregate functions? I couldn't believe it, but I couldn't find it. I want to get the first and the last item in the group. Without the FIRST and LAST function, how can I do that? Does anybody have a w...
Is MySql missing the FIRST and LAST aggregate functions? I couldn't believe it, but I couldn't find it. I want to get the first and the last item in the group. Without the FIRST and LAST function, how can I do that? Does anybody have a w...
answer(10) view(237) status()
)
LIKE AND NOT LIKE in same query possible?
I'm doing the following and I get an error. Syntax looks right, so what is the deal? Code: SELECT category, categoryid FROM `xcart_categories` WHERE category LIKE 'skate - surf/%' AND NOT LIKE 'skate - surf/%/%' ...
I'm doing the following and I get an error. Syntax looks right, so what is the deal? Code: SELECT category, categoryid FROM `xcart_categories` WHERE category LIKE 'skate - surf/%' AND NOT LIKE 'skate - surf/%/%' ...
answer(2) view(131) status()
)
Ignoring query to other database error
Hello, I am having problems creating an admin user (from command line mysql) for myphpadmin. Here is what I am running: Fedora Cora (latest build) Apache 2.0.49 MySQL 4.0.18 php-4.3.6 I get into MySQL by typing: mysql -root -...
Hello, I am having problems creating an admin user (from command line mysql) for myphpadmin. Here is what I am running: Fedora Cora (latest build) Apache 2.0.49 MySQL 4.0.18 php-4.3.6 I get into MySQL by typing: mysql -root -...
answer(1) view(332) status()
)
Mysql function for 2 dates processing
My problem is i have inserted 2 dates say "2008-01-01" and "2008-01-05", I want the return to be "2008-01-01", "2008-01-02", "2008-01-03", "2008-01-04", "2008-01-05" .
My problem is i have inserted 2 dates say "2008-01-01" and "2008-01-05", I want the return to be "2008-01-01", "2008-01-02", "2008-01-03", "2008-01-04", "2008-01-05" .
answer(0) view(22) status()
)
Oversized .sql
I've got a backup of a forum database that I want to grab the members and posts from to put them in the new forum but (here's the problem) the .sql file is 1.05gb which I'm finding is WAY too big to work with. Here's what I've tried so f...
I've got a backup of a forum database that I want to grab the members and posts from to put them in the new forum but (here's the problem) the .sql file is 1.05gb which I'm finding is WAY too big to work with. Here's what I've tried so f...
answer(3) view(352) status()
)
Mysql most common result
I have a mysql/php hit counter I am designing. I am keeping track of the screen resolution and the web browser. I would like to put a summary on a webpage of the most common browser and the most common screen resolution. Is there an easy...
I have a mysql/php hit counter I am designing. I am keeping track of the screen resolution and the web browser. I would like to put a summary on a webpage of the most common browser and the most common screen resolution. Is there an easy...
answer(2) view(348) status()
)
Insert Ignore with auto-increment field
I am new to databases and mysql. I was wondering if an auto-increment column of type integer is still incremented on an INSERT IGNORE. I have the following table defined: create table vector ( vector_id int unsigned not null auto_i...
I am new to databases and mysql. I was wondering if an auto-increment column of type integer is still incremented on an INSERT IGNORE. I have the following table defined: create table vector ( vector_id int unsigned not null auto_i...
answer(2) view(557) status()
)
MySql Install Error 1045
Hi all, I have previously installed MySql and uninstalled it. Now when I try to install it again I get Error 1045 during the installation process. I has some waffle about firewalls which I turned off. Also it talks about problems caused by ...
Hi all, I have previously installed MySql and uninstalled it. Now when I try to install it again I get Error 1045 during the installation process. I has some waffle about firewalls which I turned off. Also it talks about problems caused by ...
answer(2) view(1,047) status()
)
How many records MySQL can store
How many records MySQL can store? How many records Access can store? Can anyone tell me
How many records MySQL can store? How many records Access can store? Can anyone tell me
answer(2) view(326) status()
)
Help with Matrix Multiplications in MySQL
Dear All, As part of a university project I am migrating a small poll application from PostgreSQL to MySQL and there is one question in particular which has stumped me for a while now. How would one attempt to adjust the following SQL...
Dear All, As part of a university project I am migrating a small poll application from PostgreSQL to MySQL and there is one question in particular which has stumped me for a while now. How would one attempt to adjust the following SQL...
answer(1) view(739) status()
)
502 bad gate way
Hello I have searched on many news groups and forums with out the answers I really need. So please help. I have been banging my head on this for a while. Trying to connect to MySQL database on a hosting server from my LOCAL computer. ...
Hello I have searched on many news groups and forums with out the answers I really need. So please help. I have been banging my head on this for a while. Trying to connect to MySQL database on a hosting server from my LOCAL computer. ...
answer(3) view(289) status()
)
How to keep mysql connection alive with java.
Hi, I have connect the db but it is get disconnect after the query is execute and I want to run continuous query, which db received new row. Can anyone help me. Thanking you, kndani@gmail.com
Hi, I have connect the db but it is get disconnect after the query is execute and I want to run continuous query, which db received new row. Can anyone help me. Thanking you, kndani@gmail.com
answer(0) view(29) status()
)
PrepareStatement doesnt work with Innodb
Hi, I'm missing something here. In some of my queries I use PrepareStatement. For MyISAM type tables the queries works fine but when I changed The type to Innodb, Errors were not raised but the queries did not work. WHY? I am not using ...
Hi, I'm missing something here. In some of my queries I use PrepareStatement. For MyISAM type tables the queries works fine but when I changed The type to Innodb, Errors were not raised but the queries did not work. WHY? I am not using ...
answer(4) view(818) status()
)
Execute sql script from "mysql>" prompt
I want to run a sql script (file) from the "mysql >" prompt and not from the command line. Is there any way to do this. thanks
I want to run a sql script (file) from the "mysql >" prompt and not from the command line. Is there any way to do this. thanks
answer(5) view(558) status()
)
change field order
I have a mysql db I access from a java program. I want to know how to change the order of the fields in an existing table. so that if the field list in the table is: field1,field2,field3.... I can change it to field2,field1,field3.....
I have a mysql db I access from a java program. I want to know how to change the order of the fields in an existing table. so that if the field list in the table is: field1,field2,field3.... I can change it to field2,field1,field3.....
answer(3) view(883) status()
)
Configuration failures
I installed MySQL on a Windows 2003 server. During configuration it gets as far as Start Service and fails to Start Service. This happens every time. I've followed the docs for MySQL and did a little searching to solve this but have found nothing. ...
I installed MySQL on a Windows 2003 server. During configuration it gets as far as Start Service and fails to Start Service. This happens every time. I've followed the docs for MySQL and did a little searching to solve this but have found nothing. ...
answer(0) view(30) status()
)
How can I install SQL+ on my machine?
Hello everybody! I know this is basic and I'm probably posting in the wrong place. I apologize if so. I need to start working in SQL+ using queries. I have no idea what type of Oracle I need and how I can get a server working. I need help startin...
Hello everybody! I know this is basic and I'm probably posting in the wrong place. I apologize if so. I need to start working in SQL+ using queries. I have no idea what type of Oracle I need and how I can get a server working. I need help startin...
answer(0) view(58) status()
)
this about mysql nested aggregate problem
how could i get the maximum value of the sum of the grouped name's price i have a table with id_num prod_num and price where id_num refers to thegroup where the product belong!!! how should i do this?
how could i get the maximum value of the sum of the grouped name's price i have a table with id_num prod_num and price where id_num refers to thegroup where the product belong!!! how should i do this?
answer(0) view(33) status()
)
join problem
hi, i created 2 tables and i want to fetch name from t_user having sys_pk CREATE TABLE t_directories ( sys_pk int(11) NOT NULL auto_increment, sys_del char(1) NOT NULL default 'f', sys_state tinyint(2) NOT NULL default '0', ...
hi, i created 2 tables and i want to fetch name from t_user having sys_pk CREATE TABLE t_directories ( sys_pk int(11) NOT NULL auto_increment, sys_del char(1) NOT NULL default 'f', sys_state tinyint(2) NOT NULL default '0', ...
answer(1) view(189) status()
)
Blanks in text?
How do I preserve blanks in text?
How do I preserve blanks in text?
answer(0) view(35) status()
)
A strange problem in MySql and C
I use the MySql 4.1.12a win32 from www.mysql.com. First, I used Win98 Operating System and the toolkit is VC 1.0, and copied the head files and library files in the VC path. I included the mysql.h in my c++ program by the macro statement...
I use the MySql 4.1.12a win32 from www.mysql.com. First, I used Win98 Operating System and the toolkit is VC 1.0, and copied the head files and library files in the VC path. I included the mysql.h in my c++ program by the macro statement...
answer(1) view(646) status()
)
INSERT INTO...SELECT...
Hi, I'm trying to copy data from one table to another. I have 2 tables that are structured like this: +-------------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null...
Hi, I'm trying to copy data from one table to another. I have 2 tables that are structured like this: +-------------------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null...
answer(0) view(582) status()
)
Delphi CGI connection to MySQL in unix
I am working on a web-page and I am using someone elses server. They are running unix and an Apache v1.3 server. I am writing CGI code in Delphi and I have not been able to find out how to make a connection with the database. If you have...
I am working on a web-page and I am using someone elses server. They are running unix and an Apache v1.3 server. I am writing CGI code in Delphi and I have not been able to find out how to make a connection with the database. If you have...
answer(1) view(889) 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
- setting max length when defining fields
- Using ENUM?
- SELECT with DISTONCT or COUNT (details inside)
- Getting record with largest value
- Retrieving the last record in a table
- ordering query help
- how do Implement a where clause?
- select statement "or" problem
- MySQL DB just DROPPED!
- Resetting the ID field to Zero
- question on server load
- mysql-php auto-increment problem
- Selecting users with the most number of contacts
- I would like to know is it in possible to do this??
- Using multiple sets of WHERE within SELECT. Possible?
- Optimizing query with where and group by on different columns
- converting string to int
- mysql installation problem
- Calculation in query, ORDER BY zero problem?
- finding the highest value in a table
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