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(293) view(1,095) 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(293) view(410) 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(291) view(779) 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(297) view(574) status()
)
EXTRACT function
How can I extract the date's quarter [regardly of year] from a column?
How can I extract the date's quarter [regardly of year] from a column?
answer(0) view(3) 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(2) view(658) status(
)
)
Registered users get user_id '8388607'
Hi, I recently moved my website to a new server and I'm having some trouble registering new users. Basically, when a user tries to register (either through my PHP registration form or through the forum (the same database is used for both))...
Hi, I recently moved my website to a new server and I'm having some trouble registering new users. Basically, when a user tries to register (either through my PHP registration form or through the forum (the same database is used for both))...
answer(5) view(399) status()
)
TRY SQL online
Hi there, Once I came across a website that let me try SQL query online. Does anybody know the link? Thank you very much.
Hi there, Once I came across a website that let me try SQL query online. Does anybody know the link? Thank you very much.
answer(6) view(844) status()
)
error
execution error #1044
execution error #1044
answer(0) view(6) 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(12) view(519) status()
)
My Sql Counters for Windows Performance Monitor
i need performance counters on windows for My sql database
i need performance counters on windows for My sql database
answer(0) view(10) status()
)
COUNT not returning 'zero' rows
I'm using the following query to get a count of all members from each country. The country is linked to each member through a secondary 'state' table (member.state_id = state.id, state_country_id = country.id) The problem is that it will on...
I'm using the following query to get a count of all members from each country. The country is linked to each member through a secondary 'state' table (member.state_id = state.id, state_country_id = country.id) The problem is that it will on...
answer(3) view(359) status()
)
Join query returning NULL for last table while joining 4 tables when the 3rd table is empty
Hi, i'm using the following query to retrieve data from 4 different tables at once: SELECT ratingfav.*,members.favcount,achieve.level,achieve_info.next FROM (`ratingfav` LEFT JOIN members ON ratingfav.user = members.username) LEFT JOIN achieve ...
Hi, i'm using the following query to retrieve data from 4 different tables at once: SELECT ratingfav.*,members.favcount,achieve.level,achieve_info.next FROM (`ratingfav` LEFT JOIN members ON ratingfav.user = members.username) LEFT JOIN achieve ...
answer(0) view(15) status()
)
vt102 , any idea what this means??
hi all, i do a simple select * on my database table and after all rows are displayed, i get "vt102" repeated several times on the mysql command prompt. has anybody else encountered this??? any idea what this is and its possible...
hi all, i do a simple select * on my database table and after all rows are displayed, i get "vt102" repeated several times on the mysql command prompt. has anybody else encountered this??? any idea what this is and its possible...
answer(11) view(429) status()
)
Access to MySQL using C in QNX
Hi All, Is there any body can help me? I have a code to access to MySQL (I got from Internet). But when I tried to compile it using : gcc -L/usr/local/mysql/lib -I/usr/local/mysql/include -o select select.c -lmysqlclient -lz The er...
Hi All, Is there any body can help me? I have a code to access to MySQL (I got from Internet). But when I tried to compile it using : gcc -L/usr/local/mysql/lib -I/usr/local/mysql/include -o select select.c -lmysqlclient -lz The er...
answer(1) view(672) 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,368) 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,811) 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(809) 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(173) 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(46) 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(380) 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(372) 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(619) 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,152) 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(421) 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(767) 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(309) 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(60) 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(842) 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(575) 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
- Multiple Table Delete Query when 1 Table May Have No Data
- Apply stored procedure to each row of a select
- Limits in mysql
- timestamp update problem
- Dynamic order of count in stored procedure
- innoDB
- Reliable last inserted ID from SP w/ shared connections
- 2 questions about stored procedures
- Ordering by weeks?
- .sql file
- Move record from one table to another
- .sql text file into MySQL
- MySQL configure error
- Backup on Two Master Servers
- person and residence tables (was "Help with query statement")
- foreign Key using phpmyadmin
- select stuff giving some rows a higher priority in the search
- Best site to learn MySQL
- '--skip-grant-tables' does not work for me
- Using multiple wildcards in WHERE clause
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