Hey guys
i have this table, now i won't it to be possible to have duplicated entrys.
Is that possible with this table, or would i have to give it a column with autoincreasment or something ?
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi
if you're interested in what character sets and collation are or need to decide which one to use then have a look at the article i have posted recently on my website.
best wishes
cl...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi I'm trying to install a script for phparcadescript but I seem to be getting an error when importing the database and was hoping someone here could help. I cannot ask on the offical forums as I ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi, I hope this is the correct forum.
Does anyone know of a company that offers automatic offsite mySQL backup on a weekly basis? I often forget to download my backups from the server and woul...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I am new to mysql relational programming, and creating a tutorial site like pixel2life. I am trying to get the data from 4 tables 1st table is main tutorials table, 2nd is subcategory (subcat) tab...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Ok, I'm new to this.
My host has Mysql and Php already installed.
I'm trying to install and configure the Mysql client in my computer to connect and work with the server. I'm using 4.1.21 as...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello here,
I am trying to optimize a database query that uses the LIKE clause in the SELECT statement, and I discovered recently the the LIKE clause doesn't allow MySQL to use indexes, and this m...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
just a quickie from a newb. i'm making a site for a friend (property developer) and i'm wondering about repeating fields in one of my tables.
the property table has a column for number of bedr...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello all,
this is my first post regarding mysql although i'm a sortof regular in the php forums....
Allow me to try and explain my problem.
An item sells. A cron job will pick this up...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
Generally, I've been under the assumption that I should always use surrogate keys for all data, regardless if it has a natural key or not. However, this is starting to give me some trouble...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
If I were to store a monetary amount into a database using MySQL, what field woulld I use? The num(length) field?
Thanks!
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I would like to use transaction for certain function like deleting customer details (delete all the data associated with it. records from 10 tables need to be deleted. for e.g. if i delete...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I've got the following query which returns a search result, but I want to exclude results where 'intro' is a null value, ie where 'intro' is not null. What's the correct syntax for that ? Thanks i...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
PHP Code:
// See if relevant fields have been set.
$submitted = IsSet($_REQUEST['Submit']) ? TRUE : FALSE;
$user = I...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
The title of this post may not be optimal, but I wasn't sure what else to call it
I have 3 tables
upload_transactions,
uploaded_files,
and users
I'm allowing users to upload file...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I want to be able to select only the first letter of each row in my table.
I want to select only DISTINCT row so i would have as a result, an array of letters. For example, if i have...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello here,
I am pretty "primitive" to MySQL and I am trying to order a 2 column list output in the following way:
1. The keyword must be present in the 1st column OR in the 2nd colu...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I've never used stored procedures and need to understand what they are exactly. I want to know if a stored procedure can do this:
Looking at the picture above, is the stored procedure t...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi,
I need to filter out duplicates for every 30 seconds. say i have two duplicate records within the 30 seconds limit. I need to show up only one. If there are identical records but with a d...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I have 2 tables, payment and receive, i want to retrieve the balance for a user.
Code:
mysql> select * from payment;
+-----------+--------+---------+
| paymentid | userid | payment |...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello,
I have a database 'foo' on my local machine that I would like to upload to a server where my website is hosted. How can I do that?
P.S. I'm new to MySQL so excuse my silly question ...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
I'm trying to create a view in mySQL Query Browser. But when i create the view i get the following error,
"Definer is not fully qualified"
Here is the view itself,
Code:
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hi!
How can I get all records relating to last week from a table . I am using Mysql 3.0.x.
Kind Regards
...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
hi,
i need to write a MySQL query which updates two tables:
Code:
$query = "INSERT INTO `user_club_clubimage` (`club_image_id`, `name`) VALUES (NULL, '$name');
INSERT INTO 'us...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Hello, I have been running WAMP on my local server for sometime but I needed to upgrade so I downloaded the latest version, stopped WAMP and installed the new version. The Php is working ok but th...
[Tags: No tags defined yet] - Be the first to Tag this threadAdd TagsCancel
*Note: Tags must be comma (,) seperated. For example: boardtracker, forum search, search engine
Browse sub-categories 
