Tagged Questions
MySQL is an open-source, relational database management system.
0
votes
0answers
13 views
How to hide categories with no urls in them in while loop PHP
I need to hide all categories that has no links in them. Basically, what I have is table of all possible categories and unique ID for each category, second table contains all widgets that have parent ...
-4
votes
0answers
11 views
How to show data from mysql database to a label in php?
I want to get form labels that are stored in Mysql so i can easily display any language using select statement.
this is what i did but its hard to implement since i have different languages.
any ...
0
votes
0answers
19 views
why is select much slower with left join+where
I am attempting to optimize a MySQL query that is taking a long time to process. Imagine we have two tables, a users table and a purchases table. Both tables have ~20,000 rows in them.
mysql> ...
0
votes
1answer
15 views
Optimal storage engine for simple key/value database
I'm trying to decide on the best engine for a database to store our game objects. I've been trying to find various information on the different table engines, but so far haven't found much that would ...
0
votes
0answers
8 views
What is the purpose of table space in MySQL InnoDB storage engine?
As we know, for storage engine InnoDB in MySQL, it supports table space, my question is what is the purpose of using table space? What difference will it make one table space with a large file v.s. ...
0
votes
1answer
11 views
My Schema is not the same as my Database
i'm new using Php Cake. I'm using version 1.3. width Mysql. So I had been making some modifications in a web system. So, i had added a new column in one of the tables, and when i try to save i had ...
0
votes
0answers
16 views
Does anyone know any good perl, cgi and mysql tutorials? [on hold]
Are there any good online tutorials for perl, cgi and mysql? There are just too many listed online and I really would appreciate your help to narrow the field down a little.
0
votes
0answers
9 views
Dreamweaver PHP mySQL insert to WordPress wpdb Conversion
I would like to know how to convert this Dreamweaver generated code to what I need to use for mySQL forms in WordPress. If I use my code on a blank page (just the form and SQL) it works fine. When I ...
0
votes
1answer
40 views
Sql not accepting values in php
php
$dnumber = '9515551212';
$device_id = 'f3847010927038970110923';
device is a text field
phnum (I have used bigint, text, varchar) all give the same result.
mysql_query("INSERT INTO ...
0
votes
0answers
3 views
Creating indexes prior to LOAD DATA for performance in MySQL
The Amazon RDS Customer Data Import Guide for MySQL (written in 2009) provides the following tip to decrease load times for MySQL -
Create all secondary indexes prior to loading. This is ...
0
votes
1answer
6 views
using strtotime or Timestamp in mysql Select
I'm trying to select authors where the date in their record, pubMonth + pubYear, has passed. I've tried several combinations of WHERE statements but none of them are eliminating the records that are ...
0
votes
0answers
10 views
Why does MySQL version 6.0 keep throwing out errors?
I am new to mySQL and Netbeans7.3.1. I got a database set up and the connection all ready to go. I created one table and that worked out alright except it wouldn't let me use auto_increment.
Now I am ...
0
votes
2answers
34 views
Mysql select to table 5 per line
how i can Select from mysql_db to table limit by 5. 5 per line.
I have:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
i need:
1 6 11
2 7 12
3 8 13
4 9 14
5 10
or :
1 2 3 4 5
6 7 8 9 10
11 12 13 14
thank ...
0
votes
1answer
20 views
Using SQL join to sort elements of the same table
I'm a novice MySQL programmer, and I am trying to create a simple website with users that can send messages between each other.
The messages are stored in one table called message, with a date, from ...
1
vote
1answer
12 views
Retrieve all records from one table even if a related record can't be found in a related table
I've an application that checks recorded waste types. Part of the system allows the user to forecast how much waste they will recycle, and in a report it will list the forecasted waste type with how ...
