I am a Database Programmer, but in Access and SQL Server.
I have two questions:
I have access to the PHP myAdmin and can see that the database has six tables. I also have ftp access. W...
I have an existing table, webcommand. I want to add an uniqueness constraint to the commandname column.
I tried alter table webcommand add constraint unqiue 'commandname'. but it fails wit...
I need small clarification ,
Always i am using varchar (250) in my table for all varchar fields.
for example a TABLE Register
first_name varchar(250).
But i know the maximum length i w...
Hello,
I have a MySQL table with a column containing text (multiple words). I'm trying to SELECT rows from the table based on the number of words in the text column.
The cases are: exactly...
EE DBA Experts on MySQL:
I am a software developer and I have an application that I have written in VB.NET 2005 that uses MySQL version 5.0.45 in a Windows Development Environment that I am...
I'm working with a MySQL 5 db that uses 2 tables to store records - one records table that has a record ID for each submission and a subrecords table that contains name/value pairs for each of...
I am having a problem with some legacy code that won't work properly due to a mysql error
This code is used once a month to upload sales data on my dedicated server. Last month it worked fi...
I am trying to export mysql results from a php page to excel. I have been trying different code I have found online, but a consistent error I get is: Warning: Cannot modify header information ...
I've combined many different table views of MySQL database information resulting in a Public 'search' all locations application for site visitors and a Private 'manage my location data' for th...
Hi,
MySQL DATETIME is used to store DATE and TIME. But how can I compare only the DATE part?
Is it possible?
For example, table EMPLOYEE:
- Name: VARCHAR(25)
- Registered: DATETI...
hello. i have a form that posts results to a processing page and i need to insert an array into mysql from this page. however, i am having trouble with an array. code below.
th idea is say ...
Hi, I'm trying to sort the records in a table by using an 'up' and 'down' buttons (images).
Basically it should swap the position of the two records in the database:
example records A B C ...
Wondering if anyone can tell me how to do the following or at least point me in the right direction
Have a table containing stock data in pretty standard format (Code/Date/Value)
What i am l...
Hello Guys,
I want to write a MySQL stored procedure which returns OK message, if all went well.
I have to do quite a few data manipulations before starting my script. In the snippet belo...
Hi,
I am trying to install MSQL - I am in teh MySQL Administrator 1.2.12 and i am getting this error
I am using Windows XP on VMWare virtual machine
please help
thanks
Does anyone here know how to configure phpMyAdmin to work on a Mac OS X? I have tried so many times with different versions and I keep getting the same error message:
#2002 - The server is...
hi guys,
i have two tables in my MySQL database and I would like to merge them. They are almost similar in structure pero mas marami lang columns ung isa. Here the create table statement fo...
Does anyone know if it's possible to do a batch insert on MySQL 5 (as on SQL Server)? If so, how does one go about it? Thanks.
Hi, I just setup wamp and everything ran fine. I went into phpmyadmin and it gave me a warning that I should put a password up for mysql, otherwise people could just log right in, so I change...
Hi,
I'm planning to have MySQL instead of Access 2k3 as back-end.
I'll keep the Access-DB as front-end.
I have mainly 3 types of queries in Access. Would like to see how they look like a...
Im using Debian Stable (Woody), with MySQLversion 4.0.16 and I want to enable InnoDB tables.
I uncommented all the lines related to InnoDB in my-large.cnf, and saved it as etc/my.cnf. ...
Hi Experts,
I need to import some data in a MySql DB and I have problems importing decimal with a comma as separator.
E.G: if I need to import 1234,56 I will get 1234.00 in the db.
Any he...
I'd like to find the most efficient way to select the first row of a table, store the values of the columns, then delete the row.
Right now I am doing:
select * from err limit 1;
sto...
I have a mySQL db that i can create any table.
I have data in a .csv with fields: symbol, bid, ask, type, time, date
How can i create a table and load the data file into it with php?
I hav...
I have one table, 4 columns like this:
p1 enum('P1') default NULL,
p2 enum('P2') default NULL,
p3 enum('P3') default NULL,
p4 enum('P4') default NULL,
wich may be P1, and if i...
