2000 organizations, including eBay, Ericsson, and Lockheed Martin, now work smarter with Corporate Accounts. Save over 36%!

 

Having problems asking a question? Have a general question about Experts Exchange? Let us know!

 
Top MySQL Server Solutions: 126 - 150 of 608
 
Easiest way to copy a database and a table in MySQL
I have a database D1 with several tables including table T1 Using MySQL / MySQL Administrator: What is the easiest way for me to duplicate database D1 and all tables (including data) (i.e....
php validation form
I am working on a php class and I cannot figure out what is going wrong with this code. I have posted the validate.php code below.  I am getting the error Warning: mysql_num_rows(): supp...
MySQL Select Into
Trying to get the following query to work in MySQL 5.1 I am trying to create a table (`hcad0911`.`TA Other Table`) that has the HCAD_NUM populated from `ta hcad_nums`.`ta from 0910 shapefil...
import mysql file with command line client
I have a mysql dump which contains a create table statement all the data.  How can I import it into mysql Command line Client and then view the data.  The basic commands would be great.  the f...
Insert MySQL Datetime column value in MySQL Table in VB.NET
Hello, I am using Vb.NET and MySQL 5.1. I used odbc driver to connect with. My questions is, how can I insert value in Datetime field on MySQL? Vj
Use a function in select statement
Not sure if function is what I want, but basically I am creating a view that will do lookups on a lot of tables. In one instance, a value stored in the same column will determine which of two ...
mysql table query
hello, i have table name questions. questions question_id,title,expiration_type,expiration_date 1,question1,no,0000-00-00 2,question2,no,0000-00-00 3,question3,yes,2009-10-25 4,qu...
When to use a non-normalized structure
I have been tasked with creating table relationships in a test-item bank that will warehouse both questions and answers to multiple test and survey instruments. We will be using an MS Access f...
MySQL Query - Error
Hello Experts, I am trying to run this query (see attached code); however, when I run the code, I receive this message : "You have an error in your SQL syntax; check the manual that corr...
update query problem
Can anyone see what is wrong with the query below? I get:  MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server...
split line in mysql field
hi what i is happening, is that all the text is appearing on 1 line from data from a field in a db. rather than use a textarea which i do not like, is there a way to set a field in mysql so...
Cloning mysql Database
For performance and security reasons i want to create a clone of a mysql db I have setup 3 servers with almost exactly same configs. How can I setup a cloning so that once data is updated ...
Why are myql threads stuck in "connect" "reading from net" state?
Hi, I have a mysql server which my webserver connects to via tcp/ip, and all the threads are stuck in the connect stare as unauthenticated users. The server was running fine before and I'm ...
sql server distinct row display
I have the following data Company_id   Company_name  companyResponse  Comments   1                             abc            Awaiting                        Yes   1                    ...
A question about translating an ER diagram into tables
Hey,        I just had a quick question about translating ER diagrams into tables, my question is, if I have an entity that is related to another entity in the ER diagram, do I need to make...
select tables via join or where clause.
i am writing two type of query for inner joins. first select * from table1 t1 join table2 t2 on t1.user_id=t2.user_id and t1.course_id='3' and t1.status='1' and t2.status='1' second ...
Query "in" statement problem
Following on from http://www.experts-exchange.com/Database/MySQL/Q_24753399.html The query below works but it doesn't give the correct result for "BestBowling" and "RowCount". All the other...
How to install mysql on windows server?
How to install mysql on windows server? Server:2003 Any step by step guide?
Error when adding a where clause
I added "and $projUWFunded = Yes" to my query but now I am getting the error DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your My...
mysql now() to 0000-00-00 00:00:00.000000
Is it possible to record the time in a more precise format? Currently I can only got Mysql to record the time as 0000-00-00 00:00:00, but need it more precise. Ive read using microsecond ma...
MySQL stored procedure
I need to create a stored procedure for MySQL 5.1 where I can consecutively add 1 to the id of each datarecord. I.E. from data below 50, 1, 'Links', '', 'Links' 51, 1, 'Sample Menus', '', 'M...
MySQL retrieve rows matching ALL values specified for IN statement
I have one table t1. There are two columns in it - uid and cid, both are integers. If I use the following query "select uid from  t1 where cid IN (1,5,7)" then it gives me all records...
simple query help
I know I'm missing something but can someone help me fix the query below. Thanks
Create view need help
Hi All, I want to create view from a table where the structure of table is as below: Table: relavance_details: relevance_id     relavance_field          relevance_value --------------------...
MySQL Select data from one table that does not have a corresponding value in second table
Lets say that I have 2 tables: Table 1: person Important Column: person_id Table 2: person_data Columns: data_id, person_id There are other data columns, but they really don't matte...