I've built several web sites where the user could search the MySQL database, but never one as complex as this, and I could use a little insight from someone who's been there.
This is a sear...
I have a cent os machine with MYSQL when I login using putty and using the command mysql -u root -p after entering the root password I am able to login and see and use all the databases but th...
I have three tables (fields): lists (list, list_id), users (user_id, username), and friends (fan_id, star_id)
I want to SELECT list, list_id, and username from these tables in the following...
Hi guys hope you are all well.
I hope this is not a stupid question.
I want to quickly popluate a table with 100s of rows, but I dont want to keep having to modify an existing collection of ...
Hi guys, ive got a problem using the mysql now() function.
Im using it as a way to get uniquely inserted rows.
Here is what im doing...
insert into tooltip_ttp set name_ttp = concat('hith...
I am working on a project that will require text to be stored in multiple languages:
$language_1 = array("English", "French", "German", "Portuguese", "Spanish", "Swahili");
$language_2 = arr...
Hi Experts.
On PC MySQL is running (server), In VB I open it with :
db_name = "MyDb"
db_server = "LOCALHOST"
db_port = "3306"
db_user = "root"
db_pass = "admin"
This ...
we just got a new SQL server. this is a blessing for the admins who can now get to chop up drives with no down time. due to constraint we have only one chance at this cause we are short on tim...
Hi,
I inserted a data into the joomla fireborad db.Now th datas looks funny.& strange.
For Example some original text was:
> Sáb. 27/9 última Feria de Boliche OM .26 marzo y pagola.
> ...
I want to use MySQL for desktop application.
I want to use it with my vb.net restaurant software
I do not know how to install/deploy/restore wihout instaling mysql on client machine
An...
I have an interesting question. I have log table for orders in an ecommerce database. This table basically holds all status changes to the order by inserting a new record.
For example, if a...
Hi, im using Ruby on Rails and have a MySQL database backend. I have a search function that can take multiple variables as its search string (Up to 7 at the moment) The search function can sea...
I'm trying to build the array down below and am unsure of how to write the query to accomplish it.
myTable
---------------------------
item_id | oa_id | a_id
-------------------------...
i have an xml file which contains the book details. I want to store it in mysql database. How to do so?
Hi,
I would like to have a trigger execute a shell command (like "php myscript.php") when some record is modified.
I am using the below query to COUNT um.word_id values. There is a second field in the um table, synset_id, and I wish to count unique word_id/synset_id pairs also. For example, if the um table...
Hi,
I have a MySQL table as shown below and I need a query to extract all in the information from the table in a certain order, I would like the records sorted based on cat column and then...
I'm getting the following error with my code below
Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version fo...
Please correct following Stored Procedure. I am passing two input parameters viz. @Date1 and @Date2. There is a problem in syntax but I am not able to figure it out.
hello,
I am getting this error when I try to execute this command
SELECT * FROM Groups WHERE domain_id=1 group by id
#1 - Can't create/write to file '/var/lib/mysql/#sql_5960_0.MYI' (Errc...
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------
Attempted to load a 64-bit assembly on a 32-bit platform. Use Refle...
I have a query where you only specify the month value, and then you'll get a table-like output where the user can see for the specified month, what day of the week had the most rents (with a '...
I have 2 mysql start in same server.
one to port 3306 and socket /tmp/mysql.sock
one to port 3308 and socket /tmp/mysql2.sock
I want can connect with script shell to mysql1 or mysql2
h...
Please can you let me know how to clean up the old data in a table before I can insert new data? Do you have a query that I can use?
TIA.
V.
How can I be able to truncate a large table instead of doing a delete on the data? Pls do you have a sample query?
TIA.
V.
