is there any way i can change the min word length in a mysql query?
I might not have access to my msql ini files so, is there any way to changee this in the query?
cheers
...
[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 a table with a primary varchar key and some others columns.
I want to add a new column at the begining of the table which is Numeric auto_increment. When I add this new column via phpMyAdm...
[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
Hiya,
I've got a table of stats that is tracking the links as someone navigates an intranet site. The table contains a record for each click, and the type of "click" it is (image cli...
[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 tried using the above command to get rid of a column (y) (from table (x) because the column name was not unique).
This didn't work so i just dropped the table and created another. If my tabl...
[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
Sadly, this isn't one that can be answered simply by changing ORDER BY field DESC to ORDER BY field ASC. What I need to do is to be able to display a list of items in an arbitrary order that can b...
[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 a table with 80,000 records in it, each with a field named 'referral_id'.
I need a way to find which number is the mode in the field 'referral_id', as well as the 2nd mode (2nd most recurri...
[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
In my database, Ive used auto increment for IDs:-
create table member (ID INT(4) NOT NULL AUTO_INCREMENT,
etc;
When you insert values do you leave this empty, eg:-
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
Hello everyone,
I am trying to pull out the data from teh server with the dvd's names that start from 0 or 2 (both numbers):
SELECT * FROM dvd_product WHERE product_publish = 'Y' and produc...
[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
How would I go about comparing values in a CSV file to a table in the database, and then removing any rows where that value (an email address) matches? Is this something I can do in phpMySQL or w...
[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!
Code:
Tbl1
id
name
Tbl1 ROWS
id name
1 name1
2 name2
3 name3
Tbl2
id
tbl1_id
Tbl2 ROWS
id tbl1_id
1 1
2 1
3 2
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
Level of experience in SQL or MySQL = novice;
I am trying to create a study notes database in MySQL and populate it with records (I currently have about 40,000 questions text format and they...
[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,
No matter how many fields I want to retrieve from the table I always use "Select * FROM Table" instead of "Select field1,field2 FROM Table".
Are there any disadv...
[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,
To simplify the problem, i have 3 tables...
shop_products - stores the shop product information
shop_products_seo - stores the shop product seo data e.g. page data, redirect rules et...
[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
Mysql Books and Programming Reference Materials
Check these pages they have lot of Mysql. I have download some of it is cool. Mysql .NET books and Oracle books Books I think one of the best co...
[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.
a blind website developer.
using the jaws screen reader from http://www.freedomscientific.com
now, wanting to develop a database for my website, using my sql, and php.
the project is a...
[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 learn Joins in MySQL by practising creating portfolio in my database.
So far I figured out a simple join of a table called "projects" and table called "clients"...
[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 there, I need help with a query.
I’m only an amateur and I was hopping to get some help from some of you.
I’ve got a table with 2 columns job_id and job_name (they are article categori...
[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 people
I am using PHP to invoke mysql_query to my database.
In most cases everything works fine and the query executes perfectly.
Sometimes, I will get a burst of errors and the query w...
[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'm only going to store the path to an image in my db, do i need to have a MIME type field?
...
[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, this is my first post here at SitePoint
Found a few useful threads, which seem to have got me in what I feel is the right direction but still having some troubles with ordering a search q...
[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 was trying to create a table in my database, but it kept coming up with syntax errors, and that I should check the manual.
I have used many different data types including varchar, char, 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
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
Browse sub-categories 
